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 async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return(View(model)); } // 这不会计入到为执行帐户锁定而统计的登录失败次数中 // 若要在多次输入错误密码的情况下触发帐户锁定,请更改为 shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.UserId, model.Password, model.RememberMe, shouldLockout : false); using (var context = new MyDb2()) { var query = from t in context.User where t.UserId == model.UserId && t.Password == model.Password select t; if (query.Count() > 0) { Session["userId"] = model.UserId; Session["status"] = "1"; //ViewBag.text ="1"; return(RedirectToAction("MainIndex", "Home")); } else { ModelState.AddModelError("", "代码无效。"); return(View(model)); } } }
//主页面获取所有图片 public ActionResult GetImgInfo() { var list = new List <Models.Image>(); using (var context = new MyDb2()) { var query = from t in context.Image select t; if (query.Count() > 0) { foreach (var item in query) { Models.Image image = new Models.Image() { ImgId = item.ImgId, ImgName = item.ImgName, ImgType = item.ImgType, ImgWidth = item.ImgWidth, ImgHight = item.ImgHight, CollectNum = item.CollectNum, DownNum = item.DownNum }; list.Add(image); } return(Json(list)); } else { 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 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 InitMyDb2() { MyDb2 db = new MyDb2(); MyDb2InitAlways context = new MyDb2InitAlways(); context.InitializeDatabase(db); ViewBag.Count1 = db.MyTable1.Count(); ViewBag.Count2 = db.MyTable2.Count(); ViewBag.Count3 = db.MyTable3.Count(); return(PartialView()); }
//获取我收藏的图片 public ActionResult GetCollectImgInfo() { List <string> collectImgId = new List <string>(); //Array[] arr = new Array[]; var collectlist = new List <Models.Collection>(); var list = new List <Models.Image>(); using (var context = new MyDb2()) { string userId = (string)Session["userId"]; var query = from t in context.Collection where t.UserId == userId select t.ImgID; var q = from t in context.Image select t; if (query.Count() > 0) { foreach (var item in query) { collectImgId.Add(item); } foreach (var item in q) { foreach (var i in collectImgId) { if (item.ImgId == i) { Models.Image image = new Models.Image() { ImgId = item.ImgId, ImgName = item.ImgName, ImgType = item.ImgType, ImgWidth = item.ImgWidth, ImgHight = item.ImgHight, CollectNum = item.CollectNum, DownNum = item.DownNum }; list.Add(image); } } } return(Json(list)); } else { return(Content("未收藏图片!")); } } }
public void FormattingWithSqlParameterThatIsNotNullSqlServerDatabase() { var cmd = new SqlCommand(); cmd.Parameters.Add(new SqlParameter("Test", SqlDbType.NVarChar)); var db = new MyDb2(); Assert.AreEqual("DECLARE @0 NVarChar[4000] = 'value'\n\nsql @0", db.FormatCommand("sql @0", new object[] { "value" })); Assert.AreEqual("DECLARE @0 Int = '32'\n\nsql @0", db.FormatCommand("sql @0", new object[] { 32 })); Assert.AreEqual("DECLARE @0 DateTime = '" + DateTime.Today + "'\n\nsql @0", db.FormatCommand("sql @0", new object[] { DateTime.Today })); var guid = Guid.NewGuid(); Assert.AreEqual("DECLARE @0 UniqueIdentifier = '" + guid + "'\n\nsql @0", db.FormatCommand("sql @0", new object[] { guid })); }
public HomeController() { using (var context = new MyDb2()) { var query = from t in context.Image select t; if (query.Count() > 0) { foreach (var item in query) { dictionary.Add(item.ImgId, item.ImgContent); } } } }
//上传图片 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 My() { var userId = (string)Session["userId"]; ViewBag.userId = userId; //查询用户上传图片数量 using (var context = new MyDb2()) { var query = from t in context.Image where t.UserId == userId select t; ViewBag.uploadNum = query.ToList().Count; } if (Request.IsAjaxRequest()) { return(PartialView()); } else { return(View()); } }
public ActionResult FindPsw(string email) { Regex re = new Regex(@"[\w!#$%&'*+/=?^_`{|}~-]+(?:\.[\w!#$%&'*+/=?^_`{|}~-]+)*@(?:[\w](?:[\w-]*[\w])?\.)+[\w](?:[\w-]*[\w])?"); //实例化一个Regex对象 if (re.IsMatch(email) == true) //验证数据是否匹配 { var psw = ""; //根据邮箱查询数据库 using (var context = new MyDb2()) { var query = from t in context.User where t.Email == email select t.Password; if (query.Count() > 0) { foreach (var p in query) { psw = p; } //定义邮件内容 string content = "您的密码为: " + psw; //发送该用户密码至其输入的邮箱 var checkInfo = SendEmail(email, content); return(Content(checkInfo)); } else { return(Content("邮箱不存在!")); } } } else { return(Content("邮箱格式错误!"));//不匹配则弹出”邮箱错误“ } }
public void FormattingWithStringValueSqlServerDatabase() { var db = new MyDb2(); Assert.AreEqual("DECLARE @0 NVarChar[4000] = 'value'\n\nsql @0", db.FormatCommand("sql @0", new object[] { "value" })); }
public void FormattingWithNullValueSqlServerDatabase() { var db = new MyDb2(); Assert.AreEqual("DECLARE @0 NVarChar = null\n\nsql @0", db.FormatCommand("sql @0", new object[] { null })); }
//收藏功能 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("系统错误!")); } } }