public JuchuuList()
{
InitializeComponent();
baseEntity = new BaseEntity();
juchuuListBL = new JuchuuListBL();
cf = new CommonFunction();
obj_Export = new ExportCSVExcel();
}
public HacchuuList()
{
cf = new CommonFunction();
baseEntity = new BaseEntity();
obj_Bl = new HacchuuListBL();
obj_Export = new ExportCSVExcel();
InitializeComponent();
}
public ShukkaSiziDataShuturyoku()
{
InitializeComponent();
baseEntity = _GetBaseData();
cf = new CommonFunction();
bbl = new BaseBL();
shukkaBL = new ShukkaSiziDataShuturyokuBL();
obj_Export = new ExportCSVExcel();
}
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");
}
}
public MasterList_Shouhin()
{
InitializeComponent();
cf = new CommonFunction();
obj_Export = new ExportCSVExcel();
}
