public int GetRowCount(string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseAreaDao dao = new WarehouseAreaDao();
return(dao.GetRowCount(strTableView, filter));
}
}
public string GetNewAreaCode(string whcode)
{
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseAreaDao dao = new WarehouseAreaDao();
return(dao.GetNewAreaCode(whcode));
}
}
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));
}
}
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));
}
}
//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));
}
}
public bool Delete(DataSet dataSet)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseAreaDao dao = new WarehouseAreaDao();
dao.DeleteEntity(dataSet);
flag = true;
}
return(flag);
}
public bool Delete(int AreaID)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseAreaDao dao = new WarehouseAreaDao();
string sql = string.Format("delete from WMS_WH_AREA WHERE AREA_ID={0}", AreaID);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseAreaDao dao = new WarehouseAreaDao();
string sql = string.Format("Insert into WMS_WH_AREA (WH_CODE,AREACODE,AREANAME,SHORTNAME,ISACTIVE,AREATYPE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.WH_CODE,
this.AREACODE,
this.AREANAME,
this.SHORTNAME,
this.ISACTIVE,
this.AREATYPE,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseAreaDao dao = new WarehouseAreaDao();
string sql = string.Format("update WMS_WH_AREA set WH_CODE='{0}',AREACODE='{1}',AREANAME='{2}',SHORTNAME='{3}',ISACTIVE='{4}',MEMO='{5}',AREATYPE='{6}' where AREA_ID='{7}'"
, this.WH_CODE,
this.AREACODE,
this.AREANAME,
this.SHORTNAME,
this.ISACTIVE,
this.MEMO,
this.AREATYPE,
this.AREA_ID);
dao.SetData(sql);
flag = true;
}
return(flag);
}
