Example #1
0
 /// <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";
            }
        }
Example #3
0
 /// <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;
     }
 }