프로젝트

일반

사용자정보

개정판 3adabe82

ID3adabe826d848c68763cd2bf6b05de7432e72583
상위 32acdfb1
하위 e5a72886

유성호이(가) 일년 이상 전에 추가함

issue #0000
63버전 조회쿼리로 수정

Change-Id: I98739226be84132f92e34efbf59d79fa951b886e

차이점 보기:

ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs
108 108 
            }
109 109 
            if (projectCode == null)
110 110 
            {
111 
                sbTotalWhere.Append(" and doc.RefProjectCode in (select Code from dbo.Projects where ParentID=@RefGroupID) ");
112 
                parameters.Add("RefGroupID", projectGroupID);
113 

  		




  114
  111
  
    
                sbWhere.Append(" and prj.Code is null ");


  		




  
  112
  
    
                sbTotalWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");


  		




  
  113
  
    
                parameters.Add("RefGroupID", projectGroupID);


  		




  115
  114
  
    
            }


  		




  116
  115
  
    
            else if (projectCode.Equals(string.Empty))


  		




  117
  116
  
    
            {


  		




  118
  
  
    
                sbWhere.Append(" and doc.RefProjectCode in (select Code from dbo.Projects where ParentID=@RefGroupID) ");


  		




  119
  
  
    
                sbTotalWhere.Append(" and doc.RefProjectCode in (select Code from dbo.Projects where ParentID=@RefGroupID) ");


  		




  
  117
  
    
                sbWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");


  		




  
  118
  
    
                sbTotalWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");


  		




  120
  119
  
    
                parameters.Add("RefGroupID", projectGroupID);


  		




  121
  120
  
    
            }


  		




  122
  121
  
    
            else


  		




  123
  122
  
    
            {


  		




  124
  
  
    
                sbTotalWhere.Append(" and doc.RefProjectCode in (select Code from dbo.Projects where ParentID=@RefGroupID) ");


  		




  
  123
  
    
                sbTotalWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");


  		




  125
  124
  
    
                parameters.Add("RefGroupID", projectGroupID);


  		




  126
  125
  
    

  		




  127
  126
  
    
                sbWhere.Append(" and doc.RefProjectCode=@RefProjectCode ");


  		












  

    
      ID2.Manager/ID2.Manager/Main.Designer.cs
    
  





  1336
  1336
  
    
            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 20F));


  		




  1337
  1337
  
    
            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 85F));


  		




  1338
  1338
  
    
            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 20F));


  		




  1339
  
  
    
            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 100F));


  		




  
  1339
  
    
            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 70F));


  		




  1340
  1340
  
    
            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListFrReviewStatus, 4, 2);


  		




  1341
  1341
  
    
            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListToIsDiscussion, 2, 2);


  		




  1342
  1342
  
    
            this.tableLayoutPanelCondition.Controls.Add(this.radLabelFrReviewStatus, 3, 2);


  		












내보내기  Unified diff