View/Admin/Users.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 Users : System.Web.UI.Page
    {
        Models.Functions Con;

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

        private void ShowUsers()
        {
            string Query = "select * from UserTb1";
            UserGV.DataSource = Con.GetData(Query);
            UserGV.DataBind();
            /*UserGV.HeaderRow.Cells[1].Text = "房號";
            UserGV.HeaderRow.Cells[2].Text = "用戶名";
            UserGV.HeaderRow.Cells[3].Text = "電話";
            UserGV.HeaderRow.Cells[4].Text = "性別";
            UserGV.HeaderRow.Cells[5].Text = "地址";
            UserGV.HeaderRow.Cells[6].Text = "密碼";*/

        }

        protected void SaveBtn_Click(object sender, EventArgs e)
        {
            try
            {
                string UName = UNameTb.Value;
                string UPhone = PhoneTb.Value;
                string UGen = GenCb.SelectedValue;
                string UAdd = AddressTb.Value;
                string UPass = PasswordTb.Value;
                string Query = "insert into UserTb1 values('{0}','{1}','{2}','{3}','{4}')";
                Query = string.Format(Query, UName, UPhone, UGen, UAdd, UPass);
                Con.setData(Query);
                ShowUsers();
                ErrMsg.InnerText = "用户已經添加！！！";
                UNameTb.Value = "";
                GenCb.SelectedIndex = -1;
                AddressTb.Value = "";
                PasswordTb.Value = "";
                PhoneTb.Value = "";

            }
            catch (Exception Ex)
            {
                ErrMsg.InnerText = Ex.Message;
            }
        }