public DataTable M_Customer_Display(M_Customer_Entity customer) //TempoRegiKaiiKensaku
{
string sp = "M_Customer_Display";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Telephone", new ValuePair {
value1 = SqlDbType.VarChar, value2 = customer.TelephoneNo1
} },
//{ "@Tel2", new ValuePair { value1 = SqlDbType.VarChar, value2 = customer.TelephoneNo2 } },
//{ "@Tel3",new ValuePair { value1=SqlDbType.VarChar,value2= customer.TelephoneNo3 } },
{ "@BirthDate", new ValuePair {
value1 = SqlDbType.Date, value2 = customer.Birthdate
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = customer.CustomerCD
} },
{ "@KanaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = customer.KanaName
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = customer.CustomerName
} },
{ "@MainStoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = customer.MainStoreCD
} }
};
return(SelectData(dic, sp));
}
private void Save()
{
if (ErrorCheck())
{
cust = new M_Customer_Entity();
cust.CustomerCD = txtCustomerNo.Text;
cust = tprg_Kaiin_Bl.M_Customer_Select(cust);
if (cust != null)
{
string storeKBN = cust.StoreKBN;
string deleteFlg = cust.DeleteFlg;
if (deleteFlg == "1")
{
bbl.ShowMessage("E119");
txtCustomerNo.Focus();
}
else if (storeKBN == "1")
{
bbl.ShowMessage("E235");
txtCustomerNo.Focus();
}
else
{
Frm_TempoRegiKaiinTouroku_CustomerDetail tprg_CustDetail = new Frm_TempoRegiKaiinTouroku_CustomerDetail(1, txtCustomerNo.Text);
tprg_CustDetail.ShowDialog();
}
}
else
{
Frm_TempoRegiKaiinTouroku_CustomerDetail tprg_CustDetail = new Frm_TempoRegiKaiinTouroku_CustomerDetail(0, txtCustomerNo.Text);
tprg_CustDetail.ShowDialog();
}
}
}
/// <summary>
/// 店舗請求書よりデータ抽出時に使用
/// </summary>
/// <param name="dbe"></param>
/// <returns></returns>
public DataTable D_Billing_SelectForPrint(D_Billing_Entity dbe, M_Customer_Entity mce)
{
string sp = "D_Billing_SelectForPrint";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@BillingCloseDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dbe.BillingCloseDate
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dbe.StoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.StaffCD
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dbe.BillingCustomerCD
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dbe.CustomerName
} },
{ "@PrintFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dbe.PrintFLG
} },
};
return(SelectData(dic, sp));
}
public M_Customer_Entity M_Customer_Select(M_Customer_Entity m_cust)
{
DataTable dtCustomer = tprg_Kaiin_DL.M_Customer_SelectAll(m_cust);
if (dtCustomer.Rows.Count > 0)
{
m_cust.DeleteFlg = dtCustomer.Rows[0]["DeleteFlg"].ToString();
m_cust.StoreKBN = dtCustomer.Rows[0]["StoreKBN"].ToString();
m_cust.CustomerCD = dtCustomer.Rows[0]["CustomerCD"].ToString();
m_cust.FirstName = dtCustomer.Rows[0]["FirstName"].ToString();
m_cust.LastName = dtCustomer.Rows[0]["LastName"].ToString();
m_cust.GroupName = dtCustomer.Rows[0]["GroupName"].ToString();
m_cust.KanaName = dtCustomer.Rows[0]["KanaName"].ToString();
m_cust.Sex = dtCustomer.Rows[0]["Sex"].ToString();
m_cust.Birthdate = dtCustomer.Rows[0]["BirthDate"].ToString();
m_cust.TelephoneNo1 = dtCustomer.Rows[0]["Tel11"].ToString();
m_cust.TelephoneNo2 = dtCustomer.Rows[0]["Tel12"].ToString();
m_cust.TelephoneNo3 = dtCustomer.Rows[0]["Tel13"].ToString();
m_cust.HomephoneNo1 = dtCustomer.Rows[0]["Tel21"].ToString();
m_cust.HomephoneNo2 = dtCustomer.Rows[0]["Tel22"].ToString();
m_cust.HomephoneNo3 = dtCustomer.Rows[0]["Tel23"].ToString();
m_cust.MailAddress = dtCustomer.Rows[0]["MailAddress"].ToString();
//m_cust.MailAddress2 = dtCustomer.Rows[0]["MailAddress2"].ToString();
m_cust.DMFlg = dtCustomer.Rows[0]["DMFlg"].ToString();
m_cust.DeleteFlg = dtCustomer.Rows[0]["DeleteFlg"].ToString();
m_cust.ZipCD1 = dtCustomer.Rows[0]["ZipCD1"].ToString();
m_cust.ZipCD2 = dtCustomer.Rows[0]["ZipCD2"].ToString();
m_cust.Address1 = dtCustomer.Rows[0]["Address1"].ToString();
m_cust.Address2 = dtCustomer.Rows[0]["Address2"].ToString();
return(m_cust);
}
return(null);
}
private void DisplayData()
{
cust.CustomerCD = lblCustomerNo.Text;
cust = tprg_Kaiin_BL.M_Customer_Select(cust);
if (cust != null)
{
txtAddress1.Text = cust.CustomerCD;
txtLastName.Text = cust.LastName;
txtFirstName.Text = cust.FirstName;
txtGroupName.Text = cust.GroupName;
txtKanaName.Text = cust.KanaName;
rdoMale.Checked = cust.Sex.Equals("1") ? true : false;
rdoFemale.Checked = cust.Sex.Equals("2") ? true : false;
txtBirthDate.Text = cust.Birthdate;
txtTelNo1.Text = cust.TelephoneNo1;
txtTelNo2.Text = cust.TelephoneNo2;
txtTelNo3.Text = cust.TelephoneNo3;
txthomeTelNo1.Text = cust.HomephoneNo1;
txthomeTelNo2.Text = cust.HomephoneNo2;
txthomeTelNo3.Text = cust.HomephoneNo3;
txtMailAddress.Text = cust.MailAddress;
txtMailAddress2.Text = cust.MailAddress;
txtZipCode1.Text = cust.ZipCD1;
txtZipCode2.Text = cust.ZipCD2;
txtAddress1.Text = cust.Address1;
txtAddress2.Text = cust.Address2;
chkDelete.Checked = cust.DeleteFlg.Equals("1") ? true : false;
chkSend.Checked = cust.DMFlg.Equals("1") ? true : false;
txtLastName.Focus();
}
}
/// <summary>
/// 入金予定表データ取得処理
/// </summary>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private DataTable CheckData()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i, false) == false)
{
detailControls[i].Focus();
return(null);
}
}
dse = GetSearchInfo();
M_Customer_Entity mce = new M_Customer_Entity
{
//StaffCD = ScStaff.TxtCode.Text
CustomerCD = ScCustomer.TxtCode.Text
};
DataTable dt = mibl.D_CollectPlan_SelectForPrint(dse, mce);
//以下の条件でデータが存在しなければエラー (Error if record does not exist)Ｅ１３３
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E133");
previousCtrl.Focus();
return(null);
}
return(dt);
}
private void Save()
{
if (ErrorCheck())
{
if (tprg_Kaiin_BL.ShowMessage("Q101") == DialogResult.Yes)
{
cust = new M_Customer_Entity();
cust = GetTempoRegiKaiinToroku();
if (chkDelete.Visible == false)
{
cust.ProcessMode = "新規";
InsertUpdate(1);
}
else if (chkDelete.Visible == true)
{
cust.ProcessMode = "変更";
InsertUpdate(2);
}
}
else
{
//PreviousCtrl = this.ActiveControl;
PreviousCtrl.Focus();
}
}
}
/// <summary>
/// お買上データ取得処理
/// </summary>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private DataTable CheckData(out DataTable dtForUpdate)
{
dtForUpdate = null;
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i, false) == false)
{
detailControls[i].Focus();
return(null);
}
}
dse = GetSearchInfo();
M_Customer_Entity mce = new M_Customer_Entity
{
StaffCD = ScStaff.TxtCode.Text
};
DataTable dt = mibl.D_Billing_SelectForPrint(dse, mce);
//以下の条件で請求データが存在しなければエラー (Error if record does not exist)Ｅ１３３
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E133");
previousCtrl.Focus();
return(null);
}
else
{
//明細にデータをセット
int i = 0;
dtForUpdate = new DataTable();
dtForUpdate.Columns.Add("no", Type.GetType("System.String"));
string oldBillingNO = "";
foreach (DataRow row in dt.Rows)
{
if (row["BillingNO"].ToString() != oldBillingNO)
{
bool ret = SelectAndInsertExclusive(row["BillingNO"].ToString());
if (!ret)
{
return(null);
}
i++;
// データを追加
DataRow rowForUpdate;
rowForUpdate = dtForUpdate.NewRow();
rowForUpdate["no"] = row["BillingNO"].ToString();
dtForUpdate.Rows.Add(rowForUpdate);
oldBillingNO = row["BillingNO"].ToString();
}
}
}
return(dt);
}
private void SetDataFromDataTable(int gyoNo = 1)
{
int index = gyoNo - 1;
DataRow row = dtJuchu.Rows[index];
txtJanCD.Text = row["JanCD"].ToString();
txtJanCD.Tag = index; //選択行の行番号を退避
lblSKUName.Text = row["SKUName"].ToString();
lblColorSize.Text = row["ColorSizeName"].ToString();
lblJuchuuSuu.Text = bbl.Z_SetStr(row["JuchuuSuu"]);
//lblSyukkaKanouSu.Text = bbl.Z_SetStr(row["SyukkaKanouSu"]);
if (bbl.Z_SetStr(row["DirectFLG"]).Equals(1))
{
lblSyukkaKanouSu.Text = bbl.Z_SetStr(bbl.Z_Set(row["JuchuuSuu"]) - bbl.Z_Set(row["DeliverySu"]));
}
else
{
lblSyukkaKanouSu.Text = bbl.Z_SetStr(bbl.Z_Set(row["HikiateSu"]) - bbl.Z_Set(row["DeliverySu"]));
}
txtShippingSu.Text = bbl.Z_SetStr(row["ShippingSu"]);
lblJuchuuUnitPrice.Text = "\\" + bbl.Z_SetStr(row["JuchuuUnitPrice"]);
lblJuchuuSuu.Text = "\\" + bbl.Z_SetStr(row["SalesGaku"]);
lblSalesTax.Text = "\\" + bbl.Z_SetStr(row["SalesTax"]);
lblJuchuuTaxRitsu.Text = bbl.Z_SetStr(row["JuchuuTaxRitsu"]) + "%";
lblSyohinChuijiko.Text = row["SyohinChuijiko"].ToString();
if (OperationMode == FrmMainForm.EOperationMode.DELETE)
{
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = lblCustomerNo.Text,
ChangeDate = row["SalesDate"].ToString()
};
Customer_BL sbl = new Customer_BL();
bool ret = sbl.M_Customer_Select(mce);
if (ret)
{
lblCusName.Text = mce.CustomerName;
}
else
{
lblCusName.Text = "";
}
if (row["BillingType"].ToString() == "1")
{
btnSeikyu.Text = "即請求";
}
else
{
btnSeikyu.Text = "締請求";
}
}
}
public DataTable M_Customer_SelectAll(M_Customer_Entity mke)
{
string sp = "M_Customer_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mke.CustomerCD
} }
};
return(SelectData(dic, sp));
}
private M_Customer_Entity GetTempoRegiKaiinToroku()
{
cust = new M_Customer_Entity()
{
CustomerCD = lblCustomerNo.Text,
StroeCD = StoreCD,
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
CustomerName = txtLastName.Text + txtFirstName.Text,
LongName1 = txtLastName.Text + txtFirstName.Text,
KanaName = txtKanaName.Text,
StoreKBN = "2",
CustomerKBN = "1",
AliasKBN = "1",
BillingType = "1",
GroupName = txtGroupName.Text,
BillingFLG = "1",
CollectFLG = "1",
BillingCD = lblCustomerNo.Text,
CollectCD = lblCustomerNo.Text,
Birthdate = txtBirthDate.Text,
Sex = rdoMale.Checked ? "1" : "2",
TelephoneNo1 = txtTelNo1.Text,
TelephoneNo2 = txtTelNo2.Text,
TelephoneNo3 = txtTelNo3.Text,
HomephoneNo1 = txthomeTelNo1.Text,
HomephoneNo2 = txthomeTelNo2.Text,
HomephoneNo3 = txthomeTelNo3.Text,
ZipCD1 = txtZipCode1.Text,
ZipCD2 = txtZipCode2.Text,
Address1 = txtAddress1.Text,
Address2 = txtAddress2.Text,
MailAddress = txtMailAddress.Text,
// MailAddress2=txtMailAddress2.Text,
TankaCD = "0000000000000",
PointFLG = "1",
MainStoreCD = StoreCD,
StaffCD = InOperatorCD,
BillingCloseDate = "31",
CollectPlanDate = "31",
TaxFractionKBN = "1",
AmountFractionKBN = "1",
PaymentUnit = "2",
DMFlg = chkSend.Checked? "1" : "0",
DeleteFlg = chkDelete.Checked? "1" : "0",
Operator = InOperatorCD,
ProgramID = InProgramID,
Key = StoreCD + " " + lblCustomerNo.Text,
PC = InPcID,
};
return(cust);
}
private void ShowDetail()
{
Customer = GetCustomer();
{
dt = new DataTable();
dt = trkkkBL.M_Customer_Display(Customer);
if (dt != null)
{
dgvKaniiKensaku.DataSource = dt;
//txtZipCD.Focus();
}
}
}
//search_customer
public DataTable M_Customer_Search(M_Customer_Entity mce)
{
string sp = "M_Customer_Search";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@RefDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mce.RefDate
} },
{ "@CustomerKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mce.CustomerKBN
} },
{ "@CustName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.CustomerName
} },
{ "@KanaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.KanaName
} },
{ "@BirthDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mce.Birthdate
} },
{ "@TelephoneNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.TelephoneNo
} },
{ "@StoreKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mce.StoreKBN
} },
{ "@keyword1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.Keyword1
} },
{ "@keyword2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.Keyword2
} },
{ "@keyword3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.Keyword3
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.MainStoreCD
} },
{ "@CustFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.CustomerFrom
} },
{ "@CustTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mce.CustomerTo
} }
//{"@KeyWordType",new ValuePair{value1=SqlDbType.TinyInt,value2=mce.KeyWordType} }
};
return(SelectData(dic, sp));
}
private M_Customer_Entity GetCustomer()
{
Customer = new M_Customer_Entity()
{
TelephoneNo1 = txtZipCD.Text,
Birthdate = txtDBO.Text,
CustomerCD = txtCustomerCD.Text,
KanaName = txtKanaName.Text,
CustomerName = txtCustomerName.Text
};
Customer.MainStoreCD = chkAnotherStore.Checked == true ? string.Empty : StoreCD;
return(Customer);
}
private bool ErrorCheck(int kbn = 0)
{
if (kbn == 1)
{
//txtCustomerNo
if (!RequireCheck(new Control[] { txtCustomerNo }))
{
return(false);
}
if (!CheckWidth(1))
{
return(false);
}
if (!CheckWidth(2))
{
return(false);
}
//得意先マスター(M_Customer)に存在すること
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = txtCustomerNo.Text,
ChangeDate = bbl.GetDate()
};
Customer_BL sbl = new Customer_BL();
bool ret = sbl.M_Customer_Select(mce);
if (ret)
{
lblCusName.Text = mce.CustomerName;
lblLastPoint.Text = bbl.Z_SetStr(mce.LastPoint);
}
else
{
lblCusName.Text = "";
}
//画面転送表01に従って、画面情報を表示
DispFromJuchu();
}
return(true);
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
D_Billing_Entity dbe = new D_Billing_Entity
{
StoreCD = CboStoreCD.SelectedValue.ToString(),
BillingCustomerCD = detailControls[(int)EIndex.CustomerCD].Text,
BillingCloseDate = detailControls[(int)EIndex.SeqSDT].Text,
};
M_Customer_Entity mce = new M_Customer_Entity
{
BillingCloseDate = detailControls[(int)EIndex.Simbi].Text
};
DataTable dt = ssbl.D_Billing_SelectAll(dbe, mce);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
lblSum.Text = bbl.Z_SetStr(dt.Rows[0]["SUM_BillingGaku"].ToString());
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
lblSum.Text = "";
ssbl.ShowMessage("E128");
}
}
private void F11()
{
if (ErrorCheck())
{
mce = GetDataInfo();
dtCustomer = new DataTable();
dtCustomer = scbl.M_Customer_Search(mce);
if (dtCustomer.Rows.Count > 0)
{
gv_CustomerSearch.DataSource = dtCustomer;
}
else
{
scbl.ShowMessage("E128");
gv_CustomerSearch.DataSource = null;
txtRefDate.Focus();
}
}
else
{
gv_CustomerSearch.DataSource = null;
}
}
private M_Customer_Entity GetDataInfo()
{
string[] strlist = txtKeyword.Text.Split(',');
M_Customer_Entity mce = new M_Customer_Entity()
{
CustomerKBN = lblStoreKBN.Text,
RefDate = txtRefDate.Text,
CustomerName = txtCustomerName.Text,
KanaName = txtKanaName.Text,
TelephoneNo = txtPhno.Text,
Birthdate = txtBirthDate.Text,
StoreKBN = CheckValue(),
MainStoreCD = cbo_Store.SelectedValue == null || cbo_Store.SelectedValue.Equals("-1")?"" : cbo_Store.SelectedValue.ToString(),
Keyword1 = (strlist.Length > 0) ? strlist[0].ToString() : "",
Keyword2 = (strlist.Length > 1) ? strlist[1].ToString() : "",
Keyword3 = (strlist.Length > 2) ? strlist[2].ToString() : "",
CustomerFrom = txtCustCDFrom.Text,
CustomerTo = txtCustCDTo.Text,
//KeyWordType = rdoOR.Checked ? "1" : "2"
};
return(mce);
}
/// <summary>
/// HEAD部のコードチェック
/// </summary>
/// <param name="index"></param>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private bool CheckDetail(int index, bool set = true)
{
bool ret;
switch (index)
{
case (int)EIndex.DayStart:
case (int)EIndex.DayEnd:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
detailControls[index].Text = mibl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!mibl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
mibl.ShowMessage("E103");
return(false);
}
//(From) ≧ (To)である場合Error
if (index == (int)EIndex.DayEnd)
{
if (!string.IsNullOrWhiteSpace(detailControls[index - 1].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
//Ｅ１０６
mibl.ShowMessage("E104");
detailControls[index].Focus();
return(false);
}
}
ScCustomer.ChangeDate = detailControls[index].Text;
}
break;
case (int)EIndex.StaffCD:
//入力無くても良い(It is not necessary to input)
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScStaff.LabelText = "";
return(true);
}
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Staff_BL bl = new Staff_BL();
ret = bl.M_Staff_Select(mse);
if (ret)
{
ScStaff.LabelText = mse.StaffName;
}
else
{
bbl.ShowMessage("E101");
ScStaff.LabelText = "";
return(false);
}
break;
case (int)EIndex.CustomerCD:
//入力無くても良い(It is not necessary to input)
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//顧客情報ALLクリア
ClearCustomerInfo();
return(true);
}
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Customer_BL sbl = new Customer_BL();
ret = sbl.M_Customer_Select(mce);
if (ret)
{
//ScCustomer.LabelText = mce.CustomerName;
if (mOldCustomerCD != detailControls[index].Text)
{
if (mce.VariousFLG == "1")
{
detailControls[index + 1].Text = mce.CustomerName;
detailControls[index + 1].Enabled = true;
}
else
{
ScCustomer.LabelText = mce.CustomerName;
// detailControls[index + 1].Text = mce.CustomerCD;
//// [M_Store_Select]
// M_Store_Entity me = new M_Store_Entity
// {
// StoreCD = mce.LastSalesStoreCD,
// ChangeDate = mce.LastSalesDate
// };
}
}
}
else
{
bbl.ShowMessage("E101");
//顧客情報ALLクリア
ClearCustomerInfo();
return(false);
}
mOldCustomerCD = detailControls[index].Text; //位置確認
break;
//case (int)EIndex.CustomerName:
// //入力可能の場合 入力必須(Entry required)
// if (detailControls[index].Enabled && string.IsNullOrWhiteSpace(detailControls[index].Text))
// {
// //Ｅ１０２
// bbl.ShowMessage("E102");
// return false;
// }
// break;
case (int)EIndex.StoreCD:
if (CboStoreCD.SelectedValue.Equals("-1"))
{
CboStoreCD.MoveNext = false;
bbl.ShowMessage("E102");
CboStoreCD.Focus();
return(false);
}
else
{
if (!base.CheckAvailableStores(CboStoreCD.SelectedValue.ToString()))
{
CboStoreCD.MoveNext = false;
bbl.ShowMessage("E141");
CboStoreCD.Focus();
return(false);
}
}
break;
}
return(true);
}
/// <summary>
/// コードチェック
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
private bool CheckDetail(int index)
{
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.MailDateSt:
case (int)EIndex.MailDateEd:
//必須入力(Entry required)、入力なければエラー(If there is no input, an error)Ｅ１０２
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//Ｅ１０２
bbl.ShowMessage("E102");
return(false);
}
detailControls[index].Text = mibl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!bbl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
bbl.ShowMessage("E103");
return(false);
}
//大小チェック
//(From) ≧ (To)である場合Error
if (index == (int)EIndex.MailDateEd)
{
if (!string.IsNullOrWhiteSpace(detailControls[(int)EIndex.MailDateSt].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[(int)EIndex.MailDateSt].Text);
if (result < 0)
{
bbl.ShowMessage("E104");
return(false);
}
}
}
break;
case (int)EIndex.MailTimeSt:
case (int)EIndex.MailTimeEd:
//入力無くても良い(It is not necessary to input)
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
detailControls[index].Text = FormatTime(detailControls[index].Text);
//時刻として正しい
if (!CheckTime(detailControls[index].Text))
{
//Ｅ２１５
bbl.ShowMessage("E215");
return(false);
}
//大小チェック
//(From) ≧ (To)である場合Error
if (index == (int)EIndex.MailTimeEd)
{
if (!string.IsNullOrWhiteSpace(detailControls[(int)EIndex.MailTimeSt].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
if (detailControls[(int)EIndex.MailDateSt].Text == detailControls[(int)EIndex.MailDateEd].Text)
{
int result = detailControls[index].Text.CompareTo(detailControls[(int)EIndex.MailTimeSt].Text);
if (result < 0)
{
bbl.ShowMessage("E104");
return(false);
}
}
}
}
break;
case (int)EIndex.Customer:
if (detailControls[index].Enabled)
{
//入力無くても良い(It is not necessary to input)
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
string ymd = mibl.GetDate();
if (ScCustomer.Stype == CKM_SearchControl.SearchType.得意先)
{
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = detailControls[index].Text,
ChangeDate = ymd
};
Customer_BL sbl = new Customer_BL();
bool ret = sbl.M_Customer_Select(mce, 1);
if (ret)
{
if (mce.DeleteFlg.Equals("1"))
{
}
ScCustomer.LabelText = mce.CustomerName;
}
}
else
{
//[M_Vendor_Select]
M_Vendor_Entity mve = new M_Vendor_Entity
{
VendorCD = detailControls[index].Text,
VendorFlg = "1",
ChangeDate = ymd
};
Vendor_BL sbl = new Vendor_BL();
bool ret = sbl.M_Vendor_SelectTop1(mve);
if (ret)
{
}
}
}
break;
}
return(true);
}
/// <summary>
/// HEAD部のコードチェック
/// </summary>
/// <param name="index"></param>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
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.DayStart:
case (int)EIndex.DayEnd:
case (int)EIndex.InputDateFrom:
case (int)EIndex.InputDateTo:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
detailControls[index].Text = bbl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!bbl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
bbl.ShowMessage("E103");
return(false);
}
//(From) ≧ (To)である場合Error
if (index == (int)EIndex.DayEnd || index == (int)EIndex.InputDateTo)
{
if (!string.IsNullOrWhiteSpace(detailControls[index - 1].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
bbl.ShowMessage("E104");
return(false);
}
}
}
break;
case (int)EIndex.StoreCD:
//選択必須(Entry required)
if (!RequireCheck(new Control[] { detailControls[index] }))
{
CboStoreCD.MoveNext = false;
return(false);
}
else
{
//店舗権限のチェック
if (!base.CheckAvailableStores(CboStoreCD.SelectedValue.ToString()))
{
CboStoreCD.MoveNext = false;
bbl.ShowMessage("E141");
CboStoreCD.Focus();
return(false);
}
//パラメータ 基準日：Form.日付,店舗：Form.店舗 ,得意先区分：3
ScCustomer.Value2 = CboStoreCD.SelectedValue.ToString();
}
break;
case (int)EIndex.CboSyubetsu:
//if (CboArrivalPlan.SelectedIndex == -1)
//{
// bbl.ShowMessage("E102");
// CboArrivalPlan.Focus();
// return false;
//}
//else
//{
//}
break;
case (int)EIndex.CustomerCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{ //顧客情報ALLクリア
ClearCustomerInfo();
return(true);
}
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Customer_BL sbl = new Customer_BL();
bool ret = sbl.M_Customer_Select(mce);
if (ret)
{
//if (mce.DeleteFlg == "1")
//{
// bbl.ShowMessage("E119");
// //顧客情報ALLクリア
// ClearCustomerInfo();
// return false;
//}
ScCustomer.LabelText = mce.CustomerName;
}
else
{
bbl.ShowMessage("E101");
ScCustomer.LabelText = "";
return(false);
}
break;
case (int)EIndex.Staff:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScStaff.LabelText = "";
return(true);
}
//[M_Staff_Select]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Staff_BL stbl = new Staff_BL();
ret = stbl.M_Staff_Select(mse);
if (ret)
{
ScStaff.LabelText = mse.StaffName;
}
else
{
bbl.ShowMessage("E101");
ScStaff.LabelText = "";
return(false);
}
break;
}
return(true);
}
public bool M_Customer_Insert_Update(M_Customer_Entity cust, int mode)
{
return(tprg_Kaiin_DL.M_Customer_Insert_Update(cust, mode));
}
/// <summary>
/// HEAD部のコードチェック
/// </summary>
/// <param name="index"></param>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private bool CheckDetail(int index, bool set = true)
{
bool ret;
switch (index)
{
case (int)EIndex.DayStart:
case (int)EIndex.DayEnd:
case (int)EIndex.SalesDateFrom:
case (int)EIndex.SalesDateTo:
case (int)EIndex.BillingDateFrom:
case (int)EIndex.BillingDateTo:
case (int)EIndex.CollectDateFrom:
case (int)EIndex.CollectDateTo:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
detailControls[index].Text = bbl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!bbl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
bbl.ShowMessage("E103");
return(false);
}
//見積日(From) ≧ 見積日(To)である場合Error
if (index == (int)EIndex.DayEnd || index == (int)EIndex.SalesDateTo || index == (int)EIndex.BillingDateTo || index == (int)EIndex.CollectDateTo)
{
if (!string.IsNullOrWhiteSpace(detailControls[index - 1].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
bbl.ShowMessage("E104");
detailControls[index].Focus();
return(false);
}
}
}
break;
case (int)EIndex.StoreCD:
//選択なくてもよい
if (CboStoreCD.SelectedIndex <= 0)
{
//bbl.ShowMessage("E102");
//CboStoreCD.Focus();
//return false;
return(true);
}
else
{
//店舗権限のチェック
if (!base.CheckAvailableStores(CboStoreCD.SelectedValue.ToString()))
{
CboStoreCD.MoveNext = false;
bbl.ShowMessage("E141");
CboStoreCD.Focus();
return(false);
}
}
break;
case (int)EIndex.CustomerCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScCustomer.LabelText = "";
return(true);
}
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Customer_BL sbl = new Customer_BL();
ret = sbl.M_Customer_Select(mce);
if (ret)
{
ScCustomer.LabelText = mce.CustomerName;
}
else
{
bbl.ShowMessage("E101");
ScCustomer.LabelText = "";
return(false);
}
break;
case (int)EIndex.VendorCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScVendor.LabelText = "";
return(true);
}
//[M_VendorCD_Select]
M_Vendor_Entity mve = new M_Vendor_Entity
{
VendorCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Vendor_BL vbl = new Vendor_BL();
ret = vbl.M_Vendor_SelectTop1(mve);
if (ret)
{
ScVendor.LabelText = mve.VendorName;
}
else
{
bbl.ShowMessage("E101");
ScVendor.LabelText = "";
return(false);
}
break;
case (int)EIndex.StaffCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScStaff.LabelText = "";
return(true);
}
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Staff_BL bl = new Staff_BL();
ret = bl.M_Staff_Select(mse);
if (ret)
{
ScStaff.LabelText = mse.StaffName;
}
else
{
bbl.ShowMessage("E101");
ScStaff.LabelText = "";
return(false);
}
break;
}
return(true);
}
public DataTable D_Billing_SelectAll(D_Billing_Entity dbe, M_Customer_Entity mce)
{
return(ddl.D_Billing_SelectAll(dbe, mce));
}
public bool M_Customer_Insert_Update(M_Customer_Entity cust, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.CustomerCD
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.StroeCD
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.CustomerName
} },
{ "@LastName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.LastName
} },
{ "@FirstName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.FirstName
} },
{ "@LongName1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.LongName1
} },
{ "@KanaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.KanaName
} },
{ "@StoreKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.StoreKBN
} },
{ "@CustomerKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.CustomerKBN
} },
{ "@AliasKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.AliasKBN
} },
{ "@BillingType", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.BillingType
} },
{ "@GroupName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.GroupName
} },
{ "@BillingFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.BillingFLG
} },
{ "@CollectFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.CollectFLG
} },
{ "@BillingCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.BillingCD
} },
{ "@CollectCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.CollectCD
} },
{ "@Birthdate", new ValuePair {
value1 = SqlDbType.Date, value2 = cust.Birthdate
} },
{ "@Sex", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.Sex
} },
{ "@Tel11", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.TelephoneNo1
} },
{ "@Tel12", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.TelephoneNo2
} },
{ "@Tel13", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.TelephoneNo3
} },
{ "@Tel21", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.HomephoneNo1
} },
{ "@Tel22", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.HomephoneNo2
} },
{ "@Tel23", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.HomephoneNo3
} },
{ "@ZipCD1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.ZipCD1
} },
{ "@ZipCD2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.ZipCD2
} },
{ "@Address1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.Address1
} },
{ "@Address2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.Address2
} },
{ "@MailAddress", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.MailAddress
} },
// {"@MailAddress2" , new ValuePair{value1=SqlDbType.VarChar,value2=cust.MailAddress2}},
{ "@TankaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.TankaCD
} },
{ "@PointFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.PointFLG
} },
{ "@MainStoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.MainStoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.StaffCD
} },
{ "@BillingCloseDate", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.BillingCloseDate
} },
{ "@CollectPlanDate", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.CollectPlanDate
} },
{ "@TaxFractionKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.TaxFractionKBN
} },
{ "@AmountFractionKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.AmountFractionKBN
} },
{ "@PaymentUnit", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.PaymentUnit
} },
{ "@DMFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.DMFlg
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cust.DeleteFlg
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.Operator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cust.Key
} },
{ "@Mode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mode.ToString()
} },
};
return(InsertUpdateDeleteData(dic, "M_Customer_Insert_Update"));
}
/// <summary>
/// 得意先マスタ更新処理
/// MasterTouroku_Tokuisakiより更新時に使用
/// </summary>
/// <param name="mbe"></param>
/// <param name="operationMode"></param>
/// <param name="operatorNm"></param>
/// <param name="pc"></param>
/// <returns></returns>
public bool M_Customer_Exec(M_Customer_Entity me, short operationMode)
{
string sp = "PRC_MasterTouroku_Tokuisaki";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = operationMode.ToString()
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.CustomerCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = me.ChangeDate
} },
{ "@VariousFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.VariousFLG
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.CustomerName
} },
{ "@LastName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.LastName
} },
{ "@FirstName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.FirstName
} },
{ "@LongName1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.LongName1
} },
{ "@LongName2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.LongName2
} },
{ "@KanaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.KanaName
} },
{ "@StoreKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.StoreKBN
} },
{ "@CustomerKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CustomerKBN
} },
{ "@StoreTankaKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.StoreTankaKBN
} },
{ "@AliasKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.AliasKBN
} },
{ "@BillingType", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.BillingType
} },
{ "@GroupName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.GroupName
} },
{ "@BillingFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.BillingFLG
} },
{ "@CollectFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CollectFLG
} },
{ "@BillingCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.BillingCD
} },
{ "@CollectCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.CollectCD
} },
{ "@Birthdate", new ValuePair {
value1 = SqlDbType.Date, value2 = me.Birthdate
} },
{ "@Sex", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.Sex
} },
{ "@Tel11", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Tel11
} },
{ "@Tel12", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Tel12
} },
{ "@Tel13", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Tel13
} },
{ "@Tel21", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Tel21
} },
{ "@Tel22", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Tel22
} },
{ "@Tel23", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Tel23
} },
{ "@ZipCD1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.ZipCD1
} },
{ "@ZipCD2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.ZipCD2
} },
{ "@Address1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Address1
} },
{ "@Address2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.Address2
} },
{ "@MailAddress", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.MailAddress
} },
{ "@TankaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.TankaCD
} },
{ "@PointFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.PointFLG
} },
{ "@LastPoint", new ValuePair {
value1 = SqlDbType.Money, value2 = me.LastPoint
} },
{ "@WaitingPoint", new ValuePair {
value1 = SqlDbType.Money, value2 = me.WaitingPoint
} },
{ "@TotalPoint", new ValuePair {
value1 = SqlDbType.Money, value2 = me.TotalPoint
} },
//{ "@TotalPurchase", new ValuePair { value1 = SqlDbType.Money , value2 = me.TotalPurchase } },
//{ "@UnpaidAmount", new ValuePair { value1 = SqlDbType.Money , value2 = me.UnpaidAmount } },
//{ "@UnpaidCount", new ValuePair { value1 = SqlDbType.Money , value2 = me.UnpaidCount } },
//{ "@LastSalesDate", new ValuePair { value1 = SqlDbType.Date, value2 = me.LastSalesDate} },
//{ "@LastSalesStoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = me.LastSalesStoreCD} },
{ "@MainStoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.MainStoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.StaffCD
} },
{ "@AttentionFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.AttentionFLG
} },
{ "@ConfirmFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.ConfirmFLG
} },
{ "@ConfirmComment", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.ConfirmComment
} },
{ "@BillingCloseDate", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.BillingCloseDate
} },
{ "@CollectPlanMonth", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CollectPlanMonth
} },
{ "@CollectPlanDate", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CollectPlanDate
} },
{ "@HolidayKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.HolidayKBN
} },
{ "@TaxTiming", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.TaxTiming
} },
{ "@TaxPrintKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.TaxPrintKBN
} },
{ "@TaxFractionKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.TaxFractionKBN
} },
{ "@AmountFractionKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.AmountFractionKBN
} },
{ "@CreditLevel", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CreditLevel
} },
{ "@CreditCard", new ValuePair {
value1 = SqlDbType.Money, value2 = me.CreditCard
} },
{ "@CreditInsurance", new ValuePair {
value1 = SqlDbType.Money, value2 = me.CreditInsurance
} },
{ "@CreditDeposit", new ValuePair {
value1 = SqlDbType.Money, value2 = me.CreditDeposit
} },
{ "@CreditETC", new ValuePair {
value1 = SqlDbType.Money, value2 = me.CreditETC
} },
{ "@CreditAmount", new ValuePair {
value1 = SqlDbType.Money, value2 = me.CreditAmount
} },
//{ "@CreditWarningAmount", new ValuePair { value1 = SqlDbType.Money , value2 = me.CreditWarningAmount } },
{ "@CreditAdditionAmount", new ValuePair {
value1 = SqlDbType.Money, value2 = me.CreditAdditionAmount
} },
{ "@CreditCheckKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CreditCheckKBN
} },
{ "@CreditMessage", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.CreditMessage
} },
{ "@FareLevel", new ValuePair {
value1 = SqlDbType.Money, value2 = me.FareLevel
} },
{ "@Fare", new ValuePair {
value1 = SqlDbType.Money, value2 = me.Fare
} },
{ "@PaymentMethodCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.PaymentMethodCD
} },
{ "@KouzaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.KouzaCD
} },
{ "@DisplayOrder", new ValuePair {
value1 = SqlDbType.Int, value2 = me.DisplayOrder
} },
{ "@PaymentUnit", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.PaymentUnit
} },
{ "@NoInvoiceFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.NoInvoiceFlg
} },
{ "@CountryKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.CountryKBN
} },
{ "@CountryName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.CountryName
} },
{ "@RegisteredNumber", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.RegisteredNumber
} },
{ "@DMFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.DMFlg
} },
{ "@RemarksOutStore", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.RemarksOutStore
} },
{ "@RemarksInStore", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.RemarksInStore
} },
{ "@AnalyzeCD1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.AnalyzeCD1
} },
{ "@AnalyzeCD2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.AnalyzeCD2
} },
{ "@AnalyzeCD3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.AnalyzeCD3
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.DeleteFlg
} },
{ "@UsedFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.UsedFlg
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.InsertOperator
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.PC
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, sp));
}
/// <summary>
/// 得意先データ取得処理
/// </summary>
/// <param name="mce"></param>
/// <param name="kbn">CustomerKBN 1:店舗会員、2:店舗現金会員、3:団体法人</param>
/// <returns></returns>
public bool M_Customer_Select(M_Customer_Entity mce, short kbn = 0)
{
DataTable dt = mmdl.M_Customer_Select(mce);
if (kbn > 0)
{
DataRow[] rows = dt.Select("CustomerKBN <>" + kbn.ToString());
foreach (DataRow row in rows)
{
dt.Rows.Remove(row);
}
}
if (dt.Rows.Count > 0)
{
mce.ChangeDate = dt.Rows[0]["ChangeDate"].ToString();
mce.VariousFLG = dt.Rows[0]["VariousFLG"].ToString();
mce.CustomerName = dt.Rows[0]["CustomerName"].ToString();
mce.LastName = dt.Rows[0]["LastName"].ToString();
mce.FirstName = dt.Rows[0]["FirstName"].ToString();
mce.LongName1 = dt.Rows[0]["LongName1"].ToString();
mce.LongName2 = dt.Rows[0]["LongName2"].ToString();
mce.KanaName = dt.Rows[0]["KanaName"].ToString();
mce.StoreKBN = dt.Rows[0]["StoreKBN"].ToString();
mce.CustomerKBN = dt.Rows[0]["CustomerKBN"].ToString();
mce.StoreTankaKBN = dt.Rows[0]["StoreTankaKBN"].ToString();
mce.AliasKBN = dt.Rows[0]["AliasKBN"].ToString();
mce.BillingType = dt.Rows[0]["BillingType"].ToString();
mce.GroupName = dt.Rows[0]["GroupName"].ToString();
mce.BillingFLG = dt.Rows[0]["BillingFLG"].ToString();
mce.CollectFLG = dt.Rows[0]["CollectFLG"].ToString();
mce.BillingCD = dt.Rows[0]["BillingCD"].ToString();
mce.CollectCD = dt.Rows[0]["CollectCD"].ToString();
mce.Birthdate = dt.Rows[0]["Birthdate"].ToString();
mce.Sex = dt.Rows[0]["Sex"].ToString();
mce.Tel11 = dt.Rows[0]["Tel11"].ToString();
mce.Tel12 = dt.Rows[0]["Tel12"].ToString();
mce.Tel13 = dt.Rows[0]["Tel13"].ToString();
mce.Tel21 = dt.Rows[0]["Tel21"].ToString();
mce.Tel22 = dt.Rows[0]["Tel22"].ToString();
mce.Tel23 = dt.Rows[0]["Tel23"].ToString();
mce.ZipCD1 = dt.Rows[0]["ZipCD1"].ToString();
mce.ZipCD2 = dt.Rows[0]["ZipCD2"].ToString();
mce.Address1 = dt.Rows[0]["Address1"].ToString();
mce.Address2 = dt.Rows[0]["Address2"].ToString();
mce.MailAddress = dt.Rows[0]["MailAddress"].ToString();
mce.TankaCD = dt.Rows[0]["TankaCD"].ToString();
mce.PointFLG = dt.Rows[0]["PointFLG"].ToString();
mce.LastPoint = dt.Rows[0]["LastPoint"].ToString();
mce.WaitingPoint = dt.Rows[0]["WaitingPoint"].ToString();
mce.TotalPoint = dt.Rows[0]["TotalPoint"].ToString();
mce.TotalPurchase = dt.Rows[0]["TotalPurchase"].ToString();
mce.UnpaidAmount = dt.Rows[0]["UnpaidAmount"].ToString();
mce.UnpaidCount = dt.Rows[0]["UnpaidCount"].ToString();
mce.LastSalesDate = dt.Rows[0]["LastSalesDate"].ToString();
mce.LastSalesStoreCD = dt.Rows[0]["LastSalesStoreCD"].ToString();
mce.MainStoreCD = dt.Rows[0]["MainStoreCD"].ToString();
mce.StaffCD = dt.Rows[0]["StaffCD"].ToString();
mce.AttentionFLG = dt.Rows[0]["AttentionFLG"].ToString();
mce.ConfirmFLG = dt.Rows[0]["ConfirmFLG"].ToString();
mce.ConfirmComment = dt.Rows[0]["ConfirmComment"].ToString();
mce.BillingCloseDate = dt.Rows[0]["BillingCloseDate"].ToString();
mce.CollectPlanMonth = dt.Rows[0]["CollectPlanMonth"].ToString();
mce.CollectPlanDate = dt.Rows[0]["CollectPlanDate"].ToString();
mce.HolidayKBN = dt.Rows[0]["HolidayKBN"].ToString();
mce.TaxTiming = dt.Rows[0]["TaxTiming"].ToString();
mce.TaxFractionKBN = dt.Rows[0]["TaxFractionKBN"].ToString();
mce.AmountFractionKBN = dt.Rows[0]["AmountFractionKBN"].ToString();
mce.CreditLevel = dt.Rows[0]["CreditLevel"].ToString();
mce.CreditCard = dt.Rows[0]["CreditCard"].ToString();
mce.CreditInsurance = dt.Rows[0]["CreditInsurance"].ToString();
mce.CreditDeposit = dt.Rows[0]["CreditDeposit"].ToString();
mce.CreditETC = dt.Rows[0]["CreditETC"].ToString();
mce.CreditAmount = dt.Rows[0]["CreditAmount"].ToString();
// mce.CreditWarningAmount = dt.Rows[0]["CreditWarningAmount"].ToString();
mce.CreditAdditionAmount = dt.Rows[0]["CreditAdditionAmount"].ToString();
mce.CreditCheckKBN = dt.Rows[0]["CreditCheckKBN"].ToString();
mce.CreditMessage = dt.Rows[0]["CreditMessage"].ToString();
mce.FareLevel = dt.Rows[0]["FareLevel"].ToString();
mce.Fare = dt.Rows[0]["Fare"].ToString();
mce.PaymentMethodCD = dt.Rows[0]["PaymentMethodCD"].ToString();
mce.KouzaCD = dt.Rows[0]["KouzaCD"].ToString();
mce.DisplayOrder = dt.Rows[0]["DisplayOrder"].ToString();
mce.PaymentUnit = dt.Rows[0]["PaymentUnit"].ToString();
mce.NoInvoiceFlg = dt.Rows[0]["NoInvoiceFlg"].ToString();
mce.CountryKBN = dt.Rows[0]["CountryKBN"].ToString();
mce.CountryName = dt.Rows[0]["CountryName"].ToString();
mce.RegisteredNumber = dt.Rows[0]["RegisteredNumber"].ToString();
mce.DMFlg = dt.Rows[0]["DMFlg"].ToString();
mce.RemarksOutStore = dt.Rows[0]["RemarksOutStore"].ToString();
mce.RemarksInStore = dt.Rows[0]["RemarksInStore"].ToString();
mce.AnalyzeCD1 = dt.Rows[0]["AnalyzeCD1"].ToString();
mce.AnalyzeCD2 = dt.Rows[0]["AnalyzeCD2"].ToString();
mce.AnalyzeCD3 = dt.Rows[0]["AnalyzeCD3"].ToString();
mce.DeleteFlg = dt.Rows[0]["DeleteFlg"].ToString();
mce.UsedFlg = dt.Rows[0]["UsedFlg"].ToString();
mce.InsertOperator = dt.Rows[0]["InsertOperator"].ToString();
mce.InsertDateTime = dt.Rows[0]["InsertDateTime"].ToString();
mce.UpdateOperator = dt.Rows[0]["UpdateOperator"].ToString();
mce.UpdateDateTime = dt.Rows[0]["UpdateDateTime"].ToString();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// HEAD部のコードチェック
/// </summary>
/// <param name="index"></param>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private bool CheckDetail(int index, bool set = true)
{
bool ret;
switch (index)
{
case (int)EIndex.Syori:
//選択必須(Entry required)
if (!RequireCheck(new Control[] { detailControls[index] }))
{
cboSyori.MoveNext = false;
return(false);
}
break;
case (int)EIndex.SeqSDT:
//必須入力(Entry required)、入力なければエラー(If there is no input, an error)Ｅ１０２
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//Ｅ１０２
bbl.ShowMessage("E102");
return(false);
}
detailControls[index].Text = ssbl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!ssbl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
ssbl.ShowMessage("E103");
return(false);
}
//入力できる範囲内の日付であること
if (!bbl.CheckInputPossibleDate(detailControls[index].Text))
{
//Ｅ１１５
bbl.ShowMessage("E115");
return(false);
}
ScCustomer.ChangeDate = detailControls[index].Text;
break;
case (int)EIndex.Simbi:
//必須入力(Entry required)、入力なければエラー(If there is no input, an error)Ｅ１０２
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//Ｅ１０２
bbl.ShowMessage("E102");
return(false);
}
//１～３１以外はエラー
int simebi = Convert.ToInt32(detailControls[index].Text);
if (simebi < 1 || simebi > 31)
{
//Ｅ１０３
bbl.ShowMessage("E103");
return(false);
}
break;
case (int)EIndex.CustomerCD:
//入力無くても良い(It is not necessary to input)
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//顧客情報ALLクリア
ClearCustomerInfo();
return(true);
}
string ymd = detailControls[(int)EIndex.SeqSDT].Text;
if (string.IsNullOrWhiteSpace(ymd))
{
ymd = bbl.GetDate();
}
//[M_Customer_Select]
M_Customer_Entity mce = new M_Customer_Entity
{
CustomerCD = detailControls[index].Text,
ChangeDate = ymd
};
Customer_BL sbl = new Customer_BL();
ret = sbl.M_Customer_Select(mce);
if (ret)
{
if (mOldCustomerCD != detailControls[index].Text)
{
ScCustomer.LabelText = mce.CustomerName;
if (mce.VariousFLG == "1")
{
//detailControls[index + 1].Text = mce.CustomerName;
// detailControls[index + 1].Enabled = true;
}
else
{
//detailControls[index + 1].Text = mce.CustomerName;
}
}
}
else
{
bbl.ShowMessage("E101");
//顧客情報ALLクリア
ClearCustomerInfo();
return(false);
}
mOldCustomerCD = detailControls[index].Text; //位置確認
break;
//case (int)EIndex.CustomerName:
// //入力可能の場合 入力必須(Entry required)
// if (detailControls[index].Enabled && string.IsNullOrWhiteSpace(detailControls[index].Text))
// {
// //Ｅ１０２
// bbl.ShowMessage("E102");
// return false;
// }
// break;
case (int)EIndex.StoreCD:
//選択必須(Entry required)
if (!RequireCheck(new Control[] { detailControls[index] }))
{
CboStoreCD.MoveNext = false;
return(false);
}
else
{
if (!base.CheckAvailableStores(CboStoreCD.SelectedValue.ToString()))
{
CboStoreCD.MoveNext = false;
bbl.ShowMessage("E141");
CboStoreCD.Focus();
return(false);
}
ExecDisp();
}
break;
}
return(true);
}
public DataTable D_Billing_SelectForPrint(D_Billing_Entity dbe, M_Customer_Entity mce)
{
return(mdl.D_Billing_SelectForPrint(dbe, mce));
}
public DataTable M_Customer_Search(M_Customer_Entity mce)
{
return(mcdl.M_Customer_Search(mce));
}
