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