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