private SiiresakiEntity Get_UIData()
{
SiiresakiEntity ske = new SiiresakiEntity();
if (rdo_ChokkinDate.Checked)
{
ske.Output_Type = 0;
}
else
{
ske.Output_Type = 1;
}
ske.SiiresakiCD_From = txtSiiresakiCD_From.Text;
ske.SiiresakiCD_To = txtSiiresakiCD_To.Text;
ske.SiiresakiRyakuName = txtSiiresakiName.Text;
ske.YuubinNO1 = txtYuubinNO1.Text;
ske.YuubinNO2 = txtYubin2.Text;
ske.Juusho1 = txtAddress.Text;
ske.Tel11 = txtPhNO1.Text;
ske.Tel12 = txtPhNO2.Text;
ske.Tel13 = txtPhNO3.Text;
ske.Remarks = txtRemarks.Text;
ske.PC = PCID;
ske.ProgramID = ProgramID;
ske.InsertOperator = OperatorCD;
return(ske);
}
public DataTable Siiresaki_Search(SiiresakiEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@SiiresakiCD1", SqlDbType.VarChar)
{
Value = obj.SiiresakiCD
};
parameters[1] = new SqlParameter("@SiiresakiCD2", SqlDbType.VarChar)
{
Value = obj.SiiresakiRyakuName
};
parameters[2] = new SqlParameter("@SiiresakiName", SqlDbType.VarChar)
{
Value = obj.SiiresakiName
};
parameters[3] = new SqlParameter("@KanaName", SqlDbType.VarChar)
{
Value = obj.KanaName
};
parameters[4] = new SqlParameter("@RadioCheck", SqlDbType.VarChar)
{
Value = obj.Remarks
};
parameters[5] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
DataTable dt = ckmdl.SelectDatatable("Siiresaki_Search", GetConnectionString(), parameters);
return(dt);
}
private void DoDelete(SiiresakiEntity obj)
{
SiiresakiBL objMethod = new SiiresakiBL();
string return_BL = objMethod.M_Siiresaki_CUD(obj);
if (return_BL == "true")
{
bbl.ShowMessage("I102");
}
}
private SiiresakiEntity GetInsert()
{
SiiresakiEntity obj = new SiiresakiEntity();
obj.SiiresakiCD = txtSupplierCD.Text;
obj.ChangeDate = txtChangeDate.Text;
obj.ShokutiFLG = chk_Flag.Checked ? "1" : "0";
obj.SiiresakiName = txtSupplierName.Text;
obj.SiiresakiRyakuName = txtShort_Name.Text;
obj.KanaName = txtLong_Name.Text;
obj.SiharaisakiCD = txtPayCD.Text;
obj.YuubinNO1 = txtYubin1.Text;
obj.YuubinNO2 = txtYubin2.Text;
obj.Juusho1 = txtAddress1.Text;
obj.Juusho2 = txtAddress2.Text;
obj.Tel11 = txtPhone1_1.Text;
obj.Tel12 = txtPhone1_2.Text;
obj.Tel13 = txtPhone1_3.Text;
obj.Tel21 = txtPhone2_1.Text;
obj.Tel22 = txtPhone2_2.Text;
obj.Tel23 = txtPhone2_3.Text;
obj.TantouBusho = txtTantouBusho.Text;
obj.TantoushaName = txtTantoushaName.Text;
obj.TantouYakushoku = txtTantouYakushoku.Text;
obj.MailAddress = txtMail.Text;
obj.TuukaCD = txtCurrency.Text;
obj.StaffCD = txtStaffCD.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.ProgramID = base_Entity.ProgramID;
obj.KeyItem = txtSupplierCD.Text + " " + txtChangeDate.Text;
return(obj);
}
private void DataGridviewBind()
{
SiiresakiEntity obj = new SiiresakiEntity();
obj.SiiresakiCD = txtSupplier1.Text;
obj.ChangeDate = Date_Access_Siiresaki;
obj.SiiresakiRyakuName = txtSupplier2.Text;//using tempory for assign data
obj.SiiresakiName = txtSupplierName.Text;
obj.KanaName = txtKanaName.Text;
obj.Remarks = string.Empty;
if (rdo_Date.Checked)
{
obj.Remarks = "RevisionDate";
}
if (rdo_All.Checked)
{
obj.Remarks = "All";
}
SiiresakiBL objMethod = new SiiresakiBL();
DataTable dt = objMethod.Siiresaki_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"]);
//dt.Columns.Remove("CurrentDay");
}
else
{
ClearSession();
}
dt.Columns.Remove("CurrentDay");
}
else
{
if (dt.Rows.Count == 0)
{
ClearSession();
}
}
//dt.Columns.Remove("CurrentDay");
gvSupplier.DataSource = dt;
}
private void DBProcess()
{
SiiresakiEntity entity = GetInsert();
if (cboMode.SelectedValue.Equals("1"))
{
entity.Mode = "New";
DoInsert(entity);
}
else if (cboMode.SelectedValue.Equals("2"))
{
entity.Mode = "Update";
DoUpdate(entity);
}
else if (cboMode.SelectedValue.Equals("3"))
{
entity.Mode = "Delete";
DoDelete(entity);
}
}
private void Access_DB_Object(SiiresakiEntity obj)
{
txtCD.Text = obj.SiiresakiCD;
txtLong_Name.Text = obj.SiiresakiName;
txtShort_Name.Text = obj.SiiresakiRyakuName;
lbl_Name.Text = obj.SiiresakiRyakuName;
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 string ChooseFile()
{
var filePath = string.Empty;
SiiresakiEntity obj = new SiiresakiEntity();
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++)
{
var splits = csvRows[i].Split(',');
//obj.SiiresakiCD = splits[0];
////bl_List.Add(Null_Check(obj.SiiresakiCD,i, "仕入先CD未入力エラー"));
////bl_List.Add(Byte_Check(10, obj.SiiresakiCD,i, "仕入先CD桁数エラー"));
//if (Null_Check(obj.SiiresakiCD, i, "仕入先CD未入力エラー")) break;
//if (Byte_Check(10, obj.SiiresakiCD, 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 = string.IsNullOrEmpty(splits[2])? "" : splits[2];
//if(Null_Check(obj.ShokutiFLG,i, "諸口未入力エラー"))break;
//if (!(obj.ShokutiFLG == "0" || obj.ShokutiFLG == "1"))
//{
// bbl.ShowMessage("E276",i.ToString(), "入力可能値外エラー", "項目:諸口区分(0～1)");
// // bl_List.Add(true);
// break;
//}
////
//obj.SiiresakiName = splits[3];
//if (Null_Check(obj.SiiresakiName, i, "仕入先名未入力エラー")) break;
//if(Byte_Check(80, obj.SiiresakiName,i, "仕入先名桁数エラー"))break;
////
//obj.SiiresakiRyakuName = splits[4];
//if(Null_Check(obj.SiiresakiRyakuName,i, "略名未入力エラー"))break;
//if(Byte_Check(40, obj.SiiresakiRyakuName,i, "略名桁数エラー "))break;
////
//obj.KanaName = splits[5];
//if(Byte_Check(80, obj.KanaName,i, "カナ名桁数エラー"))break;
////no error check
//obj.KensakuHyouziJun = splits[6];
////
//obj.SiharaisakiCD = splits[7];
//if(Null_Check(obj.SiharaisakiCD,i, "支払先CD未入力エラー"))break;
//if(Byte_Check(10, obj.SiharaisakiCD,i, "支払先CD桁数エラー"))break;
////
//obj.YuubinNO1 = splits[8];
//if(Byte_Check(3, obj.YuubinNO1,i, "郵便番号１桁数エラー"))break;
////
//obj.YuubinNO2 = splits[9];
//if(Byte_Check(4, obj.YuubinNO2,i, "郵便番号２桁数エラー"))break;
////
//obj.Juusho1 = splits[10];
//if(Byte_Check(80, obj.Juusho1,i, "住所１桁数エラー"))break;
////
//obj.Juusho2 = splits[11];
//if(Byte_Check(80, obj.Juusho2,i, "住所２桁数エラー"))break;
////
//obj.Tel11 = splits[12];
//if(Byte_Check(6, obj.Tel11,i, "電話番号①-1桁数エラー"))break;
////
//obj.Tel12 = splits[13];
//if(Byte_Check(5, obj.Tel12,i, "電話番号①-2桁数エラー"))break;
////
//obj.Tel13 = splits[14];
//if(Byte_Check(5, obj.Tel13,i, "電話番号①-3桁数エラー"))break;
////
//obj.Tel21 = splits[15];
//if(Byte_Check(6, obj.Tel21,i, "電話番号②-1桁数エラー"))break;
////
//obj.Tel22 = splits[16];
//if(Byte_Check(5, obj.Tel22,i, "電話番号②-2桁数エラー"))break;
////
//obj.Tel23 = splits[17];
//if(Byte_Check(5, obj.Tel23,i, "電話番号②-3桁数エラー"))break;
////
//obj.TantouBusho = splits[18];
//if(Byte_Check(40, obj.TantouBusho,i, "担当部署桁数エラー"))break;
////
//obj.TantouYakushoku = splits[19];
//if(Byte_Check(40, obj.TantouYakushoku,i, "担当役職桁数エラー"))break;
////
//obj.TantoushaName = splits[20];
//if(Byte_Check(40, obj.TantoushaName,i, "担当者名桁数エラー"))break;
////
//obj.MailAddress = splits[21];
//if(Byte_Check(100, obj.MailAddress,i, "メールアドレス桁数エラー"))break;
////
//obj.TuukaCD = splits[22];
//if(Null_Check(obj.TuukaCD,i, "通貨CD未入力エラー"))break;
//if(Byte_Check(3, obj.TuukaCD,i, "通貨CD桁数エラー"))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.Remarks = splits[26];
//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 (rdo_Registragion.Checked == true)
//{
// DataTable dt1 = new DataTable();
// SiiresakiBL SBL = new SiiresakiBL();
// dt1 = SBL.Siiresaki_Select_Check(obj.SiiresakiCD, 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[27] = "0";
dr[28] = base_Entity.OperatorCD;
dr[29] = base_Entity.OperatorCD;
dr[30] = error;
create_dt.Rows.Add(dr);
}
//if(create_dt.Rows.Count==csvRows.Length-1)
// Xml = cf.DataTableToXml(create_dt);
//05_12_2021_[ssa]
if (create_dt.Rows.Count > 0)
{
for (int r = 0; r < create_dt.Rows.Count; r++)
{
//NMW Task NO. 529 begin
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
//NMW Task NO. 529 end
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);
}
}
}
}
else
{
Xml = string.Empty;
}
}
return(Xml);
}
public DataTable Get_ExportData(SiiresakiEntity entity)//add ssa
{
CKMDL ckmdl = new CKMDL();
entity.Sqlprms = new SqlParameter[14];
entity.Sqlprms[0] = new SqlParameter("@SiiresakiCD1", SqlDbType.VarChar)
{
Value = entity.SiiresakiCD_From
};
entity.Sqlprms[1] = new SqlParameter("@SiiresakiCD2", SqlDbType.VarChar)
{
Value = entity.SiiresakiCD_To
};
entity.Sqlprms[2] = new SqlParameter("@SiiresakiName", SqlDbType.VarChar)
{
Value = entity.SiiresakiRyakuName
};
entity.Sqlprms[3] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar)
{
Value = entity.YuubinNO1
};
entity.Sqlprms[4] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar)
{
Value = entity.YuubinNO2
};
entity.Sqlprms[5] = new SqlParameter("@Juusho", SqlDbType.VarChar)
{
Value = entity.Juusho1
};
entity.Sqlprms[6] = new SqlParameter("@Tel1", SqlDbType.VarChar)
{
Value = entity.Tel11
};
entity.Sqlprms[7] = new SqlParameter("@Tel2", SqlDbType.VarChar)
{
Value = entity.Tel12
};
entity.Sqlprms[8] = new SqlParameter("@Tel3", SqlDbType.VarChar)
{
Value = entity.Tel13
};
entity.Sqlprms[9] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = entity.Remarks
};
entity.Sqlprms[10] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = entity.ProgramID
};
entity.Sqlprms[11] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = entity.PC
};
entity.Sqlprms[12] = new SqlParameter("@InsertOperator", SqlDbType.VarChar)
{
Value = entity.InsertOperator
};
entity.Sqlprms[13] = new SqlParameter("@Output_Type", SqlDbType.VarChar)
{
Value = entity.Output_Type
};
return(ckmdl.SelectDatatable("Get_Siiresaki_ExportData", GetConnectionString(), entity.Sqlprms));
}
public string M_Siiresaki_CUD(SiiresakiEntity obj)
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
obj.Sqlprms = new SqlParameter[34];
obj.Sqlprms[0] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar)
{
Value = obj.SiiresakiCD
};
obj.Sqlprms[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
obj.Sqlprms[2] = new SqlParameter("@ShokutiFLG", SqlDbType.VarChar)
{
Value = obj.ShokutiFLG
};
obj.Sqlprms[3] = new SqlParameter("@SiiresakiName", SqlDbType.VarChar)
{
Value = obj.SiiresakiName
};
obj.Sqlprms[4] = new SqlParameter("@SiiresakiRyakuName", SqlDbType.VarChar)
{
Value = obj.SiiresakiRyakuName
};
obj.Sqlprms[5] = new SqlParameter("@KanaName", SqlDbType.VarChar)
{
Value = obj.KanaName
};
obj.Sqlprms[6] = new SqlParameter("@SiharaisakiCD", SqlDbType.VarChar)
{
Value = obj.SiharaisakiCD
};
obj.Sqlprms[7] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar)
{
Value = obj.YuubinNO1
};
obj.Sqlprms[8] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar)
{
Value = obj.YuubinNO2
};
obj.Sqlprms[9] = new SqlParameter("@Juusho1", SqlDbType.VarChar)
{
Value = obj.Juusho1
};
obj.Sqlprms[10] = new SqlParameter("@Juusho2", SqlDbType.VarChar)
{
Value = obj.Juusho2
};
obj.Sqlprms[11] = new SqlParameter("@Tel11", SqlDbType.VarChar)
{
Value = obj.Tel11
};
obj.Sqlprms[12] = new SqlParameter("@Tel12", SqlDbType.VarChar)
{
Value = obj.Tel12
};
obj.Sqlprms[13] = new SqlParameter("@Tel13", SqlDbType.VarChar)
{
Value = obj.Tel13
};
obj.Sqlprms[14] = new SqlParameter("@Tel21", SqlDbType.VarChar)
{
Value = obj.Tel21
};
obj.Sqlprms[15] = new SqlParameter("@Tel22", SqlDbType.VarChar)
{
Value = obj.Tel22
};
obj.Sqlprms[16] = new SqlParameter("@Tel23", SqlDbType.VarChar)
{
Value = obj.Tel23
};
obj.Sqlprms[17] = new SqlParameter("@TantouBusho", SqlDbType.VarChar)
{
Value = obj.TantouBusho
};
obj.Sqlprms[18] = new SqlParameter("@TantouYakushoku", SqlDbType.VarChar)
{
Value = obj.TantouYakushoku
};
obj.Sqlprms[19] = new SqlParameter("@TantoushaName", SqlDbType.VarChar)
{
Value = obj.TantoushaName
};
obj.Sqlprms[20] = new SqlParameter("@MailAddress", SqlDbType.VarChar)
{
Value = obj.MailAddress
};
obj.Sqlprms[21] = new SqlParameter("@TuukaCD", SqlDbType.VarChar)
{
Value = obj.TuukaCD
};
obj.Sqlprms[22] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = obj.StaffCD
};
obj.Sqlprms[23] = new SqlParameter("@TorihikiKaisiDate", SqlDbType.VarChar)
{
Value = obj.TorihikiKaisiDate
};
obj.Sqlprms[24] = new SqlParameter("@TorihikiShuuryouDate", SqlDbType.VarChar)
{
Value = obj.TorihikiShuuryouDate
};
obj.Sqlprms[25] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = obj.Remarks
};
obj.Sqlprms[26] = new SqlParameter("@KensakuHyouziJun", SqlDbType.VarChar)
{
Value = obj.KensakuHyouziJun
};
obj.Sqlprms[27] = new SqlParameter("@UsedFlg", SqlDbType.VarChar)
{
Value = obj.UsedFlg
};
obj.Sqlprms[28] = new SqlParameter("@InsertOperator", SqlDbType.VarChar)
{
Value = obj.InsertOperator
};
obj.Sqlprms[29] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar)
{
Value = obj.UpdateOperator
};
obj.Sqlprms[30] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = obj.Mode
};
obj.Sqlprms[31] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = obj.ProgramID
};
obj.Sqlprms[32] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = obj.PC
};
obj.Sqlprms[33] = new SqlParameter("@KeyItem", SqlDbType.VarChar)
{
Value = obj.KeyItem
};
return(ckmdl.InsertUpdateDeleteData("M_Siiresaki_CUD", GetConnectionString(), obj.Sqlprms));
}
