文書承認システムのワークフロー

private string GetFilter() { List<Guid> deputyIds = DeputyEmployeeRepository.GetReplaceableEmployeeIdentityIds(DocumentType.BillDemand,EmployeeRepository.CurrentEmployee, true); string idsString = StringUtil.GetString(deputyIds); string opSubfilter = string.Format( "SELECT dbd.{0} FROM {1} dbd INNER JOIN {2} ON dbd.{0} = {3} INNER JOIN {4} ON {5} = {6} LEFT OUTER JOIN {7} ON dbd.{0} = {8} AND {9} = {10} WHERE {11} IS NULL", BillDemandTableBase.SelectColumn_Id, BillDemandTableBase.DEFAULT_NAME, BillDemandDistributionTableBase.DEFAULT_NAME, BillDemandDistributionTableBase.FilterColumn_BillDemandDistribution_BillDemandId, DemandTableBase.DEFAULT_NAME, BillDemandDistributionTableBase.FilterColumn_BillDemandDistribution_DemandId, DemandTableBase.FilterColumn_Demand_Id, WorkflowSightingTableBase.DEFAULT_NAME, WorkflowSightingTableBase.FilterColumn_WorkflowSighting_EntityId, DemandTableBase.FilterColumn_Demand_ExecutorStructId, WorkflowSightingTableBase.FilterColumn_WorkflowSighting_ItemId, WorkflowSightingTableBase.FilterColumn_WorkflowSighting_Id ); string limitSubfilter = string.Format( "SELECT {0} FROM {1} WHERE {2} = {3} AND {4} = {5} AND {6} IS NULL AND {7} IN ({8}) ", WorkflowSightingTableBase.SelectColumn_Id, WorkflowSightingTableBase.DEFAULT_NAME, BillDemandTableBase.FilterColumn_BillDemand_Id, WorkflowSightingTableBase.FilterColumn_WorkflowSighting_EntityId, WorkflowSightingTableBase.SelectColumn_StateId, BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, WorkflowSightingTableBase.SelectColumn_SightingTime, WorkflowSightingTableBase.SelectColumn_SighterId, idsString); string filter = string.Format( "({0} IN ({1},{2}) AND {3} IN ({4})) OR ( EXISTS ({5}) )", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int) BillDemandStateEnum.Draft, (int) BillDemandStateEnum.PostingAccounting, BillDemandTableBase.FilterColumn_BillDemand_AuthorId, idsString, limitSubfilter); if (SecurityHelper.IsPrincipalsInRole(deputyIds, SecurityHelper.ControllerRoleId)) filter += string.Format(" OR {0} = {1}", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int) BillDemandStateEnum.UPKZControllerSighting); if (SecurityHelper.IsPrincipalsInRole(deputyIds, SecurityHelper.CuratorRoleId)) filter += string.Format(" OR {0} = {1}", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int) BillDemandStateEnum.UPKZCuratorSighting); if (SecurityHelper.IsPrincipalsInRole(deputyIds, SecurityHelper.UPKZHeadRoleId)) filter += string.Format(" OR {0} = {1}", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int) BillDemandStateEnum.UPKZHeadSighting); if (SecurityHelper.IsPrincipalsAccountant(deputyIds, BudgetPart)) { if (CommonSettings.CheckAccountingInFilial) { filter += string.Format(" OR ({0} = {1} AND {2} = '{3}')", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int) BillDemandStateEnum.InAccounting, BillDemandTableBase.FilterColumn_BillDemand_FilialId, EmployeeRepository.CurrentEmployeeFilialId); } else { filter += string.Format(" OR ({0} = {1})", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int)BillDemandStateEnum.InAccounting ); } } List<Guid> deputyDivisionHeads = SecurityHelper.GetPrincipalsDivisionHead(deputyIds, BudgetPart); if (deputyDivisionHeads.Count > 0) { string currentEmployeeChildrenStructs = EmployeeRepository.CurrentEmployeeChildrenStructs.Replace("(", "").Replace(")", ""); string deputyDevisionHeadString = StringUtil.GetString(deputyDivisionHeads); filter += string.Format( " OR ({0} = {1} AND EXISTS (SELECT vp.Id FROM [dbo].[vStructDivisionParentsAndThis] vp INNER JOIN {2} e ON vp.ParentId = e.{3} WHERE vp.Id = {4} AND e.{5} IN ({6})))", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int)BillDemandStateEnum.HeadInitiatorSighting, EmployeeRepository.DEFAULT_NAME, EmployeeRepository.SelectColumn_StructDivisionId, BillDemandTableBase.FilterColumn_AuthorStructDivision_Id, EmployeeRepository.SelectColumn_SecurityTrusteeId, deputyDevisionHeadString ); filter += string.Format( " OR ({0} = {1} AND {2} > 0 AND EXISTS ({3} AND {4} IN ({5}) AND dbd.{6} = {7}))", BillDemandTableBase.FilterColumn_BillDemand_BillDemandStateId, (int) BillDemandStateEnum.LimitManagerSighting, BillDemandTableBase.FilterColumn_BillDemand_BudgetPartId, opSubfilter, DemandTableBase.FilterColumn_Demand_ExecutorStructId, currentEmployeeChildrenStructs, BillDemandTableBase.SelectColumn_Id, BillDemandTableBase.FilterColumn_BillDemand_Id); } return filter; }