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