CheckInManage.cs ( File view )

  • By 洒脱 2014-10-28
  • View(s):73
  • Download(s):1
  • Point(s): 1
			using System;
using System.Data;
using System.Data.SqlClient;


namespace HotelManage
{

	/// <summary>
	/// ClientCheckManage 的摘要说明。
	/// </summary>
	public class CheckInManage
	{

		private string selectStr;
		private SqlCommand sqlCommand1=null;
		private SqlCommand sqlCommand2=null;
		//private SqlDataReader sqlDataReader1=null;
		private SqlConnection sqlConnection1;

		public CheckInManage()
		{

			this.sqlConnection1=new SqlConnection(HotelManage.util.Connection.ConnString);
			this.sqlCommand1=new SqlCommand();			
			this.sqlCommand1.CommandType=CommandType.Text;
			this.sqlCommand1.Connection=this.sqlConnection1;	
			this.sqlCommand2=new SqlCommand();
			this.sqlCommand2.CommandType=CommandType.StoredProcedure;
			this.sqlCommand2.Connection=this.sqlConnection1;
			//
			// TODO: 在此处添加构造函数逻辑
			//
		
}

		public bool ClientCheck(string CustomerID,string roomID,string OrderDate,float totalMoney)
		{

			this.selectStr="update CustomerRecord set TotalMoney="+totalMoney+",CheckDate="+"'"+System.DateTime.Now.Date.ToString()+"'"+" where CustomerID="+"'"+CustomerID+"'";
			this.sqlCommand1.CommandText=this.selectStr;
			try
			{

				if(this.sqlConnection1.State==ConnectionState.Closed)this.sqlConnection1.Open();
				this.sqlCommand1.ExecuteNonQuery();
				this.RoomPeopleNum_Minus(roomID);
				return true;
			
}
			catch(System.Exception E)
			{

				Console.WriteLine(E.ToString());
				return false;
			
}
			finally
			{
				
				this.sqlConnection1.Close();
			
}
		
}

		private  void RoomPeopleNum_Minus(string roomID)
		{

			this.sqlCommand2.CommandText="dbo.ProcedureMinusCustomer";
			this.sqlCommand2.Parameters.Add(new SqlParameter("@roomID",SqlDbType.Char,4));
			this.sqlCommand2.Parameters["@roomID"].Value=roomID;
			try
			{

				if(this.sqlConnection1.State==ConnectionState.Closed)this.sqlConnection1.Open();
				this.sqlCommand2.ExecuteNonQuery();
			
}
			catch(Exception E)
			{

				Console.WriteLine(E.ToString());
			
			
}
			finally
			{

				this.sqlConnection1.Close();
			
}			
		
}
	
}

}
			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 1

Download
0 lines left, continue to read
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
HotelManage.sql13.44 kB13-04-06 23:08
Help.chm11.05 kB01-07-07 20:19
Help.html944.00 B01-07-07 00:02
0005.gif1.33 kB12-04-04 23:13
App.ico1.05 kB26-06-07 07:41
AssemblyInfo.cs1.82 kB05-03-04 19:46
Help.chm11.05 kB01-07-07 20:35
HotelManage.exe260.00 kB04-07-07 14:56
HotelManage.pdb141.50 kB04-07-07 14:56
CheckInForm.cs7.34 kB03-07-07 18:45
CheckInForm.resx11.77 kB30-06-07 22:19
CheckInManage.cs2.18 kB03-07-07 15:42
HotelManage.sql13.44 kB13-04-06 23:08
GuesterFindForm.cs11.26 kB02-07-07 23:16
GuesterFindForm.resx13.39 kB30-06-07 22:20
App.ico1.05 kB26-06-07 07:41
AssemblyInfo.cs1.82 kB05-03-04 19:46
HotelManage.exe144.00 kB06-05-06 19:30
HotelManage.pdb91.50 kB06-05-06 19:30
CheckInForm.cs7.21 kB13-04-06 20:40
CheckInForm.resx11.77 kB13-04-06 20:40
CheckInManage.cs2.07 kB03-04-06 09:01
GuesterFindForm.cs10.93 kB06-05-06 19:35
GuesterFindForm.resx13.39 kB06-05-06 19:35
HotelManage.csproj8.31 kB13-04-06 22:44
HotelManage.csproj.user1.76 kB06-05-06 19:35
HotelManage.sln919.00 B05-03-04 19:46
HotelManage.suo13.00 kB03-04-06 07:49
MainForm.cs13.75 kB06-05-06 19:35
MainForm.resx23.08 kB15-04-06 00:33
HotelManage.CheckInForm.resources8.33 kB14-04-06 11:32
HotelManage.exe144.00 kB06-05-06 19:30
HotelManage.GuesterFindForm.resources9.70 kB15-04-06 18:38
HotelManage.MainForm.resources18.43 kB15-04-06 00:34
HotelManage.OrderForm.resources12.52 kB15-04-06 16:23
HotelManage.pdb91.50 kB06-05-06 19:30
HotelManage.projdata42.88 kB06-05-06 19:35
HotelManage.RoomFindForm.resources13.63 kB15-04-06 18:38
HotelManage.RoomManageForm.resources12.47 kB15-04-06 18:38
HotelManage.RoomTypeForm.resources11.97 kB15-04-06 18:38
OrderForm.cs11.92 kB15-04-06 16:23
OrderForm.resx16.20 kB15-04-06 16:15
OrderManage.cs3.18 kB06-04-06 21:29
RoomFindForm.cs16.38 kB06-05-06 19:35
RoomFindForm.resx17.34 kB06-05-06 19:35
RoomManage.cs2.50 kB03-04-06 09:01
RoomManageForm.cs15.47 kB06-05-06 19:35
RoomManageForm.resx16.18 kB06-05-06 19:35
RoomTypeForm.cs12.98 kB06-05-06 19:35
RoomTypeForm.resx15.64 kB06-05-06 19:35
RoomTypeManage.cs2.33 kB06-05-06 19:35
UserManageForm.resx14.58 kB13-04-06 22:42
Connection.cs324.00 B03-04-06 08:15
HotelManage.csproj11.91 kB01-07-07 21:56
HotelManage.csproj.user1.76 kB04-07-07 15:27
HotelManage.sln919.00 B05-03-04 19:46
HotelManage.suo19.00 kB06-05-06 19:35
cacular.BMP2.05 kB26-05-98 05:08
close.BMP358.00 B26-05-98 05:08
describ.BMP382.00 B25-04-98 03:58
drop.BMP1.29 kB25-04-98 03:58
end.BMP358.00 B26-05-98 05:08
expense.BMP382.00 B25-04-98 03:58
last.BMP358.00 B26-05-98 05:08
leave.BMP382.00 B25-04-98 03:58
modify.BMP2.05 kB26-05-98 05:08
NEW.BMP1.29 kB25-04-98 03:58
next.BMP358.00 B26-05-98 05:08
PREVIEW.BMP1.29 kB25-04-98 03:58
PRINT.BMP1.29 kB25-04-98 03:58
quit.BMP382.00 B25-04-98 03:58
reach.BMP382.00 B25-04-98 03:58
research.BMP238.00 B26-05-98 05:08
reserve.BMP382.00 B25-04-98 03:58
SAVE.BMP1.29 kB25-04-98 03:58
start.BMP358.00 B26-05-98 05:08
status.BMP382.00 B25-04-98 03:58
type.BMP382.00 B25-04-98 03:58
update.BMP382.00 B25-04-98 03:58
WZUNDO.BMP358.00 B26-05-98 05:08
Login.jpg38.82 kB21-06-07 10:24
LoginForm.cs6.35 kB03-07-07 15:48
LoginForm.resx68.92 kB01-07-07 09:36
MainForm.cs14.86 kB03-07-07 18:56
MainForm.jpg60.43 kB01-07-07 09:54
MainForm.resx113.85 kB01-07-07 20:32
HotelManage.CheckInForm.resources8.33 kB30-06-07 22:26
HotelManage.exe260.00 kB04-07-07 14:56
HotelManage.GuesterFindForm.resources9.70 kB30-06-07 22:26
HotelManage.LoginForm.resources45.99 kB01-07-07 09:36
HotelManage.MainForm.resources78.94 kB01-07-07 20:32
HotelManage.OrderForm.resources13.53 kB02-07-07 22:33
HotelManage.pdb141.50 kB04-07-07 14:56
HotelManage.projdata50.01 kB04-07-07 15:27
HotelManage.RoomFindForm.resources13.63 kB03-07-07 09:25
HotelManage.RoomManageForm.resources13.50 kB03-07-07 09:25
HotelManage.RoomTypeForm.resources12.99 kB02-07-07 22:30
OrderForm.cs13.38 kB03-07-07 18:39
OrderForm.resx17.29 kB02-07-07 22:33
OrderManage.cs3.25 kB02-07-07 23:04
RoomFindForm.cs17.94 kB03-07-07 18:50
RoomFindForm.resx17.34 kB03-07-07 09:24
RoomManage.cs2.56 kB02-07-07 21:33
RoomManageForm.cs18.81 kB03-07-07 09:24
RoomManageForm.resx17.28 kB03-07-07 09:24
RoomTypeForm.cs16.45 kB03-07-07 15:48
RoomTypeForm.resx16.73 kB02-07-07 15:48
RoomTypeManage.cs2.56 kB02-07-07 15:47
UserManageForm.resx14.58 kB13-04-06 22:42
Connection.cs320.00 B28-05-06 22:22
HotelManage.sln919.00 B30-06-07 23:40
HotelManage.suo13.00 kB04-07-07 15:27
cacular.BMP2.05 kB26-05-98 05:08
close.BMP358.00 B26-05-98 05:08
describ.BMP382.00 B25-04-98 03:58
drop.BMP1.29 kB25-04-98 03:58
end.BMP358.00 B26-05-98 05:08
expense.BMP382.00 B25-04-98 03:58
last.BMP358.00 B26-05-98 05:08
leave.BMP382.00 B25-04-98 03:58
modify.BMP2.05 kB26-05-98 05:08
NEW.BMP1.29 kB25-04-98 03:58
next.BMP358.00 B26-05-98 05:08
PREVIEW.BMP1.29 kB25-04-98 03:58
PRINT.BMP1.29 kB25-04-98 03:58
quit.BMP382.00 B25-04-98 03:58
reach.BMP382.00 B25-04-98 03:58
research.BMP238.00 B26-05-98 05:08
reserve.BMP382.00 B25-04-98 03:58
SAVE.BMP1.29 kB25-04-98 03:58
start.BMP358.00 B26-05-98 05:08
status.BMP382.00 B25-04-98 03:58
Thumbs.db14.00 kB15-09-09 22:07
type.BMP382.00 B25-04-98 03:58
update.BMP382.00 B25-04-98 03:58
WZUNDO.BMP358.00 B26-05-98 05:08
readme.txt199.00 B26-06-07 07:37
HotelManage.sql13.44 kB13-04-06 23:08
<temp>0.00 B25-07-09 17:00
<TempPE>0.00 B25-07-09 17:00
<Debug>0.00 B25-07-09 17:00
<Debug>0.00 B25-07-09 17:00
<temp>0.00 B25-07-09 17:00
<TempPE>0.00 B25-07-09 17:00
<Debug>0.00 B25-07-09 17:00
<bin>0.00 B25-07-09 17:00
<obj>0.00 B25-07-09 17:00
<util>0.00 B25-07-09 17:00
<Debug>0.00 B25-07-09 17:00
<bin>0.00 B25-07-09 17:00
<DataBase>0.00 B25-07-09 17:00
<HotelManage>0.00 B25-07-09 17:00
<Ico>0.00 B25-07-09 17:00
<obj>0.00 B25-07-09 17:00
<util>0.00 B25-07-09 17:00
<DataBase>0.00 B25-07-09 17:00
<HotelManage>0.00 B25-07-09 17:00
<Ico>0.00 B15-09-09 22:07
<HotelManage>0.00 B25-07-09 17:00
<系统代码>0.00 B25-07-09 17:00
...
Sponsored links

CheckInManage.cs (740.91 kB)

Need 1 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D