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