public bool AddZcOrderRefuseItemI(ZcOrderRefuseItem obj) { bool flag = false; string sql = "insert into zc_order_refuse_item (ID, CREATETIME, UPDATETIME, HAND_DATE, ORDER_ID, ORDER_NUMS, " + " PRICE, REFUSE_AMOUNT, REFUSE_NUMS, REFUSE_REASON, SALESMAN_ID, SERIALNUMBER, STREET, GOODSFILE_ID, REFUSE_ID ) " + " values (:id, :createTime, :updateTime, :hand_date, :order_id, :order_nums, :price, " + " :refuse_amount, :refuse_nums, :reason, :salesman_id , :serialNumber, :street, :goodsFile_id, :refuse_id)"; OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); 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(":hand_date", obj.handDate); cmd.Parameters.Add(":order_id", obj.orderId); cmd.Parameters.Add(":order_nums", obj.orderNums); cmd.Parameters.Add(":price", obj.price); cmd.Parameters.Add(":refuse_amount", obj.refuseAmount); cmd.Parameters.Add(":refuse_nums", obj.refuseNums); cmd.Parameters.Add(":reason", obj.refuseReason); cmd.Parameters.Add(":salesman_id", obj.salesmanId); cmd.Parameters.Add(":serialNumber", obj.serialNumber); cmd.Parameters.Add(":street", obj.street); cmd.Parameters.Add(":goodsFile_id", obj.goodsFileId); cmd.Parameters.Add(":refuse_id", obj.refuseId); cmd.ExecuteNonQuery(); tran.Commit(); flag = true; } catch (Exception ex) { tran.Rollback(); flag = false; log.Error("新增拒收明细发生异常", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } return(flag); }
public ZcOrderRefuseItem FindById(string p) { ZcOrderRefuseItem obj = new ZcOrderRefuseItem(); string sql = "select * from zc_order_refuse_item where id = @id"; MySqlConnection conn = null; MySqlTransaction tran = null; MySqlCommand cmd = new MySqlCommand(); try { conn = GetConnection(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; 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.orderId = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.orderNums = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.refuseNums = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); obj.price = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.refuseAmount = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); obj.salesmanId = reader.IsDBNull(9) ? string.Empty : reader.GetString(9); obj.handDate = reader.IsDBNull(10) ? default(DateTime) : reader.GetDateTime(10); obj.street = reader.IsDBNull(11) ? string.Empty : reader.GetString(11); obj.goodsFileId = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); obj.refuseId = reader.IsDBNull(13) ? string.Empty : reader.GetString(13); obj.refuseReason = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); } } catch (Exception ex) { log.Error("根据id获取拒收详细信息失败", ex); } finally { cmd.Dispose(); CloseConnection(conn); } return(obj); }
public bool AddZcOrderRefuseItemI(ZcOrderRefuseItem item) { ZcOrderRefuseItemDao dao = new ZcOrderRefuseItemDao(); return(dao.AddZcOrderRefuseItemI(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); } } } } }