/// <summary>
/// 查询酒店的所有房间
/// </summary>
/// <returns></returns>
public static List <RoomMessage> HotelRoom()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
return(db.RoomMessage.ToList());
}
}
/// <summary>
/// 查询上线后以地址随机推荐的酒店
/// </summary>
/// <param name="HotelNum"></param>
/// <returns></returns>
public static List <HotelManag> GetALL(int HotelNum)
{
List <HotelManag> list = new List <HotelManag>();
//ArrayList list = new ArrayList();
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
int num = 0;
// db.Configuration.ProxyCreationEnabled = false;
var dbApplicationList = db.HotelManag.GroupBy(x => x.HotelCity).Select(x => new { key = x.Key }).ToList();
foreach (var item in dbApplicationList)
{
var _dbApplicationList = item.key;
var distinctPeople = db.HotelManag.Include("HotelPhoto")
.Where(t => t.HotelCity == _dbApplicationList && t.HotelRatify == true).ToList().FirstOrDefault();
if (distinctPeople == null)
{
continue;
}
list.Add(distinctPeople);
if (num >= HotelNum)
{
break;
}
num++;
}
}
return(list);
}
/// <summary>
/// 查询所有的床型
/// </summary>
/// <returns></returns>
public static List <Mattres> Select1()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
return(db.Mattres.ToList());
}
}
public JsonResult GetEchartsHotelTypeOrder()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var all = db.Order.Include("HotelManag").GroupBy(r => r.HotelManag.HotelType).Select(s => new { Name = s.Key, ID = s.Count() });
//声明两个动态数据，存储循环出来的数据
ArrayList xAxisData = new ArrayList();
ArrayList yAxisData = new ArrayList();
//循环list将数据循环存储在动态数组中
foreach (var item in all)
{
xAxisData.Add(item.Name);
yAxisData.Add(item.ID);
}
var resultPicorder = new { Sex = xAxisData, Num = yAxisData };
return(Json(resultPicorder, JsonRequestBehavior.AllowGet));
//2、不循环添加数据直接数据Json化数据
//var all = db.Student.GroupBy(s => new { s.StuSex }).Select(s => new { Name = s.Key.StuSex, ID = s.Count() }).ToList();
//return Json(new { data = all }, JsonRequestBehavior.AllowGet);
}
}
public static List <Order> Selectorderdate(int pageindex, int pagesize, out int pagecount, string b, int HotelID)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var orders = db.Order.Include("HotelManag").Include("RoomMessage").Where(s => s.HotelID == HotelID);
var df = DateTime.Now.Date;
if (b == "今日订单")
{
DateTime bd = DateTime.Parse(df.ToString());
var students = orders.Where(s => s.Ordertime > bd).ToList();
pagecount = (int)Math.Ceiling(students.Count() * 1.0 / pagesize);
return(students.OrderByDescending(s => s.Ordertime).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList());
}
else if (b == "今日到店")
{
var students = orders.Where(t => t.ArrivalDate == df).ToList();
pagecount = (int)Math.Ceiling(students.Count() * 1.0 / pagesize);
return(students.OrderByDescending(s => s.Ordertime).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList());
}
else if (b == "待办事项")
{
var students = orders.Where(t => t.OrderState == "退款").ToList();
pagecount = (int)Math.Ceiling(students.Count() * 1.0 / pagesize);
return(students.OrderByDescending(s => s.Ordertime).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList());
}
pagecount = (int)Math.Ceiling(orders.Count() * 1.0 / pagesize); //获取总数量
return(orders.OrderBy(s => s.Ordertime).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList()); //分页数据
}
}
public IHttpActionResult GetEvaluate()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
return(Ok(db.UserEvaluate.Include("UserMessage").ToList()));
}
}
internal static Order GetOrder(string order, int UsertID)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
return(db.Order.Include("UserMessage").Include("HotelManag").Include("RoomMessage").Where(t => t.OrderNumber == order && t.UserID == UsertID).ToList().FirstOrDefault());
}
}
public ActionResult HotelOrderdtld(int id)
{
SmartRentalSystemEntities db = new SmartRentalSystemEntities();
var orderdtld = db.view_OrderHotelPhotos.Find(id);
return(View(orderdtld));
}
/// <summary>
/// 查询所有的酒店
/// </summary>
/// <returns></returns>
public static List <HotelManag> Select3()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
return(db.HotelManag.ToList());
}
}
public JsonResult GetDecryptionString(UserMessage userMessage)
{
Session.Timeout = 720;
var decryptionResult = LoginService.Decryption(userMessage.UserPhone, userMessage.UserPwd);
if (int.Parse(decryptionResult.ToString()) == 1) //超级管理员
{
Session["SuperAdmin"] = userMessage.UserPhone;
return(Json(new { succeed = 200, roestr = "/Hotel/Index" }, JsonRequestBehavior.AllowGet));
}
else if (int.Parse(decryptionResult.ToString()) == 0) //密码错误
{
return(Json(new { succeed = 404, roestr = "密码错误" }, JsonRequestBehavior.AllowGet));
}
else if (int.Parse(decryptionResult.ToString()) == -1) // 普通管理员
{
SmartRentalSystemEntities db = new SmartRentalSystemEntities();
if (BLL.LoginService.DecryptionHotelID(userMessage.UserPhone) == null)
{
return(Json(new { succeed = 200, roestr = "/GHotelHome/Main" }, JsonRequestBehavior.AllowGet));
}
Session["GeneralManager"] = userMessage.UserPhone;
Session["HotelID"] = BLL.LoginService.DecryptionHotelID(userMessage.UserPhone);
return(Json(new { succeed = 200, roestr = "/GHotelHome/MainIndex" }, JsonRequestBehavior.AllowGet));
}
else //不是管理员
{
return(Json(new { succeed = 404, roestr = "没有权限" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 查询所有的房型
/// </summary>
/// <returns></returns>
public static List <RoomType> Select2()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
return(db.RoomType.ToList());
}
}
public IHttpActionResult HotelselectName(string selectName)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var Hotel = db.HotelManag.Where(t => t.HotelName == selectName).ToList().FirstOrDefault();
return(Ok(Hotel));
}
}
/// <summary>
/// 搜索栏模糊查询
/// </summary>
/// <param name="search"></param>
internal static object Hunt(string search)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = db.HotelManag.Where(t => t.HotelName.Contains(search) && t.HotelRatify == true).ToList();
return(aa);
}
}
public IHttpActionResult Order(int UserId)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var Order = db.view_OrderHotelPhotos.OrderByDescending(t => t.Ordertime).Where(t => t.UserID == UserId).ToList();
return(Ok(Order));
}
}
public static UserMessage Personal(int UserId)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = db.UserMessage.Where(t => t.UserID == UserId).ToList().FirstOrDefault();
return(aa);
}
}
/// <summary>
/// 查询某个酒店
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static HotelManag All(int id)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = db.HotelManag.Include("HotelPhoto").Where(t => t.HotelID == id).FirstOrDefault();
return(aa);
}
}
internal static object Allroom(int roomId)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = db.RoomMessage.Include("RoomType").Include("RoomPhoto").Where(t => t.RoomID == roomId).ToList().FirstOrDefault();
return(aa);
}
}
/// <summary>
/// 所有房间信息
/// </summary>
/// <param name="id">酒店Id</param>
/// <returns></returns>
public static List <RoomMessage> GllDetails(int id)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = db.RoomMessage.Include("RoomType").Include("RoomPhoto").Where(t => t.HotelID == id && t.Roomstate != false).ToList();
return(aa);
}
}
public static int insertOrder(Order order)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
db.Order.Add(order);
return(db.SaveChanges());
}
}
public IHttpActionResult resultSearch(string name)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var Hotelname = db.HotelManag.Include("HotelPhoto").Where(t => t.HotelCity.Contains(name) && t.HotelRatify == true).ToList();
return(Ok(Hotelname));
}
}
public IHttpActionResult informationOrder(int UserId)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var count = db.Order.Where(t => t.UserID == UserId).Count();
return(Ok(count));
}
}
/// <summary>
/// 查询上线后推荐的的酒店
/// </summary>
/// <returns></returns>
public static List <HotelManag> Getrecommend()
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
db.Configuration.ProxyCreationEnabled = false;
var aa = db.HotelManag.Include("HotelPhoto").Where(t => t.HotelRatify == true).OrderBy(t => t.Hotelrecommen).ToList();
return(aa);
}
}
public IHttpActionResult Orderreimburse(int UserId)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = DateTime.Now.Date;
var Order = db.view_OrderHotelPhotos.OrderByDescending(t => t.Ordertime).Where(t => t.UserID == UserId && t.OrderState == "已退款").ToList();
return(Ok(Order));
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageindex">页码</param>
/// <param name="pagesize">一页的数量</param>
/// <returns></returns>
public static List <Order> Select(int pageindex, int pagesize, out int pagecount, int HotelID)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var orders = db.Order.Include("HotelManag").Include("RoomMessage").Where(s => s.HotelID == HotelID);
pagecount = (int)Math.Ceiling(orders.Count() * 1.0 / pagesize);
return(orders.OrderByDescending(s => s.ArrivalDate).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList());
}
}
public IHttpActionResult message(dynamic data)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var Url = "/images/" + data.data.imgURL;
var id = data.data.id;
var user = db.UserMessage.Find(id.Value);
user.HeadPhoto = Url;
db.Entry(user).State = EntityState.Modified;
return(Ok(db.SaveChanges() > 0));
}
}
internal static object Updata(UserMessage user)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var aa = db.UserMessage.Where(t => t.UserID == user.UserID).ToList().FirstOrDefault();
aa.UserName = user.UserName;
aa.Birthday = user.Birthday;
aa.sex = user.sex;
db.Entry(aa).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public ActionResult AdminOrder(int?OrderID, string OrderState, string ab, string text1, int pageindex = 1, int pagesize = 8)
{
Session["order"] = 45;
SmartRentalSystemEntities db = new SmartRentalSystemEntities();
var sss = ab; var bbb = text1;
if (ab != null && ab != "")
{
Session["se"] = ab; Session["ts"] = text1;
}
if (sss == null && bbb == null)
{
var order = db.Order.Include("RoomMessage").Where(t => t.OrderID == OrderID).FirstOrDefault();
order.OrderState = OrderState;
var or = db.Order.Find(OrderID); var roms = db.RoomMessage.Find(order.RoomID);
if (OrderState == "已退款" && roms.RoomCount < roms.RoomRemain)
{
roms.RoomCount = roms.RoomCount + order.Ordercount;
if (roms.RoomCount > roms.RoomRemain)
{
roms.RoomCount = roms.RoomRemain;//保证能售房间数量和店长修改的房间数量一样；
}
db.SaveChanges();
}
or.OrderState = OrderState;
db.SaveChanges();
}
else if (sss == "所有订单")
{
return(RedirectToAction("AdminOrder"));
}
else
{
//int countss = 5;
var student = BLL.ServiceAdmin.YAdminManageServise.GetStudentByPaging1(pageindex, pagesize, out int pagecount, sss, bbb);
//Session["order"] = 1;
ViewBag.pageindex = pageindex;
ViewBag.pagecount = pagecount;
ViewBag.pagesize = pagesize;
//if (pagesize % 5 == 0)
//{
// ViewBag.countss = pagesize;
//}
//else
//{
// ViewBag.countss = countss;
//}
return(View(student));
}
return(RedirectToAction("AdminOrder"));
}
public IHttpActionResult Evaluate(int userId, int Evaluate)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
UserBrowse browse = new UserBrowse();
browse.HotelID = Evaluate;
browse.UserID = userId;
browse.BrowseTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm"));
db.UserBrowse.Add(browse);
db.SaveChanges();
}
return(Ok(200));
}
public ActionResult HotelOrder(string OrderState, string ab, string text1, int pageindex = 1, int pagesize = 8)
{
Session["order"] = 45;
var HotelIDss = int.Parse(Session["HotelID"].ToString()); /*Session["HotelID"];*///获取酒店HotelID
SmartRentalSystemEntities db = new SmartRentalSystemEntities();
var sss = ab; var bbb = text1;
if (ab != null && ab != "")
{
Session["se"] = ab; Session["ts"] = text1;
}
if (sss == null && bbb == null)
{
var student = BLL.ServiceAdmin.GHotelManageService.Selectorderdate(pageindex, pagesize, out int pagecount, OrderState, HotelIDss);
//Session["order"] = 1;
ViewBag.pageindex = pageindex;
ViewBag.pagecount = pagecount;
ViewBag.pagesize = pagesize;
//if (pagesize % 5 == 0)
//{
// ViewBag.countss = pagesize;
//}
//else
//{
// ViewBag.countss = countss;
//}
return(View(student));
}
else if (sss == "所有订单")
{
return(RedirectToAction("HotelOrder"));
}
else
{
//int countss = 5;
var student = BLL.ServiceAdmin.GHotelManageService.GetStudentByPaging1(pageindex, pagesize, out int pagecount, sss, bbb, HotelIDss);
//Session["order"] = 1;
ViewBag.pageindex = pageindex;
ViewBag.pagecount = pagecount;
ViewBag.pagesize = pagesize;
//if (pagesize % 5 == 0)
//{
// ViewBag.countss = pagesize;
//}
//else
//{
// ViewBag.countss = countss;
//}
return(View(student));
}
}
//酒店月销量和房间销量图
public JsonResult GetEchartsyear(string datesyear)
{
var HotelIDss = int.Parse(Session["HotelID"].ToString()); /*Session["HotelID"];*///获取酒店HotelID
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var all = db.view_HotelDatemonthmoney.Where(v => v.HotelID == HotelIDss && v.datemoneytime.Contains(datesyear)).Select(s => new { Name = s.datemoneytime, ID = s.summoney }).OrderBy(s => s.Name);
//声明两个动态数据，存储循环出来的数据
ArrayList xAxisData = new ArrayList();
ArrayList yAxisData = new ArrayList();
string st2 = null;
string[] st3 = new string[32];
decimal[] sum = new decimal[32];
//循环list将数据循环存储在动态数组中
foreach (var item in all)
{
st2 = item.Name.Split('-')[1];
st3[int.Parse(st2)] = st2;
sum[int.Parse(st2)] = (decimal)item.ID;
}
for (int i = 1; i <= 12; i++)
{
string ni = i.ToString();
if (i < 10)
{
ni = "0" + i.ToString();
}
if (st3[i] != null && st3[i] == ni)
{
xAxisData.Add(i.ToString());
yAxisData.Add(sum[i]);
}
else
{
xAxisData.Add(i.ToString());
yAxisData.Add(0);
}
}
var resultsd = new { Sex = xAxisData, Num = yAxisData };
return(Json(resultsd, JsonRequestBehavior.AllowGet));
//2、不循环添加数据直接数据Json化数据
//var all = db.Student.GroupBy(s => new { s.StuSex }).Select(s => new { Name = s.Key.StuSex, ID = s.Count() }).ToList();
//return Json(new { data = all }, JsonRequestBehavior.AllowGet);
}
}