public RepXML GetRepXMLData(string RepID)
{
RepXML rx = new RepXML();
string sql = String.Format("select TemplateStyle from TUFO_ReportTemplateModel where TemplateID={0}", RepID);
//Console.WriteLine(sql);
try
{
SqlCommand cmd = new SqlCommand(sql, mainSQL);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
string RepXMLStr = (string)sdr.GetSqlString(0);
RepXMLStr = RepXMLStr.Replace("=\"", " ='").Replace("\" ", "' ").Replace("类 ='", "类 =\"").Replace("\"", "~").Replace("'", "\"");
//Console.WriteLine("GetRepXMLData: " + RepXMLStr);
rx.RTM_Doc = new XmlDocument();
rx.RTM_Doc.LoadXml(RepXMLStr);
}
sdr.Close();
cmd.Dispose();
//Console.WriteLine(rx.RootNode.InnerXml.ToString());
}
catch (Exception ex)
{
Console.WriteLine("GetRepXMLData: " + ex.Message);
}
string sql2 = String.Format("select FormulaText from TUFO_ReportTemplateFormulas where TemplateID={0}", RepID);
//Console.WriteLine(sql);
try
{
SqlCommand cmd = new SqlCommand(sql2, mainSQL);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
string RepXMLStr = (string)sdr.GetSqlString(0);
//RepXMLStr = RepXMLStr.Replace("=\"", " ='").Replace("\" ", "' ").Replace("类 ='", "类 =\"").Replace("\"", "~").Replace("'", "\"");
//Console.WriteLine("GetRepXMLData: " + RepXMLStr);
rx.RTF_Doc = new XmlDocument();
rx.RTF_Doc.LoadXml(RepXMLStr);
}
sdr.Close();
cmd.Dispose();
//Console.WriteLine(rx.RootNode.InnerXml.ToString());
}
catch (Exception ex)
{
Console.WriteLine("GetRepXMLData: " + ex.Message);
}
return(rx);
}
public string GetXMLValueByRC(RepXML RX, NumericUpDown rowno, NumericUpDown colno, string VType = "snix")
{
string namepath = String.Format("Sheet/cell[@row='{0}' and @col='{1}']", rowno.Value, colno.Value);
string rStr = "";
switch (VType)
{
case "snix":
rStr = RX.RTM_RootNode.SelectSingleNode(namepath).InnerXml;
break;
case "snafv":
rStr = RX.RTM_RootNode.SelectSingleNode(namepath).Attributes["FormulaText"].Value;
break;
default:
rStr = RX.RTM_RootNode.SelectSingleNode(namepath).InnerXml;
break;
}
return(rStr);
}
