managesyslogs.cs

自己编写的基本Orcale的通用的数据库初始化工具。

using System;

namespace DS.EMIS.StartPrepare.Common
{
	/// <summary>
	/// ManageSysLogs 的摘要说明。
	/// </summary>
	internal class ManageSysLogs
	{
		public ManageSysLogs()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/*
		 * <LocalConfig>
         *      <xs:schema id="LocalConfig" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
         *          <xs:element name="LocalConfig" msdata:IsDataSet="true" msdata:Locale="zh-CN">
         *             <xs:complexType>
         *                  <xs:choice maxOccurs="unbounded">
         *                      <xs:element name="表名">
         *                        <xs:complexType>
         *                           <xs:sequence>
         *                              <xs:element name="字段名1" type="xs:string" minOccurs="0" />
         *                              <xs:element name="字段名2" type="xs:string" minOccurs="0" />
         *                           </xs:sequence>
         *                        </xs:complexType>
         *                      </xs:element>
         *                  </xs:choice>
         *             </xs:complexType>
         *           </xs:element>
         *       </xs:schema>
         *       <表名>
         *           <字段名1>值</字段名1>
         *           <字段名2>值</字段名2>
         *       </表名>
         *       <表名>
         *           <字段名1>值</字段名1>
         *           <字段名2>值</字段名2>
         *       </表名>
         *  </LocalConfig>
		 * 
		 */

		public System.Data.DataSet ReadDataFromDataFile(string fileName)
		{
			System.Data.DataSet dsReturn =null;
			try
			{
                string currAppPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
				System.IO.StreamReader fsReadMXL = new System.IO.StreamReader(currAppPath + ".\\SysData\\"+fileName,System.Text.Encoding.GetEncoding("gb2312"));
				dsReturn= new System.Data.DataSet("LocalConfig");
				dsReturn.ReadXml(fsReadMXL);
				fsReadMXL.Close();
			}
			catch(Exception ex)
			{
				throw new Exception(ex.Message);
			}
			return dsReturn;
		}
		public void WriteDataToDataFile(string fileName,System.Data.DataSet dataSet)
		{
			try
			{
                string currAppPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
				System.IO.StreamWriter myFileName = new System.IO.StreamWriter(currAppPath + ".\\SysData\\"+fileName,false,System.Text.Encoding.GetEncoding("gb2312"));
				dataSet.WriteXml( myFileName,System.Data.XmlWriteMode.IgnoreSchema);
				myFileName.Close();
			}
			catch(Exception ex)
			{
				throw new Exception(ex.Message);
			}
		}


	}
}