便于开发的Helper类_.NET_编程开发_程序员俱乐部

一、将config封装实体层；

例子config：

class="brush:csharp;gutter:true;"><?xml version="1.0" encoding="utf-8" ?>
<Settings>
  <CRMSettings>
    <UserName>administrator</UserName>
    <Password>Sh123456</Password>
    <Domain>SSO.COM</Domain>
    <ConnectionString>Data Source=.;Initial Catalog=XHMZJ_MSCRM;User ID=sa;password=Sh123456</ConnectionString>
  </CRMSettings>
  <DataSourceSettings>
    <ConnectionString>Data Source=.;Initial Catalog=XH_YWXT;User ID=sa;password=Sh123456</ConnectionString>
  </DataSourceSettings>
</Settings>

 1.对于web版本的web.config。

 public class ConfigHelper
    {
        private static ConfigHelper _instance = null;
        public static ConfigHelper Instance
        {
            get
            {
                if (_instance == null)
                    _instance = new ConfigHelper();
                return _instance;
            }
        }
        public ConfigHelper()
        {
            this.CRMConfigInstance = new CRMConfig();
            Exception Ex = null;
            try
            {

                this.CRMConfigInstance.ServerURL = System.Configuration.ConfigurationManager.AppSettings["WebUrl"];
                this.CRMConfigInstance.UserName = System.Configuration.ConfigurationManager.AppSettings["UserName"];
                this.CRMConfigInstance.Password = System.Configuration.ConfigurationManager.AppSettings["Password"];
                this.CRMConfigInstance.Domain = System.Configuration.ConfigurationManager.AppSettings["Domain"];
                this.CRMConfigInstance.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MZJCRM"].ConnectionString;

            }
            catch (Exception ex)
            {
                Ex = ex;
            }
            finally
            {
                if (Ex != null)
                {
                    //ExceptionHelper.WriteLog(Ex);
                }
            }
        }
        public CRMConfig CRMConfigInstance = null;

    }

    public class CRMConfig
    {

        private string _ConnectionString;
        public string ConnectionString
        {
            set { _ConnectionString = value; }
            get { return _ConnectionString; }
        }

        #region CRMConfig
        private string _serverURL;
        public string ServerURL
        {
            set { _serverURL = value; }
            get { return _serverURL; }
        }

        private string _userName;
        public string UserName
        {
            set { _userName = value; }
            get { return _userName; }
        }
        private string _password;
        public string Password
        {
            set { _password = value; }
            get { return _password; }
        }
        private string _domain;
        public string Domain
        {
            set { _domain = value; }
            get { return _domain; }
        }
        #endregion
    }

 2.应用程序版本的config。

public class ConfigHelper
    {
        private static ConfigHelper _instance = null;
        public static ConfigHelper Instance
        {
            get
            {
                if (_instance == null)
                    _instance = new ConfigHelper();
                return _instance;
            }            
        }
        const string configFileName = "CRMConfig.xml";
        protected XmlDocument doc;
        public ConfigHelper()
        {
            this.CRMConfigInstance = new CRMConfig();
            this.SourceConfigInstance = new SourceConfig();


            doc = new XmlDocument();
            Exception Ex = null;
            try
            {
                doc.Load(this.FileFullPath);
                XmlNode Settings = doc.DocumentElement.SelectSingleNode("Settings");
                //CRMSettings
                XmlNode CrmSettings = doc.DocumentElement.SelectSingleNode("CRMSettings");
                XmlNode WebUrl = CrmSettings.SelectSingleNode(@"WebUrl");
                XmlNode UserName = CrmSettings.SelectSingleNode(@"UserName");
                XmlNode Password = CrmSettings.SelectSingleNode(@"Password");
                XmlNode Domain = CrmSettings.SelectSingleNode(@"Domain");
                XmlNode CRMConnectionString = CrmSettings.SelectSingleNode(@"ConnectionString");
                //DataSourceSettings
                XmlNode DataSourceSettings = doc.DocumentElement.SelectSingleNode("DataSourceSettings");
                XmlNode SourceConnectionString = DataSourceSettings.SelectSingleNode(@"ConnectionString");

              
                this.CRMConfigInstance.UserName = UserName.InnerText;
                this.CRMConfigInstance.Password = Password.InnerText;
                this.CRMConfigInstance.Domain = Domain.InnerText;
                this.CRMConfigInstance.ServerURL = WebUrl.InnerText;
                this.CRMConfigInstance.ConnectionString = CRMConnectionString.InnerText;

                this.SourceConfigInstance.ConnectionString = SourceConnectionString.InnerText;

            }
            catch(Exception ex)
            {
                Ex = ex;
            }
            finally
            {
                if(Ex != null)
                {
                    ExceptionHelper.WriteLog(Ex);
                }
            }
        }

        private string _filePath;
        public string FilePath
        {
            set { this._filePath = value; }
            get
            {
                return System.Windows.Forms.Application.StartupPath;
            }
        }
        /// <summary>
        /// full path
        /// </summary>
        public string FileFullPath
        {
            get
            {
                return System.IO.Path.Combine(this.FilePath, configFileName);
            }
        }

        public CRMConfig CRMConfigInstance = null;
        public SourceConfig SourceConfigInstance = null;

    }

    public class CRMConfig
    {

        private string _ConnectionString;
        public string ConnectionString
        {
            set { _ConnectionString = value; }
            get { return _ConnectionString; }
        }

        #region CRMConfig
        private string _serverURL;
        public string ServerURL
        {
            set { _serverURL = value; }
            get { return _serverURL; }
        }

        private string _userName;
        public string UserName
        {
            set { _userName = value; }
            get { return _userName; }
        }
        private string _password;
        public string Password
        {
            set { _password = value; }
            get { return _password; }
        }
        private string _domain;
        public string Domain
        {
            set { _domain = value; }
            get { return _domain; }
        }
        #endregion
    }
    public class SourceConfig
    {
        private string _ConnectionString;
        public string ConnectionString
        {
            set { _ConnectionString = value; }
            get { return _ConnectionString; }
        }
    }

二、SqlHeleper类

 1   public static class SQLHelper
 2     {
 3         public static DataTable GetDataTable(string sqlStr, params SqlParameter[] sqlParameters)
 4         {
 5             using (SqlConnection conn = new SqlConnection(ConfigHelper.Instance.CRMConfigInstance.ConnectionString))
 6             {
 7                 conn.Open();
 8                 using (SqlCommand cmd = conn.CreateCommand())
 9                 {
10                     cmd.CommandText = sqlStr;
11                     foreach (SqlParameter sqlParameter in sqlParameters)
12                     {
13                         cmd.Parameters.Add(sqlParameter);
14                     }
15                     DataSet dataSet = new DataSet();
16                     SqlDataAdapter adapter = new SqlDataAdapter(cmd);
17                     adapter.Fill(dataSet);
18                     return dataSet.Tables[0];
19                 }
20             }
21         }
22 
23         public static string XMLDocumentToString(ref   XmlDocument doc)
24         {
25             MemoryStream stream = new MemoryStream();
26             XmlTextWriter writer = new XmlTextWriter(stream, null);
27             writer.Formatting = Formatting.Indented;
28             doc.Save(writer); //转换
29 
30             StreamReader sr = new StreamReader(stream, System.Text.Encoding.UTF8);
31             stream.Position = 0;
32             string xmlString = sr.ReadToEnd();
33             sr.Close();
34             stream.Close();
35 
36             return xmlString;
37         }
38 
39         public static int ExecuteNonQuerys(string SQL, params SqlParameter[] commandParameters)
40         {
41             SqlCommand cmd = new SqlCommand();
42 
43             using (SqlConnection connection = new SqlConnection(ConfigHelper.Instance.CRMConfigInstance.ConnectionString))
44             {
45                 PrepareCommand(cmd, connection, null, CommandType.Text, SQL, commandParameters);
46                 int val = cmd.ExecuteNonQuery();
47                 
48                 cmd.Parameters.Clear();
49                 return val;
50             }
51         }
52 
53         private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)
54         {
55 
56             //判断数据库连接状态
57             if (conn.State != ConnectionState.Open)
58                 conn.Open();
59 
60             cmd.Connection = conn;
61             cmd.CommandText = cmdText;
62 
63             //判断是否需要事物处理
64             if (trans != null)
65                 cmd.Transaction = trans;
66 
67             cmd.CommandType = cmdType;
68 
69             if (cmdParms != null)
70             {
71                 foreach (SqlParameter parm in cmdParms)
72                     cmd.Parameters.Add(parm);
73             }
74         }
75     }