Backup/BLL/OpenRoomInfoBLL.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using DAL;
using System.Data;

namespace BLL
{
    public class OpenRoomInfoBLL
    {
        OpenRoomInfoDAO dao = new OpenRoomInfoDAO();
        private DataSet ds;

        //分页查询openroominfo
        public string PageingOpenRoomInfo(int start,int limit)
        {
            JSONHelper json = new JSONHelper();
            ds = dao.GetRoomOpenInfo(start,limit);
            json.success = true;
            foreach(DataRow dr in ds.Tables[0].Rows)
            {
                json.AddItem("openroomid", dr["openroomid"].ToString());
                json.AddItem("roomid", dr["roomid"].ToString());
                json.AddItem("guestid", dr["guestid"].ToString());
                json.AddItem("guestmoney", dr["guestmoney"].ToString());
                json.AddItem("OpenTodayTime", dr["OpenTodayTime"].ToString());
                json.AddItem("opentime", dr["opentime"].ToString());
                json.AddItem("remark", dr["remark"].ToString());
                json.ItemOk();
            }
            json.totlalCount = dao.GetOpenRoomAllCount();
            string openroominfo = json.ToString();
            return openroominfo;
        }

         //保存开房信息
        public int SaveOpenRoomInfo(OpenRoomInfoBean open)
        {
            return dao.SaveOpenRoomInfo(open);
        }

         //修改开房信息
        public int EditOpenRoomInfo(OpenRoomInfoBean open)
        {
            return dao.EditOpenRoomInfo(open);
        }
        //删除开房信息
        public int DelOpenRoomInfo(int OpenRoomID)
        {
            return dao.DelOpenRoomInfo(OpenRoomID);
        }
    }
}