//显示更多筛选条件 private void moreCon_Click(object sender, EventArgs e) { //更多筛选条件类实例 MoreCon MC = new MoreCon(); MC.ShowDialog(); }
/// <summary> /// 查询 /// </summary> /// <returns>查询失败返回0,查询成功返回查询到的数量</returns> public int singleQuery() { //更多筛选条件类实例 MoreCon MC = new MoreCon(); /*sql = "select JCRname as 姓名, JCRsex as 性别 ,JCRnation as 民族, JCRpolity as 政治面貌 ,JCRLiPla as 现居住地, JCRidenty as 身份证号 ," + "JCRphone as 联系电话, JCRbm as 别名, JCRfl as 分类, JCRJG as 籍贯,JCRsf as 身份,JCRfy as 方言,JCRzjxy as 宗教信仰, JCRsxdj as 思想等级,JCRlkdw as 列控单位,JCRjjzk as 经济状况,JCRxz as 现状,JCRlkjb as 列控级别," + "JCRbyyx as 毕业院校,JCRhjszd as 户籍所在地, JCRgzdw as 工作单位,JCRzy as 职业,JCRgxry as 关系人员,JCRgddh as 固定电话,JCRbgsdh as 办公室电话,JCRyddh as 移动电话,JCRqq as QQ,JCRwx as 微信,JCRdzyj as 电子邮件,JCRgrjl as 个人简历 " + " from JCRJBXX where 1=1 ";*/ sql = "select JCRname as 姓名,JCRbm as 别名,JCRsex as 性别, JCRidenty as 身份证号,JCRJG as 籍贯,JCRsf as 身份 from JCRJBXX where 1=1 "; #region 择的条件将筛选条件加入sql字符串 if (checkName.Checked == false && checkJG.Checked == false && checkLKDW.Checked == false && checkLKJB.Checked == false && checkXJZD.Checked == false && checkGXRY.Checked == false && MC.boolNL == false && MC.boolMZ == false && MC.boolZZMM == false && MC.boolGXRY == false && MC.booBYYX == false && MC.boolGZDW == false && MC.boolZY == false && MC.boolFL == false) { MessageBox.Show("请至少选择一项", "提示"); return(0); } else { //姓名 if (checkName.Checked == true) { if (sqlName.Text.Trim() == "") { MessageBox.Show("请输入姓名", "提示"); } sql += " and JCRname like '%" + sqlName.Text.Trim() + "%'"; } //籍贯 if (checkJG.Checked == true) { if (sqlJG.Text.Trim() == "") { MessageBox.Show("请输入籍贯", "提示"); } sql += " and JCRJG like'%" + sqlJG.Text.Trim() + "%' "; } //列控级别 if (checkLKJB.Checked == true) { if (sqlLKJB.Text.Trim() == "") { MessageBox.Show("请输入列控级别", "提示"); } sql += " and JCRlkjb like'%" + sqlLKJB.Text.Trim() + "%' "; } //关系人员 if (checkGXRY.Checked == true) { if (sqlGXRY.Text.Trim() == "") { MessageBox.Show("请输入关系人员", "提示"); } sql += " and JCRgxry like'%" + sqlGXRY.Text.Trim() + "%' "; } //现居住地 if (checkXJZD.Checked == true) { if (sqlXJZD.Text.Trim() == "") { MessageBox.Show("请输入现居住地", "提示"); } sql += " and JCRLiPla like '%" + sqlXJZD.Text.Trim() + "%'"; } //年龄 if (MC.boolNL == true) { if (MC.addNL.Trim() == "") { MessageBox.Show("请输入年龄", "提示"); } sql += " and JCRnl like '%" + MC.addNL + "%'"; } //民族 if (MC.boolMZ == true) { if (MC.addMZ.Trim() == "") { MessageBox.Show("请输入民族", "提示"); } sql += " and JCRnation like '%" + MC.addMZ + "%'"; } //政治面貌 if (MC.boolZZMM == true) { if (MC.addZZMM.Trim() == "") { MessageBox.Show("请输入政治面貌", "提示"); } sql += " and JCRpolity like '%" + MC.addZZMM + "%' "; } //身份证号 if (MC.boolGXRY == true) { if (MC.addGXRY.Trim() == "") { MessageBox.Show("请输入身份证号", "提示"); } sql += " and JCRidenty like '%" + MC.addGXRY + "%'"; } //身份 if (MC.booBYYX == true) { if (MC.addBYYX.Trim() == "") { MessageBox.Show("请输入身份", "提示"); } sql += " and JCRsf like '%" + MC.addBYYX + "%'"; } //宗教信仰 if (MC.boolGZDW == true) { if (MC.addGZDW == "") { MessageBox.Show("请输入宗教信仰", "提示"); } sql += " and JCRzjxy like '%" + MC.addGZDW + "%'"; } //职业 if (MC.boolZY == true) { if (MC.addZY == "") { MessageBox.Show("请输入职业", "提示"); } sql += " and JCRzy like '%" + MC.addZY + "%'"; } //分类 if (MC.boolFL == true) { if (MC.addFL == "") { MessageBox.Show("请输入分类", "提示"); } sql += " and JCRfl like '%" + MC.addFL + "%'"; } #endregion int result = sqlMethod(sql); if (result == 0) { MessageBox.Show("无相关人员信息", "提示"); sql = ""; return(0); } else { sql = ""; return(result); } } //单独选择姓名 //else if (checkName.Checked == true && checkJG.Checked == false && checkLKDW.Checked == false && checkLKJB.Checked == false && checkXJZD.Checked == false && checkGXRY.Checked == false) //{ // sql += "JCRname='" + sqlName.Text.Trim() + "'"; // int rename = sqlMethod(sqlName.Text.Trim(), "姓名", sql); // sql = string.Empty; // return rename; //} ////单独选择籍贯 //else if (checkName.Checked == false && checkJG.Checked == true && checkLKDW.Checked == false && checkLKJB.Checked == false && checkXJZD.Checked == false && checkGXRY.Checked == false) //{ // sql += " JCRJG='" + sqlJG.Text.Trim() + "'"; // int rename = sqlMethod(sqlJG.Text.Trim(), "籍贯", sql); // sql = string.Empty; // return rename; //} ////单独选择列控级别 //else if (checkName.Checked == false && checkJG.Checked == false && checkLKDW.Checked == false && checkLKJB.Checked == true && checkXJZD.Checked == false && checkGXRY.Checked == false) //{ // sql += " JCRlkjb='" + sqlLKJB.Text.Trim() + "'"; // int rename = sqlMethod(sqlJG.Text.Trim(), "列控级别", sql); // sql = string.Empty; // return rename; //} ////单独选择列控单位 //else if (checkName.Checked == false && checkJG.Checked == false && checkLKDW.Checked == true && checkLKJB.Checked == false && checkXJZD.Checked == false && checkGXRY.Checked == false) //{ // sql += " JCRlkdw='" + sqlLKDW.Text.Trim() + "'"; // int rename = sqlMethod(sqlJG.Text.Trim(), "列控单位", sql); // sql = string.Empty; // return rename; //} ////单独选择关系人员 //else if (checkName.Checked == false && checkJG.Checked == false && checkLKDW.Checked == false && checkLKJB.Checked == false && checkXJZD.Checked == false && checkGXRY.Checked == true) //{ // sql += " JCRgxry='" + sqlGXRY.Text.Trim() + "'"; // int rename = sqlMethod(sqlJG.Text.Trim(), "关系人员", sql); // sql = string.Empty; // return rename; //} ////单独选择现居住地 //else if (checkName.Checked == false && checkJG.Checked == false && checkLKDW.Checked == false && checkLKJB.Checked == false && checkXJZD.Checked == true && checkGXRY.Checked == false) //{ // sql += " JCRxjzd='" + sqlXJZD.Text.Trim() + "'"; // int rename = sqlMethod(sqlJG.Text.Trim(), "现居住地", sql); // sql = string.Empty; // return rename; //} //else { return 0; } }