RoomFindForm.cs ( File view )

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

namespace HotelManage
{

	/// <summary>
	/// RoomSearch 的摘要说明。
	/// </summary>
	public class RoomFindForm : System.Windows.Forms.Form
	{

		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox textRoomID;
		private System.Windows.Forms.Button btnExit;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Button btnSearch;
		private System.Windows.Forms.TextBox textRemark;

		private string selectStr;
		private DataSet ds=null;
		private SqlCommand sqlCommand1=null;
		private SqlDataReader sqlDataReader1=null;
		private SqlConnection sqlConnection1;
		private System.Windows.Forms.ComboBox comboRoomType;
		private System.Windows.Forms.ComboBox comboRoomPosition;
		private System.Windows.Forms.ComboBox comboPeopleNum;
		private System.Windows.Forms.ComboBox comboFactPeopleNum;
		private System.Windows.Forms.Button btnEmptyRoom;
		private System.Windows.Forms.Button btnNotFull;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.Button button1;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public RoomFindForm()
		{

			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();   //初始你的控件的初始值,初始化组件,每拖动一个控件,属性值等自动放在这个方法里
			this.sqlConnection1=new SqlConnection(HotelManage.util.Connection.ConnString);
			this.sqlCommand1=new SqlCommand();
			this.sqlCommand1.Connection=this.sqlConnection1;


			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		
}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{

			if( disposing )
			{

				if(components != null)
				{

					components.Dispose();
				
}
			
}
			base.Dispose( disposing );
		
}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{

			this.label5 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.textRoomID = new System.Windows.Forms.TextBox();
			this.btnEmptyRoom = new System.Windows.Forms.Button();
			this.btnSearch = new System.Windows.Forms.Button();
			this.btnExit = new System.Windows.Forms.Button();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.button1 = new System.Windows.Forms.Button();
			this.comboFactPeopleNum = new System.Windows.Forms.ComboBox();
			this.comboPeopleNum = new System.Windows.Forms.ComboBox();
			this.comboRoomPosition = new System.Windows.Forms.ComboBox();
			this.comboRoomType = new System.Windows.Forms.ComboBox();
			this.textRemark = new System.Windows.Forms.TextBox();
			this.btnNotFull = new System.Windows.Forms.Button();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.groupBox1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.SuspendLayout();
			// 
			// label5
			// 
			this.label5.BackColor = System.Drawing.Color.Transparent;
			this.label5.Location = new System.Drawing.Point(16, 88);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(56, 25);
			this.label5.TabIndex = 11;
			this.label5.Text = "其他条件";
			this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label4
			// 
			this.label4.BackColor = System.Drawing.Color.Transparent;
			this.label4.Location = new System.Drawing.Point(144, 56);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(56, 25);
			this.label4.TabIndex = 10;
			this.label4.Text = "实际人数";
			this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label3
			// 
			this.label3.BackColor = System.Drawing.Color.Transparent;
			this.label3.Location = new System.Drawing.Point(16, 56);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(60, 25);
			this.label3.TabIndex = 9;
			this.label3.Text = "额定人数";
			this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label6
			// 
			this.label6.BackColor = System.Drawing.Color.Transparent;
			this.label6.Location = new System.Drawing.Point(296, 24);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(60, 25);
			this.label6.TabIndex = 6;
			this.label6.Text = "房间楼层";
			this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label2
			// 
			this.label2.BackColor = System.Drawing.Color.Transparent;
			this.label2.Location = new System.Drawing.Point(144, 24);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(56, 25);
			this.label2.TabIndex = 2;
			this.label2.Text = "房间类型";
			this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label1
			// 
			this.label1.BackColor = System.Drawing.Color.Transparent;
			this.label1.Location = new System.Drawing.Point(16, 24);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(48, 25);
			this.label1.TabIndex = 1;
			this.label1.Text = "房间号";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// textRoomID
			// 
			this.textRoomID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.textRoomID.Location = new System.Drawing.Point(72, 24);
			this.textRoomID.Multiline = true;
			this.textRoomID.Name = "textRoomID";
			this.textRoomID.Size = new System.Drawing.Size(68, 20);
			this.textRoomID.TabIndex = 0;
			this.textRoomID.Text = "";
			// 
			// btnEmptyRoom
			// 
			this.btnEmptyRoom.BackColor = System.Drawing.Color.Transparent;
			this.btnEmptyRoom.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.btnEmptyRoom.ForeColor = System.Drawing.SystemColors.Desktop;
			this.btnEmptyRoom.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnEmptyRoom.Location = new System.Drawing.Point(304, 88);
			this.btnEmptyRoom.Name = "btnEmptyRoom";
			this.btnEmptyRoom.Size = new System.Drawing.Size(120, 24);
			this.btnEmptyRoom.TabIndex = 22;
			this.btnEmptyRoom.Text = "空房";
			this.btnEmptyRoom.Click += new System.EventHandler(this.btnEmptyRoom_Click);
			// 
			// btnSearch
			// 
			this.btnSearch.BackColor = System.Drawing.Color.Transparent;
			this.btnSearch.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.btnSearch.ForeColor = System.Drawing.SystemColors.Desktop;
			this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnSearch.Location = new System.Drawing.Point(304, 56);
			this.btnSearch.Name = "btnSearch";
			this.btnSearch.Size = new System.Drawing.Size(120, 24);
			this.btnSearch.TabIndex = 20;
			this.btnSearch.Text = "查找";
			this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
			// 
			// btnExit
			// 
			this.btnExit.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.btnExit.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnExit.Location = new System.Drawing.Point(440, 88);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(120, 23);
			this.btnExit.TabIndex = 15;
			this.btnExit.Text = "退出";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.button1);
			this.groupBox1.Controls.Add(this.comboFactPeopleNum);
			this.groupBox1.Controls.Add(this.comboPeopleNum);
			this.groupBox1.Controls.Add(this.comboRoomPosition);
			this.groupBox1.Controls.Add(this.comboRoomType);
			this.groupBox1.Controls.Add(this.textRemark);
			this.groupBox1.Controls.Add(this.label5);
			this.groupBox1.Controls.Add(this.label4);
			this.groupBox1.Controls.Add(this.label3);
			this.groupBox1.Controls.Add(this.label6);
			this.groupBox1.Controls.Add(this.label2);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Controls.Add(this.textRoomID);
			this.groupBox1.Controls.Add(this.btnExit);
			this.groupBox1.Controls.Add(this.btnSearch);
			this.groupBox1.Controls.Add(this.btnEmptyRoom);
			this.groupBox1.Controls.Add(this.btnNotFull);
			this.groupBox1.ForeColor = System.Drawing.SystemColors.Desktop;
			this.groupBox1.Location = new System.Drawing.Point(8, 16);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(568, 152);
			this.groupBox1.TabIndex = 20;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "输入查询条件";
			// 
			// button1
			// 
			this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.button1.Location = new System.Drawing.Point(304, 120);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(120, 24);
			this.button1.TabIndex = 24;
			this.button1.Text = "入住";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// comboFactPeopleNum
			// 
			this.comboFactPeopleNum.Items.AddRange(new object[] {

																	"0",
																	"1",
																	"2",
																	"3",
																	"4"
});
			this.comboFactPeopleNum.Location = new System.Drawing.Point(200, 56);
			this.comboFactPeopleNum.N
...
...
(Not finished, please download and read the complete file)
			
...
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

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