/// <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();
}
}
}
