private void doPost() { string cname = Request["cname"]; light.BLL.leftmenu bll = new light.BLL.leftmenu(); light.Model.leftmenu model = new light.Model.leftmenu(); model.addtime = DateTime.Now; model.cnname = cname; model.enname = light.Common.Hz2Py.Convert(cname); model.isopen = 1; model.parentid = int.Parse(ViewState["pid"].ToString()); bll.Add(model); WebMessageBox.ShowMessageBox("添加成功", this); }
private void doPost() { string cname = Request["cname"]; light.BLL.leftmenu bll = new light.BLL.leftmenu(); if (!bll.Exists(cname)) { model = bll.GetModel(int.Parse(ViewState["pid"].ToString())); model.cnname = cname; bll.Update(model); WebMessageBox.ShowMessageBox("修改成功", this); } else { WebMessageBox.ShowMessageBox("该菜单名已经存在", this); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int pid = light.Common.DNTRequest.GetQueryInt("pid", 0); if (pid > 0) { ViewState["pid"] = pid.ToString(); model = new light.BLL.leftmenu().GetModel(pid); } } else { doPost(); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public light.Model.leftmenu GetModel(int pkid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select * from leftmenu "); strSql.Append(" where pkid=@pkid "); OleDbParameter[] parameters = { new OleDbParameter("@pkid", OleDbType.Integer,4)}; parameters[0].Value = pkid; light.Model.leftmenu model=new light.Model.leftmenu(); DataSet ds=DbHelperOleDb.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["pkid"].ToString()!="") { model.pkid=int.Parse(ds.Tables[0].Rows[0]["pkid"].ToString()); } model.cnname=ds.Tables[0].Rows[0]["cname"].ToString(); model.enname=ds.Tables[0].Rows[0]["ename"].ToString(); if(ds.Tables[0].Rows[0]["parentid"].ToString()!="") { model.parentid=int.Parse(ds.Tables[0].Rows[0]["parentid"].ToString()); } if(ds.Tables[0].Rows[0]["isopen"].ToString()!="") { model.isopen=int.Parse(ds.Tables[0].Rows[0]["isopen"].ToString()); } if(ds.Tables[0].Rows[0]["addtime"].ToString()!="") { model.addtime=DateTime.Parse(ds.Tables[0].Rows[0]["addtime"].ToString()); } model.c_description = ds.Tables[0].Rows[0]["c_description"].ToString(); model.k_description = ds.Tables[0].Rows[0]["k_description"].ToString(); model.e_description = ds.Tables[0].Rows[0]["e_description"].ToString(); return model; } else { return null; } }