コード例 #1
0
        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";
            }
        }
コード例 #2
0
        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;



            //}
        }
コード例 #3
0
        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;
            }
        }
コード例 #5
0
 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;
     }
 }
コード例 #6
0
 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;
     }
 }
コード例 #7
0
        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;
            }
        }
コード例 #8
0
 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";
     }
 }
コード例 #9
0
        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";
            }
        }
コード例 #10
0
        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;
            }
        }
コード例 #11
0
 private void dtgv_BOMCustoms_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
 {
     DatagridviewSetting.settingDatagridview(dtgv_BOMCustoms);
     dtgv_BOMCustoms.AllowUserToAddRows = false;
 }
コード例 #12
0
 private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
 {
     DatagridviewSetting.settingDatagridview(dataGridView1);
     dataGridView1.AllowUserToAddRows = false;
 }
コード例 #13
0
 private void dtgv_buyerSelect_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
 {
     dtgv_buyerSelect.AllowUserToAddRows = false;
     DatagridviewSetting.settingDatagridview(dtgv_buyerSelect);
 }
コード例 #14
0
 private void dtgv_WarehouseInfor_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
 {
     DatagridviewSetting.settingDatagridview(dtgv_WarehouseInfor);
     dtgv_WarehouseInfor.AllowUserToAddRows = false;
 }
コード例 #15
0
 private void dtgv_BOMInfor_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
 {
     dtgv_BOMInforHQ.AllowUserToAddRows = false;
     DatagridviewSetting.settingDatagridview(dtgv_BOMInforHQ);
 }