public List <FlowAuthRoleEntity> GetFlowAuthRoleList(FlowAuthRoleQuery query) { List <FlowAuthRoleEntity> list = new List <FlowAuthRoleEntity>(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT RoleAuthID,JournalID,ActionID,RoleID,AddDate FROM dbo.FlowAuthRole WITH(NOLOCK)"); string whereSQL = FlowAuthRoleQueryToSQLWhere(query); string orderBy = FlowAuthRoleQueryToSQLOrder(query); if (!string.IsNullOrEmpty(whereSQL)) { sqlCommandText.Append(" WHERE " + whereSQL); } if (!string.IsNullOrEmpty(orderBy)) { sqlCommandText.Append(" ORDER BY " + orderBy); } DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); using (IDataReader dr = db.ExecuteReader(cmd)) { list = MakeFlowAuthRoleList(dr); } return(list); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="flowAuthRoleQuery">FlowAuthRoleQuery查询实体对象</param> /// <returns>Pager<FlowAuthRoleEntity></returns> public List <FlowAuthRoleEntity> GetFlowAuthRoleList(FlowAuthRoleQuery flowAuthRoleQuery) { return(FlowAuthRoleBusProvider.GetFlowAuthRoleList(flowAuthRoleQuery)); }
/// <summary> /// 将查询实体转换为Order语句 /// <param name="query">查询实体</param> /// <returns>获取Order语句,不包含Order</returns> /// </summary> public string FlowAuthRoleQueryToSQLOrder(FlowAuthRoleQuery query) { return(" RoleAuthID DESC"); }
/// <summary> /// 将查询实体转换为Where语句 /// <param name="query">查询实体</param> /// <returns>获取Where语句,不包含Where</returns> /// </summary> public string FlowAuthRoleQueryToSQLWhere(FlowAuthRoleQuery query) { StringBuilder sbWhere = new StringBuilder(" JournalID = " + query.JournalID + " AND ActionID = " + query.ActionID); return(sbWhere.ToString()); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="flowAuthRoleQuery">FlowAuthRoleQuery查询实体对象</param> /// <returns>Pager<FlowAuthRoleEntity></returns> public List <FlowAuthRoleEntity> GetFlowAuthRoleList(FlowAuthRoleQuery flowAuthRoleQuery) { return(FlowAuthRoleDataAccess.Instance.GetFlowAuthRoleList(flowAuthRoleQuery)); }