/// <summary>
/// ͨ��������ƷID���������Ʒʵ��
/// </summary>
/// <param name="productID"></param>
/// <returns></returns>
public Product GetProductByProductID(int productID)
{
Product product = new Product();
using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
{
string commText = "select * from Product where ProductID="+productID.ToString();
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandText = commText;
conn.Open();
using (SqlDataReader sdr = comm.ExecuteReader())
{
if (sdr.Read())
{
product.ProductID = int.Parse(sdr["ProductID"].ToString());
product.ProductName = sdr["ProductName"].ToString();
product.ProductCompany = sdr["ProductCompany"].ToString();
product.ProductCompanyDescription = sdr["ProductCompanyDescription"].ToString();
product.ProductPictureStoreIDs = sdr["ProductPictureStoreIDs"].ToString();
product.ProductHits = int.Parse(sdr["ProductHits"].ToString());
product.ProductDescription = sdr["ProductDescription"].ToString();
product.HairShopIDs = sdr["HairShopIDs"].ToString();
product.ProductRawPrice = sdr["ProductRawPrice"].ToString();
product.ProductPrice = sdr["ProductPrice"].ToString();
product.ProductDiscount = sdr["ProductDiscount"].ToString();
product.ProductTagIDs = sdr["ProductTagIDs"].ToString();
}
}
}
}
return product;
}
/// <summary>
/// ������Ʒ ��ӣ�ɾ������
/// </summary>
/// <param name="product"></param>
/// <param name="ua"></param>
/// <returns></returns>
public bool ProductCreateDeleteUpdate(Product product, UserAction ua,out int newID)
{
bool result = false;
string commandText = string.Empty;
switch (ua)
{
case UserAction.Create:
commandText = "insert into Product(ProductName,ProductCompany,ProductCompanyDescription,ProductPictureStoreIDs,ProductDescription,HairShopIDs,ProductRawPrice,ProductPrice,ProductDiscount,ProductTagIDs) values('"+product.ProductName+"','"+product.ProductCompany+"','"+product.ProductCompanyDescription+"','"+product.ProductPictureStoreIDs+"','"+product.ProductDescription+"','"+product.HairShopIDs+"','"+product.ProductRawPrice+"','"+product.ProductPrice+"','"+product.ProductDiscount+"','"+product.ProductTagIDs+"');select @@identity;";
break;
case UserAction.Delete:
commandText = "delete from Product where ProductID="+product.ProductID.ToString();
break;
case UserAction.Update:
commandText = "update Product set ProductName='"+product.ProductName+"',ProductCompany='"+product.ProductCompany+"',ProductCompanyDescription='"+product.ProductCompanyDescription+"',ProductPictureStoreIDs='"+product.ProductPictureStoreIDs+"',ProductDescription='"+product.ProductDescription+"',HairShopIDs='"+product.HairShopIDs+"',ProductRawPrice='"+product.ProductRawPrice+"',ProductPrice='"+product.ProductPrice+"',ProductDiscount='"+product.ProductDiscount+"',ProductTagIDs='"+product.ProductTagIDs+"' where ProductID = "+product.ProductID.ToString();
break;
}
using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
{
using (SqlCommand comm = new SqlCommand())
{
comm.CommandText = commandText;
comm.Connection = conn;
conn.Open();
try
{
try
{
newID = Convert.ToInt32(comm.ExecuteScalar());
}
catch (InvalidCastException)
{
newID = 0;
}
result = true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
if (ua == UserAction.Delete)
{
using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
{
result = false;
commandText = "delete from ProductRecommand where ProductRawID=" + product.ProductID.ToString();
using (SqlCommand comm = new SqlCommand())
{
comm.CommandText = commandText;
comm.Connection = conn;
conn.Open();
try
{
comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
return result;
}
public List<Product> GetProducts(int count, OrderKey ok,string productName)
{
List<Product> list = new List<Product>();
string orderKey = " order by ";
switch (ok)
{
case OrderKey.ID:
orderKey += "ProductID desc";
break;
//case OrderKey.CommentNum:
//������δ��Ԥ������ݲ�ʵ��
// orderKey += "he.HairEngineerGood+he.HairEngineerBad desc";
// break;
case OrderKey.HitNum:
orderKey += "ProductHits desc";
break;
default:
orderKey += "ProductID desc";
break;
}
string commText = "";
switch (count)
{
case 0:
commText = "select * from Product where ProductName like '%"+productName+"%'" + orderKey;
break;
default:
commText = "select top " + count.ToString() + " * from Product where ProductName like '%" + productName + "%'" + orderKey;
break;
}
using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
{
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandText = commText;
conn.Open();
using (SqlDataReader sdr = comm.ExecuteReader())
{
while (sdr.Read())
{
Product product = new Product();
product.ProductID = int.Parse(sdr["ProductID"].ToString());
product.ProductName = sdr["ProductName"].ToString();
product.ProductCompany = sdr["ProductCompany"].ToString();
product.ProductCompanyDescription = sdr["ProductCompanyDescription"].ToString();
product.ProductPictureStoreIDs = sdr["ProductPictureStoreIDs"].ToString();
product.ProductHits = int.Parse(sdr["ProductHits"].ToString());
product.ProductDescription = sdr["ProductDescription"].ToString();
product.HairShopIDs = sdr["HairShopIDs"].ToString();
product.ProductRawPrice = sdr["ProductRawPrice"].ToString();
product.ProductPrice = sdr["ProductPrice"].ToString();
product.ProductDiscount = sdr["ProductDiscount"].ToString();
product.ProductTagIDs = sdr["ProductTagIDs"].ToString();
list.Add(product);
}
}
}
}
}
return list;
}
