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));
}
}
//获取新的库区类型
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));
}
}
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));
}
}
//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));
}
}