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 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 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()));
}
public static int Add(Pingfen pinfen)
{
String sql = "insert into pingfen(ypzzpid,kgzpid,shitiid,xdbzid,chengji,pfstate) values(@ypzzpid,@kgzpid,@shitiid,@xdbzid,@chengji,@pfstate)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@ypzzpid", pinfen.YpzzpID));
para_list.Add(new MySqlParameter("@kgzpid", pinfen.KgzpID));
para_list.Add(new MySqlParameter("@shitiid", pinfen.ShitiID));
para_list.Add(new MySqlParameter("@xdbzid", pinfen.XdbzID));
para_list.Add(new MySqlParameter("@chengji", pinfen.Score));
para_list.Add(new MySqlParameter("@pfstate", 1));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static int batchUpdate(List <Pingfen> pinfenList)
{
if (pinfenList.Count < 1)
{
return(0);
}
String sql = "";
for (int i = 0; i < pinfenList.Count; i++)
{
Pingfen pingfen = pinfenList[i];
sql += " update pingfen set chengji=" + pingfen.Score + " where id=" + pingfen.Id + " ;";
}
/*
*
* String sql = "insert into pingfen(id,chengji) values ";
* StringBuilder sb=new StringBuilder();
* sb.Append(sql);
*
* for (int i=0; i<pinfenList.Count; i++ )
* {
* Pingfen pingfen=pinfenList[i];
* sb.Append("(").
* Append(pingfen.Id).Append(",").
* Append(pingfen.Score).Append(")");
* if (i < pinfenList.Count-1)
* {
* sb.Append(",");
* }
* }
* sb.Append(" ON DUPLICATE KEY UPDATE chengji=VALUES(chengji);");
*/
return(MySqlDBHelper.ExecuteCommand(sql));
}
public static int Update(Pingfen pf)
{
return(FTInterviewDAL.PingfenService.Update(pf));
}
public static int Add(Pingfen pf)
{
return(FTInterviewDAL.PingfenService.Add(pf));
}
protected void BindData()
{
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"]);
}
List <Shiti> sls = FTInterviewBLL.ShitiManage.GetAllShitiByKaotiId(kaotiid);
GridView1.DataSource = sls;
GridView1.DataBind();
if (sls.Count < 1)
{
submitButton.Visible = false;
//NextButton.Visible = false;
}
List <Pingjiaxiangdian> ps = FTInterviewBLL.PingjiaxiangdianManage.GetAll();
List <Pingjiabiaozhun> pz = FTInterviewBLL.PingjiabiaozhunManage.GetAll();
List <Xiangdianbiaozhun> xdbzls = FTInterviewBLL.XiangdianBiaozhunManage.GetAll();
xdn = ps.Count;
bzn = pz.Count;
sn = sls.Count;
if (!flag)
{
for (int i = 1; i <= sls.Count; i++)
{
shitils.Add(i, sls[i - 1].Id);
}
for (int i = 1; i <= ps.Count; i++)
{
xdls.Add(i, ps[i - 1]);
}
flag = true;
}
DataTable dt = new DataTable("msg");
dt.Columns.Add("pjxd", typeof(string));
for (int i = 1; i <= bzn; i++)
{
dt.Columns.Add("bz" + i, typeof(string));
}
for (int i = 1; i <= sn; i++)
{
dt.Columns.Add("ti" + i, typeof(string));
}
DataRow dr = dt.NewRow();
dr["pjxd"] = "项点";
for (int i = 1; i <= bzn; i++)
{
dr["bz" + i] = pz[i - 1].Content;
}
for (int i = 1; i <= sn; i++)
{
dr["ti" + i] = "第" + i + "题";
}
dt.Rows.Add(dr);
foreach (Pingjiaxiangdian pd in ps)
{
dr = dt.NewRow();
dr["pjxd"] = pd.Content;
dt.Rows.Add(dr);
}
ScoreDetail.DataSource = dt;
ScoreDetail.DataBind();
int ide = 0;
for (int ri = 1; ri <= xdn; ri++)
{
for (int ci = 1; ci <= bzn; ci++)
{
Label t_text = new Label();
t_text.Text = xdbzls[ide].MyContent;
ide++;
ScoreDetail.Rows[ri].Cells[ci].Controls.Add(t_text);
}
}
for (int ri = 1; ri <= xdls.Count; ri++)
{
for (int ci = bzn + 1; ci < bzn + 1 + sn; ci++)
{
DropDownList dl = new DropDownList();
dl.ID = ri + "DropDownList" + ci;
dl.Width = 60;
int stid = shitils[ci - bzn];
int xdid = xdls[ri].Id;
Pingfen p = FTInterviewBLL.PingfenManage.GetPfByParameter(kgzpid, ypzzpid, stid, xdid);
if (p != null)
{
DataProcess.ScoreBind(dl, xdls[ri].Score, p.Score);
}
else
{
DataProcess.ScoreBind(dl, xdls[ri].Score, -1);
}
dl.Attributes.Add("onchange", "auto_submit()");
ScoreDetail.Rows[ri].Cells[ci].Controls.Add(dl);
}
}
}
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>");
}
