private void Excel_Export() { if (gvFreeInventoryDetails.Rows.Count > 0 && rdoFreeInventory.Checked) { DataTable dtExcel = new DataTable(); dt = (DataTable)gvFreeInventoryDetails.DataSource; dtExcel = dt.Copy(); dtExcel.Columns.Remove(dtExcel.Columns[4]); dtExcel.AcceptChanges(); string fname = "在庫表"; ExportCSVExcel list = new ExportCSVExcel(); bool bl = list.ExcelOutputFile(dtExcel, ProgramID, fname, fname, 7, null, null); } else { bbl.ShowMessage("E277"); } }
private void Excel_Export() { TokuisakiBL bl = new TokuisakiBL(); dt = bl.Get_ExportData(Get_UIData()); if (dt.Rows.Count > 0) { string ProgramID = "MasterList_Tokuisaki"; string fname = "得意先マスタリスト"; string[] datacol = { "2", "28", "29" }; ExportCSVExcel list = new ExportCSVExcel(); bool Clear_bl = list.ExcelOutputFile(dt, ProgramID, fname, fname, 36, datacol, null); if (Clear_bl) { Clear(); } } else { bbl.ShowMessage("S013"); } }
private void Excel_Export() { SiiresakiBL sbl = new SiiresakiBL(); dtSiiresaki = sbl.Get_ExportData(Get_UIData()); if (dtSiiresaki.Rows.Count > 0) { string ProgramID = "MasterList_Siiresaki"; string fname = "仕入先マスタリスト"; string[] datacol = { "2", "28", "29" }; ExportCSVExcel list = new ExportCSVExcel(); bool bl = list.ExcelOutputFile(dtSiiresaki, ProgramID, fname, fname, 34, datacol, null); if (bl) { Clear(); } } else { bbl.ShowMessage("S013"); } }
public override void FunctionProcess(string tagID) { if (tagID == "6") { Clear(); } if (tagID == "10") { DataTable dt = new DataTable { TableName = "MyTableName" }; dt = Get_Form_Object(string.Empty); if (dt.Rows.Count > 0) { dt.Columns["TokuisakiCD"].ColumnName = "得意先CD"; dt.Columns["KouritenCD"].ColumnName = "店舗CD"; dt.Columns["TokuisakiName"].ColumnName = "得意先名"; dt.Columns["KouritenName"].ColumnName = "店舗名"; dt.Columns["DenpyouDate"].ColumnName = "伝票日付"; dt.Columns["ShukkaYoteiDate"].ColumnName = "出荷日"; dt.Columns["HinbanCD"].ColumnName = "品番"; dt.Columns["ColorRyakuName"].ColumnName = "カラー"; dt.Columns["SizeNO"].ColumnName = "サイズ"; dt.Columns["JANCD"].ColumnName = "JANコード"; dt.Columns["ShukkaSiziSuu"].ColumnName = "数量"; dt.Columns["UriageTanka"].ColumnName = "単価"; dt.Columns["UriageKingaku"].ColumnName = "金額"; //dt.Columns["KouritenJuusho2"].ColumnName = "先方発注№"; //dt.Columns["SenpouHacchuuNO"].ColumnName = "出荷指示番号"; dt.Columns["SenpouHacchuuNO"].ColumnName = "先方発注№"; dt.Columns["ShukkaSiziNO"].ColumnName = "出荷指示番号"; dt.Columns["ShukkaSiziMeisaiTekiyou"].ColumnName = "備考"; string ProgramID = "ShukkaSiziDataShuturyoku"; string fname = "出荷指示データ出力"; string[] datacol = { "5", "6" }; string[] numcol = null; ExportCSVExcel list = new ExportCSVExcel(); bool bl = list.ExcelOutputFile(dt, ProgramID, fname, fname, 16, datacol, numcol); if (bl) { Get_Form_Object("Update"); Clear(); } //if (!System.IO.Directory.Exists("C:\\Excel")) // System.IO.Directory.CreateDirectory("C:\\Excel"); //SaveFileDialog saveFileDialog1 = new SaveFileDialog(); //saveFileDialog1.InitialDirectory = @"C:\Excel\"; ////for excel //saveFileDialog1.Filter = "ExcelFile|*.xlsx"; //saveFileDialog1.FileName = "出荷指示データ出力.xlsx"; //saveFileDialog1.RestoreDirectory = true; //if (saveFileDialog1.ShowDialog() == DialogResult.OK) //{ // ExcelDesignSetting obj = new ExcelDesignSetting(); // obj.FilePath = saveFileDialog1.FileName; // obj.SheetName = "Sheet1"; // obj.Start_Interior_Column = "A1"; // obj.End_Interior_Column = "P1"; // obj.Interior_Color = Color.FromArgb(255, 192, 0); // obj.Start_Font_Column = "A1"; // obj.End_Font_Column = "P1"; // obj.Font_Color = Color.Black; // //For column E,F // obj.Date_Column = new List<int>(); // obj.Date_Column.Add(5); // obj.Date_Column.Add(6); // obj.Date_Format = "YYYY/MM/DD"; // obj.Start_Title_Center_Column = "A1"; // obj.End_Title_Center_Column = "P1"; // bool bl = obj_Export.ExportDataTableToExcel(dt, obj); // if (bl) // { // bbl.ShowMessage("I203"); // Clear(); // } //} } else if (dt.Rows.Count == 0) { bbl.ShowMessage("S013"); if (PreviousCtrl != null) { PreviousCtrl.Focus(); } } base.FunctionProcess(tagID); } }
public override void FunctionProcess(string tagID) { if (tagID == "6") { Clear(); } if (tagID == "10") { DataTable dt = new DataTable { TableName = "JuchuuListTable" }; dt = Get_Form_Object(); if (dt.Rows.Count > 0) { dt.Columns["JuchuuNO"].ColumnName = "受注番号"; dt.Columns["JuchuuDate"].ColumnName = "受発注日"; dt.Columns["StaffName"].ColumnName = "担当者 "; dt.Columns["TokuisakiCD"].ColumnName = "得意先コード"; dt.Columns["TokuisakiRyakuName"].ColumnName = "得意先名"; dt.Columns["KouritenCD"].ColumnName = "小売店コード"; dt.Columns["KouritenRyakuName"].ColumnName = "小売店"; dt.Columns["SenpouHacchuuNO"].ColumnName = "先方発注番号"; dt.Columns["SenpouBusho"].ColumnName = "先方部署 "; dt.Columns["KibouNouki"].ColumnName = "希望納期"; dt.Columns["JuchuuDenpyouTekiyou"].ColumnName = "伝票摘要"; dt.Columns["Char1"].ColumnName = "ブランド"; dt.Columns["Exhibition"].ColumnName = "展示会"; dt.Columns["JANCD"].ColumnName = "JANコード"; dt.Columns["HinbanCD"].ColumnName = "品番"; //TaskNo564 HET dt.Columns["ShouhinName"].ColumnName = "品名"; dt.Columns["ColorRyakuName"].ColumnName = "カラー"; dt.Columns["SizeNO"].ColumnName = "サイズ"; dt.Columns["JuchuuSuu"].ColumnName = "数量"; dt.Columns["UriageTanka"].ColumnName = "上代 "; dt.Columns["HacchuuTanka"].ColumnName = "下代"; dt.Columns["Free"].ColumnName = "Free"; dt.Columns["JuchuuMeisaiTekiyou"].ColumnName = "明細摘要"; dt.Columns["SiiresakiCD"].ColumnName = "発注先"; dt.Columns["SiiresakiRyakuName"].ColumnName = "発注先名"; //dt.Columns.Remove("発注先名"); //HET dt.Columns["SoukoName"].ColumnName = "倉庫"; string ProgramID = "JuchuuList"; string fname = "受注リスト"; string[] datacol = { "2", "10" }; string[] numcol = { "19", "20", "21" }; ExportCSVExcel list = new ExportCSVExcel(); list.stringCol = new string[1] { "14" }; bool bl = list.ExcelOutputFile(dt, ProgramID, fname, fname, 26, datacol, numcol); if (bl) { Clear(); } //if (!System.IO.Directory.Exists("C:\\Excel")) // System.IO.Directory.CreateDirectory("C:\\Excel"); //SaveFileDialog saveFileDialog1 = new SaveFileDialog(); //saveFileDialog1.InitialDirectory = @"C:\Excel\"; ////for excel //saveFileDialog1.Filter = "ExcelFile|*.xlsx"; //saveFileDialog1.FileName = "受注リスト.xlsx"; //saveFileDialog1.RestoreDirectory = true; //if (saveFileDialog1.ShowDialog() == DialogResult.OK) //{ // ExcelDesignSetting obj = new ExcelDesignSetting(); // obj.FilePath = saveFileDialog1.FileName; // obj.SheetName = "受注リスト"; // obj.Start_Interior_Column = "A1"; // obj.End_Interior_Column = "Z1"; // obj.Interior_Color = Color.FromArgb(255, 192, 0); // obj.Start_Font_Column = "A1"; // obj.End_Font_Column = "Z1"; // obj.Font_Color = Color.Black; // //For column B // obj.Date_Column = new List<int>(); // obj.Date_Column.Add(2); // obj.Date_Column.Add(10); // obj.Date_Format = "YYYY/MM/DD"; // obj.Start_Title_Center_Column = "A1"; // obj.End_Title_Center_Column = "Z1"; // //for column T,U // //obj.Number_Column = new List<int>(); // //obj.Number_Column.Add(19); // //obj.Number_Column.Add(20); // //obj.Number_Column.Add(21); // //obj.Number_Format = "#,###,###"; // bool bl = obj_Export.ExportDataTableToExcel(dt, obj); // if (bl) // { // bbl.ShowMessage("I203"); // Clear(); // } //} } else if (dt.Rows.Count == 0) { bbl.ShowMessage("S013"); if (PreviousCtrl != null) { PreviousCtrl.Focus(); } } } base.FunctionProcess(tagID); }
private void Excel_Export() { ShouhinBL sh_bl = new ShouhinBL(); dtShouhin = sh_bl.Get_ExportData(Get_UIData()); if (dtShouhin.Rows.Count > 0) { string ProgramID = "MasterList_Shouhin"; string fname = "商品マスタリスト"; string[] datacol = { "2", "33", "34" }; string[] numcol = { "22", "23", "24", "37" }; ExportCSVExcel list = new ExportCSVExcel(); //list.stringCol = new string[1] { "10" }; bool bl = list.ExcelOutputFile(dtShouhin, ProgramID, fname, fname, 45, datacol, numcol); if (bl) { Clear(); } //if (!System.IO.Directory.Exists("C:\\ShinYoh\\" + ProgramID + "\\")) // System.IO.Directory.CreateDirectory("C:\\ShinYoh\\" + ProgramID + "\\"); //SaveFileDialog saveFileDialog1 = new SaveFileDialog(); //saveFileDialog1.InitialDirectory = @"C:\ShinYoh\" + ProgramID + "\""; ////for excel //saveFileDialog1.Filter = "ExcelFile|*.xlsx"; //saveFileDialog1.FileName = fname; //saveFileDialog1.RestoreDirectory = true; //if (saveFileDialog1.ShowDialog() == DialogResult.OK) //{ // ExcelDesignSetting obj = new ExcelDesignSetting(); // obj.FilePath = saveFileDialog1.FileName; // obj.SheetName = "Sheet1"; // obj.Start_Interior_Column = "A1"; // obj.End_Interior_Column = "AS1"; // obj.Interior_Color = Color.FromArgb(255, 192, 0); // obj.Start_Font_Column = "A1"; // obj.End_Font_Column = "AS1"; // obj.Font_Color = Color.Black; // obj.Start_Title_Center_Column = "A1"; // obj.End_Title_Center_Column = "AS1"; // obj.Number_Column = new List<int>(); // obj.Number_Column.Add(22); // obj.Number_Column.Add(23); // obj.Number_Column.Add(24); // obj.Number_Column.Add(37); // obj.Number_Format = "#,###,###"; // bool bl = obj_Export.ExportDataTableToExcel(dtShouhin, obj); // if (bl) // { // bbl.ShowMessage("I203"); // Clear(); // } //} } else { bbl.ShowMessage("S013"); } }