/// <summary>
/// 清除当天主表数据和明细表数据
/// </summary>
public string deleteData()
{
string tag = "true";
try
{
DateTime dateTime = DateTime.Now;
string date = Convert.ToString(dateTime.ToString("yyyyMMdd"));
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDao dao = new SortingOrderDao();
SortingOrderDetailBll bll = new SortingOrderDetailBll();
DataTable orderdt = dao.QueryDate(date);
string orderidList = UtinString.StringMake(orderdt, "ORDER_ID");
string orderid = UtinString.StringMake(orderidList);
dao.deleteOrderDate(date);
bll.DeleteOrderId(orderid);
}
}
catch (Exception e)
{
tag = e.Message;
}
return(tag);
}
/// <summary>
/// 一个表名一个条件查询分拣主表数据
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public int GetRowCount(string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDao dao = new SortingOrderDao();
return(dao.GetRowCount(strTableView, filter));
}
}
/// <summary>
/// 修改主表线路分配的分拣线编号
/// </summary>
/// <param name="SortingCode"></param>
/// <param name="routeCode"></param>
public void UpdateOrderMaster(string SortingCode, string routeCode, string orderDate)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDao dao = new SortingOrderDao();
dao.UpdateOrderMaster(SortingCode, routeCode, orderDate);
}
}
/// <summary>
/// 分页查询数据，指定数据集表名
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="filter"></param>
/// <param name="OrderByFields"></param>
/// <returns></returns>
public DataSet QuerySortingOrderMaster(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDao dao = new SortingOrderDao();
return(dao.FindExecuteQuery(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
}
}
/// <summary>
/// 根据线路编号查询主表的主表Id
/// </summary>
/// <param name="RouteCode"></param>
/// <returns></returns>
public DataTable QueryOrderId(string RouteCode, string orderDate)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDao dao = new SortingOrderDao();
return(dao.QueryOrderId(RouteCode, orderDate));
}
}
