/// <summary> /// 给detailform赋值 /// </summary> private void fillAssignment(string judge) { DetailForm DI = new DetailForm(); string sqlID = ""; //身份证号 sqlID = sqlDataView[7, sqlDataView.CurrentCell.RowIndex].Value.ToString(); SFZid = sqlID; #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 JCRbz from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetBZ = getInfo(sql); //固定电话 sql = "select JCRgddh from JCRJBXX where JCRsfz='" + sqlID + "'"; DI.GetGDDH = 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 = judge; DI.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(); } } }