private void DoInsert(TokuisakiEntity tokuisakiEntity)
{
TokuisakiBL bl = new TokuisakiBL();
string return_Bl = bl.M_Tokuisaki_CUD(tokuisakiEntity);
if (return_Bl == "true")
{
bbl.ShowMessage("I101");
}
}
private void DoInsert(SoukoEntity soukoInsert)
{
SoukoBL souko = new SoukoBL();
string return_Bl = souko.M_Souko_CUD(soukoInsert);
if (return_Bl == "true")
{
bbl.ShowMessage("I101");
}
}
private void DoInsert(MasterTourokuStaff obj)
{
StaffBL objMethod = new StaffBL();
string return_Bl = objMethod.M_Staff_CUD(obj);
if (return_Bl == "true")
{
bbl.ShowMessage("I101");
}
}
public override void FunctionProcess(string tagID)
{
if (tagID == "6")
{
cf.Clear(PanelTitle);
cf.Clear(PanelDetail);
lbl_dataPartition.Text = "";
lbl_InputPerson.Text = "";
}
if (tagID == "7")
{
OnCheck();
}
if (tagID == "8")
{
OFFCheck();
}
if (tagID == "10")
{
if (ErrorCheck(PanelTitle))
{
btnDisplay();
if (gvHaitaSakujo.Rows.Count > 0)
{
gvHaitaSakujo.CurrentCell = gvHaitaSakujo.Rows[0].Cells["col_Target"];
Control btnF9 = this.TopLevelControl.Controls.Find("BtnF9", true)[0];
btnF9.Visible = false;
}
}
}
if (tagID == "12")
{
if (!IsCheckExist())
{
bll.ShowMessage("E257");
F12.Focus();
return;
}
else
{
if (bll.ShowMessage("Q101") != DialogResult.Yes)
{
if (PreviousCtrl != null)
{
PreviousCtrl.Focus();
}
}
else
{
btnClearExclusive();
}
}
}
}
public override void FunctionProcess(string tagID)
{
if (tagID == "2")
{
ChangeMode(Mode.New);
}
if (tagID == "3")
{
ChangeMode(Mode.Update);
}
if (tagID == "4")
{
ChangeMode(Mode.Delete);
}
if (tagID == "5")
{
ChangeMode(Mode.Inquiry);
}
if (tagID == "6")
{
Clear();
}
if (tagID == "12")
{
if (ErrorCheck(PanelTitle) && ErrorCheck(PanelDetail))
{
DBProcess();
switch (cboMode.SelectedValue)
{
case "1":
ChangeMode(Mode.New);
bbl.ShowMessage("I101");
break;
case "2":
ChangeMode(Mode.Update);
bbl.ShowMessage("I101");
break;
case "3":
ChangeMode(Mode.Delete);
bbl.ShowMessage("I102");
break;
case "4":
ChangeMode(Mode.Inquiry);
break;
}
}
}
base.FunctionProcess(tagID);
}
private bool ErrorCheckMain()
{
if (string.IsNullOrEmpty(txtKanriNO.Text))
{
bbl.ShowMessage("E102");
return(false);
}
string knrno = SheetNameForbiddenRegex.Replace(txtKanriNO.Text, "");
if (!txtKanriNO.Text.Equals(knrno))
{
bbl.ShowMessage("E118");
return(false);
}
return(true);
}
private bool ErrorCheck()
{
BaseBL bbl = new BaseBL();
if (string.IsNullOrWhiteSpace(txtOperatorCD.Text))
{
bbl.ShowMessage("E101");
txtOperatorCD.Focus();
return(false);
}
if (string.IsNullOrWhiteSpace(txtPassword.Text))
{
bbl.ShowMessage("E101");
txtPassword.Focus();
return(false);
}
OperatorCD = txtOperatorCD.Text.Trim();
return(true);
}
public void ShinyohMenu_FormClosing(object sender, FormClosingEventArgs e)
{
BaseBL bbl = new BaseBL();
if (CheckOpenForm())
{
if (bbl.ShowMessage("Q003") == DialogResult.Yes)
{
ForceToCLose();
e.Cancel = false;
}
else
{
e.Cancel = true;
}
}
}
private void txtIdouDate_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (!txtIdouDate.IsErrorOccurs)
{
if (!string.IsNullOrEmpty(txtStaffCD.Text))
{
StaffBL sBL = new StaffBL();
DataTable sf_DT = sBL.Staff_Select_Check(txtStaffCD.Text, txtIdouDate.Text, "E101");
if (sf_DT.Rows.Count > 0 && sf_DT.Rows[0]["MessageID"].ToString() != "E101")
{
txtStaffCD.Text = sf_DT.Rows[0]["StaffCD"].ToString();
lblStaff_Name.Text = sf_DT.Rows[0]["StaffName"].ToString();
}
else
{
base_bl.ShowMessage("E101");
}
}
}
}
}
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");
}
}
private void DoInsert(multipurposeEntity mentity)
{
mbl.M_Multiporpose_Insert_Update(mentity);
bbl.ShowMessage("I101");
}
public override void FunctionProcess(string tagID)
{
if (tagID == "2")
{
ChangeMode(Mode.New);
}
if (tagID == "3")
{
ChangeMode(Mode.Update);
}
if (tagID == "4")
{
ChangeMode(Mode.Delete);
}
if (tagID == "5")
{
ChangeMode(Mode.Inquiry);
}
if (tagID == "6")
{
Mode_Setting();
}
if (tagID == "10")
{
string Xml = ChooseFile();
BaseBL bbl = new BaseBL();
if (!string.IsNullOrEmpty(Xml))
{
TokuisakiBL bl = new TokuisakiBL();
string chk_val = string.Empty;
if (sRadRegister.Checked)
{
chk_val = "create_Err_Check";
}
else
{
chk_val = "delete_Err_Check";
}
DataTable dt = bl.CSV_M_Tokuisaki_CUD(Xml, chk_val);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Result"].ToString().Equals("1"))
{
if (bbl.ShowMessage("Q206") != DialogResult.Yes)
{
if (PreviousCtrl != null)
{
PreviousCtrl.Focus();
}
}
else
{
if (sRadRegister.Checked)
{
chk_val = "create_update";
}
else
{
chk_val = "delete";
}
dt = bl.CSV_M_Tokuisaki_CUD(Xml, chk_val);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Result"].ToString().Equals("1"))
{
bbl.ShowMessage("I002");
sRadRegister.Checked = true;
sRadDelete.Checked = false;
}
}
}
}
else
{
bbl.ShowMessage("E276", dt.Rows[0]["SEQ"].ToString(), dt.Rows[0]["Error1"].ToString(), dt.Rows[0]["Error2"].ToString());
}
}
}
}
if (tagID == "12")
{
// if (ErrorCheck(PanelTitle) && ErrorCheck(PanelDetail))
// {
DBProcess();
switch (cboMode.SelectedValue)
{
case "1":
ChangeMode(Mode.New);
break;
case "2":
ChangeMode(Mode.Update);
break;
case "3":
ChangeMode(Mode.Delete);
break;
case "4":
ChangeMode(Mode.Inquiry);
break;
// }
}
}
base.FunctionProcess(tagID);
}
public void ShowErrorMessage(string messageID)
{
bbl.ShowMessage(messageID);
}
public override void FunctionProcess(string tagID)
{
if (tagID == "2")
{
ChangeMode(Mode.New);
}
if (tagID == "3")
{
ChangeMode(Mode.Update);
}
if (tagID == "4")
{
ChangeMode(Mode.Delete);
}
if (tagID == "5")
{
ChangeMode(Mode.Inquiry);
}
if (tagID == "6")
{
UI_ErrorCheck();
if (cboMode.SelectedValue.Equals("2") || cboMode.SelectedValue.Equals("3") || cboMode.SelectedValue.Equals("4"))
{
txtCopyProduct.Enabled = false;
txtCopyChangeDate.Enabled = false;
txtCopyColor.Enabled = false; //HET
txtCopySize.Enabled = false; //HET
}
}
if (tagID == "10")
{
string Xml = GetFileData();
if (!string.IsNullOrEmpty(Xml))
{
ShouhinBL bl = new ShouhinBL();
string chk_val = string.Empty;
if (rdo_Registragion.Checked)
{
chk_val = "create_Err_Check";
}
else
{
chk_val = "delete_Err_Check";
}
DataTable dt = bl.CSV_M_Shouhin_CUD(Xml, chk_val);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Result"].ToString().Equals("1"))
{
if (bbl.ShowMessage("Q206") != DialogResult.Yes)
{
PreviousCtrl.Focus();
}
else
{
if (rdo_Registragion.Checked)
{
chk_val = "create_update";
}
else
{
chk_val = "delete";
}
dt = bl.CSV_M_Shouhin_CUD(Xml, chk_val);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Result"].ToString().Equals("1"))
{
bbl.ShowMessage("I002");
rdo_Registragion.Checked = true;
rdo_Delete.Checked = false;
}
}
}
}
else
{
bbl.ShowMessage("E276", dt.Rows[0]["SEQ"].ToString(), dt.Rows[0]["Error1"].ToString(), dt.Rows[0]["Error2"].ToString());
}
}
}
}
if (tagID == "12")
{
if (ErrorCheck(PanelTitle) && ErrorCheck(PanelDetail))
{
DBProcess();
switch (cboMode.SelectedValue)
{
case "1":
ChangeMode(Mode.New);
bbl.ShowMessage("I101");
break;
case "2":
ChangeMode(Mode.Update);
bbl.ShowMessage("I101");
break;
case "3":
ChangeMode(Mode.Delete);
bbl.ShowMessage("I102");
break;
case "4":
ChangeMode(Mode.Inquiry);
break;
}
}
}
base.FunctionProcess(tagID);
}
public override void FunctionProcess(string tagID)
{
if (tagID == "6")
{
Clear();
}
if (tagID == "10")
{
gvJuchuuTorikomi.ActionType = "F10";
if (rdo_Delete.Checked == true)
{
txtDenpyouNO.E102Check(false);
txtDenpyouNO.E160Check(false, "JuchuuTorikomi", txtDenpyouNO, null);
txtDenpyouNO.E265Check(false, "JuchuuTorikomi", txtDenpyouNO);
}
if (ErrorCheck(PanelDetail))
{
GridviewBind();
}
gvJuchuuTorikomi.ActionType = string.Empty;
}
if (tagID == "12")
{
gvJuchuuTorikomi.ActionType = "F10";
string spname = string.Empty;
if (rdo_Delete.Checked)
{
txtDenpyouNO.E102Check(true);
txtDenpyouNO.E160Check(true, "JuchuuTorikomi", txtDenpyouNO, null);
txtDenpyouNO.E265Check(true, "JuchuuTorikomi", txtDenpyouNO);
}
else
{
txtDenpyouNO.E102Check(false);
txtDenpyouNO.E160Check(false, "JuchuuTorikomi", txtDenpyouNO, null);
txtDenpyouNO.E265Check(false, "JuchuuTorikomi", txtDenpyouNO);
}
if (ErrorCheck(PanelDetail))
{
if (rdo_Registration.Checked)
{
(string, string)Xml = GetFile();
if (!string.IsNullOrEmpty(Xml.Item1) && !string.IsNullOrEmpty(Xml.Item2))
{
{
spname = "JuchuuTorikomi_Insert";
DataTable return_BL1 = JBL.JuchuuTorikomi_CUD(spname, Xml.Item1, Xml.Item2, "ErrorCheck");
if (return_BL1.Rows.Count > 0)
{
if (return_BL1.Rows[0]["Result"].ToString().Equals("1"))
{
if (bbl.ShowMessage("Q206") != DialogResult.Yes)
{
if (PreviousCtrl != null)
{
PreviousCtrl.Focus();
}
}
else
{
return_BL1 = JBL.JuchuuTorikomi_CUD(spname, Xml.Item1, Xml.Item2, "");
if (return_BL1.Rows.Count > 0)
{
if (return_BL1.Rows[0]["Result"].ToString().Equals("1"))
{
bbl.ShowMessage("I002");
rdo_Registration.Focus();
}
}
}
}
else
{
bbl.ShowMessage("E276", return_BL1.Rows[0]["SEQ"].ToString(), return_BL1.Rows[0]["Error1"].ToString(), return_BL1.Rows[0]["Error2"].ToString());
}
}
}
}
}
else
{
string DenpyouNO = txtDenpyouNO.Text;
gvJuchuuTorikomi.DataSource = dtMain;
if (bbl.ShowMessage("Q102") == DialogResult.Yes)
{
string Xml = string.Empty;
spname = "JuchuuTorikomi_Delete";
Xml = cf.DataTableToXml(dtMain);
foreach (DataRow dr in dtMain.Rows)
{
string JuchuuNO = dr["JuchuuNO"].ToString();
JEntity.DataKBN = 1;
JEntity.Number = JuchuuNO;
JEntity.ProgramID = ProgramID;
JEntity.PC = PCID;
JEntity.OperatorCD = OperatorCD;
DataTable dt1 = new DataTable();
dt1 = JBL.D_Exclusive_Lock_Check(JEntity);
if (dt1.Rows[0]["MessageID"].ToString().Equals("S004"))
{
bbl.ShowMessage("S004");
}
}
JEntity.OperatorCD = base_Entity.OperatorCD;
JEntity.ProgramID = base_Entity.ProgramID;
JEntity.PC = base_Entity.PC;
JEntity.OperateMode = "Delete";
DataTable return_BL1 = JBL.JuchuuTorikomi_Delete(spname, Xml, DenpyouNO, JEntity);
if (return_BL1.Rows.Count > 0)
{
if (return_BL1.Rows[0]["Result"].ToString().Equals("1"))
{
bbl.ShowMessage("I002");
rdo_Delete.Checked = true;
txtDate1.Clear();
txtDate2.Clear();
txtDenpyouNO.Clear();
txtDenpyouNO.Focus();
GridviewBind();
}
else
{
bbl.ShowMessage("S013");
txtDenpyouNO.Focus();
}
}
}
else
{
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 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);
}
public (bool, string) JuchuuNyuuryoku(int memory_row, DataTable dt, string changeDate)
{
bool error_occur = false;
string row_col = string.Empty;
if (memory_row == 0)
{
base_bl.ShowMessage("E274");
error_occur = true;
return(error_occur, row_col);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string isSelected = string.Empty;
string free = dt.Rows[i]["Free"].ToString().ToString();
string JuchuuSuu = dt.Rows[i]["JuchuuSuu"].ToString();
string siiresakiCD = dt.Rows[i]["SiiresakiCD"].ToString(); //requierd Field
string expectedDate = dt.Rows[i]["ExpectedDate"].ToString(); //requierd Field
string soukoCD = dt.Rows[i]["SoukoCD"].ToString(); //requierd Field
if (string.IsNullOrEmpty(free))
{
isSelected = "OFF";
}
else
{
isSelected = "ON";
}
int j = 0;
if (isSelected == "OFF" && JuchuuSuu != "0")
{
foreach (DataColumn dc in dt.Columns)
{
row_col = i + "_" + j;
if (dc.ColumnName == "SiiresakiCD")
{
if (string.IsNullOrEmpty(siiresakiCD))
{
base_bl.ShowMessage("E102");
error_occur = true;
goto BreakProcess;
}
else
{
DataTable siiresaki_dt = new DataTable();
(error_occur, siiresaki_dt) = Gridview_Error_Check("E101", siiresakiCD, "Siiresaki", changeDate);
if (error_occur)
{
goto BreakProcess;
}
(error_occur, siiresaki_dt) = Gridview_Error_Check("E227", siiresakiCD, "Siiresaki", changeDate);
if (error_occur)
{
goto BreakProcess;
}
(error_occur, siiresaki_dt) = Gridview_Error_Check("E267", siiresakiCD, "Siiresaki", changeDate);
if (error_occur)
{
goto BreakProcess;
}
}
}
if (dc.ColumnName == "ExpectedDate")
{
if (string.IsNullOrEmpty(expectedDate))
{
base_bl.ShowMessage("E102");
error_occur = true;
goto BreakProcess;
}
STextBox txt = new STextBox();
txt.Text = expectedDate;
if (!cf.DateCheck(txt))
{
base_bl.ShowMessage("E103");
error_occur = true;
goto BreakProcess;
}
if (Convert.ToDateTime(expectedDate) < Convert.ToDateTime(changeDate))
{
base_bl.ShowMessage("E267", "受注日");
error_occur = true;
goto BreakProcess;
}
}
if (dc.ColumnName == "SoukoCD")
{
DataTable souko_dt = new DataTable();
if (string.IsNullOrEmpty(soukoCD))
{
base_bl.ShowMessage("E102");
error_occur = true;
goto BreakProcess;
}
(error_occur, souko_dt) = Gridview_Error_Check("E101", soukoCD, "Souko", string.Empty);
if (error_occur)
{
goto BreakProcess;
}
}
j++;
BreakProcess : if (error_occur)
{
break;
}
}
}
if (error_occur)
{
return(error_occur, row_col);
}
}
return(error_occur, row_col);
}
public override void FunctionProcess(string tagID)
{
if (tagID == "6")
{
Modified_Panel();
}
if (tagID == "7")
{
if (rdoFreeInventory.Checked)
{
Excel_Export();
}
}
if (tagID == "8")
{
D_Exclusive_JuchuuNO_Delete();
Confirm_Data();
}
if (tagID == "10")
{
gvMainDetail.ActionType = "F10"; //to skip gv error check at the ErrorCheck() of BaseForm.cs
gvAggregationDetails.ActionType = "F10"; //to skip gv error check at the ErrorCheck() of BaseForm.cs
gvFreeInventoryDetails.ActionType = "F10"; //to skip gv error check at the ErrorCheck() of BaseForm.cs
if (ErrorCheck(PanelDetail))
{
Display_Data();
}
gvMainDetail.ActionType = string.Empty; //to check gv error at the ErrorCheck() of BaseForm.cs
gvAggregationDetails.ActionType = string.Empty; //to check gv error at the ErrorCheck() of BaseForm.cs
gvFreeInventoryDetails.ActionType = string.Empty; //to check gv error at the ErrorCheck() of BaseForm.cs
}
if (tagID == "11")
{
TemporarySave_Data();
}
if (tagID == "12")
{
if (F8_dt1 == null)
{
bbl.ShowMessage("E274");
}
else if (F8_dt1.Rows.Count < 1)
{
bbl.ShowMessage("E274");
}
else
{
DBData_IU();
txtBrand.Focus();
}
}
base.FunctionProcess(tagID);
}