/// <summary>
/// 查询默认地址ID
/// </summary>
/// <returns></returns>
public int SelectAddByType()
{
string sql = "select id from address where type=0";
return(Convert.ToInt32(SqlHelper.ExScalar(sql)));
}
public object SelectUserInfo(string uname, string pwd)
{
string sql = $"select count(*) from Users where username='******' and password='******'";
return(SqlHelper.ExScalar(sql));
}
public object SelectUserLevel(string uname)
{
string sql = $"select UserLevel from Users where username='******'";
return(SqlHelper.ExScalar(sql));
}
/// <summary>
/// 检查商品ID是否存在
/// </summary>
/// <param name="id"></param>
/// <param name="username"></param>
/// <returns></returns>
public object SelectCommByid(string id, string username)
{
string sql = $"select count(*) from Shoppingcart where Pid={id} and UserName='******'";
return(SqlHelper.ExScalar(sql));
}