managerdel.aspx.cs

学生公寓管理系统使用说明： 1.服务器运行环境 SQL 2000 .NET FRAMEWORK 1.1 .NET FRAMEWORK 1.1 CHINESE (SIMPL

			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=\"BBS-HZ0752-NET\";packet size=4096;integrated security=SSPI;data so" +
				"urce=\"BBS-HZ0752-NET\";persist security info=False;initial catalog=student";
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO Manager(Manager_UserName, Manager_Name, Manager_Age, Manager_Sex, Manager_Tel, Floor_ID) VALUES (@Manager_UserName, @Manager_Name, @Manager_Age, @Manager_Sex, @Manager_Tel, @Floor_ID); SELECT Manager_UserName, Manager_Name, Manager_Age, Manager_Sex, Manager_Tel, Floor_ID FROM Manager WHERE (Manager_UserName = @Manager_UserName)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_UserName", System.Data.SqlDbType.VarChar, 20, "Manager_UserName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Name", System.Data.SqlDbType.VarChar, 8, "Manager_Name"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Age", System.Data.SqlDbType.Int, 4, "Manager_Age"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Sex", System.Data.SqlDbType.VarChar, 2, "Manager_Sex"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Tel", System.Data.SqlDbType.BigInt, 8, "Manager_Tel"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Floor_ID", System.Data.SqlDbType.SmallInt, 2, "Floor_ID"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT Manager_UserName, Manager_Name, Manager_Age, Manager_Sex, Manager_Tel, Flo" +
				"or_ID FROM Manager";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE Manager SET Manager_UserName = @Manager_UserName, Manager_Name = @Manager_Name, Manager_Age = @Manager_Age, Manager_Sex = @Manager_Sex, Manager_Tel = @Manager_Tel, Floor_ID = @Floor_ID WHERE (Manager_UserName = @Original_Manager_UserName) AND (Floor_ID = @Original_Floor_ID OR @Original_Floor_ID IS NULL AND Floor_ID IS NULL) AND (Manager_Age = @Original_Manager_Age OR @Original_Manager_Age IS NULL AND Manager_Age IS NULL) AND (Manager_Name = @Original_Manager_Name) AND (Manager_Sex = @Original_Manager_Sex) AND (Manager_Tel = @Original_Manager_Tel OR @Original_Manager_Tel IS NULL AND Manager_Tel IS NULL); SELECT Manager_UserName, Manager_Name, Manager_Age, Manager_Sex, Manager_Tel, Floor_ID FROM Manager WHERE (Manager_UserName = @Manager_UserName)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_UserName", System.Data.SqlDbType.VarChar, 20, "Manager_UserName"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Name", System.Data.SqlDbType.VarChar, 8, "Manager_Name"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Age", System.Data.SqlDbType.Int, 4, "Manager_Age"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Sex", System.Data.SqlDbType.VarChar, 2, "Manager_Sex"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Manager_Tel", System.Data.SqlDbType.BigInt, 8, "Manager_Tel"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Floor_ID", System.Data.SqlDbType.SmallInt, 2, "Floor_ID"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Manager_UserName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Manager_UserName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Floor_ID", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Floor_ID", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Manager_Age", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Manager_Age", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Manager_Name", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Manager_Name", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Manager_Sex", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Manager_Sex", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Manager_Tel", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Manager_Tel", System.Data.DataRowVersion.Original, null));
			// 
			// dataSet12
			// 
			this.dataSet12.DataSetName = "DataSet1";
			this.dataSet12.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet12)).EndInit();

		}
		#endregion

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid1.CurrentPageIndex = e.NewPageIndex;
			if(this.TextBox1.Text!="")
				Grid_Bind();
			else if(this.TextBox1.Text=="")
				Data_Bind();
		}

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(DataGrid1.Items.Count==1)
			{
				if(DataGrid1.CurrentPageIndex!=0)
				{
					DataGrid1.CurrentPageIndex=DataGrid1.CurrentPageIndex-1;
				}
			}
			else
			{	
				string SqlStr1="delete Manager  where Manager_UserName='"+e.Item.Cells[0].Text+"'";
				myConn=System.Configuration.ConfigurationSettings.AppSettings["mySql"];
				conn=new System.Data.SqlClient.SqlConnection(myConn);
				conn.Open();
				cmd=new System.Data.SqlClient.SqlCommand(SqlStr1,conn);
				cmd.ExecuteNonQuery();
				conn.Close();
				Response.Write("<script>alert('删除成功！')</script>");
				if(this.TextBox1.Text!="")
					Grid_Bind();
				else if(this.TextBox1.Text=="")
					Data_Bind();
			}
		
			
		}
	

		

		private void Search_Click(object sender, System.EventArgs e)
		{
			this.DataGrid1.CurrentPageIndex=0;
			string s;
			s=this.DropDownList1.SelectedValue.ToString()+"="+"'"+this.TextBox1.Text+"'";
			this.myConn=ConfigurationSettings.AppSettings["mySql"];
			this.conn=new System.Data.SqlClient.SqlConnection(myConn);
			try
			{
				if(this.TextBox1.Text!="")
				{
					cmdText="select * from Manager where ";
					cmdText=cmdText+s;
					this.sqlConnection1=new System.Data.SqlClient.SqlConnection(myConn);
					this.sqlConnection1.Open();
					this.sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter(cmdText,this.sqlConnection1);
			
					this.dataSet11=new DataSet1();
					this.sqlDataAdapter1.Fill(this.dataSet11,"Manager");
					this.DataGrid1.DataSource=this.dataSet11;
					this.DataGrid1.DataBind();
					this.sqlConnection1.Close();

				}
				else 
				{
					Response.Write("<script>alert('请输入查询条件！')</script>");
					Data_Bind();
				}
			}
			catch(Exception ex)
			{	
				
				Response.Write("<script>alert('"+ex.Message+"查询条件格式错误！')</script>");
				Data_Bind();
			}
		}
	}
}