public bool M_JANOrderPrice_Select(M_JANOrderPrice_Entity mie)
{
DataTable dt = mdl.M_JANOrderPrice_Select(mie);
if (dt.Rows.Count > 0)
{
mie.Rate = dt.Rows[0]["Rate"].ToString();
mie.PriceWithoutTax = dt.Rows[0]["PriceWithoutTax"].ToString();
mie.Remarks = dt.Rows[0]["Remarks"].ToString();
mie.DeleteFlg = dt.Rows[0]["DeleteFlg"].ToString();
mie.UsedFlg = dt.Rows[0]["UsedFlg"].ToString();
return(true);
}
else
{
return(false);
}
}
public DataTable M_JANOrderPrice_Select(M_JANOrderPrice_Entity mje)
{
string sp = "M_JANOrderPrice_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@AdminNO", new ValuePair {
value1 = SqlDbType.Int, value2 = mje.AdminNO
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mje.VendorCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mje.ChangeDate
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mje.StoreCD
} },
};
return(SelectData(dic, sp));
}