/// <summary> /// 获得部门的集合 /// </summary> /// <param name="role"></param> /// <returns></returns> public IList<Department> GetDepartMent(Department dept) { IList<Department> datalist = new List<Department>(); string strWhere = string.Empty; if (!string.IsNullOrEmpty(dept.CompanyCode)) strWhere = "a.CCODE = '" + dept.CompanyCode + "' And "; if (!string.IsNullOrEmpty(dept.DeptCode)) strWhere = "a.DeptCode in (" + dept.DeptCode + ") And "; string strSql = "select * from Department a left join Company b on a.ccode = b.ccode where {0} 1 = 1 order by a.OrderNo"; strSql = string.Format(strSql, strWhere); IDataReader dr = OracleHelper.ExecuteReader(strSql); while (dr.Read()) { Department deptEntity = new Department(); deptEntity.DeptCode = dr["DeptCode"].ToString(); deptEntity.DeptName = dr["DeptName"].ToString(); deptEntity.FullName = string.Format("{0}--{1}", dr["cName"].ToString(), dr["DeptName"].ToString()); deptEntity.Description = dr["Description"].ToString(); datalist.Add(deptEntity); } dr.Close(); return datalist; }
public Users() { company = new Company(); role = new Role(); depart = new Department(); }
public bool ManageDeartMent(Department dept) { string strSql = string.Empty; switch (dept.Action) { case ActionEnum.Insert: strSql = "select nvl(Max(OrderNo),0) + 1 OrderNo from department where cCode = '" + dept.CompanyCode + "'"; string orderNo = OracleHelper.ExecuteDataTable(strSql).Rows[0][0].ToString(); strSql = "Insert into DepartMent(DeptCode,CCODE,DeptName,Description,OrderNo) Values ('{1}'||{0},'{1}','{2}','{3}','{4}')"; strSql = string.Format(strSql, "seq_department.Nextval", dept.CompanyCode, dept.DeptName, dept.Description, orderNo); break; case ActionEnum.Update: strSql = "Update DepartMent Set DeptName = '{1}',Description = '{2}' Where DeptCode = {0}"; strSql = string.Format(strSql, dept.DeptCode, dept.DeptName, dept.Description); break; case ActionEnum.Delete: strSql = "delete from DepartMent Where DeptCode = {0}"; strSql = string.Format(strSql, dept.DeptCode); break; } return OracleHelper.ExecuteCommand(strSql); }
/// <summary> /// 查询部门 /// </summary> /// <param name="dept"></param> /// <returns></returns> public IList<Department> QueryDepartMent(Department dept) { IList<Department> datalist = new List<Department>(); string strWhere = string.Empty; if (!string.IsNullOrEmpty(dept.CompanyCode)) strWhere += "a.CCODE like '" + CommonHelper.GetShortCode(dept.CompanyCode) + "%' And "; if (!string.IsNullOrEmpty(dept.QueryDeptLevel)) { if (dept.QueryDeptLevel.IndexOf(",") == -1) { if (dept.QueryDeptLevel.Equals(((int)CompanyTypeEnum.SHI).ToString())) { strWhere += "length(b.ShortCCode) = 4 And "; } if (dept.QueryDeptLevel.Equals(((int)CompanyTypeEnum.XIAN).ToString())) { strWhere += "length(b.ShortCCode) = 6 And "; } } } string strSql = "select * from Department a left join Company b on a.ccode = b.ccode where {0} 1 = 1 order by a.ccode, a.orderno"; strSql = string.Format(strSql, strWhere); IDataReader dr = OracleHelper.ExecuteReader(strSql); while (dr.Read()) { Department deptEntity = new Department(); deptEntity.DeptCode = dr["DeptCode"].ToString(); deptEntity.DeptName = dr["DeptName"].ToString(); deptEntity.FullName = string.Format("{0}--{1}", dr["cName"].ToString(), dr["DeptName"].ToString()); deptEntity.Description = dr["Description"].ToString(); datalist.Add(deptEntity); } dr.Close(); return datalist; }