/// <summary>
/// 添加预习总结
/// </summary>
/// <param name="yx"></param>
/// <returns></returns>
public bool AddYuXi(YuXi yx)
{
//插入文件信息
var file = new UploadFile()
{
UploadTime = DateTime.Now,
UploadFileName = yx.UploadFileNameyx,
Describe = yx.Describeyx,
UploadFilePath = yx.UploadFilePath
};
context.UploadFiles.Add(file);
//如果插入文件成功则继续插入作业信息
if (context.SaveChanges() > 0)
{
var yxzj = new YXZJ()
{
Z_Have = yx.Z_Have,
Z_NotHave = yx.Z_NotHave,
Y_Have = yx.Y_Have,
Y_NotHave = yx.Y_NotHave
};
context.YXZJs.Add(yxzj);
if (context.SaveChanges() > 0)
{
var uploadFileId = Convert.ToInt32((context.UploadFiles.Where(s => s.UploadFilePath == yx.UploadFilePath).Select(m => m.UploadFileId).ToList())[0]);
var yxzjId = (from a in context.YXZJs
orderby a.YXZJId descending
select a.YXZJId).ToList()[0];
//int uploadFileId = Convert.ToInt32();
var Yuxi = new Homework()
{
StudentNo = yx.StudentNo,
ChapterId = yx.ChapterId,
HomeworkTypeId = yx.HomeworkTypeId,
UploadFileId = uploadFileId,
YXZJId = yxzjId
};
context.Homework.Add(Yuxi);
if (context.SaveChanges() > 0)
{
return(true);
}
}
}
return(false);
}
/// <summary>
/// 预习总结上传
/// </summary>
/// <param name="yx"></param>
/// <param name="uploadFilelx"></param>
/// <returns></returns>
public ActionResult Yuxi(YuXi yx, HttpPostedFileBase uploadFileyx)
{
yx.HomeworkTypeId = 1;
yx.StudentNo = Convert.ToInt32(this.User.Identity.Name);
//设置文件名
string fileName = yx.StudentNo + "/" + yx.StudentNo + "-" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + "-" + DateTime.Now.Millisecond + ".zip";
//文件保存路径
string path = Server.MapPath("~/WorkSpances/YXZJ/" + yx.StudentNo + "/");
//如果路径不存在则创建
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string uploadFilePath = "~/WorkSpances/YXZJ/" + fileName;
string uploadFilePathRe = Server.MapPath(uploadFilePath);
yx.UploadFileNameyx = fileName;
uploadFileyx.SaveAs(uploadFilePathRe);
yx.UploadFilePath = uploadFilePath;
student.AddYuXi(yx);
return(Content("<script>alert('上传成功！');location.href='" + Url.Action("Index") + "'</script>"));
}
public bool AddYuXi(YuXi yx)
{
return(student.AddYuXi(yx));
}
