View/Admin/Rooms.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace EHotelMS.View.Admin
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        Models.Functions Con;

        protected void Page_Load(object sender, EventArgs e)
        {
            Con = new Models.Functions();
            ShowRooms();
            GetCategories();
        }

        private void ShowRooms()
        {
            string Query = "select * from RoomTb1";
            RoomsGV.DataSource = Con.GetData(Query);
            RoomsGV.DataBind();
            RoomsGV.HeaderRow.Cells[1].Text = "房號";
            RoomsGV.HeaderRow.Cells[2].Text = "客房名稱";
            RoomsGV.HeaderRow.Cells[3].Text = "房型";
            RoomsGV.HeaderRow.Cells[4].Text = "位置";
            RoomsGV.HeaderRow.Cells[5].Text = "價格";
            RoomsGV.HeaderRow.Cells[6].Text = "標簽";
            RoomsGV.HeaderRow.Cells[7].Text = "狀態";
        }

        private void GetCategories()
        {
            string Query = "Select * from CategoryTb1";
            if (!Page.IsPostBack)
            {
                CatCb.DataTextField = Con.GetData(Query).Columns["CatName"].ToString();
                CatCb.DataValueField = Con.GetData(Query).Columns["CatId"].ToString();
                CatCb.DataSource = Con.GetData(Query);
                CatCb.DataBind();
            }
        }

        protected void SaveBtn_Click1(object sender, EventArgs e)
        {
            try
            {
                string RName = RNameTb.Value;
                string RCat = CatCb.SelectedValue.ToString();
                string Rloc = LocationTb.Value;
                string Cost = CostTb.Value;
                string Rem = RemarksTb.Value;
                string Status = "空閑";
                string Query = "insert into RoomTb1 values('{0}','{1}','{2}','{3}','{4}','{5}')";
                Query = string.Format(Query, RName, RCat, Rloc, Cost, Rem, Status);
                Con.setData(Query);
                ShowRooms();