Workflow в Document Approval System

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;
}