//删除监测人
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;
}
}
}
