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