protected void BandInfo(int id) { ShowShop.BLL.OrderCard.OrderCardInfo bll = new ShowShop.BLL.OrderCard.OrderCardInfo(); ShowShop.Model.OrderCard.OrderCardInfo model = bll.GetModelID(id); if (model != null) { this.rbCardType.SelectedValue = model.Type; this.rblIsShopSale.SelectedValue = model.IsWhetherSale.ToString(); if (model.IsWhetherSale.ToString() == "1") { this.OptionProduct.Style.Value = "display:"; string Name=ProductName(model.ProductID.ToString()); if (Name!="") { this.txtProduct.Text = Name; this.hfid.Value = model.ProductID.ToString(); } } this.brlmode.Enabled = false; this.txtCardNumber.Text = model.CardNumber; this.txtPassword.Text = model.JOCW_Password; this.txtFaceValue.Text = model.FaceValue.ToString(); this.txtPoint.Text = model.Point.ToString(); this.ddty.SelectedValue = model.Unit; this.txtPrice.Text = model.Price.ToString(); this.txtEndTime.Text = model.ExpirationDate.ToString(); this.txtBusinessAgent.Text = model.BusinessAgent; ViewState["ID"] = model.ID; ViewState["PassWord"] = model.JOCW_Password; ViewState["UserName"] = model.UserName; ViewState["CardNumber"] = model.CardNumber; ViewState["FullMoneyDate"] = model.FullMoneyDate; ViewState["WhetherRelease"] = model.WhetherRelease; } }
/// <summary> /// 列表 /// </summary> /// <returns></returns> protected string GetList() { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.OrderCard.OrderCardInfo data = new ShowShop.BLL.OrderCard.OrderCardInfo(); ChangeHope.DataBase.DataByPage dataPage = data.GetList(); //第一步先添加表头 table.AddHeadCol("4%", "序号"); table.AddHeadCol("11%", "类型"); table.AddHeadCol("15%", "卡号"); table.AddHeadCol("5%", "面值"); table.AddHeadCol("5%", "点数"); table.AddHeadCol("14%", "所属商品"); table.AddHeadCol("8%", "状态"); table.AddHeadCol("10%", "截止日期"); table.AddHeadCol("9%", "使用会员"); table.AddHeadCol("10%", "获取时间"); table.AddHeadCol("15%", "操作"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex"); if (curpage < 0) { curpage = 1; } int count = 0; while (dataPage.DataReader.Read()) { count++; string No = (15 * (curpage - 1) + count).ToString(); table.AddCol(No); table.AddCol(dataPage.DataReader["type"].ToString() == "1" ? "本商城充值卡" : "其它公司充值卡"); table.AddCol(dataPage.DataReader["cardnumber"].ToString()); table.AddCol(dataPage.DataReader["facevalue"].ToString()); table.AddCol(dataPage.DataReader["point"].ToString() + dataPage.DataReader["unit"].ToString()); table.AddCol(dataPage.DataReader["iswebsitersale"].ToString() == "1" ? ProductName(dataPage.DataReader["productid"].ToString()) : "不通过商城出售"); table.AddCol(Convert.ToDateTime(dataPage.DataReader["expirationdate"].ToString()) < System.DateTime.Now ? "已失效" : this.State(dataPage.DataReader["whetherRelease"].ToString(), dataPage.DataReader["productid"].ToString())); table.AddCol(Convert.ToDateTime(dataPage.DataReader["expirationdate"].ToString()).ToString("yyyy-MM-dd")); table.AddCol(dataPage.DataReader["username"].ToString()); table.AddCol(Convert.ToDateTime(dataPage.DataReader["fullmoneydate"].ToString()) != Convert.ToDateTime("1753-01-01") ? Convert.ToDateTime(dataPage.DataReader["fullmoneydate"].ToString()).ToString("yyyy-MM-dd") : ""); table.AddCol(string.Format("<a href=ordercard_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString())); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; return view; }
/// <summary> /// 保存信息 /// </summary> protected void Save() { string addManner = this.brlmode.SelectedValue; string CardNo = this.txtCardNumber.Text; string CardPassWord = this.txtPassword.Text; string BatchCard = this.txtBatch.Text; if (addManner == "1") { if (string.IsNullOrEmpty(CardNo)) { this.ltlMsg.Text = "操作失败,卡号不能为空。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } if (string.IsNullOrEmpty(CardPassWord)) { this.ltlMsg.Text = "操作失败,密码不能为空。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } else if (addManner == "2") { if (string.IsNullOrEmpty(BatchCard)) { this.ltlMsg.Text = "操作失败,格式文本不能为空。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtFaceValue.Text.Trim()!="") { if(!ChangeHope.Common.ValidateHelper.IsMoney(txtFaceValue.Text.Trim())) { this.ltlMsg.Text = "操作失败,请输入正确面值。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } if(float.Parse(txtFaceValue.Text.Trim())<=0) { this.ltlMsg.Text = "操作失败,面值小于或等于0。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtPoint.Text.Trim()!="") { if(!ChangeHope.Common.ValidateHelper.IsMoney(txtPoint.Text.Trim())) { this.ltlMsg.Text = "操作失败,请输入正确数量。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } if(float.Parse(txtPoint.Text.Trim())<=0) { this.ltlMsg.Text = "操作失败,数量小于或等于0。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtPrice.Text.Trim()!="") { if(!ChangeHope.Common.ValidateHelper.IsMoney(txtPrice.Text.Trim())) { this.ltlMsg.Text = "操作失败,请输入正确价格。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } if(float.Parse(txtPrice.Text.Trim())<=0) { this.ltlMsg.Text = "操作失败,价格小于或等于0。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } ShowShop.BLL.OrderCard.OrderCardInfo bll = new ShowShop.BLL.OrderCard.OrderCardInfo(); ShowShop.Model.OrderCard.OrderCardInfo model = new ShowShop.Model.OrderCard.OrderCardInfo(); TryCode.SymmetricMethod pw = new TryCode.SymmetricMethod(); string isProductID =this.rblIsShopSale.SelectedValue; if (addManner == "1") { if (ViewState["CardNumber"] == null) { ChangeHope.DataBase.DataByPage db = bll.GetList("[order by] id asc", 1, " and cardnumber=" + CardNo + ""); if (db.DataReader != null) { this.ltlMsg.Text = "操作失败,卡号和密码重复,请重新输入。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; return; } } model.ProductID = (isProductID == "1" && this.hfid.Value != string.Empty) ? Convert.ToInt32(this.hfid.Value) : 0; model.IsWhetherSale = int.Parse(isProductID); model.Type = this.rbCardType.Text; model.CardNumber = CardNo; model.Password = CardPassWord; model.FaceValue = Convert.ToDecimal(this.txtFaceValue.Text); model.Point = this.txtPoint.Text; model.Unit = this.ddty.SelectedValue; model.ExpirationDate = Convert.ToDateTime(this.txtEndTime.Text); model.BusinessAgent = this.txtBusinessAgent.Text; model.CreateDate = System.DateTime.Now; model.Appearance = 0; model.Price = this.txtPrice.Text.Trim() != "" ? Convert.ToDecimal(this.txtPrice.Text.Trim()) : 0; model.UpdateDate = System.DateTime.Now; if (ViewState["ID"] == null) { model.WhetherRelease = 0; model.FullMoneyDate =Convert.ToDateTime("1753-01-01"); model.UserName = "******"; if (bll.Add(model) != 0) { this.hfid.Value = string.Empty; this.ltlMsg.Text = "操作成功,添加信息保存成功。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } } else { model.ID = Convert.ToInt32(ViewState["ID"].ToString()); model.WhetherRelease = Convert.ToInt32(ViewState["WhetherRelease"].ToString()); model.UserName = ViewState["UserName"].ToString(); model.FullMoneyDate = Convert.ToDateTime(ViewState["FullMoneyDate"].ToString()); if (bll.Update(model) != 0) { this.hfid.Value = string.Empty; this.ltlMsg.Text = "操作成功,修改信息保存成功。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } } } else if (addManner == "2") { string str = "", strs = "", sp = ""; str = BatchCard.Replace("\n", ","); string[] StringArray = str.Split(','); if (this.tbSp.Text.Trim() != string.Empty) { sp = this.tbSp.Text.Trim(); } else { sp = "|"; } for (int i = 0; i < StringArray.Length; i++) { strs = StringArray[i]; if (strs != string.Empty) { if (strs.IndexOf(sp) > 0) { string[] slingArray = strs.Replace(sp, ",").Split(','); ChangeHope.DataBase.DataByPage db = bll.GetList("[order by] id asc", 1, " and cardnumber=" + slingArray[0] + ""); if(db.DataReader!=null) { break; } if (db.DataReader != null) { this.ltlMsg.Text = "操作失败,卡号和密码重复,请重新输入。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; return; } model.ProductID = (isProductID == "1" && this.txtProduct.Text.Trim() != string.Empty) ? Convert.ToInt32(this.hfid.Value) : 0; model.IsWhetherSale = int.Parse(isProductID); model.Type = this.rbCardType.Text; model.CardNumber = slingArray[0]; model.Password = slingArray[1]; model.FaceValue = Convert.ToDecimal(this.txtFaceValue.Text); model.Point = this.txtPoint.Text; model.Unit = this.ddty.SelectedValue; model.ExpirationDate = Convert.ToDateTime(this.txtEndTime.Text); model.BusinessAgent = this.txtBusinessAgent.Text; model.CreateDate = System.DateTime.Now; model.Appearance = 0; model.Price = this.txtPrice.Text.Trim() != "" ? Convert.ToDecimal(this.txtPrice.Text.Trim()) : 0; model.WhetherRelease = 0; model.UpdateDate = System.DateTime.Now; model.UserName = "******"; model.FullMoneyDate = Convert.ToDateTime("1753-01-01"); bll.Add(model); } } } this.ltlMsg.Text = "操作成功,信息保存成功。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } }
private void del(int id) { ShowShop.BLL.OrderCard.OrderCardInfo bll = new ShowShop.BLL.OrderCard.OrderCardInfo(); ShowShop.Model.OrderCard.OrderCardInfo model = bll.GetModelID(id); if (model != null) { bll.Delete(id); } Response.Write("ok"); }