/// <summary>
/// 店舗レジ実績照会データ取得処理
/// TempoRegiJissekiSyoukaiよりデータ抽出時に使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Sales_SelectData_ForTempoRegiJissekiSyoukai(D_Sales_Entity ds)
{
string sp = "D_Sales_SelectData_ForTempoRegiJisseki";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Date", new ValuePair {
value1 = SqlDbType.Date, value2 = ds.SalesDate
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 店舗レジ販売履歴照会データ取得処理
/// TempoRegiHanbaiRirekiよりデータ抽出時に使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Sales_SelectData_ForTempoRegiHanbaiRireki(D_Sales_Entity de)
{
string sp = "D_Sales_SelectData_ForTempoRegiHanbaiRireki";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@JuchuuNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNO
} },
};
return(SelectData(dic, sp));
}
private D_Sales_Entity GetSearchInfo()
{
dme = new D_Sales_Entity
{
SalesDateFrom = detailControls[(int)EIndex.DayStart].Text,
SalesDateTo = detailControls[(int)EIndex.DayEnd].Text,
StaffCD = ScStaff.TxtCode.Text,
CustomerCD = ScCustomer.TxtCode.Text,
CustomerName = detailControls[(int)EIndex.CustomerName].Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
};
return(dme);
}
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 DataTable D_Sale_SelectForSeisan(D_Sales_Entity dse)
{
string sp = "D_Sale_SelectForSeisan";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.StoreCD
} },
{ "@Date", new ValuePair {
value1 = SqlDbType.Date, value2 = dse.ChangeDate
} },
};
UseTransaction = true;
return(SelectData(dic, sp));
}
/// <summary>
/// 売上データ取得処理
/// 店舗レジ 販売登録で使用するためのストアドとして作成
/// </summary>
public DataTable D_Sales_SelectForRegi(D_Sales_Entity mie, short operationMode)
{
string sp = "D_Sales_SelectForRegi";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@SalesNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mie.SalesNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 出荷売上データ更新処理
/// </summary>
/// <param name="dse"></param>
/// <returns></returns>
public bool ShukkaUriageUpdate(D_Sales_Entity dse)
{
string sp = "PRC_ShukkaUriageUpdate";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.Operator
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.PC
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, sp));
}
/// <summary>
/// 売上入力データ取得処理
/// UriageNyuuryokuよりデータ抽出時に使用
/// 売上入力未作成のため納品書で使用するためのストアドとして作成
/// </summary>
public DataTable D_Sales_SelectData(D_Sales_Entity mie, short operationMode)
{
string sp = "D_Sales_SelectData";
//command.Parameters.Add("@SyoKBN", SqlDbType.TinyInt).Value = mie.SyoKBN;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@SalesNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mie.SalesNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 売上番号検索よりデータ抽出時に使用
/// </summary>
/// <param name="dme"></param>
/// <returns></returns>
public DataTable D_Sales_SelectAll(D_Sales_Entity dme)
{
string sp = "D_Sales_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SalesDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.SalesDateFrom
} },
{ "@SalesDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.SalesDateTo
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.StoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.StaffCD
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.CustomerCD
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.CustomerName
} },
};
if (!string.IsNullOrWhiteSpace(dme.CustomerName))
{
DataTable dt = SelectData(dic, sp);
DataRow[] drs = dt.Select(" CustomerName LIKE '%" + dme.CustomerName + "%'");
DataTable newdt = dt.Clone();
foreach (var dr in drs)
{
//newdt.Rows.Add(dr)ではダメ。
//drはdtに所属している行なので、別のDataTableであるnewdtにはAddできない。
//よって、newdtの新しい行を作成し、その各列の値をdrと全く同じにし、それをnewdtに追加すれば良い。
DataRow newrow = newdt.NewRow();
newrow.ItemArray = dr.ItemArray;
newdt.Rows.Add(newrow);
}
return(newdt);
}
return(SelectData(dic, sp));
}
public bool D_Sales_Update(D_Sales_Entity dse, DataTable dt, string operatorNm, string pc)
{
string sp = "D_Sales_Update";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, operatorNm);
AddParam(command, "@PC", SqlDbType.VarChar, pc);
UseTransaction = true;
string outPutParam = ""; //未使用
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
return(ret);
}
static void Main(string[] args)
{
Console.Title = "TempoRegiDataUpdate";
if (loginbl.ReadConfig() == true)
{
if (GetCmdLine() == false)
{
return;
}
D_Sales_Entity dse = new D_Sales_Entity();
dse.SalesNO = InSaleNO;
dse.Operator = InOperatorCD;
dse.PC = InPcID;
dse.StoreCD = InStoreCD;
exe.ExecUpdate(dse, Convert.ToInt32(InOperationMode));
}
}
private void DispFromSales()
{
D_Sales_Entity dse = new D_Sales_Entity();
dse.SalesDate = txtDate.Text;
dtSales = tprg_Jisseki_Bl.D_Sales_Select(dse);
if (dtSales.Rows.Count > 0)
{
//【Data Area Detail】
DispFromDataTable();
}
else
{
Clear(pnlDetail);
tprg_Jisseki_Bl.ShowMessage("E128");
txtDate.Focus();
}
}
/// <summary>
/// 店舗レジ出荷売上入力更新処理
/// TempoShukkaNyuuryokuより更新時に使用
/// </summary>
/// <param name="dse"></param>
/// <param name="operationMode"></param>
/// <param name="operatorNm"></param>
/// <param name="pc"></param>
/// <returns></returns>
public bool PRC_TempoShukkaNyuuryoku(D_Sales_Entity dse, DataTable dt, short operationMode, string operatorNm, string pc)
{
string sp = "PRC_TempoShukkaNyuuryoku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@JuchuuNO", SqlDbType.VarChar, dse.JuchuuNO);
AddParam(command, "@SalesNO", SqlDbType.VarChar, dse.SalesNO);
AddParam(command, "@StoreCD", SqlDbType.VarChar, dse.StoreCD);
AddParam(command, "@SalesDate", SqlDbType.VarChar, dse.SalesDate);
AddParam(command, "@FirstCollectPlanDate", SqlDbType.VarChar, dse.FirstCollectPlanDate);
AddParam(command, "@CustomerCD", SqlDbType.VarChar, dse.CustomerCD);
AddParam(command, "@BillingType", SqlDbType.TinyInt, dse.BillingType);
AddParam(command, "@SalesGaku", SqlDbType.Money, dse.SalesGaku);
AddParam(command, "@SalesTax", SqlDbType.Money, dse.SalesTax);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, operatorNm);
AddParam(command, "@PC", SqlDbType.VarChar, 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);
}
private void FrmSelectSales_Load(object sender, EventArgs e)
{
AddHandler();
D_Sales_Entity dje = new D_Sales_Entity();
dje.JuchuuNO = mJuchuNo;
dtSales = tbl.D_Sales_Select(dje);
if (dtSales.Rows.Count > 0)
{
//【Data Area Detail】
DispFromDataTable();
btnDown.Tag = "0";
lblDtGyo1.BackColor = Color.FromArgb(255, 242, 204);
}
else
{
EndSec();
}
}
public bool ExecUpdate(D_Sales_Entity de)
{
D_Sales_DL ddl = new D_Sales_DL();
return(ddl.ShukkaUriageUpdate(de));
}
public DataTable D_Sales_SelectAll(D_Sales_Entity dse)
{
return(ddl.D_Sales_SelectAll(dse));
}
/// <summary>
/// 売上入力取得処理
/// UriageNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Sales_SelectData(D_Sales_Entity dse, short operationMode)
{
DataTable dt = mdl.D_Sales_SelectData(dse, operationMode);
return(dt);
}
/// <summary>
/// 店舗納品書更新処理
/// TempoNouhinsyoよりフラグ更新時に使用
/// </summary>
public bool D_Sales_Update(D_Sales_Entity dse, DataTable dt, string operatorNm, string pc)
{
return(mdl.D_Sales_Update(dse, dt, operatorNm, pc));
}
public void ExecUpdate(D_Sales_Entity dse, int OperationMode)
{
TempoRegiHanbaiTouroku_BL tprg_Hanbai_Bl = new TempoRegiHanbaiTouroku_BL();
bool ret = tprg_Hanbai_Bl.PRC_TempoRegiDataUpdate(dse, OperationMode);
}
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));
}
public DataTable D_Sales_Select(D_Sales_Entity de)
{
D_Sales_DL dl = new D_Sales_DL();
return(dl.D_Sales_SelectData_ForTempoRegiHanbaiRireki(de));
}
/// <summary>
/// 店舗納品書よりデータ抽出時に使用
/// </summary>
/// <param name="dme"></param>
/// <returns></returns>
public DataTable D_Sales_SelectForPrint(D_Sales_Entity dme)
{
string sp = "D_Sales_SelectForPrint";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SalesNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.SalesNO
} },
{ "@SalesDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.SalesDateFrom
} },
{ "@SalesDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.SalesDateTo
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.StoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.StaffCD
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.CustomerCD
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dme.CustomerName
} },
{ "@PrintFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dme.PrintFLG
} },
};
if (!string.IsNullOrWhiteSpace(dme.CustomerName))
{
DataTable dt = SelectData(dic, sp);
DataRow[] drs = dt.Select(" CustomerName LIKE '%" + dme.CustomerName + "%'");
DataTable newdt = dt.Clone();
foreach (var dr in drs)
{
if (dme.PrintFLG == "1")
{
if (string.IsNullOrWhiteSpace(dr["PrintDateTime"].ToString()))
{
continue;
}
}
else if (dme.PrintFLG == "0")
{
if (!string.IsNullOrWhiteSpace(dr["PrintDateTime"].ToString()))
{
continue;
}
}
//newdt.Rows.Add(dr)ではダメ。
//drはdtに所属している行なので、別のDataTableであるnewdtにはAddできない。
//よって、newdtの新しい行を作成し、その各列の値をdrと全く同じにし、それをnewdtに追加すれば良い。
DataRow newrow = newdt.NewRow();
newrow.ItemArray = dr.ItemArray;
newdt.Rows.Add(newrow);
}
return(newdt);
}
else if (dme.PrintFLG == "1")
{
DataTable dt1 = SelectData(dic, sp);
DataRow[] drs1 = dt1.Select(" PrintDateTime IS NOT NULL");
DataTable newdt1 = dt1.Clone();
foreach (var dr in drs1)
{
//newdt.Rows.Add(dr)ではダメ。
//drはdtに所属している行なので、別のDataTableであるnewdtにはAddできない。
//よって、newdtの新しい行を作成し、その各列の値をdrと全く同じにし、それをnewdtに追加すれば良い。
DataRow newrow1 = newdt1.NewRow();
newrow1.ItemArray = dr.ItemArray;
newdt1.Rows.Add(newrow1);
}
return(newdt1);
}
else if (dme.PrintFLG == "0")
{
DataTable dt1 = SelectData(dic, sp);
DataRow[] drs1 = dt1.Select(" PrintDateTime IS NULL");
DataTable newdt1 = dt1.Clone();
foreach (var dr in drs1)
{
//newdt.Rows.Add(dr)ではダメ。
//drはdtに所属している行なので、別のDataTableであるnewdtにはAddできない。
//よって、newdtの新しい行を作成し、その各列の値をdrと全く同じにし、それをnewdtに追加すれば良い。
DataRow newrow1 = newdt1.NewRow();
newrow1.ItemArray = dr.ItemArray;
newdt1.Rows.Add(newrow1);
}
return(newdt1);
}
return(SelectData(dic, sp));
}
public DataTable D_Sales_Select(D_Sales_Entity de)
{
D_Sales_DL dl = new D_Sales_DL();
return(dl.D_Sales_SelectData_ForTempoRegiJissekiSyoukai(de));
}
/// <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);
}
public bool PRC_TempoRegiDataUpdate(D_Sales_Entity dse, int operationMode)
{
TempoRegiHanbaiTouroku_DL dl = new TempoRegiHanbaiTouroku_DL();
return(dl.PRC_TempoRegiDataUpdate(dse, operationMode));
}
public DataTable D_Sales_SelectForPrint(D_Sales_Entity mie)
{
return(mdl.D_Sales_SelectForPrint(mie));
}
/// <summary>
/// 店舗売上入力更新処理
/// KaitouNoukiTourokuより更新時に使用
/// </summary>
public bool Uriage_Exec(D_Sales_Entity de, DataTable dt, short operationMode)
{
TempoShukkaNyuuryoku_DL dl = new TempoShukkaNyuuryoku_DL();
return(dl.PRC_TempoUriageNyuuryoku(de, dt, operationMode));
}
public DataTable CheckSalesNo(D_Sales_Entity dse, short operationMode)
{
D_Sales_DL dl = new D_Sales_DL();
return(dl.D_Sales_SelectData(dse, operationMode));
}
public bool PRC_TempoShukkaNyuuryoku(D_Sales_Entity dse, DataTable dt, short operationMode, string operatorNm, string pc)
{
TempoShukkaNyuuryoku_DL dl = new TempoShukkaNyuuryoku_DL();
return(dl.PRC_TempoShukkaNyuuryoku(dse, dt, operationMode, operatorNm, pc));
}
public DataTable D_Sales_SelectForRegi(D_Sales_Entity de, short operationMode)
{
D_Sales_DL dl = new D_Sales_DL();
return(dl.D_Sales_SelectForRegi(de, operationMode));
}
