user.cs.bak

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

using System;
using System.Web;
using System.Web.UI;
using System.Data;

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

		private DBOP myDBOP=new DBOP();
		private string strComm;

		public struct UserStru
		{
			public int id;
			public string username;
			public string pwd;
			public string realname;
			public int gender;  //原来是byte类型。
			public int age;
			public int level;
			public string address;
			public string phone;
		};


		public UserStru GetUserDetail(int id)
		{
			DataSet myDS;
			UserStru myUserStru=new UserStru();
 
			strComm="select * from users where id="+ id +"";

			myDS=myDBOP.mySelect(strComm);

			myUserStru.id=id;
			myUserStru.username=myDS.Tables[0].Rows[0][1].ToString().Trim();
			myUserStru.pwd=myDS.Tables[0].Rows[0][2].ToString().Trim();	
			myUserStru.realname=myDS.Tables[0].Rows[0][3].ToString().Trim();
			if(myDS.Tables[0].Rows[0][4].ToString().Trim()=="True")
				myUserStru.gender=1;
			else
				myUserStru.gender=0;
			myUserStru.age=Convert.ToInt32(myDS.Tables[0].Rows[0][5].ToString().Trim());
			myUserStru.level=Convert.ToInt32(myDS.Tables[0].Rows[0][6].ToString().Trim());
			myUserStru.address=myDS.Tables[0].Rows[0][7].ToString().Trim();
			myUserStru.phone=myDS.Tables[0].Rows[0][8].ToString().Trim();

			return myUserStru;
		}

		public bool AddUserDetail(UserStru myUserStru)
		{
			int id;
			strComm="select max(id) from users";
			id=(int)myDBOP.mySelect(strComm,1)+1;
			strComm="insert into users (id,username,pwd,realname,gender,age,level,address,phone) values("+id+",'"+myUserStru.username+"','"+myUserStru.pwd+"','"+myUserStru.realname+"',"+myUserStru.gender+","+myUserStru.age+","+myUserStru.level+",'"+myUserStru.address+"','"+myUserStru.phone+"')";
			return myDBOP.myAdd(strComm);
		}

		public bool UpdateUserDetail(UserStru myUserStru)
		{
			//myDBOP=new DBOP();
			strComm="update users set username='"+myUserStru.username+"',pwd='"+myUserStru.pwd+"',realname='"+myUserStru.realname+"',gender="+myUserStru.gender+",age="+myUserStru.age+",address='"+myUserStru.address+"',phone='"+myUserStru.phone+"' where id="+myUserStru.id+"";
			return myDBOP.myUpdate(strComm);
		}

		public bool DeleteUserDetail(int id)
		{
			strComm="delete from users where id="+id+"";
			return myDBOP.myDelete(strComm);
		}
		
		public DataSet GetAllUserDS(int RsCount,int PageSize)
		{
			
			strComm="select * from users order by id";
		    
			return myDBOP.mySelect(strComm,RsCount,PageSize);//重载方法mySelect。
		}

		public int GetAllUserCount()
		{
			strComm="select count(*) from users";
			return Convert.ToInt32(myDBOP.mySelect(strComm,1));
		}

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