void BindOrderLogList() { this.dataGridView_OrderList.Rows.Clear(); string str = QueryCondition(); DataSet ds = new VipSoft.BLL.OrderLog().GetList(QueryCondition()); foreach (DataRow dr in ds.Tables[0].Rows) { this.dataGridView_OrderList.Rows.Add(dr["ID"].ToString(),dr["OrderCode"].ToString(),dr["CardID"].ToString(),dr["MemName"].ToString(),dr["TotalMoney"].ToString(),dr["DisCountMoney"].ToString(),dr["DisCountMoney"].ToString(),dr["TotalNumber"].ToString(),dr["Point"].ToString(),GetOrderType(dr["PayType"].ToString()),dr["CreateDateTime"].ToString()); } }
private void BindMemExpHistoryThread() { Thread.Sleep(100); string[] condition = { "MemID=" + memInfo.ID }; VipSoft.BLL.OrderLog ol = new VipSoft.BLL.OrderLog(); int rescount = 0; DataTable dt = ol.GetList(20, 0, out rescount, condition).Tables[0]; MainFormHistoryHandler handler = new MainFormHistoryHandler(BindMemExpHistoryInvoke); if (this.IsHandleCreated) this.BeginInvoke(handler, dt); }
private void dgvMCollect_CellClick(object sender, DataGridViewCellEventArgs e) { this.dgvMWater.Rows.Clear(); if (this.dgvMCollect.SelectedRows.Count == 0) return; StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_M_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_M_Start.Value.ToShortDateString() + " " + this.maskedTextBox_M_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_M_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_M_End.Value.ToShortDateString() + " " + this.maskedTextBox_M_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append("CreateDateTime <= '" + time2.ToString() + "'"); } if (this.comboBox_M_OrderType.SelectedIndex == 1) sb.Append(" and OrderType=0");// 余额消费 else if (this.comboBox_M_OrderType.SelectedIndex == 2) sb.Append(" and OrderType=1");// 记次 if (this.comboBox_M_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_M_Class.SelectedItem)["Value"].ToString(); DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" and GoodsID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" and GoodsID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.textBox_M_Price.Text != "¥0.00" && this.textBox_M_Price.Text != "") sb.Append(" and Price" + this.comboBox_M_Sign.Text + this.textBox_M_Price.Text.Replace("¥", "")); if (this.searchMember4.CardID != "") { searchMember4.GetSearchMember(); sb.Append(" and MemID=" + this.searchMember4.MemID); } string cardID = this.dgvMCollect.SelectedRows[0].Cells[0].Value.ToString(); DataSet dst = null; //单据表 if (sb.ToString() != "") { dst = new VipSoft.BLL.OrderLog().GetListCollect("SELECT CardID,GoodsCode,GoodsName,sum(Number) as Numbers,Price, sum(DiscountPrice) as sumMoneys from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode where " + sb.ToString() + " and CardID='" + cardID + "' and orderType not in (2,3,8) group by GoodsCode,GoodsName,Price,DiscountPrice,cardID"); } else { dst = new VipSoft.BLL.OrderLog().GetListCollect("SELECT CardID,GoodsCode,GoodsName,sum(Number) as Numbers,Price, sum(DiscountPrice) as sumMoneys from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode where " + sb.ToString() + " CardID='" + cardID + "' and orderType not in (2,3,8) group by GoodsCode,GoodsName,Price,DiscountPrice,cardID"); } foreach (DataRow drst in dst.Tables[0].Rows) { this.dgvMWater.Rows.Add(drst["GoodsCode"], drst["GoodsName"], drst["Price"], drst["sumMoneys"], drst["Numbers"], drst["sumMoneys"]); } }
private void dgvGCollect_CellClick(object sender, DataGridViewCellEventArgs e) { this.dgvGWater.Rows.Clear(); if (this.dgvGCollect.SelectedRows.Count == 0) return; string goodsCode = this.dgvGCollect.SelectedRows[0].Cells[0].Value.ToString(); DataSet dt = null; StringBuilder sb = new StringBuilder(); if (this.dateTimePicker_G_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_G_Start.Value.ToShortDateString() + " " + this.maskedTextBox_G_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" a.CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_G_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_G_End.Value.ToShortDateString() + " " + this.maskedTextBox_G_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append(" a.CreateDateTime <= '" + time2.ToString() + "'"); } string type; if (this.comboBox_G_OrderType.SelectedIndex == 1) { sb.Append(" and a.OrderType=0");// 余额消费 if (this.comboBox_G_PayType.SelectedIndex != -1 && this.comboBox_G_PayType.SelectedIndex != 0) { type = ((DictionaryEntry)this.comboBox_G_PayType.SelectedItem).Value.ToString(); sb.Append(" and a.PayType=" + type); } } else if (this.comboBox_G_OrderType.SelectedIndex == 2) sb.Append(" and a.OrderType=1");// 记次 else if (this.comboBox_G_OrderType.SelectedIndex == 3) sb.Append(" and a.OrderType=2");// 退货 DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; if (this.comboBox_G_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_G_Class.SelectedItem)["Value"].ToString(); string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" b.GoodsID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" b.GoodsID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.TextBox_G_Key.Text != "") sb.Append(" b.GoodsCode='" + this.TextBox_G_Key.Text + "' or b.GoodsName like '%" + this.TextBox_G_Key.Text + "%'"); if (this.textBox_G_Price.Text != "¥0.00" && this.textBox_G_Price.Text != "") sb.Append(" b.Price" + this.comboBox_G_Sign.Text + this.textBox_G_Price.Text.Replace("¥", "")); if (this.searchMember4.CardID != "") { searchMember4.GetSearchMember(); sb.Append("MemID=" + this.searchMember4.MemID); } if (sb.ToString() != "") { dt = new VipSoft.BLL.OrderLog().GetListCollect("SELECT a.OrderCode,a.CardID,a.MemName,b.Number,b.DiscountPrice,a.DiscountMoney,a.OrderType,a.CreateTime,b.GoodsCode ,b.GoodsName,b.GoodsID,b.OrderCode from OrderLog as a left join OrderDetail as b on a.OrderCode=b.OrderCode where " + sb.ToString() + " and b.GoodsCode='" + goodsCode + "' and a.OrderType not in (2,3,8)"); } else { dt = new VipSoft.BLL.OrderLog().GetListCollect("SELECT a.OrderCode,a.CardID,a.MemName,b.Number,b.DiscountPrice,a.DiscountMoney,a.OrderType,a.CreateTime ,a.GoodsCode,a.GoodsName,b.GoodsCode,b.OrderCode from OrderLog as a left join OrderDetail as b on a.GoodsCode=b.GoodsCode where " + sb.ToString() + " b.GoodsCode='" + goodsCode + "' and a.OrderType not in (2,3,8)"); } // todo ddddddsssssss foreach (DataRow dr in dt.Tables[0].Rows) { this.dgvGWater.Rows.Add(dr["a.OrderCode"], dr["CardID"], dr["MemName"], dr["Number"], dr["DiscountPrice"], dr["DiscountMoney"], dr["OrderType"].ToString() == "0" ? "储值消费" : (dr["OrderType"].ToString() == "1" ? "记次消费" : (dr["OrderType"].ToString() == "2" ? "退货" : "累计积分")), dr["CreateTime"]); } }
private void button_Query_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_Start.Value.ToShortDateString() + " " + this.maskedTextBox5.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and OrderLog.CreateDateTime>='" + t1 + "'"); } if (this.dateTimePicker_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_End.Value.ToShortDateString() + " " + this.maskedTextBox_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append(" and OrderLog.CreateDateTime<='" + t2 + "'"); } sb.Append(" and OrderLog.OrderType=0"); if (this.comboBox_CardLevel.SelectedIndex != -1 && this.comboBox_CardLevel.SelectedIndex != 0) { int level = int.Parse(((DictionaryEntry)this.comboBox_CardLevel.SelectedItem).Value.ToString()); string ids = new VipSoft.BLL.MemCard().GetMemIDs(level); } if (this.searchMember1.CardID != "") { searchMember1.GetSearchMember(); sb.Append(" and OrderLog.MemID=" + this.searchMember1.MemID); } if (this.textBox_Money.Text != "¥0.00" && this.textBox_Money.Text != "") sb.Append(" and OrderLog.DiscountMoney" + this.comboBox_Sign.Text + this.textBox_Money.Text.Replace("¥", "")); if (this.TextBox_OrderCode.Text != "") sb.Append(" and orderLog.OrderCode='" + this.TextBox_OrderCode.Text + "'"); this.dgvSellWater.Rows.Clear(); decimal totalmoney = 0; decimal totalNumber = 0; DataTable dt = new VipSoft.BLL.OrderLog().GetOrderGoodsList(sb.ToString()).Tables[0]; if (dt.Rows.Count > 0) { this.loading.Visible = false; } else { this.loading.Visible = true; } foreach (DataRow dr in dt.Rows) { totalmoney += Math.Round(decimal.Parse(dr["DiscountMoney"].ToString()), 2); totalNumber += decimal.Parse(dr["TotalNumber"].ToString()); this.dgvSellWater.Rows.Add(dr["OrderCode"], dr["CardID"], dr["MemName"], dr["DiscountMoney"], dr["CreateDateTime"], Function.GetPayTypeName(int.Parse(dr["PayType"].ToString())), dr["OrderType"].ToString() == "0" ? "储值消费" : (dr["OrderType"].ToString() == "1" ? "记次消费" : (dr["OrderType"].ToString() == "2" ? "退货" : "累计积分")), dr["Remark"]); } this.lbl_summoney.Text = totalmoney.ToString("#0.00"); this.label66.Text = totalNumber.ToString(); }
private void Button_M_Query_Click(object sender, EventArgs e) { this.dgvMWater.Rows.Clear(); this.dgvMCollect.Rows.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_M_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_M_Start.Value.ToShortDateString() + " " + this.maskedTextBox_M_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_M_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_M_End.Value.ToShortDateString() + " " + this.maskedTextBox_M_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append("CreateDateTime <= '" + time2.ToString() + "'"); } if (this.comboBox_M_OrderType.SelectedIndex == 1) sb.Append(" and OrderType=0");// 余额消费 else if (this.comboBox_M_OrderType.SelectedIndex == 2) sb.Append(" and OrderType=1");// 记次 if (this.comboBox_M_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_M_Class.SelectedItem)["Value"].ToString(); DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" and GoodsID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" and GoodsID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.textBox_M_Price.Text != "¥0.00" && this.textBox_M_Price.Text != "") sb.Append(" and Price" + this.comboBox_M_Sign.Text + this.textBox_M_Price.Text.Replace("¥", "")); if (this.searchMember4.CardID != "") { searchMember4.GetSearchMember(); sb.Append(" and MemID=" + this.searchMember4.MemID); } //汇总表 int Mnum = 0; decimal Money = 0; DataSet ds = null; if (sb.ToString() == "") { ds = new VipSoft.BLL.OrderLog().GetListCollect("SELECT MemID,CardID,MemName,sum(Number) as TotalNumbers,sum(DiscountPrice) as DiscountMoneys from OrderLog left join OrderDetail on OrderLog.OrderCode=OrderDetail.OrderCode where " + sb.ToString() + " OrderType not int (2,3,8) group by MemID,CardID,MemName"); } else { ds = new VipSoft.BLL.OrderLog().GetListCollect("SELECT MemID,CardID,MemName,sum(Number) as TotalNumbers,sum(DiscountPrice) as DiscountMoneys from OrderLog left join OrderDetail on OrderLog.OrderCode=OrderDetail.OrderCode where " + sb.ToString() + " and OrderType not in (2,3,8) group by MemID,CardID,MemName"); } if (ds.Tables[0].Rows.Count > 0) { this.lblM_Ing.Visible = false; } else { this.lblM_Ing.Visible = true; } foreach (DataRow dr in ds.Tables[0].Rows) { Mnum += int.Parse(dr["TotalNumbers"].ToString()); Money += Math.Round(decimal.Parse(dr["DiscountMoneys"].ToString()), 2); this.dgvMCollect.Rows.Add(dr["CardID"], dr["MemName"], dr["TotalNumbers"], dr["DiscountMoneys"]); } this.lbl_num.Text = Mnum.ToString(); this.lmoney.Text = Money.ToString("#0.00"); }
private void btnBlackQuery_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_B_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_B_Start.Value.ToShortDateString() + " " + this.maskedTextBox_B_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and OrderLog.CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_B_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_B_End.Value.ToShortDateString() + " " + this.maskedTextBox_B_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append(" and OrderLog.CreateDateTime <= '" + time2.ToString() + "'"); } sb.Append(" and OrderLog.OrderType=2") ;// if (this.comboBox_B_CardLevel.SelectedIndex != -1 && this.comboBox_B_CardLevel.SelectedIndex != 0) { int level = int.Parse(((DictionaryEntry)this.comboBox_B_CardLevel.SelectedItem).Value.ToString()); string ids = new VipSoft.BLL.MemCard().GetMemIDs(level); if (ids != "") sb.Append(" and OrderLog.MemID in (" + ids + ")"); else { sb.Append( " and MemID in (-1)"); } } if (this.searchMember5.CardID != "") { searchMember5.GetSearchMember(); sb.Append(" and OrderLog.MemID=" + this.searchMember5.MemID); } if (this.textBox_B_Money.Text != "¥0.00" && this.textBox_B_Money.Text != "") sb.Append(" and abs(OrderLog.DiscountMoney)" + this.comboBox_B_Sign.Text + this.textBox_B_Money.Text.Replace("¥", "")); if (this.TextBox_B_OrderCode.Text != "") sb.Append(" and OrderLog.OrderCode='" + this.TextBox_B_OrderCode.Text + "'"); this.dgvBlackWater.Rows.Clear(); this.dgvBlackCollect.Rows.Clear(); decimal balckMoney = 0; //退货总金额 decimal balckNumber = 0; //退货总数量 ////流水表 DataTable dt = new VipSoft.BLL.OrderLog().GetOrderGoodsList(sb.ToString()).Tables[0]; if (dt.Rows.Count > 0) { this.load_B_ing.Visible = false; } else { this.load_B_ing.Visible = true; } foreach (DataRow dr in dt.Rows) { balckMoney += Math.Round(decimal.Parse(dr["DiscountMoney"].ToString()), 2); balckNumber += decimal.Parse(dr["TotalNumber"].ToString()); this.dgvBlackWater.Rows.Add(dr["OrderCode"], dr["CardID"], dr["MemName"], dr["DiscountMoney"], dr["CreateDateTime"]); } this.label70.Text = balckNumber.ToString(); this.label68.Text = balckMoney.ToString("¥0.00"); }
private void btn_P_Query_Click(object sender, EventArgs e) { this.dgvPointList.Rows.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_P_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_P_Start.Value.ToShortDateString() + " " + this.maskedTextBox_P_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and OrderLog.CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_P_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_P_End.Value.ToShortDateString() + " " + this.maskedTextBox_P_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append(" and OrderLog.CreateDateTime <= '" + time2.ToString() + "'"); } sb.Append(" and OrderLog.OrderType=3"); if (this.comboBox_P_CardLevel.SelectedIndex != -1 && this.comboBox_P_CardLevel.SelectedIndex != 0) { int level = int.Parse(((DictionaryEntry)this.comboBox_P_CardLevel.SelectedItem).Value.ToString()); string ids = new VipSoft.BLL.MemCard().GetMemIDs(level); if (ids != "") sb.Append("OrderLog.MemID in (" + ids + ")"); else { sb.Append(" and OrderLog.MemID in (-1)"); } } if (this.searchMember2.CardID != "") { searchMember2.GetSearchMember(); sb.Append(" OrderLog.MemID=" + this.searchMember2.MemID); } if (this.textBox_P_Money.Text != "¥0.00" && this.textBox_P_Money.Text != "") sb.Append(" OrderLog.DiscountMoney" + this.comboBox_P_Sign.Text + this.textBox_P_Money.Text.Replace("¥", "")); if (this.TextBox_P_OrderCode.Text != "") sb.Append(" OrderLog.OrderCode='" + this.TextBox_P_OrderCode.Text + "'"); if (this.txtRemark.Text != "") sb.Append(" OrderLog.Remark like '%" + this.txtRemark.Text + "%'"); decimal pmoney = 0; int point = 0; DataSet ds = new VipSoft.BLL.OrderLog().GetOrderPointList(sb.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { pmoney += Math.Round(decimal.Parse(dr["DiscountMoney"].ToString()), 2); point += int.Parse(dr["Point"].ToString()); this.dgvPointList.Rows.Add(dr["OrderCode"], dr["CardID"], dr["MemName"], dr["DiscountMoney"], dr["Point"], dr["CreateDateTime"], Function.GetPayTypeName(int.Parse(dr["PayType"].ToString())), dr["Remark"]); } this.lbl_pnum.Text = point.ToString(); this.lbl_p.Text = pmoney.ToString("#0.00"); }
// 确认结算时 // 订单表中插入记录、订单详细表、账户金额积分处理 // 系统日志 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)); } }