private void txt_packingNo_TextChanged(object sender, EventArgs e)
{
if (txt_packingNo.Text.Length == 13)
{
dtgv_BOMCustoms.Columns.Clear();
dtgv_BOMCustoms.Controls.Clear();
Database.ERPSOFT.t_ExportFGoods t_ExportFGoods = new Database.ERPSOFT.t_ExportFGoods();
dtExport = t_ExportFGoods.GetDataTableExportFinishedGoods(txt_packingNo.Text);
if (dtExport.Rows.Count > 0)
{
lb_client.Text = "Client : " + dtExport.Rows[0]["Client"].ToString().Trim();
lb_Invoice.Text = "Invoice: " + dtExport.Rows[0]["Invoice"].ToString().Trim();
txt_buyerSelect.Text = dtExport.Rows[0]["TL202"].ToString().Trim();
txt_ShipmentType.Text = dtExport.Rows[0]["TL203"].ToString().Trim();
lb_dateExportWarehouse.Text = "Warehouse Export Date : " + dtExport.Rows[0]["dateExport"].ToString().Trim();
}
var ListProduct = (from r in dtExport.AsEnumerable()
select r["Product"]).Distinct().ToList();
listSummary = new List <SummaryDelivery>();
for (int i = 0; i < ListProduct.Count; i++)
{
SummaryDelivery summary = new SummaryDelivery();
summary.Product = (string)ListProduct[i];
decimal TotalQty = 0;
TotalQty = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Sum(d => d.Field <decimal>("Quantity"));
summary.TotalQuantity = TotalQty;
summary.PriceUnit = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Select(d => d.Field <decimal>("PriceUnit")).ToList()[0];
summary.price = summary.TotalQuantity * summary.PriceUnit;
summary.Unit = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Select(d => d.Field <string>("Unit")).ToList()[0];
summary.Currency = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Select(d => d.Field <string>("Currency")).ToList()[0];
listSummary.Add(summary);
}
dtgv_deliveryInfo.DataSource = listSummary;
dtgv_BOMCustoms.DataSource = listSummary;
DataGridViewButtonColumn dataGridViewButton = new DataGridViewButtonColumn();
dataGridViewButton.HeaderText = "BOM Customs Declar";
dataGridViewButton.Name = "BOM";
dataGridViewButton.Width = 100;
dtgv_BOMCustoms.Columns.Add(dataGridViewButton);
}
}
private void dtgv_BOMCustoms_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
if (dtgv_BOMCustoms.Columns[e.ColumnIndex].Name == "BOM")
{
string product = dtgv_BOMCustoms.Rows[e.RowIndex].Cells["Product"].Value.ToString().Trim();
SummaryDelivery summary = new SummaryDelivery();
summary.Product = DateTime.Now.ToString("yy") + "-" + product;
summary.TotalQuantity = (decimal)dtgv_BOMCustoms.Rows[e.RowIndex].Cells["TotalQuantity"].Value;
summary.Unit = dtgv_BOMCustoms.Rows[e.RowIndex].Cells["Unit"].Value.ToString().Trim();
summary.PriceUnit = (decimal)dtgv_BOMCustoms.Rows[e.RowIndex].Cells["PriceUnit"].Value;
summary.price = (decimal)dtgv_BOMCustoms.Rows[e.RowIndex].Cells["Price"].Value;
summary.Currency = dtgv_BOMCustoms.Rows[e.RowIndex].Cells["Currency"].Value.ToString().Trim();
BOMDeclarWin bOMDeclarWin = new BOMDeclarWin(summary);
bOMDeclarWin.ShowDialog();
}
}
}
