Exemplo n.º 1
0
 private void Button_Delete_Click(object sender, EventArgs e)
 {
     Class_State.Editor_State = "Delete";
     if (Get_RowClick == -1)
     {
         MessageBox.Show("请选择您要删除联系人!", "Tips", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else
     {
         if (MessageBox.Show("您即将删除联系人" + Class_State.Get_Name + ",删除请点击确认!", "Tips", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
         {
             //AND Phone = '" + Class_State.Get_Phone + "'
             string SQL_Delete       = "Delete * FROM Archive_Table WHERE Real_Name = '" + Class_State.Get_Name + "'  AND Archive_Type = '" + Class_State.Windows_State + "' ";
             string SQL_Delete_Visit = "Delete * FROM Visit_Table WHERE  Real_Name = '" + Class_State.Get_Name + "'  AND  Visit_Type = '" + Class_State.Windows_State + "' ";
             if (Class_State.Get_Phone != "")
             {
                 SQL_Delete       += " AND Phone = '" + Class_State.Get_Phone + "'";
                 SQL_Delete_Visit += " AND Phone = '" + Class_State.Get_Phone + "'";
             }
             Class_SQL_Deal.Delete_SQL(SQL_Delete_Visit);
             Class_SQL_Deal.Delete_SQL(SQL_Delete);
             Button_Search_Click(null, null);
         }
     }
 }