public void DocumentDelete(TBL_DOCUMENT document)
{
try
{
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
if (DeleteTools.DeleteDocumentInfo(u => u.documentId == document.documentId) == true)
{
Response.Write("<script>alert('删除成功！');</script>");
Response.Redirect("/Document/Index");
}
else
{
Response.Write("<script>alert('不存在删除内容！');</script>");
Response.Redirect("/Document/Index");
}
}
catch
{
}
}
public FileResult DocumentDownload(TBL_DOCUMENT document)
{
TBL_DOCUMENT[] list = SelectTools.SelectDocumentInfo(u => u.documentId == document.documentId, u => u.documentId);
string path = list[0].documentUrl;
string filePath = Server.MapPath(path); //路径
return(File(filePath, "text/plain", "document.excel")); //welcome.txt是客户端保存的名字
}
/// <summary>
/// 往文档数据表中插入数据
/// </summary>
/// <param name="info">新上传的文档数据信息</param>
/// <returns></returns>
public static Boolean InsertDocumentInfo(TBL_DOCUMENT info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
db.TBL_DOCUMENT.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 查找文档数据表中符合条件的信息
/// </summary>
/// <param name="whereLambda">u => u.documentId == info.documentId, u => u.documentId</param>
/// <returns>文档数据数据数组</returns>
public static TBL_DOCUMENT[] SelectDocumentInfo <TKey>(Expression <Func <TBL_DOCUMENT, bool> > whereLambda, Expression <Func <TBL_DOCUMENT, TKey> > orderBy)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_DOCUMENT> dataObject = db.TBL_DOCUMENT.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_DOCUMENT>;
TBL_DOCUMENT[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
TBL_DOCUMENT[] nullInfo = new TBL_DOCUMENT[0];
return(nullInfo);
}
}
public ActionResult SaveImage(TBL_DOCUMENT info)
{
try
{
HttpPostedFileBase imageName = Request.Files["image"];// 从前台获取文件
if (imageName == null)
{
return(Content("(error)未获取到文件"));
}
string file = imageName.FileName;
string fileFormat = file.Split('.')[file.Split('.').Length - 1]; // 以“.”截取，获取“.”后面的文件后缀
Regex imageFormat = new Regex(@"^(bmp)|(png)|(gif)|(jpg)|(jpeg)"); // 验证文件后缀的表达式（自己写的，不规范别介意哈）
if (string.IsNullOrEmpty(file) || !imageFormat.IsMatch(fileFormat)) // 验证后缀，判断文件是否是所要上传的格式
{
return(Content("(error)文件格式支持(bmp)|(png)|(gif)|(jpg)|(jpeg)"));
}
else
{
string timeStamp = DateTime.Now.Ticks.ToString(); // 获取当前时间的string类型
string firstFileName = timeStamp.Substring(0, timeStamp.Length - 4); // 通过截取获得文件名
string imageStr = "/img/"; // 获取保存图片的项目文件夹
string uploadPath = Server.MapPath("~/" + imageStr); // 将项目路径与文件夹合并
string pictureFormat = file.Split('.')[file.Split('.').Length - 1]; // 设置文件格式
string fileName = firstFileName + "." + fileFormat; // 设置完整（文件名+文件格式）
string saveFile = uploadPath + fileName; //文件路径
imageName.SaveAs(saveFile); // 保存文件
string image = imageStr + fileName; // 设置数据库保存的路径
ViewBag.pictureAdr = image;
ViewBag.appInfo = info;
if (info.documentId != 0)
{
return(View("Index"));
}
else
{
return(View("Index"));;
}
}
}
catch
{
return(Content("上传出错！"));
}
}
/// <summary>
/// 修改TBL_DOCUMENT表的数据
/// </summary>
/// <param name="whereLambda"> (u=>u.documentId == info.documentId, info) == true </param>
/// 判断有无documentId
/// <param name="info"> info是需要修改的信息 </param>
/// <notice></notice>
public static Boolean UpdateDocumentInfo(Expression <Func <TBL_DOCUMENT, bool> > whereLambda, TBL_DOCUMENT info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_DOCUMENT> dataObject = db.TBL_DOCUMENT.Where(whereLambda) as DbQuery <TBL_DOCUMENT>;
TBL_DOCUMENT oldInfo = dataObject.FirstOrDefault();
oldInfo.documentKind = info.documentKind;
oldInfo.documentNote = info.documentNote;
oldInfo.documentUrl = info.documentUrl;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
