//查询全部数据
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 int Insert(Ep229Product product)
{
string sql = String.Format("insert into ep229_product(prod_name,cat_id,prod_type, prod_price,prod_image, prod_desc, prod_firstShow) values('{0}',{1},'{2}',{3},'{4}','{5}',{6})", product.ProdName,
product.Category.CatId, product.ProdType, product.ProdPrice, product.ProdImage, product.ProdDesc, product.ProdFirstShow ? 1 : 0);
return(SqlHelper.ExecuteNonQuery(sql));
}
//更新数据
public int Update(Ep229Product product)
{
string sql = String.Format("update ep229_product set cat_id={0},prod_name='{1}',prod_type='{2}',prod_price={3},prod_desc='{4}',prod_firstShow={5} where prod_id={6}", product.Category.CatId, product.ProdName,
product.ProdType, product.ProdPrice, product.ProdDesc, product.ProdFirstShow ? 1 : 0, product.ProdId);
return(SqlHelper.ExecuteNonQuery(sql));
}
//查找一条数据
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);
}
//编辑一条产品
public int EditProduct(Ep229Product product)
{
return(ProductDAL.Update(product));
}
//删除一条产品
public int DeleteProduct(Ep229Product product)
{
return(ProductDAL.Delete(product.ProdId));
}
//增加一条产品数据
public int AddProduct(Ep229Product product)
{
return(ProductDAL.Insert(product));
}