示例#1
0
 public DataSet QueryAreaByID(int AreaID)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         WarehouseAreaDao dao = new WarehouseAreaDao();
         string           sql = string.Format("SELECT * FROM WMS_WH_AREA where AREA_ID='{0}'", AreaID);
         return(dao.GetData(sql));
     }
 }
示例#2
0
 //获取新的库区类型
 public DataSet QueryNewAreaType(string wh_code)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         WarehouseAreaDao dao = new WarehouseAreaDao();
         string           sql = string.Format("SELECT MAX(AREATYPE+1) FROM WMS_WH_AREA where WH_CODE={0}", wh_code);
         return(dao.GetData(sql));
     }
 }
示例#3
0
 public DataSet QueryAreaByWHCODE(string WhCode)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         WarehouseAreaDao dao = new WarehouseAreaDao();
         string           sql = string.Format("SELECT * FROM WMS_WH_AREA where WH_CODE='{0}' ORDER BY AREACODE", WhCode);
         return(dao.GetData(sql));
     }
 }
示例#4
0
 //private string strPrimaryKey = "AREA_ID";
 //private string strOrderByFields = "ExceptionalLogID ASC";
 //private string strQueryFields = "*";
 public DataSet QueryAllArea()
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         WarehouseAreaDao dao = new WarehouseAreaDao();
         string           sql = string.Format("SELECT * FROM WMS_WH_AREA ORDER BY WH_CODE,AREACODE");
         return(dao.GetData(sql));
     }
 }