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("系统错误！"));
}
}
}
