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