示例#1
0
        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, "中级权限", "");
            }
        }
示例#2
0
 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, "中级权限", "");
     }
 }