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
{
//Ｅ１０１
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));
}
