/// <summary> /// 增加一条数据 /// </summary> public int Add(VipSoft.Model.OrderLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderLog("); strSql.Append("OrderCode,OrderType,MemID,CardID,MemName,TotalNumber,TotalMoney,DisCountMoney,PayInfo,Point,CreateDateTime,PayType,MasterID,MasterName,ShopID,ShopName)"); strSql.Append(" values ("); strSql.Append("@OrderCode,@OrderType,@MemID,@CardID,@MemName,@TotalNumber,@TotalMoney,@DisCountMoney,@PayInfo,@Point,@CreateDateTime,@PayType,@MasterID,@MasterName,@ShopID,@ShopName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OrderCode", SqlDbType.NChar, 10), new SqlParameter("@OrderType", SqlDbType.Int, 4), new SqlParameter("@MemID", SqlDbType.Int, 4), new SqlParameter("@CardID", SqlDbType.VarChar, 50), new SqlParameter("@MemName", SqlDbType.VarChar, 20), new SqlParameter("@TotalNumber", SqlDbType.Int, 4), new SqlParameter("@TotalMoney", SqlDbType.Money, 8), new SqlParameter("@DisCountMoney", SqlDbType.Money, 8), new SqlParameter("@PayInfo", SqlDbType.VarChar, 50), new SqlParameter("@Point", SqlDbType.Int, 4), new SqlParameter("@CreateDateTime", SqlDbType.DateTime), new SqlParameter("@PayType", SqlDbType.Int, 4), new SqlParameter("@MasterID", SqlDbType.Int, 4), new SqlParameter("@MasterName", SqlDbType.VarChar, 50), new SqlParameter("@ShopID", SqlDbType.Int, 4), new SqlParameter("@ShopName", SqlDbType.Int, 4) }; parameters[0].Value = model.OrderCode; parameters[1].Value = model.OrderType; parameters[2].Value = model.MemID; parameters[3].Value = model.CardID; parameters[4].Value = model.MemName; parameters[5].Value = model.TotalNumber; parameters[6].Value = model.TotalMoney; parameters[7].Value = model.DisCountMoney; parameters[8].Value = model.PayInfo; parameters[9].Value = model.Point; parameters[10].Value = model.CreateDateTime; parameters[11].Value = model.PayType; parameters[12].Value = model.MasterID; parameters[13].Value = model.MasterName; parameters[14].Value = model.ShopID; parameters[15].Value = model.ShopName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public VipSoft.Model.OrderLog GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,OrderCode,OrderType,MemID,CardID,MemName,TotalNumber,TotalMoney,DisCountMoney,PayInfo,Point,CreateDateTime,PayType,MasterID,MasterName,ShopID,ShopName from OrderLog "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; VipSoft.Model.OrderLog model = new VipSoft.Model.OrderLog(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public VipSoft.Model.OrderLog GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,OrderCode,OrderType,MemID,CardID,MemName,TotalNumber,TotalMoney,DisCountMoney,PayInfo,Point,CreateDateTime,PayType,MasterID,MasterName,ShopID,ShopName from OrderLog "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4) }; parameters[0].Value = ID; VipSoft.Model.OrderLog model=new VipSoft.Model.OrderLog(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public VipSoft.Model.OrderLog DataRowToModel(DataRow row) { VipSoft.Model.OrderLog model=new VipSoft.Model.OrderLog(); if (row != null) { if(row["ID"]!=null && row["ID"].ToString()!="") { model.ID=int.Parse(row["ID"].ToString()); } if(row["OrderCode"]!=null) { model.OrderCode=row["OrderCode"].ToString(); } if(row["OrderType"]!=null && row["OrderType"].ToString()!="") { model.OrderType=int.Parse(row["OrderType"].ToString()); } if(row["MemID"]!=null && row["MemID"].ToString()!="") { model.MemID=int.Parse(row["MemID"].ToString()); } if(row["CardID"]!=null) { model.CardID=row["CardID"].ToString(); } if(row["MemName"]!=null) { model.MemName=row["MemName"].ToString(); } if(row["TotalNumber"]!=null && row["TotalNumber"].ToString()!="") { model.TotalNumber=int.Parse(row["TotalNumber"].ToString()); } if(row["TotalMoney"]!=null && row["TotalMoney"].ToString()!="") { model.TotalMoney=decimal.Parse(row["TotalMoney"].ToString()); } if(row["DisCountMoney"]!=null && row["DisCountMoney"].ToString()!="") { model.DisCountMoney=decimal.Parse(row["DisCountMoney"].ToString()); } if(row["PayInfo"]!=null) { model.PayInfo=row["PayInfo"].ToString(); } if(row["Point"]!=null && row["Point"].ToString()!="") { model.Point=int.Parse(row["Point"].ToString()); } if(row["CreateDateTime"]!=null && row["CreateDateTime"].ToString()!="") { model.CreateDateTime=DateTime.Parse(row["CreateDateTime"].ToString()); } if(row["PayType"]!=null && row["PayType"].ToString()!="") { model.PayType=int.Parse(row["PayType"].ToString()); } if(row["MasterID"]!=null && row["MasterID"].ToString()!="") { model.MasterID=int.Parse(row["MasterID"].ToString()); } if(row["MasterName"]!=null) { model.MasterName=row["MasterName"].ToString(); } if(row["ShopID"]!=null && row["ShopID"].ToString()!="") { model.ShopID=int.Parse(row["ShopID"].ToString()); } if(row["ShopName"]!=null && row["ShopName"].ToString()!="") { model.ShopName=row["ShopName"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public VipSoft.Model.OrderLog DataRowToModel(DataRow row) { VipSoft.Model.OrderLog model = new VipSoft.Model.OrderLog(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["OrderCode"] != null) { model.OrderCode = row["OrderCode"].ToString(); } if (row["OrderType"] != null && row["OrderType"].ToString() != "") { model.OrderType = int.Parse(row["OrderType"].ToString()); } if (row["MemID"] != null && row["MemID"].ToString() != "") { model.MemID = int.Parse(row["MemID"].ToString()); } if (row["CardID"] != null) { model.CardID = row["CardID"].ToString(); } if (row["MemName"] != null) { model.MemName = row["MemName"].ToString(); } if (row["TotalNumber"] != null && row["TotalNumber"].ToString() != "") { model.TotalNumber = int.Parse(row["TotalNumber"].ToString()); } if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "") { model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString()); } if (row["DisCountMoney"] != null && row["DisCountMoney"].ToString() != "") { model.DisCountMoney = decimal.Parse(row["DisCountMoney"].ToString()); } if (row["PayInfo"] != null) { model.PayInfo = row["PayInfo"].ToString(); } if (row["Point"] != null && row["Point"].ToString() != "") { model.Point = int.Parse(row["Point"].ToString()); } if (row["CreateDateTime"] != null && row["CreateDateTime"].ToString() != "") { model.CreateDateTime = DateTime.Parse(row["CreateDateTime"].ToString()); } if (row["PayType"] != null && row["PayType"].ToString() != "") { model.PayType = int.Parse(row["PayType"].ToString()); } if (row["MasterID"] != null && row["MasterID"].ToString() != "") { model.MasterID = int.Parse(row["MasterID"].ToString()); } if (row["MasterName"] != null) { model.MasterName = row["MasterName"].ToString(); } if (row["ShopID"] != null && row["ShopID"].ToString() != "") { model.ShopID = int.Parse(row["ShopID"].ToString()); } if (row["ShopName"] != null && row["ShopName"].ToString() != "") { model.ShopName = int.Parse(row["ShopName"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(VipSoft.Model.OrderLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrderLog set "); strSql.Append("OrderCode=@OrderCode,"); strSql.Append("OrderType=@OrderType,"); strSql.Append("MemID=@MemID,"); strSql.Append("CardID=@CardID,"); strSql.Append("MemName=@MemName,"); strSql.Append("TotalNumber=@TotalNumber,"); strSql.Append("TotalMoney=@TotalMoney,"); strSql.Append("DisCountMoney=@DisCountMoney,"); strSql.Append("PayInfo=@PayInfo,"); strSql.Append("Point=@Point,"); strSql.Append("CreateDateTime=@CreateDateTime,"); strSql.Append("PayType=@PayType,"); strSql.Append("MasterID=@MasterID,"); strSql.Append("MasterName=@MasterName,"); strSql.Append("ShopID=@ShopID,"); strSql.Append("ShopName=@ShopName"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@OrderCode", SqlDbType.NChar, 10), new SqlParameter("@OrderType", SqlDbType.Int, 4), new SqlParameter("@MemID", SqlDbType.Int, 4), new SqlParameter("@CardID", SqlDbType.VarChar, 50), new SqlParameter("@MemName", SqlDbType.VarChar, 20), new SqlParameter("@TotalNumber", SqlDbType.Int, 4), new SqlParameter("@TotalMoney", SqlDbType.Money, 8), new SqlParameter("@DisCountMoney", SqlDbType.Money, 8), new SqlParameter("@PayInfo", SqlDbType.VarChar, 50), new SqlParameter("@Point", SqlDbType.Int, 4), new SqlParameter("@CreateDateTime", SqlDbType.DateTime), new SqlParameter("@PayType", SqlDbType.Int, 4), new SqlParameter("@MasterID", SqlDbType.Int, 4), new SqlParameter("@MasterName", SqlDbType.VarChar, 50), new SqlParameter("@ShopID", SqlDbType.Int, 4), new SqlParameter("@ShopName", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.OrderCode; parameters[1].Value = model.OrderType; parameters[2].Value = model.MemID; parameters[3].Value = model.CardID; parameters[4].Value = model.MemName; parameters[5].Value = model.TotalNumber; parameters[6].Value = model.TotalMoney; parameters[7].Value = model.DisCountMoney; parameters[8].Value = model.PayInfo; parameters[9].Value = model.Point; parameters[10].Value = model.CreateDateTime; parameters[11].Value = model.PayType; parameters[12].Value = model.MasterID; parameters[13].Value = model.MasterName; parameters[14].Value = model.ShopID; parameters[15].Value = model.ShopName; parameters[16].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void treeView_goods_DoubleClick(object sender, EventArgs e) { TreeNode node = this.treeView_goods.SelectedNode; if (node == null) return; if (node.Name.IndexOf("goods_") == -1) { string msg = "双击产品名称即可选择该产品,双击类别将无效。"; this.toolTip_Tree.Show(msg, this.treeView_goods); } else { if (memInfo==null && !IsTravelerMember) { MessageBox.Show("请先选择要消费的会员。"); this.searchMember1.Focus(); return; } int id = int.Parse(node.Name.Replace("goods_", "")); goodsInfo = new VipSoft.BLL.Goods().GetModel(id); if (goodsInfo.Number <= 0 && goodsInfo.GoodsType == (byte)0) { MessageBox.Show("此产品暂时缺货!"); return; } TempOrderInfo order = GetTempOrderItem(id); if (order != null) { SelectGoods(order.GInfo.GoodsCode); } order = GetTempOrderItem(id); if (order == null) { goodsInfo = new VipSoft.BLL.Goods().GetModel(id); if (goodsInfo == null) { MessageBox.Show("未找到产品,请刷新列表,然后重新选择。"); return; } this.label_Guid.Text = ""; BindSelectedGoods(); AddOrder(goodsInfo.GoodsCode); } else { goodsInfo = order.GInfo; this.label_Guid.Text = order.Guid; BindSelectedGoods(order.Number); } } }
// 确认结算时 // 订单表中插入记录、订单详细表、账户金额积分处理 // 系统日志 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)); } }