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); } }