public DataTable D_Exclusive_Lock_Check(JuchuuTorikomiEntity ce)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@Number", SqlDbType.VarChar)
{
Value = ce.Number
};
parameters[1] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = ce.OperatorCD
};
parameters[2] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = ce.ProgramID
};
parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = ce.PC
};
parameters[4] = new SqlParameter("@DataKBN", SqlDbType.Int)
{
Value = ce.DataKBN
};
DataTable dt = ckmdl.SelectDatatable("D_Exclusive_Lock_Check", GetConnectionString(), parameters);
return(dt);
}
public JuchuuTorikomi()
{
InitializeComponent();
cf = new CommonFunction();
bbl = new BaseBL();
JBL = new JuchuuTorikomiBL();
JEntity = new JuchuuTorikomiEntity();
dtMain = new DataTable();
}
public DataTable JuchuuTorikomi_Display(JuchuuTorikomiEntity entity)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@Datefrom", SqlDbType.VarChar)
{
Value = entity.DateFrom
};
parameters[1] = new SqlParameter("@Dateto", SqlDbType.VarChar)
{
Value = entity.DateTo
};
DataTable dt = ckmdl.SelectDatatable("JuchuuTorikomi_Display", GetConnectionString(), parameters);
return(dt);
}
private (string, string) GetFile()
{
JuchuuTorikomiEntity JEntity = new JuchuuTorikomiEntity();
string Xml_Hacchuu = string.Empty;
string Xml_Juchuu = string.Empty;
string error = string.Empty;
if (File.Exists(txtImportFolder.Text + txtImportFileName.Text)) //Task 453
{
DataTable create_dt = new DataTable();
Create_Datatable_Column(create_dt);
//openFileDialog.FileName = txtImportFolder.Text + txtImportFileName.Text; //Task 453
string[] csvRows = File.ReadAllLines(txtImportFolder.Text + txtImportFileName.Text, Encoding.GetEncoding(932));//Task 453 --repaired encoding 2021/05/29 ssa CHG TaskNO 469
var bl_List = new List <bool>();
for (int i = 1; i < csvRows.Length; i++)
{
error = "false";
var splits = csvRows[i].Split(',');
DataRow dr = create_dt.NewRow();
for (int j = 0; j < splits.Length; j++)
{
if (string.IsNullOrEmpty(splits[j]))
{
dr[j] = DBNull.Value;
}
else
{
dr[j] = splits[j].ToString();
}
}
dr[56] = base_Entity.OperatorCD;
dr[57] = base_Entity.ProgramID;
dr[58] = base_Entity.PC;
dr[59] = error;
create_dt.Rows.Add(dr);
}
create_dt.Columns.Add("JuchuuNO", typeof(string));
create_dt.Columns.Add("HacchuuNO", typeof(string));
for (int i = 0; i < create_dt.Rows.Count; i++)
{
TextBox txt = new TextBox();
txt.Text = create_dt.Rows[i]["JuchuuDate"].ToString();
string date = string.Empty;
if (cf.DateCheck(txt))
{
create_dt.Rows[i]["JuchuuDate"] = txt.Text;
date = create_dt.Rows[i]["JuchuuDate"].ToString();
}
if (!string.IsNullOrEmpty(date))
{
DataTable Dt_JuchuuNO = JBL.GetJuchuuNO("1", date, "0");
DataTable Dt_HacchuuNO = JBL.GetHacchuuNO("2", date, "0");
create_dt.Rows[i]["JuchuuNO"] = Dt_JuchuuNO.Rows[0]["Column1"];
create_dt.Rows[i]["HacchuuNO"] = Dt_HacchuuNO.Rows[0]["Column1"];
}
}
DataTable dt_Main = new DataTable();
if (create_dt.Rows.Count > 0)
{
dt_Main = create_dt.AsEnumerable()
.GroupBy(r => new { Col1 = r["JuchuuDate"], Col2 = r["TokuisakiCD"], Col3 = r["KouritenCD"], Col4 = r["SenpouHacchuuNO"], Col5 = r["SenpouBusho"], Col6 = r["KibouNouki"], Col7 = r["SoukoCD"] })
.Select(g => g.OrderBy(r => r["JuchuuDate"]).First())
.CopyToDataTable();
Remove_Datatable_Column(dt_Main);
Xml_Hacchuu = cf.DataTableToXml(dt_Main);
}
if (create_dt.Rows.Count > 0)
{
for (int r = 0; r < create_dt.Rows.Count; r++)
{
//NMW task NO. 592 begin
TextBox txt1 = new TextBox();
txt1.Text = create_dt.Rows[r]["JuchuuDate"].ToString();//column_1
if (cf.DateCheck(txt1))
{
create_dt.Rows[r]["JuchuuDate"] = string.IsNullOrEmpty(txt1.Text) ? null : txt1.Text;
}
string date1 = create_dt.Rows[r]["JuchuuDate"].ToString();//column_1
TextBox txt2 = new TextBox();
txt2.Text = create_dt.Rows[r]["KibouNouki"].ToString();//column_1
if (cf.DateCheck(txt2))
{
create_dt.Rows[r]["KibouNouki"] = string.IsNullOrEmpty(txt2.Text) ? null : txt2.Text;
}
string date2 = create_dt.Rows[r]["KibouNouki"].ToString();//column_2
TextBox txt3 = new TextBox();
txt3.Text = create_dt.Rows[r]["ChakuniYoteiDate"].ToString();//column_3
if (cf.DateCheck(txt3))
{
create_dt.Rows[r]["ChakuniYoteiDate"] = string.IsNullOrEmpty(txt3.Text) ? null : txt3.Text;
}
string date3 = create_dt.Rows[r]["ChakuniYoteiDate"].ToString();//column_3
//NMW task NO.592 end
int line_No = r + 1;
if (Date_Check(date1, line_No, "入力可能値外エラー", "項目:受注日") == "true")
{
return(null, null);
}
else if (Date_Check(date2, line_No, "入力可能値外エラー", "項目:希望納期") == "true")
{
return(null, null);
}
else if (Date_Check(date3, line_No, "入力可能値外エラー", "項目:着荷予定日") == "true")
{
return(null, null);
}
else if (r == create_dt.Rows.Count - 1)
{
Xml_Juchuu = cf.DataTableToXml(create_dt);
}
}
}
else
{
Xml_Hacchuu = string.Empty;
Xml_Juchuu = string.Empty;
}
}
else
{
bbl.ShowMessage("E281");
txtImportFolder.Focus();
}
return(Xml_Hacchuu, Xml_Juchuu);
}
public DataTable JuchuuTorikomi_Delete(string sp_name, string Xml, string DenpyouNO, JuchuuTorikomiEntity entity)
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@XML", SqlDbType.Xml)
{
Value = Xml
};
parameters[1] = new SqlParameter("@DenyouNO", SqlDbType.VarChar)
{
Value = DenpyouNO
};
parameters[2] = new SqlParameter("@ProgramID", SqlDbType.VarChar)
{
Value = entity.ProgramID
};
parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = entity.PC
};
parameters[4] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = entity.OperatorCD
};
return(ckmdl.SelectDatatable(sp_name, GetConnectionString(), parameters));
}
