public List <Department> GetDepResult(string parentDepId, string keyword, bool isEnabled) { var list = new List <Department>(); var sql = new Sql("SELECT * from org_t_department WHERE IsEnabled =" + isEnabled); if (parentDepId == "") { sql.Append("AND parentDepId IS NULL"); } else if (parentDepId != null) { sql.Append("AND parentDepId = @0", parentDepId); } if (!string.IsNullOrEmpty(keyword)) { sql.AppendLike("AND DepName LIKE @0", keyword); } sql.Append("ORDER BY DepName collate Chinese_PRC_CS_AS_KS_WS ASC"); list = db.Fetch <Department>(sql); foreach (var item in list) { item.NodeList = GetDepNodeList(item.ID); item.ParentDepartment = GetById(item.ParentDepID); } return(list); }
/// <summary> /// 获取应用列表 /// </summary> /// <param name="applicationName"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="total"></param> /// <returns></returns> public List <RightApplication> GetApplicationList(string applicationName, int?pageIndex, int?pageSize, out int total) { var sql = new Sql(@" SELECT Id, ApplicationId, ApplicationName FROM RM_T_RightApplication WHERE 1=1"); if (!string.IsNullOrEmpty(applicationName)) { sql.AppendLike("AND ApplicationName LIKE @0", applicationName); } List <RightApplication> result; if (pageIndex.HasValue && pageSize.HasValue) { result = Util.FetchPage <RightApplication>(db, sql, pageIndex.Value, pageSize.Value, "ORDER BY Id", out total); } else { result = db.Fetch <RightApplication>(sql); total = result.Count; } return(result); }