incomeandout.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 IncomeAndOut : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        AjaxPro.Utility.RegisterTypeForAjax(typeof(IncomeAndOut));
    }
    [AjaxPro.AjaxMethod]
    public DataTable BindTable()
    {
        RoomBLL room = new RoomBLL();
        DataSet ds = room.select4("empty");
        return ds.Tables[0];
    }
    [AjaxPro.AjaxMethod]
    public int BindCountALL()
    {
        RoomBLL room = new RoomBLL();
        int count = room.selectCount("1=1");
        return count;
    }
    [AjaxPro.AjaxMethod]
    public int BindCountEmpty()
    {
        RoomBLL room = new RoomBLL();
        int count = room.selectCount("State='empty'");
        return count;
    }
    /// <summary>
    /// 绑定下拉列表
    /// </summary>
    /// <returns></returns>
    [AjaxPro.AjaxMethod]
    public DataTable BindToDropList()
    {
        RoomTypeBLL roomtype = new RoomTypeBLL();
        DataSet ds = roomtype.Bindselect();
        return ds.Tables[0];
    }

    [AjaxPro.AjaxMethod]
    public DataTable BindByStateAndTypeID(int typeid, string state)
    {
        RoomBLL room = new RoomBLL();
        DataSet ds = room.selectandState(typeid, state);
        return ds.Tables[0];
    }
    [AjaxPro.AjaxMethod]
    public int Update(int roomid,string state)
    {
        RoomBLL room = new RoomBLL();
        int count = room.updatewhereroomid(roomid, state);
        return count;
    }
}