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