private void BOMDeclarasionWin_Load(object sender, EventArgs e)
        {
            Database.ERPSOFT.t_HQ_ERP_MAPPING t_HQ_ERP_MAPPING = new Database.ERPSOFT.t_HQ_ERP_MAPPING();

            DataTable dtHQ = t_HQ_ERP_MAPPING.GetDataTableFromHQ_ERP_MAPPING();

            dtgv_MASPHQ.DataSource = dtHQ;
        }
        private void btn_Search_Click(object sender, EventArgs e)
        {
            Database.ERPSOFT.t_HQ_ERP_MAPPING t_HQ_ERP_MAPPING = new Database.ERPSOFT.t_HQ_ERP_MAPPING();

            DataTable dtHQ = t_HQ_ERP_MAPPING.GetDataTableFromHQ_ERP_MAPPINGbyproductSearch(txt_productSearch.Text.Trim());

            dtgv_MASPHQ.DataSource = dtHQ;
        }
        private void btn_compare_Click(object sender, EventArgs e)
        {
            Database.ERPSOFT.t_HQ_ERP_MAPPING t_HQ_ERP_MAPPING = new Database.ERPSOFT.t_HQ_ERP_MAPPING();
            DataTable dtMA_SP_HQ = t_HQ_ERP_MAPPING.GetAllDataTableFromHQ_ERP_MAPPING();

            Controller.CompareBOMHQERP compareBOMHQERP = new Controller.CompareBOMHQERP();

            ListhQERPBOMs          = compareBOMHQERP.listHQERPBoms(dtMA_SP_HQ);
            dtgv_MASPHQ.DataSource = ListhQERPBOMs;
        }
 private void btn_Update_Click(object sender, EventArgs e)
 {
     Database.ERPSOFT.t_HQ_ERP_MAPPING t_HQ_ERP_MAPPING = new Database.ERPSOFT.t_HQ_ERP_MAPPING();
     t_HQ_ERP_MAPPING.UploadProductCodebyCustomsDB();
 }