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 static int AddHotelManager(HotelManag manager, string[] photo, UserMessage usms)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
HotelPhoto hotel = new HotelPhoto();
for (int i = 0; i < photo.Length; i++)
{
if (i == 0)
{
hotel.Hotelphoto1 = photo[i].ToString();
}
if (i == 1)
{
hotel.Hotelphoto2 = photo[i].ToString();
}
if (i == 2)
{
hotel.Hotelphoto3 = photo[i].ToString();
}
if (i == 3)
{
hotel.Hotelphoto4 = photo[i].ToString();
}
if (i == 4)
{
hotel.Hotelphoto5 = photo[i].ToString();
}
if (i == 5)
{
hotel.Hotelphoto6 = photo[i].ToString();
}
if (i == 6)
{
hotel.Hotelphoto7 = photo[i].ToString();
}
}
var bb = db.HotelPhoto.Add(hotel);
db.SaveChanges();
int photoID = bb.HotelPhotoID;
manager.HotelPhotoID = photoID;
manager.Hotelrecommen = 10000;
db.SaveChanges();
var hh = db.HotelManag.Add(manager);
var usermess = db.UserMessage.Find(usms.UserID);
usermess.HotelID = hh.HotelID;
return(db.SaveChanges());
}
}
public static bool UpdataAudit(HotelManag hotel)
{
var re = db.HotelManag.Find(hotel.HotelID);
re.HotelRatify = hotel.HotelRatify;
if (re.HotelRatify == true)
{
var userurel = db.UserMessage.Where(s => s.HotelID == hotel.HotelID).FirstOrDefault();
var usme = db.UserMessage.Find(userurel.UserID);
usme.UserGrade = "管理员";
user_roles user_Roles = new user_roles();
user_Roles.UserPhone = usme.UserPhone;
user_Roles.user_roles1 = usme.UserGrade;
db.user_roles.Add(user_Roles);
}
else
{
var userurel = db.UserMessage.Where(s => s.HotelID == hotel.HotelID).FirstOrDefault();
var usme = db.UserMessage.Find(userurel.UserID);
usme.UserGrade = "用户";
var usrolfirst = db.user_roles.Where(s => s.UserPhone == usme.UserPhone).FirstOrDefault();
var usrol = db.user_roles.Find(usrolfirst.user_rolesID);
db.user_roles.Remove(usrol);
}
return(db.SaveChanges() > 0);
}
public static int insertOrder(Order order)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
db.Order.Add(order);
return(db.SaveChanges());
}
}
internal static int insertCompletePayment(Order order)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var orders = db.Order.Where(t => t.OutTradeNo == order.OutTradeNo).ToList().FirstOrDefault();
orders.Ordertime = order.Ordertime;
orders.ActualPrice = order.ActualPrice;
orders.OrderNumber = order.OrderNumber;
orders.OrderState = "已支付";
db.Entry(orders).State = EntityState.Modified;
db.SaveChanges();
var Room = db.RoomMessage.Where(t => t.RoomID == orders.RoomID).ToList().FirstOrDefault();
Room.RoomCount = Room.RoomCount - orders.Ordercount;
db.Entry(Room).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public ActionResult HotelOrderdtld(int id, string OrderState)
{
SmartRentalSystemEntities db = new SmartRentalSystemEntities();
var order = db.Order.Include("RoomMessage").Where(t => t.OrderID == id).FirstOrDefault();
order.OrderState = OrderState;
var or = db.Order.Find(id); 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();
return(Content("<script>alert('修改成功');location.href = '/GHotelHome/HotelOrder';</script>"));
}
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 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));
}
}
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 IHttpActionResult setEvaluate(int userId)
{
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var liu = db.View_UserBrHishory.OrderByDescending(s => s.BrowseID).Where(t => t.UserID == userId).Take(3).ToList();
db.SaveChanges();
if (liu.Count == 0)
{
return(Ok(0));
}
else
{
return(Ok(liu));
}
}
}
public IHttpActionResult kkk(dynamic data)
{
IAopClient client = new DefaultAopClient(URL, APPID, APP_PRIVATE_KEY, FORMAT, "2.0", "RSA2", ALIPAY_PUBLIC_KEY, CHARSET, false);
// 商户订单号，和交易号不能同时为空
string out_trade_no = "20200709104925";
// 支付宝交易号，和商户订单号不能同时为空
string trade_no = "2020070922001450210500981173";
// 退款金额，不能大于订单总金额
string refund_amount = "110.00";
// 退款原因
string refund_reason = "我就是想退款";
// 退款单号，同一笔多次退款需要保证唯一，部分退款该参数必填。
string out_request_no = "16541";
AlipayTradeRefundModel model = new AlipayTradeRefundModel();
model.OutTradeNo = data.data.OutTradeNo;
model.TradeNo = data.data.TradeNo;
model.RefundAmount = data.data.RefundAmount;
model.RefundReason = data.data.RefundReason;
model.OutRequestNo = DateTime.Now.ToString("yyyyMMddHHmmss");
AlipayTradeRefundRequest request = new AlipayTradeRefundRequest();
request.SetBizModel(model);
AlipayTradeRefundResponse response = null;
response = client.SdkExecute(request);
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
var ode = db.Order.Where(t => t.OrderNumber == model.OutTradeNo).ToList().FirstOrDefault();
ode.OrderState = "退款";
db.SaveChanges();
}
//Execute(request);
return(Ok(response.Body));
}
public ActionResult DeleteRoom(int id)
{
SmartRentalSystemEntities dbContext = new SmartRentalSystemEntities();
var s = dbContext.RoomMessage.Find(id);
if (s.RoomCount == s.RoomRemain)
{
var htole = dbContext.HotelManag.Find(s.HotelID);
if (htole.HotelDiscount >= s.RoomPrice)
{
var hoteldipri = dbContext.RoomMessage.Where(d => d.HotelID == s.HotelID && d.RoomPrice > s.RoomPrice).OrderBy(r => r.RoomPrice).FirstOrDefault();
htole.HotelDiscount = hoteldipri.RoomPrice;
}
s.Roomstate = false;
dbContext.SaveChanges();
return(Content("ok:删除成功"));
}
else
{
return(Content("no:删除失败"));
}
}
public ActionResult RecommendAlter(int?Hotelrecommen, int?OldHotelrecommen, int?HotelID, string HotelName, string HotelNames)
{
//Hotelrecommen，OldHotelrecommen需要更新的图像字段，HotelID酒店选择的id，HotelName，HotelNames所选择的酒店名
if (Hotelrecommen == null && HotelID == null)
{
ViewBag.hh = OldHotelrecommen;
ViewBag.kk = HotelNames;
var hotels = db.HotelManag.Include("HotelPhoto").Where(t => t.HotelName.Contains(HotelName)).ToList();
return(View(hotels));
}
else
{
HotelManag hotelManag = db.HotelManag.Where(t => t.Hotelrecommen == OldHotelrecommen).FirstOrDefault();
hotelManag.Hotelrecommen = Hotelrecommen;
db.Entry(hotelManag).State = EntityState.Modified;//标注
HotelManag hotelManag1 = db.HotelManag.Where(t => t.HotelID == HotelID).FirstOrDefault();
hotelManag1.Hotelrecommen = OldHotelrecommen;
db.Entry(hotelManag1).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Recommend"));
}
}
public ActionResult EditRoom(RoomMessage roomMessage, string[] RoomFacility)
{
string fi = "";
foreach (var item in RoomFacility)
{
//可以自己写Insert语句(添加数据)
fi = fi + "+" + item.ToString();//这样写方便调时看
}
roomMessage.RoomFacility = fi;
System.Web.HttpFileCollection file = System.Web.HttpContext.Current.Request.Files;
var photocount = file.Count;
string[] imgname = new string[photocount];
if (photocount > 0 && file[0].FileName != "")
{
for (int i = 0; i < photocount; i++)
{
if (file[i].FileName == "" || file[i].FileName == null)
{
imgname[i] = "";
}
else
{
string guid = Guid.NewGuid().ToString();
string path = "~/images/Roomphoto/" + guid + file[i].FileName;
file[i].SaveAs(Server.MapPath(path));//必须得是相对路径
imgname[i] = "/images/Roomphoto/" + guid + file[i].FileName;
}
}
}
RoomPhoto roomph = new RoomPhoto();
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{ var hotmana = db.RoomMessage.Find(roomMessage.RoomID);
if (roomMessage.RoomRemain >= (hotmana.RoomRemain - hotmana.RoomCount))
{
if (imgname[0] != "" && imgname[0] != null)
{
for (int i = 0; i < photocount; i++)
{
if (i == 0)
{
roomph.PhotoName1 = imgname[i].ToString();
}
if (i == 1)
{
roomph.PhotoName2 = imgname[i].ToString();
}
if (i == 2)
{
roomph.PhotoName3 = imgname[i].ToString();
}
if (i == 3)
{
roomph.PhotoName4 = imgname[i].ToString();
}
if (i == 4)
{
roomph.PhotoName5 = imgname[i].ToString();
}
if (i == 5)
{
roomph.PhotoName6 = imgname[i].ToString();
}
if (i == 6)
{
roomph.PhotoName7 = imgname[i].ToString();
}
}
for (int s = photocount; s < 7; s++)
{
if (s == 0)
{
roomph.PhotoName1 = null;
}
if (s == 1)
{
roomph.PhotoName2 = null;
}
if (s == 2)
{
roomph.PhotoName3 = null;
}
if (s == 3)
{
roomph.PhotoName4 = null;
}
if (s == 4)
{
roomph.PhotoName5 = null;
}
if (s == 5)
{
roomph.PhotoName6 = null;
}
if (s == 6)
{
roomph.PhotoName7 = null;
}
}
roomph.RoomPhotoID = (int)roomMessage.RoomPhotoID;
db.Entry(roomph).State = EntityState.Modified;
db.SaveChanges();
}
hotmana.MattresID = roomMessage.MattresID;
hotmana.RoomTypeID = roomMessage.RoomTypeID;
hotmana.RoomName = roomMessage.RoomName;
hotmana.RoomLayout = roomMessage.RoomLayout;
hotmana.RoomFacility = roomMessage.RoomFacility;
hotmana.RoomCount = roomMessage.RoomRemain - (hotmana.RoomRemain - hotmana.RoomCount);
hotmana.RoomRemain = roomMessage.RoomRemain;
hotmana.PrimeCost = roomMessage.PrimeCost;
hotmana.RoomPrice = roomMessage.RoomPrice;
var htole = db.HotelManag.Find(hotmana.HotelID);
if (htole.HotelDiscount > hotmana.RoomPrice)
{
htole.HotelDiscount = hotmana.RoomPrice;
}
hotmana.Boolbreakfast = roomMessage.Boolbreakfast;
//db.Entry(manag).State = EntityState.Modified;
db.SaveChanges();
return(Content("<script>alert('修改成功');location.href = '/GHotelHome/RoomIndex';</script>"));
}
else
{
return(Content("<script>alert('修改失败，房间数量小于该房间已出售数量');location.href = '/GHotelHome/EditRoom?id=" + roomMessage.RoomID + "';</script>"));
} }
}
public System.Web.Mvc.ActionResult Index(RoomMessage roomMessage, string[] RoomFacility)
{
string fi = "";
foreach (var item in RoomFacility)
{
//可以自己写Insert语句(添加数据)
fi = fi + "+" + item.ToString();//这样写方便调时看
}
roomMessage.RoomFacility = fi;
int hotelID = int.Parse(Session["HotelID"].ToString());
System.Web.HttpFileCollection file = System.Web.HttpContext.Current.Request.Files;
var photocount = file.Count;
string[] imgname = new string[photocount];
if (photocount > 0 && file[0].FileName != "")
{
for (int i = 0; i < photocount; i++)
{
if (file[i].FileName == "" || file[i].FileName == null)
{
imgname[i] = "";
}
else
{
string guid = Guid.NewGuid().ToString();
string path = "~/images/Roomphoto/" + guid + file[i].FileName;
file[i].SaveAs(Server.MapPath(path));//必须得是相对路径
imgname[i] = "/images/Roomphoto/" + guid + file[i].FileName;
}
}
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
RoomPhoto roomph = new RoomPhoto();
for (int i = 0; i < photocount; i++)
{
if (i == 0)
{
roomph.PhotoName1 = imgname[i].ToString();
}
if (i == 1)
{
roomph.PhotoName2 = imgname[i].ToString();
}
if (i == 2)
{
roomph.PhotoName3 = imgname[i].ToString();
}
if (i == 3)
{
roomph.PhotoName4 = imgname[i].ToString();
}
if (i == 4)
{
roomph.PhotoName5 = imgname[i].ToString();
}
if (i == 5)
{
roomph.PhotoName6 = imgname[i].ToString();
}
if (i == 6)
{
roomph.PhotoName7 = imgname[i].ToString();
}
}
var bb = db.RoomPhoto.Add(roomph);
db.SaveChanges();
int photoID = bb.RoomPhotoID;
roomMessage.RoomPhotoID = photoID;
roomMessage.RoomCount = roomMessage.RoomRemain;
roomMessage.HotelID = hotelID;
db.RoomMessage.Add(roomMessage);
var htole = db.HotelManag.Find(hotelID);
if (htole.HotelDiscount > roomMessage.RoomPrice)
{
htole.HotelDiscount = roomMessage.RoomPrice;
}
db.SaveChanges();
//if (db.SaveChanges()>0)
//return Content("<script>alert('添加成功');location.href='/GHotelHome/Index'</script>");
}
return(Content("<script>alert('添加成功');location.href = '/GHotelHome/Index';</script>"));
}
return(Content("<script>alert('添加失败');location.href = '/GHotelHome/Index';</script>"));
}
public ActionResult MainEdit(HotelManag manag, string city, string province, string[] HotelFacility)
{
if (city.Substring(0, 1) == "市" || city.Substring(0, 1) == "县")
{
manag.HotelCity = province;
}
else
{
manag.HotelCity = city;
}
string fi = "";
foreach (var item in HotelFacility)
{
//可以自己写Insert语句(添加数据)
fi = fi + "+" + item.ToString();//这样写方便调时看
}
manag.HotelFacility = fi;
System.Web.HttpFileCollection file = System.Web.HttpContext.Current.Request.Files;
var photocount = file.Count;
string[] imgname = new string[photocount];
if (photocount > 0)
{
for (int i = 0; i < photocount; i++)
{
if (file[i].FileName == "" || file[i].FileName == null)
{
imgname[i] = "";
}
else
{
string guid = Guid.NewGuid().ToString();
string path = "~/images/HotelPhoto/" + guid + file[i].FileName;
file[i].SaveAs(Server.MapPath(path));//必须得是相对路径
imgname[i] = "/images/HotelPhoto/" + guid + file[i].FileName;
}
}
}
using (SmartRentalSystemEntities db = new SmartRentalSystemEntities())
{
if (imgname[0] != "" && imgname[0] != null)
{
HotelPhoto roomph = new HotelPhoto();
for (int i = 0; i < photocount; i++)
{
if (i == 0)
{
roomph.Hotelphoto1 = imgname[i].ToString();
}
if (i == 1)
{
roomph.Hotelphoto2 = imgname[i].ToString();
}
if (i == 2)
{
roomph.Hotelphoto3 = imgname[i].ToString();
}
if (i == 3)
{
roomph.Hotelphoto4 = imgname[i].ToString();
}
if (i == 4)
{
roomph.Hotelphoto5 = imgname[i].ToString();
}
if (i == 5)
{
roomph.Hotelphoto6 = imgname[i].ToString();
}
if (i == 6)
{
roomph.Hotelphoto7 = imgname[i].ToString();
}
}
for (int s = photocount; s < 7; s++)
{
if (s == 0)
{
roomph.Hotelphoto1 = null;
}
if (s == 1)
{
roomph.Hotelphoto2 = null;
}
if (s == 2)
{
roomph.Hotelphoto3 = null;
}
if (s == 3)
{
roomph.Hotelphoto4 = null;
}
if (s == 4)
{
roomph.Hotelphoto5 = null;
}
if (s == 5)
{
roomph.Hotelphoto6 = null;
}
if (s == 6)
{
roomph.Hotelphoto7 = null;
}
}
roomph.HotelPhotoID = (int)manag.HotelPhotoID;
db.Entry(roomph).State = EntityState.Modified;
db.SaveChanges();
}
var hotmana = db.HotelManag.Find(manag.HotelID);
hotmana.HotelName = manag.HotelName;
hotmana.HotelCity = manag.HotelCity;
hotmana.AddressDetails = manag.AddressDetails;
hotmana.HotelType = manag.HotelType;
hotmana.HotelIntro = manag.HotelIntro;
hotmana.HotelBoss = manag.HotelBoss;
hotmana.HotelRule = manag.HotelRule;
hotmana.HotelFacility = manag.HotelFacility;
hotmana.HotelPhone = manag.HotelPhone;
hotmana.HotelOpentime = manag.HotelOpentime;
//db.Entry(manag).State = EntityState.Modified;
db.SaveChanges();
}
return(Content("<script>alert('修改成功');location.href = '/GHotelHome/MainIndex';</script>"));
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="user">用户注册信息</param>
internal static bool Registr(UserMessage user)
{
db.UserMessage.Add(user);
return(db.SaveChanges() > 0);
}
