client.cs

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

using System;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using HotelsManage.DateLevel;
namespace HotelsManage.BusinessLevel
{
	/// <summary>
	/// Client 的摘要说明。
	/// </summary>
	public class Client
	{
        ListView listview;
		public Client(ListView listview)
		{
			this.listview=listview;
		}
		private static  void list(SqlDataReader sdr,Client Ct)
		{
			while(sdr.Read())
			{
				ListViewItem lvi=new ListViewItem();
				lvi.SubItems.Clear();
				lvi.SubItems[0].Text=sdr["ClientID"].ToString();
				lvi.SubItems.Add(sdr["ClientName"].ToString());
				lvi.SubItems.Add(sdr["RoomID"].ToString());
				lvi.SubItems.Add(sdr["RTname"].ToString());
				lvi.SubItems.Add(sdr["Price"].ToString());
				lvi.SubItems.Add(sdr["InDate"].ToString());
				lvi.SubItems.Add(sdr["CheckDate"].ToString());
				lvi.SubItems.Add(sdr["TotalMoney"].ToString());
				Ct.listview.Items.Add(lvi);
			}
			if(Ct.listview.Items.Count==0)
			{
			 MessageBox.Show("没有记录存在","没有记录",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		public  static bool ClientSearch(string Clientid,Client Ct)
		{
		 bool result=false;
			SqlParameter[] paras=new SqlParameter[1];
				paras[0]=new SqlParameter("@ClientID",SqlDbType.Char,18);
			    paras[0].Value=Clientid;
			try
			{
				Ct.listview.Items.Clear();
				Ct.listview.Refresh();
				SqlDataReader sdr=DB.ExequlReader("proc_ClientRecord_Search",paras);
				
				Client.list(sdr,Ct);
				result=true;
			}
			catch{}
			return result;
		}
		private static void Incommon(Client Ct,string storeName)
		{
			Ct.listview.Items.Clear();
			Ct.listview.Refresh();
			SqlDataReader sdr=DB.ExequlReader(storeName);
				
			Client.list(sdr,Ct);
		}
		public static void AllRecord(Client Ct)
		{
		 Client.Incommon(Ct,"proc_ClientRecord_Iformation");
		}
		public static void  ClientLiving(Client Ct)
		{
		 Client.Incommon(Ct,"proc_ClientRecord_Living");
		}
		public static bool ClientCheck(string ClientID,string RoomID,string CheckDate,string TotalMoney)
		{
		 bool result=false;
			SqlParameter[] paras=new SqlParameter[4];
			paras[0]=new SqlParameter("@ClientID",SqlDbType.Char,18);
			paras[0].Value=ClientID;

			paras[1]=new SqlParameter("@RoomID",SqlDbType.Char,4);
			paras[1].Value=RoomID;

			paras[2]=new SqlParameter("@CheckDate",SqlDbType.VarChar,50);
			paras[2].Value=CheckDate;

			paras[3]=new SqlParameter("@TotalMoney",SqlDbType.VarChar,10);
			paras[3].Value=TotalMoney;

			result=DB.ExequlNon("proc_ClientRecord_Check",paras);
			return  result;
		}


	}
}