//添加订单流水信息 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 updateOrderInfo(string orderId) { TM_OrderListBiz orderListBiz = new TM_OrderListBiz(); orderListBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_UpdateOrderInfoByOrderId] '"+ orderId + "'," + ConstantList.ORDER_STATES_SUCCESS + ",'" + DateTime.Now + "'"); }