HYTOS

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string id2Issues, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem)

                    return rep.GetDocuments(projectGroupID, dateTypes, frDate, toDate, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, id2Issues, avevaStatus, avevaIssues, prodIsResult, clientIsResult, isGateWay, isRegSystem);

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(List<ID2ProjectInfo> id2Infos, string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Issues, string id2Status, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem)

                var (dwgs, totalCnt) = this.GetDocuments(projectGroupID, dateTypes, frDate, toDate, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, id2Issues, avevaStatus, avevaIssues, prodIsResult, clientIsResult, isGateWay, isRegSystem);

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string id2Issues, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem)

            if (!string.IsNullOrEmpty(id2Issues))

            {

                sbWhere.Append(" and (case when isnull(ltrim(rtrim(doc.ID2Issues)),'') = '' then 'No' else 'Yes' end)=@ID2Issues ");

                parameters.Add("ID2Issues", id2Issues);

            }

            if (!string.IsNullOrEmpty(avevaIssues))

            {

                sbWhere.Append(" and (case when isnull(ltrim(rtrim(doc.AVEVAIssues)),'') = '' then 'No' else 'Yes' end)=@AVEVAIssues ");

                parameters.Add("AVEVAIssues", avevaIssues);

            }

                            markus.MARKUP_DATA_ID as MARKUP_DATA_ID, markus.*

        string Id2Issues { get; set; }

        string AvevaIssues { get; set; }

        public LoadDocumentsWorker(List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string id2Issues, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem, Control parent = null) : base(parent)

            this.Id2Issues = id2Issues;

            this.AvevaIssues = avevaIssues;

                var (dwgs, totalCnt) = new DocumentController().GetDocuments(informations.ActiveProject.ProjectID, this.DateTypes, this.FrDate, this.ToDate, this.ProjectCode, this.PersonIncharge, this.JobLevel, this.DocumentNo, this.IsToIsDiscussion, this.IsFrReviewStatus, this.IsID2Work, this.Id2Status, this.Id2Issues, this.AvevaStatus, this.AvevaIssues, this.ProdIsResult, this.ClientIsResult, this.DTIsGateWay, this.DTIsRegSystem);

            this.radLabelID2Issues = new Telerik.WinControls.UI.RadLabel();

            this.radLabelAVEVAIssues = new Telerik.WinControls.UI.RadLabel();

            this.radDropDownListID2Issues = new Telerik.WinControls.UI.RadDropDownList();

            this.radDropDownListAVEVAIssues = new Telerik.WinControls.UI.RadDropDownList();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelID2Issues)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelAVEVAIssues)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListID2Issues)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListAVEVAIssues)).BeginInit();

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

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelAVEVAStatus, 5, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListAVEVAStatus, 6, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelID2Issues, 3, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelAVEVAIssues, 7, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListID2Issues, 4, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListAVEVAIssues, 8, 3);

            this.radLabelAVEVAStatus.Location = new System.Drawing.Point(486, 90);

            this.radDropDownListAVEVAStatus.Location = new System.Drawing.Point(572, 88);

            this.radPageViewPageAutoCAD.ItemSize = new System.Drawing.SizeF(63F, 28F);

            // radLabelID2Issues

            // 

            this.radLabelID2Issues.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabelID2Issues.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelID2Issues.Location = new System.Drawing.Point(273, 90);

            this.radLabelID2Issues.Name = "radLabelID2Issues";

            this.radLabelID2Issues.Size = new System.Drawing.Size(64, 17);

            this.radLabelID2Issues.TabIndex = 23;

            this.radLabelID2Issues.Text = "ID2 Issue";

            // 

            // radLabelAVEVAIssues

            // 

            this.radLabelAVEVAIssues.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radLabelAVEVAIssues.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelAVEVAIssues.Location = new System.Drawing.Point(699, 90);

            this.radLabelAVEVAIssues.Name = "radLabelAVEVAIssues";

            this.radLabelAVEVAIssues.Size = new System.Drawing.Size(81, 17);

            this.radLabelAVEVAIssues.TabIndex = 24;

            this.radLabelAVEVAIssues.Text = "AVEVA Issue";

            // 

            // radDropDownListID2Issues

            // 

            this.radDropDownListID2Issues.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListID2Issues.DropDownAnimationEnabled = true;

            this.radDropDownListID2Issues.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListID2Issues.Location = new System.Drawing.Point(359, 88);

            this.radDropDownListID2Issues.Name = "radDropDownListID2Issues";

            this.radDropDownListID2Issues.Size = new System.Drawing.Size(120, 20);

            this.radDropDownListID2Issues.TabIndex = 25;

            // 

            // radDropDownListAVEVAIssues

            // 

            this.radDropDownListAVEVAIssues.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListAVEVAIssues.DropDownAnimationEnabled = true;

            this.radDropDownListAVEVAIssues.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListAVEVAIssues.Location = new System.Drawing.Point(785, 88);

            this.radDropDownListAVEVAIssues.Name = "radDropDownListAVEVAIssues";

            this.radDropDownListAVEVAIssues.Size = new System.Drawing.Size(120, 20);

            this.radDropDownListAVEVAIssues.TabIndex = 26;

            // 

            ((System.ComponentModel.ISupportInitialize)(this.radLabelID2Issues)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelAVEVAIssues)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListID2Issues)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListAVEVAIssues)).EndInit();

        private Telerik.WinControls.UI.RadLabel radLabelID2Issues;

        private Telerik.WinControls.UI.RadLabel radLabelAVEVAIssues;

        private Telerik.WinControls.UI.RadDropDownList radDropDownListID2Issues;

        private Telerik.WinControls.UI.RadDropDownList radDropDownListAVEVAIssues;

                #endregion

                #region 작업

                    if (this.radDropDownListID2Status.Items.Count > 0)

                        this.radDropDownListID2Status.Items.Clear();

                    informations.JobStatus.ForEach(x =>

                    {

                        this.radDropDownListID2Status.Items.Add(new RadListDataItem(x, x));

                    });

                    var allID2Status = new RadListDataItem("== 전체 ==", string.Empty);

                    this.radDropDownListID2Status.Items.Insert(0, allID2Status);

                    allID2Status.Selected = true;

                }

                //ID2 Issues

                {

                    if (this.radDropDownListID2Issues.Items.Count > 0)

                        this.radDropDownListID2Issues.Items.Clear();

                    informations.IsYesNo.ForEach(x =>

                    {

                        this.radDropDownListID2Issues.Items.Add(new RadListDataItem(x, x));

                    });

                    var allID2Issues = new RadListDataItem("== 전체 ==", string.Empty);

                    this.radDropDownListID2Issues.Items.Insert(0, allID2Issues);

                    allID2Issues.Selected = true;

                }

                    if (this.radDropDownListAVEVAStatus.Items.Count > 0)

                        this.radDropDownListAVEVAStatus.Items.Clear();

                    informations.JobStatus.ForEach(x =>

                    {

                        this.radDropDownListAVEVAStatus.Items.Add(new RadListDataItem(x, x));

                    });

                    var allAVEVAStatus = new RadListDataItem("== 전체 ==", string.Empty);

                    this.radDropDownListAVEVAStatus.Items.Insert(0, allAVEVAStatus);

                    allAVEVAStatus.Selected = true;

                }

                //AVEVA Issues

                {

                    if (this.radDropDownListAVEVAIssues.Items.Count > 0)

                        this.radDropDownListAVEVAIssues.Items.Clear();

                    informations.IsYesNo.ForEach(x =>

                    {

                        this.radDropDownListAVEVAIssues.Items.Add(new RadListDataItem(x, x));

                    });

                    var allAVEVAIssues = new RadListDataItem("== 전체 ==", string.Empty);

                    this.radDropDownListAVEVAIssues.Items.Insert(0, allAVEVAIssues);

                    allAVEVAIssues.Selected = true;

                }

                #endregion

                #region 검수

                    string id2Issues = this.radDropDownListID2Issues.SelectedValue.ToString();

                    string avevaIssues = this.radDropDownListAVEVAIssues.SelectedValue.ToString();

                    var worker = new LoadDocumentsWorker(dateTypes, frDate, toDate, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, id2Issues, avevaStatus, avevaIssues, prodIsResult, clientIsResult, isGateWay, isRegSystem, this.radGridViewDocuments);