opermana.cs

此为本人和同学所开发的酒店管理系统.C#.net.也是软件工程课程的作业.

			this.buttdelete.Name = "buttdelete";
			this.buttdelete.Size = new System.Drawing.Size(48, 23);
			this.buttdelete.TabIndex = 4;
			this.buttdelete.Text = "删除";
			this.buttdelete.Click += new System.EventHandler(this.buttdelete_Click);
			// 
			// buttedit
			// 
			this.buttedit.Location = new System.Drawing.Point(104, 170);
			this.buttedit.Name = "buttedit";
			this.buttedit.Size = new System.Drawing.Size(48, 23);
			this.buttedit.TabIndex = 4;
			this.buttedit.Text = "修改";
			this.buttedit.Click += new System.EventHandler(this.buttedit_Click);
			// 
			// buttsave
			// 
			this.buttsave.Location = new System.Drawing.Point(176, 170);
			this.buttsave.Name = "buttsave";
			this.buttsave.Size = new System.Drawing.Size(48, 23);
			this.buttsave.TabIndex = 4;
			this.buttsave.Text = "保存";
			this.buttsave.Click += new System.EventHandler(this.buttsave_Click);
			// 
			// buttcancer
			// 
			this.buttcancer.Location = new System.Drawing.Point(224, 170);
			this.buttcancer.Name = "buttcancer";
			this.buttcancer.Size = new System.Drawing.Size(48, 23);
			this.buttcancer.TabIndex = 4;
			this.buttcancer.Text = "返回";
			this.buttcancer.Click += new System.EventHandler(this.buttcancer_Click);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.tabControl1);
			this.groupBox1.Location = new System.Drawing.Point(8, 32);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(296, 248);
			this.groupBox1.TabIndex = 5;
			this.groupBox1.TabStop = false;
			// 
			// opermana
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(312, 336);
			this.ControlBox = false;
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.label3);
			this.Controls.Add(this.button1);
			this.MaximizeBox = false;
			this.MaximumSize = new System.Drawing.Size(320, 344);
			this.MinimizeBox = false;
			this.MinimumSize = new System.Drawing.Size(320, 344);
			this.Name = "opermana";
			this.ShowInTaskbar = false;
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "操作员管理";
			this.TopMost = true;
			this.Load += new System.EventHandler(this.opermana_Load);
			this.tabControl1.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			this.tabPage2.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void button1_Click(object sender, System.EventArgs e)
		{
			if(MessageBox.Show("真的要退出吗？","注意",MessageBoxButtons.OKCancel,MessageBoxIcon.Question)==DialogResult.OK)
				this.Close ();
		}

		private void opermana_Load(object sender, System.EventArgs e)
		{
			label3.Text ="操 作 员："+nam;

			cbbh.Visible =true;
			tbbh.Visible =false;

			tbxm.ReadOnly =true;
			tbmm.ReadOnly =true;
			tbbz.ReadOnly =true;
			

			
			if(pur!='1')
			{
				buttappend.Enabled =false;
				buttdelete.Enabled =false;
				buttedit.Enabled =false;
				buttsave.Enabled =false;
				buttcancer.Enabled =false;

				cbbh.Enabled =false;
				cbjb.Enabled=false;
			}
			else
			{
				buttappend.Enabled =true;
				buttdelete.Enabled =true;
				buttedit.Enabled =true;
				buttsave.Enabled =true;
				buttcancer.Enabled =true;
				
				

				string str=dc.connstr ;
				SqlConnection conn=new SqlConnection (str);
				string sql="select 操作员编号 from tabpurview";
				SqlDataAdapter adapter=new SqlDataAdapter (sql,conn);
				DataSet dataset=new DataSet ();
				adapter.Fill (dataset,"tab");
				
				cbbh.DisplayMember ="操作员编号";
				cbbh.DataSource =dataset.Tables ["tab"];

				conn.Dispose ();
				dataset.Dispose ();
				adapter.Dispose ();
			}
			
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			textBox1 .Text ="";
			textBox2.Text ="";
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			if(textBox1.Text ==textBox2.Text )
			{
				string str=dc.connstr ;
				SqlConnection conn=new SqlConnection (str);
				string sql="update tabpurview set 密码='"+textBox1.Text +"' where 操作员姓名='"+nam+"'";
				SqlCommand cmd=new SqlCommand (sql,conn);
				conn.Open ();
				cmd.ExecuteNonQuery ();
				MessageBox.Show ("操作成功！");
				conn.Close ();
				cmd.Dispose ();
			}
			else
			{
				MessageBox.Show ("您两次输入的密码不一致，请重新输入！");
			}
		}

		private void buttappend_Click(object sender, System.EventArgs e)
		{
			opernum=1;
			buttdelete.Enabled =false;
			buttedit.Enabled =false;
			cbbh.Visible =false;
			tbbh.Visible =true;

			tbxm.ReadOnly =false;
			tbmm.ReadOnly =false;
			tbbz.ReadOnly =false;

			string str=dc.connstr ;
			SqlConnection conn=new SqlConnection (str);
			string sql="select 操作员编号 from tabpurview";
			SqlDataAdapter adapter=new SqlDataAdapter (sql,conn);
			DataSet dataset=new DataSet ();
			adapter.Fill (dataset,"tab");
				
			cbbh.DisplayMember ="操作员编号";
			cbbh.DataSource =dataset.Tables ["tab"];

			conn.Dispose ();
			dataset.Dispose ();
			adapter.Dispose ();

			int cou=dataset.Tables ["tab"].Rows .Count ;
			cou++;

			tbbh.Text ="CZY"+cou.ToString ("d5");
			//防止编号重复
			for(int i=0;i<cou-1;i++)
			{
				cbbh.SelectedIndex=i;
				if(cbbh.Text ==tbbh.Text)
				{
					int a=cou+1;
					tbbh.Text ="CZY"+a.ToString ("d5");
				}
			}
			tbbz.Text ="";
			tbxm.Text ="";
			tbmm.Text ="";
			cbjb.SelectedIndex =-1;//为空

		}

		private void buttcancer_Click(object sender, System.EventArgs e)
		{
			cbbh.Visible =true;
			tbbh.Visible =false;

			cbbh.SelectedIndex =-1;
			tbxm.Text ="";
			tbmm.Text ="";
			cbjb.SelectedIndex =-1;
			tbbz.Text ="";

			tbxm.ReadOnly =true;
			tbmm.ReadOnly =true;
			tbbz.ReadOnly =true;

			buttappend.Enabled =true;
			buttdelete.Enabled =true;
			buttedit.Enabled =true;

			//刷新
			string str=dc.connstr ;
			SqlConnection conn=new SqlConnection (str);
			string sql="select 操作员编号 from tabpurview";
			SqlDataAdapter adapter=new SqlDataAdapter (sql,conn);
			DataSet dataset=new DataSet ();
			adapter.Fill (dataset,"tab");
				
			cbbh.DisplayMember ="操作员编号";
			cbbh.DataSource =dataset.Tables ["tab"];

			conn.Dispose ();
			dataset.Dispose ();
			adapter.Dispose ();
		}

		private void buttdelete_Click(object sender, System.EventArgs e)
		{
			opernum=2;
			buttappend.Enabled =false;
			buttedit.Enabled =false;
		}

		private void buttedit_Click(object sender, System.EventArgs e)
		{
			opernum=3;
			buttappend.Enabled =false;
			buttdelete.Enabled =false;

			tbxm.ReadOnly =false;
			tbmm.ReadOnly =false;
			tbbz.ReadOnly =false;
		}

		private void buttsave_Click(object sender, System.EventArgs e)
		{
			string str=dc.connstr ;
			SqlConnection conn=new SqlConnection (str);
			//添加
			if(opernum==1)
			{
				

				string sql="insert into tabpurview values(";
				sql=sql+"'"+tbbh.Text +"',";
				sql=sql+"'"+tbxm.Text +"',";
				sql=sql+"'"+tbmm.Text +"',";
				sql=sql+"'"+cbjb.Text +"',";
				sql=sql+"'"+tbbz.Text +"')";

				SqlCommand cmd=new SqlCommand (sql,conn);

				if(tbxm.Text .Length >0&tbmm.Text .Length >0&cbjb.Text .Length >0)
				{
					conn.Open ();
					cmd.ExecuteNonQuery ();
					MessageBox.Show ("操作成功！","恭喜",MessageBoxButtons.OK ,MessageBoxIcon.Information);
				}
				else
				{
					MessageBox.Show ("您的输入有误，请仔细检查，重新输入！","注意",MessageBoxButtons.OK ,MessageBoxIcon.Error );
				}
				
				cmd.Dispose ();
				conn.Close ();

			}
			//删除
			if(opernum==2)
			{
				string sql="delete tabpurview where 操作员编号='"+cbbh.Text  +"'";
				SqlCommand cmd=new SqlCommand (sql,conn);
				if(MessageBox.Show("真的要删除吗？","注意",MessageBoxButtons.OKCancel,MessageBoxIcon.Question)==DialogResult.OK)
				{
					conn.Open ();
					cmd.ExecuteNonQuery ();
					MessageBox.Show ("操作成功！","恭喜",MessageBoxButtons.OK ,MessageBoxIcon.Information);
					
					string sql1="select 操作员编号 from tabpurview";
					SqlDataAdapter adapter=new SqlDataAdapter (sql1,conn);
					DataSet dataset=new DataSet ();
					adapter.Fill (dataset,"tab");
					cbbh.DisplayMember ="房间号";
					cbbh.DataSource =dataset.Tables ["tab"];

					dataset.Dispose ();
					adapter.Dispose ();
				}

				cmd.Dispose ();
				conn.Close ();
			}
			//修改
			if(opernum==3)
			{
				string sql="update tabpurview set 操作员姓名='"+tbxm.Text +"',密码='"+tbmm.Text +"',权限级别='"+cbjb.Text +"',备注='"+tbbz.Text +"' where 操作员编号='"+cbbh.Text +"'";
				SqlCommand cmd=new SqlCommand (sql,conn);
				if(MessageBox.Show("真的所做的修改吗？","注意",MessageBoxButtons.OKCancel,MessageBoxIcon.Question)==DialogResult.OK)
				{
					conn.Open ();
					cmd.ExecuteNonQuery ();
					MessageBox.Show ("操作成功！","恭喜",MessageBoxButtons.OK ,MessageBoxIcon.Information);
				}

				cmd.Dispose ();
				conn.Close ();
			}
		}

		private void cbbh_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string str=dc.connstr ;
			SqlConnection conn=new SqlConnection (str);
			string sql="select * from tabpurview where 操作员编号='"+this.cbbh .Text +"'";
			SqlDataAdapter adapter=new SqlDataAdapter (sql,conn);
			DataSet dataset=new DataSet ();
			adapter.Fill (dataset,"tab");

			tbxm .DataBindings.Add (new Binding ("Text",dataset,"tab.操作员姓名"));
			tbmm .DataBindings.Add (new Binding ("Text",dataset,"tab.密码"));
			cbjb .DataBindings.Add (new Binding ("Text",dataset,"tab.权限级别"));
			tbbz .DataBindings.Add (new Binding ("Text",dataset,"tab.备注"));

			tbxm.DataBindings .Clear ();
			tbmm.DataBindings .Clear ();
			cbjb.DataBindings .Clear ();
			tbbz.DataBindings .Clear ();

			conn.Dispose ();
			dataset.Dispose ();
			adapter.Dispose ();
		}


	}
}