/// <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;
}
}
