protected void PrepareForm() { if (type == "ADD") { if (Request.QueryString["parent"] == null || Request.QueryString["parent"] == "") { Response.Redirect("../Error.aspx?msg="); return; } ViewState["parent"] = Request.QueryString["parent"]; fieldset1.Style["display"] = ""; fieldset2.Style["display"] = ""; } else if (type == "EDIT") { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { try { SysNo = int.Parse(Request.QueryString["id"]); CMS_CategoryMod m_cate = CMS_CategoryBll.GetInstance().GetModel(SysNo); ltrParent.Text = ""; txtName.Text = m_cate.Name; drpHide.SelectedIndex = drpHide.Items.IndexOf(drpHide.Items.FindByValue(m_cate.IsHide.ToString())); drpStatus.SelectedIndex = drpStatus.Items.IndexOf(drpStatus.Items.FindByValue(m_cate.DR.ToString())); DataTable m_child = CMS_CategoryBll.GetInstance().GetCatesForAdmin(SysNo); rptFamous.DataSource = m_child; rptFamous.DataBind(); if (m_cate.ParentSysNo != 0) { CMS_CategoryMod m_parent = CMS_CategoryBll.GetInstance().GetModel(m_cate.ParentSysNo); ltrParent.Text = m_parent.Name + "—" + m_cate.Name; } else { ltrParent.Text = "此分类为一级分类"; } fieldset1.Style["display"] = ""; fieldset2.Style["display"] = ""; } catch { Response.Redirect("../Error.aspx?msg="); return; } } } else if (type == "TOP") { DataTable m_child = CMS_CategoryBll.GetInstance().GetCatesForAdmin(0); rptFamous.DataSource = m_child; rptFamous.DataBind(); fieldset1.Style["display"] = "none"; fieldset2.Style["display"] = "none"; } }
protected void Unnamed1_Click(object sender, EventArgs e) { CMS_CategoryMod m_cate = new CMS_CategoryMod(); if (type == "EDIT") { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { SysNo = int.Parse(Request.QueryString["id"]); } m_cate = CMS_CategoryBll.GetInstance().GetModel(SysNo); try { m_cate.Name = txtName.Text.Trim(); m_cate.IsHide = int.Parse(drpHide.SelectedValue); m_cate.DR = int.Parse(drpStatus.SelectedValue); CMS_CategoryBll.GetInstance().Update(m_cate); LogManagement.getInstance().WriteTrace(m_cate.SysNo, "CMS.Category.Update", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); ltrNotice.Text = "该记录已保存成功!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true); } catch { ltrError.Text = "输入资料格式有误,请检查!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); return; } } else if (type == "ADD") { try { m_cate.Name = txtName.Text.Trim(); m_cate.IsHide = int.Parse(drpHide.SelectedValue); m_cate.DR = int.Parse(drpStatus.SelectedValue); m_cate.TS = DateTime.Now; m_cate.ParentSysNo = Convert.ToInt32(ViewState["parent"]); m_cate.TopSysNo = CMS_CategoryBll.GetInstance().GetModel(Convert.ToInt32(ViewState["parent"])).TopSysNo; CMS_CategoryBll.GetInstance().Add(m_cate); LogManagement.getInstance().WriteTrace(m_cate.SysNo, "CMS.Category.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); ltrNotice.Text = "该记录已保存成功!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true); } catch { ltrError.Text = "输入资料格式有误,请检查!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); return; } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CMS_CategoryMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMS_Category("); strSql.Append("Name,ParentSysNo,TopSysNo,IsHide,DR,TS)"); strSql.Append(" values ("); strSql.Append("@Name,@ParentSysNo,@TopSysNo,@IsHide,@DR,@TS)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@Name",SqlDbType.NVarChar,200), new SqlParameter("@ParentSysNo",SqlDbType.Int,4), new SqlParameter("@TopSysNo",SqlDbType.Int,4), new SqlParameter("@IsHide",SqlDbType.TinyInt,1), new SqlParameter("@DR",SqlDbType.TinyInt,1), new SqlParameter("@TS",SqlDbType.DateTime), }; if (model.Name != AppConst.StringNull) parameters[0].Value = model.Name; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.ParentSysNo != AppConst.IntNull) parameters[1].Value = model.ParentSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.TopSysNo != AppConst.IntNull) parameters[2].Value = model.TopSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.IsHide != AppConst.IntNull) parameters[3].Value = model.IsHide; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.DR != AppConst.IntNull) parameters[4].Value = model.DR; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.TS != AppConst.DateTimeNull) parameters[5].Value = model.TS; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); return SqlHelper.ExecuteNonQuery(cmd, parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public CMS_CategoryMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, Name, ParentSysNo, TopSysNo, IsHide, DR, TS from CMS_Category"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4) }; parameters[0].Value = SysNo; CMS_CategoryMod model = new CMS_CategoryMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); if (ds.Tables[0].Rows[0]["ParentSysNo"].ToString() != "") { model.ParentSysNo = int.Parse(ds.Tables[0].Rows[0]["ParentSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["TopSysNo"].ToString() != "") { model.TopSysNo = int.Parse(ds.Tables[0].Rows[0]["TopSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["IsHide"].ToString() != "") { model.IsHide = int.Parse(ds.Tables[0].Rows[0]["IsHide"].ToString()); } if (ds.Tables[0].Rows[0]["DR"].ToString() != "") { model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CMS_CategoryMod model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(CMS_CategoryMod model) { dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(CMS_CategoryMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CMS_Category set "); strSql.Append("Name=@Name,"); strSql.Append("ParentSysNo=@ParentSysNo,"); strSql.Append("TopSysNo=@TopSysNo,"); strSql.Append("IsHide=@IsHide,"); strSql.Append("DR=@DR,"); strSql.Append("TS=@TS"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo",SqlDbType.Int,4), new SqlParameter("@Name",SqlDbType.NVarChar,200), new SqlParameter("@ParentSysNo",SqlDbType.Int,4), new SqlParameter("@TopSysNo",SqlDbType.Int,4), new SqlParameter("@IsHide",SqlDbType.TinyInt,1), new SqlParameter("@DR",SqlDbType.TinyInt,1), new SqlParameter("@TS",SqlDbType.DateTime) }; if (model.SysNo != AppConst.IntNull) parameters[0].Value = model.SysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.Name != AppConst.StringNull) parameters[1].Value = model.Name; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.ParentSysNo != AppConst.IntNull) parameters[2].Value = model.ParentSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.TopSysNo != AppConst.IntNull) parameters[3].Value = model.TopSysNo; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.IsHide != AppConst.IntNull) parameters[4].Value = model.IsHide; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.DR != AppConst.IntNull) parameters[5].Value = model.DR; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); if (model.TS != AppConst.DateTimeNull) parameters[6].Value = model.TS; else parameters[6].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[6]); return SqlHelper.ExecuteNonQuery(cmd, parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public CMS_CategoryMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, Name, ParentSysNo, TopSysNo, IsHide, DR, TS from CMS_Category"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int,4 ) }; parameters[0].Value = SysNo; CMS_CategoryMod model = new CMS_CategoryMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); if (ds.Tables[0].Rows[0]["ParentSysNo"].ToString() != "") { model.ParentSysNo = int.Parse(ds.Tables[0].Rows[0]["ParentSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["TopSysNo"].ToString() != "") { model.TopSysNo = int.Parse(ds.Tables[0].Rows[0]["TopSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["IsHide"].ToString() != "") { model.IsHide = int.Parse(ds.Tables[0].Rows[0]["IsHide"].ToString()); } if (ds.Tables[0].Rows[0]["DR"].ToString() != "") { model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } return model; } else { return null; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CMS_CategoryMod model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CMS_CategoryMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMS_Category("); strSql.Append("Name,ParentSysNo,TopSysNo,IsHide,DR,TS)"); strSql.Append(" values ("); strSql.Append("@Name,@ParentSysNo,@TopSysNo,@IsHide,@DR,@TS)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 200), new SqlParameter("@ParentSysNo", SqlDbType.Int, 4), new SqlParameter("@TopSysNo", SqlDbType.Int, 4), new SqlParameter("@IsHide", SqlDbType.TinyInt, 1), new SqlParameter("@DR", SqlDbType.TinyInt, 1), new SqlParameter("@TS", SqlDbType.DateTime), }; if (model.Name != AppConst.StringNull) { parameters[0].Value = model.Name; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.ParentSysNo != AppConst.IntNull) { parameters[1].Value = model.ParentSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.TopSysNo != AppConst.IntNull) { parameters[2].Value = model.TopSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.IsHide != AppConst.IntNull) { parameters[3].Value = model.IsHide; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.DR != AppConst.IntNull) { parameters[4].Value = model.DR; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.TS != AppConst.DateTimeNull) { parameters[5].Value = model.TS; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(CMS_CategoryMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CMS_Category set "); strSql.Append("Name=@Name,"); strSql.Append("ParentSysNo=@ParentSysNo,"); strSql.Append("TopSysNo=@TopSysNo,"); strSql.Append("IsHide=@IsHide,"); strSql.Append("DR=@DR,"); strSql.Append("TS=@TS"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 200), new SqlParameter("@ParentSysNo", SqlDbType.Int, 4), new SqlParameter("@TopSysNo", SqlDbType.Int, 4), new SqlParameter("@IsHide", SqlDbType.TinyInt, 1), new SqlParameter("@DR", SqlDbType.TinyInt, 1), new SqlParameter("@TS", SqlDbType.DateTime) }; if (model.SysNo != AppConst.IntNull) { parameters[0].Value = model.SysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.Name != AppConst.StringNull) { parameters[1].Value = model.Name; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.ParentSysNo != AppConst.IntNull) { parameters[2].Value = model.ParentSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.TopSysNo != AppConst.IntNull) { parameters[3].Value = model.TopSysNo; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.IsHide != AppConst.IntNull) { parameters[4].Value = model.IsHide; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.DR != AppConst.IntNull) { parameters[5].Value = model.DR; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.TS != AppConst.DateTimeNull) { parameters[6].Value = model.TS; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }