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);
}
protected void SaveID_Click(object sender, EventArgs e)
{
if (zpitmid != -1)
{
if (ZPitemName.Value != "")
{
FTInterviewBLL.ZhaopinItemManage.UpdateZhaopinItemTitle(zpitmid, ZPitemName.Value);
Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
Response.Write("<script language=javascript>alert('更新成功！')</script>");
}
}
else
{
if (ZPitemName.Value != "")
{
ZhaopinItem zm = new ZhaopinItem();
zm.Title = ZPitemName.Value;
zm.PubTime = DateTime.Now.ToString();
zm.ZpitemState = 1;
FTInterviewBLL.ZhaopinItemManage.Add(zm);
Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
Response.Write("<script language=javascript>alert('添加成功！')</script>");
}
}
}
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 int Add(ZhaopinItem zp)
{
String sqlstr = "insert into zhaopinitem(title,pubtime,zpitemstate) values(@title,@pubtime,@zpitemstate)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@title", zp.Title));
para_list.Add(new MySqlParameter("@pubtime", zp.PubTime));
para_list.Add(new MySqlParameter("@zpitemstate", 1));
return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray()));
}
protected void BindData()
{
if (zpitmid != -1)
{
ZhaopinItem zm = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ZPitemName.Value = zm.Title;
}
else
{
ZPitemName.Value = "";
}
}
public static int Update(ZhaopinItem zpitem)
{
String sqlstr = "update zhaopinitem set title=@title,pubtime=@pubtime,zpitemstate=@zpitemstate where id=@id";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@id", zpitem.Id));
para_list.Add(new MySqlParameter("@title", zpitem.Title));
para_list.Add(new MySqlParameter("@pubtime", zpitem.PubTime));
para_list.Add(new MySqlParameter("@zpitemstate", zpitem.ZpitemState));
return(MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray()));
}
protected void BindData()
{
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
title_f.Text = zim.Title + "面试成绩";
//List<YingpinzheZhaopin> ls = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopinID(zpid);
List <YingpinzheZhaopin> ls = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopinItemID(zpitmid);
DataTable dt = new DataTable("msg");
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("bm_duty", typeof(string));
dt.Columns.Add("duty", typeof(string));
dt.Columns.Add("ypdep_pos", typeof(string));
dt.Columns.Add("yppos", typeof(string));
dt.Columns.Add("score", typeof(string));
dt.Columns.Add("info", typeof(string));
for (int i = 0; i < ls.Count; i++)
{
DataRow dr = dt.NewRow();
YingpinzheZhaopin t_ypzzp = ls[i];
dr["Id"] = t_ypzzp.ID;
dr["Name"] = t_ypzzp.YpzName;
dr["bm_duty"] = t_ypzzp.YpzDepName + "-" + t_ypzzp.YpzPosName;
dr["duty"] = t_ypzzp.YpzPosName;
dr["ypdep_pos"] = t_ypzzp.YpzYpDepName + "-" + t_ypzzp.YpzYpPosName;
dr["yppos"] = t_ypzzp.YpzYpPosName;
int sc = (int)FTInterviewBLL.PingfenManage.GetScoreSums(t_ypzzp.ID);
dr["score"] = sc + "";
if (sc < 60)
{
dr["info"] = "不及格";
}
else
{
dr["info"] = "";
}
dt.Rows.Add(dr);
}
MsjgGridview.DataSource = dt;
MsjgGridview.DataBind();
}
}
protected void BindData()
{
DataProcess.DepartmentBind(department);
DataProcess.PositionBind(Position, -1);
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ItemTitle.Text = zim.Title;
List <Zhaopin> ls = FTInterviewBLL.ZhaopinManage.GetAllZhaopinListInZpItemId(zpitmid);
MslbGridview.DataSource = ls;
AspNetPagerAskAnswer.RecordCount = ls.Count;
MslbGridview.DataBind();
}
}
protected void BindData()
{
DataProcess.DepartmentBind(department);
List <Yingpinzhe> ls = new List <Yingpinzhe>();
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ItemTitle.Text = zim.Title;
//ls = FTInterviewBLL.YingpinzheManage.GetAllYingpinzhe();
ls = FTInterviewBLL.YingpinzheManage.GetAllYingpinzheInZpItem(zpitmid);
}
YpzGridview.DataSource = ls;
AspNetPagerAskAnswer.RecordCount = ls.Count;
YpzGridview.DataBind();
}
protected void BindData()
{
DataProcess.DepartmentBind(department);
DataProcess.PositionBind(Position, Convert.ToInt32(department.SelectedValue));
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ItemTitle.Text = zim.Title;
DataTable dt = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheResultInzhaopinItemId(zpitmid);
MslbGridview.DataSource = dt;
AspNetPagerAskAnswer.RecordCount = dt.Rows.Count;
MslbGridview.DataBind();
}
}
protected void BindData()
{
DataProcess.DepartmentBind(department);
DataProcess.PositionBind(Position, Convert.ToInt32(department.SelectedValue));
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
if (zim != null)
{
ItemTitle.Text = zim.Title;
}
//List<Zhaopin> zpls=FTInterviewBLL.ZhaopinManage.GetAllZhaopinListByparameters();
List <Zhaopin> zpls = FTInterviewBLL.ZhaopinManage.GetAllZhaopinListInZpItemId(zpitmid);
MslbGridview.DataSource = zpls;
AspNetPagerAskAnswer.RecordCount = zpls.Count;
MslbGridview.DataBind();
}
public static ZhaopinItem GetZhaopinItemById(int zpitemid)
{
string sqlstr = "select zhaopinitem.id as Id," +
"zhaopinitem.title as Title," +
"zhaopinitem.pubtime as PubTime from zhaopinitem " +
" where zhaopinitem.zpitemstate=1 and id=" + zpitemid +
" order by PubTime desc";
DataTable dt = MySqlDBHelper.GetDataSet(sqlstr);
ZhaopinItem zpitm = new ZhaopinItem();
foreach (DataRow dr in dt.Rows)
{
zpitm.Id = Convert.ToInt32(dr["Id"].ToString());
zpitm.Title = dr["Title"].ToString();
zpitm.PubTime = dr["PubTime"].ToString();
return(zpitm);
}
return(null);
}
protected void BindData(int bmid = -1)
{
DataProcess.DepartmentBind(department);
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ItemTitle.Text = zim.Title;
if (bmid != -1)
{
department.SelectedValue = bmid + "";
}
string gn = gwName.Value;
//DataTable dt = FTInterviewBLL.ZhaopinFbManage.GetAllZhaopinFb(bmid, gn);
DataTable dt = FTInterviewBLL.ZhaopinFbManage.GetAllZhaopinFbInItem(bmid, gn, zpitmid);
ZpgwGridview.DataSource = dt;
AspNetPagerAskAnswer.RecordCount = dt.Rows.Count;
ZpgwGridview.DataBind();
}
}
protected void BindData()
{
DataProcess.DepartmentBind(department);
HttpCookie c*k = Request.Cookies["ftcook"];
if (c*k != null)
{
zpitmid = Convert.ToInt32(c*k["zpitmid"].ToString());
}
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ItemTitle.Text = zim.Title;
DataTable dt = FTInterviewBLL.ZhaopinManage.GetAllZhaopinListInItemIdByKaoguan(zpitmid, msgid);
MslbGridview.DataSource = dt;
AspNetPagerAskAnswer.RecordCount = dt.Rows.Count;
MslbGridview.DataBind();
}
}
public static int AddReturnID(ZhaopinItem zp)
{
String sql = "select uuid()";
string uni_str = "";
while (true)
{
DataTable dt = MySqlDBHelper.GetDataSet(sql);
if (dt.Rows.Count == 1)
{
uni_str = dt.Rows[0][0].ToString();
dt.Clear();
break;
}
}
String sqlstr = "insert into zhaopinitem(title,pubtime,zpitemstate,identifg) values(@title,@pubtime,@zpitemstate,@identifg)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@title", zp.Title));
para_list.Add(new MySqlParameter("@pubtime", zp.PubTime));
para_list.Add(new MySqlParameter("@zpitemstate", 1));
para_list.Add(new MySqlParameter("@identifg", uni_str));
MySqlDBHelper.ExecuteCommand(sqlstr, para_list.ToArray());
sqlstr = "select id from zhaopinitem where identifg='" + uni_str + "'";
DataTable resdt = MySqlDBHelper.GetDataSet(sqlstr);
int id = -1;
if (resdt.Rows.Count > 0)
{
id = Convert.ToInt32(resdt.Rows[0]["id"]);
}
return(id);
}
protected void BindData()
{
DataProcess.DepartmentBind(department);
DataProcess.PositionBind(Position, -1);
HttpCookie c*k = Request.Cookies["ftcook"];
if (c*k != null)
{
zpitmid = Convert.ToInt32(c*k["zpitmid"]);
}
if (zpitmid != -1)
{
ZhaopinItem zim = FTInterviewBLL.ZhaopinItemManage.GetZhaopinItemById(zpitmid);
ItemTitle.Text = zim.Title;
List <Zhaopin> ls = FTInterviewBLL.ZhaopinManage.GetAllZhaopinListInZpItemId(zpitmid);
MslbGridview.DataSource = ls;
AspNetPagerAskAnswer.RecordCount = ls.Count;
MslbGridview.DataBind();
}
}
public static int Update(ZhaopinItem zpitem)
{
return(FTInterviewDAL.ZhaopinItemService.Update(zpitem));
}
public static int AddReturnID(ZhaopinItem zp)
{
return(FTInterviewDAL.ZhaopinItemService.AddReturnID(zp));
}
