Пример #1
0
        public ExpResult(decimal _totalMoney, bool _isTravelerMember, VipSoft.Model.MemCard _memInfo)
        {
            totalMoney = _totalMoney;
            isTravelerMember = _isTravelerMember;
            memInfo = _memInfo;

            InitializeComponent();
        }
Пример #2
0
        public ExpResult(List<TempOrderInfo> list, decimal _totalMoney, bool _isTravelerMember, VipSoft.Model.MemCard _memInfo)
        {
            totalMoney = 0;
            listOrders = list;

            foreach (TempOrderInfo order in listOrders)
            {
                totalMoney += order.DiscountPrice;
            }
            totalMoney = Math.Round(totalMoney, 0, MidpointRounding.AwayFromZero);

            isTravelerMember = _isTravelerMember;
            memInfo = _memInfo;
            InitializeComponent();
        }
Пример #3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public VipSoft.Model.MemCard GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 ID,CardID,CardMianID,Name,Sex,Password,Mobile,Photo,LevelID,IsPast,PastTime,Point,State,IsPointAuto,Money,TotalMoney,ShopID,ShopName,LastTime,Email,PayMoney,Remark,CardTypeID from MemCard ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;

            VipSoft.Model.MemCard model = new VipSoft.Model.MemCard();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Пример #4
0
        private void TextBox_CardID_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode==Keys.Enter)
            {
                if (this.TextBox_CardID.Text.Trim() == "")
                {
                    MessageBox.Show("请输入正确的卡号,或者手机号码!");
                    this.TextBox_CardID.Focus();
                    this.TextBox_CardID.SelectAll();
                    return;
                }

                memInfo = new VipSoft.BLL.MemCard().GetModel(this.TextBox_CardID.Text.Trim());

                if (memInfo != null)
                {
                    BindMemInfo(memInfo);
                    this.myTabControl1.SelectedIndex = 0;
                    BindMemExpHistory();
                }
                else
                {
                    memInfo = null;
                    ClearFormText();
                    MessageBox.Show("未找到此会员!");
                    this.TextBox_CardID.Focus();
                    this.TextBox_CardID.SelectAll();
                }
            }
        }
Пример #5
0
 /// <summary>
 /// 清除会员信息
 /// </summary>
 private void ClearMember()
 {
     this.label_Birth.Text = "";
     this.label_CardID.Text = "";
     this.label_Level.Text = "";
     this.label_Mobile.Text = "";
     this.label_Money.Text = "";
     this.label_Name.Text = "";
     this.label_OverCount.Text = "";
     this.label_PassTime.Text = "";
     this.label_Pay.Text = "";
     this.label_Point.Text = "";
     this.label_State.Text = "";
     this.label_TotalMoney.Text = "";
     this.myMemberPhoto.PhotoPath = "";
     memInfo = null;
     this.TextBox_CardID.Text = "";
     this.dataGridView_OrderList.Rows.Clear();
     this.dataGridView_Recharge.Rows.Clear();
     this.dataGridView_List.Rows.Clear();
     this.dataGridView_DetailList.DataSource = null;
     this.panel_Custom.Controls.Clear();
 }
Пример #6
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public VipSoft.Model.MemCard DataRowToModel(DataRow row)
 {
     VipSoft.Model.MemCard model=new VipSoft.Model.MemCard();
     if (row != null)
     {
         if(row["ID"]!=null && row["ID"].ToString()!="")
         {
             model.ID=int.Parse(row["ID"].ToString());
         }
         if(row["CardID"]!=null)
         {
             model.CardID=row["CardID"].ToString();
         }
         if(row["CardMianID"]!=null)
         {
             model.CardMianID=row["CardMianID"].ToString();
         }
         if(row["Name"]!=null)
         {
             model.Name=row["Name"].ToString();
         }
         if(row["Sex"]!=null && row["Sex"].ToString()!="")
         {
             model.Sex=int.Parse(row["Sex"].ToString());
         }
         if(row["Password"]!=null)
         {
             model.Password=row["Password"].ToString();
         }
         if(row["Mobile"]!=null)
         {
             model.Mobile=row["Mobile"].ToString();
         }
         if(row["Photo"]!=null)
         {
             model.Photo=row["Photo"].ToString();
         }
         if(row["LevelID"]!=null && row["LevelID"].ToString()!="")
         {
             model.LevelID=int.Parse(row["LevelID"].ToString());
         }
         if(row["IsPast"]!=null && row["IsPast"].ToString()!="")
         {
             if((row["IsPast"].ToString()=="1")||(row["IsPast"].ToString().ToLower()=="true"))
             {
                 model.IsPast=true;
             }
             else
             {
                 model.IsPast=false;
             }
         }
         if(row["PastTime"]!=null && row["PastTime"].ToString()!="")
         {
             model.PastTime=DateTime.Parse(row["PastTime"].ToString());
         }
         if(row["Point"]!=null && row["Point"].ToString()!="")
         {
             model.Point=int.Parse(row["Point"].ToString());
         }
         if(row["State"]!=null && row["State"].ToString()!="")
         {
             model.State=int.Parse(row["State"].ToString());
         }
         if(row["IsPointAuto"]!=null && row["IsPointAuto"].ToString()!="")
         {
             if((row["IsPointAuto"].ToString()=="1")||(row["IsPointAuto"].ToString().ToLower()=="true"))
             {
                 model.IsPointAuto=true;
             }
             else
             {
                 model.IsPointAuto=false;
             }
         }
         if(row["Money"]!=null && row["Money"].ToString()!="")
         {
             model.Money=decimal.Parse(row["Money"].ToString());
         }
         if(row["TotalMoney"]!=null && row["TotalMoney"].ToString()!="")
         {
             model.TotalMoney=decimal.Parse(row["TotalMoney"].ToString());
         }
         if(row["ShopID"]!=null && row["ShopID"].ToString()!="")
         {
             model.ShopID=int.Parse(row["ShopID"].ToString());
         }
         if(row["ShopName"]!=null)
         {
             model.ShopName=row["ShopName"].ToString();
         }
         if(row["LastTime"]!=null && row["LastTime"].ToString()!="")
         {
             model.LastTime=DateTime.Parse(row["LastTime"].ToString());
         }
         if(row["Email"]!=null)
         {
             model.Email=row["Email"].ToString();
         }
         if(row["PayMoney"]!=null && row["PayMoney"].ToString()!="")
         {
             model.PayMoney=decimal.Parse(row["PayMoney"].ToString());
         }
         if(row["Remark"]!=null)
         {
             model.Remark=row["Remark"].ToString();
         }
         if(row["CardTypeID"]!=null && row["CardTypeID"].ToString()!="")
         {
             model.CardTypeID=int.Parse(row["CardTypeID"].ToString());
         }
     }
     return model;
 }
Пример #7
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public VipSoft.Model.MemCard GetModel(int ID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 ID,CardID,CardMianID,Name,Sex,Password,Mobile,Photo,LevelID,IsPast,PastTime,Point,State,IsPointAuto,Money,TotalMoney,ShopID,ShopName,LastTime,Email,PayMoney,Remark,CardTypeID from MemCard ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4)
            };
            parameters[0].Value = ID;

            VipSoft.Model.MemCard model=new VipSoft.Model.MemCard();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }
Пример #8
0
        private void Button_Save_Click(object sender, EventArgs e)
        {
            totalPoint = 0;
            if (memInfo == null)
            {
                MessageBox.Show("您必须先选择会员!");
                return;
            }

             exchangList = new List<VipSoft.Model.ExchangeLog>();
             foreach (DataGridViewRow row in this.dataGridView_List.Rows)
             {
                 Model.ExchangeLog info;
                 Model.Gift gift;

                 if (row.Cells[0].Value != null && bool.Parse(row.Cells[0].Value.ToString()))
                 {
                     int id = int.Parse(row.Cells["Column_ID"].Value.ToString());
                     string code = row.Cells["Column_Code"].Value.ToString();
                     string name = row.Cells["Column_Name"].Value.ToString();
                     int point = int.Parse(row.Cells["Column_Point"].Value.ToString());

                     int number = 1;
                     try
                     {
                         number = int.Parse(row.Cells["Column_ENum"].Value.ToString());
                     }
                     catch
                     {
                         MessageBox.Show("请输入正确的兑换数量!");
                         return;
                     }

                     if (number > int.Parse(row.Cells["Column_Number"].Value.ToString()))
                     {
                         MessageBox.Show("兑换数量超出礼品剩余数量!");
                         return;
                     }
                     gift = new Model.Gift();
                     gift.GiftCode=code;
                     gift.Name=name;
                     gift.Photo="";
                     gift.Point=point;
                     gift.Number=number;
                     gift.ID = id;

                     info = new Model.ExchangeLog();
                     info.MemID=memInfo.ID;
                     info.CardID=memInfo.CardID;
                     info.Name=memInfo.Name;
                     info.Number=number;
                     info.Point = point * number;
                     info.GiftID=id;
                     info.GiftName=name;
                     info.GiftCode=code;
                     info.MasterID=PublicState.Master.ID;
                     info.MasterName=PublicState.Master.Name;
                     info.ShopID=PublicState.Master.ShopID;
                     info.ShopName=PublicState.Master.ShopName;
                     exchangList.Add(info);
                 }
             }

             if (exchangList.Count == 0)
             {
                 MessageBox.Show("请先选择需要兑换的礼品!");
                 return;
             }
             if (totalPoint > memInfo.Point)
             {
                 MessageBox.Show("对不起,此会员账户积分不足!");
                 return;
             }

             if (new VipSoft.BLL.ExchangeLog().Add(exchangList))
             {
                 // 日志记录
                 VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
                 log.Add(new Model.SysLog(PublicState.Master, "积分兑换", "积分兑换产品成功,会员卡号:" + memInfo.CardID + "姓名:" + memInfo.Name, DateTime.Now));
                 // 发送系统短信
                 memInfo = new BLL.MemCard().GetModel(memInfo.ID);
                     Function.UpdateMemberLevel(2, memInfo);//兑换登记时候自动重新计算

                 // 提示
                 MessageBox.Show("兑换成功。");
                 // 界面
                 memInfo = null;
                 this.label_M_Money.Text = "";
                 this.label_M_Name.Text = "";
                 this.label_M_Point.Text = "";
                 this.label_M_TotalMoney.Text = "";
                 this.searchMember1.CardID = "";
                 BindList();
             }
        }
Пример #9
0
 private void searchMember1_EventMemberSelected(Model.MemCard selectedMemInfo)
 {
     memInfo = selectedMemInfo;
     if (memInfo.IsPast && memInfo.PastTime <= DateTime.Now)
     {
         memInfo = null;
         MessageBox.Show("对不起,此会员卡有效期限已过,无法兑换礼品。");
         this.searchMember1.CardID = "";
         return;
     }
     this.label_M_Name.Text = memInfo.Name;
     this.label_M_Point.Text = memInfo.Point.ToString();
     this.label_M_TotalMoney.Text = memInfo.TotalMoney.ToString("¥0.00");
     this.label_M_Money.Text = memInfo.Money.ToString("¥0.00");
 }
Пример #10
0
 private void Exchang_Load(object sender, EventArgs e)
 {
     BindList();
     if (CurrentCardID != "")
         memInfo = new VipSoft.BLL.MemCard().GetModel(CurrentCardID);
     if (memInfo == null)
     {
         this.label_M_Money.Text = "";
         this.label_M_Name.Text = "";
         this.label_M_Point.Text = "";
         this.label_M_TotalMoney.Text = "";
     }
     else
     {
         this.label_M_Name.Text = memInfo.Name;
         this.label_M_Point.Text = memInfo.Point.ToString();
         this.label_M_TotalMoney.Text = memInfo.TotalMoney.ToString("¥0.00");
         this.label_M_Money.Text = memInfo.Money.ToString("¥0.00");
     }
 }
Пример #11
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.MemCard model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into MemCard(");
            strSql.Append("CardID,CardMianID,Name,Sex,Password,Mobile,Photo,LevelID,IsPast,PastTime,Point,State,IsPointAuto,Money,TotalMoney,ShopID,ShopName,LastTime,Email,PayMoney,Remark,CardTypeID)");
            strSql.Append(" values (");
            strSql.Append("@CardID,@CardMianID,@Name,@Sex,@Password,@Mobile,@Photo,@LevelID,@IsPast,@PastTime,@Point,@State,@IsPointAuto,@Money,@TotalMoney,@ShopID,@ShopName,@LastTime,@Email,@PayMoney,@Remark,@CardTypeID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CardID",      SqlDbType.VarChar,     50),
                new SqlParameter("@CardMianID",  SqlDbType.VarChar,     50),
                new SqlParameter("@Name",        SqlDbType.VarChar,     50),
                new SqlParameter("@Sex",         SqlDbType.Int,          4),
                new SqlParameter("@Password",    SqlDbType.VarChar,     20),
                new SqlParameter("@Mobile",      SqlDbType.VarChar,     20),
                new SqlParameter("@Photo",       SqlDbType.VarChar,     20),
                new SqlParameter("@LevelID",     SqlDbType.Int,          4),
                new SqlParameter("@IsPast",      SqlDbType.Bit,          1),
                new SqlParameter("@PastTime",    SqlDbType.DateTime),
                new SqlParameter("@Point",       SqlDbType.Int,          4),
                new SqlParameter("@State",       SqlDbType.Int,          4),
                new SqlParameter("@IsPointAuto", SqlDbType.Bit,          1),
                new SqlParameter("@Money",       SqlDbType.Money,        8),
                new SqlParameter("@TotalMoney",  SqlDbType.Money,        8),
                new SqlParameter("@ShopID",      SqlDbType.Int,          4),
                new SqlParameter("@ShopName",    SqlDbType.VarChar,     50),
                new SqlParameter("@LastTime",    SqlDbType.DateTime),
                new SqlParameter("@Email",       SqlDbType.VarChar,     50),
                new SqlParameter("@PayMoney",    SqlDbType.Money,        8),
                new SqlParameter("@Remark",      SqlDbType.VarChar,   1000),
                new SqlParameter("@CardTypeID",  SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.CardID;
            parameters[1].Value  = model.CardMianID;
            parameters[2].Value  = model.Name;
            parameters[3].Value  = model.Sex;
            parameters[4].Value  = model.Password;
            parameters[5].Value  = model.Mobile;
            parameters[6].Value  = model.Photo;
            parameters[7].Value  = model.LevelID;
            parameters[8].Value  = model.IsPast;
            parameters[9].Value  = model.PastTime;
            parameters[10].Value = model.Point;
            parameters[11].Value = model.State;
            parameters[12].Value = model.IsPointAuto;
            parameters[13].Value = model.Money;
            parameters[14].Value = model.TotalMoney;
            parameters[15].Value = model.ShopID;
            parameters[16].Value = model.ShopName;
            parameters[17].Value = model.LastTime;
            parameters[18].Value = model.Email;
            parameters[19].Value = model.PayMoney;
            parameters[20].Value = model.Remark;
            parameters[21].Value = model.CardTypeID;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Пример #12
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public VipSoft.Model.MemCard DataRowToModel(DataRow row)
 {
     VipSoft.Model.MemCard model = new VipSoft.Model.MemCard();
     if (row != null)
     {
         if (row["ID"] != null && row["ID"].ToString() != "")
         {
             model.ID = int.Parse(row["ID"].ToString());
         }
         if (row["CardID"] != null)
         {
             model.CardID = row["CardID"].ToString();
         }
         if (row["CardMianID"] != null)
         {
             model.CardMianID = row["CardMianID"].ToString();
         }
         if (row["Name"] != null)
         {
             model.Name = row["Name"].ToString();
         }
         if (row["Sex"] != null && row["Sex"].ToString() != "")
         {
             model.Sex = int.Parse(row["Sex"].ToString());
         }
         if (row["Password"] != null)
         {
             model.Password = row["Password"].ToString();
         }
         if (row["Mobile"] != null)
         {
             model.Mobile = row["Mobile"].ToString();
         }
         if (row["Photo"] != null)
         {
             model.Photo = row["Photo"].ToString();
         }
         if (row["LevelID"] != null && row["LevelID"].ToString() != "")
         {
             model.LevelID = int.Parse(row["LevelID"].ToString());
         }
         if (row["IsPast"] != null && row["IsPast"].ToString() != "")
         {
             if ((row["IsPast"].ToString() == "1") || (row["IsPast"].ToString().ToLower() == "true"))
             {
                 model.IsPast = true;
             }
             else
             {
                 model.IsPast = false;
             }
         }
         if (row["PastTime"] != null && row["PastTime"].ToString() != "")
         {
             model.PastTime = DateTime.Parse(row["PastTime"].ToString());
         }
         if (row["Point"] != null && row["Point"].ToString() != "")
         {
             model.Point = int.Parse(row["Point"].ToString());
         }
         if (row["State"] != null && row["State"].ToString() != "")
         {
             model.State = int.Parse(row["State"].ToString());
         }
         if (row["IsPointAuto"] != null && row["IsPointAuto"].ToString() != "")
         {
             if ((row["IsPointAuto"].ToString() == "1") || (row["IsPointAuto"].ToString().ToLower() == "true"))
             {
                 model.IsPointAuto = true;
             }
             else
             {
                 model.IsPointAuto = false;
             }
         }
         if (row["Money"] != null && row["Money"].ToString() != "")
         {
             model.Money = decimal.Parse(row["Money"].ToString());
         }
         if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "")
         {
             model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString());
         }
         if (row["ShopID"] != null && row["ShopID"].ToString() != "")
         {
             model.ShopID = int.Parse(row["ShopID"].ToString());
         }
         if (row["ShopName"] != null)
         {
             model.ShopName = row["ShopName"].ToString();
         }
         if (row["LastTime"] != null && row["LastTime"].ToString() != "")
         {
             model.LastTime = DateTime.Parse(row["LastTime"].ToString());
         }
         if (row["Email"] != null)
         {
             model.Email = row["Email"].ToString();
         }
         if (row["PayMoney"] != null && row["PayMoney"].ToString() != "")
         {
             model.PayMoney = decimal.Parse(row["PayMoney"].ToString());
         }
         if (row["Remark"] != null)
         {
             model.Remark = row["Remark"].ToString();
         }
         if (row["CardTypeID"] != null && row["CardTypeID"].ToString() != "")
         {
             model.CardTypeID = int.Parse(row["CardTypeID"].ToString());
         }
     }
     return(model);
 }
Пример #13
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(VipSoft.Model.MemCard model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update MemCard set ");
            strSql.Append("CardID=@CardID,");
            strSql.Append("CardMianID=@CardMianID,");
            strSql.Append("Name=@Name,");
            strSql.Append("Sex=@Sex,");
            strSql.Append("Password=@Password,");
            strSql.Append("Mobile=@Mobile,");
            strSql.Append("Photo=@Photo,");
            strSql.Append("LevelID=@LevelID,");
            strSql.Append("IsPast=@IsPast,");
            strSql.Append("PastTime=@PastTime,");
            strSql.Append("Point=@Point,");
            strSql.Append("State=@State,");
            strSql.Append("IsPointAuto=@IsPointAuto,");
            strSql.Append("Money=@Money,");
            strSql.Append("TotalMoney=@TotalMoney,");
            strSql.Append("ShopID=@ShopID,");
            strSql.Append("ShopName=@ShopName,");
            strSql.Append("LastTime=@LastTime,");
            strSql.Append("Email=@Email,");
            strSql.Append("PayMoney=@PayMoney,");
            strSql.Append("Remark=@Remark,");
            strSql.Append("CardTypeID=@CardTypeID");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CardID",      SqlDbType.VarChar,     50),
                new SqlParameter("@CardMianID",  SqlDbType.VarChar,     50),
                new SqlParameter("@Name",        SqlDbType.VarChar,     50),
                new SqlParameter("@Sex",         SqlDbType.Int,          4),
                new SqlParameter("@Password",    SqlDbType.VarChar,     20),
                new SqlParameter("@Mobile",      SqlDbType.VarChar,     20),
                new SqlParameter("@Photo",       SqlDbType.VarChar,     20),
                new SqlParameter("@LevelID",     SqlDbType.Int,          4),
                new SqlParameter("@IsPast",      SqlDbType.Bit,          1),
                new SqlParameter("@PastTime",    SqlDbType.DateTime),
                new SqlParameter("@Point",       SqlDbType.Int,          4),
                new SqlParameter("@State",       SqlDbType.Int,          4),
                new SqlParameter("@IsPointAuto", SqlDbType.Bit,          1),
                new SqlParameter("@Money",       SqlDbType.Money,        8),
                new SqlParameter("@TotalMoney",  SqlDbType.Money,        8),
                new SqlParameter("@ShopID",      SqlDbType.Int,          4),
                new SqlParameter("@ShopName",    SqlDbType.VarChar,     50),
                new SqlParameter("@LastTime",    SqlDbType.DateTime),
                new SqlParameter("@Email",       SqlDbType.VarChar,     50),
                new SqlParameter("@PayMoney",    SqlDbType.Money,        8),
                new SqlParameter("@Remark",      SqlDbType.VarChar,   1000),
                new SqlParameter("@CardTypeID",  SqlDbType.Int,          4),
                new SqlParameter("@ID",          SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.CardID;
            parameters[1].Value  = model.CardMianID;
            parameters[2].Value  = model.Name;
            parameters[3].Value  = model.Sex;
            parameters[4].Value  = model.Password;
            parameters[5].Value  = model.Mobile;
            parameters[6].Value  = model.Photo;
            parameters[7].Value  = model.LevelID;
            parameters[8].Value  = model.IsPast;
            parameters[9].Value  = model.PastTime;
            parameters[10].Value = model.Point;
            parameters[11].Value = model.State;
            parameters[12].Value = model.IsPointAuto;
            parameters[13].Value = model.Money;
            parameters[14].Value = model.TotalMoney;
            parameters[15].Value = model.ShopID;
            parameters[16].Value = model.ShopName;
            parameters[17].Value = model.LastTime;
            parameters[18].Value = model.Email;
            parameters[19].Value = model.PayMoney;
            parameters[20].Value = model.Remark;
            parameters[21].Value = model.CardTypeID;
            parameters[22].Value = model.ID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #14
0
        private void searchMember1_EventMemberSelected(Model.MemCard selectedMemInfo)
        {
            memInfo = selectedMemInfo;
            if (memInfo.IsPast && memInfo.PastTime <= DateTime.Now)
            {
                memInfo = null;
                ClearFormText();
                MessageBox.Show("对不起,此会员卡有效期限已过,无法进行消费。");
                this.searchMember1.CardID = "";
            }
            else
            {
                BindMemberMsg();

                if (this.dataGridView_List.Rows.Count > 0)
                {
                    this.dataGridView_List.Rows[this.dataGridView_List.Rows.Count - 1].Selected = true;
                }
                textBox_GoodsCode.Focus();
                textBox_GoodsCode.SelectAll();
            }
        }
Пример #15
0
        // 确认结算时
        // 订单表中插入记录、订单详细表、账户金额积分处理
        // 系统日志
        void exp_ExpenseResultSelected(OrderPayType expType, decimal payMoney, decimal payCard, decimal payCash, decimal payCredit, decimal payVoucher, decimal moneyZero)
        {
            string orderCode = CreateOrderCode();
            payInfo = payCard + "|" + payCash + "|" + payCredit + "|" + payVoucher;
            // 如果修改了金额,积分需要重新计算一下的
            int point = totalPoint;

            List<VipSoft.Model.OrderDetail> ListDetail = new List<VipSoft.Model.OrderDetail>();
            VipSoft.Model.OrderDetail detail;

            foreach (TempOrderInfo temp in listOrder)
            {
                detail = new VipSoft.Model.OrderDetail();
                detail.OrderCode=orderCode;
                detail.GoodsID=temp.GInfo.ID;
                detail.GoodsCode=temp.GInfo.GoodsCode;
                detail.GoodsName=temp.GInfo.Name;
                detail.OrderCode=orderCode;
                detail.Number=temp.Number;
                detail.Percent=temp.Discount;
                detail.IsService=temp.GInfo.GoodsType==(byte)0?true:false;
                detail.Price=temp.GInfo.Price;
                detail.DiscountPrice=temp.DiscountPrice;
                ListDetail.Add(detail);
            }
            VipSoft.BLL.OrderLog oLog = new VipSoft.BLL.OrderLog();
            bool ok;
            string logStrType, logStrOk, logStrErr;
            if (IsTravelerMember)
            {
                order = new Model.OrderLog();
                order.OrderCode = orderCode;
                order.OrderType = 0;
                order.MemID = 59;
                order.MemName = "散客消费";
                order.CardID = "0";
                order.CreateDateTime = DateTime.Now;
                order.DisCountMoney = discountPrice;
                order.MasterID = PublicState.Master.ID;
                order.MasterName = PublicState.Master.Name;
                order.PayInfo = payInfo;
                order.PayType = (int)expType;
                order.Point = totalPoint;
                order.ShopID = PublicState.Master.ShopID;
                order.ShopName = PublicState.Master.ShopName;
                order.TotalMoney = totalPrice;
                order.TotalNumber = totalNumber;

                ok = oLog.Add(order, ListDetail);

                logStrType = "散客消费";
                logStrOk = string.Format("消费成功,订单号:{0}消费金额:{1}", order.OrderCode, order.DisCountMoney);
                logStrErr = string.Format("消费失败,消费金额:{0}", order.DisCountMoney);
            }
            else
            {
                order = new Model.OrderLog();
                order.OrderCode = orderCode;
                order.OrderType = 0;
                order.MemID = memInfo.ID;
                order.MemName = memInfo.Name;
                order.CardID = memInfo.CardID;
                order.CreateDateTime = DateTime.Now;
                order.DisCountMoney = discountPrice;
                order.MasterID = PublicState.Master.ID;
                order.MasterName = PublicState.Master.Name;
                order.PayInfo = payInfo;
                order.PayType = (int)expType;
                order.Point = totalPoint;
                order.TotalMoney = totalPrice;
                order.TotalNumber = totalNumber;
                order.ShopID = PublicState.Master.ShopID;
                order.ShopName = PublicState.Master.ShopName;

                ok = oLog.Add(order, ListDetail);
                if (ok)
                {
                    VipSoft.BLL.MemCard bllMemCard = new BLL.MemCard();
                    VipSoft.BLL.PointLog bllPointLog = new BLL.PointLog();
                    memInfo.Point += totalPoint;
                    memInfo.TotalMoney += discountPrice;
                    memInfo.LastTime = DateTime.Now;
                    memInfo.Money -= payCard;
                    bllMemCard.Update(memInfo);
                    memInfo = bllMemCard.GetModel(memInfo.ID);

                    VipSoft.Model.PointLog modelPointLog = new Model.PointLog();
                    modelPointLog.CardID = memInfo.CardID;
                    modelPointLog.CreateDateTime = DateTime.Now;
                    modelPointLog.MemName = memInfo.Name;
                    modelPointLog.Point = totalPoint;
                    modelPointLog.ShopID = PublicState.Master.ShopID;
                    modelPointLog.ShopName = PublicState.Master.ShopName;
                    modelPointLog.Type = (int)PointLogType.OrderPoint;
                    bllPointLog.Add(modelPointLog);
                }

                logStrType = "会员消费";
                logStrOk = string.Format("消费成功,订单号:{0}会员卡号:{1}姓名:{2}消费金额:{3}所得积分:{4}付费方式:{5}",
                    order.OrderCode, order.CardID, order.MemName, order.DisCountMoney, order.Point, order.PayType.ToString());
                logStrErr = string.Format("消费失败,会员卡号:{0}姓名:{1}消费金额:{2}所得积分:{3}付费方式:{4}",
                    order.CardID, order.MemName, order.DisCountMoney, order.Point, order.PayType.ToString());
            }

            if (ok)
            {
                VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
                log.Add(new VipSoft.Model.SysLog(PublicState.Master, logStrType, logStrOk, DateTime.Now));

                // 更新当前会员的财务信息,因为打印的时候和更新等级的时候都需要显示出来
                if (!IsTravelerMember)
                {
                    memInfo = new VipSoft.BLL.MemCard().GetModel(memInfo.ID);
                    Function.UpdateMemberLevel(1, memInfo);
                }
                MessageBox.Show("消费成功。");

                // 清除数据
                this.label_OTMoney.Text = "";
                this.label_OTMoney2.Text = "";
                this.label_OTNumber.Text = "";
                this.label_OTPoint.Text = "";
                this.label_OTActivity.Text = "";
                listOrder = new List<TempOrderInfo>();
                order = null;
                this.dataGridView_List.Rows.Clear();
                ClearFormText();
                memInfo = null;
            }
            else
            {
                MessageBox.Show("系统错误导致消费失败,请重试。");
                // 记录日志
                VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
                log.Add(new VipSoft.Model.SysLog(PublicState.Master, logStrType,  logStrErr, DateTime.Now));
            }
        }
Пример #16
0
        private void Expense_Load(object sender, EventArgs e)
        {
            ClearFormText();
            if (CurrentCardID != "")
            {
                VipSoft.BLL.MemCard card = new VipSoft.BLL.MemCard();
                memInfo = card.GetModel(CurrentCardID);
                if (memInfo != null)
                    BindMemberMsg();
                this.textBox_GoodsCode.Select();
            }
            else
                this.searchMember1.Select();

            BindGoodsTree();
        }