/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"]) { Response.Write("<script language=JavaScript>;parent.location.href='../Login.aspx';</script>"); Response.End(); } DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); Model.SP.SP_Category modelAdd = new Model.SP.SP_Category { ID = Guid.NewGuid().ToString("N").ToUpper(), //文章标题 Name = this.txtTitle.Text, SiteCode = Session["strSiteCode"].ToString() }; if (dal.InsertInfo(modelAdd) > 0) { strMessage = "商品分类添加成功!"; } else { strMessage = "商品分类添加失败!"; } MessageBox.Show(this, strMessage); }
protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(Session["strSiteCode"].ToString()) && Session["strRoleCode"].ToString() != "ADMIN") { Response.Write("<script language=JavaScript>;parent.location.href='../Login.aspx';</script>"); Response.End(); } if (!IsPostBack) { this.ddlCategory.Items.Clear(); DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); DataSet ds = new DataSet(); if (Session["strRoleCode"].ToString() == "ADMIN") { ds = dal.GetSPCategory(""); } else { ds = dal.GetSPCategory(" SiteCode ='" + Session["strSiteCode"].ToString() + "' "); } DataTable dt = ds.Tables[0]; DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = "0"; dr["Name"] = "--全部--"; dt.Rows.InsertAt(dr, 0); this.ddlCategory.DataSource = ds.Tables[0].DefaultView; this.ddlCategory.DataTextField = "Name"; this.ddlCategory.DataValueField = "ID"; this.ddlCategory.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); switch (strAction) { case "del": if (dal.UpdateSPCategoryState(strID)) { strMessage = "删除商品分类完成!"; } else { strMessage = "删除商品分类失败!"; } break; default: break; } Response.Write(strMessage); Response.End(); }
public void ShowSPCategoryInfo(string strID) { DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); DataSet ds = dal.GetSPCategoryDetail(strID); Model.SP.SP_Category model = DataConvert.DataRowToModel <Model.SP.SP_Category>(ds.Tables[0].Rows[0]); this.txtTitle.Text = model.Name; }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); DataSet ds = dal.GetSPCategory(strWhere); DataView dv = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; Repeater1.DataSource = pds; Repeater1.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"]) { Response.Write("<script language=JavaScript>;parent.location.href='../Login.aspx';</script>"); Response.End(); } DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); Model.SP.SP_Category modelUpdate = new Model.SP.SP_Category { ID = strID, Name = this.txtTitle.Text }; if (dal.UpdateSPCategoryData(modelUpdate)) { MessageBox.Show(this, "修改成功!"); } else { MessageBox.Show(this, "修改失败!"); } }
const string vsKey = "searchCriteria"; //ViewState key /// <summary> /// 页面加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.ddlCategory.Items.Clear(); DAL.Product.CategoryDAL dal = new DAL.Product.CategoryDAL(); DataSet ds = new DataSet(); if (Session["strRoleCode"].ToString() == "ADMIN") { ds = dal.GetSPCategory(""); } else { ds = dal.GetSPCategory(" SiteCode ='" + Session["strSiteCode"].ToString() + "' "); } DataTable dt = ds.Tables[0]; DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = "0"; dr["Name"] = "--全部--"; dt.Rows.InsertAt(dr, 0); this.ddlCategory.DataSource = ds.Tables[0].DefaultView; this.ddlCategory.DataTextField = "Name"; this.ddlCategory.DataValueField = "ID"; this.ddlCategory.DataBind(); AspNetPager1.CurrentPageIndex = 1; string s = ""; if (Session["strRoleCode"].ToString() != "ADMIN") { s = " a.SiteCode = '" + Session["strSiteCode"].ToString() + "' "; } ViewState[vsKey] = s; LoadData(s); } }