roomsysmng.aspx.cs

房屋管理系统 房屋管理系统 房屋管理系统 房屋管理系统

					try
					{
						sqlcom="DELETE ["+datatable+"] WHERE ["+head+"]='"+((Label)oDataGridItem.FindControl("dLabel")).Text+"'";
						//定义命令对象
						OdbcCommand cmd = new OdbcCommand(sqlcom,conn);
						//执行SQL命令
						cmd.ExecuteNonQuery();	
					}
					catch(Exception err)
					{
						Label1.Text="外键约束，此数据项不能被删除！";
					}
				}
			}
			DataBindGrid(datatable,col);
			conn.Close();
		}

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("RoomUserMng.aspx");
		}

		private void LinkButton3_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("RoomDataMng.aspx");
		}

		private void LinkButton2_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("RoomSysMng.aspx");
		}

		private void LinkButton4_Click(object sender, System.EventArgs e)
		{
			
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="宽带";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="宽带";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vnet";
			Session["headname"]="编号";
			Session["colname"]="宽带";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataGrid1.CurrentPageIndex=0;
			DataBindGrid(datatable,col);
		}

		private void LinkButton5_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="电";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="电";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="velect";
			Session["headname"]="编号";
			Session["colname"]="电";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void LinkButton6_Click(object sender, System.EventArgs e)
		{			
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="水";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="水";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vwater";
			Session["headname"]="编号";
			Session["colname"]="水";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void LinkButton10_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("RoomBuildingInfoMng.aspx");
		}

		private void LinkButton7_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="性别";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="性别";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vsex";
			Session["headname"]="编号";
			Session["colname"]="性别";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void LinkButton8_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="用途";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="用途";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vusing";
			Session["headname"]="编号";
			Session["colname"]="用途";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void LinkButton9_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="单位";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="单位";
			TextBox1.Enabled=true;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vunit";
			Session["headname"]="编号";
			Session["colname"]="单位";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void LinkButton11_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="是否闲置";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="是否闲置";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vunused";
			Session["headname"]="编号";
			Session["colname"]="是否闲置";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void LinkButton12_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="电话";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="电话";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vphone";
			Session["headname"]="编号";
			Session["colname"]="电话";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			TextBox1.Text="";
			TextBox2.Text="";
		}

		private void Button4_Click(object sender, System.EventArgs e)
		{
			string tname,sqlcom;
			sqlcom="";
			tname=Session["tablename"].ToString();
			switch(tname)
			{
				case "vwater" :  sqlcom="insert into vwater(水)values('"+TextBox2.Text+"')"; break;
				case "vusing" :  sqlcom="insert into vusing(用途)values('"+TextBox2.Text+"')"; break;
				case "vunused" :  sqlcom="insert into vunused(是否闲置)values('"+TextBox2.Text+"')"; break;
				case "vunit" : sqlcom="insert into vunit(编号,单位)values('"+TextBox1.Text+"','"+TextBox2.Text+"')"; break;
				case "vsex" :  sqlcom="insert into vsex(性别)values('"+TextBox2.Text+"')"; break;
				case "vphone" :  sqlcom="insert into vphone(电话)values('"+TextBox2.Text+"')"; break;
				case "vnet" :  sqlcom="insert into vnet(宽带)values('"+TextBox2.Text+"')"; break;
				case "velect" :  sqlcom="insert into velect(电)values('"+TextBox2.Text+"')"; break;
				case "vBuildingInfo" : sqlcom=" insert into vbuildinginfo (楼号) values('"+TextBox2.Text+"')"; break;
				default :  Label1.Text="请先选择要添加的表项！"; break;
			}
			OdbcConnection conn = new OdbcConnection();
			conn.ConnectionString=ConfigurationSettings.AppSettings["oCn_Str"];
			//打开数据连接
			conn.Open();
			try
			{
				//定义命令对象
				OdbcCommand cmd = new OdbcCommand(sqlcom,conn);
				//执行SQL命令
				cmd.ExecuteNonQuery();
//				Label1.Text="添加成功";
				DataBindGrid(datatable,col);
			}
			catch
			{
				Label1.Text="添加失败";
			}
			//关闭连接对象
			conn.Close();
		}

		private void LinkButton13_Click(object sender, System.EventArgs e)
		{
			//设置当前页
			DataGrid1.CurrentPageIndex=0;
			//设置Grid标题
			DataGrid1.Columns[4].HeaderText="多媒体";
			//设置添加框的Label和Text属性
			Label2.Text="编号";
			Label3.Text="多媒体";
			TextBox1.Enabled=false;
			TextBox2.Enabled=true;
			//设置表名和首列名
			Session["tablename"]="vmultimedia";
			Session["headname"]="编号";
			Session["colname"]="多媒体";
			//取得字符段
			col=Session["colname"].ToString();
			head=Session["headname"].ToString();
			datatable=Session["tablename"].ToString();
			DataBindGrid(datatable,col);
		}

		private void Button12_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("RoomFloorInfoMng.aspx");
		}
	}
}