/// <summary>
/// Write the dataset to the stream using the specified format.
/// </summary>
/// <param name="destination"></param>
/// <param name="source"></param>
/// <param name="format"></param>
public static void Write(System.IO.Stream destination, System.Data.DataSet source, StreamDataSetFormat format)
{
switch (format)
{
case StreamDataSetFormat.XML:
source.WriteXml(destination, System.Data.XmlWriteMode.WriteSchema);
break;
case StreamDataSetFormat.Binary:
BinWriteDataSetToStream(destination, source);
break;
default:
throw new ApplicationException("StreamDataSet Format not supported");
}
}
//construct HTML code
static string getHTML(System.Data.DataTable dt)
{
string xsltFilePath = @"C:\Users\Kelly\Documents\schedule\MySchedule\MySchedule\bin\Debug\XSLTFile1.xslt";
TextWriter txtwriter = new StringWriter();
dt.WriteXml(txtwriter);
XDocument xmlDoc = XDocument.Parse(txtwriter.ToString());
XDocument htmlDoc = new XDocument();
using (XmlWriter writer = htmlDoc.CreateWriter())
{
XslCompiledTransform xslt = new XslCompiledTransform();
xslt.Load(xsltFilePath);
xslt.Transform(xmlDoc.CreateReader(), writer);
}
return htmlDoc.Document.ToString();
}
/// <summary>
/// 设置表类型配置
/// </summary>
/// <param name="ClassName">类名</param>
/// <param name="TableElementName">表元素名</param>
/// <param name="dt">表配置</param>
public void SetTableConfig(string ClassName, string TableElementName, System.Data.DataTable dt)
{
if (xn == null)
{
throw new System.Exception("请先设置 Root!");
}
System.Xml.XmlNode xn1 = xn.SelectSingleNode(ClassName);
if (xn1 == null)
{
xn1 = xd.CreateElement(ClassName);
xn.AppendChild(xn1);
}
System.Xml.XmlNode xn2 = xn1.SelectSingleNode(TableElementName);
if (xn2 == null)
{
xn2 = xd.CreateElement(TableElementName);
xn1.AppendChild(xn2);
}
if (xn2 != null && xn2.ChildNodes.Count > 0)
{
xn2.InnerXml = string.Empty;
}
StringWriter sw = new StringWriter();
dt.WriteXml(sw, System.Data.XmlWriteMode.WriteSchema);
xn2.InnerXml = sw.ToString();
}
