基于.NET Core 3.1 网站开发和部署的方法
-- 插入测试数据 -- 打点员信息 insert into SysAdmins(LoginPwd,LoginName)values('123456','李浩'); insert into SysAdmins(LoginPwd,LoginName)values('123456','赵雪伶'); -- 消息分类 insert into NewsCategory(CategoryName)values('公司消息'); insert into NewsCategory(CategoryName)values('社会消息'); -- 菜品分类 insert into DishCategory(CategoryName)values('川菜'); insert into DishCategory(CategoryName)values('湘菜'); insert into DishCategory(CategoryName)values('鲁菜'); insert into DishCategory(CategoryName)values('海鲜类'); insert into DishCategory(CategoryName)values('其他'); -- 消息 insert into News(NewsTitle,NewsContent,CategoryId)values('欢迎十一海鲜大促销','最奇怪的鱼类全面上市,接待新老顾主品尝。',1); insert into News(NewsTitle,NewsContent,CategoryId)values('本店正在热招加盟商','假如您乐意在旅馆行业有所打破,请插手我们。',1); insert into News(NewsTitle,NewsContent,CategoryId)values('互联网的斲丧正在鼓起','网上购物已经成为人们糊口必不行少的一部门。',2); insert into News(NewsTitle,NewsContent,CategoryId)values('本店正在热招加盟商','假如您乐意在旅馆行业有所打破,请插手我们。',1); insert into News(NewsTitle,NewsContent,CategoryId)values('互联网的斲丧正在鼓起','网上购物已经成为人们糊口必不行少的一部门。',2); -- 菜品信息 insert into Dishes(DishName,UnitPrice,CategoryId)values('水煮鱼',50,1); insert into Dishes(DishName,UnitPrice,CategoryId)values('回锅肉',85,1); insert into Dishes(DishName,UnitPrice,CategoryId)values('剁椒鱼头',75,2); insert into Dishes(DishName,UnitPrice,CategoryId)values('红椒腊牛肉',40,2); insert into Dishes(DishName,UnitPrice,CategoryId)values('糖醋鲤鱼',70,3); insert into Dishes(DishName,UnitPrice,CategoryId)values('玉记扒鸡',60,3); insert into Dishes(DishName,UnitPrice,CategoryId)values('汤爆双脆',90,3); insert into Dishes(DishName,UnitPrice,CategoryId)values('赤贝',80,4); -- 预定信息 insert into DishBook(HotelName,ConsumeTime,ConsumePersons,RoomType,CustomerName,CustomerPhone,CustomerEmail,Comments) values('天津南开店','2014-09-11 12:30',5,'包间','李丽','13589011222','lilivip@163.com','但愿房间敞亮些'); insert into DishBook(HotelName,ConsumeTime,ConsumePersons,RoomType,CustomerName,CustomerPhone,CustomerEmail,Comments) values('天津僻静店','2014-10-11 14:30',5,'包间','王鑫新','13889018888','wangxinxin@qq.com','但愿房间宁静些'); insert into DishBook(HotelName,ConsumeTime,ConsumePersons,RoomType,CustomerName,CustomerPhone,CustomerEmail,Comments) values('北京向阳点','2014-12-10 17:30',5,'散座','刘花雨','13689011999','liuhuayu@126.com','房间靠内里点儿'); -- 雇用信息 insert into Recruitment(PostName,PostType,WorkPlace,PostDesc,PostRequire,Experience,EduBackground,RequireCount,Manager,PhoneNumber,Email) values('大堂司理','全职','天津','认真一层楼的打点','要求具备该地位3年以上策划打点履历','3年','本科',2,'李超阳','15689011231','lichaoyang@hyl.com'); insert into Recruitment(PostName,PostType,WorkPlace,PostDesc,PostRequire,Experience,EduBackground,RequireCount,Manager,PhoneNumber,Email) values('迎接员','全职','北京','认真客户的迎接礼节','要求具备该地位1年以上履历','1年','高中',5,'李超阳','15689011231','lichaoyang@hyl.com'); insert into Recruitment(PostName,PostType,WorkPlace,PostDesc,PostRequire,Experience,EduBackground,RequireCount,Manager,PhoneNumber,Email) values('总司理助理','全职','天津','认真一般的文秘事变','要求具备该地位3年以上策划打点履历','3年','本科',1,'李超阳','15689011231','lichaoyang@hyl.com'); -- 投诉提议 insert into Suggestion(CustomerName,ConsumeDesc,SuggestionDesc,PhoneNumber,Email) values('杜小杰','在该店进行一次婚礼','感受总体处事不到位,菜咀嚼道没有早年的好。','15687423456','duxiaojie@qq.com'); insert into Suggestion(CustomerName,ConsumeDesc,SuggestionDesc,PhoneNumber,Email) values('柳钢','在本店集会一次','感受上菜有点慢,但愿后续改造。','15686623456','liugang@qq.com'); 二、搭建项目框架 1.行使vscode建设一个mvc项目进入vscode,打开终端建设项目标根目次
建设项目根目次 (编辑:湖南网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |