GuesterFindForm.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>
	/// Customer 的摘要说明。
	/// </summary>
	public class GuesterFindForm : System.Windows.Forms.Form
	{

		private string selectStr;
		private SqlCommand sqlCommand1=null;
		private SqlDataReader sqlDataReader1=null;
		private SqlConnection sqlConnection1;
		private DataSet ds= null;
		HotelManage.CheckInManage clientCheck=new HotelManage.CheckInManage();
		private System.Windows.Forms.GroupBox groupBox3;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox textClientID;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Button btnSearch;
		private System.Windows.Forms.Button btnEmptyRoom;
		private System.Windows.Forms.Button btnExit;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.Button button1;

		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public GuesterFindForm()
		{

			//
			// 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.groupBox3 = new System.Windows.Forms.GroupBox();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.label1 = new System.Windows.Forms.Label();
			this.textClientID = new System.Windows.Forms.TextBox();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.button1 = new System.Windows.Forms.Button();
			this.btnSearch = new System.Windows.Forms.Button();
			this.btnEmptyRoom = new System.Windows.Forms.Button();
			this.btnExit = new System.Windows.Forms.Button();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.groupBox3.SuspendLayout();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.SuspendLayout();
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.groupBox1);
			this.groupBox3.Controls.Add(this.groupBox2);
			this.groupBox3.Location = new System.Drawing.Point(8, 8);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(632, 80);
			this.groupBox3.TabIndex = 26;
			this.groupBox3.TabStop = false;
			// 
			// groupBox1
			// 
			this.groupBox1.BackColor = System.Drawing.SystemColors.Window;
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Controls.Add(this.textClientID);
			this.groupBox1.ForeColor = System.Drawing.SystemColors.ControlText;
			this.groupBox1.Location = new System.Drawing.Point(8, 16);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(232, 56);
			this.groupBox1.TabIndex = 23;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "输入查询条件";
			// 
			// label1
			// 
			this.label1.BackColor = System.Drawing.Color.White;
			this.label1.ForeColor = System.Drawing.SystemColors.ControlText;
			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;
			// 
			// textClientID
			// 
			this.textClientID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.textClientID.Location = new System.Drawing.Point(64, 24);
			this.textClientID.Multiline = true;
			this.textClientID.Name = "textClientID";
			this.textClientID.Size = new System.Drawing.Size(136, 20);
			this.textClientID.TabIndex = 0;
			this.textClientID.Text = "";
			// 
			// groupBox2
			// 
			this.groupBox2.BackColor = System.Drawing.SystemColors.Window;
			this.groupBox2.Controls.Add(this.button1);
			this.groupBox2.Controls.Add(this.btnSearch);
			this.groupBox2.Controls.Add(this.btnEmptyRoom);
			this.groupBox2.Controls.Add(this.btnExit);
			this.groupBox2.ForeColor = System.Drawing.SystemColors.WindowText;
			this.groupBox2.Location = new System.Drawing.Point(248, 16);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(360, 56);
			this.groupBox2.TabIndex = 25;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "请选择操作";
			// 
			// button1
			// 
			this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.button1.Location = new System.Drawing.Point(264, 24);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(64, 23);
			this.button1.TabIndex = 23;
			this.button1.Text = "结算";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// btnSearch
			// 
			this.btnSearch.BackColor = System.Drawing.SystemColors.Window;
			this.btnSearch.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnSearch.ForeColor = System.Drawing.SystemColors.InfoText;
			this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnSearch.Location = new System.Drawing.Point(40, 24);
			this.btnSearch.Name = "btnSearch";
			this.btnSearch.Size = new System.Drawing.Size(56, 24);
			this.btnSearch.TabIndex = 20;
			this.btnSearch.Text = "查找";
			this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
			// 
			// btnEmptyRoom
			// 
			this.btnEmptyRoom.BackColor = System.Drawing.SystemColors.Window;
			this.btnEmptyRoom.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnEmptyRoom.ForeColor = System.Drawing.SystemColors.InfoText;
			this.btnEmptyRoom.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnEmptyRoom.Location = new System.Drawing.Point(120, 24);
			this.btnEmptyRoom.Name = "btnEmptyRoom";
			this.btnEmptyRoom.Size = new System.Drawing.Size(56, 24);
			this.btnEmptyRoom.TabIndex = 22;
			this.btnEmptyRoom.Text = "全部";
			this.btnEmptyRoom.Click += new System.EventHandler(this.btnEmptyRoom_Click);
			// 
			// btnExit
			// 
			this.btnExit.BackColor = System.Drawing.SystemColors.Window;
			this.btnExit.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnExit.ForeColor = System.Drawing.SystemColors.InfoText;
			this.btnExit.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnExit.Location = new System.Drawing.Point(192, 24);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(56, 23);
			this.btnExit.TabIndex = 15;
			this.btnExit.Text = "退出";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// dataGrid1
			// 
			this.dataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.dataGrid1.BackgroundColor = System.Drawing.SystemColors.ActiveCaptionText;
			this.dataGrid1.CaptionVisible = false;
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(8, 96);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(632, 240);
			this.dataGrid1.TabIndex = 27;
			// 
			// GuesterFindForm
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.BackColor = System.Drawing.Color.AliceBlue;
			this.ClientSize = new System.Drawing.Size(642, 349);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.groupBox3);
			this.Name = "GuesterFindForm";
			this.Text = "客户记录查询";
			this.groupBox3.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.ResumeLayout(false);

		
}
		#endregion

		private void btnSearch_Click(object sender, System.EventArgs e)
		{

			if(this.textClientID.Text=="")
			{

				MessageBox.Show("请先输入客户号","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
			
}
			else
			{

				this.selectStr="select CustomerID 客户ID,CustomerName 客户姓名,RoomID 房间号,RoomTypeName 房间类型,Price 价钱,InDate 入住日期,CheckDate 结算日期,TotalMoney 总金额 from View1_CustomerRecord where CustomerID="+"'"+this.textClientID.Text+"'";			
				FillDataGrid(selectStr);
			
}
		  
		
		
}
		private void FillDataGrid(string sql)
		{

			if(this.sqlConnection1.State==ConnectionState.Closed)this.sqlConnection1.Open();
			
			Console.WriteLine(sql);
			SqlDataAdapter adapter = new SqlDataAdapter(sql,sqlConnection1);
			ds = new DataSet("t_user");
			adapter.Fill(ds,"t_user");
			this.dataGrid1.SetDataBinding(ds,"t_user");
		
}	
		

		private void btnExit_Click(object sender, System.EventArgs e)
		{

			this.Close();
		
}
	
		private void btnEmptyRoom_Click(object sender, System.EventArgs e)
		{

			this.selectStr="select CustomerID 客户ID,CustomerName 客户姓名,RoomID 房间号,RoomTypeName 房间类型,Price 价钱,InDate 入住日期,CheckDate 结算日期,TotalMoney 总金额 from View1_CustomerRecord";			
			thi
...
...
(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

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