/// <summary>
/// 単価取得処理
/// </summary>
/// <param name="fue"></param>
/// <returns></returns>
public bool Fnc_UnitPrice(Fnc_UnitPrice_Entity fue)
{
Function_DL fdl = new Function_DL();
DataTable dt = fdl.Fnc_UnitPrice(fue);
if (dt.Rows.Count > 0)
{
fue.ZeikomiTanka = Z_SetStr(dt.Rows[0]["ZeikomiTanka"]);
fue.ZeinukiTanka = Z_SetStr(dt.Rows[0]["ZeinukiTanka"]);
fue.Zeiritsu = Z_SetStr(dt.Rows[0]["Zeiritsu"]);
fue.Zei = Z_SetStr(dt.Rows[0]["Zei"]);
fue.GenkaTanka = Z_SetStr(dt.Rows[0]["GenkaTanka"]);
fue.Bikou = dt.Rows[0]["Bikou"].ToString();
return(true);
}
else
{
fue.ZeikomiTanka = "0";
fue.ZeinukiTanka = "0";
fue.Zeiritsu = "0";
fue.Zei = "0";
fue.GenkaTanka = "0";
fue.Bikou = "";
return(false);
}
}
/// <summary>
/// 単価取得処理
/// </summary>
/// <param name="fue"></param>
/// <returns></returns>
public DataTable Fnc_UnitPrice(Fnc_UnitPrice_Entity fue)
{
string sp = "Fnc_UnitPrice";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@AdminNo", new ValuePair {
value1 = SqlDbType.Int, value2 = fue.AdminNo
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fue.ChangeDate
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fue.CustomerCD
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = fue.StoreCD
} },
{ "@SaleKbn", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = fue.SaleKbn
} },
{ "@Suryo", new ValuePair {
value1 = SqlDbType.Int, value2 = fue.Suryo
} }
};
return(SelectData(dic, sp));
}