//查询全部数据
public IList <Ep229Product> SelectAll()
{
IList <Ep229Product> list = new List <Ep229Product>();
String sql = String.Format("select * from ep229_product");
DataTable dt = SqlHelper.ExecuteQuery(sql);
Ep229Product product = null;
foreach (DataRow row in dt.Rows)
{
product = new Ep229Product();
product.ProdId = (int)row[0];
Ep229CategoryDAL category = new Ep229CategoryDAL();
int id = (int)row[1];
product.Category = category.SelectById((int)row[1]);
product.ProdName = (string)row[2];
product.ProdType = (string)row[3];
product.ProdPrice = (double)row[4];
product.ProdImage = (string)row[5];
product.ProdDesc = (string)row[6];
product.ProdDatetime = (DateTime)row[7];
product.ProdFirstShow = (bool)row[8];
list.Add(product);
}
return(list);
}
//查找一条数据
public Ep229Product SelectById(int id)
{
Ep229Product product = null;
string sql = String.Format("select * from ep229_product where prod_id={0}", id);
SqlDataReader sdr = SqlHelper.ExecuteReader(sql);
if (sdr.Read())
{
product = new Ep229Product();
product.ProdId = sdr.GetInt32(0);
Ep229CategoryDAL category = new Ep229CategoryDAL();
product.Category = category.SelectById(sdr.GetInt32(1));
product.ProdName = sdr.GetString(2);
product.ProdType = sdr.GetString(3);
product.ProdPrice = sdr.GetDouble(4);
product.ProdImage = sdr.GetString(5);
product.ProdDesc = sdr.GetString(6);
product.ProdDatetime = sdr.GetDateTime(7);
product.ProdFirstShow = sdr.GetBoolean(8);
}
sdr.Close();
return(product);
}
//out标记需要返回的参数
//查找首页数据产品
public IList <Ep229Product> SelectSome(out int total, int start, int count)
{
IList <Ep229Product> list = new List <Ep229Product>();
String sql = String.Format("select * from ep229_product where prod_firstShow=1");
DataTable dt = SqlHelper.ExecuteQuery(out total, sql, "prod_datetime desc", start, count);
Ep229Product product = null;
foreach (DataRow row in dt.Rows)
{
product = new Ep229Product();
product.ProdId = (int)row[0];
Ep229CategoryDAL category = new Ep229CategoryDAL();
product.Category = category.SelectById((int)row[1]);
product.ProdName = (string)row[2];
product.ProdType = (string)row[3];
product.ProdPrice = (double)row[4];
product.ProdImage = (string)row[5];
product.ProdDesc = (string)row[6];
product.ProdDatetime = (DateTime)row[7];
product.ProdFirstShow = (bool)row[8];
list.Add(product);
}
return(list);
}
