business.cs

酒店管理,主要从事酒店管理都可以.这可是北大青鸟的程序

using System;
using HotelHome.room;
using System.Data;

namespace HotelHome.Command
{
	/// <summary>
	/// Business 的摘要说明。
	/// </summary>
	public class Business
	{
		public Business()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static int getDays(DateTime beginDate,DateTime endDate)
		{
			TimeSpan ts=endDate-beginDate;
			int days=ts.Days;
			if(days==0)
				days=1;
			return days;
		}
		public static bool query(DateTime startDate,DateTime endDate,roomDTO roomdto,int i_num,string guid)
		{
			DataSet ds3;
			DBService dbs=new DBService();
			int minNum=0;
			int totalPrice=0;
			string roomID=roomdto.roomID.ToString();
			bool available=false;
			int days=getDays(startDate,endDate);
			String selectSQL;
			for(int i=0;i<days;i++)
			{
				int price=0;
				int useNum=0;
				int i_leftNum=0;
				DateTime dtTmp=startDate.Add(new TimeSpan(i,0,0,0,0));
				String sel_SQL="select inuseNumber from inuseroom where roomID='"+roomID+"' and resDate='" +dtTmp  + "'";
				ds3=dbs.executeBySQL(sel_SQL);
				if(ds3.Tables[0].Rows.Count>0)
				{
					useNum=Convert.ToInt32(ds3.Tables[0].Rows[0][0]==DBNull.Value?"0":ds3.Tables[0].Rows[0][0]);
				}
				else
				{
					useNum=0;
				}
				selectSQL="select roomnum,price from roomavailable where roomID=" +roomID + " and begindate<='"+dtTmp+"' and enddate>='"+dtTmp+"' order by lastupdate desc";
				ds3=dbs.executeBySQL(selectSQL);
				if(ds3.Tables[0].Rows.Count==0)
				{
					available=false;
				}
				foreach(DataRow dr in ds3.Tables[0].Rows)
				{
					i_leftNum=Convert.ToInt32(dr[0]==DBNull.Value?"0":dr[0])-useNum;
					price=Convert.ToInt32(dr[1]==DBNull.Value?"0":dr[1]);
					if(i_num<=i_leftNum)
					{
						available=true;
						if(minNum==0)
						{
							minNum=i_leftNum;
						}
						else
						{
							minNum=minNum<i_leftNum?minNum:i_leftNum;
						}
						break;
					}
					else
					{
						available=false;
					}
				}
				if(available==false)
				{
					break;
				}	
				selectSQL="insert into querydetail (roomid,bookdate,price,leftNum,guid) values ("+roomID.ToString()+
						",'"+dtTmp.ToString()+"',"+price.ToString()+","+i_leftNum.ToString()+",'"+guid.ToString()+"')";
				dbs.ExecuteNonQuery(selectSQL);
				totalPrice+=price;
			}
			roomdto.leftNum=minNum;
			roomdto.Price=totalPrice;
			return available;
		}
	}
}