/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.BD_PromotionDetail2 model) { return(dal.Update(model)); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string str = string.Empty; string ProType = string.Empty; //促销方式 string ProIsEnabled = string.Empty; //是否启用 string ProInfos = string.Empty; //促销描述 string ProIsJieTi = string.Empty; //是否启用阶梯 string PromotionDate = string.Empty; //促销开始日期 string PromotionEndDate = string.Empty; //促销结束日期 int isComNew = 0; //是否发布促销公告 #region 判断值是否为空,取值 //促销方式 ProType = Request["promotionType"].ToString(); //是否启用 ProIsEnabled = Request["IsEnabled"].ToString(); //是否启用阶梯 ProIsJieTi = Request["IsEnabled2"].ToString(); //促销开始日期 if (this.txtPromotionDate.Value.Trim() == "") { str += " -- 促销开始日期不能为空。</br>"; } else { PromotionDate = this.txtPromotionDate.Value.Trim(); } //促销结束日期 if (this.txtPromotionDate1.Value.Trim() == "") { str += " -- 促销结束日期不能为空。</br>"; } else { PromotionEndDate = this.txtPromotionDate1.Value.Trim(); } ProInfos = Common.NoHTML(this.txtProInfos.Value.Trim().ToString()); if (str != "") { JScript.AlertMsgOne(this, str, JScript.IconOption.错误, 2500); return; } #endregion //是否发布促销公告 isComNew = this.isOkComNews.Checked ? 1 : 0; string NewsContents = string.Empty; NewsContents = "<font size=\"3\" style=\"line-height:30px;\">"; SqlTransaction Tran = null; try { Hi.Model.BD_Promotion proModel = null; int ProId = 0; Tran = DBUtility.SqlHelper.CreateStoreTranSaction(); if (KeyID != 0)//修改 { ProId = KeyID; List <Hi.Model.BD_PromotionDetail2> l = new Hi.BLL.BD_PromotionDetail2().GetList("", "isnull(dr,0)=0 and proId=" + KeyID + " and compId=" + this.CompID, "", Tran); if (l.Count > 0) { foreach (Hi.Model.BD_PromotionDetail2 item in l) { new Hi.BLL.BD_PromotionDetail2().Delete(item.ID, Tran); } } proModel = new Hi.BLL.BD_Promotion().GetModel(KeyID, Tran); } else { proModel = new Hi.Model.BD_Promotion(); } //else //{ proModel.Type = Type.ToInt(0); proModel.CompID = this.CompID; proModel.ProType = ProType.ToInt(0); if (ProType == "5") { proModel.ProTitle = "订单满减促销"; } else if (ProType == "6") { proModel.ProTitle = "订单满折促销"; } proModel.IsEnabled = ProIsEnabled.ToInt(0); proModel.Discount = 0; proModel.ProStartTime = PromotionDate.ToDateTime(); proModel.ProEndTime = PromotionEndDate.ToDateTime(); proModel.ProInfos = ProInfos; proModel.CreateUserID = this.UserID; proModel.CreateDate = DateTime.Now; proModel.modifyuser = this.UserID; proModel.ts = DateTime.Now.ToString(); if (KeyID != 0)//修改 { ProId = KeyID; proModel.ID = KeyID; new Hi.BLL.BD_Promotion().Update(proModel, Tran); } else { ProId = new Hi.BLL.BD_Promotion().Add(proModel, Tran); } if (ProType == "5") { string[] price = Request["txtPrice"].ToString().Split(','); //需要满金额 string[] price2 = Request["txtSendFull"].ToString().Split(','); //满后需要减得金额 for (int i = 0; i < price.Length; i++) { if (price[i] != "") { Hi.Model.BD_PromotionDetail2 modelDeta = new Hi.Model.BD_PromotionDetail2(); modelDeta.CompID = this.CompID; modelDeta.ProID = ProId; modelDeta.OrderPrice = Convert.ToDecimal(price[i]); modelDeta.Discount = Convert.ToDecimal(price2[i]); modelDeta.modifyuser = this.UserID; modelDeta.ts = DateTime.Now; modelDeta.CreateUserID = this.UserID; modelDeta.CreateDate = DateTime.Now; new Hi.BLL.BD_PromotionDetail2().Add(modelDeta, Tran); NewsContents += "订单金额满¥" + price[i] + ",立减¥" + price2[i] + "<br>"; } } } else if (ProType == "6") { string[] prices = Request["txtPrices"].ToString().Split(','); //需要满金额 string[] prices2 = Request["txtDiscount"].ToString().Split(','); //满后折扣 for (int i = 0; i < prices.Length; i++) { if (prices[i] != "") { Hi.Model.BD_PromotionDetail2 modelDeta = new Hi.Model.BD_PromotionDetail2(); modelDeta.CompID = this.CompID; modelDeta.ProID = ProId; modelDeta.OrderPrice = Convert.ToDecimal(prices[i]); modelDeta.Discount = Convert.ToDecimal(prices2[i]); modelDeta.modifyuser = this.UserID; modelDeta.ts = DateTime.Now; modelDeta.CreateUserID = this.UserID; modelDeta.CreateDate = DateTime.Now; new Hi.BLL.BD_PromotionDetail2().Add(modelDeta, Tran); NewsContents += "订单金额满¥" + prices[i] + ",打折(" + prices2[i] + ")%<br>"; } } } //} Hi.Model.BD_CompNews news = new Hi.Model.BD_CompNews(); news.CompID = CompID; news.CreateDate = DateTime.Now; news.CreateUserID = UserID; news.dr = 0; news.ts = DateTime.Now; news.IsTop = 1; news.IsEnabled = 0; news.NewsType = 4; news.ShowType = "2"; if (ProType == "5") { news.NewsTitle = "订单满减促销"; } else if (ProType == "6") { news.NewsTitle = "订单满折促销"; } NewsContents += "先到先得!"; ProInfos = ProInfos == "" ? "" : "(" + ProInfos + ")"; NewsContents += ProInfos; NewsContents += " </br> 活动时间:" + PromotionDate.ToDateTime().ToString("yyyy-MM-dd") + "至" + PromotionEndDate.ToDateTime().ToString("yyyy-MM-dd"); NewsContents += "</font>"; news.NewsContents = NewsContents; news.modifyuser = UserID; news.PmID = ProId; if (isComNew == 1) { new Hi.BLL.BD_CompNews().Add(news, Tran); } Tran.Commit(); Response.Write("<script>window.location.href='PromotionInfo2.aspx?KeyId=" + Common.DesEncrypt(ProId.ToString(), Common.EncryptKey) + "&type=" + Type + "';</script>"); } catch (Exception ex) { if (Tran != null) { if (Tran.Connection != null) { Tran.Rollback(); } } JScript.AlertMsgOne(this, "保存失败了", JScript.IconOption.错误, 2500); return; } finally { DBUtility.SqlHelper.ConnectionClose(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.BD_PromotionDetail2 model) { return(dal.Add(model)); }