public DataTable D_StorePayment_Select(D_StorePayment_Entity dse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.StoreCD
} },
{ "@SalesNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.SalesNO
} },
};
return(SelectData(dic, "D_StorePayment_Select"));
}
public TempoRegiSiharaiTouroku(Base.Client.FrmMainForm.EOperationMode mode, D_Sales_Entity dse1, D_StorePayment_Entity dspe1, EPSON_TM30.CashDrawerOpen cdo, string Up, string Lp)
{
this.Up = Up;
this.Lp = Lp;
this.cdo = cdo;
InitializeComponent();
ckmShop_Label7.Visible = false;
lblZan.Visible = false;
ShowCloseMessage = false;
OperationMode = mode;
dse = dse1;
dspe = dspe1;
}
public bool D_StorePayment_Select(D_StorePayment_Entity dse)
{
D_StorePayment_DL dl = new D_StorePayment_DL();
DataTable dt = dl.D_StorePayment_Select(dse);
if (dt.Rows.Count > 0)
{
dse.PurchaseAmount = dt.Rows[0]["PurchaseAmount"].ToString();
dse.TaxAmount = dt.Rows[0]["TaxAmount"].ToString();
dse.DiscountAmount = dt.Rows[0]["DiscountAmount"].ToString();
dse.BillingAmount = dt.Rows[0]["BillingAmount"].ToString();
dse.PointAmount = dt.Rows[0]["PointAmount"].ToString();
dse.CardDenominationName = dt.Rows[0]["CardDenominationName"].ToString();
dse.CardDenominationCD = dt.Rows[0]["CardDenominationCD"].ToString();
dse.CardAmount = dt.Rows[0]["CardAmount"].ToString();
dse.CashAmount = dt.Rows[0]["CashAmount"].ToString();
dse.DepositAmount = dt.Rows[0]["DepositAmount"].ToString();
dse.RefundAmount = dt.Rows[0]["RefundAmount"].ToString();
dse.CreditAmount = dt.Rows[0]["CreditAmount"].ToString();
dse.DenominationName1 = dt.Rows[0]["DenominationName1"].ToString();
dse.Denomination1CD = dt.Rows[0]["Denomination1CD"].ToString();
dse.Denomination1Amount = dt.Rows[0]["Denomination1Amount"].ToString();
dse.DenominationName2 = dt.Rows[0]["DenominationName2"].ToString();
dse.Denomination2CD = dt.Rows[0]["Denomination2CD"].ToString();
dse.Denomination2Amount = dt.Rows[0]["Denomination2Amount"].ToString();
dse.AdvanceAmount = dt.Rows[0]["AdvanceAmount"].ToString();
dse.TotalAmount = dt.Rows[0]["TotalAmount"].ToString();
dse.SalesRate = dt.Rows[0]["SalesRate"].ToString();
return(true);
}
else
{
return(false);
}
}
public bool PRC_TempoRegiHanbaiTouroku(D_Sales_Entity dse, D_StorePayment_Entity dspe, DataTable dt, short operationMode)
{
TempoRegiHanbaiTouroku_DL dl = new TempoRegiHanbaiTouroku_DL();
return(dl.PRC_TempoRegiHanbaiTouroku(dse, dspe, dt, operationMode));
}
/// <summary>
/// 店舗レジ出荷売上入力更新処理
/// TempoRegiHanbaiTourokuより更新時に使用
/// </summary>
/// <param name="dse"></param>
/// <param name="operationMode"></param>
/// <returns></returns>
public bool PRC_TempoRegiHanbaiTouroku(D_Sales_Entity dse, D_StorePayment_Entity dspe, DataTable dt, short operationMode)
{
string sp = "PRC_TempoRegiHanbaiTouroku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@SalesNO", SqlDbType.VarChar, dse.SalesNO);
AddParam(command, "@JuchuuNO", SqlDbType.VarChar, dse.JuchuuNO);
AddParam(command, "@StoreCD", SqlDbType.VarChar, dse.StoreCD);
AddParam(command, "@CustomerCD", SqlDbType.VarChar, dse.CustomerCD);
AddParam(command, "@Age", SqlDbType.TinyInt, dse.Age);
AddParam(command, "@CustomerChangeDate", SqlDbType.VarChar, dse.ChangeDate);
AddParam(command, "@SalesRate", SqlDbType.Int, dspe.SalesRate);
AddParam(command, "@AdvanceAmount", SqlDbType.Money, dspe.AdvanceAmount);
AddParam(command, "@PointAmount", SqlDbType.Money, dspe.PointAmount);
AddParam(command, "@CashAmount", SqlDbType.Money, dspe.CashAmount);
AddParam(command, "@RefundAmount", SqlDbType.Money, dspe.RefundAmount);
AddParam(command, "@DenominationCD", SqlDbType.VarChar, dspe.CardDenominationCD);
AddParam(command, "@CardAmount", SqlDbType.Money, dspe.CardAmount);
AddParam(command, "@Discount", SqlDbType.Money, dspe.DiscountAmount);
AddParam(command, "@CreditAmount", SqlDbType.Money, dspe.CreditAmount);
AddParam(command, "@Denomination1Amount", SqlDbType.Money, dspe.Denomination1Amount);
AddParam(command, "@DenominationCD1", SqlDbType.VarChar, dspe.Denomination1CD);
AddParam(command, "@Denomination2Amount", SqlDbType.Money, dspe.Denomination2Amount);
AddParam(command, "@DenominationCD2", SqlDbType.VarChar, dspe.Denomination2CD);
AddParam(command, "@DepositAmount", SqlDbType.Money, dspe.DepositAmount);
AddParam(command, "@Keijobi", SqlDbType.VarChar, dse.SalesDate);
AddParam(command, "@SalesGaku", SqlDbType.Money, dse.SalesGaku);
AddParam(command, "@SalesTax", SqlDbType.Money, dse.SalesTax);
AddParam(command, "@SalesHontaiGaku0", SqlDbType.Money, dse.SalesHontaiGaku0);
AddParam(command, "@SalesHontaiGaku8", SqlDbType.Money, dse.SalesHontaiGaku8);
AddParam(command, "@SalesHontaiGaku10", SqlDbType.Money, dse.SalesHontaiGaku10);
AddParam(command, "@HanbaiTax10", SqlDbType.Money, dse.SalesTax10);
AddParam(command, "@HanbaiTax8", SqlDbType.Money, dse.SalesTax8);
AddParam(command, "@InvoiceGaku", SqlDbType.Money, dspe.BillingAmount);
AddParam(command, "@Discount8", SqlDbType.Money, dse.Discount8);
AddParam(command, "@Discount10", SqlDbType.Money, dse.Discount10);
AddParam(command, "@DiscountTax", SqlDbType.Money, dse.DiscountTax);
AddParam(command, "@DiscountTax8", SqlDbType.Money, dse.DiscountTax8);
AddParam(command, "@DiscountTax10", SqlDbType.Money, dse.DiscountTax10);
AddParam(command, "@TotalAmount", SqlDbType.Money, dspe.TotalAmount);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, dse.Operator);
AddParam(command, "@PC", SqlDbType.VarChar, dse.PC);
//OUTパラメータの追加
string outPutParam = "@OutSalesNO";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
dse.SalesNO = outPutParam;
}
return(ret);
}
