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> /// 将查询实体转换为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); }
public ActionResult GetFlowAuthRoleListAjax(FlowAuthRoleQuery query) { IFlowFacadeService service = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>(); query.JournalID = CurAuthor.JournalID; List<FlowAuthRoleEntity> listResult = service.GetFlowAuthRoleList(query); return Json(new { Rows = listResult }); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="flowAuthRoleQuery">FlowAuthRoleQuery查询实体对象</param> /// <returns>Pager<FlowAuthRoleEntity></returns> public List<FlowAuthRoleEntity> GetFlowAuthRoleList(FlowAuthRoleQuery flowAuthRoleQuery) { return FlowAuthRoleBusProvider.GetFlowAuthRoleList(flowAuthRoleQuery); }
/// <summary> /// 获取审稿环节角色权限列表 /// </summary> /// <param name="queryFlowAuthRole"></param> /// <returns></returns> public List<FlowAuthRoleEntity> GetFlowAuthRoleList(FlowAuthRoleQuery queryFlowAuthRole) { HttpClientHelper clientHelper = new HttpClientHelper(); List<FlowAuthRoleEntity> flowAuthRoleList = clientHelper.PostAuth<List<FlowAuthRoleEntity>, FlowAuthRoleQuery>(GetAPIUrl(APIConstant.FLOW_GETFLOWAUTHROLELIST), queryFlowAuthRole); if (flowAuthRoleList != null) { foreach (FlowAuthRoleEntity item in flowAuthRoleList) { item.RoleName = GetRoleName(item.RoleID); } } return flowAuthRoleList; }
public List<FlowAuthRoleEntity> GetFlowAuthRoleList(FlowAuthRoleQuery queryFlowAuthRole) { try { IFlowAuthRoleService flowAuthRoleService = ServiceContainer.Instance.Container.Resolve<IFlowAuthRoleService>(); List<FlowAuthRoleEntity> listFlowAuthRole = flowAuthRoleService.GetFlowAuthRoleList(queryFlowAuthRole); return listFlowAuthRole; } catch (Exception ex) { LogProvider.Instance.Error("获取审稿流程角色权限出现异常:" + ex.Message); throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.ExpectationFailed, ex.Message)); } }