/// <summary>
/// 从分拣线下载线路信息
/// </summary>
/// <returns></returns>
public DataTable GetSortRouteInfo(string routeCodeList)
{
using (PersistentManager dbPm = new PersistentManager())
{
DownRouteDao dao = new DownRouteDao();
return(dao.GetSortRouteInfo(routeCodeList));
}
}
/// <summary>
/// 把虚拟表的数据添加到数据库
/// </summary>
/// <param name="ds"></param>
public void Insert(DataSet ds)
{
using (PersistentManager dbPm = new PersistentManager())
{
DownRouteDao dao = new DownRouteDao();
dao.Insert(ds);
}
}
/// <summary>
/// 查询仓库线路编号
/// </summary>
/// <returns></returns>
public DataTable GetRouteCode()
{
using (PersistentManager dbPm = new PersistentManager())
{
DownRouteDao dao = new DownRouteDao();
return(dao.GetRouteCode());
}
}
/// <summary>
/// 删除7天之前的线路表，分拣中间表和分拣表(包含细表)，作业调度表
/// </summary>
public void DeleteTable()
{
using (PersistentManager dbPm = new PersistentManager())
{
DownRouteDao dao = new DownRouteDao();
dao.DeleteTable();
}
}
/// <summary>
/// 下载线路信息
/// </summary>
/// <returns></returns>
public DataTable GetRouteInfos(string routeCodeList)
{
using (PersistentManager dbPm = new PersistentManager("YXConnection"))
{
DownRouteDao dao = new DownRouteDao();
dao.SetPersistentManager(dbPm);
return(dao.GetRouteInfos(routeCodeList));
}
}
/// <summary>
/// 删除7天之前的线路表，分拣中间表和分拣表(包含细表)，作业调度表
/// </summary>
public void DeleteTable()
{
try
{
using (PersistentManager dbPm = new PersistentManager())
{
DownRouteDao dao = new DownRouteDao();
dao.DeleteTable();
}
}
catch (Exception e)
{
throw new Exception("删除数据失败！原因：" + e.Message);
}
}
