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); }