ASP.NET开发的民宿管理系统源码

-- -------------------------------------------------------- -- 主机: 127.0.0.1 -- 服务器版本: 5.6.24-log - MySQL Community Server (GPL) -- 服务器操作系统: Win32 -- HeidiSQL 版本: 9.3.0.4984 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- 导出 bnbjoybackenddb 的数据库结构 CREATE DATABASE IF NOT EXISTS `bnbjoybackenddb` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `bnbjoybackenddb`; -- 导出 表 bnbjoybackenddb.BnbInfo 结构 CREATE TABLE IF NOT EXISTS `BnbInfo` ( `BnbId` varchar(50) NOT NULL COMMENT '民宿id', `OwnerId` varchar(50) NOT NULL COMMENT '民宿所有者用户id', `BnbName` varchar(50) NOT NULL COMMENT '民宿名称', `Tel` varchar(20) NOT NULL COMMENT '前台联系电话', `Province` varchar(20) NOT NULL COMMENT '所在省', `City` varchar(20) NOT NULL COMMENT '所在市', `Town` varchar(20) NOT NULL COMMENT '所在区县', `Address` varchar(200) NOT NULL COMMENT '详细地址', `OnlineSale` bit(1) NOT NULL COMMENT '是否开启线上销售', PRIMARY KEY (`BnbId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='民宿信息表'; -- 正在导出表 bnbjoybackenddb.BnbInfo 的数据：~3 rows (大约) /*!40000 ALTER TABLE `BnbInfo` DISABLE KEYS */; INSERT INTO `BnbInfo` (`BnbId`, `OwnerId`, `BnbName`, `Tel`, `Province`, `City`, `Town`, `Address`, `OnlineSale`) VALUES ('1', '4d042a4255e9499db3300e7572913489', '宛若故里清泉美宿', '0512-62977045', '江苏省', '苏州市', '姑苏区', '平江路201号', b'0'), ('2', '911b65522c564dc0a6bf6784019424de', '小桥流水美宿', '0512-62977046', '江苏省', '苏州市', '姑苏区', '平江路202号', b'0'), ('3', '911b65522c564dc0a6bf6784019424de', '艺宿精品', '0512-62977047', '江苏省', '苏州市', '姑苏区', '平江路203号', b'0'); /*!40000 ALTER TABLE `BnbInfo` ENABLE KEYS */; -- 导出 表 bnbjoybackenddb.Channel 结构 CREATE TABLE IF NOT EXISTS `Channel` ( `ChannelId` int(11) NOT NULL AUTO_INCREMENT, `ChannelName` varchar(50) NOT NULL DEFAULT '0', PRIMARY KEY (`ChannelId`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='下单渠道表'; -- 正在导出表 bnbjoybackenddb.Channel 的数据：~2 rows (大约) /*!40000 ALTER TABLE `Channel` DISABLE KEYS */; INSERT INTO `Channel` (`ChannelId`, `ChannelName`) VALUES (1, 'Online'), (2, 'Offline'); /*!40000 ALTER TABLE `Channel` ENABLE KEYS */; -- 导出 表 bnbjoybackenddb.Client 结构 CREATE TABLE IF NOT EXISTS `Client` ( `Id` varchar(50) NOT NULL COMMENT '客户端id', `Secret` varchar(100) NOT NULL COMMENT '客户端秘钥', `Name` varchar(50) NOT NULL COMMENT '客户端名称', `ApplicationType` tinyint(4) NOT NULL COMMENT '客户端类别', `Active` bit(1) NOT NULL COMMENT '是否激活', `RefreshTokenLifeTime` int(11) NOT NULL COMMENT 'RefreshToken剩余时间，以秒计算', `AllowedOrigin` varchar(100) DEFAULT NULL COMMENT '跨域信息', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户端授权表'; -- 正在导出表 bnbjoybackenddb.Client 的数据：~4 rows (大约) /*!40000 ALTER TABLE `Client` DISABLE KEYS */; INSERT INTO `Client` (`Id`, `Secret`, `Name`, `ApplicationType`, `Active`, `RefreshTokenLifeTime`, `AllowedOrigin`) VALUES ('AndoridApp', 'xj8/8xFe3w2bEah2Y6qkTo3pQU75u6C3N/VXcJaJkgg=', 'Andorid Native App User', 3, b'1', 2592000, '*'), ('H5', 'jtU5v9zJc0SWXgCZ9s3+gzrAsmr5KuOBYzBfEDo/li8=', 'Mobile Browser User For Bnbjoy', 1, b'1', 172800, '*'), ('iOSApp', 'lBBv/C3uLjrqNVIQyyesMPc28MedlTERmglUY5uuFIY=', 'iOS Native App User', 2, b'1', 2592000, '*'), ('Web', '9o74ys/ZfUKvl1f+d77awebt84G+g58tPJ0CQPlApYg=', 'WebSite User For Bnbjoy', 0, b'1', 172800, '*'); /*!40000 ALTER TABLE `Client` ENABLE KEYS */; -- 导出 表 bnbjoybackenddb.CommonPrice 结构 CREATE TABLE IF NOT EXISTS `CommonPrice` ( `Id` varchar(50) NOT NULL COMMENT '通用价格id', `InitPrice` decimal(6,2) NOT NULL COMMENT '默认初始价', `MondayPrice` decimal(6,2) NOT NULL COMMENT '周一价格', `TuesdayPrice` decimal(6,2) NOT NULL COMMENT '周二价格', `WednesdayPrice` decimal(6,2) NOT NULL COMMENT '周三价格', `ThursdayPrice` decimal(6,2) NOT NULL COMMENT '周四价格', `FridayPrice` decimal(6,2) NOT NULL COMMENT '周五价格', `SaturdayPrice` decimal(6,2) NOT NULL COMMENT '周六价格', `SundayPrice` decimal(6,2) NOT NULL COMMENT '周日价格', `RoomTypeId` varchar(50) NOT NULL COMMENT '房型Id', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通用价格表'; -- 正在导出表 bnbjoybackenddb.CommonPrice 的数据：~12 rows (大约) /*!40000 ALTER TABLE `CommonPrice` DISABLE KEYS */; INSERT INTO `CommonPrice` (`Id`, `InitPrice`, `MondayPrice`, `TuesdayPrice`, `WednesdayPrice`, `ThursdayPrice`, `FridayPrice`, `SaturdayPrice`, `SundayPrice`, `RoomTypeId`) VALUES ('042fccdc84684f5eb4e99c364a6a364d', 100.00, 100.00, 100.00, 100.00, 100.00, 100.00, 100.00, 100.00, '200b8063d76940b3911c8e6c2a9d7468'), ('0d770a3b7fe04b26b0d1b66f9861c4ec', 100.00, 100.00, 100.00, 100.00, 100.00, 100.00, 100.00, 100.00, 'e83f856c45c7427e966ebfcc63ea7177'), ('1d3694fc13794de89332858fa5943117', 1111.00, 1111.00, 1111.00, 1111.00, 1111.00, 1111.00, 1111.00, 1111.00, 'a0f65ffd1b574888be73602f7fbdf816'), ('1e6dabcb9254430592fc5b2c0521453e', 210.00, 210.00, 210.00, 210.00, 210.00, 210.00, 210.00, 210.00, 'd946f9ed466a4adab3a7b854f5a69025'), ('24be2ed2586c4ccfb2e235f1bbd683e1', 700.00, 700.00, 700.00, 700.00, 700.00, 700.00, 700.00, 700.00, 'b41bad78ef1a4cbc9f6f83bba0d7fb05'), ('2c8e6c7d677349b282e85750ab1849ac', 200.00, 200.00, 200.00, 200.00, 200.00, 200.00, 200.00, 200.00, 'e377f1259d514dc2b5cefb916e3dba36'), ('4062a2620ea94bd7907256c566f21677', 200.00, 200.00, 200.00, 200.00, 200.00, 200.00, 200.00, 200.00, 'ba3a2961fa654bfb973e1b7d8fdcac9d'), ('6cf0c6789c3e46afab63562af418bd94', 100.46, 100.46, 100.46, 100.46, 100.46, 100.46, 100.46, 100.46, '7098f405af7743d7b150ed5fb1062f9c'), ('7d3affaf7f9948848f2bfdf3ba8b215e', 120.00, 120.00, 120.00, 120.00, 120.00, 120.00, 120.00, 120.00, '6b1ea32e54454843995cbf6776dc5cfb'), ('84b456f8dbc04806b0b644de7b993fc8', 111.00, 111.00, 111.00, 111.00, 111.00, 111.00, 111.00, 111.00, '8d97b17cf66e43d09ce25c6e50b5eb62'), ('ce5fee18fde144da8dbcd378a284176d', 300.00, 300.00, 300.00, 300.00, 300.00, 300.00, 300.00, 300.00, 'b6f3a2ae364541a682acf5727ddf716f'), ('e790dbc080534707880d640c35aa77fd', 222.00, 222.00, 222.00, 222.00, 222.00, 222.00, 222.00, 222.00, '543369f3bbac42b48ae7c0e4c6119ddb'); /*!40000 ALTER TABLE `CommonPrice` ENABLE KEYS */; -- 导出 表 bnbjoybackenddb.Customer 结构 CREATE TABLE IF NOT EXISTS `Customer` ( `CustomerId` varchar(50) NOT NULL, `OrderId` varchar(50) NOT NULL, `CustomerName` varchar(50) NOT NULL, `CustomerIdType` int(11) NOT NULL, `CustomerIdNumber` varchar(80) NOT NULL, PRIMARY KEY (`CustomerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='入住人信息表'; -- 正在导出表 bnbjoybackenddb.Customer 的数据：~1 rows (大约) /*!40000 ALTER TABLE `Customer` DISABLE KEYS */; INSERT INTO `Customer` (`CustomerId`, `OrderId`, `CustomerName`, `CustomerIdType`, `CustomerIdNumber`) VALUES ('cb113ec490b940b1b46243465b098cbd', 'B20161121040204235', '深深', 1, '330722197609192116'); /*!40000 ALTER TABLE `Customer` ENABLE KEYS */; -- 导出 表 bnbjoybackenddb.CustomerIdType 结构 CREATE TABLE IF NOT EXISTS `CustomerIdType` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Type` varchar(50) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户证件类别'; -- 正在导出表