/// <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", "卷烟信息表");
}
}
