st_product.cs

it have big power,i hope to do it . happy everyday!

using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_BookBiz
{
	/// <summary>
	/// ST_Product 的摘要说明。
	/// </summary>
	public class ST_Product
	{
		public ST_Product()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 插入商品信息
		/// </summary>
		/// <param name="st_product"></param>
		/// <returns></returns>
		public int InsertProduct(ST_BookBiz.ST_ProductEntity st_product)
		{
			string sqlString = @"insert into ST_Product(ST_ProductName,ST_Price,ST_SoldPrice,ST_Publisher,ST_ISBN,ST_Page,ST_PublishDate,ST_ClassID,ST_Image,ST_IsSelling)
								 values('"+st_product.ST_ProductName+"','"+st_product.ST_Price+"','"+st_product.ST_SoldPrice+"','"+st_product.ST_Publisher+"','"+st_product.ST_ISBN+"','"+st_product.ST_Page+"','"+st_product.ST_PublishDate+"','"+st_product.ST_ClassID+"','"+st_product.ST_Image+"','"+(st_product.ST_IsSelling?1:0)+"'); select scope_identity();";

			object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			if(obj!=null)
				return int.Parse(obj.ToString());
			return 0;
		}
		/// <summary>
		/// 更新商品信息
		/// </summary>
		/// <param name="st_product"></param>
		public void UpdateProduct(ST_BookBiz.ST_ProductEntity st_product)
		{
			string sqlString = "update ST_Product set ST_ProductName='"+st_product.ST_ProductName+"',ST_Price='"+st_product.ST_Price+"',ST_SoldPrice='"+st_product.ST_SoldPrice+"',ST_Publisher='"+st_product.ST_Publisher+"',ST_ISBN='"+st_product.ST_ISBN+"',ST_Page='"+st_product.ST_Page+"',ST_PublishDate='"+st_product.ST_PublishDate+"',ST_ClassID='"+st_product.ST_ClassID+"',ST_Image='"+st_product.ST_Image+"',ST_IsSelling='"+(st_product.ST_IsSelling?1:0)+"' where ST_ProductID="+st_product.ST_ProductID;
			SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
		}

        /// <summary>
        /// 更新商品图片
        /// </summary>
        /// <param name="st_product"></param>
        public void UpdateProductImg(string st_image, int st_productid)
        {
            string sqlString = "update ST_Product set ST_Image='" + st_image + "' where ST_ProductID=" + st_productid;
            SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
        }

		/// <summary>
		/// 取得一个商品的信息
		/// </summary>
		/// <param name="productid"></param>
		/// <returns></returns>
		public ST_BookBiz.ST_ProductEntity GetProductInfoByID(int productid)
		{
			string sqlString = "select * from ST_Product where ST_ProductID="+productid;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			ST_BookBiz.ST_ProductEntity st_product = new ST_ProductEntity();
			st_product.ST_ProductID = productid;
			st_product.ST_ProductName = ds.Tables[0].Rows[0]["ST_ProductName"].ToString();
			st_product.ST_Price = float.Parse(ds.Tables[0].Rows[0]["ST_Price"].ToString());
			st_product.ST_SoldPrice = float.Parse(ds.Tables[0].Rows[0]["ST_SoldPrice"].ToString());
			st_product.ST_Publisher = ds.Tables[0].Rows[0]["ST_Publisher"].ToString();
			st_product.ST_ISBN = ds.Tables[0].Rows[0]["ST_ISBN"].ToString();
			st_product.ST_Page = int.Parse(ds.Tables[0].Rows[0]["ST_Page"].ToString());
			st_product.ST_PublishDate = DateTime.Parse(ds.Tables[0].Rows[0]["ST_PublishDate"].ToString());
			st_product.ST_ClassID = int.Parse(ds.Tables[0].Rows[0]["ST_ClassID"].ToString());
			st_product.ST_Image = ds.Tables[0].Rows[0]["ST_Image"].ToString();
			st_product.ST_IsSelling = bool.Parse(ds.Tables[0].Rows[0]["ST_IsSelling"].ToString());
            st_product.ST_Author = ds.Tables[0].Rows[0]["ST_Author"].ToString();
			return st_product;

		}
		/// <summary>
		/// 取得某个分类下的所有商品
		/// </summary>
		/// <param name="classID"></param>
		/// <returns></returns>
		public DataSet GetProductByClassID(int classID)
		{
			string sqlString = "select * from ST_Product where ST_IsDeleted=0 and ST_ClassID="+classID;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}
		/// <summary>
		/// 取得某个分类下的上架商品或者下架商品,1是上架，0是下架
		/// </summary>
		/// <param name="classID"></param>
		/// <returns></returns>
		public DataSet GetProductByClassID(int classID,int flag)
		{
			string sqlString = "select * from ST_Product where ST_IsDeleted=0 and st_isselling="+flag+" and ST_ClassID="+classID;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}
		/// <summary>
		/// 取得按某个关键词搜索的上架商品
		/// </summary>
		/// <param name="classID"></param>
		/// <returns></returns>
		public DataSet GetProductByClassID(string keyword, int classid)
		{
			string sqlString = "select * from ST_Product where ST_IsDeleted=0 and st_isselling=1 and ST_ProductName like '%"+keyword+"%'";
			if(classid!=0)
			{
				sqlString += " and ST_ClassID="+classid;
			}
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}
		/// <summary>
		/// 判断商品是否可以删除
		/// </summary>
		/// <param name="productid"></param>
		/// <returns></returns>
		public bool CanDeleteProduct(int productid)
		{
			string sqlString = "select count(*) from ST_OrderProduct sop join ST_Product sp on sop.st_productid = sp.st_productid where sp.st_productid="+productid;
			object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			if(obj!=null && obj.ToString()!="0")
				return false;
			return true;

		}
		/// <summary>
		/// 删除一件商品
		/// </summary>
		/// <param name="productid"></param>
		public void DeleteProduct(int productid)
		{
			string sqlString = "update ST_Product set ST_IsDeleted=1 where st_productid="+productid;
			SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 得到推荐商品
		/// </summary>
		/// <param name="productid"></param>
		public DataSet GetPromotionProduct()
		{
			string sqlString = "select * from ST_Product where ST_IsDeleted=0 and ST_IsSelling=1 AND ST_IsPromotion=1";
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}
        /// <summary>
        /// 推荐操作
        /// </summary>
        /// <param name="productid"></param>
        public void UpdatePromotion(int productid,int flag)
        {
            string sqlString = "update ST_Product set ST_IsPromotion=" + flag + " where ST_ProductID="+productid;
            SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
        }
        /// <summary>
        /// 上下架操作
        /// </summary>
        /// <param name="productid"></param>
        public void UpdateUpDown(int productid, int flag)
        {
            string sqlString = "update ST_Product set ST_IsSelling=" + flag + " where ST_ProductID=" + productid;
            SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
        }
	}
}