private void SetAddress() { if (!string.IsNullOrWhiteSpace(txtZipCD1.Text) && !string.IsNullOrWhiteSpace(txtZipCD2.Text)) { mtsbl = new MasterTouroku_Souko_BL(); if (OperationMode == EOperationMode.UPDATE) { if (z1 != txtZipCD1.Text || z2 != txtZipCD2.Text) { mze = new M_ZipCode_Entity(); mze.ZipCD1 = txtZipCD1.Text; mze.ZipCD2 = txtZipCD2.Text; DataTable dt = mtsbl.M_ZipCode_AddressSelect(mze); if (dt.Rows.Count > 0) { TxtAddress1.Text = dt.Rows[0]["Address1"].ToString(); TxtAddress2.Text = dt.Rows[0]["Address2"].ToString(); } } z1 = txtZipCD1.Text; z2 = txtZipCD2.Text; } } }
public bool M_ZipCode_Select(M_ZipCode_Entity mze) { if (mzdl.M_ZipCode_Select(mze).Rows.Count > 0) { return(true); } return(false); }
private bool CheckZipCD(M_ZipCode_Entity mze) { if (!tprg_Kaiin_BL.M_ZipCode_Select(mze)) { tprg_Kaiin_BL.ShowMessage("E101"); txtZipCode1.Focus(); return(false); } return(true); }
public M_ZipCode_Entity GetZipCodeEntity() { ZipCode = new M_ZipCode_Entity { ZipCD1 = txtZip1from.Text, ZipCD2 = txtZip2From.Text, Operator = InOperatorCD, ProcessMode = ModeText, ProgramID = InProgramID, PC = InPcID, Key = txtZip1from.Text + "" + txtZip1To.Text + " " + txtZip2From.Text + "" + txtZip2To.Text }; return(ZipCode); }
private bool CheckDetail(int index, bool set = true) { if (detailControls[index].GetType().Equals(typeof(CKM_Controls.CKM_TextBox))) { if (((CKM_Controls.CKM_TextBox)detailControls[index]).isMaxLengthErr) { return(false); } } switch (index) { case (int)EIndex.ZipCD1: break; case (int)EIndex.ZipCD2: //郵便番号1または2に入力があった場合 if (!string.IsNullOrWhiteSpace(detailControls[index].Text) || !string.IsNullOrWhiteSpace(detailControls[index - 1].Text)) { //郵便番号変換マスター(M_ZipCode)に存在すること //[M_ZipCode] M_ZipCode_Entity mze = new M_ZipCode_Entity { ZipCD1 = detailControls[index - 1].Text, ZipCD2 = detailControls[index].Text }; ZipCode_BL mbl = new ZipCode_BL(); bool ret = mbl.M_ZipCode_SelectData(mze); if (ret) { if (set) { detailControls[index + 1].Text = mze.Address1; detailControls[index + 2].Text = mze.Address2; } } else { //E101 mbl.ShowMessage("E101"); return(false); } } break; } return(true); }
public bool M_ZipCode_SelectData(M_ZipCode_Entity mze) { DataTable dt = mzdl.M_ZipCode_Select(mze); if (dt.Rows.Count > 0) { mze.Address1 = dt.Rows[0]["Address1"].ToString(); mze.Address2 = dt.Rows[0]["Address2"].ToString(); return(true); } else { return(false); } }
private bool CheckZipCD(CKM_TextBox txt) { M_ZipCode_Entity mze = new M_ZipCode_Entity { ZipCD1 = (txt == txtZipCode1) ? txt.Text : string.Empty, ZipCD2 = (txt == txtZipCode2) ? txt.Text : string.Empty }; if (!tprg_Kaiin_BL.M_ZipCode_Select(mze)) { tprg_Kaiin_BL.ShowMessage("E101"); txt.Focus(); txt.MoveNext = false; return(false); } return(true); }
private void SetAddress() { if (!string.IsNullOrWhiteSpace(txtPostalCode.Text) && !string.IsNullOrWhiteSpace(txtPostalCode1.Text)) { mze = new M_ZipCode_Entity(); mze.ZipCD1 = txtPostalCode.Text; mze.ZipCD2 = txtPostalCode1.Text; DataTable dt = tprg_Kaiin_BL.M_ZipCode_AddressSelect(mze); if (dt.Rows.Count > 0) { txtAddress1.Text = dt.Rows[0]["Address1"].ToString(); txtAddress2.Text = dt.Rows[0]["Address2"].ToString(); } } }
//old[CheckZipCD] private bool CheckZipCD(CKM_TextBox txt) { M_ZipCode_Entity mze = new M_ZipCode_Entity { ZipCD1 = (txt == txtZipCD1) ? txt.Text : string.Empty, ZipCD2 = (txt == txtZipCD2) ? txt.Text : string.Empty }; mtsbl = new MasterTouroku_Souko_BL(); if (!mtsbl.M_ZipCode_Select(mze)) { mtsbl.ShowMessage("E101"); txt.Focus(); txt.MoveNext = false; return(false); } return(true); }
//RealUse[CheckZipCDEvent] private bool CheckZipCDEvent() { M_ZipCode_Entity mze = new M_ZipCode_Entity { ZipCD1 = txtZipCD1.Text, ZipCD2 = txtZipCD2.Text }; mtsbl = new MasterTouroku_Souko_BL(); if (!mtsbl.M_ZipCode_Select(mze)) { mtsbl.ShowMessage("E101"); txtZipCD2.Focus(); //txt.MoveNext = false; return(false); } return(true); }
public bool M_ZipCode_Update(M_ZipCode_Entity ZipCode, string Zip1To, string Zip2To, string Xml) { string sp = "M_ZipCode_Update"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@Zip1From", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.ZipCD1 } }, { "@Zip2From", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.ZipCD2 } }, { "@Zip1To", new ValuePair { value1 = SqlDbType.VarChar, value2 = Zip1To } }, { "@Zip2To", new ValuePair { value1 = SqlDbType.VarChar, value2 = Zip2To } }, { "@Xml", new ValuePair { value1 = SqlDbType.VarChar, value2 = Xml } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.Operator } }, { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.ProgramID } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.PC } }, { "@OperateMode", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.ProcessMode } }, { "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = ZipCode.Key } } }; UseTransaction = true; return(InsertUpdateDeleteData(dic, sp)); }
private void UpdateInsert() { //*** Insert Update Function ZipCode = GetZipCodeEntity(); string ZipCD1To = txtZip1To.Text; string ZipCD2To = txtZip2To.Text; if (dtDisplay.Rows.Count > 0) { int i = 0; foreach (DataRow dr in dtDisplay.Rows) { dr["CarrierCD"] = dgvYuubinBangou.Rows[i].Cells["colCarrier"].Value; i++; if (dr["ZipCD1"] == DBNull.Value) { dtDisplay.Rows.Remove(dr); } else if (dr["ZipCD1"] != DBNull.Value && dr["CarrierLeadDay"] == DBNull.Value) { dr["CarrierLeadDay"] = "0"; } } Xml = YuubinBangouBL.DataTableToXml(dtDisplay); if (YuubinBangouBL.M_ZipCode_Update(ZipCode, ZipCD1To, ZipCD2To, Xml)) { Clear(PanelHeader); Clear(PanelDetail); ChangeMode(OperationMode); txtZip1from.Focus(); YuubinBangouBL.ShowMessage("I101"); } else { YuubinBangouBL.ShowMessage("S001"); } } }
private bool DisplayData() { //*** Show Data ZipCode = new M_ZipCode_Entity { ZipCD1 = txtZip1from.Text, ZipCD2 = txtZip2From.Text, }; string ZipCD1To = txtZip1To.Text; string ZipCD2To = txtZip2To.Text; dtDisplay = YuubinBangouBL.M_ZipCode_YuubinBangou_Select(ZipCode, ZipCD1To, ZipCD2To); if (dtDisplay != null) { dgvYuubinBangou.DataSource = dtDisplay; int i = 0; foreach (DataRow dr in dtDisplay.Rows) { if (dr["CarrierCD"] != DBNull.Value) { dgvYuubinBangou.Rows[i].Cells["colCarrier"].Value = dr["CarrierCD"]; i++; } else { dgvYuubinBangou.Rows[i].Cells["colCarrier"].Value = string.Empty; i++; } } txtZip1from.Focus(); return(true); } else { YuubinBangouBL.ShowMessage("E133"); return(false); } }
public DataTable M_ZipCode_YuubinBangou_Select(M_ZipCode_Entity Zipcode, string Zip1To, string Zip2To) { string sp = "M_ZipCode_YuubinBangou_Select"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@Zip1From", new ValuePair { value1 = SqlDbType.VarChar, value2 = Zipcode.ZipCD1 } }, { "@Zip2From", new ValuePair { value1 = SqlDbType.VarChar, value2 = Zipcode.ZipCD2 } }, { "@Zip1To", new ValuePair { value1 = SqlDbType.VarChar, value2 = Zip1To } }, { "@Zip2To", new ValuePair { value1 = SqlDbType.VarChar, value2 = Zip2To } } }; return(SelectData(dic, sp)); }
public DataTable M_ZipCode_Select(M_ZipCode_Entity mze) { string sp = "M_ZipCode_Select"; //KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。 //command = new SqlCommand(sp, GetConnection()); //command.CommandType = CommandType.StoredProcedure; //command.CommandTimeout = 0; //command.Parameters.Add("@ZipCD1", SqlDbType.VarChar).Value = mze.ZipCD1; //command.Parameters.Add("@ZipCD2", SqlDbType.VarChar).Value = mze.ZipCD2; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ZipCD1", new ValuePair { value1 = SqlDbType.VarChar, value2 = mze.ZipCD1 } }, { "@ZipCD2", new ValuePair { value1 = SqlDbType.VarChar, value2 = mze.ZipCD2 } } }; //return SelectData(sp); return(SelectData(dic, sp)); }
private void btnZipCD_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtZipCode1.Text)) { tprg_Kaiin_BL.ShowMessage("E102"); txtZipCode1.Focus(); return; } if (string.IsNullOrEmpty(txtZipCode2.Text)) { tprg_Kaiin_BL.ShowMessage("E102"); txtZipCode2.Focus(); return; } mze = new M_ZipCode_Entity(); mze.ZipCD1 = txtZipCode1.Text; mze.ZipCD2 = txtZipCode2.Text; if (CheckZipCD(mze)) { SetAddress(); } }
public DataTable M_ZipCode_YuubinBangou_Select(M_ZipCode_Entity Zipcode, string Zip1To, string Zip2To) { return(ZipcodeDL.M_ZipCode_YuubinBangou_Select(Zipcode, Zip1To, Zip2To)); }
private bool ErrorCheck() { if (!RequireCheck(new Control[] { txtLastName, txtFirstName })) { return(false); } if (!Checkwidth(new Control[] { txtTelNo1, txtTelNo2, txtTelNo3, txthomeTelNo1, txthomeTelNo2, txthomeTelNo3, txtZipCode1, txtZipCode2 })) { return(false); } if (!string.IsNullOrWhiteSpace(txtTelNo1.Text) || !string.IsNullOrWhiteSpace(txtTelNo2.Text) || !string.IsNullOrWhiteSpace(txtTelNo3.Text) ) { if (!CompletePhoneNo(1)) { return(false); } } if (!string.IsNullOrWhiteSpace(txthomeTelNo1.Text) || !string.IsNullOrWhiteSpace(txthomeTelNo2.Text) || !string.IsNullOrWhiteSpace(txthomeTelNo3.Text) ) { if (!CompletePhoneNo(2)) { return(false); } } else { if (!CompletePhoneNo(1)) { return(false); } } if (txtMailAddress.Text != txtMailAddress2.Text) { tprg_Kaiin_BL.ShowMessage("E174"); txtMailAddress2.Focus(); return(false); } if (!RequireCheck(new Control[] { txtZipCode1, txtZipCode2, txtAddress1 })) { return(false); } mze = new M_ZipCode_Entity(); mze.ZipCD1 = txtZipCode1.Text; mze.ZipCD2 = txtZipCode2.Text; if (!tprg_Kaiin_BL.M_ZipCode_Select(mze)) { tprg_Kaiin_BL.ShowMessage("E101"); txtZipCode1.Focus(); return(false); } return(true); }
public DataTable M_ZipCode_AddressSelect(M_ZipCode_Entity mze) { return(mzdl.M_ZipCode_Select(mze)); }
public bool M_ZipCode_Update(M_ZipCode_Entity ZipCode, string Zip1To, string Zip2To, string Xml) { return(ZipcodeDL.M_ZipCode_Update(ZipCode, Zip1To, Zip2To, Xml)); }