//添加订单流水信息 private void addWaterBill(string orderId, string depositMoney) { TM_WaterBill waterBill = new TM_WaterBill(); waterBill.BiId = Guid.NewGuid(); waterBill.UBId = getUserId(); TM_OrderListBiz orderListBiz = new TM_OrderListBiz(); DataSet result = orderListBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_GetOrderIdByWeixinId] '"+ GetUData.OpenId + "'"); waterBill.FId = (Guid)result.Tables[0].Rows[0][0]; waterBill.NCode = orderId; waterBill.WMney = decimal.Parse(depositMoney); //waterBill.Platform //waterBill.BType=ConstantList.WATER_BILL_TYPE_RECEIVE //TODO 类型与平台? DateTime now = DateTime.ParseExact(GetUData.Timestamp, "yyyyMMddHHmmss", null); waterBill.Years = (short)now.Year; waterBill.Months = (byte)now.Month; waterBill.Days = now.Month + "-" + now.Day; waterBill.Weeks = now.DayOfWeek.ToString(); waterBill.CreateTime = DateTime.Now; waterBill.isDeleted = false; TM_WaterBillBiz waterBillBiz = new TM_WaterBillBiz(); waterBillBiz.Add(waterBill); }
//添加订单信息 private void addOrderInfo(string orderId, string money) { TM_OrderList orderList = new TM_OrderList(); orderList.OiId = Guid.NewGuid(); orderList.UOId = getUserId(); orderList.SOId = Guid.Empty; orderList.NCode = orderId; orderList.OMuney = decimal.Parse(money); orderList.SaleType = ConstantList.ORDER_SALE_TYPE_PERSON; orderList.States = ConstantList.ORDER_STATES_UNPAID; //TODO 支付类型判断 orderList.PayType = ConstantList.ORDER_PAYMENT_TYPE_UNION; DateTime now = DateTime.Now; orderList.CreateTime = now; orderList.isDeleted = false; TM_OrderListBiz orderListBiz = new TM_OrderListBiz(); orderListBiz.Add(orderList); }
//订单完成后更新信息 private void updateOrderInfo(string orderId) { TM_OrderListBiz orderListBiz = new TM_OrderListBiz(); orderListBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_UpdateOrderInfoByOrderId] '"+ orderId + "'," + ConstantList.ORDER_STATES_SUCCESS + ",'" + DateTime.Now + "'"); }