.net中webform，winform讀取xml設定檔的方法

webform讀取：

string.Format(SqlConfig.GetSql("SQLServer.QueryTableInfo"), "SysLog");

/// <summary>
        /// 讀取指定SQL
        /// </summary>
        /// <param name="key">sql名稱</param>
        /// <returns>sql字串</returns>
        public static string GetSql(string key)
        {
            string sql = string.Empty;
            try
            {
                string[] sqlLayers = key.Split('.');
                XmlNode xmlNode = ReadMapping(sqlLayers[0]);
                sql = xmlNode.SelectNodes("SqlMaps[@key='" + sqlLayers[1] + "']/SqlMap[@key='" + sqlLayers[2] + "']")[0].InnerText;
            }
            catch (Exception ex)
            {
                DataLib.LogAccess.Log("擷取SQL:" + key + "錯誤：" + ex.ToString());
            }
            return sql;
        }

        /// <summary>
        /// 讀取設定檔中的Mapping節點
        /// </summary>
        /// <param name="key">mapping節點名稱</param>
        /// <returns>Mapping節點下的sqlMap</returns>
        private static XmlNode ReadMapping(string key)
        {
            XmlDocument Xdoc;
            string fileName = HttpContext.Current.Server.MapPath("~/mapping.config");
            //if (HttpContext.Current.Cache["mapping"] == null)
            //{
                Xdoc = new XmlDocument();
                Xdoc.Load(fileName);
                HttpContext.Current.Cache.Add("mapping", Xdoc, new System.Web.Caching.CacheDependency(fileName),
                    DateTime.Now.AddDays(3), TimeSpan.Zero, System.Web.Caching.CacheItemPriority.Default, null);
            //}
            //else
                Xdoc = (XmlDocument)HttpContext.Current.Cache["mapping"];
            return Xdoc.SelectSingleNode("/configuration/mapping[@key='" + key + "']");
        }
    }

 

winfrom讀取

string.Format(SqlConfig.GetSql("SQLServer.QueryTableInfo"), "SysLog");

 /// <summary>
        /// 讀取指定SQL
        /// </summary>
        /// <param name="key">sql名稱</param>
        /// <returns>sql字串</returns>
        public static string GetSql(string key)
        {
            string sql = string.Empty;
            try
            {
                string[] sqlLayers = key.Split('.');
                XmlNode xmlNode = ReadMapping(sqlLayers[0]);
                XmlNodeList list = xmlNode.SelectNodes("Sql");
                foreach (XmlNode node in list)
                {
                    if (node.Attributes["key"].Value.Equals(sqlLayers[1]))
                    {
                        return node.InnerText;
                    }
                }
                sql = xmlNode.SelectNodes("SqlMap[@key='" + sqlLayers[1] + "']")[0].InnerText;
            }
            catch (Exception ex)
            {
                DataLib.LogAccess.Log("擷取SQL:" + key + "錯誤：" + ex.ToString());
            }
            return sql;
        }

        /// <summary>
        /// 讀取設定檔中的Mapping節點
        /// </summary>
        /// <param name="key">mapping節點名稱</param>
        /// <returns>Mapping節點下的sqlMap</returns>
        private static XmlNode ReadMapping(string key)
        {
            XmlDocument Xdoc;
            string fileName = System.Windows.Forms.Application.StartupPath + (@"\SqlMapping.config");
            Xdoc = new XmlDocument();
            Xdoc.Load(fileName);
            XmlNodeList list = Xdoc.SelectNodes("SqlMapping/SqlMaps");
            foreach (XmlNode node in list)
            {
                if (node.Attributes["key"].Value.Equals(key))
                {
                    return node;
                }
            }
            return null;
        }
    }

<?xml version="1.0" encoding="utf-8" ?>
<SqlMapping>
  <SqlMaps key="SQLServer">
    <Sql key="QueryAllTable">
      <![CDATA[
        select name from sysobjects where type='U' and name <>'sysdiagrams' order by name asc
      ]]>
    </Sql>

  </SqlMaps>

</SqlMapping>