private TokuisakiEntity GetInsert()
{
TokuisakiEntity obj = new TokuisakiEntity();
obj.TokuisakiCD = txt_Tokuisaki.Text;
obj.ChangeDate = txtChange_Date.Text;
obj.ShokutiFLG = chk.Checked ? 1 : 0;
if (RadSaMa.Checked == true)
{
obj.AliasKBN = 1;
}
else if (RadOnchuu.Checked == true)
{
obj.AliasKBN = 2;
}
if (RadNeed.Checked == true)
{
obj.ShukkaSizishoHuyouKBN = 0;
}
else if (RadNoNeed.Checked == true)
{
obj.ShukkaSizishoHuyouKBN = 1;
}
obj.TokuisakiName = txtTokuisakiName.Text;
obj.TokuisakiRyakuName = txtShortName.Text;
obj.KanaName = txtKanaName.Text;
obj.SeikyuusakiCD = txtBillAddress.Text;
obj.YuubinNO1 = txtYubin1.Text;
obj.YuubinNO2 = txtYubin2.Text;
obj.Juusho1 = txtAddress1.Text;
obj.Juusho2 = txtAddress2.Text;
obj.Tel11 = txtPhNo1.Text;
obj.Tel12 = txtPhNo2.Text;
obj.Tel13 = txtPhNo3.Text;
obj.Tel21 = txtPhNo4.Text;
obj.Tel22 = txtPhNo5.Text;
obj.Tel23 = txtPhNo6.Text;
obj.TantouBusho = txtDepCharge.Text;
obj.TantouYakushoku = txtJobTitle.Text;
obj.TantoushaName = txtPersonCharge.Text;
obj.MailAddress = txtMailAddress.Text;
obj.StaffCD = txtStaffCharge.Text;
obj.TorihikiKaisiDate = txtStartDate.Text;
obj.TorihikiShuuryouDate = txtEndDate.Text;
obj.Remarks = txtRemark.Text;
int int_val = 0;
int.TryParse(txtSearch.Text, NumberStyles.Any, CultureInfo.CurrentCulture, out int_val);
obj.KensakuHyouziJun = int_val.ToString();
obj.UsedFlg = 0;
obj.InsertOperator = base_Entity.OperatorCD;
obj.UpdateOperator = base_Entity.OperatorCD;
//for log table
obj.PC = base_Entity.PC;
obj.KeyItem = txt_Tokuisaki.Text + " " + txtChange_Date.Text;
return(obj);
}
private void DoDelete(TokuisakiEntity tokuisakiEntity)
{
TokuisakiBL bl = new TokuisakiBL();
string return_Bl = bl.M_Tokuisaki_CUD(tokuisakiEntity);
if (return_Bl == "true")
{
bbl.ShowMessage("I101");
}
}
private void DataGridviewBind()
{
TokuisakiEntity obj = new TokuisakiEntity();
obj.TokuisakiCD = txtTokuisaki1.Text;
obj.ChangeDate = Date_Access_Tokuisaki;
obj.TokuisakiRyakuName = txtTokuisaki2.Text;//using tempory for assign data
obj.TokuisakiName = txtTokuisakiName.Text;
obj.KanaName = txtKanaName.Text;
obj.Remarks = string.Empty;
if (rdo_Date.Checked)
{
obj.Remarks = "RevisionDate";
}
if (rdo_All.Checked)
{
obj.Remarks = "All";
}
TokuisakiBL tBL = new TokuisakiBL();
DataTable dt = tBL.Tokuisaki_Search(obj);
if (dt.Columns.Contains("CurrentDay"))
{
if (dt.Rows.Count > 0)
{
lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);
}
else
{
ClearSession(); //HET
}
dt.Columns.Remove("CurrentDay");
}
else
{
if (dt.Rows.Count == 0) //HET
{
ClearSession();
}
}
gvTokuisaki.DataSource = dt;
}
private void DBProcess()
{
TokuisakiEntity tokuisaki = GetInsert();
if (cboMode.SelectedValue.Equals("1"))
{
tokuisaki.Mode = "New";
DoInsert(tokuisaki);
}
else if (cboMode.SelectedValue.Equals("2"))
{
tokuisaki.Mode = "Update";
DoUpdate(tokuisaki);
}
else if (cboMode.SelectedValue.Equals("3"))
{
tokuisaki.Mode = "Delete";
DoDelete(tokuisaki);
}
}
private void Access_DB_Object(TokuisakiEntity obj)
{
txtTokuisakiCD.Text = obj.TokuisakiCD;
txtLong_Name.Text = obj.TokuisakiName;
txtShort_Name.Text = obj.TokuisakiRyakuName;
lblTokuisaki_Name.Text = obj.TokuisakiRyakuName;
txtYubin1.Text = obj.YuubinNO1;
txtYubin2.Text = obj.YuubinNO2;
txtAddress1.Text = obj.Juusho1;
txtAddress2.Text = obj.Juusho2;
txtPhone1_1.Text = obj.Tel11;
txtPhone1_2.Text = obj.Tel12;
txtPhone1_3.Text = obj.Tel13;
txtPhone2_1.Text = obj.Tel21;
txtPhone2_2.Text = obj.Tel22;
txtPhone2_3.Text = obj.Tel23;
YuuBinNO1 = txtYubin1.Text;
YuuBinNO2 = txtYubin2.Text;
Address1 = txtAddress1.Text;
Address2 = txtAddress2.Text;
}
private TokuisakiEntity Get_UIData()
{
TokuisakiEntity entity = new TokuisakiEntity();
if (rdo_RRevisionDate.Checked)
{
entity.Output_Type = 0;
}
else
{
entity.Output_Type = 1;
}
entity.TokuisakiCD = txtTokuisakiCD.Text;
entity.TokuisakiCD1 = txtTokuisakiCD1.Text;
entity.TokuisakiName = txtTokuisakiName.Text;
entity.YuubinNO1 = txtYuubinNO1.Text;
entity.YuubinNO2 = txtYuubinNO2.Text;
entity.Juusho1 = txtJuusho.Text;
entity.Tel11 = txtPhNO1.Text;
entity.Tel12 = txtPhNO2.Text;
entity.Tel13 = txtPhNO3.Text;
entity.Remarks = txtRemarks.Text;
return(entity);
}
private string ChooseFile()
{
var filePath = string.Empty;
TokuisakiEntity obj = new TokuisakiEntity();
string Xml = string.Empty;
string error = string.Empty;
var bl_List = new List <bool>();
using (OpenFileDialog openFileDialog = new OpenFileDialog())
{
openFileDialog.InitialDirectory = "C:\\CSV Folder\\";
openFileDialog.Title = "Browse CSV Files";
openFileDialog.Filter = "csv files (*.csv)|*.csv";
openFileDialog.FilterIndex = 2;
openFileDialog.RestoreDirectory = true;
DataTable create_dt = new DataTable();
Create_Datatable_Column(create_dt);
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
filePath = openFileDialog.FileName;
string[] csvRows = File.ReadAllLines(filePath, Encoding.GetEncoding(932));
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["UsedFlg"] = "0";
dr["InsertOperator"] = base_Entity.OperatorCD;
dr["UpdateOperator"] = base_Entity.OperatorCD;
dr["Error"] = error;
create_dt.Rows.Add(dr);
//05_12_2021[ssa]
if (create_dt.Rows.Count > 0)
{
for (int r = 0; r < create_dt.Rows.Count; r++)
{
//Task NO begin 592 NMW
TextBox txt1 = new TextBox();
txt1.Text = create_dt.Rows[r]["ChangeDate"].ToString();//column_1
if (cf.DateCheck(txt1))
{
create_dt.Rows[r]["ChangeDate"] = string.IsNullOrEmpty(txt1.Text) ? null : txt1.Text;
}
string date1 = create_dt.Rows[r]["ChangeDate"].ToString();//column_1
TextBox txt2 = new TextBox();
txt2.Text = create_dt.Rows[r]["TorihikiKaisiDate"].ToString();//column_2
if (cf.DateCheck(txt2))
{
create_dt.Rows[r]["TorihikiKaisiDate"] = string.IsNullOrEmpty(txt2.Text) ? null : txt2.Text;
}
string date2 = create_dt.Rows[r]["TorihikiKaisiDate"].ToString();//column_2
TextBox txt3 = new TextBox();
txt3.Text = create_dt.Rows[r]["TorihikiShuuryouDate"].ToString();//column_3
if (cf.DateCheck(txt3))
{
create_dt.Rows[r]["TorihikiShuuryouDate"] = string.IsNullOrEmpty(txt3.Text) ? null : txt3.Text;
}
string date3 = create_dt.Rows[r]["TorihikiShuuryouDate"].ToString();//column_3
//TaskNo 592 end NMW
int line_No = r + 1;
if (Date_Check(date1, line_No, "入力可能値外エラー", "項目:改定日") == "true")
{
return(null);
}
else if (Date_Check(date2, line_No, "入力可能値外エラー", "項目:取引開始日") == "true")
{
return(null);
}
else if (Date_Check(date3, line_No, "入力可能値外エラー", "項目:取引終了日") == "true")
{
return(null);
}
else if (r == create_dt.Rows.Count - 1)
{
Xml = cf.DataTableToXml(create_dt);
}
}
}
//obj.TokuisakiCD = splits[0];
//if (Null_Check(obj.TokuisakiCD, i, "得意先CD未入力エラー")) break;
//if (Byte_Check(10, obj.TokuisakiCD, i, "得意先CD桁数エラー")) break;
////
//obj.ChangeDate = splits[1];
//if (Null_Check(obj.ChangeDate, i, "改定日未入力エラー")) break;
//if (Date_Check(obj.ChangeDate, i, "入力可能値外エラー", "改定日") == "true") break;
//else splits[1] = Date_Check(obj.ChangeDate, i, "入力可能値外エラー", "改定日");
////
//obj.ShokutiFLG = Convert.ToInt32(splits[2]);
//if (!(obj.ShokutiFLG == 0 || obj.ShokutiFLG == 1))
//{
// bbl.ShowMessage("E276", i.ToString(), "入力可能値外エラー", "項目:諸口区分(0～1)");
// //bl_List.Add(true);
// break;
//}
//if (Null_Check(obj.ShokutiFLG.ToString(), i, "諸口未入力エラー")) break;
////
//obj.TokuisakiName = splits[3];
//if (Null_Check(obj.TokuisakiName, i, "得意先名未入力エラー")) break;
//if (Byte_Check(80, obj.TokuisakiName, i, "得意先名桁数エラー")) break;
////
//obj.TokuisakiRyakuName = splits[4];
//if (Null_Check(obj.TokuisakiRyakuName, i, "略名未入力エラー")) break;
//if (Byte_Check(40, obj.TokuisakiRyakuName, i, "略名桁数エラー")) break;
////
//obj.KanaName = splits[5];
//if (Byte_Check(80, obj.KanaName, i, "カナ名桁数エラー")) break;
////no error check
//obj.KensakuHyouziJun = splits[6];
//obj.SeikyuusakiCD = splits[7];
//if (Null_Check(obj.SeikyuusakiCD, i, "請求先CD未入力エラー")) break;
//if (Byte_Check(10, obj.SeikyuusakiCD, i, "請求先CD桁数エラー")) break;
////
//obj.AliasKBN = Convert.ToInt32(splits[8]);
//if (!(obj.AliasKBN == 1 || obj.AliasKBN == 2))
//{
// bbl.ShowMessage("E276", i.ToString(), "入力可能値外エラー", "項目:敬称(1～2)");
// //bl_List.Add(true);
// break;
//}
//if (Null_Check(obj.AliasKBN.ToString(), i, "敬称未入力エラー")) break;
////
//obj.YuubinNO1 = splits[9];
//if (Byte_Check(3, obj.YuubinNO1, i, "郵便番号１桁数エラー")) break;
////
//obj.YuubinNO2 = splits[10];
//if (Byte_Check(4, obj.YuubinNO2, i, "郵便番号２桁数エラー")) break;
////
//obj.Juusho1 = splits[11];
//if (Byte_Check(80, obj.Juusho1, i, "住所１桁数エラー")) break;
////
//obj.Juusho2 = splits[12];
//if (Byte_Check(80, obj.Juusho2, i, "住所２桁数エラー")) break;
////
//obj.Tel11 = splits[13];
//if (Byte_Check(6, obj.Tel11, i, "電話番号①-1桁数エラー")) break;
////
//obj.Tel12 = splits[14];
//if (Byte_Check(5, obj.Tel12, i, "電話番号①-2桁数エラー")) break;
////
//obj.Tel13 = splits[15];
//if (Byte_Check(5, obj.Tel13, i, "電話番号①-3桁数エラー")) break;
////
//obj.Tel21 = splits[16];
//if (Byte_Check(6, obj.Tel21, i, "電話番号②-1桁数エラー")) break;
////
//obj.Tel22 = splits[17];
//if (Byte_Check(5, obj.Tel22, i, "電話番号②-2桁数エラー")) break;
////
//obj.Tel23 = splits[18];
//if (Byte_Check(5, obj.Tel23, i, "電話番号②-3桁数エラー")) break;
////
//obj.TantouBusho = splits[19];
//if (Byte_Check(40, obj.TantouBusho, i, "担当部署桁数エラー")) break;
////
//obj.TantouYakushoku = splits[20];
//if (Byte_Check(40, obj.TantouYakushoku, i, "担当役職桁数エラー")) break;
////
//obj.TantoushaName = splits[21];
//if (Byte_Check(40, obj.TantoushaName, i, "担当者名桁数エラー")) break;
////
//obj.MailAddress = splits[22];
//if (Byte_Check(100, obj.MailAddress, i, "メールアドレス桁数エラー")) break;
////
//obj.StaffCD = splits[23];
//if (Null_Check(obj.StaffCD, i, "担当スタッフCD未入力エラー")) break;
//if (Byte_Check(10, obj.StaffCD, i, "担当スタッフCD桁数エラー")) break;
////
//obj.TorihikiKaisiDate = splits[24];
//if (!string.IsNullOrEmpty(obj.TorihikiKaisiDate))
//{
// if (Date_Check(obj.TorihikiKaisiDate, i, "入力可能値外エラー", "取引開始日") == "true") break;
// else splits[24] = Date_Check(obj.TorihikiKaisiDate, i, "入力可能値外エラー", "取引開始日");
//}
////
//obj.TorihikiShuuryouDate = splits[25];
//if (!string.IsNullOrEmpty(obj.TorihikiShuuryouDate))
//{
// if (Date_Check(obj.TorihikiShuuryouDate, i, "入力可能値外エラー", "取引終了日") == "true") break;
// else splits[25] = Date_Check(obj.TorihikiShuuryouDate, i, "入力可能値外エラー", "取引終了日");
//}
////
//obj.ShukkaSizishoHuyouKBN = Convert.ToInt32(splits[26]);
//if (!(obj.ShukkaSizishoHuyouKBN == 0 || obj.ShukkaSizishoHuyouKBN == 1))
//{
// bbl.ShowMessage("E276", i.ToString(), "入力可能値外エラー", "出荷指示書不要区分(0～1)");
// //bl_List.Add(true);
// break;
//}
//if (Null_Check(obj.ShukkaSizishoHuyouKBN.ToString(), i, "出荷指示書不要区分未入力エラー")) break;
////
//obj.Remarks = splits[27];
//if (Byte_Check(80, obj.Remarks, i, "備考桁数エラー")) break;
////
//DataTable dt = new DataTable();
//StaffBL sBL = new StaffBL();
//dt = sBL.Staff_Select_Check(obj.StaffCD, obj.ChangeDate, "E101");
//if (dt.Rows[0]["MessageID"].ToString() == "E101")
//{
// bbl.ShowMessage("E276", i.ToString(), "担当スタッフCD未登録エラー");
// //bl_List.Add(true);
// break;
//}
//if (sRadRegister.Checked == true)
//{
// DataTable dt1 = new DataTable();
// TokuisakiBL TBL = new TokuisakiBL();
// dt1 = TBL.M_Tokuisaki_Select(obj.TokuisakiCD, obj.ChangeDate, "E132");
// if (dt1.Rows[0]["MessageID"].ToString() == "E132")
// {
// bbl.ShowMessage("E276", i.ToString(), "得意先CD登録済エラー");
// //bl_List.Add(true);
// break;
// }
//}
//if (bl_List.Contains(true))
// error = "true";
//else error = "false";
//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[28] = "0";
//dr[29] = base_Entity.OperatorCD;
//dr[30] = base_Entity.OperatorCD;
//dr[31] = error;
//create_dt.Rows.Add(dr);
}
//if (create_dt.Rows.Count == csvRows.Length - 1)
//Xml = cf.DataTableToXml(create_dt);
}
else
{
Xml = string.Empty;
}
}
return(Xml);
}
