Beispiel #1
0
 //根据顾客身份证号查询顾客信息(分页)
 public static DataTable Cha_GuestInfoByPid(string pid, int ye)
 {
     return(DAL_Hotel.Cha_GuestInfoByPid(pid, ye));
 }
Beispiel #2
0
 //根据身份证号查询信息
 public static DataTable Cha_Idcard(string idcard, string table)
 {
     return(DAL_Hotel.Cha_Idcard(idcard, table));
 }
Beispiel #3
0
 //根据入住时间查询信息
 public static DataTable Cha_LiveTime(string livetime, string table)
 {
     return(DAL_Hotel.Cha_LiveTime(livetime, table));
 }
Beispiel #4
0
 //图标方式展示房间信息(分页)
 public static DataTable Img_Table(int ye)
 {
     return(DAL_Hotel.imgtable(ye));
 }
Beispiel #5
0
 //根据房间编号查询信息
 public static DataTable Cha_Roomid(string roomid, string table)
 {
     return(DAL_Hotel.Cha_Roomid(roomid, table));
 }
Beispiel #6
0
 //顾客升级
 public static int UpdateGuest(int gid)
 {
     return(DAL_Hotel.UpdateGuest(gid));
 }
Beispiel #7
0
 //查询所有顾客信息
 public static DataTable Cha_Cus()
 {
     return(DAL_Hotel.ChaCus());
 }
Beispiel #8
0
 //客户信息表分页
 public static DataTable Cha_CusFenYe(int ye)
 {
     return(DAL_Hotel.Cha_CusFenYe(ye));
 }
Beispiel #9
0
 //查看楼层信息
 public static DataTable Bind_LouCeng()
 {
     return(DAL_Hotel.Bind_LouCeng());
 }
Beispiel #10
0
 //DropDwonList绑定年份
 public static DataTable Bind_DropDwonListBindYear()
 {
     return(DAL_Hotel.Bind_DropDwonListBindYear());
 }
Beispiel #11
0
 //查询最近三年的收益总额
 public static DataTable Cha_ThreeChargeCount(int year)
 {
     return(DAL_Hotel.Cha_ThreeChargeCount(year));
 }
Beispiel #12
0
 //查询指定月份的销售额
 public static DataTable Cha_MonthChargeCount(int month, int year)
 {
     return(DAL_Hotel.Cha_MonthChargeCount(month, year));
 }
Beispiel #13
0
 //根据顾客姓名查询顾客信息(分页)
 public static DataTable Cha_GuestInfoByGname(string gname, int ye)
 {
     return(DAL_Hotel.Cha_GuestInfoByGname(gname, ye));
 }
Beispiel #14
0
 //根据顾客手机号查询顾客信息(分页)
 public static DataTable Cha_GuestInfoByMobile(string mobile, int ye)
 {
     return(DAL_Hotel.Cha_GuestInfoByMobile(mobile, ye));
 }
Beispiel #15
0
 //删除顾客
 public static int Del_GuestInfo(int gid)
 {
     return(DAL_Hotel.Del_GuestInfo(gid));
 }
Beispiel #16
0
 //新增房间
 public static int Add_Room(string name, int fid, string mark, int roomid)
 {
     return(DAL_Hotel.Add_Room(name, fid, mark, roomid));
 }
Beispiel #17
0
        //删除入住信息记录表

        public static int Del_Record(int idd)
        {
            return(DAL_Hotel.DelRecord(idd));
        }
Beispiel #18
0
 //入住预定(预定信息表插入数据)
 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));
 }
Beispiel #19
0
 //入住/预定信息查询(分页)
 public static DataTable LiveMark(string table, int ye)
 {
     return(DAL_Hotel.LiveMark(table, ye));
 }
Beispiel #20
0
 //只查看单独类型的房间
 public static DataTable image_TableType(int type)
 {
     return(DAL_Hotel.image_TableType(type));
 }
Beispiel #21
0
 //图标方式展示房间信息
 public static DataTable Img_Table()
 {
     return(DAL_Hotel.imgtable());
 }
Beispiel #22
0
 //根据房间编号查询预约信息
 public static DataTable Cha_OneReserve(int roomid)
 {
     return(DAL_Hotel.Cha_OneReserve(roomid));
 }
Beispiel #23
0
 //根据顾客编号查询信息
 public static DataTable Cha_Gid(string gid, string table)
 {
     return(DAL_Hotel.Cha_Gid(gid, table));
 }
Beispiel #24
0
 //取消房间预约
 public static int Qu_Reserve(int roomid, string state)
 {
     return(DAL_Hotel.Qu_Reserve(roomid, state));
 }
Beispiel #25
0
 //根据顾客姓名查询信息
 public static DataTable Cha_Gname(string gname, string table)
 {
     return(DAL_Hotel.Cha_Gname(gname, table));
 }
Beispiel #26
0
 //删除预约信息表
 public static int DelReserve(int idd)
 {
     return(DAL_Hotel.DelReserve(idd));
 }
Beispiel #27
0
 //根据手机号查询信息
 public static DataTable Cha_Tel(string tel, string table)
 {
     return(DAL_Hotel.Cha_Tel(tel, table));
 }
Beispiel #28
0
 //修改顾客信息
 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));
 }
Beispiel #29
0
 //根据房间ID查询房间信息
 public static DataTable Cha_One(int idd)
 {
     return(DAL_Hotel.Cha_One(idd));
 }
Beispiel #30
0
 //根据顾客编号查询顾客信息(分页)
 public static DataTable Cha_GuestInfoByGid(int idd, int ye)
 {
     return(DAL_Hotel.Cha_GuestInfoByGid(idd, ye));
 }