private void button1_Click(object sender, EventArgs e)
{
Form1 f1 = (Form1)Owner;
Filter f = new Filter();
f.keywords = "";
string bkzy = "";
string bkfx = "";
string bkcc = "";
if ((ComboboxItem)cbbkzy.SelectedItem != null)
{
bkzy = ((ComboboxItem)cbbkzy.SelectedItem).Value.ToString();
}
if ((ComboboxItem)cbbkfx.SelectedItem != null)
{
bkfx = ((ComboboxItem)cbbkfx.SelectedItem).Value.ToString();
}
if ((ComboboxItem)cbbkcc.SelectedItem != null)
{
bkcc = ((ComboboxItem)cbbkcc.SelectedItem).Value.ToString();
}
f.fx = bkfx;
f.cc = bkcc;
f.zy = bkzy;
f.sd = tbsd.Text;
f.ed = tbed.Text;
f.a = comboBox1.SelectedItem.ToString();
f1.Bind(f);
Close();
}
private void btn_del_Click(object sender, EventArgs e)
{
int rid = Int16.Parse(dgv_recruit.SelectedRows[0].Cells["id"].Value.ToString());
string sqlStr = "DELETE FROM recruit WHERE id = " + rid.ToString();
DB.excuteSql(sqlStr);
Filter f = new Filter();
f.keywords = tb_query.Text;
Bind(f);
}
private void btn_search_Click(object sender, EventArgs e)
{
Filter f = new Filter();
f.keywords = tb_query.Text;
if (cb_avatar.SelectedItem!=null)
{
f.a = cb_avatar.SelectedItem.ToString();
}
Bind(f);
}
public void Bind(Filter f)
{
string sqlStr;
sqlStr = "SELECT '" + DateTime.Today.Year.ToString() + "', recruit.bmh, recruit.xm, recruit.zkzh, recruit.jxzd, recruit.jxfdd, zd_xb.mc AS xb, zd_mz.mc AS mz, " +
"zd_zzmm.mc AS zzmm, recruit.csrq, recruit.sfzh, recruit.bysj, recruit.gzdw, recruit.byxx, recruit.byzdm, recruit.bkzy, " +
"recruit.bkfx, recruit.bkcc, zd_xxxs.mc AS xxxs, recruit.txdz, recruit.yzdm, recruit.lxdh, recruit.sjh, zd_sfjxs.mc AS sfjxs, " +
"recruit.dateline, recruit.id, recruit.pc, recruit.avatar " +
"FROM (((((recruit INNER JOIN " +
"zd_mz ON recruit.mz = zd_mz.dm) INNER JOIN " +
"zd_sfjxs ON recruit.sfjxs = zd_sfjxs.ID) INNER JOIN " +
"zd_xb ON recruit.xb = zd_xb.dm) INNER JOIN " +
"zd_xxxs ON recruit.xxxs = zd_xxxs.ID) INNER JOIN " +
"zd_zzmm ON recruit.zzmm = zd_zzmm.ID) " +
"WHERE recruit.pc = '" + pc + "' and recruit.jxzd = '" + jxzd + "'";
if (f.keywords != null)
{
string[] keywords = f.keywords.Split(' ');
foreach (string k in keywords)
{
sqlStr += " AND (recruit.nf like '%" + k + "%' OR recruit.xm like '%" + k + "%'" +
" OR recruit.sfzh like '%" + k + "%' OR recruit.bmh like '%" + k + "%'" +
" OR recruit.bkzy like '%" + k + "%' OR recruit.bkfx like '%" + k + "%'" +
" OR recruit.sjh like '%" + k + "%' OR recruit.dateline like '%" + k + "%'" +
" OR recruit.bkcc like '%" + k + "%' OR zd_xxxs.mc like '%" + k + "%')";
}
}
if (f.zy != null && f.zy != "")
{
sqlStr += " AND recruit.bkzy like '%" + f.zy + "%'";
}
if (f.fx != null && f.fx != "")
{
sqlStr += " AND recruit.bkfx like '%" + f.fx + "%'";
}
if (f.cc != null && f.cc != "")
{
sqlStr += " AND recruit.bkcc like '%" + f.cc + "%'";
}
if (f.sd != null && f.sd != "")
{
sqlStr += " AND recruit.dateline >= #" + f.sd + "#";
}
if (f.ed != null && f.ed != "")
{
sqlStr += " AND recruit.dateline <= #" + f.ed + "#";
}
if (f.ed != null && f.ed != "")
{
sqlStr += " AND recruit.dateline <= #" + f.ed + "#";
}
if (f.a != null && f.a != "")
{
checkJpg();
if (f.a == "有头像")
{
sqlStr += " AND recruit.avatar = '有'";
}
else if (f.a == "无头像")
{
sqlStr += " AND (recruit.avatar = '' OR recruit.avatar is null)";
}
}
System.Data.DataTable dt = DB.dataTable(sqlStr);
DataColumn Col = dt.Columns.Add("编号", System.Type.GetType("System.Int32"));
Col.SetOrdinal(0);// to put the column in position 0;
foreach(DataRow dr in dt.Rows)
{
dr[0] = dt.Rows.IndexOf(dr) + 1;
}
dgv_recruit.DataSource = dt;
dgv_recruit.Columns[0].HeaderText = "编号";
dgv_recruit.Columns[1].HeaderText = "年份*";
dgv_recruit.Columns[2].HeaderText = "报名号";
//dgv_recruit.Columns[2].Visible = false;
dgv_recruit.Columns[3].HeaderText = "姓名*";
dgv_recruit.Columns[4].HeaderText = "准考证号";
//dgv_recruit.Columns[4].Visible = false;
dgv_recruit.Columns[5].HeaderText = "教学站点*";
//dgv_recruit.Columns[5].Visible = false;
dgv_recruit.Columns[6].HeaderText = "教学辅导点";
//dgv_recruit.Columns[6].Visible = false;
dgv_recruit.Columns[7].HeaderText = "性别*";
//dgv_recruit.Columns[7].Visible = false;
dgv_recruit.Columns[8].HeaderText = "民族*";
//dgv_recruit.Columns[8].Visible = false;
dgv_recruit.Columns[9].HeaderText = "政治面貌*";
//dgv_recruit.Columns[9].Visible = false;
dgv_recruit.Columns[10].HeaderText = "出生日期(格式为：20010101)*";
//dgv_recruit.Columns[10].Visible = false;
dgv_recruit.Columns[11].HeaderText = "身份证号*";
//dgv_recruit.Columns[11].Visible = false;
dgv_recruit.Columns[12].HeaderText = "毕业时间(格式为：200101)";
//dgv_recruit.Columns[12].Visible = false;
dgv_recruit.Columns[13].HeaderText = "工作单位";
//dgv_recruit.Columns[13].Visible = false;
dgv_recruit.Columns[14].HeaderText = "毕业学校";
//dgv_recruit.Columns[14].Visible = false;
dgv_recruit.Columns[15].HeaderText = "毕业证代码";
//dgv_recruit.Columns[15].Visible = false;
dgv_recruit.Columns[16].HeaderText = "报考专业*";
dgv_recruit.Columns[17].HeaderText = "报考方向*";
dgv_recruit.Columns[18].HeaderText = "报考层次*";
dgv_recruit.Columns[19].HeaderText = "学习形式*";
dgv_recruit.Columns[20].HeaderText = "通信地址";
//dgv_recruit.Columns[20].Visible = false;
dgv_recruit.Columns[21].HeaderText = "邮政代码";
//dgv_recruit.Columns[21].Visible = false;
dgv_recruit.Columns[22].HeaderText = "联系电话";
//dgv_recruit.Columns[22].Visible = false;
dgv_recruit.Columns[23].HeaderText = "手机号";
dgv_recruit.Columns[24].HeaderText = "是否进修生*";
//dgv_recruit.Columns[24].Visible = false;
dgv_recruit.Columns[25].HeaderText = "报名日期";
dgv_recruit.Columns[26].Visible = false;
dgv_recruit.Columns[27].Visible = false;
dgv_recruit.Columns[28].HeaderText = "头像";
dgv_recruit.AutoResizeColumns();
dgv_recruit.AutoResizeColumnHeadersHeight();
}
