HYTOS

                                //document.RefProjectCode = prjInfo.Code;

                                document.RefProjectCode = string.IsNullOrEmpty(value) ? value : value.Trim();

                                document.DocumentNo = string.IsNullOrEmpty(value) ? value : value.Trim();

            if (projectCode == null)

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

                parameters.Add("RefGroupID", projectGroupID);

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

            }

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

            {

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

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

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

select @Total=count(*) from dbo.Documents doc where doc.IsDeleted=0 {sbTotalWhere};";

//        public bool ExistsNotRegID2ProjectDocuments()

//        {

//            try

//            {

//                string query = $@"

//select top 1 *

//from   dbo.Documents doc

//where  doc.IsDeleted=0

//   and doc.RefProjectCode not in (select Code from dbo.Projects prj);";

//                bool isRet = ExecuteScalar<int>(query, null) > 0;

//                return isRet;

//            }

//            catch (Exception ex)

//            {

//                throw ex;

//            }

//        }

where  RefProjectCode is not null and ((RegisteredDate between @CreatedDate and @EndDate) or (ModifiedDate between @CreatedDate and @EndDate))";

        //private readonly Color _SummaryColor = Color.FromArgb(255, 108, 55);

            this.radTextBoxDocumentNo.TextChanged += RadTextBoxDocumentNo_TextChanged;

            //this.radTextBoxDocumentNo.KeyUp += RadTextBoxDocumentNo_KeyUp;

                this.radDropDownListProject.Items.Add(new RadListDataItem("== ID2 Project 미등록 ==", null));//ID2 Project 미등록

                string team = this.radDropDownListTeam.SelectedValue.ToString();

                List<string> dateTypes = this.radCheckedDropDownListDateType.CheckedItems.Select(x => x.Value.ToString()).ToList();

                DateTime? frDate = this.radDateTimePickerFr.Value.Equals(this.radDateTimePickerFr.NullDate) ? (DateTime?)null : this.radDateTimePickerFr.Value;

                DateTime? toDate = this.radDateTimePickerTo.Value.Equals(this.radDateTimePickerTo.NullDate) ? (DateTime?)null : this.radDateTimePickerTo.Value;

                string projectCode = this.radDropDownListProject.SelectedValue?.ToString();

                string personIncharge = this.radDropDownListPersonInCharge.SelectedValue.ToString();

                string jobLevel = this.radDropDownListJobLevel.SelectedValue.ToString();

                string documentNo = this.radTextBoxDocumentNo.Text.Trim();

                string isToIsDiscussion = this.radDropDownListToIsDiscussion.SelectedValue.ToString();

                string isFrReviewStatus = this.radDropDownListFrReviewStatus.SelectedValue.ToString();

                string id2Status = this.radDropDownListID2Status.SelectedValue.ToString();

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

                string avevaStatus = this.radDropDownListAVEVAStatus.SelectedValue.ToString();

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

                string prodIsResult = this.radDropDownListProdIsResult.SelectedValue.ToString();

                string clientIsResult = this.radDropDownListClientIsResult.SelectedValue.ToString();

                string isGateWay = this.radDropDownListGateway.SelectedValue.ToString();

                string isRegSystem = this.radDropDownListRegistration.SelectedValue.ToString();

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

                worker.OnWorkCompletedHandler += (e) =>

                {

                    var docData = e.Result as DocumentsResult;

                    this.documents = docData.Dwgs;

                    this.orgDocuments = JsonConvert.DeserializeObject<List<Documents>>(JsonConvert.SerializeObject(docData.Dwgs));

                    this.TotalCount = docData.TotalCount;

                    this.SearchCount = docData.Dwgs.Count;

                    List<string> projectCodes = new List<string>();

                    if (!string.IsNullOrWhiteSpace(projectCode))

                    {

                        projectCodes.Add(projectCode);

                    }

                    else

                    {

                        projectCodes = informations.ProjectList.Select(x => x.Code).ToList();

                    }

                    this.DocumentListBinding(isFilterClear);

                };

                (btnShowAllDetail.HostedItem as RadCheckBoxElement).Checked = false;

                worker.StartWork();

                ColProjects.DataSource = informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).Select(x => x.Code).ToList();

                //ColProjects.DisplayMember = "Name";

                //ColProjects.ValueMember = "Code";

                string ddlSelectedValue = ddl.SelectedValue?.ToString();

                if (ddlSelectedValue == null)

                    ddl.BackColor = Color.DarkSlateBlue;

                    ddl.ForeColor = Color.Yellow;

                    ddl.Font = new Font("Segoe UI", 8.25F, FontStyle.Bold);

                }

                else if (ddlSelectedValue.Equals(string.Empty))

                {

                    ddl.BackColor = Color.White;

                    ddl.ForeColor = Color.Black;

                    ddl.Font = new Font("Segoe UI", 8.25F, FontStyle.Regular);

                }

                else

                {

                    ddl.BackColor = Color.DarkSlateBlue;

                    ddl.ForeColor = Color.Yellow;

                    ddl.Font = new Font("Segoe UI", 8.25F, FontStyle.Bold);

        private void RadTextBoxDocumentNo_TextChanged(object sender, EventArgs e)

        private void RadTextBoxDocumentNo_KeyDown(object sender, KeyEventArgs e)

        {

            if (e.KeyCode == Keys.Enter)

            {

                this.radButtonSearch.Focus();

                this.radButtonSearch.PerformClick();

            }

        }

        //private void RadTextBoxDocumentNo_KeyUp(object sender, KeyEventArgs e)

        //{

        //    if (sender is RadTextBox txtBox)

        //    {

        //        if (txtBox.Text.Length > 0)

        //        {

        //            txtBox.BackColor = Color.DarkSlateBlue;

        //            txtBox.ForeColor = Color.Yellow;

        //            txtBox.Font = new Font("Segoe UI", 8.25F, FontStyle.Bold);

        //        }

        //        else

        //        {

        //            txtBox.BackColor = Color.White;

        //            txtBox.ForeColor = Color.Black;

        //            txtBox.Font = new Font("Segoe UI", 8.25F, FontStyle.Regular);

        //        }

        //    }

        //}

                    #region 필수값 체크(ID2 Project, DWG_ID)

                        RadMessageBox.Show($"Please, check the required value (ID2 Project).", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

                        RadMessageBox.Show(result.Error, Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);