//根据顾客身份证号查询顾客信息（分页）
public static DataTable Cha_GuestInfoByPid(string pid, int ye)
{
return(DAL_Hotel.Cha_GuestInfoByPid(pid, ye));
}
//根据身份证号查询信息
public static DataTable Cha_Idcard(string idcard, string table)
{
return(DAL_Hotel.Cha_Idcard(idcard, table));
}
//根据入住时间查询信息
public static DataTable Cha_LiveTime(string livetime, string table)
{
return(DAL_Hotel.Cha_LiveTime(livetime, table));
}
//图标方式展示房间信息（分页）
public static DataTable Img_Table(int ye)
{
return(DAL_Hotel.imgtable(ye));
}
//根据房间编号查询信息
public static DataTable Cha_Roomid(string roomid, string table)
{
return(DAL_Hotel.Cha_Roomid(roomid, table));
}
//顾客升级
public static int UpdateGuest(int gid)
{
return(DAL_Hotel.UpdateGuest(gid));
}
//查询所有顾客信息
public static DataTable Cha_Cus()
{
return(DAL_Hotel.ChaCus());
}
//客户信息表分页
public static DataTable Cha_CusFenYe(int ye)
{
return(DAL_Hotel.Cha_CusFenYe(ye));
}
//查看楼层信息
public static DataTable Bind_LouCeng()
{
return(DAL_Hotel.Bind_LouCeng());
}
//DropDwonList绑定年份
public static DataTable Bind_DropDwonListBindYear()
{
return(DAL_Hotel.Bind_DropDwonListBindYear());
}
//查询最近三年的收益总额
public static DataTable Cha_ThreeChargeCount(int year)
{
return(DAL_Hotel.Cha_ThreeChargeCount(year));
}
//查询指定月份的销售额
public static DataTable Cha_MonthChargeCount(int month, int year)
{
return(DAL_Hotel.Cha_MonthChargeCount(month, year));
}
//根据顾客姓名查询顾客信息（分页）
public static DataTable Cha_GuestInfoByGname(string gname, int ye)
{
return(DAL_Hotel.Cha_GuestInfoByGname(gname, ye));
}
//根据顾客手机号查询顾客信息(分页)
public static DataTable Cha_GuestInfoByMobile(string mobile, int ye)
{
return(DAL_Hotel.Cha_GuestInfoByMobile(mobile, ye));
}
//删除顾客
public static int Del_GuestInfo(int gid)
{
return(DAL_Hotel.Del_GuestInfo(gid));
}
//新增房间
public static int Add_Room(string name, int fid, string mark, int roomid)
{
return(DAL_Hotel.Add_Room(name, fid, mark, roomid));
}
//删除入住信息记录表
public static int Del_Record(int idd)
{
return(DAL_Hotel.DelRecord(idd));
}
//入住预定（预定信息表插入数据）
public static int Add_Reserve(int gid, int roomid, DateTime intime, DateTime outtime, int day, double charge, double actcharge)
{
return(DAL_Hotel.Add_Reserve(gid, roomid, intime, outtime, day, charge, actcharge));
}
//入住/预定信息查询（分页）
public static DataTable LiveMark(string table, int ye)
{
return(DAL_Hotel.LiveMark(table, ye));
}
//只查看单独类型的房间
public static DataTable image_TableType(int type)
{
return(DAL_Hotel.image_TableType(type));
}
//图标方式展示房间信息
public static DataTable Img_Table()
{
return(DAL_Hotel.imgtable());
}
//根据房间编号查询预约信息
public static DataTable Cha_OneReserve(int roomid)
{
return(DAL_Hotel.Cha_OneReserve(roomid));
}
//根据顾客编号查询信息
public static DataTable Cha_Gid(string gid, string table)
{
return(DAL_Hotel.Cha_Gid(gid, table));
}
//取消房间预约
public static int Qu_Reserve(int roomid, string state)
{
return(DAL_Hotel.Qu_Reserve(roomid, state));
}
//根据顾客姓名查询信息
public static DataTable Cha_Gname(string gname, string table)
{
return(DAL_Hotel.Cha_Gname(gname, table));
}
//删除预约信息表
public static int DelReserve(int idd)
{
return(DAL_Hotel.DelReserve(idd));
}
//根据手机号查询信息
public static DataTable Cha_Tel(string tel, string table)
{
return(DAL_Hotel.Cha_Tel(tel, table));
}
//修改顾客信息
public static int ChangeGuestInfo(string name, int GTid, string sex, string mobile, int chargesum, string pid, int gid)
{
return(DAL_Hotel.ChangeGuestInfo(name, GTid, sex, mobile, chargesum, pid, gid));
}
//根据房间ID查询房间信息
public static DataTable Cha_One(int idd)
{
return(DAL_Hotel.Cha_One(idd));
}
//根据顾客编号查询顾客信息(分页)
public static DataTable Cha_GuestInfoByGid(int idd, int ye)
{
return(DAL_Hotel.Cha_GuestInfoByGid(idd, ye));
}