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