/// <summary> /// 查询仓库入库单据细表上报 /// </summary> public string FindInDetailBill() { string tag = "上报仓库入库单据细表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable inDetailTable = this.QueryInDetailBill(); if (inDetailTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertInDetailBill(inDetailTable); this.UpdateInDetail(""); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有新的仓库入库细表信息要上报!"; } } return(tag); }
/// <summary> /// 查询业务库存表表上报 /// </summary> public string FindBusiStock() { string tag = "上报业务库存表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable busiStockTable = this.QueryBusiStock(); if (busiStockTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertBustStock(busiStockTable); this.UpdateBusiStock(""); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有新的业务库存信息要上报!"; } } return(tag); }
/// <summary> /// 查询出库业务单据表上报 /// </summary> public string FindOutBusiBill() { string tag = "上报仓库出库业务单据表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable outBusiTable = this.QueryOutBusiBill(); if (outBusiTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertOutBusiBill(outBusiTable); this.UpdateOutBusi(""); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有新的仓库出库业务单据表要上报!"; } } return(tag); }
/// <summary> /// 查询同步状态表上报 /// </summary> public string FindSynchroInfo() { string tag = "上报同步状态表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable synchroTable = this.QuerySynchroInfo(); if (synchroTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertSynchro(synchroTable); this.UpdateSyachro(""); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有同步状态表数据可上报!"; } } return(tag); }
/// <summary> /// 查询分拣订单主表上报 /// </summary> public string FindIordMasterOrder() { string tag = "上报分拣订单主表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable orderMasterTable = this.QueryIordMasterOrder(); if (orderMasterTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertIordOrder(orderMasterTable); this.UpdateOrderMaster(""); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有新的分拣订单主表要上报!"; } } return(tag); }
/// <summary> /// 查询卷烟信息表上报 /// </summary> public string FindProduct() { string tag = "上报卷烟信息表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable brandTable = this.QueryProductInfo(); if (brandTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertProduct(brandTable); this.UpdateProduct(); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有新的卷烟信息要上报!"; } } return(tag); }
/// <summary> /// Get the start date and end date for the upload. /// </summary> public void GetStartDateAndEndDate() { UploadDao UploadDao = new UploadDao(); this.startDate = UploadDao.GetPMTUploadStartDate(uploadType, assetGroupType); this.endDate = UploadDao.GetPMTUploadEndDate(uploadType, assetGroupType); }
/// <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); } }
/// <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="brandSet"></param> public void InsertProduct(DataSet brandSet) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertProduct(brandSet); } }
//业务库存表 public void QueryBusiStock(DataSet busiStock) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertBustStock(busiStock); } }
//仓储属性表 public void UploadCell(DataSet cell) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertCell(cell); } }
/// <summary> /// 获取配送中心编码 /// </summary> /// <returns></returns> public string GetCompany() { using (PersistentManager dbpm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); return(dao.GetCompany().ToString()); } }
//获取产品的单位比例 public DataTable ProductRate(string productCode) { using (PersistentManager dbPm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbPm); return(dao.ProductRate(productCode)); } }
/// <summary> /// 根据产品编码查询业务库存零烟柜数量 /// </summary> /// <param name="product"></param> /// <returns></returns> public DataTable QueryCellTiao(string product) { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); return(dao.QueryCellTiao(product)); } }
/// <summary> /// 上报客户信息数据 /// </summary> /// <param name="costomerSet"></param> public void InsertCustom(DataSet costomerSet) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertCustom(costomerSet); } }
/// <summary> /// 查询仓库出库单据细表 /// </summary> /// <returns></returns> public DataTable QueryOutDetailBill() { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); return(dao.QueryOutDetailBill()); } }
//入库主表 public void InsertInMasterBill(DataSet busiStock) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertInMasterBill(busiStock); } }
/// <summary> /// 查询分拣订单主表 /// </summary> /// <returns></returns> public DataTable QueryIordMasterOrder() { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); return(dao.QueryIordMasterOrder()); } }
/// <summary> /// 修改同步状态表信息上报状态 /// </summary> /// <param name="productCode"></param> public void UpdateSyachro(string syachroCode) { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.UpdateSyachro(syachroCode); } }
//同步状态表 public void InsertSynchro() { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertSynchro(); } }
/// <summary> /// 组织机构表 /// </summary> /// <param name="companySet"></param> public void UploadOrganization(DataSet companySet) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertCompany(companySet); } }
/// <summary> /// 查询同步状态表 /// </summary> /// <returns></returns> public DataTable QuerySynchroInfo() { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); return(dao.QuerySynchroInfo()); } }
//人员信息表 public void UploadEmployee(DataSet employee) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertEmployee(employee); } }
/// <summary> /// 查询组织结构表 /// </summary> /// <returns></returns> public DataTable QueryOrganization() { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); return(dao.QueryOrganization()); } }
/// <summary> /// 修改业务库存表信息上报状态 /// </summary> /// <param name="productCode"></param> public void UpdateBusiStock(string busiStockCode) { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.UpdateBusiStock(busiStockCode); dao.InsertSynchroInfo("DWV_IWMS_BUSI_STOCK", "业务库存表"); } }
/// <summary> /// 修改仓库入库单据主表信息上报状态 /// </summary> /// <param name="productCode"></param> public void UpdateInMaster(string inMasterCode) { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.UpdateInMaster(inMasterCode); dao.InsertSynchroInfo("DWV_IWMS_IN_STORE_BILL", "仓库入库单据主表"); } }
/// <summary> /// 修改出库业务单据表信息上报状态 /// </summary> /// <param name="productCode"></param> public void UpdateOutBusi(string outBusiCode) { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.UpdateOutBusi(outBusiCode); dao.InsertSynchroInfo("DWV_IWMS_OUT_BUSI_BILL", "出库业务单据表"); } }
/// <summary> /// 修改仓库出库单据细表信息上报状态 /// </summary> /// <param name="productCode"></param> public void UpdateOutDetail(string outDetailCode) { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.UpdateOutDetail(outDetailCode); dao.InsertSynchroInfo("DWV_IWMS_OUT_STORE_BILL_DETAIL", "仓库出库单据细表"); } }
/// <summary> /// 修改卷烟信息表上报状态 /// </summary> /// <param name="productCode"></param> public void UpdateProduct() { using (PersistentManager pm = new PersistentManager()) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.UpdateProduct(); dao.InsertSynchroInfo("DWV_IINF_BRAND", "卷烟信息表"); } }