public ExpResult(decimal _totalMoney, bool _isTravelerMember, VipSoft.Model.MemCard _memInfo) { totalMoney = _totalMoney; isTravelerMember = _isTravelerMember; memInfo = _memInfo; InitializeComponent(); }
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(); }
/// <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); } }
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(); } } }
/// <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(); }
/// <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; }
/// <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; } }
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(); } }
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"); }
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"); } }
/// <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)); } }
/// <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); }
/// <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); } }
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(); } }
// 确认结算时 // 订单表中插入记录、订单详细表、账户金额积分处理 // 系统日志 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)); } }
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(); }