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 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); }
protected void DataBind(int tid = -1) { if (tid != -1)//chuan zhi { Shiti st = FTInterviewBLL.ShitiManage.GetShitiById(tid); AnsTime.Value = st.StTime + ""; StWeight.Value = st.Weight + ""; myEditor.Value = st.Question; } }
public static int Add(Shiti shiti) { String sql = "insert into shiti(question,ktid,ktindex,weight,sttime) values(@question,@ktid,@ktindex,@weight,@sttime)"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@question", shiti.Question)); para_list.Add(new MySqlParameter("@ktid", shiti.KaotiID)); para_list.Add(new MySqlParameter("@ktindex", shiti.KaotiIndex)); para_list.Add(new MySqlParameter("@weight", shiti.Weight)); para_list.Add(new MySqlParameter("@sttime", shiti.StTime)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int Update(Shiti st) { String sql = "update shiti set question=@question,weight=@weight,sttime=@sttime where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", st.Id)); para_list.Add(new MySqlParameter("@question", st.Question)); //para_list.Add(new MySqlParameter("@ktid", st.KaotiID)); para_list.Add(new MySqlParameter("@weight", st.Weight)); para_list.Add(new MySqlParameter("@sttime", st.StTime)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static List <Shiti> GetAllShiti() { String sql = "select shiti.id as Id,question,ktid,ktindex,weight,sttime from shiti,kaoti where shiti.ktid=kaoti.id 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 double GetScoreSums(int ypzzpid, int kgzpid = -1) { double sum = 0; if (kgzpid != -1) { string sql = "select pingfen.shitiid,pingfen.chengji from pingfen,yingpingzhezhaopin,yingpinzhe,kaoguanzhaopin,kaoguan,zhaopin,shiti " + " where pfstate=1 and ypzzpid=" + ypzzpid + " and kgzpid=" + kgzpid + " and pingfen.ypzzpid=yingpingzhezhaopin.id and pingfen.kgzpid=kaoguanzhaopin.id " + " and zhaopin.id=yingpingzhezhaopin.zpid and pingfen.shitiid=shiti.id and shiti.ktid=zhaopin.ktid " + " and yingpingzhezhaopin.ypzid=yingpinzhe.id and yingpinzhe.ypzstate=1 " + " and kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 "; DataTable dt = MySqlDBHelper.GetDataSet(sql); Dictionary <int, int> temp = new Dictionary <int, int>(); foreach (DataRow dr in dt.Rows) { int stid = Convert.ToInt32(dr["shitiid"]); int chengji = Convert.ToInt32(dr["chengji"]); if (!temp.ContainsKey(stid)) { temp.Add(stid, chengji); } else { temp[stid] += chengji; } } foreach (int k in temp.Keys) { Shiti st = ShitiService.GetShitiById(k); if (st != null) { int w = st.Weight; sum += temp[k] * w * 0.01; } } } else//获取全部 { string sql = "select pingfen.kgzpid as Kgzpid," + " pingfen.shitiid as ShitiId," + "pingfen.xdbzid as XdId," + "shiti.weight as Weight," + "kaoguanzhaopin.weight as KgWeight," + "pingfen.chengji as CJ " + "from pingfen,shiti,kaoguanzhaopin,kaoguan,yingpingzhezhaopin,yingpinzhe,zhaopin " + " where pingfen.pfstate=1 and pingfen.ypzzpid=" + ypzzpid + " and pingfen.shitiid=shiti.id and kaoguanzhaopin.id= pingfen.kgzpid" + " and zhaopin.id=yingpingzhezhaopin.zpid and pingfen.shitiid=shiti.id and shiti.ktid=zhaopin.ktid " + " and pingfen.ypzzpid=yingpingzhezhaopin.id " + " and yingpingzhezhaopin.ypzid=yingpinzhe.id and yingpinzhe.ypzstate=1 " + " and kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 "; DataTable dt = MySqlDBHelper.GetDataSet(sql); Dictionary <int, double> wei = new Dictionary <int, double>(); Dictionary <int, double> kgwei = new Dictionary <int, double>(); Dictionary <int, Dictionary <int, int> > _myres = new Dictionary <int, Dictionary <int, int> >(); foreach (DataRow dr in dt.Rows) { int kgzpid_t = Convert.ToInt32(dr["Kgzpid"]); int stid = Convert.ToInt32(dr["ShitiId"]); int xdid = Convert.ToInt32(dr["XdId"]); int chengji = Convert.ToInt32(dr["CJ"]); double weight_kg = Convert.ToDouble(dr["KgWeight"]); double weight_st = Convert.ToDouble(dr["Weight"]); if (!wei.ContainsKey(stid)) { wei.Add(stid, weight_st); } if (!kgwei.ContainsKey(kgzpid_t)) { kgwei.Add(kgzpid_t, weight_kg); } if (!_myres.ContainsKey(kgzpid_t)) { Dictionary <int, int> mt = new Dictionary <int, int>(); mt.Add(stid, chengji); _myres.Add(kgzpid_t, mt); } else { Dictionary <int, int> mt = _myres[kgzpid_t]; if (mt.ContainsKey(stid)) { mt[stid] += chengji; } else { mt.Add(stid, chengji); } } } foreach (int kgkeys in _myres.Keys) { double kgw = kgwei[kgkeys]; double sum_temp = 0; Dictionary <int, int> temp_sc = _myres[kgkeys]; foreach (int stkeys in temp_sc.Keys) { double stw = wei[stkeys]; sum_temp += stw * 0.01 * temp_sc[stkeys]; } sum += (0.01 * kgw * sum_temp); } } return(sum); }
//save protected void Save_Click(object sender, EventArgs e) { List <string> msg = new List <string>(); int ans_t = 0, wei_t = 0; //if(AnsTime.Value.Trim()=="" || ) { try { ans_t = Convert.ToInt32(AnsTime.Value); } catch (System.Exception ex) { msg.Add("请输入合法时间值!"); } } //if (StWeight.Value.Trim() == "") { try { wei_t = Convert.ToInt32(StWeight.Value); } catch (System.Exception ex) { msg.Add("请输入合法权重比例!"); } } if (msg.Count > 0) { 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('" + msg[0] + "')</script>"); } else { if (t_id != -1) { Shiti st = new Shiti(); st.StTime = ans_t; st.Weight = wei_t; st.Question = myEditor.Value;//myEditor.InnerHtml; st.Id = t_id; FTInterviewBLL.ShitiManage.Update(st); 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 (kt_id != -1) { Shiti st = new Shiti(); st.StTime = ans_t; st.Weight = wei_t; st.Question = myEditor.Value;//myEditor.InnerHtml; st.KaotiID = kt_id; FTInterviewBLL.ShitiManage.Add(st); 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 int Update(Shiti st) { return(FTInterviewDAL.ShitiService.Update(st)); }
public static int Add(Shiti shiti) { return(FTInterviewDAL.ShitiService.Add(shiti)); }