public static ZhaopinFb GetZhaopinFbByid(int id) { string sqlstr = "select zpfb.id as Id," + "zpfb.zpgwid as ZpgwId," + "zpgw.zpbm as ZpBmID," + "department.departname as ZpBm," + "zpgw.zppos as Zppos," + "zpfb.sums as ZpSums," + "zpfb.fbtime as FbTime, " + "zpfb.zpitmid as ZpItmId " + "from zpfb,zpgw,department " + " where zpfb.fbstate=1 and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and department.bmstate=1 and zpfb.id=" + id; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; ZhaopinFb zf = new ZhaopinFb(); zf.Id = Convert.ToInt32(dr["Id"].ToString()); zf.ZpGwID = Convert.ToInt32(dr["ZpgwId"].ToString()); zf.ZpSums = Convert.ToInt32(dr["ZpSums"].ToString()); zf.ZpFbTime = dr["FbTime"].ToString(); zf.ZpitmId = Convert.ToInt32(dr["ZpItmId"]); zf.ZpBmName = dr["ZpBm"].ToString(); zf.ZpPosName = dr["Zppos"].ToString(); zf.FbBmId = Convert.ToInt32(dr["ZpBmID"].ToString()); return(zf); } return(null); }
public static List <Department> GetDepartmentByName(string depname) { String sqlstr = "select * from department where bmstate=1 "; if (depname != "" && depname != null) { sqlstr += " and departname Like '%" + depname + "%'"; } //String sqlstr = "select * from department where bmstate=1 and departname='"+depname+"'"; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); List <Department> list = new List <Department>(); if (dt.Rows.Count < 1) { return(list); } foreach (DataRow dr in dt.Rows) { Department department = new Department(); department.Id = (int)dr["id"]; department.Name = dr["departname"].ToString(); department.Info = dr["info"].ToString(); department.Bmstate = Convert.ToInt32(dr["bmstate"].ToString()); list.Add(department); } return(list); }
public static DataTable GetAllZhaopinFbInItem(int dep = -1, string pos = "", int itmid = -1) { string sqlstr = "select zpfb.id as Id," + "zpfb.zpgwid as ZpgwId," + "zpgw.zpbm as ZpBmID," + "department.departname as ZpBm," + "zpgw.zppos as Zppos," + "zpfb.sums as ZpSums," + "zpfb.fbtime as FbTime, " + "zpfb.zpitmid as ZpItmId " + "from zpfb,zpgw,department " + " where zpfb.fbstate=1 and zpfb.zpgwid=zpgw.id" + " and zpgw.zpbm=department.id and department.bmstate=1 "; if (dep != -1) { sqlstr += " and department.id=" + dep + " "; } if (pos != "") { sqlstr += " and zpgw.zppos='" + pos + "' "; } if (itmid != -1) { sqlstr += " and zpfb.zpitmid='" + itmid + "' "; } sqlstr += " order by FbTime desc "; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); return(dt); }
public static Shiti GetShitiById(int stid = -1) { String sql = "select shiti.id as Id,question,ktid,ktindex,weight,sttime from shiti,kaoti where shiti.ktid=kaoti.id and kaoti.ktstate=1 "; if (stid != -1) { sql += " and shiti.id=" + stid + ""; } else { return(null); } DataTable dt = MySqlDBHelper.GetDataSet(sql); Shiti st = new Shiti(); foreach (DataRow dr in dt.Rows) { // Shiti st = new Shiti(); st.Id = Convert.ToInt32(dr["Id"].ToString()); st.Question = dr["question"].ToString(); st.KaotiID = Convert.ToInt32(dr["ktid"].ToString()); st.KaotiIndex = Convert.ToInt32(dr["ktindex"].ToString()); st.Weight = Convert.ToInt32(dr["weight"]); st.StTime = Convert.ToInt32(dr["sttime"]); return(st); } return(null); }
public static bool FindUser(string username, string password) { String sql = "select * from userinfo where uname='" + username + "' and pwd='" + password + "'"; DataTable dt = MySqlDBHelper.GetDataSet(sql); return(dt.Rows.Count > 0 ? true:false); }
public static int getShitiWeightsInkaoti(int ktid = -1, int seceptid = -1) { String sql = "select SUM(weight) from kaoti,shiti where kaoti.ktstate=1 and shiti.ktid=kaoti.id "; int weight_sum = 0; if (ktid != -1) { sql += " and shiti.ktid=" + ktid + " "; } if (seceptid != -1) { sql += " and shiti.id <> " + seceptid; } DataTable dt = MySqlDBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { if (dt.Rows[0][0].ToString() != "") { weight_sum = Convert.ToInt32(dt.Rows[0][0]); } } return(weight_sum); }
public static List <Zhaopin> GetAllZhaopinListByparameters(int dep = -1, string pos = "", string st = "", string et = "") { string sqlstr = "select zhaopin.id as Id," + "zhaopin.title as Title," + "zhaopin.zpfbid as ZPfbId," + "zhaopin.interviewtime as PubTime," + "department.departname as Bm," + "zpgw.zppos as Position," + "zpfb.sums as ZpSum," + "zhaopin.hege as HegeLine, " + "zhaopin.ktid as KTID " + "from zhaopin,zpfb,zpgw,department" + " where zhaopin.zpfbid=zpfb.id and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and zpfb.fbstate=1 and zhaopin.zpstate=1 and department.bmstate=1 "; if (dep != -1) { sqlstr += " and department.id=" + dep + " "; if (pos != "") { sqlstr += " and zpgw.zppos='" + pos + "' "; } } if (st != "") { sqlstr += " and zhaopin.interviewtime >='" + st + "' "; } if (et != "") { sqlstr += " and zhaopin.interviewtime<='" + et + "' "; } sqlstr += " order by zhaopin.interviewtime DESC"; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); List <Zhaopin> ls = new List <Zhaopin>(); foreach (DataRow dr in dt.Rows) { Zhaopin zp = new Zhaopin(); zp.Id = Convert.ToInt32(dr["Id"].ToString()); zp.Title = dr["Title"].ToString(); // DateTime date = (DateTime)dr["PubTime"]; //zp.InterviewTime = date.ToShortDateString(); zp.InterviewTime = dr["PubTime"].ToString(); zp.ZpfbId = Convert.ToInt32(dr["ZPfbId"].ToString()); zp.KaotiID = dr["KTID"].ToString() == "" ? 0 : Convert.ToInt32(dr["KTID"].ToString()); zp.HegeLine = Convert.ToInt32(dr["HegeLine"].ToString()); zp.ZpbmName = dr["Bm"].ToString(); zp.ZpgwName = dr["Position"].ToString(); zp.ZpSums = Convert.ToInt32(dr["ZpSum"].ToString()); ls.Add(zp); } return(ls); }
public static KaoguanZhaopin GetKgZPbyId(int id) { String sql = "select kaoguanzhaopin.id as Id, " + "kgid," + "zpid," + "weight " + " from kaoguanzhaopin,kaoguan,zhaopin,department " + " where kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 " + " and kaoguanzhaopin.zpid= zhaopin.id " + " and zhaopin.id in (select zhaopin.id from zhaopin,zpfb,zpgw,department " + " where zhaopin.zpfbid=zpfb.id and zpfb.fbstate=1 and zhaopin.zpstate=1 " + " and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and department.bmstate=1 ) " + " and department.id=kaoguan.depart and department.bmstate=1 " + " and kaoguanzhaopin.id=" + id; DataTable dt = MySqlDBHelper.GetDataSet(sql); KaoguanZhaopin kgzp = new KaoguanZhaopin(); foreach (DataRow dr in dt.Rows) { kgzp.Id = (int)dr["Id"]; kgzp.KaoguanID = Convert.ToInt32(dr["kgid"].ToString()); kgzp.ZhaopinID = Convert.ToInt32(dr["zpid"].ToString()); kgzp.Weight = Convert.ToInt32(dr["weight"].ToString()); return(kgzp); } return(null); }
public static List <Shiti> GetAllShitiByKaotiId(int ktid = -1) { String sql = "select shiti.id as Id,question,ktid,ktindex,weight,sttime " + " from shiti,kaoti,zpgw,department " + " where kaoti.ktstate=1 and shiti.ktid=kaoti.id " + " and kaoti.zpgwid=zpgw.id and zpgw.zpbm=department.id and department.bmstate=1 "; //if(ktid !=-1) { sql += " and shiti.ktid=" + ktid + " "; } sql += " order by Id asc"; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Shiti> list = new List <Shiti>(); foreach (DataRow dr in dt.Rows) { Shiti st = new Shiti(); st.Id = Convert.ToInt32(dr["Id"].ToString()); st.Question = dr["question"].ToString(); st.KaotiID = Convert.ToInt32(dr["ktid"].ToString()); st.KaotiIndex = Convert.ToInt32(dr["ktindex"].ToString()); st.Weight = Convert.ToInt32(dr["weight"]); st.StTime = Convert.ToInt32(dr["sttime"]); list.Add(st); } return(list); }
public static List <Kaoti> GetKaotiByZpID(int zpid = -1) { String sql = "select kaoti.id as Id," + "kaoti.title as Title," + "kaoti.zpgwid as ZpgwId " + " from kaoti,zpfb,zpgw,zhaopin " + " where kaoti.ktstate=1 and zhaopin.zpfbid=zpfb.id and zhaopin.zpstate=1 " + " and zpfb.zpgwid=zpgw.id and zpfb.fbstate=1 and zpgw.id=kaoti.zpgwid "; // if (zpid != -1) { sql += " and zhaopin.id=" + zpid + " "; } DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Kaoti> list = new List <Kaoti>(); foreach (DataRow dr in dt.Rows) { Kaoti kt = new Kaoti(); kt.Id = (int)dr["Id"]; kt.Title = dr["title"].ToString(); kt.ZpgwId = Convert.ToInt32(dr["ZpgwId"].ToString()); list.Add(kt); } return(list); }
public static Pingfen GetPfByParameter(int kgzpid, int ypzzpid, int stid, int xdbzid) { String sqlstr = "select pingfen.id as Id,pingfen.ypzzpid,pingfen.kgzpid,pingfen.shitiid,pingfen.xdbzid,pingfen.chengji," + "pingfen.pfstate from pingfen,yingpingzhezhaopin,yingpinzhe,kaoguanzhaopin,kaoguan " + "where pingfen.pfstate=1 and kgzpid=@kgzpid and ypzzpid=@ypzzpid and shitiid=@stid and xdbzid=@xdbzid " + " and pingfen.ypzzpid=yingpingzhezhaopin.id and pingfen.kgzpid=kaoguanzhaopin.id " + " and yingpingzhezhaopin.ypzid=yingpinzhe.id and yingpinzhe.ypzstate=1 " + " and kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 "; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@kgzpid", kgzpid)); para_list.Add(new MySqlParameter("@ypzzpid", ypzzpid)); para_list.Add(new MySqlParameter("@stid", stid)); para_list.Add(new MySqlParameter("@xdbzid", xdbzid)); DataTable dt = MySqlDBHelper.GetDataSet(sqlstr, para_list.ToArray()); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; Pingfen pf = new Pingfen(); pf.Id = Convert.ToInt32(dr["Id"].ToString()); pf.KgzpID = Convert.ToInt32(dr["kgzpid"].ToString()); pf.ShitiID = Convert.ToInt32(dr["shitiid"].ToString()); pf.YpzzpID = Convert.ToInt32(dr["ypzzpid"].ToString()); pf.XdbzID = Convert.ToInt32(dr["xdbzid"].ToString()); pf.State = Convert.ToInt32(dr["pfstate"].ToString()); pf.Score = Convert.ToInt32(dr["chengji"].ToString()); return(pf); } return(null); }
public static int batchAdd(List <Pingfen> pinfenList) { if (pinfenList.Count < 1) { return(0); } String sql = "insert into pingfen(ypzzpid,kgzpid,shitiid,xdbzid,chengji,pfstate) values "; StringBuilder sb = new StringBuilder(); sb.Append(sql); for (int i = 0; i < pinfenList.Count; i++) { Pingfen pingfen = pinfenList[i]; sb.Append("("). Append(pingfen.YpzzpID).Append(","). Append(pingfen.KgzpID).Append(","). Append(pingfen.ShitiID).Append(","). Append(pingfen.XdbzID).Append(","). Append(pingfen.Score).Append(","). Append(1).Append(" )"); if (i < pinfenList.Count - 1) { sb.Append(","); } } sql = sb.ToString(); return(MySqlDBHelper.ExecuteCommand(sql)); }
public static List <ZhaopinItem> GetAllZhaopinItemListWithKgaoguan(int kgid, string name) { string sqlstr = "select zhaopinitem.id as Id," + "zhaopinitem.title as Title," + "zhaopinitem.pubtime as PubTime from zhaopinitem " + " where zhaopinitem.zpitemstate=1 " + " and zhaopinitem.id in(select zhaopinitem.id from zhaopinitem,zpfb,zhaopin,kaoguanzhaopin,kaoguan " + " where zhaopinitem.id= zpfb.zpitmid and zhaopin.id= kaoguanzhaopin.zpid and zhaopin.zpfbid=zpfb.id and kaoguanzhaopin.kgid=kaoguan.id " + " and zhaopinitem.zpitemstate=1 and zpfb.fbstate=1 and zhaopin.zpstate=1 and kaoguan.kgstate=1 " + " and kaoguan.id=" + kgid + ") "; //+ ; // " order by PubTime desc"; if (name != "") { sqlstr += " and zhaopinitem.title Like '%" + name + "%'"; } DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); List <ZhaopinItem> ls = new List <ZhaopinItem>(); foreach (DataRow dr in dt.Rows) { ZhaopinItem zpitem = new ZhaopinItem(); zpitem.Id = Convert.ToInt32(dr["Id"]); zpitem.Title = dr["Title"].ToString(); zpitem.PubTime = dr["PubTime"].ToString(); ls.Add(zpitem); } return(ls); }
public static List <ZhaopinItem> GetAllZhaopinItemListByTitle(string titlename = "") { string sqlstr = "select zhaopinitem.id as Id," + "zhaopinitem.title as Title," + "zhaopinitem.pubtime as PubTime from zhaopinitem " + " where zhaopinitem.zpitemstate=1 ";//+ //"order by PubTime desc"; if (titlename != "") { sqlstr += " and zhaopinitem.title Like '%" + titlename + "%'"; } sqlstr += " order by PubTime desc"; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); List <ZhaopinItem> ls = new List <ZhaopinItem>(); foreach (DataRow dr in dt.Rows) { ZhaopinItem zpitem = new ZhaopinItem(); zpitem.Id = Convert.ToInt32(dr["Id"]); zpitem.Title = dr["Title"].ToString(); zpitem.PubTime = dr["PubTime"].ToString(); ls.Add(zpitem); } return(ls); }
public static Kaoguan GetKaoguanByID(int id) { String sql = "select kaoguan.*,department.departname from kaoguan,department where kaoguan.depart=department.id and kaoguan.kgstate=1 and kaoguan.id=" + id; DataTable dt = MySqlDBHelper.GetDataSet(sql); if (dt.Rows.Count < 1) { return(null); } Kaoguan kg = new Kaoguan(); bool falg = false; foreach (DataRow dr in dt.Rows) { kg.Id = (int)dr["id"]; kg.WorkID = dr["workid"].ToString(); kg.Name = dr["name"].ToString(); kg.DepID = Convert.ToInt32(dr["depart"].ToString()); kg.PositionName = dr["position"].ToString(); kg.Company = dr["company"].ToString(); kg.Pwd = dr["password"].ToString(); kg.DepName = dr["departname"].ToString(); falg = true; break; } if (falg) { return(kg); } return(null); }
public static List <Kaoguan> GetAllKaoguan() { String sql = "select kaoguan.*,department.departname from kaoguan,department" + " where kaoguan.depart=department.id and kaoguan.kgstate=1" + " and department.bmstate=1 " + " order by department.id asc"; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Kaoguan> list = new List <Kaoguan>(); if (dt.Rows.Count < 1) { return(list); } foreach (DataRow dr in dt.Rows) { Kaoguan kg = new Kaoguan(); kg.Id = (int)dr["id"]; kg.WorkID = dr["workid"].ToString(); kg.Name = dr["name"].ToString(); kg.DepID = Convert.ToInt32(dr["depart"].ToString()); kg.PositionName = dr["position"].ToString(); kg.Company = dr["company"].ToString(); kg.Pwd = dr["password"].ToString(); kg.DepName = dr["departname"].ToString(); list.Add(kg); } return(list); }
//hhy public static DataTable GetAllZhaopinListInItemIdByKaoguan(int zpitmid, int kgid, int dep = -1, string pos = "") { string sqlstr = "select zhaopin.id as Id," + "zhaopin.title as Title," + "zhaopin.zpfbid," + "zhaopin.interviewtime as InterviewTime," + "department.departname as ZpbmName," + "zpgw.zppos as ZpgwName," + "zpfb.sums as ZpSums," + "zhaopin.hege as HegeLine, " + "zhaopin.ktid as KTID " + "from zhaopin,zpfb,zpgw,department" + " where zhaopin.zpfbid=zpfb.id and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and zpfb.fbstate=1 and zhaopin.zpstate=1 and department.bmstate=1 " + " and zhaopin.id in (select distinct zpid from kaoguanzhaopin,kaoguan,department where kaoguanzhaopin.kgid=kaoguan.id and kaoguan .kgstate=1 and kaoguan.depart=department.id and department.bmstate=1 and kaoguanzhaopin.kgid= " + kgid + " )"; if (zpitmid != -1) { sqlstr += " and zpfb.zpitmid=" + zpitmid + " "; } if (dep != -1) { sqlstr += " and department.id=" + dep + " "; } if (pos != "") { sqlstr += " and zpgw.zppos='" + pos + "' "; } sqlstr += " and zhaopin.id in (select distinct zpid from kaoguanzhaopin where kgid= " + kgid + " )"; sqlstr += " order by InterviewTime desc "; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); return(dt); }
public static DataTable GetAllZhaopin(int dep = -1, string pos = "") { string sqlstr = "select zhaopin.id as Id," + "zhaopin.title as Title," + "zhaopin.zpfbid," + "zhaopin.interviewtime as InterviewTime," + "department.departname as ZpbmName," + "zpgw.zppos as ZpgwName," + "zpfb.sums as ZpSums," + "zhaopin.hege as HegeLine, " + "zhaopin.ktid as KTID " + "from zhaopin,zpfb,zpgw,department" + " where zhaopin.zpfbid=zpfb.id and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and zpfb.fbstate=1 and zhaopin.zpstate=1 and department.bmstate=1 "; if (dep != -1) { sqlstr += " and department.id=" + dep + " "; } if (pos != "") { sqlstr += " and zpgw.zppos='" + pos + "' "; } sqlstr += " order by InterviewTime desc "; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); return(dt); }
public static int Add(Politic politic) { String sql = "insert into politic(politicname) values(@politicname)"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@politicname", politic.PoliticName)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int DeleteByID(int _id) { String sql = "delete from pingjiabiaozhun where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", _id)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int Add(Xueli xl) { String sql = "insert into Xueli(degreename) values(@degreename)"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@degreename", xl.XueliName)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int Delete(int id) { String sqlstr = "delete from kaoti where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", id)); return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray())); }
public static int UpdateZhaopinItemTitle(int id, string title_t) { String sqlstr = "update zhaopinitem set title=@title where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", id)); para_list.Add(new MySqlParameter("@title", title_t)); return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray())); }
public static int Add(UserInfo userinfo) { String sql = "insert into userinfo(uname,pwd) values(@uname,@pwd)"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@uname", userinfo.Username)); para_list.Add(new MySqlParameter("@pwd", userinfo.Password)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int UpdateWeight(int kgzpid, int w) { String sql = "update kaoguanzhaopin set weight=@weight where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", kgzpid)); para_list.Add(new MySqlParameter("@weight", w)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int GetKaotiSumsInGw(int gwid) { int res = 0; string sql = "select * from kaoti where ktstate=1 and zpgwid=" + gwid + " "; DataTable dt = MySqlDBHelper.GetDataSet(sql); res = dt.Rows.Count; return(res); }
public static int UpdateIndex(int id, int ord) { String sql = "update yingpingzhezhaopin set ranindex=@ranindex where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", id)); para_list.Add(new MySqlParameter("@ranindex", ord)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int UpdateSubmitState(YingpinzheZhaopin ypzzp) { String sql = "update yingpingzhezhaopin set submitstate=@submitstate where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", ypzzp.ID)); para_list.Add(new MySqlParameter("@submitstate", ypzzp.SubmitState)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int UpdateKaotiIndex(int id, int ktid) { String sqlstr = "update zhaopin set ktid=@ktid where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", id)); para_list.Add(new MySqlParameter("@ktid", ktid)); return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray())); }
public static int Update(Pingfen pf) { String sql = "update pingfen set chengji=@chengji where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", pf.Id)); para_list.Add(new MySqlParameter("@chengji", pf.Score)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }