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)); } }