public List <Chain.Model.GoodsClassDiscount> DataTableToList(DataTable dt) { List <Chain.Model.GoodsClassDiscount> modelList = new List <Chain.Model.GoodsClassDiscount>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { for (int i = 0; i < rowsCount; i++) { Chain.Model.GoodsClassDiscount model = new Chain.Model.GoodsClassDiscount(); if (dt.Rows[i]["ClassDiscountID"] != null && dt.Rows[i]["ClassDiscountID"].ToString() != "") { model.ClassDiscountID = int.Parse(dt.Rows[i]["ClassDiscountID"].ToString()); } if (dt.Rows[i]["GoodsClassID"] != null && dt.Rows[i]["GoodsClassID"].ToString() != "") { model.GoodsClassID = int.Parse(dt.Rows[i]["GoodsClassID"].ToString()); } if (dt.Rows[i]["MemLevelID"] != null && dt.Rows[i]["MemLevelID"].ToString() != "") { model.MemLevelID = int.Parse(dt.Rows[i]["MemLevelID"].ToString()); } if (dt.Rows[i]["DiscountShopID"] != null && dt.Rows[i]["DiscountShopID"].ToString() != "") { model.DiscountShopID = int.Parse(dt.Rows[i]["DiscountShopID"].ToString()); } if (dt.Rows[i]["ClassDiscountPercent"] != null && dt.Rows[i]["ClassDiscountPercent"].ToString() != "") { model.ClassDiscountPercent = decimal.Parse(dt.Rows[i]["ClassDiscountPercent"].ToString()); } if (dt.Rows[i]["ClassPointPercent"] != null && dt.Rows[i]["ClassPointPercent"].ToString() != "") { model.ClassPointPercent = decimal.Parse(dt.Rows[i]["ClassPointPercent"].ToString()); } modelList.Add(model); } } return(modelList); }
protected void btnCopy_Click(object sender, EventArgs e) { Chain.BLL.SysShop bllShop = new Chain.BLL.SysShop(); Chain.BLL.GoodsClassAuthority bllGoodsClassAuthority = new Chain.BLL.GoodsClassAuthority(); Chain.BLL.GoodsClass bllGoodsClass = new Chain.BLL.GoodsClass(); DataTable dtShop = bllShop.GetList("ShopID>0 and ShopType=3 and IsMain=0 ").Tables[0]; DataTable dtGoodsClass = bllGoodsClass.GetList("CreateShopID=" + this._UserShopID).Tables[0]; for (int i = 0; i < dtShop.Rows.Count; i++) { int ShopID = int.Parse(dtShop.Rows[i]["ShopID"].ToString()); for (int j = 0; j < dtGoodsClass.Rows.Count; j++) { int ClassID = int.Parse(dtGoodsClass.Rows[j]["ClassID"].ToString()); Chain.Model.GoodsClassAuthority modelGoodsClassAuthority = new Chain.Model.GoodsClassAuthority(); modelGoodsClassAuthority.ClassID = ClassID; modelGoodsClassAuthority.ShopID = ShopID; int count = bllGoodsClassAuthority.GetRecordCount(string.Concat(new object[] { "ShopID=", ShopID, " and ClassID=", ClassID })); if (count == 0) { bllGoodsClassAuthority.Add(modelGoodsClassAuthority); } } } Chain.BLL.GoodsClassDiscount bllGoodsClassDiscount = new Chain.BLL.GoodsClassDiscount(); DataTable dtClassDiscount = bllGoodsClassDiscount.GetList("DiscountShopID=" + this._UserShopID).Tables[0]; for (int i = 0; i < dtShop.Rows.Count; i++) { int ShopID = int.Parse(dtShop.Rows[i]["ShopID"].ToString()); for (int j = 0; j < dtClassDiscount.Rows.Count; j++) { Chain.Model.GoodsClassDiscount modelGoodsClassDiscount = new Chain.Model.GoodsClassDiscount(); int ClassID = int.Parse(dtClassDiscount.Rows[j]["GoodsClassID"].ToString()); int MemLevelID = int.Parse(dtClassDiscount.Rows[j]["MemLevelID"].ToString()); modelGoodsClassDiscount.GoodsClassID = ClassID; modelGoodsClassDiscount.MemLevelID = MemLevelID; modelGoodsClassDiscount.DiscountShopID = ShopID; modelGoodsClassDiscount.ClassDiscountPercent = int.Parse(dtClassDiscount.Rows[j]["ClassDiscountPercent"].ToString()); modelGoodsClassDiscount.ClassPointPercent = int.Parse(dtClassDiscount.Rows[j]["ClassPointPercent"].ToString()); DataTable dtShopGoodsClassDiscount = bllGoodsClassDiscount.GetList(string.Concat(new object[] { "MemLevelID=", MemLevelID, " and DiscountShopID=", ShopID, " and GoodsClassID=", ClassID })).Tables[0]; if (dtShopGoodsClassDiscount.Rows.Count == 0) { bllGoodsClassDiscount.Add(modelGoodsClassDiscount); } else { modelGoodsClassDiscount.ClassDiscountID = int.Parse(dtShopGoodsClassDiscount.Rows[0]["ClassDiscountID"].ToString()); bllGoodsClassDiscount.Update(modelGoodsClassDiscount); } } } Chain.BLL.Goods bllGoods = new Chain.BLL.Goods(); DataTable dtGoods = bllGoods.GetGoodsList("CreateShopID=" + this._UserShopID).Tables[0]; Chain.BLL.GoodsNumber bllGoodsNumber = new Chain.BLL.GoodsNumber(); for (int i = 0; i < dtShop.Rows.Count; i++) { int ShopID = int.Parse(dtShop.Rows[i]["ShopID"].ToString()); for (int j = 0; j < dtGoods.Rows.Count; j++) { int GoodsID = int.Parse(dtGoods.Rows[j]["GoodsID"].ToString()); int count = bllGoodsNumber.GetRecordCount(string.Concat(new object[] { "GoodsID=", GoodsID, " and ShopID=", ShopID })); Chain.Model.GoodsNumber modelGoodsNumber = new Chain.Model.GoodsNumber(); modelGoodsNumber.GoodsID = GoodsID; modelGoodsNumber.Number = 0m; modelGoodsNumber.ShopID = ShopID; if (count == 0) { bllGoodsNumber.Add(modelGoodsNumber); } } } this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "message", "<Script Language='JavaScript' defer>art.dialog({title: '系统提示',time: 2,content:'同步成功',close: function () { location.href = 'GoodsList.aspx?PID=62'; }});</script>"); }
public bool Update(Chain.Model.GoodsClassDiscount model) { return(this.dal.Update(model)); }
public int Add(Chain.Model.GoodsClassDiscount model) { return(this.dal.Add(model)); }