public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseShelfDao dao = new WarehouseShelfDao();
string sql = string.Format("Insert into WMS_WH_SHELF (WH_CODE,AREACODE,SHELFCODE,SHELFNAME,CELLROWS,CELLCOLS,IMG_X,IMG_Y,ISACTIVE,MEMO,AREATYPE) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')"
, this.WH_CODE,
this.AREACODE,
this.SHELFCODE,
this.SHELFNAME,
this.CELLROWS,
this.CELLCOLS,
this.IMG_X,
this.IMG_Y,
this.ISACTIVE,
this.MEMO,
this.AREATYPE);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseShelfDao dao = new WarehouseShelfDao();
string sql = string.Format("update WMS_WH_SHELF set WH_CODE='{1}',AREACODE='{2}',SHELFCODE='{3}',SHELFNAME='{4}',CELLROWS='{5}',CELLCOLS='{6}',IMG_X='{7}',IMG_Y='{8}',ISACTIVE='{9}',MEMO='{10}',AREATYPE='{11}' where SHELF_ID='{0}'"
, this.SHELF_ID,
this.WH_CODE,
this.AREACODE,
this.SHELFCODE,
this.SHELFNAME,
this.CELLROWS,
this.CELLCOLS,
this.IMG_X,
this.IMG_Y,
this.ISACTIVE,
this.MEMO,
this.AREATYPE);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Delete(int ShelfID)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
WarehouseShelfDao dao = new WarehouseShelfDao();
string sql = string.Format("delete from WMS_WH_SHELF WHERE SHELF_ID={0}", ShelfID);
dao.SetData(sql);
flag = true;
}
return(flag);
}