private void button6_Click(object sender, EventArgs e)
{
if (textBox3.Text == "")
{
return;
}
SqliHelper.CheckImporlistview(listView4, "消息记录", " where QQID like '" + textBox3.Text + "' ");
}
private void toolStripMenuItem4_Click(object sender, EventArgs e)
{
if (SqliHelper.CheckDataExsit("中级权限", "QQID", slectitem) == true)
{
SqliHelper.DeleteData("中级权限", "QQID", "QQID like'" + slectitem + "'");
SqliHelper.CheckImporlistview(this.listView3, "中级权限", "");
MessageBox.Show("删除成功.");
}
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (SqliHelper.CheckDataExsit("授权群号", "GroupID", textBox1.Text) == true)
{
SqliHelper.DeleteData("授权群号", "GroupID", "GroupID like'" + slectitem + "'");
SqliHelper.CheckImporlistview(this.listView1, "授权群号", "");
MessageBox.Show("删除成功.");
}
}
private void toolStripMenuItem3_Click(object sender, EventArgs e)
{
Object myValue = Interaction.InputBox("是否要修改中级权限QQ号:" + slectitem + "?", "中级权限", "");
Regex regex = new Regex("^[0-9]+$");
if (Convert.ToString(myValue) != "" && regex.IsMatch(Convert.ToString(myValue)) == true)
{
SqliHelper.UpdateData("中级权限", new string[] { "QQID like'" + slectitem + "'" }, "QQID='" + Convert.ToString(myValue) + "'");
SqliHelper.CheckImporlistview(this.listView2, "中级权限", "");
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox2.Text == "")
{
return;
}
if (SqliHelper.CheckDataExsit("中级权限", "QQID", textBox2.Text) == false)
{
SqliHelper.InsertData("中级权限", new string[] { "QQID", "time" }, new string[] { textBox2.Text, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture) });
SqliHelper.CheckImporlistview(this.listView3, "中级权限", "");
MessageBox.Show("添加成功.");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
return;
}
if (SqliHelper.CheckDataExsit("授权群号", "GroupID", textBox1.Text) == true)
{
SqliHelper.DeleteData("授权群号", "GroupID", "QQID like'" + textBox1.Text + "'");
SqliHelper.CheckImporlistview(this.listView1, "授权群号", "");
MessageBox.Show("删除成功.");
}
}
private void button7_Click(object sender, EventArgs e)
{
if (textBox4.Text == "" || textBox5.Text == "")
{
return;
}
if (SqliHelper.CheckDataExsit("主人信息", "FeedbackGroup", textBox4.Text) == false)
{
if (SqliHelper.CheckDataExsit("主人信息", "MasterQQ", textBox5.Text) == false)
{
SqliHelper.ClearTable("主人信息");
SqliHelper.InsertData("主人信息", new string[] { "FeedbackGroup", "MasterQQ" }, new string[] { textBox4.Text, textBox5.Text });
MessageBox.Show("添加成功.");
}
else
{
SqliHelper.UpdateData("主人信息", new string[] { "MasterQQ like'" + textBox5.Text + "'" }, "FeedbackGroup='" + textBox4.Text + "'");
MessageBox.Show("修改成功.");
}
}
else
{
if (SqliHelper.CheckDataExsit("主人信息", "MasterQQ", textBox5.Text) == false)
{
SqliHelper.UpdateData("主人信息", new string[] { "FeedbackGroup like'%" + textBox4.Text + "%''" }, "MasterQQ='" + textBox5.Text + "'");
MessageBox.Show("修改成功.");
}
}
PInvoke.FeedbackGroup = long.Parse(textBox4.Text);
PInvoke.MasterQQ = textBox5.Text;
if (SqliHelper.CheckDataExsit("授权群号", "GroupID", textBox4.Text) == false)
{
SqliHelper.InsertData("授权群号", new string[] { "GroupID", "time" }, new string[] { textBox4.Text, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture) });
SqliHelper.CheckImporlistview(this.listView1, "授权群号", "");
}
if (SqliHelper.CheckDataExsit("高级权限", "QQID", textBox5.Text) == false)
{
SqliHelper.InsertData("高级权限", new string[] { "QQID", "time" }, new string[] { textBox5.Text, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture) });
SqliHelper.CheckImporlistview(this.listView2, "高级权限", "");
}
if (SqliHelper.CheckDataExsit("中级权限", "QQID", textBox5.Text) == false)
{
SqliHelper.InsertData("中级权限", new string[] { "QQID", "time" }, new string[] { textBox2.Text, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture) });
SqliHelper.CheckImporlistview(this.listView3, "中级权限", "");
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.listView1.Items.Clear();
this.listView1.GridLines = true;
this.listView1.View = View.Details;
this.listView1.FullRowSelect = true;
this.listView1.Columns.Add("ID", 30, HorizontalAlignment.Center);
this.listView1.Columns.Add("群号", listView1.Width - 30 - 5, HorizontalAlignment.Center);
this.listView1.Items.Clear();
this.listView2.GridLines = true;
this.listView2.View = View.Details;
this.listView2.FullRowSelect = true;
this.listView2.Columns.Add("ID", 30, HorizontalAlignment.Center);
this.listView2.Columns.Add("高级权限QQ号", listView2.Width - 30 - 5, HorizontalAlignment.Center);
this.listView3.Items.Clear();
this.listView3.GridLines = true;
this.listView3.View = View.Details;
this.listView3.FullRowSelect = true;
this.listView3.Columns.Add("ID", 30, HorizontalAlignment.Center);
this.listView3.Columns.Add("中级权限QQ号", listView3.Width - 30 - 5, HorizontalAlignment.Center);
this.listView4.Items.Clear();
this.listView4.GridLines = true;
this.listView4.View = View.Details;
this.listView4.FullRowSelect = true;
this.listView4.Columns.Add("ID", 30, HorizontalAlignment.Center);
this.listView4.Columns.Add("群号", 60, HorizontalAlignment.Center);
this.listView4.Columns.Add("QQ号", 60, HorizontalAlignment.Center);
this.listView4.Columns.Add("MessageReq", 60, HorizontalAlignment.Center);
this.listView4.Columns.Add("MessageRandom", 80, HorizontalAlignment.Center);
this.listView4.Columns.Add("时间", 150, HorizontalAlignment.Center);
this.listView4.Columns.Add("消息", 250, HorizontalAlignment.Left);
SqliHelper.CheckImporlistview(this.listView1, "授权群号", "");
SqliHelper.CheckImporlistview(this.listView2, "高级权限", "");
SqliHelper.CheckImporlistview(this.listView3, "中级权限", "");
List <List <string> > MasterInfo = SqliHelper.ReadData("主人信息", new string[] { "FeedbackGroup", "MasterQQ", }, "", "FeedbackGroup like '%%'");
if (MasterInfo.Count > 0)
{
textBox4.Text = MasterInfo[0][0];
textBox5.Text = MasterInfo[0][1];
}
new Thread(() =>
{
while (true)
{
List <string> status = CpuMemoryCapacity.GetUsage();
try
{
label21.Invoke((MethodInvoker)(() => label21.Text = string.Join(" ", status)));
}
catch { }
Thread.Sleep(2000);
}
}).Start();
}
