private void BindData() { if (bzid != -1) { Pingjiabiaozhun pjz = FTInterviewBLL.PingjiabiaozhunManage.GetPXBZbyId(bzid); myEditor.Value = pjz.Content; } }
public static int Update(Pingjiabiaozhun pjbz) { String sql = "update pingjiabiaozhun set content=@content,ckscore=@ckscore where id=@id"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@id", pjbz.Id)); para_list.Add(new MySqlParameter("@content", pjbz.Content)); para_list.Add(new MySqlParameter("@score", pjbz.CkScore)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static int Add(Pingjiabiaozhun pjbz) { String sql = "insert into pingjiabiaozhun(content,pjxdid,ckscore) values(@content,@pjxdid,@ckscore)"; List <MySqlParameter> para_list = new List <MySqlParameter>(); para_list.Add(new MySqlParameter("@content", pjbz.Content)); para_list.Add(new MySqlParameter("@pjxdid", pjbz.PjxdID)); para_list.Add(new MySqlParameter("@ckscore", pjbz.CkScore)); return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray())); }
public static Pingjiabiaozhun GetPXBZbyId(int bzid) { String sql = "select * from pingjiabiaozhun where id=" + bzid; DataTable dt = MySqlDBHelper.GetDataSet(sql); Pingjiabiaozhun st = new Pingjiabiaozhun(); foreach (DataRow dr in dt.Rows) { st.Id = Convert.ToInt32(dr["id"].ToString()); st.Content = dr["content"].ToString(); st.CkScore = Convert.ToInt32(dr["ckscore"].ToString()); return(st); } return(null); }
public static List <Pingjiabiaozhun> GetAll() { String sql = "select * from pingjiabiaozhun "; DataTable dt = MySqlDBHelper.GetDataSet(sql); List <Pingjiabiaozhun> list = new List <Pingjiabiaozhun>(); foreach (DataRow dr in dt.Rows) { Pingjiabiaozhun st = new Pingjiabiaozhun(); st.Id = Convert.ToInt32(dr["id"].ToString()); st.Content = dr["content"].ToString(); st.CkScore = Convert.ToInt32(dr["ckscore"].ToString()); st.PjxdID = Convert.ToInt32(dr["pjxdid"].ToString()); list.Add(st); } return(list); }
protected void Save_Click(object sender, EventArgs e) { Pingjiabiaozhun pbz = new Pingjiabiaozhun(); pbz.Content = myEditor.Value; pbz.PjxdID = 1; pbz.CkScore = 100; if (bzid != -1) { // if (ScoreValue.Value != null && ScoreValue.Value != "") { try { pbz.Id = bzid; FTInterviewBLL.PingjiabiaozhunManage.Update(pbz); 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 (System.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('输入不合法!')</script>"); } } } else { // if (ScoreValue.Value != null && ScoreValue.Value != "") { try { FTInterviewBLL.PingjiabiaozhunManage.Add(pbz); 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 (System.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('输入不合法!')</script>"); } } } }
public static int Update(Pingjiabiaozhun pjbz) { return(FTInterviewDAL.PingjiabiaozhunService.Update(pjbz)); }
public static int Add(Pingjiabiaozhun pz) { return(FTInterviewDAL.PingjiabiaozhunService.Add(pz)); }