public Product GetProductById(string productId)
{
string sql = "select ProductId,ProductName,UnitPrice,Discount,CategoryId from Products where ProductId=@ProductId";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ProductId", productId)
};
Product objProduct = null;
try
{
SqlDataReader objReader = SQLHelp.GetResult(sql, param);
if (objReader.Read())
{
objProduct = new Product();
objProduct.UnitPrice = Convert.ToDecimal(objReader["UnitPrice"]);
objProduct.ProductId = objReader["ProductId"].ToString();
objProduct.ProductName = objReader["ProductName"].ToString();
objProduct.CategoryId = Convert.ToInt32(objReader["CategoryId"]);
objProduct.Discount = Convert.ToInt32(objReader["Discount"]);
}
objReader.Close();
return(objProduct);
}
catch (SqlException ex)
{
throw new Exception("应用程序与数据库连接出错，具体内容： " + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
public SMMembers GetSMMemberById(string smmemberId)
{
string sql = "select MemberId, MemberName, Points, PhoneNumber, MemberAddress, OpenTime, MemberStatus from ";
sql += "SMMembers where MemberId={0}";
sql = string.Format(sql, smmemberId);
SMMembers objSMMember = null;
try
{
SqlDataReader objReader = SQLHelp.GetResult(sql, null);
if (objReader.Read())
{
objSMMember = new SMMembers()
{
MemberAddress = objReader["MemberAddress"].ToString(),
MemberId = objReader["MemberId"].ToString(),
MemberName = objReader["MemberName"].ToString(),
MemberStatus = Convert.ToInt32(objReader["MemberStatus"]),
OpenTime = Convert.ToDateTime(objReader["OpenTime"]),
PhoneNumber = objReader["PhoneNumber"].ToString(),
Points = Convert.ToInt32(objReader["Points"])
};
}
objReader.Close();
return(objSMMember);
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception("应用程序与数据库连接出错，具体内容： " + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
