前一段时间，突发奇想，开发了一个聊天机器人，本来是想做helpdesk的一个平台。support部门的人先教它，然后有问题的人可以像它请教。
教的越多它越聪明。
但是公司一直没有机器来放，只好自己搞着玩一玩。
作为公司用，只有出现解决方案才有作用。也就是当你问它比较专业的问题时，它会告诉你如何解决，解决方案1，2，3并且要出现图解的内容。所以，最好查找到相应的内容，机器人给你一个网页地址，上面包含你要查找的内容。
好了，不多说了，把开发步骤介绍一下。
（一）分析流程，需求，建立数据库。
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sogo_link]’) AND type in (N’U’))
BEGIN
CREATE TABLE [dbo].[sogo_link](
[id] [int] IDENTITY(1,1) NOT NULL,
[sogo_link_url] [nvarchar](100) NULL,
[sogo_link_font] [nvarchar](100) NULL,
[sogo_link_login] [nvarchar](100) NULL,
[sogo_link_alt] [nvarchar](100) NULL,
[sogo_link_logo_or_txt] [int] NULL,
[sogo_link_yes_no] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[robot]’) AND type in (N’U’))
BEGIN
CREATE TABLE [dbo].[robot](
[ID] [int] IDENTITY(1,1) NOT NULL,
[title] [nvarchar](50) NULL,
[robot_content] [nvarchar](4000) NULL,
[BigClassName] [nvarchar](50) NULL,
[SmallClassName] [nvarchar](50) NULL,
[kin_demo] [nvarchar](4000) NULL,
[picUrl] [nvarchar](255) NULL,
[imagenum] [int] NULL,
[firstImageName] [nvarchar](50) NULL,
[robot_user] [nvarchar](50) NULL,
[infotime] [datetime] NULL CONSTRAINT [DF_robot_infotime] DEFAULT (getdate()),
[hits] [int] NULL,
[ok] [bit] NULL,
[tuijian] [bit] NULL,
[web_yes_no] [bit] NOT NULL,
CONSTRAINT [PK_robot] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Admin]’) AND type in (N’U’))
BEGIN
CREATE TABLE [dbo].[Admin](
[ID] [int] IDENTITY(1,1) NOT NULL,
[admin] [nvarchar](50) NULL,
[password] [nvarchar](50) NULL,
[aleave] [nvarchar](50) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bigClass]’) AND type in (N’U’))
BEGIN
CREATE TABLE [dbo].[bigClass](
[BigClassID] [int] NOT NULL,
[BigClassName] [nvarchar](50) NULL,
[Admin] [nvarchar](100) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[shop_pinglun]’) AND type in (N’U’))
BEGIN
CREATE TABLE [dbo].[shop_pinglun](
[pinglunid] [int] NOT NULL,
[ID] [int] NULL,
[pinglunname] [nvarchar](50) NULL,
[pinglundate] [datetime] NULL,
[pingluncontent] [nvarchar](max) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SmallClass]’) AND type in (N’U’))
BEGIN
CREATE TABLE [dbo].[SmallClass](
[SmallClassID] [int] NOT NULL,
[SmallClassName] [nvarchar](50) NULL,
[BigClassName] [nvarchar](50) NULL,
[Admin] [nvarchar](100) NULL
) ON [PRIMARY]
END
（二）建立解决方案网页。
（三）建立web版机器人
（四）申请小I机器人，下载原程序进行修改。
using System;
using System.IO;
using System.Drawing;
using System.Configuration;
using System.Runtime.Serialization;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.Xml.Serialization;
using System.Text;
using System.Runtime.Serialization.Formatters.Binary;
using System.Threading;
using Incesoft.BotPlatform.SDK;
using Incesoft.BotPlatform.SDK.Interface;
namespace BotPlatformConsoleServer
{
public class MyRobot
{
public string address;
public int port;
public string user;
public string password;
static void Main(string[] args)
{
MyRobot me = new MyRobot();
me.address = "msnbot.incesoft.com";
me.port = 6602;
me.user = "SP092231";
me.password = "******";
IRobotServer server = RobotServerFactory.Instance.createRobotServer(me.address, me.port);
server.addRobotHandler(new MyHandler(server));
server.addConnectionListener(new MyListener());
try
{
server.login(me.user, me.password, 300000);
server.requestContactList(haigangdeng@126.com);
}
catch (RobotException e)
{
Console.Out.WriteLine("Failed to connect :" + e.Message);
}
}
}
class MyHandler : IRobotHandler
{
public MyHandler(IRobotServer server)
{
this.server = server;
}
private IRobotServer server;
private Random rdm = new Random();
public System.String commandList = "Hi，你好，我是helpdesk小M。r" +
"如果你有************问题，可以问我。r" +
"也许我能帮你解答。";
public System.String commandListEnt = "*****************************************r" +
"** BOTPLATFORM SDK ENTERPRISE ONLY COMMAND LIST **r" +
"** Only use the following commands after upgraded your sp account **r" +
"
*****************************************r" +
" file —— test file transfer.r" +
" bg ——– test background sharing.r" +
" ink ——- test send ink.r" +
" wink —— test send wink.r" +
" voice —– test send voiceclip.r" +
" webcam —- test send webcamr" +
" cs <account> ——– test create session.r" +
" pu <account> —— test push offline message.r" +
" iv <account> ——– test invite user.r" +
" ent ——— print this command list.";
public virtual void sessionOpened(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: sessionOpened");
try
{
switch(session.OpenMode)
{
case SessionOpenMode.OPEN_MODE_CONV_OPEN:
session.send(commandList);
break;
case SessionOpenMode.OPEN_MODE_ROBOT:
session.send("You have an alert message: blablabla");
break;
default:
break;
}
}
catch (RobotException e)
{
util.consoleOut(e.ToString());
}
}
public virtual void sessionClosed(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: sessionClosed");
}
public virtual void messageReceived(IRobotSession session, IRobotMessage message)
{
System.Console.Out.WriteLine("EVENT: messageReceived");
try
{
System.String command = message.String;
IRobotMessage msg = session.createMessage();
if ("+".ToString().Equals(command[0].ToString()))
{
if (command.IndexOf(‘|’) < 0)
{
session.send("问题和答案要用“|”分开吆");
}
else
{
string wenti = command.Substring(1, (command.IndexOf(‘|’) – 1));
string daan = command.Substring(command.IndexOf(‘|’) + 1);
string connectionstrings = "server=IP*****;UID=robot;PWD=******;DataBase=robot";
SqlConnection connection = new SqlConnection(connectionstrings);
string sqlxuexi = "insert into robot (title,robot_content,web_yes_no) values (" + "’" + wenti + "’," + "’" + daan + "’," + 0 + ")";
SqlCommand commxuexi = new SqlCommand(sqlxuexi,connection);
connection.Open();
commxuexi.ExecuteNonQuery();
connection.Close();
session.send("嗯，我记住了，谢谢你。");
}
}
else if ("help".ToUpper().Equals(command.ToUpper()) || "?".ToUpper().Equals(command.ToUpper()))
{
session.send(commandList);
}
else if ("nudge".ToUpper().Equals(command.ToUpper()))
{
session.sendNudge();
}
else if ("bye".ToUpper().Equals(command.ToUpper()))
{
session.cl
ose();
}
else
{
string connectionstrings = "server=IP******;UID=robot;PWD=******;DataBase=robot";
SqlConnection connection = new SqlConnection(connectionstrings);
string sqlcontent = "select * from robot where title like" + "’%" + command.ToString() + "%’";
SqlDataAdapter myad = new SqlDataAdapter(sqlcontent, connection);
connection.Open();
DataSet myds = new DataSet();
myad.Fill(myds,"robot");
if (myds.Tables["robot"].Rows.Count > 0)
{
int i = 0;
while (i < myds.Tables["robot"].Rows.Count)
{
int f = i + 1;
if (myds.Tables["robot"].Rows[i]["web_yes_no"].GetHashCode() == 0)
{
session.send(myds.Tables["robot"].Rows[i]["robot_content"].ToString());
}
else
{
session.send("解决方案（" + f +"）n" + "http://www.xxxxx.com/robot/onews.asp?id=" + myds.Tables["robot"].Rows[i]["ID"].ToString());
}
i = i + 1;
}
}
else
{
session.send("对不起，我还不知道这个问题的答案，如果你知道你能告诉我吗？用“+问题|答案”的方式告诉我，我就能记住了。");
}
connection.Close();
}
}
catch (RobotException e)
{
util.consoleOut(e.ToString());
}
}
public virtual void nudgeReceived(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: nudgeReceived");
}
public virtual void activityAccepted(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: activityAccepted");
}
public virtual void activityRejected(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: activityRejected");
}
public virtual void userAdd(String robot, String user)
{
System.Console.Out.WriteLine("EVENT: userAdd");
}
public virtual void userRemove(String robot, String user)
{
System.Console.Out.WriteLine("EVENT: userRemove");
}
public virtual void exceptionCaught(IRobotSession session, System.Exception cause)
{
System.Console.Out.WriteLine("SERVER ERROR: " + cause.Message);
}
public virtual void activityClosed(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: activityClosed");
}
public virtual void fileAccepted(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: fileAccepted");
}
public virtual void fileRejected(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: fileRejected");
}
public virtual void fileTransferEnded(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: fileTransferEnded");
}
public virtu
al void backgroundAccepted(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: backgroundAccepted");
}
public virtual void backgroundRejected(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: backgroundRejected");
}
public virtual void backgroundTransferEnded(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: backgroundTransferEnded");
}
public virtual void webcamAccepted(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: webcamAccepted");
}
public virtual void webcamRejected(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: webcamRejected");
}
public virtual void activityLoaded(IRobotSession session)
{
System.Console.Out.WriteLine("EVENT: activityLoaded");
}
public virtual void activityReceived(IRobotSession session, System.String data)
{
System.Console.Out.WriteLine("EVENT: activityReceived:" + data);
}
public virtual void userJoined(IRobotSession session, IRobotUser user)
{
System.Console.Out.WriteLine("EVENT: userJoined : " + user);
}
public virtual void userLeft(IRobotSession session, IRobotUser user)
{
System.Console.Out.WriteLine("EVENT: userLeft :" + user);
}
public virtual void userUpdated(IRobotUser user)
{
System.Console.Out.WriteLine("EVENT: userUpdated (" + user.ID +","+user.Status+","+user.FriendlyName+ ")");
}
public virtual void personalMessageUpdated(System.String robot, System.String user, System.String personalMessage)
{
System.Console.Out.WriteLine("EVENT: personalMessageUpdated (" + robot + ", " + user + ", " + personalMessage + ")");
}
public virtual void contactListReceived(System.String robot, System.Collections.ArrayList contactList)
{
System.Console.Out.WriteLine("EVENT: contactListRecieved ");
for (int i=0; i<contactList.Count; i++)
{
IRobotUser user = (IRobotUser)contactList[i];
System.Console.Out.WriteLine("User "+i+": "+user.ID);
}
}
}
class MyListener : IRobotConnectionListener
{
public void serverConnected(IRobotServer server)
{
Console.Out.WriteLine("Server connected.");
}
public void serverReconnected(IRobotServer server)
{
Console.Out.WriteLine("Server reconnected.");
}
public void serverDisconnected(IRobotServer server)
{
Console.Out.WriteLine("Server disconnected.");
}
public void serverLoggedIn(IRobotServer sever)
{
Console.Out.WriteLine("Server logged in.");
}
}
}