public bool Delete(string DeptCode) { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { DepartmentDao dao = new DepartmentDao(); dao.SetData("delete BI_DEPARTMENT WHERE DEPTCODE='" + DeptCode + "'"); flag = true; } return(flag); }
public bool Update() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { DepartmentDao dao = new DepartmentDao(); string sql = string.Format("update BI_DEPARTMENT set DEPTNAME='{1}',DEPTLEADER='{2}',ISACTIVE='{3}',WARECODE='{4}',MEMO='{5}' where DEPTCODE='{0}'" , this.DEPTCODE, this.DEPTNAME, this.DEPTLEADER, this.ISACTIVE, this.WARECODE, this.MEMO); dao.SetData(sql); flag = true; } return(flag); }
public bool Insert() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { DepartmentDao dao = new DepartmentDao(); string sql = string.Format("Insert into BI_DEPARTMENT (DEPTCODE,DEPTNAME,DEPTLEADER,ISACTIVE,WARECODE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}')" , this.DEPTCODE, this.DEPTNAME, this.DEPTLEADER, this.ISACTIVE, this.WARECODE, this.MEMO); dao.SetData(sql); flag = true; } return(flag); }