/// <summary>
/// 自动下载订单
/// </summary>
/// <returns></returns>
public string DownSortingOrder()
{
string tag = "true";
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
try
{
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
orderlist = "ORDER_ID NOT IN(" + orderlist + ")";
DataTable masterdt = this.GetSortingOrder(orderlist);
DataTable detaildt = this.GetSortingOrderDetail(orderlist);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdt);
DataSet detailds = this.SaveSortingOrderDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
return("没有可用的数据下载！");
}
}
catch (Exception e)
{
tag = e.Message;
}
}
return(tag);
}
/// <summary>
/// 手动下载
/// </summary>
/// <param name="billno"></param>
/// <returns></returns>
public string GetSortingOrderById(string orderid)
{
string tag = "true";
using (PersistentManager dbPm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbPm);
try
{
orderid = "ORDER_ID IN (" + orderid + ")";
DataTable masterdt = this.GetSortingOrder(orderid);
DataTable detaildt = this.GetSortingOrderDetail(orderid);
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdt);
DataSet detailds = this.SaveSortingOrderDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
return("没有数据可下载！");
}
}
catch (Exception e)
{
tag = e.Message;
}
}
return(tag);
}
/// <summary>
/// 根据用户选择的订单下载分拣线订单明细表 创联
/// </summary>
/// <returns></returns>
public DataTable GetSortingOrderDetails(string orderid)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
return(dao.GetSortingOrderDetails(orderid));
}
}
/// <summary>
/// 查询4天之内的分拣订单
/// </summary>
/// <returns></returns>
public DataTable GetOrderId()
{
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
return(dao.GetOrderId());
}
}
/// <summary>
/// 查询营销系统分拣明细表数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="inBillNo"></param>
/// <returns></returns>
public DataTable GetSortingOrderDetail(int pageIndex, int pageSize, string inBillNo)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
inBillNo = "ORDER_ID = '" + inBillNo + "'";
return(dao.GetSortingOrderDetail(inBillNo));
}
}
/// <summary>
/// 查询营销系统分拣订单主表数据进行下载
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataTable GetSortingOrder(int pageIndex, int pageSize)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
orderlist = "ORDER_ID NOT IN(" + orderlist + ")";
return(dao.GetSortingOrder(orderlist));
}
}
/// <summary>
/// 把下载的数据添加到数据库。
/// </summary>
/// <param name="masterds"></param>
/// <param name="detailds"></param>
public void Insert(DataSet masterds, DataSet detailds)
{
using (PersistentManager pm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(pm);
if (masterds.Tables["DWV_OUT_ORDER"].Rows.Count > 0)
{
dao.InsertSortingOrder(masterds);
}
if (detailds.Tables["DWV_OUT_ORDER_DETAIL"].Rows.Count > 0)
{
dao.InsertSortingOrderDetail(detailds);
}
}
}
/// <summary>
/// 根据时间查询营销系统分拣订单主表数据进行下载
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataTable GetSortingOrder(int pageIndex, int pageSize, string startDate, string endDate)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
//orderlist = "ORDER_DATE>='" + startDate + "' AND ORDER_DATE<='" + endDate + "' AND ORDER_ID NOT IN(" + orderlist + ")";
orderlist = "ORDER_ID NOT IN(" + orderlist + ")";
DataTable masert = dao.GetSortingOrder("ORDER_ID NOT IN('')");
DataRow[] orderdr = masert.Select(orderlist);
return(this.SaveSortingOrder(orderdr).Tables[0]);
}
}
/// <summary>
/// 选择日期从营销系统下载分拣信息
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public string GetSortingOrderDate(string startDate, string endDate)
{
string tag = "true";
using (PersistentManager dbpm = new PersistentManager())
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
try
{
//查询仓库7天内的订单号
DataTable orderdt = this.GetOrderId();
string orderlist = UtinString.StringMake(orderdt, "ORDER_ID");
orderlist = UtinString.StringMake(orderlist);
string orderlistDate = "ORDER_DATE>='" + startDate + "' AND ORDER_DATE<='" + endDate + "' AND ORDER_ID NOT IN(" + orderlist + ")";
DataTable masterdt = this.GetSortingOrder(orderlistDate); //根据时间查询订单信息
string ordermasterlist = UtinString.StringMake(masterdt, "ORDER_ID"); //取得根据时间查询的订单号
string ordermasterid = UtinString.StringMake(ordermasterlist);
ordermasterid = "ORDER_ID IN (" + ordermasterid + ")";
DataTable detaildt = this.GetSortingOrderDetail(ordermasterid);//根据订单号查询明细
if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0)
{
DataSet masterds = this.SaveSortingOrder(masterdt);
DataSet detailds = this.SaveSortingOrderDetail(detaildt);
this.Insert(masterds, detailds);
}
else
{
return("没有可用的数据下载！");
}
}
catch (Exception e)
{
tag = e.Message;
}
}
return(tag);
}