/// <summary> /// 修改数据 /// </summary> /// <param name="FormID">表单ID</param> /// <param name="content">内容</param> /// <param name="UPDATEUSERID">用户ID</param> /// <param name="UPDATEUSERNAME">用户名</param> /// <returns>bool</returns> public bool UpdateContent(string FormID, byte[] content, UserInfo userinfo) { using (SysRtfBLL bll = new SysRtfBLL()) { return(bll.UpdateContent(FormID, content, userinfo)); } }
/// <summary> /// 数据是否存在 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>bool</returns> public bool IsExits(string FORMID) { using (SysRtfBLL bll = new SysRtfBLL()) { return(bll.IsExits(FORMID)); } }
/// <summary> /// 写入数据 /// </summary> /// <param name="FormID">表单ID</param> /// <param name="content">富文本框内容</param> /// <param name="userinfo">用户实体</param> /// <returns>bool</returns> public bool AddContent(string FormID, byte[] content, string CompanyID, string SystemCode, string ModelName, UserInfo userinfo) { using (SysRtfBLL bll = new SysRtfBLL()) { T_SYS_RTF t_SYS_RTF = new T_SYS_RTF(); t_SYS_RTF.RTFID = Guid.NewGuid().ToString(); t_SYS_RTF.SYSTEMCODE = SystemCode; t_SYS_RTF.COMPANYID = CompanyID; t_SYS_RTF.MODELNAME = ModelName; t_SYS_RTF.FORMID = FormID; t_SYS_RTF.OWNERID = userinfo.USERID; t_SYS_RTF.OWNERNAME = userinfo.USERNAME; t_SYS_RTF.OWNERCOMPANYID = userinfo.COMPANYID; t_SYS_RTF.OWNERDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.OWNERPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEUSERID = userinfo.USERID; t_SYS_RTF.CREATEUSERNAME = userinfo.USERNAME; t_SYS_RTF.CREATECOMPANYID = userinfo.COMPANYID; t_SYS_RTF.CREATEDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.CREATEPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEDATE = DateTime.Now; t_SYS_RTF.CONTENT = content; return(bll.AddContent(t_SYS_RTF)); } }
/// <summary> /// 删除数据 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>bool</returns> public bool DeleteContent(string FORMID) { using (SysRtfBLL bll = new SysRtfBLL()) { return(bll.DeleteContent(FORMID)); } }
/// <summary> /// 获取数据 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>内容</returns> public byte[] GetContent(string FORMID) { try { using (SysRtfBLL bll = new SysRtfBLL()) { try { return bll.GetContent(FORMID); } catch (Exception e) { Tracer.Debug("调用GetContent" + e.InnerException.ToString()); throw e; } } } catch (Exception ex) { Tracer.Debug("调用GetContent" + ex.InnerException.ToString()); throw ex; } }
/// <summary> /// 写入数据 /// </summary> /// <param name="FormID">表单ID</param> /// <param name="content">富文本框内容</param> /// <param name="userinfo">用户实体</param> /// <returns>bool</returns> public bool AddContent(string FormID, byte[] content, string CompanyID, string SystemCode, string ModelName, UserInfo userinfo) { using (SysRtfBLL bll = new SysRtfBLL()) { try { string fileId = Guid.NewGuid().ToString(); T_SYS_RTF t_SYS_RTF = new T_SYS_RTF(); string fileDirectory = AppDomain.CurrentDomain.BaseDirectory + userinfo.COMPANYID + @"\" + userinfo.DEPARTMENTID + @"\" + userinfo.POSTID; DirectoryInfo target = new DirectoryInfo(fileDirectory); if (!target.Exists) { target.Create(); } string filePath = fileDirectory + @"\" + fileId; if (!File.Exists(filePath)) { FileStream fs = File.Create(filePath); //path是文件的路径 fs.Write(content, 0, content.Length); fs.Close(); } t_SYS_RTF.CONTENT = filePath; t_SYS_RTF.RTFID = fileId; t_SYS_RTF.SYSTEMCODE = SystemCode; t_SYS_RTF.COMPANYID = CompanyID; t_SYS_RTF.MODELNAME = ModelName; t_SYS_RTF.FORMID = FormID; t_SYS_RTF.OWNERID = userinfo.USERID; t_SYS_RTF.OWNERNAME = userinfo.USERNAME; t_SYS_RTF.OWNERCOMPANYID = userinfo.COMPANYID; t_SYS_RTF.OWNERDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.OWNERPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEUSERID = userinfo.USERID; t_SYS_RTF.CREATEUSERNAME = userinfo.USERNAME; t_SYS_RTF.CREATECOMPANYID = userinfo.COMPANYID; t_SYS_RTF.CREATEDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.CREATEPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEDATE = DateTime.Now; string pathR = t_SYS_RTF.CONTENT; bool flag = bll.AddContent(t_SYS_RTF); return(flag); }catch (Exception ex) { Tracer.Debug(ex.ToString()); return(false); } } }
/// <summary> /// 获取数据 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>内容</returns> public byte[] GetContent(string FORMID) { try { using (SysRtfBLL bll = new SysRtfBLL()) { try { return(bll.GetContent(FORMID)); } catch (Exception e) { Tracer.Debug("调用GetContent" + e.InnerException.ToString()); throw e; } } } catch (Exception ex) { Tracer.Debug("调用GetContent" + ex.InnerException.ToString()); throw ex; } }
/// <summary> /// 获取数据 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>内容</returns> public string GetContentFormatImgToUrl(string FORMID) { string strContent = string.Empty; string strcon = string.Empty; try { using (SysRtfBLL bll = new SysRtfBLL()) { byte[] context = bll.GetContent(FORMID); strcon = UTF8Encoding.UTF8.GetString(context); } //string strcon = System.IO.File.ReadAllText("c:/神州通在线协同办公平台.htm"); try { // 定义正则表达式用来匹配 img 标签 Regex regImg = new Regex(@"<img\b[^<>]*?\bsrc[\s\t\r\n]*=[\s\t\r\n]*[""']?[\s\t\r\n]*(?<imgUrl>[^\s\t\r\n""'<>]*)[^<>]*?/?[\s\t\r\n]*>", RegexOptions.IgnoreCase); // 搜索匹配的字符串 MatchCollection matches = regImg.Matches(strcon); int n = 0, m = 0; string[] sUrlList = new string[matches.Count]; string[] img = new string[matches.Count]; strContent = strcon; // 取得匹配项列表 foreach (Match match in matches) { img[n++] = match.Groups["imgobj"].Value; //整个IMG 标签 sUrlList[m++] = match.Groups["imgUrl"].Value; //IMG SRC地址 // 判断src的格式是不是内嵌格式。 var temp = match.Groups["imgUrl"].Value; if (temp.Split(',').Count() > 1) { string base64Str = temp.Split(',')[1]; string imageUrl = Base64ToImage(base64Str, FORMID, m.ToString()); strContent = strContent.Replace(match.Groups["imgUrl"].Value, imageUrl); } } string oldString = "<span class=\"s_E6FD2046\"> </span>"; string newString = "<span class=\"s_E6FD2046\"></br></span>"; strContent = strContent.Replace(oldString, newString); return(strContent); // string imgLocalPath = @"D:/web/LoadImge";//存放下载图片的路径 // for (int i = 0; i < sUrlList.Length; i++) // { // string fileName //= sUrlList[i].Substring(sUrlList[i].LastIndexOf("/") + 1, sUrlList[i].Length - sUrlList[i].LastIndexOf("/") - 1); // string urlName = sUrlList[i]; // WebClient wc = new WebClient(); // if (!System.IO.File.Exists(imgLocalPath + "//" + fileName)) // { // wc.DownloadFile(urlName, imgLocalPath + "//" + fileName); // } // //替换掉整个IMG 标签 // strcon = strcon.Replace(img[i], "<img width=220 src=http://localhost/CathImge/" + fileName + "/>"); // //只替换Url // strcon = strcon.Replace(urlName, @"http://localhost/CathImge/" + fileName); // } //return ""; } catch (Exception e) { Tracer.Debug("调用GetContent" + e.InnerException.ToString()); throw e; } // } } catch (Exception ex) { Tracer.Debug("调用GetContent" + ex.InnerException.ToString()); throw ex; } }
/// <summary> /// 获取数据 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>内容</returns> public string GetContentFormatImgToUrl(string FORMID) { string strContent = string.Empty; string strcon = string.Empty; try { using (SysRtfBLL bll = new SysRtfBLL()) { byte[] context = bll.GetContent(FORMID); strcon =UTF8Encoding.UTF8.GetString(context); } //string strcon = System.IO.File.ReadAllText("c:/神州通在线协同办公平台.htm"); try { // 定义正则表达式用来匹配 img 标签 Regex regImg = new Regex(@"<img\b[^<>]*?\bsrc[\s\t\r\n]*=[\s\t\r\n]*[""']?[\s\t\r\n]*(?<imgUrl>[^\s\t\r\n""'<>]*)[^<>]*?/?[\s\t\r\n]*>", RegexOptions.IgnoreCase); // 搜索匹配的字符串 MatchCollection matches = regImg.Matches(strcon); int n = 0, m = 0; string[] sUrlList = new string[matches.Count]; string[] img = new string[matches.Count]; strContent = strcon; // 取得匹配项列表 foreach (Match match in matches) { img[n++] = match.Groups["imgobj"].Value; //整个IMG 标签 sUrlList[m++] = match.Groups["imgUrl"].Value; //IMG SRC地址 // 判断src的格式是不是内嵌格式。 var temp = match.Groups["imgUrl"].Value; if ( temp.Split(',').Count() > 1) { string base64Str = temp.Split(',')[1]; string imageUrl=Base64ToImage(base64Str, FORMID, m.ToString()); strContent = strContent.Replace(match.Groups["imgUrl"].Value, imageUrl); } } string oldString = "<span class=\"s_E6FD2046\"> </span>"; string newString = "<span class=\"s_E6FD2046\"></br></span>"; strContent = strContent.Replace(oldString, newString); return strContent; // string imgLocalPath = @"D:/web/LoadImge";//存放下载图片的路径 // for (int i = 0; i < sUrlList.Length; i++) // { // string fileName //= sUrlList[i].Substring(sUrlList[i].LastIndexOf("/") + 1, sUrlList[i].Length - sUrlList[i].LastIndexOf("/") - 1); // string urlName = sUrlList[i]; // WebClient wc = new WebClient(); // if (!System.IO.File.Exists(imgLocalPath + "//" + fileName)) // { // wc.DownloadFile(urlName, imgLocalPath + "//" + fileName); // } // //替换掉整个IMG 标签 // strcon = strcon.Replace(img[i], "<img width=220 src=http://localhost/CathImge/" + fileName + "/>"); // //只替换Url // strcon = strcon.Replace(urlName, @"http://localhost/CathImge/" + fileName); // } //return ""; } catch (Exception e) { Tracer.Debug("调用GetContent" + e.InnerException.ToString()); throw e; } // } } catch (Exception ex) { Tracer.Debug("调用GetContent" + ex.InnerException.ToString()); throw ex; } }
/// <summary> /// 数据是否存在 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>bool</returns> public bool IsExits(string FORMID) { using (SysRtfBLL bll = new SysRtfBLL()) { return bll.IsExits(FORMID); } }
/// <summary> /// 写入数据 /// </summary> /// <param name="FormID">表单ID</param> /// <param name="content">富文本框内容</param> /// <param name="userinfo">用户实体</param> /// <returns>bool</returns> public bool AddContent(string FormID, byte[] content, string CompanyID, string SystemCode, string ModelName, UserInfo userinfo) { using (SysRtfBLL bll = new SysRtfBLL()) { try { string fileId = Guid.NewGuid().ToString(); T_SYS_RTF t_SYS_RTF = new T_SYS_RTF(); string fileDirectory = AppDomain.CurrentDomain.BaseDirectory + userinfo.COMPANYID + @"\" + userinfo.DEPARTMENTID + @"\" + userinfo.POSTID; DirectoryInfo target = new DirectoryInfo(fileDirectory); if (!target.Exists) { target.Create(); } string filePath = fileDirectory + @"\" + fileId; if (!File.Exists(filePath)) { FileStream fs = File.Create(filePath); //path是文件的路径 fs.Write(content, 0, content.Length); fs.Close(); } t_SYS_RTF.CONTENT = filePath; t_SYS_RTF.RTFID = fileId; t_SYS_RTF.SYSTEMCODE = SystemCode; t_SYS_RTF.COMPANYID = CompanyID; t_SYS_RTF.MODELNAME = ModelName; t_SYS_RTF.FORMID = FormID; t_SYS_RTF.OWNERID = userinfo.USERID; t_SYS_RTF.OWNERNAME = userinfo.USERNAME; t_SYS_RTF.OWNERCOMPANYID = userinfo.COMPANYID; t_SYS_RTF.OWNERDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.OWNERPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEUSERID = userinfo.USERID; t_SYS_RTF.CREATEUSERNAME = userinfo.USERNAME; t_SYS_RTF.CREATECOMPANYID = userinfo.COMPANYID; t_SYS_RTF.CREATEDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.CREATEPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEDATE = DateTime.Now; string pathR = t_SYS_RTF.CONTENT; bool flag = bll.AddContent(t_SYS_RTF); return flag; }catch(Exception ex) { Tracer.Debug(ex.ToString()); return false; } } }
/// <summary> /// 修改数据 /// </summary> /// <param name="FormID">表单ID</param> /// <param name="content">内容</param> /// <param name="UPDATEUSERID">用户ID</param> /// <param name="UPDATEUSERNAME">用户名</param> /// <returns>bool</returns> public bool UpdateContent(string FormID, byte[] content, UserInfo userinfo) { using (SysRtfBLL bll = new SysRtfBLL()) { return bll.UpdateContent(FormID, content, userinfo); } }
/// <summary> /// 删除数据 /// </summary> /// <param name="FORMID">表单ID</param> /// <returns>bool</returns> public bool DeleteContent(string FORMID) { using (SysRtfBLL bll = new SysRtfBLL()) { return bll.DeleteContent(FORMID); } }
/// <summary> /// 写入数据 /// </summary> /// <param name="FormID">表单ID</param> /// <param name="content">富文本框内容</param> /// <param name="userinfo">用户实体</param> /// <returns>bool</returns> public bool AddContent(string FormID, byte[] content, string CompanyID, string SystemCode, string ModelName, UserInfo userinfo) { using (SysRtfBLL bll = new SysRtfBLL()) { T_SYS_RTF t_SYS_RTF = new T_SYS_RTF(); t_SYS_RTF.RTFID = Guid.NewGuid().ToString(); t_SYS_RTF.SYSTEMCODE = SystemCode; t_SYS_RTF.COMPANYID = CompanyID; t_SYS_RTF.MODELNAME = ModelName; t_SYS_RTF.FORMID = FormID; t_SYS_RTF.OWNERID = userinfo.USERID; t_SYS_RTF.OWNERNAME = userinfo.USERNAME; t_SYS_RTF.OWNERCOMPANYID = userinfo.COMPANYID; t_SYS_RTF.OWNERDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.OWNERPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEUSERID = userinfo.USERID; t_SYS_RTF.CREATEUSERNAME = userinfo.USERNAME; t_SYS_RTF.CREATECOMPANYID = userinfo.COMPANYID; t_SYS_RTF.CREATEDEPARTMENTID = userinfo.DEPARTMENTID; t_SYS_RTF.CREATEPOSTID = userinfo.POSTID; t_SYS_RTF.CREATEDATE = DateTime.Now; t_SYS_RTF.CONTENT = content; return bll.AddContent(t_SYS_RTF); } }