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));
}
}
