//删除监测人 private void delObj_Click(object sender, EventArgs e) { delPwd DP = new delPwd(); string sql = ""; string getName = sqlDataView[0, sqlDataView.CurrentCell.RowIndex].Value.ToString(); string getSFZ = sqlDataView[7, sqlDataView.CurrentCell.RowIndex].Value.ToString(); DP.ShowDialog(); //执行删除 if (DP.rightYH == "1") { DialogResult res = MessageBox.Show("确定删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (DialogResult.Yes == res) { sql = "update JCRJBXX set JCRdellogo='1' where JCRsfz='" + getSFZ + "' "; string re = sqlMethod(sql, 2); if (re != "-1") { MessageBox.Show("删除成功", "提示"); singleQuery(); } else { MessageBox.Show("删除失败", "提示"); } } } }
//修改对象信息按钮 private void changeObjInfo_Click(object sender, EventArgs e) { DetailForm DI = new DetailForm(); string sqlID = ""; //身份证号 sqlID = sqlDataView[7, sqlDataView.CurrentCell.RowIndex].Value.ToString(); SFZid = sqlID; delPwd DP = new delPwd(); if (Login.limit == "2") { MessageBox.Show("对不起,您没有权限访问", "提示"); } else { DP.ShowDialog(); if (DP.rightYH == "1") { #region 将详细信息显示出来 //姓名 sql = "select JCRname from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetName = getInfo(sql); //性别 sql = "select JCRsex from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetSex = getInfo(sql); //籍贯 sql = "select JCRJG from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetJG = getInfo(sql); //职业 sql = "select JCRzy from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetZY = getInfo(sql); //民族 sql = "select JCRnation from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetMZ = getInfo(sql); //经济状况 sql = "select JCRjjzk from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetJJZK = getInfo(sql); //列控单位 sql = "select JCRlkdw from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetLKDW = getInfo(sql); //身份证号 DI.GetSFZ = sqlID; //政治面貌 sql = "select JCRpolity from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetZZMM = getInfo(sql); //分类 sql = "select JCRfl from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetFL = getInfo(sql); //列控级别 sql = "select JCRlkjb from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetLKJB = getInfo(sql); //毕业院校 sql = "select JCRbyyx from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetBYYX = getInfo(sql); //户籍所在地 sql = "select JCRhjszd from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetHJSZD = getInfo(sql); //现居住地 sql = "select JCRxjzd from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetXJZD = getInfo(sql); //工作单位 sql = "select JCRgzdw from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetGZDW = getInfo(sql); //关系人员 sql = "select JCRgxry from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetGXRY = getInfo(sql); //个人简历 sql = "select JCRgrjl from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetGRJL = getInfo(sql); //固定电话 sql = "select JCRgddh from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetGDDH = getInfo(sql); //备注 sql = "select JCRbz from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetBZ = getInfo(sql); //移动电话 sql = "select JCRyddh from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetYDDH = getInfo(sql); //电子邮件 sql = "select JCRdzyj from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetDZYJ = getInfo(sql); //QQ sql = "select JCRqq from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetQQ = getInfo(sql); //微信 sql = "select JCRwx from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetWX = getInfo(sql); #endregion See_Change = "2"; DI.Show(); } } }
//删除附件 private void DelThisFJ_Click(object sender, EventArgs e) { delPwd DP = new delPwd(); DP.ShowDialog(); if (DP.rightYH != "1") { return; } string delJCRsfz = dataGridWD[1, dataGridWD.CurrentCell.RowIndex].Value.ToString(); string delName = dataGridWD[2, dataGridWD.CurrentCell.RowIndex].Value.ToString(); if (FJflag == "文档") { string sql = "update FJWD set WDdellogo='1' where JCRsfz='" + delJCRsfz + "' and WDname='" + delName + "'"; string re = sqlMethod(sql, 2); if (re == "-1") { MessageBox.Show("删除失败", "提示"); return; } else { MessageBox.Show("删除成功", "提示"); } string sqlCount = "select WDCount from JCRFJ where JCRsfz='" + getSFZ + "'"; string sqlTable = "select JCRname as 姓名,JCRsfz as 身份证号, WDname as 文件名,WDAddTime as 添加时间 from FJWD where JCRsfz='" + getSFZ + "' and WDdellogo='0' "; if (queryMethod(sqlCount, sqlTable) == false) { MessageBox.Show("已无更多附件显示", "提示"); return; } } if (FJflag == "照片") { string sql = "update FJZP set ZPdellogo='1' where JCRsfz='" + delJCRsfz + "' and ZPname='" + delName + "'"; string re = sqlMethod(sql, 2); if (re == "-1") { MessageBox.Show("删除失败", "提示"); return; } else { MessageBox.Show("删除成功", "提示"); } string sqlCount = "select ZPCount from JCRFJ where JCRsfz='" + getSFZ + "'"; string sqlTable = "select JCRname as 姓名,JCRsfz as 身份证号, ZPname as 文件名,ZPAddTime as 添加时间 from FJZP where JCRsfz='" + getSFZ + "' and ZPdellogo='0' "; if (queryMethod(sqlCount, sqlTable) == false) { MessageBox.Show("已无更多附件显示", "提示"); return; } } if (FJflag == "视频") { string sql = "update FJSP set SPdellogo='1' where JCRsfz='" + delJCRsfz + "' and SPname='" + delName + "'"; string re = sqlMethod(sql, 2); if (re == "-1") { MessageBox.Show("删除失败", "提示"); return; } else { MessageBox.Show("删除成功", "提示"); } string sqlCount = "select SPCount from JCRFJ where JCRsfz='" + getSFZ + "'"; string sqlTable = "select JCRname as 姓名,JCRsfz as 身份证号, SPname as 文件名,SPAddTime as 添加时间 from FJSP where JCRsfz='" + getSFZ + "' and SPdellogo='0' "; if (queryMethod(sqlCount, sqlTable) == false) { MessageBox.Show("已无更多附件显示", "提示"); return; } } if (FJflag == "音频") { string sql = "update FJYY set YYdellogo='1' where JCRsfz='" + delJCRsfz + "' and YYname='" + delName + "'"; string re = sqlMethod(sql, 2); if (re == "-1") { MessageBox.Show("删除失败", "提示"); return; } else { MessageBox.Show("删除成功", "提示"); } string sqlCount = "select YYCount from JCRFJ where JCRsfz='" + getSFZ + "'"; string sqlTable = "select JCRname as 姓名,JCRsfz as 身份证号, YYname as 文件名,YYAddTime as 添加时间 from FJYY where JCRsfz='" + getSFZ + "' and YYdellogo='0' "; if (queryMethod(sqlCount, sqlTable) == false) { MessageBox.Show("已无更多附件显示", "提示"); return; } } }