RoomTypeManage.cs ( File view )

  • By 洒脱 2014-10-28
  • View(s):73
  • Download(s):1
  • Point(s): 1
			using System;                                 //roomtypemanage 是业务逻辑层,即业务逻辑处理类,主要用来实现数据库交互
using System.Data;
using System.Data.SqlClient;


namespace HotelManage
{

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

		private SqlConnection sqlConnection1=null;
		private SqlCommand sqlCommand1=null;
		//private SqlDataReader sqlDataReader1=null;
		private string selectStr=null;
	 
		
		public RoomTypeManage()
		{

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

		public void RoomType_Add(string typename,int area,int bednum,float price,int telephone,int tv,int HasToilet,int aircondition)
		{

			this.selectStr="insert into RoomType values("+"'"+typename+"',"+area+","+bednum+","+price+","+aircondition+","+telephone+","+tv+","+HasToilet+")";
			this.sqlCommand1.CommandText=this.selectStr;   //添加数据记录
			try
			{

				this.sqlConnection1.Open();  //与数据库建立连接
				this.sqlCommand1.ExecuteNonQuery();				
			
}
			catch(System.Exception E)  //应用程序在执行时发生错误
			{

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

				this.sqlConnection1.Close();    //连接断开
			
}

		
}
		
		public void Room_Delete(string roomID)    //删除
		{

			this.selectStr="delete from Room where RoomID="+roomID;   //删除数据记录
			this.sqlCommand1.CommandText=this.selectStr;
			try
			{

				this.sqlConnection1.Open();
				this.sqlCommand1.ExecuteNonQuery();				
			
}
			catch(System.Exception E)
			{

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

				this.sqlConnection1.Close();
			
}
		
}
		
		public bool Room_Modify(string typename,int area,int bednum,float price,int telephone,int tv,int HasToilet,int aircondition)
		{
   //修改
			this.selectStr="update RoomType set Area="+area+","+"BedNum="+bednum+","+"Price="+price+","+"HasToilet="+HasToilet+","+"AirCondition="+aircondition+","+"HasTelevision="+tv+","+"HasPhone="+telephone+" where RoomTypeName="+"'"+typename+"'";
			this.sqlCommand1.CommandText=this.selectStr;   //修改数据记录
			try
			{

				this.sqlConnection1.Open();
				this.sqlCommand1.ExecuteNonQuery();				
				return true;
			
}
			catch(System.Exception E)
			{

				Console.WriteLine(E.ToString());
				return false;
			
}
			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

RoomTypeManage.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