roomstate.aspx.cs

酒店管理系统 用C#开发 程序简单明了 应用系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using BLL;

public partial class RoomState : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        AjaxPro.Utility.RegisterTypeForAjax(typeof(RoomState));
        if (!Page.IsPostBack)
        {
            BindToDropList();
        }
    }
    /// <summary>
    /// 邦定客房状态
    /// </summary>
    /// <returns></returns>
    [AjaxPro.AjaxMethod]
    public DataTable BindTable()
    {
        RoomBLL room = new RoomBLL();
        DataSet ds = room.select3();
        return ds.Tables[0];
    }
    /// <summary>
    /// 根据房间类型绑定
    /// </summary>
    /// <returns></returns>
    [AjaxPro.AjaxMethod]
    public DataTable BindTableByID(int typeid)
    {
        RoomBLL room = new RoomBLL();
        DataSet ds = room.select5(typeid);
        return ds.Tables[0];
    }
    /// <summary>
    /// 绑定下拉列表
    /// </summary>
    /// <returns></returns>
    [AjaxPro.AjaxMethod]
    public DataTable BindToDropList()
    {
        RoomTypeBLL roomtype = new RoomTypeBLL();
        DataSet ds = roomtype.Bindselect();
        return ds.Tables[0];
    }
    /// <summary>
    /// 根据房间号修改房间状态
    /// </summary>
    /// <param name="roomid"></param>
    /// <param name="state"></param>
    /// <returns></returns>
    [AjaxPro.AjaxMethod]
    public string Update(int roomid, string state)
    {
        RoomBLL ro = new RoomBLL();
        int count = ro.updatewhereroomid(roomid, state);
        if (count != 0)
        {
            return "更新成功";
        }
        return "更新失败";
    }
}