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 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 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 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 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 <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 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); }
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 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); }
//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 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 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 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 DataTable GetAllZhaopinItem() { 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"; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); return(dt); }
public static int GetPingjiaxiangdianScoreSum() { String sql = "select * from pingjiaxiangdian "; DataTable dt = MySqlDBHelper.GetDataSet(sql); int scoresum = 0; foreach (DataRow dr in dt.Rows) { scoresum += Convert.ToInt32(dr["score"].ToString()); } return(scoresum); }
public static int GetPositionIDbyName(string gwname) { int positionid = -1; String sqlstr = "select id from gwposition where positionname='" + gwname + "'"; DataTable dt = MySqlDBHelper.GetDataSet(sqlstr); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; positionid = Convert.ToInt32(dr["id"].ToString()); } return(positionid); }
public static int GetByypzidkgidNoSubmit(int ypzzpid, int kgzpid) { String sql = "select ypzkgsubmit.id as Id," + "ypzkgsubmit.ypzzpid as YpzzpID," + "ypzkgsubmit.kgzpid as KgzpID," + "ypzkgsubmit.submitstate as SubmitState " + " from ypzkgsubmit " + " where ypzkgsubmit.submitstate=0 and ypzkgsubmit.ypzzpid= " + ypzzpid + " and ypzkgsubmit.kgzpid= " + kgzpid; DataTable dt = MySqlDBHelper.GetDataSet(sql); return(dt.Rows.Count); }
public static List <Kaoti> GetKaotiByParameters(int depid = -1, string zppos = "") { String sql = "select kaoti.id as Id," + "kaoti.title as Title," + "kaoti.zpgwid as ZpgwId," + "zpgw.zpbm as DepId," + "department.departname as ZpDepName," + "zpgw.zppos as ZpPosName," + " kaoti.ktstate, " + " kaoti.createtime " + " from kaoti,zpgw,department" + " where zpgw.zpbm=department.id and kaoti.zpgwid=zpgw.id and " + " kaoti.ktstate=1 and department.bmstate=1 "; if (depid != -1) { sql += " and department.id=" + depid + " "; } if (zppos != "" && zppos != null) { sql += " and zpgw.zppos='" + zppos + "' "; } 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()); kt.KtState = Convert.ToInt32(dr["ktstate"].ToString()); if (dr["createtime"].ToString() != null && dr["createtime"].ToString() != "") { DateTime date = (DateTime)dr["createtime"]; kt.CreateTime = date.ToShortDateString(); } else { kt.CreateTime = ""; } kt.ZpBmName = dr["ZpDepName"].ToString(); kt.ZpGmName = dr["ZpPosName"].ToString(); list.Add(kt); } return(list); }
public static List <Politic> GetAllPolitic() { String sql = "select * from politic"; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Politic> list = new List <Politic>(); foreach (DataRow dr in dt.Rows) { Politic pic = new Politic(); pic.ID = Convert.ToInt32(dr["id"]); pic.PoliticName = dr["politicname"].ToString(); list.Add(pic); } return(list); }
public static SystemManage GetSystemManage() { String sql = "select * from systemmanage "; DataTable dt = MySqlDBHelper.GetDataSet(sql); foreach (DataRow dr in dt.Rows) { SystemManage sm = new SystemManage(); sm.ID = Convert.ToInt32(dr["id"]); sm.TikuPwd = dr["tkpwd"].ToString(); sm.KaochangJilv = dr["kcjl"].ToString(); return(sm); } return(null); }
public static Pingjiabiaozhun GetPXBZbyId(int bzid) { String sql = "select * from pingjiabiaozhun where id=" + bzid; DataTable dt = MySqlDBHelper.GetDataSet(sql); Pingjiabiaozhun st = new Pingjiabiaozhun(); foreach (DataRow dr in dt.Rows) { st.Id = Convert.ToInt32(dr["id"].ToString()); st.Content = dr["content"].ToString(); st.CkScore = Convert.ToInt32(dr["ckscore"].ToString()); return(st); } return(null); }
public static List <Position> GetAllPosition() { String sql = "select * from gwposition"; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Position> list = new List <Position>(); foreach (DataRow dr in dt.Rows) { Position ps = new Position(); ps.Id = (int)dr["id"]; ps.PositionName = dr["positionname"].ToString(); list.Add(ps); } return(list); }
public static List <Xueli> GetAll() { String sql = "select * from Xueli"; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Xueli> list = new List <Xueli>(); foreach (DataRow dr in dt.Rows) { Xueli xl = new Xueli(); xl.ID = Convert.ToInt32(dr["id"]); xl.XueliName = dr["degreename"].ToString(); list.Add(xl); } return(list); }
//hhy public static List <Yingpinzhe> GetAllYingpinzheByZpAndParameters(int zpid = -1, bool in_zp = true, string ypzname = "", int depid = -1) { String sql = "select yingpinzhe.id as Id, " + "yingpinzhe.name as Name," + "department.departname as DepName," + "yingpinzhe.dutyname as DutyName, " + "xueli.degreename as DegreeName," + "yingpinzhe.jointime as JinTime," + "politic.politicname as PolName " + "from yingpinzhe,department,xueli,politic,zhaopin,zpfb,zpgw " + "where yingpinzhe.departid=department.id and department.bmstate=1 and yingpinzhe.ypzstate=1 " + " and zhaopin.zpfbid=zpfb.id and zhaopin.zpstate=1 and zhaopin.id= " + zpid + " " + " and zpfb.zpgwid=zpgw.id and zpfb.fbstate=1 " + " and yingpinzhe.zpfbid=zpfb.id " + " and yingpinzhe.xueli= xueli.id and yingpinzhe.politic=politic.id " + " and yingpinzhe.id not in (select distinct ypzid from yingpingzhezhaopin where zpid=" + zpid + ")"; if (ypzname != "") { sql += " and yingpinzhe.name='" + ypzname + "' "; } if (depid != -1) { sql += " and yingpinzhe.departid=" + depid; } sql += " order by department.id asc "; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Yingpinzhe> list = new List <Yingpinzhe>(); foreach (DataRow dr in dt.Rows) { Yingpinzhe ypz = new Yingpinzhe(); ypz.ID = (int)dr["Id"]; ypz.Name = dr["Name"].ToString(); DateTime date = (DateTime)dr["JinTime"]; ypz.JoinTime = date.ToShortDateString(); ypz.DepName = dr["DepName"].ToString(); ypz.XueliName = dr["DegreeName"].ToString(); ypz.PolName = dr["PolName"].ToString(); list.Add(ypz); } return(list); }
public static List <UserInfo> GetAllUserInfo() { String sql = "select * from userinfo"; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <UserInfo> list = new List <UserInfo>(); foreach (DataRow dr in dt.Rows) { UserInfo uifo = new UserInfo(); uifo.ID = Convert.ToInt32(dr["id"]); uifo.Username = dr["uname"].ToString(); uifo.Password = ""; list.Add(uifo); } return(list); }