private D_DepositHistory_Entity DepositHistoryEnity()
{
mre = new D_DepositHistory_Entity
{
DataKBN = "3",
DepositKBN = "4",
DepositKBN1 = "5",
CancelKBN = "0",
RecoredKBN = "0",
DenominationCD = "",
Rows = "0",
SalesSU = "0",
SalesUnitPrice = "0",
SalesGaku = "0",
SalesTax = "0",
TotalGaku = "0",
SalesTaxRate = "0",
Refund = "0",
ProperGaku = "0", //update
DiscountGaku = "0", //update
CustomerCD = "", //update
IsIssued = "0",
ExchangeMoney = ExchangeMoney.Text,
ExchangeDenomination = ExchangeDenomination.SelectedValue.ToString(),
ExchangeCount = ExchangeCount.Text.Replace(",", ""),
Remark = Remark.Text,
StoreCD = storeCD,
Operator = InOperatorCD,
ProcessMode = "登録",
ProgramID = InProgramID,
PC = InPcID,
Key = storeCD + " " + ExchangeMoney.Text
};
return(mre);
}
public frmTempoRegiTsurisenJyunbi()
{
Start_Display();
InitializeComponent();
dtDepositNO = new DataTable();
trtjb = new TempoRegiTsurisenJyunbi_BL();
mre = new D_DepositHistory_Entity();
}
public frmTempoRegiRyougaeNyuuryoku()
{
Start_Display();
InitializeComponent();
dtDepositNO = new DataTable();
trrnbl = new TempoRegiRyougaeNyuuryoku_BL();
mre = new D_DepositHistory_Entity();
}
public DataTable D_DepositHistory_SelectForSeisan(D_DepositHistory_Entity mre)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.StoreCD
} },
{ "@Date", new ValuePair {
value1 = SqlDbType.Date, value2 = mre.ChangeDate
} },
};
return(SelectData(dic, "D_DepositHistory_SelectForSeisan"));
}
public DataTable D_DepositＨistory_Gaku_Select(D_DepositHistory_Entity mre)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@DepositKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.DepositKBN
} },
{ "@DepositKBN1", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.DepositKBN1
} },
};
return(SelectData(dic, "D_DepositＨistory_Gaku_Select"));
}
///
/// <summary>
/// 登録ボタンを押下時データベースにInsertする
/// </summary>
public void Save()
{
if (ErrorCheck())
{
if (ExchangeLabel.Text != ExchangeMoney.Text)
{
trrnbl.ShowMessage("E181");
ExchangeCount.Focus();
}
else
{
if (trrnbl.ShowMessage("Q101") == DialogResult.Yes)
{
DataTable dt = new DataTable();
dt = trrnbl.SimpleSelect1("70", ChangeDate.Replace("/", "-"), storeCD);
if (dt.Rows.Count > 0)
{
trrnbl.ShowMessage("E252");
}
valid = false;
mre = DepositHistoryEnity();
if (trrnbl.TempoRegiRyougaeNyuuryoku_Insert_Update(mre))
{
trrnbl.ShowMessage("I101");
RunConsole();
//exeRun
ExchangeDenomination.SelectedValue = "-1";
ExchangeMoney.Clear();
ExchangeCount.Clear();
ExchangeLabel.Text = "";
Remark.Clear();
ExchangeMoney.Focus();
}
else
{
trrnbl.ShowMessage("S001");
}
}
else
{
PreviousCtrl.Focus();
//Remark.Focus();
}
}
}
}
private void Save()
{
if (ErrorCheck())
{
if (trntBL.ShowMessage("Q101") == DialogResult.Yes)
{
DataTable dt = new DataTable();
dt = trntBL.SimpleSelect1("70", ChangeDate.Replace("/", "-"), StoreCD);
if (dt.Rows.Count > 0)
{
trntBL.ShowMessage("E252");
}
ddpe = GetDepositEntity();
if (trntBL.TempoNyuukinTouroku_D_DepositHistory_InsertUpdate(ddpe))
{
if (!string.IsNullOrWhiteSpace(txtCustomerCD.Text))
{
dce = GetDCollectData();
trntBL.TempoNyuukinTouroku_D_Collect_Insert(dce);
}
trntBL.ShowMessage("I101");
RunConsole();
txtPayment.Clear();
txtPayment.Focus();
cboDenominationName.SelectedValue = "-1";
txtCustomerCD.Clear();
lblCustomerName.Text = string.Empty;
txtRemarks.Clear();
DisplayData();
chkAdvanceFlg.Enabled = chkAdvanceFlg.Checked = false;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
private D_DepositHistory_Entity DepositHistoryEnity()
{
mre = new D_DepositHistory_Entity
{
DataKBN = "3",
DepositKBN = "6",
CancelKBN = "0",
RecoredKBN = "0",
Rows = "0",
AdminNO = "",
//AccountingDate = System.DateTime.Now.ToShortDateString(),
AccountingDate = txtDate.Text,
SalesTaxRate = "0",
DepositGaku = DepositGaku.Text,
DenominationCD = "",
Remark = Remark.Text,
ExchangeMoney = "0",
ExchangeDenomination = "",
ExchangeCount = "0",
SalesSU = "0",
SalesUnitPrice = "0",
SalesGaku = "0",
SalesTax = "0",
TotalGaku = "0",
Refund = "0",
IsIssued = "0",
StoreCD = storeCD,
CustomerCD = "",
DiscountGaku = "0",
ProperGaku = "0",
Operator = InOperatorCD,
ProcessMode = "登録",
ProgramID = InProgramID,
PC = InPcID,
Key = storeCD + " " + DepositGaku.Text
};
return(mre);
}
private D_DepositHistory_Entity GetDepositEntity()
{
ddpe = new D_DepositHistory_Entity
{
StoreCD = InOperatorCD,
DenominationCD = cboDenominationName.SelectedValue.ToString(),
DataKBN = "3",
DepositKBN = "3",
DepositGaku = txtPayment.Text,
Remark = txtRemarks.Text,
ExchangeMoney = "0",
ExchangeDenomination = string.Empty,
ExchangeCount = "0",
AdminNO = string.Empty,
SalesSU = "0",
SalesUnitPrice = "0",
SalesGaku = "0",
SalesTax = "0",
TotalGaku = "0",
Refund = "0",
ProperGaku = "0",
DiscountGaku = "0",
CustomerCD = string.Empty,
IsIssued = "0",
CancelKBN = "0",
RecoredKBN = "0",
Rows = "0",
SalesTaxRate = "0",
AccountingDate = DateTime.Today.ToShortDateString(),
Operator = InOperatorCD,
ProgramID = InProgramID,
PC = InPcID,
ProcessMode = "登 録",
Key = txtPayment.Text.ToString()
};
return(ddpe);
}
/// <summary>
/// 登録ボタンを押下時データベースにInsertする
/// </summary>
public void Save()
{
if (ErrorCheck())
{
{
if (trtjb.ShowMessage("Q101") == DialogResult.Yes)
{
DataTable dt = new DataTable();
dt = trtjb.SimpleSelect1("70", ChangeDate.Replace("/", "-"), storeCD, txtDate.Text);
if (dt.Rows.Count > 0)
{
trtjb.ShowMessage("E252");
}
mre = DepositHistoryEnity();
if (trtjb.TempoRegiTsurisenJyunbi_Insert_Update(mre))
{
trtjb.ShowMessage("I101");
RunConsole();
txtDate.Clear();
DepositGaku.Clear();
Remark.Clear();
txtDate.Focus();
}
else
{
trtjb.ShowMessage("S001");
}
}
else
{
DepositGaku.Focus();
}
}
}
}
public bool TempoRegiShiNyuuryoku_InsertUpdate(D_DepositHistory_Entity ddpe)
{
return(ddhdl.D_DepositＨistory_Insert_Update(ddpe));
}
public bool D_DepositＨistory_Insert_Update(D_DepositHistory_Entity mre)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.StoreCD
} },
{ "@DenominationCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.DenominationCD
} },
{ "@DepositKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.DepositKBN
} },
{ "@DepositGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.DepositGaku
} },
{ "@Remark", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.Remark
} },
{ "@DataKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.DataKBN
} },
{ "@ExchangeMoney", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.ExchangeMoney
} },
{ "@ExchangeDenomination", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.ExchangeDenomination
} },
{ "@ExchangeCount", new ValuePair {
value1 = SqlDbType.Int, value2 = mre.ExchangeCount
} },
{ "@AdminNO", new ValuePair {
value1 = SqlDbType.Int, value2 = mre.AdminNO
} },
{ "@SalesSU", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.SalesSU
} },
{ "@SalesUnitPrice", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.SalesUnitPrice
} },
{ "@SalesGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.SalesGaku
} },
{ "@SalesTax", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.SalesTax
} },
{ "@TotalGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.TotalGaku
} },
{ "@Refund", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.Refund
} },
{ "@ProperGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.ProperGaku
} },
{ "@DiscountGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = mre.DiscountGaku
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.CustomerCD
} },
{ "@IsIssued", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.IsIssued
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.Operator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mre.StoreCD + " " + mre.Key
} },
{ "@CancelKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.CancelKBN
} },
{ "@RecordKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.RecoredKBN
} },
{ "@AccountingDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mre.AccountingDate
} },
{ "@Rows", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mre.Rows
} },
{ "@SalesTaxRate", new ValuePair {
value1 = SqlDbType.Int, value2 = mre.SalesTaxRate
} },
};
return(InsertUpdateDeleteData(dic, "D_DepositHistory_InsertUpdate"));
}
public bool TempoRegiTsurisenJyunbi_Insert_Update(D_DepositHistory_Entity mre)
{
return(trrndl.D_DepositＨistory_Insert_Update(mre));
}
public bool TempoNyuukinTouroku_D_DepositHistory_InsertUpdate(D_DepositHistory_Entity ddpe)
{
return(ddhdl.D_DepositＨistory_Insert_Update(ddpe));
}
public bool TempoRegiRyougaeNyuuryoku_Insert_Update(D_DepositHistory_Entity mre)
{
return(trrndl.TempoRegiRyougaeNyuuryoku_Insert(mre));
}