/// <summary>
/// 根据用户选择的订单下载分拣线订单主表
/// </summary>
/// <returns></returns>
public DataTable GetSortingOrder(string orderid)
{
using (PersistentManager dbpm = new PersistentManager("YXConnection"))
{
DownSortingOrderDao dao = new DownSortingOrderDao();
dao.SetPersistentManager(dbpm);
return(dao.GetSortingOrder(orderid));
}
}
/// <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="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]);
}
}
