public DataSet QueryShelfByWHCODE(string whcode)
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseShelfDao dao = new WarehouseShelfDao();
string sql = string.Format("SELECT * FROM WMS_WH_SHELF where WH_CODE='{0}' ORDER BY AREACODE,SHELFCODE", whcode);
return(dao.GetData(sql));
}
}
public DataSet QueryShelfByID(int ShelfID)
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseShelfDao dao = new WarehouseShelfDao();
string sql = string.Format("SELECT * FROM WMS_WH_SHELF WHERE SHELF_ID='{0}' ORDER BY AREACODE,SHELFCODE", ShelfID);
return(dao.GetData(sql));
}
}
//private string strPrimaryKey = "";
//private string strOrderByFields = "ExceptionalLogID ASC";
//private string strQueryFields = "";
public DataSet QueryAllShelf()
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseShelfDao dao = new WarehouseShelfDao();
string sql = string.Format("SELECT * FROM WMS_WH_SHELF ORDER BY AREACODE,SHELFCODE");
return(dao.GetData(sql));
}
}