//获取移位单产生的货位变化
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]);
}
}
