public ActionResult Create([Bind(Include = "KeChengID,KeChengName")] MyTable1 myTable1) { if (ModelState.IsValid) { db.MyTable1.Add(myTable1); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(myTable1)); }
public ActionResult Create([Bind(Include = "StudentID,StudentName,RuXueShiJian")] MyTable2 myTable2) { if (ModelState.IsValid) { db.MyTable2.Add(myTable2); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(myTable2)); }
public ActionResult Create([Bind(Include = "ID,StudentID,KeChengID,Grade")] MyTable3 myTable3) { if (ModelState.IsValid) { db.MyTable3.Add(myTable3); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.KeChengID = new SelectList(db.MyTable1, "KeChengID", "KeChengName", myTable3.KeChengID); ViewBag.StudentID = new SelectList(db.MyTable2, "StudentID", "StudentName", myTable3.StudentID); return(View(myTable3)); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { using (var context = new MyDb2()) { var user = new User(); user.Email = model.Email; user.UserId = model.UserId; user.Password = model.Password; context.User.Add(user); if (context.SaveChanges() > 0) { return(RedirectToAction("Login", "Account")); } else { return(RedirectToAction("Register", "Account")); } } //AddErrors(result); } return(View(model)); }
//修改密码 public ActionResult XGMM(string nowPsw, string newPsw) { using (var context = new MyDb2()) { string ud = (string)Session["userId"]; var query = from t in context.User where t.UserId == ud select t; if (query.Count() > 0) { if (query.First().Password == nowPsw) { query.First().Password = newPsw; } else { return(Content("原始密码输入错误!")); } } try { context.SaveChanges(); return(Content("修改密码成功!")); } catch { return(Content("抱歉,系统出错!")); } } }
//删除功能 public ActionResult deleteImg(string imgId) { using (var context = new MyDb2()) { //操作image表,删除图片记录 var image = new Models.Image(); var query = from t in context.Image where t.ImgId == imgId select t; if (query.Count() == 0) { return(Content("q = 0")); } context.Image.Remove(query.First()); try { context.SaveChanges(); return(Content("删除成功!")); } catch (DbEntityValidationException dbEx) { return(Content("删除失败!")); } } }
public ActionResult Create([Bind(Include = "StudentID,StudentName,Sex,RuXueShiJian")] MyTable2 myTable2) { if (ModelState.IsValid) { try { db.MyTable2.Add(myTable2); db.SaveChanges(); } catch (DataException err) { ModelState.AddModelError("StudentID", "(已存在该学号,不能重复添加)。\n" + err.Message); return(View(myTable2)); } return(RedirectToAction("Index")); } return(View(myTable2)); }
public ActionResult Create([Bind(Include = "KeChengID,KeChengName")] MyTable1 myTable1) { if (ModelState.IsValid) { try { db.MyTable1.Add(myTable1); db.SaveChanges(); } catch { ModelState.AddModelError("KeChengID", "库中已存在该课程编号,不能重复添加。"); return(View(myTable1)); } return(RedirectToAction("Index")); } return(View(myTable1)); }
//上传图片 public ActionResult Uploads(string path, string imgName, int imgType) { //根据路径获取图片并将其转化为二进制流 FileStream fs = new FileStream(path, FileMode.Open);//可以是其他重载方法 byte[] byData = new byte[fs.Length]; fs.Read(byData, 0, byData.Length); //BinaryReader br = new BinaryReader(fs); //byte[] byData = br.ReadBytes((int)fs.Length); //将流读入到字节数组中 //获取图片的像素宽和像素高 System.Drawing.Image tempimage = System.Drawing.Image.FromStream(fs, true); var width = tempimage.Width; var height = tempimage.Height; //获取当前时间戳 TimeSpan ts1 = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0); //将图片存入数据库 using (var context = new MyDb2()) { var image = new Models.Image(); image.ImgId = Convert.ToInt64(ts1.TotalMilliseconds).ToString(); image.ImgType = imgType; image.ImgName = imgName; image.ImgContent = byData; image.UserId = (string)Session["userId"]; image.ImgWidth = width; image.ImgHight = height; context.Image.Add(image); try { context.SaveChanges(); return(Content("上传成功!")); } catch (DbEntityValidationException dbEx) { return(Content("系统错误,上传失败!")); } } }
//收藏功能 public ActionResult Collection(string imgId, string userId) { var res = ""; //获取当前时间戳 TimeSpan ts2 = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0); using (var context = new MyDb2()) { //通过userId查询该用户所有已收藏图片的imgId var query = from t in context.Collection where t.UserId == userId select t.ImgID; if (query.Count() > 0) { //判断是否有本次要收藏的图片的imgId foreach (var v in query) { if (v == imgId) { res = "该图片已收藏!"; } } //如果res为空,证明改图片未被该用户收藏过 if (res == "") { //操作Collection表,插入新收藏的图片 var collection = new Models.Collection(); collection.CollectId = Convert.ToInt64(ts2.TotalMilliseconds).ToString(); collection.ImgID = imgId; collection.UserId = userId; context.Collection.Add(collection); //操作Image表,将被收藏图片的CollectNum属性值加1 var query1 = from t in context.Image where t.ImgId == imgId select t; if (query1.Count() > 0) { query1.First().CollectNum += 1; } try { context.SaveChanges(); return(Content("收藏成功!")); } catch (DbEntityValidationException dbEx) { return(Content("系统错误!")); } } else { return(Content(res)); } } else { return(Content("系统错误!")); } } }