/// <summary> /// 添加数据到服务器 /// </summary> /// <param name="history"></param> public void AddZcOrderHistory(ZcOrderHistory obj) { string sql = "insert into zc_order_history (id, createTime, updateTime, branchId, cansignphone, consignee, goodsnum, isgift, membercardnumber, orderamount, ordercome, orderdate, ordernum, orderreduceamount, orderstatus, ordertotalvalue, pullflag, member_Id, zczoning_id, actual_money, actual_nums) values (:id,:createTime,:updateTime,:branchId,:phone,:consignee,:goodsnum,:isgift," + ":cardNum,:orderAmount,:orderCome,:orderDate,:orderNum,:uceAmount,:status,:total,:flag,:memberId,:zczoningId, :actual_money, :actual_nums)"; 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(new OracleParameter(":id", obj.Id)); cmd.Parameters.Add(new OracleParameter(":createTime", obj.CreateTime)); cmd.Parameters.Add(new OracleParameter(":updateTime", obj.UpdateTime)); cmd.Parameters.Add(new OracleParameter(":branchId", obj.BranchId)); cmd.Parameters.Add(new OracleParameter(":phone", obj.Cansignphone)); cmd.Parameters.Add(new OracleParameter(":consignee", obj.Consignee)); cmd.Parameters.Add(new OracleParameter(":goodsnum", obj.GoodSnum)); cmd.Parameters.Add(new OracleParameter(":isgift", obj.IsGift)); cmd.Parameters.Add(new OracleParameter(":cardNum", obj.MemberCardNumber)); cmd.Parameters.Add(new OracleParameter(":orderAmount", obj.OrderAmount)); cmd.Parameters.Add(new OracleParameter(":orderCome", obj.OrderCome)); cmd.Parameters.Add(new OracleParameter(":orderDate", obj.OrderDate)); cmd.Parameters.Add(new OracleParameter(":orderNum", obj.OrderNum)); cmd.Parameters.Add(new OracleParameter(":uceAmount", obj.OrderRedUceAmount)); cmd.Parameters.Add(new OracleParameter(":status", obj.OrderStatus)); cmd.Parameters.Add(new OracleParameter(":total", obj.OrderTotalValue)); cmd.Parameters.Add(new OracleParameter(":flag", obj.PullFlag)); cmd.Parameters.Add(new OracleParameter(":memberId", obj.MemberId)); cmd.Parameters.Add(new OracleParameter(":zczoningId", obj.ZczoingId)); cmd.Parameters.Add(":actual_money", obj.ActualMoney); cmd.Parameters.Add(":actual_nums", obj.ActualNums); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> uploadList = new List <UploadInfo>(); UploadDao uploadDao = new UploadDao(); UploadInfo obj1 = new UploadInfo(); obj1.Id = obj.Id; obj1.CreateTime = DateTime.Now; obj1.UpdateTime = DateTime.Now; obj1.Type = Constant.ZC_ORDER_HISTORY; uploadList.Add(obj1); uploadDao.AddUploadInfo(uploadList); log.Error("上传zcOrderHistory发生异常", ex); } finally { cmd.Dispose(); tran.Dispose(); OracleUtil.CloseConn(conn); } }
/// <summary> /// 上传退款明细信息 /// </summary> /// <param name="list"></param> public void AddZcOrderRefundItem(List <ZcOrderRefundItem> list) {// 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; foreach (ZcOrderRefundItem obj in list) { 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(); cmd.Parameters.Clear(); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> uploadList = new List <UploadInfo>(); UploadDao uploadDao = new UploadDao(); foreach (ZcOrderRefundItem obj in list) { UploadInfo obj2 = new UploadInfo(); obj2.Id = obj.Id; obj2.CreateTime = DateTime.Now; obj2.UpdateTime = DateTime.Now; obj2.Type = Constant.ZC_ORDER_REFUND_ITEM; uploadList.Add(obj2); } uploadDao.AddUploadInfo(uploadList); log.Error("上传退款明细数据到服务器发生异常", ex); } finally { cmd.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
public void AddPayInfo(List <PayInfo> payList) { OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); string sql = "insert into zc_payinfo (id, createTime, updateTime, branch_id, memberid, orderid, payamount, paydate, paymode, salesman) values (:id, :createTime, :updateTime, :branchId, :memberId, :orderId, :payAmount, :payDate, :payMode, :salesman)"; try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; foreach (PayInfo obj in payList) { cmd.Parameters.Add(":id", obj.Id); cmd.Parameters.Add(":createTime", obj.CreateTime); cmd.Parameters.Add(":updateTime", obj.UpdateTime); cmd.Parameters.Add(":branchId", obj.BranchId); cmd.Parameters.Add(":memberId", obj.MemberId); cmd.Parameters.Add(":orderId", obj.orderId); cmd.Parameters.Add(":payAmount", obj.PayAmount); cmd.Parameters.Add(":payDate", obj.payDate); cmd.Parameters.Add(":payMode", obj.PayMode); cmd.Parameters.Add(":salesman", obj.salesmanId); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> list = new List <UploadInfo>(); foreach (PayInfo obj in payList) { UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.PAY_INFO; list.Add(uploadInfo); } UploadDao uploadDao = new UploadDao(); uploadDao.AddUploadInfo(list); log.Error("添加付款信息发生异常", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
/// <summary> /// 上传零售明细 /// </summary> /// <param name="list"></param> public void AddResaleItem(List <ResaleItem> list) { string sql = "insert into zc_resale_item (id, createTime, updateTime, goodsFile_id, nums, money, resale_id) " + " values(:id, :createTime, :updateTime, :gooodsFileId, :nums, :money, :resaleId)"; OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; foreach (ResaleItem obj in list) { cmd.Parameters.Add(":id", obj.Id); cmd.Parameters.Add(":createTime", obj.CreateTime); cmd.Parameters.Add(":updateTime", obj.UpdateTime); cmd.Parameters.Add(":gooodsFileId", obj.GoodsFileId); cmd.Parameters.Add(":nums", obj.Nums); cmd.Parameters.Add(":money", obj.Money); cmd.Parameters.Add(":resaleId", obj.ResaleId); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> upList = new List <UploadInfo>(); foreach (ResaleItem obj in list) { UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.ZC_RESALE_ITME; upList.Add(uploadInfo); } UploadDao uploadDao = new UploadDao(); uploadDao.AddUploadInfo(upList); log.Error("上传零售明细发生异常", ex); } finally { OracleUtil.CloseConn(conn); } }
/// <summary> /// 上传退款信息 /// </summary> /// <param name="obj"></param> public void AddZcOrderRefund(ZcOrderRefund obj) { string sql = "insert into zc_order_refund (id, createTime, updateTime, order_id, order_amount, actual_amount, order_refund_status, hand_date) values (:id,:createTime,:updateTime,:order_id,:order_amount,:actual_amount,:order_refund_status,:hand_date)"; 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(":order_id", obj.Order_id); cmd.Parameters.Add(":order_amount", obj.Order_amount); cmd.Parameters.Add(":actual_amount", obj.Actual_amount); cmd.Parameters.Add(":order_refund_status", obj.Order_refund_status); cmd.Parameters.Add(":hand_date", obj.Hand_date); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> uploadList = new List <UploadInfo>(); UploadDao dao = new UploadDao(); UploadInfo obj1 = new UploadInfo(); obj1.Id = obj.Id; obj1.CreateTime = DateTime.Now; obj1.UpdateTime = DateTime.Now; obj1.Type = Constant.ZC_ORDER_REFUND; uploadList.Add(obj1); dao.AddUploadInfo(uploadList); log.Error("上传退款信息到服务器失败", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
public void AddZcOrderRefuse(ZcOrderRefuse obj) { string sql = "insert into zc_order_refuse (id, CREATETIME, UPDATETIME, ACTUAL_AMOUNT, ORDER_AMOUNT, ORDER_ID) values (:id, :createTime, :updateTime, :actual_amount, :order_amount, :order_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(":actual_amount", obj.actualAmount); cmd.Parameters.Add(":order_amount", obj.orderAmount); cmd.Parameters.Add(":order_id", obj.orderId); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); UploadDao dao = new UploadDao(); List <UploadInfo> list = new List <UploadInfo>(); UploadInfo obj1 = new UploadInfo(); obj1.Id = obj.id; obj1.CreateTime = DateTime.Now; obj1.UpdateTime = DateTime.Now; obj1.Type = Constant.ZC_ORDER_REFUSE; list.Add(obj1); dao.AddUploadInfo(list); log.Error("上传拒收订单信息异常", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
/// <summary> /// 上传零售信息 /// </summary> /// <param name="obj"></param> public void AddResale(Resale obj) { string sql = "insert into zc_resale (id, createTime, updateTime, waterNumber, nums, money, branch_id, member_id) " + " values (:id, :createTime, :updateTime, :number, :nums, :money, :branchId, :memberId)"; OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.Add(":id", obj.Id); cmd.Parameters.Add(":createTime", obj.CreateTime); cmd.Parameters.Add(":updateTime", obj.UpdateTime); cmd.Parameters.Add(":number", obj.WaterNumber); cmd.Parameters.Add(":nums", obj.Nums); cmd.Parameters.Add(":money", obj.Money); cmd.Parameters.Add(":branchId", obj.BranchId); cmd.Parameters.Add(":memberId", obj.memberId); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.ZC_RESALE; UploadDao uploadDao = new UploadDao(); uploadDao.AddUploadInfo(uploadInfo); log.Error("上传零售信息发生异常", ex); } finally { OracleUtil.CloseConn(conn); } }
public void DeleteByOrderId(string orderNumber) { OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); string sql = "delete from zc_order_transit where id = :id"; cmd.CommandText = sql; cmd.Connection = conn; cmd.Parameters.Add(":id", orderNumber); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> list = new List <UploadInfo>(); UploadDao dao = new UploadDao(); UploadInfo obj = new UploadInfo(); obj.Id = orderNumber; obj.CreateTime = DateTime.Now; obj.UpdateTime = DateTime.Now; obj.Type = Constant.ZC_ORDER_TRANSIT_DELETE; list.Add(obj); dao.AddUploadInfo(list); log.Error("服务器订单号删除订单失败", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
/// <summary> /// 更新历史订单状态 /// </summary> /// <param name="id"></param> /// <param name="status"></param> public void UpdateOrderStatusByIds(string id, string status) { string sql = "update zc_order_history set orderstatus = '" + status + "' where id =" + 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.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> uploadList = new List <UploadInfo>(); UploadDao DAO = new UploadDao(); UploadInfo obj3 = new UploadInfo(); obj3.Id = id; obj3.CreateTime = DateTime.Now; obj3.UpdateTime = DateTime.Now; obj3.Type = Constant.ZC_ORDER_HISTORY_UPDATE; uploadList.Add(obj3); DAO.AddUploadInfo(uploadList); log.Error("上传zcOrderHistory发生异常", ex); } finally { cmd.Dispose(); tran.Dispose(); OracleUtil.CloseConn(conn); } }
private void deliveryButton_Click(object sender, EventArgs e) { if (!harvestFlag) { MessageBox.Show("当前货物已确认收货,无法重复确认收货!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); return; } bool deli = false; bool prompt = false; if (itemDataGridView.Rows.Count == 0) { MessageBox.Show("当前并无需要提交的收货单!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); return; } for (int i = 0; i < itemDataGridView.Rows.Count; i++) { if (Convert.ToInt32(itemDataGridView[5, i].Value) == 0) { deli = true; } if (Convert.ToInt32(itemDataGridView[6, i].Value) != 0) { prompt = true; } } if (deli || prompt) { string sInput = ""; DGPrompt dGPrompt = new DGPrompt(); if (dGPrompt.ShowDialog() == DialogResult.OK) {// sInput = dGPrompt.inputMess; //MessageBox.Show(sInput); } if (!sInput.Equals("y")) { return; } } List <DailyReceiveGoods> list = new List <DailyReceiveGoods>(); //确定收货 for (int i = 0; i < itemDataGridView.RowCount; i++) { DailyReceiveGoods obj = new DailyReceiveGoods(); DataGridViewRow dc = itemDataGridView.Rows[i]; obj.Id = Guid.NewGuid().ToString().Replace("-", ""); obj.CreateTime = DateTime.Now; obj.UpdateTime = DateTime.Now; obj.SerialNumber = dc.Cells[0].Value.ToString(); obj.Name = dc.Cells[1].Value.ToString(); obj.Classify = dc.Cells[11].Value.ToString(); obj.GoodsUnit = dc.Cells[10].Value.ToString(); obj.GoodsSpecifications = dc.Cells[9].Value.ToString(); obj.GooodsPrice = dc.Cells[2].Value.ToString(); obj.Nums = dc.Cells[3].Value.ToString(); obj.ActualQuantity = dc.Cells[5].Value == null ? "" : dc.Cells[5].Value.ToString(); obj.OrderAmount = dc.Cells[7].Value.ToString(); obj.ReceiveAmount = dc.Cells[8].Value == null ? "" : dc.Cells[8].Value.ToString(); obj.sortenum = dc.Cells[4].Value.ToString(); obj.Salesman = LoginUserInfo.id; obj.BranchId = LoginUserInfo.branchId; obj.receiveDate = DateTime.Now; list.Add(obj); } BranchDailyReceiveGoodsService branchservice = new BranchDailyReceiveGoodsService(); //存入本地数据库 branchservice.AddDailyReceiveGoods(list); //将全部订单改为待提货 BranchZcOrderTransitService branchZcOrderTransitService = new BranchZcOrderTransitService(); branchZcOrderTransitService.UpdateOrderStatus(Constant.ORDER_STATUS_RECEIPT); //将亭点收获标识更新为true DownloadIdentifyService downloadService = new DownloadIdentifyService(); downloadService.UpdateHarvestFlag(Constant.HARVEST_YES); List <ZcOrderTransit> tranlist = branchZcOrderTransitService.FindAll(); ///上传数据处理 if (PingTask.IsConnected) { //上传每日收货数据 DailyReceiveGoodsService service = new DailyReceiveGoodsService(); service.AddDailyReceiveGoods(list); ZcOrderTransitService zcOderTransitService = new ZcOrderTransitService(); zcOderTransitService.UpdateStatus(tranlist); } else { List <UploadInfo> uploadList = new List <UploadInfo>(); foreach (DailyReceiveGoods obj in list) { UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.DAILY_RECEIVE_GOODS; uploadList.Add(uploadInfo); } foreach (ZcOrderTransit obj in tranlist) { UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.ZC_ORDER_TRANSIT_UPDATE; uploadList.Add(uploadInfo); } UploadDao uploadDao = new UploadDao(); uploadDao.AddUploadInfo(uploadList); } MessageBox.Show("收货成功!"); this.branchMain.Show(); this.Close(); }
public void AddZcOrderRefuseItem(List <ZcOrderRefuseItem> list) { 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; foreach (ZcOrderRefuseItem obj in list) { 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(); cmd.Parameters.Clear(); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> uploadList = new List <UploadInfo>(); UploadDao dao = new UploadDao(); foreach (ZcOrderRefuseItem obj in list) { UploadInfo obj2 = new UploadInfo(); obj2.Id = obj.id; obj2.CreateTime = DateTime.Now; obj2.UpdateTime = DateTime.Now; obj2.Type = Constant.ZC_ORDER_REFUSE_ITEM; uploadList.Add(obj2); } dao.AddUploadInfo(uploadList); log.Error("新增拒收明细发生异常", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
public void AddZcOrderHistoryItem(List <ZcOrderHistoryItem> historyItemlist) { string sql = "insert into zc_order_history_item values (:id,:createTime,:updateTime, :actual_money, :actual_nums,:addOn,:amount,:bn,:cost,:gPrice,:goodsState,:itemType," + ":name,:nums,:objId,:orderId,:price,:productId,:score,:sendNum,:TypeId,:weight,:fileId,:providerId)"; OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; foreach (ZcOrderHistoryItem obj in historyItemlist) { cmd.Parameters.Add(new OracleParameter(":id", obj.Id)); cmd.Parameters.Add(new OracleParameter(":createTime", obj.CreateTime)); cmd.Parameters.Add(new OracleParameter(":updateTime", obj.UpdateTime)); cmd.Parameters.Add(":actual_money", obj.actualMoney); cmd.Parameters.Add(":actual_nums", obj.actualNums); cmd.Parameters.Add(new OracleParameter(":addOn", obj.AddOn)); cmd.Parameters.Add(new OracleParameter(":amount", obj.Amount)); cmd.Parameters.Add(new OracleParameter(":bn", obj.Bn)); cmd.Parameters.Add(new OracleParameter(":cost", obj.Cost)); cmd.Parameters.Add(new OracleParameter(":gPrice", obj.GPrice)); cmd.Parameters.Add(new OracleParameter(":goodsState", obj.GoodsState)); cmd.Parameters.Add(new OracleParameter(":itemType", obj.ItemType)); cmd.Parameters.Add(new OracleParameter(":name", obj.Name)); cmd.Parameters.Add(new OracleParameter(":nums", obj.Nums)); cmd.Parameters.Add(new OracleParameter(":objId", obj.ObjId)); cmd.Parameters.Add(new OracleParameter(":orderId", obj.OrderId)); cmd.Parameters.Add(new OracleParameter(":price", obj.Price)); cmd.Parameters.Add(new OracleParameter(":productId", obj.ProductId)); cmd.Parameters.Add(new OracleParameter(":score", obj.Score)); cmd.Parameters.Add(new OracleParameter(":sendNum", obj.SendNum)); cmd.Parameters.Add(new OracleParameter(":TypeId", obj.TypeId)); cmd.Parameters.Add(new OracleParameter(":weight", obj.Weight)); cmd.Parameters.Add(new OracleParameter(":fileId", obj.GoodsFileId)); cmd.Parameters.Add(new OracleParameter(":providerId", obj.ProviderId)); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); List <UploadInfo> list = new List <UploadInfo>(); UploadDao dao = new UploadDao(); foreach (ZcOrderHistoryItem obj in historyItemlist) { UploadInfo obj1 = new UploadInfo(); obj1.Id = obj.Id; obj1.CreateTime = DateTime.Now; obj1.UpdateTime = DateTime.Now; obj1.Type = Constant.ZC_ORDER_HISTORY_ITEM; list.Add(obj1); } dao.AddUploadInfo(list); log.Error("新增zc_order_history_item发生异常", ex); } finally { cmd.Dispose(); tran.Dispose(); OracleUtil.CloseConn(conn); } }
/// <summary> /// 确定支付 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) { ///1,支付信息的存储等 ///2,调用结算界面的方法,存储信息,挪动历史订单信息 customerDelivery.actualTotalMoney = textBox4.Text; if (paidAmount >= float.Parse(textBox4.Text)) { flag = true; if (float.Parse(textBox4.Text) - this.cardpayment > 0) { PayInfo obj = new PayInfo(); obj.Id = Guid.NewGuid().ToString(); obj.CreateTime = DateTime.Now; obj.UpdateTime = DateTime.Now; obj.PayAmount = (float.Parse(textBox4.Text) - this.cardpayment).ToString("0.00"); obj.orderId = orderId; obj.salesmanId = LoginUserInfo.id; obj.payDate = DateTime.Now; obj.PayMode = BranchPay.money; obj.MemberId = memberCardId; obj.BranchId = LoginUserInfo.branchId; AddPayInfo(obj); } } else { flag = false; cashTextbox.Text = (float.Parse(textBox4.Text) - paidAmount).ToString("0.00"); } if (flag) { BranchPayInfoService payService = new BranchPayInfoService(); payService.AddPayInfo(payList); //上传支付信息 if (PingTask.IsConnected) { PayInfoService masterPayInfoService = new PayInfoService(); masterPayInfoService.AddPayInfo(payList); } else { List <UploadInfo> list = new List <UploadInfo>(); foreach (PayInfo obj in payList) { UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.PAY_INFO; list.Add(uploadInfo); } UploadDao uploadDao = new UploadDao(); uploadDao.AddUploadInfo(list); } MessageBox.Show("支付完成!"); if (ModeFlag == 1) { customerDelivery.saveRefuseInform(Constant.ORDER_STATUS_PART_REFUSE); } else { customerDelivery.saveAllPay(Constant.ORDER_STATUS_FININSH); } clFlag = true; ///打印小票的代码 ///start ///付款金额, customerDelivery.printTicket(float.Parse(textBox4.Text)); ///stop this.Close(); } else { MessageBox.Show("支付尚未完成!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); return; } }