/// <summary> /// 数据绑定 /// </summary> private void Bind() { if (KeyID != 0) { Hi.Model.BD_Promotion ProModel = new Hi.BLL.BD_Promotion().GetModel(KeyID); //促销公告 List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID + "and isnull(IsEnabled,0)=1", ""); if (ProModel != null) { if (newsl != null && newsl.Count > 0) { this.isOkComNews.Checked = true; this.isNoComNews.Checked = false; } else { this.isOkComNews.Checked = false; this.isNoComNews.Checked = true; } this.txtPromotionDate.Value = ProModel.ProStartTime == DateTime.MinValue ? "" : ProModel.ProStartTime.ToString("yyyy-MM-dd"); this.txtPromotionDate1.Value = ProModel.ProEndTime == DateTime.MinValue ? "" : ProModel.ProEndTime.ToString("yyyy-MM-dd"); this.txtProInfos.Value = ProModel.ProInfos; //促销禁用 if (ProModel.IsEnabled == 0) { this.IsEnabled0.Checked = true; this.IsEnabled1.Checked = false; } else { this.IsEnabled0.Checked = false; this.IsEnabled1.Checked = true; } List <Hi.Model.BD_PromotionDetail2> ll = new Hi.BLL.BD_PromotionDetail2().GetList("", "isnull(dr,0)=0 and proId=" + KeyID + " and compId=" + this.CompID, ""); if (ll.Count > 1) { this.Radio1.Checked = true; this.Radio2.Checked = false; } else { this.Radio2.Checked = true; this.Radio1.Checked = false; } string html = ""; if (ProModel.ProType == 5) { this.promotionType3.Checked = true; this.promotionType4.Checked = false; int z = 0; foreach (Hi.Model.BD_PromotionDetail2 item in ll) { z++; html += "<label>订单金额满¥<input type=\"text\" onkeyup='KeyInt2(this)' id=\"txtPrice" + z + "\" class=\"send txtPrice\" style=\"width: 50px;\" name=\"txtPrice\" value=\"" + item.OrderPrice.ToString("f2") + "\" />,立减¥<input type=\"text\" id=\"txtSendFull" + z + "\" onkeyup='KeyInt2(this)' class=\"send txtSendFull\" name=\"txtSendFull\" style=\"width: 50px;\" value=\"" + item.Discount.ToString("f2") + "\"/>"; if (z > 1) { html += "<a class=\"theme-color ml20 deleteItem\" href=\"javascript:;\">删除</a>"; } html += "</label><br>"; } this.SendFull.InnerHtml = html.Substring(0, html.LastIndexOf("<")); } else if (ProModel.ProType == 6) { this.promotionType4.Checked = true; this.promotionType3.Checked = false; int x = 0; foreach (Hi.Model.BD_PromotionDetail2 item in ll) { x++; html += "<label>订单金额满¥<input type=\"text\" onkeyup='KeyInt2(this)' id=\"txtPrices" + x + "\" class=\"send txtPrices\" style=\"width: 50px;\" name=\"txtPrices\" value=\"" + item.OrderPrice.ToString("f2") + "\"/>,打折(<input type=\"text\" id=\"txtDiscount" + x + "\" onkeyup='KeyInt2(this)' class=\"send txtDiscount\" name=\"txtDiscount\" style=\"width: 20px;\" value=\"" + Convert.ToInt32(item.Discount) + "\"/>)%"; if (x > 1) { html += "<a class=\"theme-color ml20 deleteItem\" href=\"javascript:;\">删除</a>"; } html += "</label><br>"; } this.Discount.InnerHtml = html.Substring(0, html.LastIndexOf("<")); } } } }
/// <summary> /// 数据绑定 /// </summary> private void Bind() { if (KeyID != 0) { Hi.Model.BD_Promotion ProModel = new Hi.BLL.BD_Promotion().GetModel(KeyID); if (ProModel != null) { this.lblProType.InnerText = Common.GetProType(ProModel.ProType.ToString()); pro = ProModel.ProType.ToString(); this.lblProIsEnabled.InnerText = Common.GetIsEnabled(ProModel.IsEnabled.ToString()); this.lblProStartDate.InnerText = ProModel.ProStartTime == DateTime.MinValue ? "" : ProModel.ProStartTime.ToString("yyyy-MM-dd"); this.lblProEndDate.InnerText = ProModel.ProEndTime == DateTime.MinValue ? "" : ProModel.ProEndTime.ToString("yyyy-MM-dd"); this.lblProInfos.InnerText = ProModel.ProInfos; if (ProModel.ProStartTime <= DateTime.Now && ProModel.ProEndTime.AddDays(1) > DateTime.Now) { //促销活动中 //判断是否禁用 if (ProModel.IsEnabled == 0) { //未禁用 this.liEdit.Visible = true; //编辑 this.liDel.Visible = true; //删除 this.liNo.Visible = false; //禁用 this.liOk.Visible = true; //启用 } else { //已禁用 this.liEdit.Visible = false; //编辑 this.liDel.Visible = false; //删除 this.liNo.Visible = true; //禁用 this.liOk.Visible = false; //启用 } } else if (ProModel.ProStartTime > DateTime.Now) { //判断是否禁用 if (ProModel.IsEnabled == 0) { //未禁用 this.liEdit.Visible = true; //编辑 this.liDel.Visible = true; //删除 this.liNo.Visible = false; //禁用 this.liOk.Visible = true; //启用 } else { //已禁用 this.liEdit.Visible = false; //编辑 this.liDel.Visible = false; //删除 this.liNo.Visible = true; //禁用 this.liOk.Visible = false; //启用 } } else { this.liEdit.Visible = true; //编辑 this.liDel.Visible = true; //删除 this.liNo.Visible = false; //禁用 this.liOk.Visible = false; //启用 } List <Hi.Model.BD_PromotionDetail2> ll = new Hi.BLL.BD_PromotionDetail2().GetList("", "isnull(dr,0)=0 and proId=" + ProModel.ID + " and compId=" + this.CompID, ""); if (ll.Count > 1) { this.lblProIsJieTi.InnerText = "是"; } else { this.lblProIsJieTi.InnerText = "否"; } string html = ""; if (ProModel.ProType == 5) { foreach (Hi.Model.BD_PromotionDetail2 item in ll) { html += "<label>订单金额满¥<input type=\"text\" onkeyup='KeyInt2(this)' id=\"txtPrice1\" class=\"send txtPrice\" style=\"width: 50px;\" name=\"txtPrice\" value=\"" + item.OrderPrice.ToString("f2") + "\" />,立减¥<input type=\"text\" id=\"txtSendFull1\" onkeyup='KeyInt2(this)' class=\"send txtSendFull\" name=\"txtSendFull\" style=\"width: 50px;\" value=\"" + item.Discount.ToString("f2") + "\"/></label><br>"; } } else if (ProModel.ProType == 6) { foreach (Hi.Model.BD_PromotionDetail2 item in ll) { html += "<label>订单金额满¥<input type=\"text\" onkeyup='KeyInt2(this)' id=\"txtPrices1\" class=\"send txtPrices\" style=\"width: 50px;\" name=\"txtPrices\" value=\"" + item.OrderPrice.ToString("f2") + "\"/>,打折(<input type=\"text\" id=\"txtDiscount1\" onkeyup='KeyInt2(this)' class=\"send txtDiscount\" name=\"txtDiscount\" style=\"width: 20px;\" value=\"" + Convert.ToInt32(item.Discount) + "\"/>)%</label><br>"; } } this.SendFull.InnerHtml = html; } } }
/// <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(); } }