public DataTable M_Site_Select(M_Site_Entity mse)
{
string sp = "M_Site_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@AdminNO", new ValuePair {
value1 = SqlDbType.Int, value2 = mse.AdminNO
} },
{ "@APIKey", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.APIKey
} }
};
return(SelectData(dic, sp));
}
public bool M_Site_Select(M_Site_Entity mse)
{
DataTable dt = mmdl.M_Site_Select(mse);
if (dt.Rows.Count > 0)
{
mse.ItemSKUCD = dt.Rows[0]["ItemSKUCD"].ToString();
mse.APIKey = dt.Rows[0]["APIKey"].ToString();
//mse.ItemSKUFLG = dt.Rows[0]["ItemSKUFLG"].ToString();
mse.SiteURL = dt.Rows[0]["SiteURL"].ToString();
mse.InsertOperator = dt.Rows[0]["InsertOperator"].ToString();
mse.InsertDateTime = dt.Rows[0]["InsertDateTime"].ToString();
mse.UpdateOperator = dt.Rows[0]["UpdateOperator"].ToString();
mse.UpdateDateTime = dt.Rows[0]["UpdateDateTime"].ToString();
return(true);
}
else
{
return(false);
}
}
