kind.cs

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

using System;
using System.Data;

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

		DBOP myDBOP=new DBOP();
		string strComm;

		public struct KindStru
		{
			public int id;          //编号
			public string kindname; //分类名称
			public string descr;    //描述
		};


		public KindStru GetKindDetail(int id)
		{
			//myDBOP=new DBOP();
			DataSet myDS;
			KindStru myKindStru=new KindStru();
 
			strComm="select * from Kind where id="+ id +"";

			//return myDBOP.GetKindDetail(strComm);

			myDS=myDBOP.mySelect(strComm);

			myKindStru.id=id;
			myKindStru.kindname=myDS.Tables[0].Rows[0][1].ToString().Trim();
			myKindStru.descr=myDS.Tables[0].Rows[0][2].ToString().Trim();

			return myKindStru;
		}

		public bool AddKindDetail(KindStru myKindStru)
		{
			strComm="insert into Kind (id,kindname,descr) values("+myKindStru.id+",'"+myKindStru.kindname+"','"+myKindStru.descr+"')";
			return myDBOP.myAdd(strComm);
		}

		public bool UpdateKindDetail(KindStru myKindStru)
		{
			//myDBOP=new DBOP();
			strComm="update Kind set kindname='"+myKindStru.kindname+"',descr='"+myKindStru.descr+"' where id="+myKindStru.id+"";
			return myDBOP.myUpdate(strComm);
		}

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

		public DataSet GetAllKindDS(int RsCount,int PageSize)
		{
			
			strComm="select * from Kind order by id";
		    
			return myDBOP.mySelect(strComm,RsCount,PageSize);//重载方法mySelect。
		}

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

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

	}
}