private DataTable ValidateFile(string fileName, DataTable table) { if (File.Exists(fileName)) { try { table = Foxpro.ReadFile(fileName); } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File: " + fileName + " tidak ditemukan !"); table = null; } return(table); }
private void LoadFile() { string fileName1 = "Htjtmp.dbf"; fileName1 = GlobalVar.DbfDownload + "\\" + fileName1; if (UnzipFile(fileName1)) { if (File.Exists(fileName1)) { try { dtDownload = Foxpro.ReadFile(fileName1); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dtDownload.Columns.Add(newcol); gvDownload1.DataSource = dtDownload; lblDownloadCount1.Text = "0/" + dtDownload.Rows.Count.ToString("#,##0"); pbDownload1.Minimum = 0; pbDownload1.Maximum = dtDownload.Rows.Count; lblInfo1.Text = fileName1; pbDownload1.Value = 0; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { lblInfo1.Text = "File " + fileName1 + " tidak ada."; cmdDownload.Enabled = false; MessageBox.Show("File: " + fileName1 + " tidak ada. Mohon cek kembali file tersebut apakah sudah ada dilokasi file yang sudah ditentukan.", "Download", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void frmHPPRataRataDownload_Load(object sender, EventArgs e) { string fileName = "hppatmp\\hppatmp.DBF"; string fileZIPName = "hppatmp.zip"; fileName = GlobalVar.DbfDownload + "\\" + fileName; fileZIPName = GlobalVar.DbfDownload + "\\" + fileZIPName; if (UnzipFile(fileZIPName, fileName)) { if (File.Exists(fileName)) { try { dtHPPHistory = Foxpro.ReadFile(fileName); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dtHPPHistory.Columns.Add(newcol); gvHPP.DataSource = dtHPPHistory; lblInfoRecordCount.Text = "0/" + dtHPPHistory.Rows.Count.ToString("#,##0"); pbHPPDownload.Minimum = 0; pbHPPDownload.Maximum = dtHPPHistory.Rows.Count; lblFileNameLocation.Text = fileName; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { lblFileNameLocation.Text = "File " + fileName + " tidak ada."; cmdDownload.Enabled = false; MessageBox.Show("File: " + fileName + " tidak ada. Mohon cek kembali file tersebut apakah sudah ada dilokasi file yang sudah ditentukan.", "Download HPP rata-rata", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private DataTable ValidateFile(string fileName, DataTable table) { if (File.Exists(fileName)) { try { table = Foxpro.ReadFile(fileName); pbSyncDownload.Value = 0; pbSyncDownload.Minimum = 0; pbSyncDownload.Maximum = table.Rows.Count; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File: " + fileName + " tidak ditemukan !"); } return(table); }
private void ExtractData() { string fileNameH = "datahi.dbf"; fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH; if (File.Exists(fileNameH)) { try { tblHeader = Foxpro.ReadFile(fileNameH); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblHeader.Columns.Add(newcol); //foreach (DataRow dr in tblHeader.Rows) //{ // dr["no_perk"] = ""; //} } catch (Exception ex) { Error.LogError(ex); } } }
private void LoadGridFromDBF() { try { if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip")) { ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip"); } else { MessageBox.Show("File " + GlobalVar.DbfDownload + "\\dbfmatch.zip tidak ada"); return; } string fileNameH = "hptmp.DBF"; string fileNameD = "dptmp.DBF"; string fileNamePromoB = "brgtmp.DBF"; string fileNamePromoC = "cptmp.DBF"; string fileNamePromoD = "ddptmp.DBF"; fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH; fileNameD = GlobalVar.DbfDownload + "\\" + fileNameD; fileNamePromoB = GlobalVar.DbfDownload + "\\" + fileNamePromoB; fileNamePromoC = GlobalVar.DbfDownload + "\\" + fileNamePromoC; fileNamePromoD = GlobalVar.DbfDownload + "\\" + fileNamePromoD; if (File.Exists(fileNameH)) { tblPromo = Foxpro.ReadFile(fileNameH); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblPromo.Columns.Add(newcol); DVPromo.DataSource = tblPromo; lblPrmo.Text = "0/" + tblPromo.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = tblPromo.Rows.Count; this.DialogResult = DialogResult.OK; } else { MessageBox.Show("File " + fileNameH + " tidak ada"); return; } if (File.Exists(fileNameD)) { try { tblDetailPromo = Foxpro.ReadFile(fileNameD); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblDetailPromo.Columns.Add(newcol); DVdetailPromo.DataSource = tblDetailPromo; lblDetailPromo.Text = "0/" + tblDetailPromo.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = tblDetailPromo.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNameD + " tidak ada"); return; } if (File.Exists(fileNamePromoB)) { try { tblBPromo = Foxpro.ReadFile(fileNamePromoB); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblBPromo.Columns.Add(newcol); DVBpromo.DataSource = tblBPromo; lblBpromo.Text = "0/" + tblBPromo.Rows.Count.ToString("#,##0"); progressBar3.Minimum = 0; progressBar3.Maximum = tblBPromo.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNamePromoB + " tidak ada"); return; } if (File.Exists(fileNamePromoC)) { try { tblCPromo = Foxpro.ReadFile(fileNamePromoC); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblCPromo.Columns.Add(newcol); DVCpromo.DataSource = tblCPromo; lblCpromo.Text = "0/" + tblCPromo.Rows.Count.ToString("#,##0"); progressBar4.Minimum = 0; progressBar4.Maximum = tblCPromo.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNamePromoC + " tidak ada"); return; } if (File.Exists(fileNamePromoD)) { try { tblDPromo = Foxpro.ReadFile(fileNamePromoD); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblDPromo.Columns.Add(newcol); DVDpromo.DataSource = tblDPromo; lblDpromo.Text = "0/" + tblDPromo.Rows.Count.ToString("#,##0"); progressBar5.Minimum = 0; progressBar5.Maximum = tblDPromo.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNamePromoD + " tidak ada"); return; } } catch (Exception ex) { Error.LogError(ex); } }
private void ExtractData() { if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip")) { ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip"); } else { MessageBox.Show("File dbfmatch.zip tidak ada"); this.Close(); return; } string fileNameH = "Hostmp.dbf"; string fileNameD = "Dostmp.dbf"; fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH; fileNameD = GlobalVar.DbfDownload + "\\" + fileNameD; if (File.Exists(fileNameH)) { try { tblHeader = Foxpro.ReadFile(fileNameH); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblHeader.Columns.Add(newcol); //dataGridView1.DataSource = tblHeader; lblDownloadStatus1.Text = "0/" + tblHeader.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = tblHeader.Rows.Count; this.Title = fileNameH; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } if (File.Exists(fileNameD)) { try { tblDetail = Foxpro.ReadFile(fileNameD); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblDetail.Columns.Add(newcol); //dataGridView3.DataSource = tblDetail; lblDownloadStatus2.Text = "0/" + tblDetail.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = tblDetail.Rows.Count; this.Title = this.Title + " " + fileNameD; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNameH + " atau " + fileNameD + " Tidak ada"); return; } dtHeaderFilter = tblHeader.Clone(); dtDetailFilter = tblDetail.Clone(); }
private void frmHargaDownload11_Load(object sender, EventArgs e) { string fileNameBMK = "tmpbmk.DBF"; string fileNameHks = "hkstmp.DBF"; string fileNameHksAgen = "Hjualtmp.DBF"; string fileZIPName = "DBFMATCH"; fileNameBMK = GlobalVar.DbfDownload + "\\" + fileNameBMK; fileNameHks = GlobalVar.DbfDownload + "\\" + fileNameHks; fileNameHksAgen = GlobalVar.DbfDownload + "\\" + fileNameHksAgen; if (UnzipFile(fileZIPName, fileNameBMK, fileNameHks, fileNameHksAgen)) { if (File.Exists(fileNameBMK)) { try { tblBMK = Foxpro.ReadFile(fileNameBMK); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblBMK.Columns.Add(newcol); dataGridView1.DataSource = tblBMK; lblDownloadStatus1.Text = "0/" + tblBMK.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = tblBMK.Rows.Count; this.Title = fileNameBMK; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } if (File.Exists(fileNameHks)) { try { tblHks = Foxpro.ReadFile(fileNameHks); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblHks.Columns.Add(newcol); dataGridView2.DataSource = tblHks; lblDownloadStatus2.Text = "0/" + tblHks.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = tblHks.Rows.Count; this.Title = fileNameHks; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } if (File.Exists(fileNameHksAgen)) { try { tblHksAgen = Foxpro.ReadFile(fileNameHksAgen); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblHksAgen.Columns.Add(newcol); //dataGridView2.DataSource = tblHksAgen; //lblDownloadStatus2.Text = "0/" + tblHksAgen.Rows.Count.ToString("#,##0"); //progressBar2.Minimum = 0; //progressBar2.Maximum = tblHksAgen.Rows.Count; //this.Title = fileNameHks; //this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } dataGridView1.AutoGenerateColumns = true; dataGridView2.AutoGenerateColumns = true; } }
private void ExtractData() { if (File.Exists(GlobalVar.DbfDownload + "\\BNSTMP.zip")) { ExtractFile(GlobalVar.DbfDownload + "\\BNSTMP.zip"); } string fileName1 = GlobalVar.DbfDownload + "\\Grstktmp.dbf", fileName2 = GlobalVar.DbfDownload + "\\Dtstktmp.dbf", fileName3 = GlobalVar.DbfDownload + "\\Grprdtmp.dbf"; // Read table 1 (Grstktmp) if (File.Exists(fileName1)) { try { dt1 = new DataTable(); dt1 = Foxpro.ReadFile(fileName1); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dt1.Columns.Add(newcol); dataGridView1.DataSource = dt1; lblDlStatus1.Text = "0/" + dt1.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = dt1.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } // Read table 2 (Dtstktmp) if (File.Exists(fileName2)) { try { dt2 = new DataTable(); dt2 = Foxpro.ReadFile(fileName2); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dt2.Columns.Add(newcol); dataGridView2.DataSource = dt2; lblDlStatus2.Text = "0/" + dt2.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = dt2.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } // Read table 3 (Grprdtmp) if (File.Exists(fileName3)) { try { dt3 = new DataTable(); dt3 = Foxpro.ReadFile(fileName3); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dt3.Columns.Add(newcol); dataGridView3.DataSource = dt3; lblDlStatus3.Text = "0/" + dt3.Rows.Count.ToString("#,##0"); progressBar3.Minimum = 0; progressBar3.Maximum = dt3.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } }
private void frmTargetSalesDownload_Load(object sender, EventArgs e) { if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip")) { ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip"); } else { MessageBox.Show("File " + GlobalVar.DbfDownload + "\\dbfmatch.zip tidak ada"); return; } string fileNameH = "TSlstmp.dbf"; string fileNameD = "TTokotmp.dbf"; fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH; fileNameD = GlobalVar.DbfDownload + "\\" + fileNameD; if (File.Exists(fileNameH)) { try { tblHeader = Foxpro.ReadFile(fileNameH); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblHeader.Columns.Add(newcol); dataGridView1.DataSource = tblHeader; lblDownloadStatus1.Text = "0/" + tblHeader.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = tblHeader.Rows.Count; this.Title = fileNameH; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } //else //{ // MessageBox.Show("File " + fileNameH + " tidak ada"); // return; //} if (File.Exists(fileNameD)) { try { tblDetail = Foxpro.ReadFile(fileNameD); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblDetail.Columns.Add(newcol); dataGridView2.DataSource = tblDetail; lblDownloadStatus2.Text = "0/" + tblDetail.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = tblDetail.Rows.Count; this.Title = fileNameD; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } //else //{ // MessageBox.Show("File " + fileNameD + " tidak ada"); // return; //} }
private void FrmHargaJualDownload_Load(object sender, EventArgs e) { if (File.Exists(GlobalVar.DbfDownload + "\\DBFMATCH.zip")) { ExtractFile(GlobalVar.DbfDownload + "\\DBFMATCH.zip"); } else { MessageBox.Show("File " + GlobalVar.DbfDownload + "\\DBFMATCH.zip tidak ada"); return; } string fileNameS = "Parttmp.dbf"; string fileNameB = "tmpbmk.dbf"; //string fileNameP = "Sptmp.dbf"; fileNameS = GlobalVar.DbfDownload + "\\" + fileNameS; fileNameB = GlobalVar.DbfDownload + "\\" + fileNameB; // fileNameP = GlobalVar.DbfDownload + "\\" + fileNameP; if (File.Exists(fileNameS)) { try { tblStokPart = Foxpro.ReadFile(fileNameS); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblStokPart.Columns.Add(newcol); dataGridView1.DataSource = tblStokPart; lblDownloadStatus1.Text = "0/" + tblStokPart.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = tblStokPart.Rows.Count; label2.Text = fileNameS; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } //else //{ // MessageBox.Show("File " + fileNameS + " tidak ada"); // return; //} if (File.Exists(fileNameB)) { try { tblBMK = Foxpro.ReadFile(fileNameB); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblBMK.Columns.Add(newcol); dataGridView2.DataSource = tblBMK; lblDownloadStatus2.Text = "0/" + tblBMK.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = tblBMK.Rows.Count; label4.Text = fileNameB; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNameB + " tidak ada"); return; } //if (File.Exists(fileNameP)) //{ // try // { // tblStokPart = Foxpro.ReadFile(fileNameP); // DataColumn newcol = new DataColumn("cUploaded"); // newcol.DataType = Type.GetType("System.Boolean"); // tblStokPart.Columns.Add(newcol); // //-dataGridView5.DataSource = tblStokPart; // //-label9.Text = "0/" + tblStokPart.Rows.Count.ToString("#,##0"); // progressBar3.Minimum = 0; // progressBar3.Maximum = tblStokPart.Rows.Count; // this.Title = fileNameP; // this.DialogResult = DialogResult.OK; // } // catch (Exception ex) // { // Error.LogError(ex); // } //} //else //{ // MessageBox.Show("File " + fileNameP + " tidak ada"); // return; //} }
private void LoadFile() { string fileName = lookupGudang.GudangID + GlobalVar.Gudang; string fileName1 = fileName + "\\Htj2tmp.dbf"; string fileName2 = fileName + "\\Dtj2tmp.dbf"; string fileZIPName = fileName + ".zip"; fileName1 = GlobalVar.DbfDownload + "\\" + fileName1; fileName2 = GlobalVar.DbfDownload + "\\" + fileName2; fileZIPName = GlobalVar.DbfDownload + "\\" + fileZIPName; if (UnzipFile(fileName, fileName1, fileName2)) { if (File.Exists(fileName1) && File.Exists(fileName2)) { try { dt1 = Foxpro.ReadFile(fileName1); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dt1.Columns.Add(newcol); gvDownload1.DataSource = dt1; lblDownloadCount1.Text = "0/" + dt1.Rows.Count.ToString("#,##0"); pbDownload1.Minimum = 0; pbDownload1.Maximum = dt1.Rows.Count; lblInfo1.Text = fileName1; dt2 = Foxpro.ReadFile(fileName2); DataColumn newcol2 = new DataColumn("cUploaded"); newcol2.DataType = Type.GetType("System.Boolean"); dt2.Columns.Add(newcol2); gvDownload2.DataSource = dt2; lblDownloadCount2.Text = "0/" + dt2.Rows.Count.ToString("#,##0"); pbDownload2.Minimum = 0; pbDownload2.Maximum = dt2.Rows.Count; lblInfo2.Text = fileName2; pbDownload1.Value = 0; pbDownload2.Value = 0; this.DialogResult = DialogResult.OK; cmdDownload.Enabled = true; } catch (Exception ex) { Error.LogError(ex); } } else { lblInfo1.Text = "File " + fileName1 + " tidak ada."; lblInfo2.Text = "File " + fileName2 + " tidak ada."; cmdDownload.Enabled = false; MessageBox.Show("File: " + fileName1 + " / " + fileName2 + " tidak ada. Mohon cek kembali file tersebut apakah sudah ada dilokasi file yang sudah ditentukan.", "Download", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void frmBPPDownload_Load(object sender, EventArgs e) { if (File.Exists(GlobalVar.DbfDownload + "\\BPP" + GlobalVar.Gudang + ".zip")) { ExtractFile(GlobalVar.DbfDownload + "\\BPP" + GlobalVar.Gudang + ".zip"); } else { MessageBox.Show("File " + GlobalVar.DbfDownload + "\\BPP" + GlobalVar.Gudang + ".zip tidak ada"); return; } string fileName = "BPPtmp.dbf"; string fileName2 = "BPPDetailtmp.dbf"; fileName = GlobalVar.DbfDownload + "\\" + fileName; fileName2 = GlobalVar.DbfDownload + "\\" + fileName2; if (File.Exists(fileName)) { try { dtBPP = Foxpro.ReadFile(fileName); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dtBPP.Columns.Add(newcol); dataGridView2.DataSource = dtBPP; dtBPP.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = dtBPP.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileName + " tidak ada"); return; } if (File.Exists(fileName2)) { try { dtBPPDetail = Foxpro.ReadFile(fileName2); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); dtBPPDetail.Columns.Add(newcol); dataGridView1.DataSource = dtBPPDetail; dtBPPDetail.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = dtBPPDetail.Rows.Count; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileName2 + " tidak ada"); return; } }
private void frmMasterStokDownload_Load(object sender, EventArgs e) { if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip")) { ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip"); } else { MessageBox.Show("File " + GlobalVar.DbfDownload + "\\dbfmatch.zip tidak ada"); return; } string fileNameS = "Stktmp.dbf"; string fileNameB = "Bctmp.dbf"; string fileNameP = "Sptmp.dbf"; fileNameS = GlobalVar.DbfDownload + "\\" + fileNameS; fileNameB = GlobalVar.DbfDownload + "\\" + fileNameB; fileNameP = GlobalVar.DbfDownload + "\\" + fileNameP; if (File.Exists(fileNameS)) { try { tblStok = Foxpro.ReadFile(fileNameS); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblStok.Columns.Add(newcol); dataGridView1.DataSource = tblStok; lblDownloadStatus1.Text = "0/" + tblStok.Rows.Count.ToString("#,##0"); progressBar1.Minimum = 0; progressBar1.Maximum = tblStok.Rows.Count; this.Title = fileNameS; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNameS + " tidak ada"); return; } if (File.Exists(fileNameB)) { try { tblStokBarcode = Foxpro.ReadFile(fileNameB); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblStokBarcode.Columns.Add(newcol); dataGridView4.DataSource = tblStokBarcode; label7.Text = "0/" + tblStokBarcode.Rows.Count.ToString("#,##0"); progressBar2.Minimum = 0; progressBar2.Maximum = tblStokBarcode.Rows.Count; this.Title = fileNameB; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNameB + " tidak ada"); return; } if (File.Exists(fileNameP)) { try { tblStokPart = Foxpro.ReadFile(fileNameP); DataColumn newcol = new DataColumn("cUploaded"); newcol.DataType = Type.GetType("System.Boolean"); tblStokPart.Columns.Add(newcol); dataGridView5.DataSource = tblStokPart; label9.Text = "0/" + tblStokPart.Rows.Count.ToString("#,##0"); progressBar3.Minimum = 0; progressBar3.Maximum = tblStokPart.Rows.Count; this.Title = fileNameP; this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } } else { MessageBox.Show("File " + fileNameP + " tidak ada"); return; } }