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