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