flower.cs

ASP.net+sql server2000编写的完整鲜花在线销售系统

using System;
using System.Data;

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

		DBOP myDBOP=new DBOP();
		string strComm;

		public struct FlowerStru
		{
			public int id;        //编号
			public string name;   //名称
			public int inprice;   //进价
			public int outprice;  //售价
			public int incount;   //进货数量
			public string classid;//分类编号
			public int remain;    //
			public string unit;   //
			public string picpath;//图片地址
		};


		public FlowerStru GetFlowerDetail(int id)
		{
			//myDBOP=new DBOP();
			DataSet myDS;
			FlowerStru myFlowerStru=new FlowerStru();
 
			strComm="select * from flower where id="+ id +"";

			//return myDBOP.GetFlowerDetail(strComm);

			myDS=myDBOP.mySelect(strComm);

			myFlowerStru.id=id;
			myFlowerStru.name=myDS.Tables[0].Rows[0][1].ToString().Trim();
			myFlowerStru.inprice=Convert.ToInt32(myDS.Tables[0].Rows[0][2].ToString().Trim());
			myFlowerStru.outprice=Convert.ToInt32(myDS.Tables[0].Rows[0][3].ToString().Trim());
			myFlowerStru.incount=Convert.ToInt32(myDS.Tables[0].Rows[0][4].ToString().Trim());
			myFlowerStru.classid=myDS.Tables[0].Rows[0][5].ToString().Trim();
			myFlowerStru.remain=Convert.ToInt32(myDS.Tables[0].Rows[0][6].ToString().Trim());
			myFlowerStru.unit=myDS.Tables[0].Rows[0][7].ToString().Trim();
			myFlowerStru.picpath=myDS.Tables[0].Rows[0][9].ToString().Trim();

			return myFlowerStru;
		}

		public bool AddFlowerDetail(FlowerStru myFlowerStru)
		{
			strComm="insert into flower (id,name,inprice,outprice,incount,classid,remain,unit) values("+myFlowerStru.id+",'"+myFlowerStru.name+"',"+myFlowerStru.inprice+","+myFlowerStru.outprice+","+myFlowerStru.incount+",'"+myFlowerStru.classid+"',"+myFlowerStru.remain+",'"+myFlowerStru.unit+"')";
			return myDBOP.myAdd(strComm);
		}

		public bool UpdateFlowerDetail(FlowerStru myFlowerStru)
		{
			//myDBOP=new DBOP();
			strComm="update flower set name='"+myFlowerStru.name+"',inprice="+myFlowerStru.inprice+",outprice="+myFlowerStru.outprice+",incount="+myFlowerStru.incount+",classid='"+myFlowerStru.classid+"',remain="+myFlowerStru.remain+",unit='"+myFlowerStru.unit+"' where id="+myFlowerStru.id+"";
			return myDBOP.myUpdate(strComm);
		}

		public bool DeleteFlowerDetail(int id)
		{
			strComm="delete from flower where id="+id+"";
			return myDBOP.myDelete(strComm);
		}

		public DataSet GetAllFlowerDS(int RsCount,int PageSize,int orderby)
		{
			if(orderby==0)
				strComm="select * from flower order by id";
			else
				strComm="select * from flower order by outcount desc";
		    
			return myDBOP.mySelect(strComm,RsCount,PageSize);//重载方法mySelect。
		}

		public int GetAllFlowerCount()
		{
			strComm="select count(*) from flower";
			return int.Parse(myDBOP.mySelect(strComm).Tables[0].Rows[0][0].ToString().Trim());
		}

		public int GetFlowerMaxID()
		{
			strComm="select max(id) from flower";
			return int.Parse(myDBOP.mySelect(strComm).Tables[0].Rows[0][0].ToString().Trim());
		}

	}
}