public bool Fnc_Reserve(Fnc_Reserve_Entity fre)
{
Function_DL fdl = new Function_DL();
DataTable dt = fdl.Fnc_Reserve(fre);
if (dt.Rows.Count > 0)
{
fre.Result = dt.Rows[0]["Result"].ToString();
fre.Error = dt.Rows[0]["Error"].ToString();
fre.LastDay = dt.Rows[0]["LastDay"].ToString();
fre.OutKariHikiateNo = dt.Rows[0]["OutKariHikiateNo"].ToString();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 商品引当処理
/// </summary>
/// <param name="fre"></param>
/// <returns></returns>
public DataTable Fnc_Reserve(Fnc_Reserve_Entity fre)
{
string sp = "Fnc_Reserve";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@AdminNO", new ValuePair {
value1 = SqlDbType.Int, value2 = fre.AdminNO
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fre.ChangeDate
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fre.StoreCD
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fre.SoukoCD
} },
{ "@Suryo", new ValuePair {
value1 = SqlDbType.Int, value2 = fre.Suryo
} },
{ "@DenType", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = fre.@DenType
} },
{ "@DenNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fre.@DenNo
} },
{ "@DenGyoNo", new ValuePair {
value1 = SqlDbType.Int, value2 = fre.@DenGyoNo
} },
{ "@KariHikiateNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fre.@KariHikiateNo
} }
};
return(SelectData(dic, sp));
}