Backup/BLL/GuestInfoBLL.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Model;
using DAL;
namespace BLL
{
    public class GuestInfoBLL
    {
        GuestInfoDAO dao=new GuestInfoDAO();
        private DataSet ds;
         //保存客人信息
        public int SaveGuestInfo(GuestInfoBean guest)
        {
            return dao.SaveGuestInfo(guest);
        }

        //分页查询客人信息
        public string GetGuestInfos(int start,int limit)
        {
            JSONHelper json = new JSONHelper();
            string jsons = "";
            json.success = true;
            ds = dao.GetGuestInfo(start, limit);
            foreach(DataRow dr in ds.Tables[0].Rows)
            {
                json.AddItem("guestid",dr["guestid"].ToString());
                json.AddItem("guestcardid", dr["guestcardid"].ToString());
                json.AddItem("guestname", dr["guestname"].ToString());
                json.AddItem("guestsex", dr["guestsex"].ToString());
                json.AddItem("guestmobile", dr["guestmobile"].ToString());
                json.AddItem("guestaddress", dr["guestaddress"].ToString());
                json.ItemOk();
            }
            json.totlalCount = dao.GetGuestInfoCount();
            jsons = json.ToString();
            return jsons;
        }

        //修改保存客人信息

        public int EditSaveGuestInfo(GuestInfoBean guest)
        {
            return dao.EditSaveGuestInfo(guest);
        }

         //删除客人信息
        public int DeleteGuestInfo(int guestid)
        {
            return dao.DeleteGuestInfo(guestid);
        }
    }
}