public DataSet QueryWarehouseCell(string filter, int pageIndex, int pageSize)
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseCellDao dao = new WarehouseCellDao();
string sql = string.Format("select * from V_WMS_WH_CELL WHERE {0} ORDER BY AREACODE,SHELFCODE,CELLCODE", filter);
return(dao.Query(sql, pageIndex, pageSize));
}
}
/// <summary>
/// 查询产品分布
/// </summary>
public DataSet QueryProductDistribution(int pageIndex, int pageSize, string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseCellDao dao = new WarehouseCellDao();
string sql = string.Format("SELECT * FROM {0} WHERE {1} ORDER BY CURRENTPRODUCT,CELLCODE", strTableView, filter);
return(dao.Query(sql, pageIndex, pageSize));
}
}
//获取移位单产生的货位变化
public DataSet MoveChangeCell(DateTime timeNow)
{
using (PersistentManager pm = new PersistentManager())
{
WarehouseCellDao dao = new WarehouseCellDao();
dao.SetPersistentManager(pm);
string sql = string.Format("SELECT OUT_CELLCODE,IN_CELLCODE FROM WMS_MOVE_BILLDETAIL WHERE FINISHTIME<='{0}' AND FINISHTIME>=(select max(billdate) from WMS_OUT_BILLMASTER) AND STATUS='2'", timeNow);
return(dao.Query(sql));
}
}
//报表
public DataTable QueryProductDistribution(string filter)
{
using (PersistentManager pm = new PersistentManager())
{
WarehouseCellDao dao = new WarehouseCellDao();
dao.SetPersistentManager(pm);
string sql = string.Format("SELECT * FROM {0} WHERE {1} ORDER BY CURRENTPRODUCT,CELLCODE", strTableView, filter);
return(dao.Query(sql).Tables[0]);
}
}
