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, "郵便番号1桁数エラー"))break; //// //obj.YuubinNO2 = splits[9]; //if(Byte_Check(4, obj.YuubinNO2,i, "郵便番号2桁数エラー"))break; //// //obj.Juusho1 = splits[10]; //if(Byte_Check(80, obj.Juusho1,i, "住所1桁数エラー"))break; //// //obj.Juusho2 = splits[11]; //if(Byte_Check(80, obj.Juusho2,i, "住所2桁数エラー"))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)); }