user.cs

酒店管理系统是个不错的 系统 自己做的毕业设计 里面功能齐全

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using HotelsManage.DateLevel;
namespace HotelsManage.BusinessLevel
{
	/// <summary>
	/// User 的摘要说明。
	/// </summary>
	public class User
	{
		string Uname;
		string Upwd;
		string Usort;
		public User(string Uname,string Upwd,string Usort)
		{
            this.Uname=Uname;
			this.Upwd=Upwd;
			this.Usort=Usort;
		}

		
		public static string CheckLogin(string Uname,string Upwd)
		{
		 string result="不";
			SqlParameter[] paras=new SqlParameter[4];
			paras[0]=new SqlParameter("@Uname",SqlDbType.VarChar,20);
			paras[0].Value=Uname;

			paras[1]=new SqlParameter("@Upwd",SqlDbType.VarChar,20);
			paras[1].Value=Upwd;

			paras[2]=new SqlParameter("@Usort",SqlDbType.VarChar,10);
			paras[2].Direction=ParameterDirection.Output;		

			paras[3]=new SqlParameter("@count",SqlDbType.Int);
			paras[3].Direction=ParameterDirection.ReturnValue;

			result=DB.Login(paras);
			return result;

		}
		private static bool InCommon(string storeName,User user)
		{
		 bool result=false;

			SqlParameter[] paras=new SqlParameter[3];
			paras[0]=new SqlParameter("@Uname",SqlDbType.VarChar,20);
			paras[0].Direction=ParameterDirection.Input;
			paras[0].Value=user.Uname;

			paras[1]=new SqlParameter("@Upwd",SqlDbType.VarChar,20);
			paras[1].Direction=ParameterDirection.Input;
			paras[1].Value=user.Upwd;

			paras[2]=new SqlParameter("@Usort",SqlDbType.VarChar,10);
			paras[2].Direction=ParameterDirection.Input;
			paras[2].Value=user.Usort;

			if(DB.ExequlNon(storeName,paras))
			{
			 result=true;
			}
			return result;
		}

		public static bool UserAdd(User user)
		{
		 bool result=false;
			if(User.InCommon("proc_Users_Add",user))
			{
			 result=true;
			}
		 return result;
		}
		public static bool UserUpdate(User user)
		{
			bool result=false;
			if(User.InCommon("proc_Users_Update",user))
			{
				result=true;
			}
			return result;
		}
		public static bool UserDelete(string Uid)
		{
		 bool result=false;
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@Uname",SqlDbType.VarChar,20);
			paras[0].Direction=ParameterDirection.Input;
			paras[0].Value=Uid;

			if(DB.ExequlNon("proc_Users_Delete",paras))
			{
				result=true;
			}
			return result;
		}
		public static bool bindlist(ListView listview)
		{
		bool	result=false;
		 listview.Items.Clear();
			listview.Refresh();
			try
			{
				SqlDataReader sdr=DB.ExequlReader("proc_Users_Information");
				while(sdr.Read())
				{
					ListViewItem lvi=new ListViewItem();
					lvi.SubItems[0].Text=sdr["Uname"].ToString();
					lvi.SubItems.Add(sdr["Upwd"].ToString());
					lvi.SubItems.Add(sdr["Usort"].ToString());

					listview.Items.Add(lvi);
				}
				result=true;
			}
			catch{}
			if(listview.Items.Count==0)
			{
			 MessageBox.Show("没有用户记录");
			}
			return result;
		}

	}
}