public bool AddZcOrderRefundItemI(ZcOrderRefundItem obj) { bool flag = false; string sql = "insert into zc_order_refund_item (id, createTime, updateTime, serialNumber, order_id, order_nums, refund_nums, price, refund_amount, salesman_id, hand_date, street, goodsFile_id, refund_id, refund_reason) values (:id,:createTime,:updateTime,:serialNumber,:order_id,:order_nums,:refund_nums,:price,:refund_amount,:salesman_id,:hand_date,:street,:goodsFile_id,:refund_id,:refund_reason)"; OracleConnection conn = null; OracleCommand cmd = new OracleCommand(); OracleTransaction tran = null; try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; cmd.Parameters.Add(":id", obj.Id); cmd.Parameters.Add(":createTime", obj.CreateTime); cmd.Parameters.Add(":updateTime", obj.UpdateTime); cmd.Parameters.Add(":serialNumber", obj.SerialNumber); cmd.Parameters.Add(":order_id", obj.Order_id); cmd.Parameters.Add(":order_nums", obj.Order_nums); cmd.Parameters.Add(":refund_nums", obj.Refund_nums); cmd.Parameters.Add(":price", obj.Price); cmd.Parameters.Add(":refund_amount", obj.Refund_amount); cmd.Parameters.Add(":salesman_id", obj.Salesman_id); cmd.Parameters.Add(":hand_date", obj.Hand_date); cmd.Parameters.Add(":street", obj.Street); cmd.Parameters.Add(":goodsFile_id", obj.GoodsFile_id); cmd.Parameters.Add(":refund_id", obj.Refund_id); cmd.Parameters.Add(":refund_reason", obj.Refund_reason); cmd.ExecuteNonQuery(); tran.Commit(); flag = true; } catch (Exception ex) { tran.Rollback(); flag = false; log.Error("上传退款明细数据到服务器发生异常", ex); } finally { cmd.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } return(flag); }
public ZcOrderRefundItem FindById(string p) { ZcOrderRefundItem obj = new ZcOrderRefundItem(); string sql = "select * from zc_order_refund_item where id = @id"; MySqlConnection conn = null; MySqlCommand cmd = new MySqlCommand(); try { conn = GetConnection(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@id", p); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1); obj.UpdateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(2); obj.SerialNumber = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); obj.Order_id = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.Order_nums = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.Refund_nums = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); obj.Price = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.Refund_amount = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); obj.Salesman_id = reader.IsDBNull(9) ? string.Empty : reader.GetString(9); obj.Hand_date = reader.IsDBNull(10) ? default(DateTime) : reader.GetDateTime(10); obj.Street = reader.IsDBNull(11) ? string.Empty : reader.GetString(11); obj.GoodsFile_id = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); obj.Refund_id = reader.IsDBNull(13) ? string.Empty : reader.GetString(13); obj.Refund_reason = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); } } catch (Exception ex) { log.Error("根据id获取退款详细信息失败", ex); } finally { cmd.Dispose(); CloseConnection(conn); } return(obj); }
public bool AddZcOrderRefundItemI(ZcOrderRefundItem item) { RefundInfoDao dao = new RefundInfoDao(); return(dao.AddZcOrderRefundItemI(item)); }
/// <summary> /// 网络连通时,上传数据 /// </summary> public static void Upload() { UploadDao dao = new UploadDao(); int count = dao.QueryCount(); if (count != 0) { List <UploadInfo> list = dao.FindAll(); foreach (UploadInfo obj in list) { if (obj.Type == Constant.DAILY_RECEIVE_GOODS) { BranchDailyReceiveGoodsDao dailyDao = new BranchDailyReceiveGoodsDao(); DailyReceiveGoods drg = dailyDao.FindById(obj.Id); drg.CreateTime = DateTime.Now; drg.UpdateTime = DateTime.Now; DailyReceiveGoodsService service = new DailyReceiveGoodsService(); bool flag = service.AddDailyReceiveGoods(drg); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_TRANSIT_UPDATE) { ZcOrderTransitService service = new ZcOrderTransitService(); bool flag = service.UpdateStatus(obj.Id, Constant.ORDER_STATUS_RECEIPT); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.PAY_INFO) { BranchPayInfoService service = new BranchPayInfoService(); PayInfo payInfo = service.FindById(obj.Id); PayInfoService masterService = new PayInfoService(); bool flag = masterService.AddPayInfoI(payInfo); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_HISTORY) { BranchZcOrderHistoryService branchService = new BranchZcOrderHistoryService(); ZcOrderHistory history = branchService.FindById(obj.Id); ZcOrderHistoryService service = new ZcOrderHistoryService(); bool flag = service.AddZcOrderHistoryI(history); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_HISTORY_ITEM) { BranchZcOrderHistoryItemService branchService = new BranchZcOrderHistoryItemService(); ZcOrderHistoryItem item = branchService.FindById(obj.Id); ZcOrderHistoryItemService service = new ZcOrderHistoryItemService(); bool flag = service.AddZcOrderHistoryItemI(item); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_TRANSIT_DELETE) { ZcOrderTransitService service = new ZcOrderTransitService(); bool flag = service.DeleteById(obj.Id); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_TRANSIT_ITEM_DELETE) { ZcOrderTransitItemService service = new ZcOrderTransitItemService(); bool flag = service.DeleteByOrderIdI(obj.Id); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_REFUSE) { BranchZcOrderRefuseService branchService = new BranchZcOrderRefuseService(); ZcOrderRefuse refuse = branchService.FindById(obj.Id); ZcOrderRefuseService service = new ZcOrderRefuseService(); bool flag = service.AddZcOrderRefuseI(refuse); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_REFUSE_ITEM) { BranchZcOrderRefuseItemService branchService = new BranchZcOrderRefuseItemService(); ZcOrderRefuseItem item = branchService.FindById(obj.Id); ZcOrderRefuseItemService service = new ZcOrderRefuseItemService(); bool flag = service.AddZcOrderRefuseItemI(item); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_REFUND) { BranchZcOrderRefundService branchService = new BranchZcOrderRefundService(); ZcOrderRefund refund = branchService.FindById(obj.Id); RefundInfoService service = new RefundInfoService(); bool flag = service.AddZcOrderRefundI(refund); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_REFUND_ITEM) { BranchZcOrderRefundItemService branchService = new BranchZcOrderRefundItemService(); ZcOrderRefundItem item = branchService.FindById(obj.Id); RefundInfoService service = new RefundInfoService(); bool flag = service.AddZcOrderRefundItemI(item); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } else if (obj.Type == Constant.ZC_ORDER_HISTORY_UPDATE) { BranchZcOrderHistoryService branchService = new BranchZcOrderHistoryService(); ZcOrderHistory history = branchService.FindById(obj.Id); ZcOrderHistoryService service = new ZcOrderHistoryService(); bool flag = service.UpdateOrderStatusByIdsI(obj.Id, history.OrderStatus); if (flag) { dao.DeleteByIdAndType(obj.Id, obj.Type); } } } } }