/// <summary> /// 得到一个对象实体 /// </summary> public ECommerce.CM.Model.CMArticleType DataRowToModel(DataRow row) { ECommerce.CM.Model.CMArticleType model = new ECommerce.CM.Model.CMArticleType(); if (row != null) { if (row["ATId"] != null && row["ATId"].ToString() != "") { model.ATId = Convert.ToInt32(row["ATId"].ToString()); } if (row["ATName"] != null) { model.ATName = row["ATName"].ToString(); } if (row["DisplayCss"] != null) { model.DisplayCss = row["DisplayCss"].ToString(); } if (row["ColorValue"] != null) { model.ColorValue = row["ColorValue"].ToString(); } } return model; }
ECommerce.CM.DAL.CMArticle aDAL = new ECommerce.CM.DAL.CMArticle(); //创建商品品牌DAL对象 protected void Page_Load(object sender, EventArgs e) { //VerifyPage("", false); if (!IsPostBack) { var ATId = Request.QueryString["ATId"]; //编辑分类Id var detATId = Request.QueryString["detATId"]; //删除商品分类Id var ATName = HttpUtility.UrlDecode(Request.QueryString["ATName"]); //商品名称 var DisplayCss = HttpUtility.UrlDecode(Request.QueryString["DisplayCss"]); //商品名称 #region 除分类 if (!string.IsNullOrEmpty(detATId)) { #region 查询分类是否有品牌关联 string sqlWhere = ""; List <SqlParameter> parameters = new List <SqlParameter>(); //创建查询参数集合 sqlWhere = " ATId=@detATId "; var parameter = new SqlParameter("@detATId", DbType.AnsiString); parameter.Value = detATId; parameters.Add(parameter); DataSet dts = aDAL.GetList(sqlWhere, parameters); //通过商品分类Id查找关系表数据 if (dts.Tables[0].Rows.Count > 0) { Response.Write("该类型已被内容使用,不能删除"); Response.End(); } #endregion #region 判断分类是否存在子分类 else { Response.Write(atDAL.Delete(Convert.ToInt32(detATId)) ? "删除成功" : "删除失败"); Response.End(); } #endregion } #endregion #region 添加、修改、添加子分类 else { if (string.IsNullOrEmpty(ATName)) { Response.Write("类型名称不能为空"); Response.End(); } #region 修改商品分类 ECommerce.CM.Model.CMArticleType atMdoel = new ECommerce.CM.Model.CMArticleType(); //商品分类实体 if (!string.IsNullOrEmpty(ATId)) { try { atMdoel = atDAL.GetModel(Convert.ToInt32(ATId)); if (atMdoel != null) { string sqlWhere = ""; List <SqlParameter> parameters = new List <SqlParameter>(); //创建查询参数集合 sqlWhere = " ATName=@ATName and ATId!=@ATId "; //查询条件 var parameter = new SqlParameter("@ATName", DbType.AnsiString); parameter.Value = ATName; parameters.Add(parameter); var parameter1 = new SqlParameter("@ATId", DbType.AnsiString); parameter1.Value = ATId; parameters.Add(parameter1); var ds = atDAL.GetList(sqlWhere, parameters); //通过商品分类名称及商品Id查询商品分类名称是否存在 if (ds.Tables[0].Rows.Count > 0) { Response.Write("该类型名称已存在"); Response.End(); } atMdoel.ATName = ATName; atMdoel.DisplayCss = DisplayCss; switch (DisplayCss) { case "红色": atMdoel.ColorValue = "#b94a48"; break; case "黄色": atMdoel.ColorValue = "#f89406"; break; case "绿色": atMdoel.ColorValue = "#468847"; break; } atMdoel.DisplayCss = DisplayCss; Response.Write(atDAL.Update(atMdoel) ? "保存成功" : "保存失败"); Response.End(); } } catch (System.Threading.ThreadAbortException ex) { throw ex; } catch { Response.Write("保存失败"); Response.End(); } } #endregion #region 添加子分类、添加分类 else { try { string sqlWhere = ""; List <SqlParameter> parameters = new List <SqlParameter>(); //创建查询参数集合 sqlWhere = " ATName=@ATName and ATId=@ATId "; var parameter = new SqlParameter("@ATName", DbType.AnsiString); parameter.Value = ATName; parameters.Add(parameter); var parameter1 = new SqlParameter("@ATId", DbType.AnsiString); parameter1.Value = ATId; parameters.Add(parameter1); var ds = atDAL.GetList(sqlWhere, parameters); if (ds.Tables[0].Rows.Count > 0) { Response.Write("该类型名称已存在"); Response.End(); } atMdoel.ATName = ATName; //商品分类名称 atMdoel.DisplayCss = DisplayCss; switch (DisplayCss) { case "红色": atMdoel.ColorValue = "#b94a48"; break; case "黄色": atMdoel.ColorValue = "#f89406"; break; case "绿色": atMdoel.ColorValue = "#468847"; break; } Response.Write(atDAL.Add(atMdoel) > 0 ? "保存成功" : "保存失败"); Response.End(); } catch (System.Threading.ThreadAbortException ex) { throw ex; } catch { Response.Write("保存失败"); Response.End(); } } #endregion } #endregion } }
ECommerce.CM.DAL.CMArticleType atDAL = new ECommerce.CM.DAL.CMArticleType(); //创建商品分类DAL对象 #endregion Fields #region Methods protected void Page_Load(object sender, EventArgs e) { //VerifyPage("", false); if (!IsPostBack) { var ATId = Request.QueryString["ATId"]; //编辑分类Id var detATId = Request.QueryString["detATId"]; //删除商品分类Id var ATName = HttpUtility.UrlDecode(Request.QueryString["ATName"]); //商品名称 var DisplayCss = HttpUtility.UrlDecode(Request.QueryString["DisplayCss"]); //商品名称 #region 删除分类 if (!string.IsNullOrEmpty(detATId)) { #region 查询分类是否有品牌关联 string sqlWhere = ""; List<SqlParameter> parameters = new List<SqlParameter>(); //创建查询参数集合 sqlWhere = " ATId=@detATId "; var parameter = new SqlParameter("@detATId", DbType.AnsiString); parameter.Value = detATId; parameters.Add(parameter); DataSet dts = aDAL.GetList(sqlWhere, parameters); //通过商品分类Id查找关系表数据 if (dts.Tables[0].Rows.Count > 0) { Response.Write("该类型已被内容使用,不能删除"); Response.End(); } #endregion #region 判断分类是否存在子分类 else { Response.Write(atDAL.Delete(Convert.ToInt32(detATId)) ? "删除成功" : "删除失败"); Response.End(); } #endregion } #endregion #region 添加、修改、添加子分类 else { if (string.IsNullOrEmpty(ATName)) { Response.Write("类型名称不能为空"); Response.End(); } #region 修改商品分类 ECommerce.CM.Model.CMArticleType atMdoel = new ECommerce.CM.Model.CMArticleType(); //商品分类实体 if (!string.IsNullOrEmpty(ATId)) { try { atMdoel = atDAL.GetModel(Convert.ToInt32(ATId)); if (atMdoel != null) { string sqlWhere = ""; List<SqlParameter> parameters = new List<SqlParameter>(); //创建查询参数集合 sqlWhere = " ATName=@ATName and ATId!=@ATId "; //查询条件 var parameter = new SqlParameter("@ATName", DbType.AnsiString); parameter.Value = ATName; parameters.Add(parameter); var parameter1 = new SqlParameter("@ATId", DbType.AnsiString); parameter1.Value = ATId; parameters.Add(parameter1); var ds = atDAL.GetList(sqlWhere, parameters); //通过商品分类名称及商品Id查询商品分类名称是否存在 if (ds.Tables[0].Rows.Count > 0) { Response.Write("该类型名称已存在"); Response.End(); } atMdoel.ATName = ATName; atMdoel.DisplayCss = DisplayCss; switch (DisplayCss) { case "红色": atMdoel.ColorValue = "#b94a48"; break; case "黄色": atMdoel.ColorValue = "#f89406"; break; case "绿色": atMdoel.ColorValue = "#468847"; break; } atMdoel.DisplayCss = DisplayCss; Response.Write(atDAL.Update(atMdoel) ? "保存成功" : "保存失败"); Response.End(); } } catch (System.Threading.ThreadAbortException ex) { throw ex; } catch { Response.Write("保存失败"); Response.End(); } } #endregion #region 添加子分类、添加分类 else { try { string sqlWhere = ""; List<SqlParameter> parameters = new List<SqlParameter>(); //创建查询参数集合 sqlWhere = " ATName=@ATName and ATId=@ATId "; var parameter = new SqlParameter("@ATName", DbType.AnsiString); parameter.Value = ATName; parameters.Add(parameter); var parameter1 = new SqlParameter("@ATId", DbType.AnsiString); parameter1.Value = ATId; parameters.Add(parameter1); var ds = atDAL.GetList(sqlWhere, parameters); if (ds.Tables[0].Rows.Count > 0) { Response.Write("该类型名称已存在"); Response.End(); } atMdoel.ATName = ATName; //商品分类名称 atMdoel.DisplayCss = DisplayCss; switch (DisplayCss) { case "红色": atMdoel.ColorValue = "#b94a48"; break; case "黄色": atMdoel.ColorValue = "#f89406"; break; case "绿色": atMdoel.ColorValue = "#468847"; break; } Response.Write(atDAL.Add(atMdoel) > 0 ? "保存成功" : "保存失败"); Response.End(); } catch (System.Threading.ThreadAbortException ex) { throw ex; } catch { Response.Write("保存失败"); Response.End(); } } #endregion } #endregion } }
/// <summary> /// 对象实体绑定数据 /// </summary> public ECommerce.CM.Model.CMArticleType ReaderBind(IDataReader dataReader) { ECommerce.CM.Model.CMArticleType model = new ECommerce.CM.Model.CMArticleType(); object ojb; ojb = dataReader["ATId"]; if (ojb != null && ojb != DBNull.Value) { model.ATId = Convert.ToInt32(ojb); } model.ATName = dataReader["ATName"].ToString(); model.DisplayCss = dataReader["DisplayCss"].ToString(); model.ColorValue = dataReader["ColorValue"].ToString(); return model; }