private void BindCombo() { petc0307_bl = new PETC0307I_BL(); DataTable dt = new DataTable(); dt = petc0307_bl.RakutenShop_Combo(); cboRakutenStore.DisplayMember = "Char1"; cboRakutenStore.ValueMember = "Key"; cboRakutenStore.DataSource = dt; }
private void F12() { if (ErrorCheck()) { ShopId = cboRakutenStore.SelectedValue.ToString(); startdate = txtStartDate.Text.Replace("/", "-"); enddate = txtEndDate.Text.Replace("/", "-"); DataTable dtRakuten = new DataTable(); petc0307_bl = new PETC0307I_BL(); dtRakuten = petc0307_bl.PECT0301I_Select(ShopId, startdate, enddate); if (dtRakuten.Rows.Count > 0) { petc0307_bl = new PETC0307I_BL(); DataTable dtFolder = new DataTable(); dtFolder = petc0307_bl.GetFolder(ShopId); string Folderpath = dtFolder.Rows[0]["Char2"].ToString(); if (!string.IsNullOrWhiteSpace(Folderpath)) { if (!Directory.Exists(Folderpath)) { Directory.CreateDirectory(Folderpath); } #region CSV create and save SaveFileDialog savedialog = new SaveFileDialog(); savedialog.Filter = "CSV|*.csv"; savedialog.Title = "Save"; savedialog.FileName = dtFolder.Rows[0]["Char3"].ToString(); savedialog.InitialDirectory = dtFolder.Rows[0]["Char2"].ToString(); savedialog.RestoreDirectory = true; if (savedialog.ShowDialog() == DialogResult.OK) { if (Path.GetExtension(savedialog.FileName).Contains("csv")) { CsvWriter csvwriter = new CsvWriter(); csvwriter.WriteCsv(dtRakuten, savedialog.FileName, Encoding.GetEncoding(932)); } Process.Start(Path.GetDirectoryName(savedialog.FileName)); } #endregion } } else { MessageBox.Show("There's no data to export!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }