/// <summary>
/// 把下载的数据添加到数据库。
/// </summary>
/// <param name="masterds"></param>
/// <param name="detailds"></param>
public void Insert(DataSet detailds, DataSet middleds)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
try
{
if (middleds.Tables["WMS_MIDDLE_OUT_BILLDETAIL"].Rows.Count > 0)
{
dao.InsertMiddle(middleds);
}
if (detailds.Tables["WMS_OUT_BILLMASTER"].Rows.Count > 0)
{
dao.InsertOutBillMaster(detailds);
}
if (detailds.Tables["WMS_OUT_BILLDETAILA"].Rows.Count > 0)
{
dao.InsertOutBillDetail(detailds);
}
}
catch (Exception exp)
{
throw new Exception(exp.Message);
}
}
}
/// <summary>
/// 手动下载
/// </summary>
/// <param name="billno"></param>
/// <returns></returns>
public bool GetOutBillManual(string billno, string EmployeeCode)
{
bool tag = true;
Employee = EmployeeCode;
using (PersistentManager dbPm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(dbPm);
billno = "ORDER_ID IN(" + billno + ")";
DataTable masterdt = this.GetOutBillMaster(billno);
DataTable detaildt = this.GetOutBillDetail(billno);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet detailds = this.OutBillDetail(detaildt);
DataSet masterds = this.OutBillMaster(masterdt);
this.Insert(masterds, detailds);
}
else
{
tag = false;
}
}
return(tag);
}
/// <summary>
/// 自动下载
/// </summary>
/// <returns></returns>
public bool DownOutBillInfoAuto(string EmployeeCode)
{
bool tag = true;
Employee = EmployeeCode;
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(dbpm);
DataTable outBillNoTable = this.GetOutBillNo();
string billnolist = UtinString.StringMake(outBillNoTable, "BILLNO");
billnolist = UtinString.StringMake(billnolist);
billnolist = "ORDER_ID NOT IN(" + billnolist + ")";
DataTable masterdt = this.GetOutBillMaster(billnolist);
DataTable detaildt = this.GetOutBillDetail(billnolist);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet detailds = this.OutBillDetail(detaildt);
DataSet masterds = this.OutBillMaster(masterdt);
this.Insert(masterds, detailds);
}
else
{
tag = false;
}
}
return(tag);
}
/// <summary>
/// 选择日期从营销系统下载出库单据
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public bool GetOutBill(string startDate, string endDate, string EmployeeCode)
{
bool tag = true;
Employee = EmployeeCode;
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(dbpm);
DataTable outBillNoTable = this.GetOutBillNo();
string outBillList = UtinString.StringMake(outBillNoTable, "BILLNO");
outBillList = UtinString.StringMake(outBillList);
outBillList = string.Format("ORDER_DATE >='{0}' AND ORDER_DATE <='{1}' AND ORDER_ID NOT IN({2})", startDate, endDate, outBillList);
DataTable masterdt = this.GetOutBillMaster(outBillList);
string outDetailList = UtinString.StringMake(masterdt, "ORDER_ID");
outDetailList = UtinString.StringMake(outDetailList);
outDetailList = "ORDER_ID IN(" + outDetailList + ")";
DataTable detaildt = this.GetOutBillDetail(outDetailList);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.OutBillMaster(masterdt);
DataSet detailds = this.OutBillDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
tag = false;
}
}
return(tag);
}
/// <summary>
/// 根据时间查询仓库出库单据号
/// </summary>
/// <returns></returns>
public DataTable GetOutBillNo(string orderDate)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
return(dao.GetOutBillNo(orderDate));
}
}
/// <summary>
/// 查询营销系统出库明细表数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="inBillNo"></param>
/// <returns></returns>
public DataTable GetOutBillDetail(int pageIndex, int pageSize, string inBillNo)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(dbpm);
return(dao.GetOutBillDetailInfo(inBillNo));
}
}
/// <summary>
/// 合单添加数据
/// </summary>
/// <param name="tableName"></param>
/// <param name="table"></param>
public void InsertOutBillMaster(string tableName, DataTable table)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
dao.InsertTable(tableName, table);
}
}
/// <summary>
/// 查询一个空表
/// </summary>
/// <param name="outTable"></param>
/// <returns></returns>
public DataTable QueryNullTable(string outTable)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
return(dao.QueryOutMaterTable(outTable));
}
}
/// <summary>
/// 根据单据号查询总数量和总金额
/// </summary>
/// <param name="datetime"></param>
/// <returns></returns>
public DataTable GetCountQuantity(string billNolist)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
return(dao.GetCountQuantity(billNolist));
}
}
/// <summary>
/// 根据单据号查询合单明细数据
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public DataTable GetDetailByBillNo(string billNoList)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
return(dao.GetOutDetailByBillNo(billNoList));
}
}
/// <summary>
/// 下载出库明细表信息
/// </summary>
/// <returns></returns>
public DataTable GetOutBillDetail(string billno)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(dbpm);
return(dao.GetOutBillDetail(billno));
}
}
/// <summary>
/// 根据单号查询合单后的明细数据
/// </summary>
/// <param name="billno"></param>
/// <returns></returns>
public DataTable QueryOutDetailTable(string billno)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
return(dao.QueryOutDetailTable(billno));
}
}
/// <summary>
/// 查询数字仓储7天之内的单据号
/// </summary>
/// <returns></returns>
public DataTable GetOutBillNo()
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
return(dao.GetOutBillNo());
}
}
/// <summary>
/// 清除一个星期以前合单后没有作业的数据
/// </summary>
public void DeleteOutBillInfo()
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
dao.DeleteOutBillInfo();
}
}
public DataTable GetOrderGather(string orderDate, string batchNo)
{
DataTable ordergather = new DataTable();
using (PersistentManager pm = new PersistentManager("ServerConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
ordergather = dao.GetOrderGather(orderDate, batchNo);
}
return(ordergather);
}
public DataTable GetBatchNo()
{
DataTable batchnodt = new DataTable();
using (PersistentManager pm = new PersistentManager("ServerConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
batchnodt = dao.GetBatchNo();
}
return(batchnodt);
}
public bool GetOrderGather(string billno, string billdate, string batchno, string billtype, string warehouse, decimal quantity)
{
bool tag = true;
string memo = "此主单由分拣系统日期为" + billdate + "，批次号为" + batchno + "合成！";
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
dao.InsertOutBillMaster(billno, billdate, batchno, billtype, warehouse, memo, quantity);
}
return(tag);
}
/// <summary>
/// 查询营销系统出库主表数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataTable GetOutBillMaster(int pageIndex, int pageSize, string startDate, string endDate)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(dbpm);
DataTable outBillNoTable = this.GetOutBillNo();
string billnolist = UtinString.StringMake(outBillNoTable, "BILLNO");
billnolist = UtinString.StringMake(billnolist);
billnolist = "ORDER_ID NOT IN(" + billnolist + ")";
DataTable unitedt = this.UniteBillNo();
string unitelist = UtinString.StringMake(unitedt, "DOWNBILLINO");
unitelist = UtinString.StringMake(unitelist);
return(dao.GetOutBillMaster(billnolist, unitelist));
}
}
public bool GetOrderGather(string billno, string billdate, string batchno)
{
bool tag = true;
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
DataTable detaildt = this.GetOrderGather(billdate, batchno);
DataRow[] dr = detaildt.Select("ORDERDATE='" + billdate + "' and BATCHNO ='" + batchno + "'");
DataSet detailds = this.GetOrderGather(dr, billno);
if (detailds.Tables["WMS_OUT_BILLDETAIL"].Rows.Count > 0)
{
dao.InsertOutBillDetail(detailds);
}
}
return(tag);
}
/// <summary>
/// 选择日期从营销系统下载出库单据 创联
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public bool GetOutBills(string startDate, string endDate, string EmployeeCode, out string errorInfo, string wareCode, string billType)
{
bool tag = true;
Employee = EmployeeCode;
errorInfo = string.Empty;
using (PersistentManager dbpm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
DataTable emply = dao.FindEmployee(EmployeeCode);
DataTable outBillNoTable = this.GetOutBillNo(startDate);
string outBillList = UtinString.MakeString(outBillNoTable, "bill_no");
outBillList = string.Format("ORDER_DATE ='{0}' AND ORDER_ID NOT IN({1}) ", startDate, outBillList);
DataTable masterdt = this.GetOutBillMasters(outBillList);
string outDetailList = UtinString.MakeString(masterdt, "ORDER_ID");
outDetailList = "ORDER_ID IN(" + outDetailList + ")";
DataTable detaildt = this.GetOutBillDetail(outDetailList);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
try
{
string billno = this.GetNewBillNo();
DataSet middleds = this.MiddleTable(masterdt, billno);
//DataSet masterds = this.OutBillMaster(masterdt, emply.Rows[0]["employee_id"].ToString(), wareCode, billType);
DataSet detailds = this.OutBillDetail(detaildt, emply.Rows[0]["employee_id"].ToString(), wareCode, billType, startDate, billno);
this.Insert(detailds, middleds);
}
catch (Exception e)
{
errorInfo += e.Message;
tag = false;
}
}
else
{
errorInfo = "没有可下载的出库数据！";
tag = false;
}
}
return(tag);
}
/// <summary>
/// 把下载的数据添加到数据库。
/// </summary>
/// <param name="masterds"></param>
/// <param name="detailds"></param>
public void Insert(DataSet masterds, DataSet detailds)
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
//pm.BeginTransaction();
try
{
if (masterds.Tables["WMS_OUT_BILLMASTER"].Rows.Count > 0)
{
dao.InsertOutBillMaster(masterds);
}
if (masterds.Tables["DWV_IWMS_OUT_STORE_BILL"].Rows.Count > 0)
{
dao.InsertOutStoreBill(masterds);
}
if (detailds.Tables["WMS_OUT_BILLDETAILA"].Rows.Count > 0)
{
dao.InsertOutBillDetail(detailds);
}
if (detailds.Tables["DWV_IWMS_OUT_STORE_BILL_DETAIL"].Rows.Count > 0)
{
dao.InsertOutStoreBillDetail(detailds);
}
//pm.Commit();
}
catch (Exception exp)
{
//pm.Rollback();
throw new Exception(exp.Message);
}
}
}
/// <summary>
/// 生成出库单号
/// </summary>
/// <returns></returns>
public string GetNewBillNo()
{
using (PersistentManager persistentManager = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
DataSet ds = dao.FindOutBillNo(System.DateTime.Now.ToString("yyMMdd"));
if (ds.Tables[0].Rows.Count == 0)
{
return(System.DateTime.Now.ToString("yyMMdd") + "0001" + "OU");
}
else
{
int i = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString().Substring(6, 4));
i++;
string newcode = i.ToString();
for (int j = 0; j < 4 - i.ToString().Length; j++)
{
newcode = "0" + newcode;
}
return(System.DateTime.Now.ToString("yyMMdd") + newcode + "OU");
}
}
}
/// <summary>
/// 为从分拣系统下载单据生成编号
/// </summary>
/// <returns></returns>
public string GetStoreBillDetailId()
{
using (PersistentManager pm = new PersistentManager())
{
DownOutBillDao dao = new DownOutBillDao();
dao.SetPersistentManager(pm);
DataTable dt = dao.GetOutStoreDetailId();
if (dt.Rows.Count == 0)
{
return(DateTime.Now.ToString("yyyyMMdd") + "0001");
}
else
{
int i = Convert.ToInt32(dt.Rows[0][0].ToString().Substring(8, 4));
i++;
string newcode = i.ToString();
for (int j = 0; j < 4 - i.ToString().Length; j++)
{
newcode = "0" + newcode;
}
return(DateTime.Now.ToString("yyyyMMdd") + newcode);
}
}
}