public void SearchData() { Cursor.Current = Cursors.WaitCursor; DateTime dtFromDate, dtToDate; string strFromDate, strToDate; string strSearchCustomer; decimal decYieldRate; gcTotal.DataSource = null; gcCandidate.DataSource = null; gcDetail.DataSource = null; gvTotal.PopulateColumns(); gvCandidate.PopulateColumns(); gvDetail.PopulateColumns(); try { dtFromDate = Convert.ToDateTime(dtSearchDateFrom.EditValue); dtToDate = Convert.ToDateTime(dtSearchDateTo.EditValue).AddDays(1); strFromDate = Functions.FunctionDateToString(dtFromDate, 0); strToDate = Functions.FunctionDateToString(dtToDate, 0); dtFromDate = Convert.ToDateTime(strFromDate); dtToDate = Convert.ToDateTime(strToDate); strSearchCustomer = lueSearchCustomer.Properties.GetKeyValueByDisplayText(lueSearchCustomer.Text).ToString(); if (string.IsNullOrEmpty(strSearchCustomer)) { strSearchCustomer = "%"; } string strSearchPOtype = lueSearchPOType.Properties.GetKeyValueByDisplayText(lueSearchPOType.Text).ToString(); if (string.IsNullOrEmpty(strSearchPOtype)) { strSearchPOtype = "%"; } try { decYieldRate = Convert.ToDecimal(barEditYieldRate.EditValue.ToString()) / 100; } catch { decYieldRate = 0; } var qryTotal = db.stp_InventorySummary_Total(dtFromDate, dtToDate, strSearchCustomer, strSearchPOtype); //var qry = db.stp_POHeader_Select(dtFromDate, dtToDate, strSearchCustomer, strSearchPOtype, strSearchPONumber, strSearchStatus); if (qryTotal != null) { gcTotal.DataSource = qryTotal.ToList(); if (gvTotal.RowCount > 0) { gvTotal.FocusedRowHandle = -1; //string[] arr = { "CustomerID", "POHeaderID" }; //Functions.SetInvisible(ref gvTotal, arr); // Set Display format gvTotal.Columns["Regular"].DisplayFormat.FormatString = "#,##0"; gvTotal.Columns["Regular"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvTotal.Columns["FCL"].DisplayFormat.FormatString = "#,##0"; gvTotal.Columns["FCL"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvTotal.Columns["RMA"].DisplayFormat.FormatString = "#,##0"; gvTotal.Columns["RMA"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvTotal.Columns["Total"].DisplayFormat.FormatString = "#,##0"; gvTotal.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvTotal.OptionsView.ShowFooter = true; //gvTotal.Columns["Regular"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; //gvTotal.Columns["Regular"].SummaryItem.FieldName = "Regular"; //gvTotal.Columns["Regular"].SummaryItem.DisplayFormat = "SUM={0;#,##}"; gvTotal.Columns["Regular"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Regular", "{0:#,##0}"); gvTotal.Columns["FCL"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "FCL", "{0:#,##0}"); gvTotal.Columns["RMA"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "RMA", "{0:#,##0}"); gvTotal.Columns["Total"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Total", "{0:#,##0}"); gvTotal.BestFitColumns(); gvTotal.OptionsBehavior.ReadOnly = true; gvTotal.FocusedRowHandle = 0; } } else { gcTotal.DataSource = null; //MessageBox.Show("No Results", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); } var qryCandidate = db.stp_InventorySummary_Canidate(dtFromDate, dtToDate, strSearchCustomer, strSearchPOtype, decYieldRate); if (qryCandidate != null) { gcCandidate.DataSource = qryCandidate.ToList(); if (gvCandidate.RowCount > 0) { gvCandidate.FocusedRowHandle = -1; //string[] arr = { "CustomerCode" }; //Functions.SetInvisible(ref gvTotal, arr); gvCandidate.Columns["Regular"].DisplayFormat.FormatString = "#,##0"; gvCandidate.Columns["Regular"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvCandidate.Columns["FCL"].DisplayFormat.FormatString = "#,##0"; gvCandidate.Columns["FCL"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvCandidate.Columns["RMA"].DisplayFormat.FormatString = "#,##0"; gvCandidate.Columns["RMA"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvCandidate.Columns["Total"].DisplayFormat.FormatString = "#,##0"; gvCandidate.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvCandidate.OptionsView.ShowFooter = true; gvCandidate.Columns["Regular"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Regular", "{0:#,##0}"); gvCandidate.Columns["FCL"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "FCL", "{0:#,##0}"); gvCandidate.Columns["RMA"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "RMA", "{0:#,##0}"); gvCandidate.Columns["Total"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Total", "{0:#,##0}"); gvCandidate.BestFitColumns(); gvCandidate.OptionsBehavior.ReadOnly = true; gvCandidate.FocusedRowHandle = 0; } } else { gcCandidate.DataSource = null; //MessageBox.Show("No Results", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); } var qryDetail = db.stp_InventorySummary_Detail(dtFromDate, dtToDate, strSearchCustomer, strSearchPOtype); //var qry = db.stp_POHeader_Select(dtFromDate, dtToDate, strSearchCustomer, strSearchPOtype, strSearchPONumber, strSearchStatus); if (qryDetail != null) { gcDetail.DataSource = qryDetail.ToList(); if (gvDetail.RowCount > 0) { gvDetail.FocusedRowHandle = -1; string[] arr = { "CustomerCode" }; Functions.SetInvisible(ref gvTotal, arr); gvDetail.Columns["Regular"].DisplayFormat.FormatString = "#,##0"; gvDetail.Columns["Regular"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvDetail.Columns["FCL"].DisplayFormat.FormatString = "#,##0"; gvDetail.Columns["FCL"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvDetail.Columns["RMA"].DisplayFormat.FormatString = "#,##0"; gvDetail.Columns["RMA"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvDetail.Columns["Total"].DisplayFormat.FormatString = "#,##0"; gvDetail.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gvDetail.OptionsView.ShowFooter = true; gvDetail.Columns["Regular"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Regular", "{0:#,##0}"); gvDetail.Columns["FCL"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "FCL", "{0:#,##0}"); gvDetail.Columns["RMA"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "RMA", "{0:#,##0}"); gvDetail.Columns["Total"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Total", "{0:#,##0}"); gvDetail.BestFitColumns(); gvDetail.OptionsBehavior.ReadOnly = true; gvDetail.FocusedRowHandle = 0; } } else { gcDetail.DataSource = null; //MessageBox.Show("No Results", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("Couldn't Search Item List!" + Environment.NewLine + ex.Message.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; } }