public void SearchData()
{
Cursor.Current = Cursors.WaitCursor;
AddDropDown();
try
{
var qry = (from hdr in db.POHeaders
from cst in db.Customers
where cst.CustomerID == hdr.CustomerID &&
hdr.POHeaderID == intPOHeaderID
select new
{
CustomerID = cst.CustomerID
,
CustomerCode = cst.CustomerCode
,
POType = hdr.POType
,
PONumber = hdr.PONumber
,
POHeaderID = hdr.POHeaderID
,
OrderDate = hdr.OrderDate
,
Status = hdr.Status
,
Remark = hdr.Remark
}).FirstOrDefault();
if (qry != null)
{
lueCustomer.EditValue = qry.CustomerCode;
lueSearchPOType.EditValue = qry.POType;
txtPONumber.Text = qry.PONumber;
txtPOHeaderID.Text = qry.POHeaderID.ToString();
deOrderDate.EditValue = qry.OrderDate;
lueStatus.EditValue = qry.Status;
txtRemark.Text = qry.Remark;
var qryDetail = db.stp_PODetail_Select(qry.CustomerCode, "%", qry.PONumber, "%", "%");
try
{
dtPODetails = Functions.LINQToDataTable(qryDetail);
gcPODetail.DataSource = dtPODetails;
if (gvPODetail.RowCount > 0)
{
// // Set Display format
//gvPODetail.Columns["ReceiveQty"].DisplayFormat.FormatString = "#,##0";
//gvPODetail.Columns["ReceiveQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//gvPODetail.Columns["ShipGoodQty"].DisplayFormat.FormatString = "#,##0";
//gvPODetail.Columns["ShipGoodQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//gvPODetail.Columns["ShipFunctionFailQty"].DisplayFormat.FormatString = "#,##0";
//gvPODetail.Columns["ShipFunctionFailQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//gvPODetail.Columns["ShipDIPQty"].DisplayFormat.FormatString = "#,##0";
//gvPODetail.Columns["ShipDIPQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//gvPODetail.Columns["ShipTotalQty"].DisplayFormat.FormatString = "#,##0";
//gvPODetail.Columns["ShipTotalQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//gvPODetail.Columns["InventoryQty"].DisplayFormat.FormatString = "#,##0";
//gvPODetail.Columns["InventoryQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
////gvPODetail.BestFitColumns();
////gvPODetail.OptionsBehavior.ReadOnly = true;
//gvPODetail.FocusedRowHandle = 0;
//gvPODetail.Columns["POLineNumber"].Caption = "Line#";
//gvPODetail.Columns["ShipFunctionFailQty"].Caption = "Function Fail";
//gvPODetail.Columns["ShipDIPQty"].Caption = "DIP";
//gvPODetail.Columns["ShipTotalQty"].Caption = "Total";
//gvPODetail.Columns["InventoryQty"].Caption = "Inventory";
string[] arr = { "CustomerCode", "CustomerName", "PONumber", "OrderDate", "DueDate", "ItemCode", "POHeaderID", "PODetailID", "CustomerID", "ItemID" };
Functions.SetInvisible(ref gvPODetail, arr);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Could not find P/O Data!" + Environment.NewLine + ex.Message.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void SearchData(string strCustomer, string strPONumber)
{
Cursor.Current = Cursors.WaitCursor;
try
{
var qry = db.stp_PODetail_Select(strCustomer, "%", strPONumber, "%", "%");
if (qry != null)
{
gcDetail.DataSource = qry.ToList();
if (gvDetail.RowCount > 0)
{
gvDetail.BestFitColumns();
gvDetail.OptionsBehavior.ReadOnly = true;
gvDetail.FocusedRowHandle = 0;
// Set Display format
//CustomerCode CustomerName PONumber OrderDate POLineNumber ItemCode ItemNumber ReceiveQty DueDate ShipRefurbishedQty ShipFrontOnly ShipFunctionFailQty
//ShipDIPQty ShipSampleQty ShipNTFQty ShipOutOfWarranty ShipCustomerAbuse ShipTotalQty InventoryQty Status POHeaderID PODetailID CustomerID ItemID
// Set Display format
gvDetail.Columns["ReceiveQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ReceiveQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipRefurbishedQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipRefurbishedQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipRefurbishedFPCBQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipRefurbishedFPCBQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipFrontOnly"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipFrontOnly"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipFunctionFailQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipFunctionFailQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipDIPQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipDIPQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipSampleQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipSampleQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipNTFQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipNTFQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipOutOfWarranty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipOutOfWarranty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipCustomerAbuse"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipCustomerAbuse"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["ShipTotalQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["ShipTotalQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["InventoryQty"].DisplayFormat.FormatString = "#,##0";
gvDetail.Columns["InventoryQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gvDetail.Columns["POLineNumber"].Caption = "Line#";
gvDetail.Columns["ReceiveQty"].Caption = "Receive";
gvDetail.Columns["ShipRefurbishedQty"].Caption = "Refurbished";
gvDetail.Columns["ShipRefurbishedFPCBQty"].Caption = "Refurbished-FPCB";
gvDetail.Columns["ShipFrontOnly"].Caption = "Front Only";
gvDetail.Columns["ShipFunctionFailQty"].Caption = "Function Fail";
gvDetail.Columns["ShipDIPQty"].Caption = "DIP";
gvDetail.Columns["ShipSampleQty"].Caption = "Sample";
gvDetail.Columns["ShipNTFQty"].Caption = "NTF";
gvDetail.Columns["ShipOutOfWarranty"].Caption = "OOW";
gvDetail.Columns["ShipCustomerAbuse"].Caption = "Customer Abuse";
gvDetail.Columns["ShipTotalQty"].Caption = "Total";
gvDetail.Columns["InventoryQty"].Caption = "Inventory";
gvDetail.Columns["PONumber"].BestFit();
gvDetail.Columns["ItemNumber"].BestFit();
gvDetail.Columns["POLineNumber"].BestFit();
string[] arr = { "CustomerCode", "ItemCode", "DueDate", "POHeaderID", "PODetailID", "CustomerID", "ItemID" };
Functions.SetInvisible(ref gvDetail, arr);
}
}
else
{
gcDetail.DataSource = null;
MessageBox.Show("No Results", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("Couldn't Search Purchase Order Detail!" + Environment.NewLine + ex.Message.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
