XDF/Admin/RoomInfo.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using BLL;

namespace XDF.Admin
{
    public partial class RoomInfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack == false)
            {

                if (Session["UserRole"] == null)
                    Response.Redirect("~/Login.aspx");
                string roomid = Session["RoomID"].ToString();
                string type = getType(roomid);
                string capacity = getCapacity(roomid);
                string address = getAddress(roomid);
                string id = roomid.Substring(4, 3);
                string baseid = roomid.Substring(0, 4);
                DropDownListType.SelectedValue = type;
                TextBoxAddress.Text = address;
                LabelBaseID.Text = baseid;
                TextBoxCapacity.Text = capacity;
                LabelRoomID.Text = id;
                string result=getNumber(roomid);
                int Count = int.Parse(result);
                if (Count==1)
                {
                    LinkButtonDelete.Enabled = true;
                }
                else
                {
                    LinkButtonDelete.Enabled=false;
                }
            }

        }

        private string getNumber(string roomid)
        {
            string result = "";
            try
            {
                // 1. 创建连接
                SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

                // 2. 打开连接
                connection.Open();

                // 2.1 创建命令对象
                SqlCommand command = null;