//查询全部数据 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); }
//根据Cid找一个类 public Ep229Category FindCategoryById(int CatId) { return(CategoryDAL.SelectById(CatId)); }