private void dtgv_content_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_content);
if (dtgv_content.Rows.Count > 0)
{
dtgv_content.ColumnHeadersHeight = 100;
dtgv_content.Columns["WeekRequestDate"].HeaderText = "Client's Request Week";
dtgv_content.Columns["MonthRequest"].HeaderText = "Client's Request Month";
dtgv_content.Columns["ClientOrderDate"].HeaderText = "Client's Request Date";
dtgv_content.Columns["OrderCode"].HeaderText = "Order Code";
dtgv_content.Columns["ClientOrder"].HeaderText = "Client Order";
dtgv_content.Columns["Deliveried"].HeaderText = "Deliveried Qty";
dtgv_content.Columns["Deliveried"].DefaultCellStyle.Format = "N0";
dtgv_content.Columns["OrderQty"].HeaderText = "Order Qty";
dtgv_content.Columns["OrderQty"].DefaultCellStyle.Format = "N0";
dtgv_content.Columns["ShortageQty"].HeaderText = "Shortage Qty";
dtgv_content.Columns["ShortageQty"].DefaultCellStyle.Format = "N0";
dtgv_content.Columns["RemainDay"].HeaderText = "Day Countdown";
dtgv_content.Columns["RemainDay"].DefaultCellStyle.Format = "N0";
dtgv_content.Columns["TargetQtyDay"].HeaderText = "Target/Day";
dtgv_content.Columns["TargetQtyDay"].DefaultCellStyle.Format = "N0";
}
}
private void dtgv_deliveryInfo_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_deliveryInfo);
dtgv_deliveryInfo.AllowUserToAddRows = false;
dtgv_deliveryInfo.ReadOnly = true;
//if(dtgv_deliveryInfo.Rows.Count > 0)
//{
// dtgv_deliveryInfo.Columns["KeyID"].Visible = false;
// dtgv_deliveryInfo.Columns["KeyNo"].Visible = false;
// dtgv_deliveryInfo.Columns["Client"].Visible = false;
// dtgv_deliveryInfo.Columns["DeptCode"].Visible = false;
// dtgv_deliveryInfo.Columns["Warehouse"].Visible = false;
// dtgv_deliveryInfo.Columns["Location"].Visible = false;
// dtgv_deliveryInfo.Columns["DocNo"].Visible = false;
// dtgv_deliveryInfo.Columns["dateCreate"].Visible = false;
// dtgv_deliveryInfo.Columns["TL201"].Visible = false;
// dtgv_deliveryInfo.Columns["TL202"].Visible = false;
// dtgv_deliveryInfo.Columns["TL203"].Visible = false;
// dtgv_deliveryInfo.Columns["TL204"].Visible = false;
// dtgv_deliveryInfo.Columns["dateUpdate"].Visible = false;
// dtgv_deliveryInfo.Columns["ExportFlag"].Visible = false;
// dtgv_deliveryInfo.Columns["TL211"].Visible = false;
// dtgv_deliveryInfo.Columns["TL212"].Visible = false;
// dtgv_deliveryInfo.Columns["TL213"].Visible = false;
// dtgv_deliveryInfo.Columns["TL214"].Visible = false;
// dtgv_deliveryInfo.Columns["dateExport"].Visible = false;
// dtgv_deliveryInfo.Columns["Invoice"].Visible = false;
//}
}
private void dtgv_stockWH_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
dtgv_stockWH.ReadOnly = true;
dtgv_stockWH.AllowUserToAddRows = false;
DatagridviewSetting.settingDatagridview(dtgv_stockWH);
if (dtgv_stockWH.Rows.Count > 0)
{
dtgv_stockWH.Columns["MM001"].HeaderText = "Product";
dtgv_stockWH.Columns["MM002"].HeaderText = "Warehouse";
dtgv_stockWH.Columns["MM003"].HeaderText = "Location";
dtgv_stockWH.Columns["MM004"].HeaderText = "Lot No";
dtgv_stockWH.Columns["MM005"].HeaderText = "Quantity (pcs)";
dtgv_stockWH.Columns["MM005"].DefaultCellStyle.Format = "N0";
dtgv_stockWH.Columns["MM006"].HeaderText = "Weight (kg)";
dtgv_stockWH.Columns["MM006"].DefaultCellStyle.Format = "N3";
dtgv_stockWH.Columns["MM008"].HeaderText = "Import date";
dtgv_stockWH.Columns["MM009"].HeaderText = "Export date";
dtgv_stockWH.Columns["MM016"].HeaderText = "QR Import";
dtgv_stockWH.Columns["MM001"].ReadOnly = true;
dtgv_stockWH.Columns["MM002"].ReadOnly = true;
dtgv_stockWH.Columns["MM003"].ReadOnly = true;
dtgv_stockWH.Columns["MM004"].ReadOnly = true;
dtgv_stockWH.Columns["MM005"].ReadOnly = true;
dtgv_stockWH.Columns["MM006"].ReadOnly = true;
dtgv_stockWH.Columns["MM008"].ReadOnly = true;
dtgv_stockWH.Columns["MM009"].ReadOnly = true;
dtgv_stockWH.Columns["MM016"].ReadOnly = true;
dtgv_stockWH.Columns["MM007"].Visible = false;
dtgv_stockWH.Columns["MM010"].Visible = false;
}
}
private void dtgv_SemiFiGoods_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_SemiFiGoods);
if (dtgv_SemiFiGoods.Rows.Count > 0)
{
dtgv_SemiFiGoods.Columns["Product"].HeaderText = "Product";
dtgv_SemiFiGoods.Columns["Product"].Visible = false;
dtgv_SemiFiGoods.Columns["SemiFinishedGoods"].HeaderText = "Semi-Finished Goods";
dtgv_SemiFiGoods.Columns["QtyWarehouse"].HeaderText = "Warehouse (pcs)";
dtgv_SemiFiGoods.Columns["QtyWarehouse"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["SemiFGsRequire"].HeaderText = "Amount needed to produce (pcs)";
dtgv_SemiFiGoods.Columns["SemiFGsRequire"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyInMQC"].HeaderText = "IN MQC";
dtgv_SemiFiGoods.Columns["QtyInMQC"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyInMQC"].Visible = false;
dtgv_SemiFiGoods.Columns["QtyOutMQC"].HeaderText = "OUT MQC";
dtgv_SemiFiGoods.Columns["QtyOutMQC"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyOutMQC"].Visible = false;
dtgv_SemiFiGoods.Columns["QTyAtMQC"].HeaderText = "MQC Station (pcs)";
dtgv_SemiFiGoods.Columns["QTyAtMQC"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyInPQC"].HeaderText = "IN PQC";
dtgv_SemiFiGoods.Columns["QtyInPQC"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyInPQC"].Visible = false;
dtgv_SemiFiGoods.Columns["QtyOutPQC"].HeaderText = "OUT PQC";
dtgv_SemiFiGoods.Columns["QtyOutPQC"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyOutPQC"].Visible = false;
dtgv_SemiFiGoods.Columns["QTyAtPQC"].HeaderText = "PQC Station (pcs)";
dtgv_SemiFiGoods.Columns["QTyAtPQC"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyPendingWarehouse"].HeaderText = "Into Warehouse Pending (pcs)";
dtgv_SemiFiGoods.Columns["QtyPendingWarehouse"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["QtyWip"].HeaderText = "WIP (pcs)";
dtgv_SemiFiGoods.Columns["QtyWip"].DefaultCellStyle.Format = "N0";
dtgv_SemiFiGoods.Columns["Accessory"].HeaderText = "Accessory";
dtgv_SemiFiGoods.Columns["AccessoryStock"].HeaderText = "Accessory Stock";
dtgv_SemiFiGoods.Columns["WarehouseofAccessory"].HeaderText = "Accessory Warehouse";
dtgv_SemiFiGoods.Columns["Accessory"].Visible = false;
dtgv_SemiFiGoods.Columns["AccessoryStock"].Visible = false;
dtgv_SemiFiGoods.Columns["WarehouseofAccessory"].Visible = false;
}
}
private void dtgv_BOMDeclar_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_BOMDeclar);
dtgv_BOMDeclar.AllowUserToAddRows = false;
if (dtgv_BOMDeclar.Rows.Count > 0)
{
dtgv_BOMDeclar.Columns["Product"].Visible = false;
dtgv_BOMDeclar.Columns["SLSanpham"].Visible = false;
dtgv_BOMDeclar.Columns["GiaTriSp"].Visible = false;
dtgv_BOMDeclar.Columns["DonviSp"].Visible = false;
}
}
private void dtgv_ExportSummary_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_ExportSummary);
dtgv_ExportSummary.AllowUserToAddRows = false;
if (dtgv_ExportSummary.Rows.Count > 0)
{
dtgv_ExportSummary.Columns["TL201"].Visible = false;
dtgv_ExportSummary.Columns["TL202"].Visible = false;
dtgv_ExportSummary.Columns["TL203"].Visible = false;
dtgv_ExportSummary.Columns["TL204"].Visible = false;
dtgv_ExportSummary.Columns["dateUpdate"].Visible = false;
dtgv_ExportSummary.Columns["TL211"].Visible = false;
dtgv_ExportSummary.Columns["TL212"].Visible = false;
dtgv_ExportSummary.Columns["TL213"].Visible = false;
dtgv_ExportSummary.Columns["TL214"].Visible = false;
dtgv_ExportSummary.Columns["PriceUnit"].Visible = false;
dtgv_ExportSummary.Columns["Currency"].Visible = false;
}
}
private void dtgv_importSummary_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_importSummary);
dtgv_importSummary.ReadOnly = false;
dtgv_importSummary.AllowUserToAddRows = false;
if (dtgv_importSummary.Rows.Count > 0)
{
dtgv_importSummary.Columns["SubQR"].Visible = false;
// dtgv_importSummary.Columns["KeyID"].Visible = false;
// dtgv_importSummary.Columns["KeyNo"].Visible = false;
dtgv_importSummary.Columns["TL101"].Visible = false;
dtgv_importSummary.Columns["TL102"].Visible = false;
dtgv_importSummary.Columns["TL103"].Visible = false;
dtgv_importSummary.Columns["TL104"].Visible = false;
dtgv_importSummary.Columns["dateUpdate"].Visible = false;
// dtgv_importSummary.Columns["ImportFlag"].Visible = false;
dtgv_importSummary.Columns["TL111"].Visible = false;
dtgv_importSummary.Columns["TL112"].Visible = false;
// dtgv_importSummary.Columns["TL113"].Visible = false;
dtgv_importSummary.Columns["TL114"].Visible = false;
// dtgv_importSummary.Columns["dateImport"].Visible = false;
dtgv_importSummary.Columns["ProductOrder"].HeaderText = "Production Order";
dtgv_importSummary.Columns["Quantity"].HeaderText = "Import Quantity (pcs)";
dtgv_importSummary.Columns["Quantity"].DefaultCellStyle.Format = "N0";
dtgv_importSummary.Columns["LotNo"].HeaderText = "Lot No";
dtgv_importSummary.Columns["dateCreate"].HeaderText = "Request's Date";
dtgv_importSummary.Columns["ImportFlag"].HeaderText = "Already Imported";
dtgv_importSummary.Columns["dateImport"].HeaderText = "Import Date";
dtgv_importSummary.Columns["TL113"].HeaderText = "ERP Doc";
dtgv_importSummary.Columns["ProductOrder"].ReadOnly = true;
dtgv_importSummary.Columns["Product"].ReadOnly = true;
dtgv_importSummary.Columns["STT"].ReadOnly = true;
dtgv_importSummary.Columns["Quantity"].ReadOnly = true;
dtgv_importSummary.Columns["LotNo"].ReadOnly = true;
dtgv_importSummary.Columns["Warehouse"].ReadOnly = true;
dtgv_importSummary.Columns["dateCreate"].ReadOnly = true;
dtgv_importSummary.Columns["dateCreate"].ReadOnly = true;
dtgv_importSummary.Columns["ImportFlag"].ReadOnly = true;
dtgv_importSummary.Columns["dateImport"].ReadOnly = true;
}
}
private void dtgv_data_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_data);
dtgv_data.AllowUserToAddRows = false;
if (dtgv_data.Rows.Count > 0)
{
dtgv_data.Columns["TE001"].Visible = false;
dtgv_data.Columns["TE002"].Visible = false;
dtgv_data.Columns["TE003"].HeaderText = "No";
dtgv_data.Columns["TE004"].HeaderText = "Material";
dtgv_data.Columns["TE005"].HeaderText = "Quantity";
dtgv_data.Columns["TE006"].HeaderText = "Unit";
dtgv_data.Columns["TE007"].Visible = false;
dtgv_data.Columns["TE008"].HeaderText = "Warehouse";
dtgv_data.Columns["TE009"].Visible = false;
dtgv_data.Columns["TE010"].HeaderText = "Lot";
dtgv_data.Columns["TE011"].HeaderText = "PO Code";
dtgv_data.Columns["TE012"].HeaderText = "PO No";
dtgv_data.Columns["TE017"].Visible = false;
dtgv_data.Columns["TE029"].HeaderText = "Location";
dtgv_data.Columns["TC009"].HeaderText = "Confirm";
}
}
private void dtgv_header_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_header);
if (dtgv_header.Rows.Count > 0)
{
dtgv_header.ColumnHeadersHeight = 100;
dtgv_header.Columns["product"].HeaderText = "Product";
dtgv_header.Columns["client"].HeaderText = "Client";
dtgv_header.Columns["Amount_Of_Order"].HeaderText = "Amount of Orders";
dtgv_header.Columns["Amount_Of_Order"].Width = 100;
dtgv_header.Columns["Amount_Of_Order"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["Total_Order_Qty"].HeaderText = "Total Order";
dtgv_header.Columns["Total_Order_Qty"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["StockInWarehouse"].HeaderText = "Finished Goods";
dtgv_header.Columns["StockInWarehouse"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["SemiFinishedGoods"].HeaderText = "Semi-FGs";
dtgv_header.Columns["SemiFinishedGoods"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["Semi_FGs_Needed_Qty"].HeaderText = "Semi-FGs Needed";
dtgv_header.Columns["Semi_FGs_Needed_Qty"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["StockSemiFinished"].HeaderText = "Semi-FGs Stock";
dtgv_header.Columns["StockSemiFinished"].DefaultCellStyle.Format = "N0";
// dtgv_header.Columns["MQCStock"].Width = 60;
dtgv_header.Columns["MQCStock"].HeaderText = "MQC Station";
dtgv_header.Columns["MQCStock"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["PQCStock"].HeaderText = "PQC Station";
dtgv_header.Columns["PQCStock"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["PendingWarehouse"].HeaderText = "IntoWH pending";
dtgv_header.Columns["PendingWarehouse"].DefaultCellStyle.Format = "N0";
dtgv_header.Columns["Accessories"].HeaderText = "Accessories";
dtgv_header.Columns["StockAccessory"].HeaderText = "Accessories Stock";
dtgv_header.Columns["StockAccessory"].DefaultCellStyle.Format = "N0";
}
}
private void dtgv_clientOrder_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_clientOrder);
if (dtgv_clientOrder.Rows.Count > 0)
{
dtgv_clientOrder.Columns["TC005"].Visible = false;
dtgv_clientOrder.Columns["TC004"].Visible = false;
dtgv_clientOrder.Columns["TD032"].Visible = false;
dtgv_clientOrder.Columns["TD036"].Visible = false;
dtgv_clientOrder.Columns["TD016"].Visible = false;
dtgv_clientOrder.Columns["TD021"].Visible = false;
dtgv_clientOrder.Columns["TD005"].Visible = false;
dtgv_clientOrder.Columns["TC012"].HeaderText = "Client Order";
dtgv_clientOrder.Columns["TD001"].HeaderText = "Order Code";
dtgv_clientOrder.Columns["TD002"].HeaderText = "Order No";
dtgv_clientOrder.Columns["TD003"].HeaderText = "STT";
dtgv_clientOrder.Columns["TD004"].HeaderText = "Product";
dtgv_clientOrder.Columns["TD008"].HeaderText = "Order Quantity";
dtgv_clientOrder.Columns["TD008"].DefaultCellStyle.Format = "N0";
dtgv_clientOrder.Columns["TD009"].HeaderText = "Delivery Quantity";
dtgv_clientOrder.Columns["TD009"].DefaultCellStyle.Format = "N0";
dtgv_clientOrder.Columns["TD010"].HeaderText = "Unit";
dtgv_clientOrder.Columns["TD013"].HeaderText = "Client Request Date";
dtgv_clientOrder.Columns["TC012"].ReadOnly = true;
dtgv_clientOrder.Columns["TD001"].ReadOnly = true;
dtgv_clientOrder.Columns["TD002"].ReadOnly = true;
dtgv_clientOrder.Columns["TD003"].ReadOnly = true;
dtgv_clientOrder.Columns["TD004"].ReadOnly = true;
dtgv_clientOrder.Columns["TD008"].ReadOnly = true;
dtgv_clientOrder.Columns["TD009"].ReadOnly = true;
dtgv_clientOrder.Columns["TD010"].ReadOnly = true;
dtgv_clientOrder.Columns["TD013"].ReadOnly = true;
}
}
private void dtgv_BOMCustoms_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_BOMCustoms);
dtgv_BOMCustoms.AllowUserToAddRows = false;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dataGridView1);
dataGridView1.AllowUserToAddRows = false;
}
private void dtgv_buyerSelect_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
dtgv_buyerSelect.AllowUserToAddRows = false;
DatagridviewSetting.settingDatagridview(dtgv_buyerSelect);
}
private void dtgv_WarehouseInfor_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DatagridviewSetting.settingDatagridview(dtgv_WarehouseInfor);
dtgv_WarehouseInfor.AllowUserToAddRows = false;
}
private void dtgv_BOMInfor_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
dtgv_BOMInforHQ.AllowUserToAddRows = false;
DatagridviewSetting.settingDatagridview(dtgv_BOMInforHQ);
}