//submit
protected void SubmitButton_Click(object sender, EventArgs e)
{
try
{
string[] res = hdfWPBH.Value.Split(',');
for (int i = 0; i < res.Length - 1; i++)
{
int id_ypz = Convert.ToInt32(res[i]);
//更新
/* YingpinzheZhaopin ypzzp = new YingpinzheZhaopin();
* ypzzp.ID = id_ypz;
* ypzzp.SubmitState = 1;
* FTInterviewBLL.YingpinzheZhaopinManage.UpdateSubmitState(ypzzp);*/
YpzZhaopinkgzp yk = new YpzZhaopinkgzp();
yk.YpzzpID = id_ypz;
yk.KgzpID = kgzpid;
yk.KgYpzSubmitState = 1;
FTInterviewBLL.YpzZhaopinkgzpManage.UpdateSubmitStateByypzzpkgzp(yk);
}
BindData();
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>");
}
catch (Exception ex)
{
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('" + ex.ToString() + "！')</script>");
}
}
//save
protected void Button1_Click(object sender, EventArgs e)
{
if (id != -1)
{
List <YingpinzheZhaopin> ypzzpls = FTInterviewBLL.YingpinzheZhaopinManage.GetAllYingpinzheInzhaopinID(id);
List <KaoguanZhaopin> kgzpls = FTInterviewBLL.KaoguanZhaopinManage.GetKgZPbyzpId(id);
for (int i = 0; i < kgzpls.Count; i++)
{
int kgzpid = kgzpls[i].Id;
for (int j = 0; j < ypzzpls.Count; j++)
{
int ypzzpid = ypzzpls[j].ID;
YpzZhaopinkgzp coy = FTInterviewBLL.YpzZhaopinkgzpManage.GetByypzidkgid(ypzzpid, kgzpid);
if (coy == null)
{
YpzZhaopinkgzp temp = new YpzZhaopinkgzp();
temp.KgzpID = kgzpid;
temp.YpzzpID = ypzzpid;
temp.KgYpzSubmitState = 0;
FTInterviewBLL.YpzZhaopinkgzpManage.Add(temp);
}
else
{
coy.KgYpzSubmitState = 0;
FTInterviewBLL.YpzZhaopinkgzpManage.UpdateSubmitState(coy);
}
}
}
}
}
public static int UpdateSubmitState(YpzZhaopinkgzp ypzzpkgzp)
{
String sql = "update ypzkgsubmit set submitstate=@submitstate where id=@id";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@id", ypzzpkgzp.ID));
para_list.Add(new MySqlParameter("@submitstate", ypzzpkgzp.KgYpzSubmitState));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static int Add(YpzZhaopinkgzp ypzkg)
{
String sql = "insert into ypzkgsubmit(ypzzpid,kgzpid,submitstate) values(@ypzzpid,@kgzpid,@submitstate)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@ypzzpid", ypzkg.YpzzpID));
para_list.Add(new MySqlParameter("@kgzpid", ypzkg.KgzpID));
para_list.Add(new MySqlParameter("@submitstate", ypzkg.KgYpzSubmitState));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static YpzZhaopinkgzp GetByID(int id)
{
String sql = "select ypzkgsubmit.id as Id," +
"ypzkgsubmit.ypzzpid as YpzzpID," +
"ypzkgsubmit.kgzpid as KgzpID," +
"ypzkgsubmit.submitstate as SubmitState," +
" from ypzkgsubmit" +
" where ypzkgsubmit.id= " + id;
DataTable dt = MySqlDBHelper.GetDataSet(sql);
foreach (DataRow dr in dt.Rows)
{
YpzZhaopinkgzp t = new YpzZhaopinkgzp();
t.ID = Convert.ToInt32(dr["Id"].ToString());
t.KgzpID = Convert.ToInt32(dr["KgzpID"].ToString());
t.YpzzpID = Convert.ToInt32(dr["YpzzpID"].ToString());
t.KgYpzSubmitState = Convert.ToInt32(dr["SubmitState"].ToString());
return(t);
}
return(null);
}
public static int UpdateSubmitStateByypzzpkgzp(YpzZhaopinkgzp ypzzpkgzp)
{
return(FTInterviewDAL.YpzheZhaopinkgzpService.UpdateSubmitStateByypzzpkgzp(ypzzpkgzp));
}
public static int Add(YpzZhaopinkgzp ypzzpkgzp)
{
return(FTInterviewDAL.YpzheZhaopinkgzpService.Add(ypzzpkgzp));
}
protected void SaveButton_Click(object sender, EventArgs e)
{
logger.Info("SaveButton_Click - start");
HttpCookie c*k = Request.Cookies["ftcook"];
if (c*k != null)
{
ypzzpid = Convert.ToInt32(c*k["ypzzpid"]);
kgzpid = Convert.ToInt32(c*k["kgzpid"]);
kaotiid = Convert.ToInt32(c*k["kaotiid"]);
logger.Info("SaveButton_Click - info, ypzzpid:" + ypzzpid + " ,kgzpid:" + kgzpid + ",kaotiid: " + kaotiid);
}
if (kaotiid == -1 || ypzzpid == -1 || kgzpid == -1)
{
Response.Redirect("../login.aspx");
}
logger.Info("SaveButton_Click - info1");
List <Pingfen> pfList = new List <Pingfen>();
List <Pingfen> updatePfList = new List <Pingfen>();
logger.Info("SaveButton_Click - info1," + "xdls.Count:" + xdls.Count + ", bzn: " + bzn);
for (int ri = 1; ri <= xdls.Count; ri++)
{
for (int ci = bzn + 1; ci < bzn + sn + 1; ci++)
{
int nn = ScoreDetail.Rows[ri].Cells[ci].Controls.Count;
DropDownList dl = (DropDownList)ScoreDetail.Rows[ri].Cells[ci].Controls[0];
int vale = dl.SelectedIndex - 1;
if (vale != -1)
{
int stid = shitils[ci - bzn];
int xdid = xdls[ri].Id;
Pingfen pf = FTInterviewBLL.PingfenManage.GetPfByParameter(kgzpid, ypzzpid, stid, xdid);
if (pf != null)
{
pf.Score = vale;
//FTInterviewBLL.PingfenManage.Update(pf);
updatePfList.Add(pf);
}
else
{
pf = new Pingfen();
pf.KgzpID = kgzpid;
pf.YpzzpID = ypzzpid;
pf.ShitiID = stid;
pf.XdbzID = xdid;
pf.Score = vale;
// FTInterviewBLL.PingfenManage.Add(pf);
pfList.Add(pf);
}
}
}
}
logger.Info("SaveButton_Click - info1," + "pfList:" + pfList + ", updatePfList: " + updatePfList);
FTInterviewBLL.PingfenManage.batchAdd(pfList);
FTInterviewBLL.PingfenManage.batchUpdate(updatePfList);
YpzZhaopinkgzp yk = new YpzZhaopinkgzp();
yk.YpzzpID = ypzzpid;
yk.KgzpID = kgzpid;
yk.KgYpzSubmitState = 0;
FTInterviewBLL.YpzZhaopinkgzpManage.UpdateSubmitStateByypzzpkgzp(yk);
// 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>");
//Response.Write("<script language=javascript>alert('操作成功！');self.location='index.aspx'; </script>");
}
