/// <summary> /// 根据卡号查询 /// </summary> /// <param name="cardNumber"></param> /// <returns></returns> public ShowShop.Model.OrderCard.OrderCardInfo GetModelByCardNumber(string cardNumber) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,password,expirationdate,point,unit,whetherRelease from yxs_ordercard where cardnumber=@cardnumber"); SqlParameter[] parameters ={ new SqlParameter("@cardnumber",SqlDbType.VarChar,50) }; parameters[0].Value = cardNumber; ShowShop.Model.OrderCard.OrderCardInfo model = null; using(SqlDataReader reader=ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(),parameters)){ if(reader.Read()) { model = new ShowShop.Model.OrderCard.OrderCardInfo(); model.ID = (int)reader["id"]; model.Password = (string)reader["password"]; model.ExpirationDate = Convert.ToDateTime(reader["expirationdate"]); model.Point = (string)reader["point"]; model.Unit = (string)reader["unit"]; model.WhetherRelease = Convert.ToInt32(reader["whetherRelease"]); } } return model; }
/// <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"; } }
/// <summary> /// 返回数据 /// </summary> /// <param name="row"></param> /// <returns></returns> public ShowShop.Model.OrderCard.OrderCardInfo GetModel(System.Data.DataRow row) { ShowShop.Model.OrderCard.OrderCardInfo model = new ShowShop.Model.OrderCard.OrderCardInfo(); if (row != null) { model.ID = int.Parse(row["id"].ToString()); model.ProductID = int.Parse(row["productid"].ToString()); model.IsWhetherSale = int.Parse(row["iswebsitersale"].ToString()); model.Type = row["type"].ToString(); model.CardNumber = row["cardnumber"].ToString(); model.Password = row["password"].ToString(); model.FaceValue = decimal.Parse(row["facevalue"].ToString()); model.Point = row["point"].ToString(); model.Unit = row["unit"].ToString(); model.ExpirationDate = Convert.ToDateTime(row["expirationdate"].ToString()); model.BusinessAgent = row["businessagent"].ToString(); model.CreateDate = Convert.ToDateTime(row["createdate"].ToString()); model.Appearance = int.Parse(row["appearance"].ToString()); model.Price = decimal.Parse(row["price"].ToString()); model.WhetherRelease = int.Parse(row["whetherRelease"].ToString()); model.UserName = row["username"].ToString(); model.UpdateDate = Convert.ToDateTime(row["updatedate"].ToString()); model.FullMoneyDate = Convert.ToDateTime(row["fullmoneydate"].ToString()); return model; } else { return null; } }