public ActionResult Dis_Add_list(Distribution d) { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { HttpFileCollectionBase files = Request.Files; HttpPostedFileBase file = files[0]; //获取文件名后缀 string extName = Path.GetExtension(file.FileName).ToLower(); //获取保存目录的物理路径 if (System.IO.Directory.Exists(Server.MapPath("/Images/")) == false)//如果不存在就创建images文件夹 { System.IO.Directory.CreateDirectory(Server.MapPath("/Images/")); } string path = Server.MapPath("/Images/"); //path为某个文件夹的绝对路径,不要直接保存到数据库 // string path = "F:\\TgeoSmart\\Image\\"; //生成新文件的名称,guid保证某一时刻内图片名唯一(文件不会被覆盖) string fileNewName = Guid.NewGuid().ToString(); string ImageUrl = path + fileNewName + extName; //SaveAs将文件保存到指定文件夹中 file.SaveAs(ImageUrl); //此路径为相对路径,只有把相对路径保存到数据库中图片才能正确显示(不加~为相对路径) string url = "\\Images\\" + fileNewName + extName; d.DistributionImg = fileNewName + extName; d.DistributionTime = Convert.ToDateTime("yyyy-MM-dd HH:mm:ss"); db.Distribution.Add(d); if (db.SaveChanges() > 0) { return(Content("ok")); } else { return(Content("on")); } } }
/// <summary> /// 首页实现步骤 /// </summary> /// <returns></returns> public ActionResult IndexFul() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { } return(View()); }
/// <summary> /// 出入登记显示 /// </summary> /// <returns></returns> public ActionResult Register_list() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Register.Select(x => new { x.RegisterID, x.RegisterName, x.RegisterGoods, x.Distribution.DistributionNum, x.Distribution.DistributionImg, x.Distribution.DistributionAcademic, x.RegisterType, x.RegisterTime }).ToList(); var newdata = new { code = 0, msg = "", count = list.Count, data = list }; return(Json(newdata, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 出入登记 /// </summary> /// <returns></returns> public ActionResult Register() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Register.Select(x => new { x.RegisterID, x.RegisterName, x.RegisterGoods, x.Distribution.DistributionNum, x.Distribution.DistributionImg, x.Distribution.DistributionAcademic, x.RegisterType, x.RegisterTime }).ToList(); ViewBag.count = list.Count; } return(View()); }
/// <summary> /// 保修管理 显示 /// </summary> /// <returns></returns> public ActionResult Repairs_list() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Repairs.Select(x => new { x.RepairsID, x.RepairsDescribe, x.Distribution.DistributionNum, x.RepairsTime }).ToList(); var newdata = new { code = 0, msg = "", count = list.Count, data = list }; return(Json(newdata, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 保修管理视图 /// </summary> /// <returns></returns> public ActionResult Repairs() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Repairs.Select(x => new { x.RepairsID, x.RepairsDescribe, x.Distribution.DistributionNum, x.RepairsTime }).ToList(); ViewBag.count = list.Count; } return(View()); }
/// <summary> /// 旷寝显示 /// </summary> /// <returns></returns> public ActionResult Arrive_list() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Arrive.Select(x => new { x.ArriveID, x.ArriveName, x.ArriveTime, x.Distribution.DistributionNum, x.Distribution.DistributionImg, x.Distribution.DistributionAcademic }).ToList(); var newdata = new { code = 0, msg = "", count = list.Count, data = list }; return(Json(newdata, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 旷寝视图 /// </summary> /// <returns></returns> public ActionResult Arrive() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Arrive.ToList(); ViewBag.count = list.Count; } return(View()); }
/// <summary> /// 通知管理显示 /// </summary> /// <returns></returns> public ActionResult HostelNotice_list() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.HostelNotice.Select(x => new { x.HostelNoticeTitle, x.HostelNoticeCont, x.HostelNoticeTime }).ToList(); var newdata = new { code = 0, msg = "", count = list.Count, data = list }; return(Json(newdata, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 卫生管理显示 /// </summary> /// <returns></returns> public ActionResult Hygiene_list() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Hygiene.Select(x => new { x.HygieneID, x.HygieneType, x.Distribution.DistributionNum }).ToList(); var newdata = new { code = 0, msg = "", count = list.Count, data = list }; return(Json(newdata, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 卫生管理 /// </summary> /// <returns></returns> public ActionResult Hygiene() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Hygiene.Select(x => new { x.HygieneID, x.HygieneType, x.Distribution.DistributionNum }).ToList(); ViewBag.num = list.Count; } return(View()); }
/// <summary> /// 寝室分配人员情况 /// </summary> /// <returns></returns> public ActionResult Distrb() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Distribution.ToList(); ViewBag.count = list.Count; } return(View()); }
/// <summary> /// 通知管理 /// </summary> /// <returns></returns> public ActionResult HostelNotice() { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.HostelNotice.Select(x => new { x.HostelNoticeTitle, x.HostelNoticeCont, x.HostelNoticeTime }).ToList(); ViewBag.hos = list[list.Count - 1].HostelNoticeCont; ViewBag.tit = list[list.Count - 1].HostelNoticeTitle; return(View()); } }
/// <summary> /// 删除 /// </summary> /// <param name="id">需要删除行的ID</param> /// <returns></returns> public ActionResult Del(string id) { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { Distribution list = db.Distribution.Find(int.Parse(id)); db.Distribution.Remove(list); if (db.SaveChanges() > 0) { return(Content("ok")); } else { return(Content("no")); } } }
/// <summary> /// 登录实现步骤 /// </summary> /// <param name="admin"></param> /// <returns></returns> public ActionResult LoginFul(Admin admin) { try { using (DormitoryDBEntitie db = new DormitoryDBEntitie()) { var list = db.Admin.Where(x => x.AdminNumber == admin.AdminNumber && x.AdminPwd == admin.AdminPwd).ToList(); if (list.Count > 0) { return(View("Index")); } else { return(Content("<script>alert('账号或密码错误!!!');history.go(-1);</script>")); } } } catch (Exception) { return(RedirectToAction("Home", "Error")); } }