/// <summary>
/// 根据卷烟编码查询计量单位信息
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public DataTable FindUnitListCode(string product)
{
using (PersistentManager pm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
return dao.FindUnitListCode(product);
}
}
public DataTable GetInBillMasterDateTime(string dateTime)
{
using (PersistentManager dbpm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
return dao.GetInBillMasterDateTime(dateTime);
}
}
/// <summary>
/// 删除中间表数据
/// </summary>
/// <param name="billno">单号</param>
public void DeleteMiddleBill(string billno)
{
using (PersistentManager pm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
dao.DeleteMiddleBill(billno);
}
}
/// <summary>
/// 根据日期下载入库数据 zxl 2012-09-14
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public bool GetInBillMiddle(string startDate, string endDate, string EmployeeCode, string wareCode, string billtype, out string errorInfo)
{
bool tag = false;
Employee = EmployeeCode;
errorInfo = string.Empty;
using (PersistentManager pm = new PersistentManager())
{
try
{
DownDecidePlanDao dao = new DownDecidePlanDao();
DataTable emply = dao.FindEmployee(EmployeeCode);
DataTable inMasterBillNo = this.GetMiddleBillNo();
string billnolist = UtinString.MakeString(inMasterBillNo, "bill_no");
billnolist = string.Format("BB_INPUT_DATE >='{0}' AND BB_UUID NOT IN({1})", startDate, billnolist);
DataTable masterdt = this.GetMiddleInBillMaster(billnolist);
string inDetailList = UtinString.MakeString(masterdt, "BILL_NO");
inDetailList = "BD_BB_UUID IN(" + inDetailList + ")";
DataTable detaildt = this.GetMiddleInBillDetail(inDetailList);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
try
{
DataSet middleds = this.MiddleTable(masterdt);
DataSet masterds = this.MiddleInBillMaster(masterdt, emply.Rows[0]["employee_id"].ToString(), wareCode, billtype);
DataSet detailds = this.MiddleInBillDetail(detaildt);
this.Insert(masterds, detailds, middleds);
tag = true;
}
catch (Exception e)
{
errorInfo = "保存错误：" + e.Message;
}
}
else
errorInfo = "没有新的入库单下载！";
}
catch (Exception ex)
{
errorInfo ="下载入库数据失败！原因："+ ex.Message;
}
}
return tag;
}
/// <summary>
/// 把查询的数据添加到仓储数据库
/// </summary>
/// <param name="middleds"></param>
/// <param name="detailds"></param>
public void InsertMiddle(DataSet middleds)
{
using (PersistentManager pm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
}
}
/// <summary>
/// 把查询的数据添加到仓储数据库
/// </summary>
/// <param name="masterds"></param>
/// <param name="detailds"></param>
public void Insert(DataSet masterds, DataSet detailds, DataSet middleds)
{
try
{
using (PersistentManager pm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
if (masterds.Tables["WMS_IN_BILLMASTER"].Rows.Count > 0)
{
dao.InsertInBillMaster(masterds);
}
if (detailds.Tables["WMS_IN_BILLDETAIL"].Rows.Count > 0)
{
dao.InsertInBillDetail(detailds);
}
if (middleds.Tables["WMS_MIDDLE_IN_BILLDETAIL"].Rows.Count > 0)
{
dao.InsertMiddle(middleds);
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// 下载入库单主表数据zxl 2012-09-14
/// </summary>
/// <returns></returns>
public DataTable GetMiddleInBillMaster(string inBillNoList)
{
using (PersistentManager dbpm = new PersistentManager("ZYJCConnection"))
{
DownDecidePlanDao dao = new DownDecidePlanDao();
dao.SetPersistentManager(dbpm);
return dao.GetMiddleInBillMaster(inBillNoList);
}
}
/// <summary>
/// 查询数字仓储中间表4天内入库单 zxl 2012-09-14
/// </summary>
/// <returns></returns>
public DataTable GetMiddleBillNo()
{
using (PersistentManager pm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
return dao.GetMiddleBillNo();
}
}
/// <summary>
/// 下载入库单明细表数据zxl 2012-09-14
/// </summary>
/// <returns></returns>
public DataTable GetMiddleInBillDetail(string inBillNoList)
{
using (PersistentManager dbpm = new PersistentManager())
{
DownDecidePlanDao dao = new DownDecidePlanDao();
return dao.GetMiddleInBillDetail(inBillNoList);
}
}