//显示更多筛选条件
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; }
}
