SklDataProvider/DataSourceFactory.cs at master · 4color/SklDataProvider · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
/*******************************************************************
 * Created : zhuyf
 * Date    : 2017-7-28
 *
 * ****************************************************************/
using System;

namespace SklDataProvider
{
    /// <summary>
    /// DataSourceFactory 的摘要说明。
    /// </summary>
    public class DataSourceFactory
    {
        public static string connectionString = "";
        public static string databaseType = "sqlserver";

        public DataSourceFactory()
        {
            //
            // TODO: 在此处添加构造函数逻辑

        }

        #region Create Data Source Instance

        public static SklDataSource CreateInstance()
        {
            return DataSourceFactory.CreateInstance(connectionString, databaseType);

        }


        /// <summary>
        /// Create GisqDataSource object.
        /// </summary>
        /// <param name="connectionString">
        /// Connection string.
        /// SqlServer : Server=[NetSDK];Initial Catalog=[pubs];uid=[sa];pwd=123
        /// Oracle    : Data Source = [GisqOA];User Id=[UserID];Password=[Password]
        /// Access    : Provider = Microsoft.Jet.OLEDB.4.0;Data Source=[C:\Northwind.mdb]
        /// </param>
        /// <returns>GisqDataSource object.</returns>
        public static SklDataSource CreateInstance(string connectionString)
        {
            return DataSourceFactory.CreateInstance(connectionString, "sqlserver");
        }

        /// <summary>
        /// Create GisqDataSource object.
        /// </summary>
        /// <param name="connectionString">Connection string.</param>
        /// <param name="dbType">Database type.(Sql Server default)</param>
        /// <returns>GisqDataSource object.</returns>
        public static SklDataSource CreateInstance(string connectionString, string databaseType)
        {
            SklDataSource dataSource = null;
            switch (databaseType.ToLower())
            {
                case "sqlserver":
                    dataSource = new SqlDataSource(connectionString);
                    break;
                case "oracle":
                    dataSource = new OracleDataSource(connectionString);
                    break;
                case "oledb":
                    dataSource = new OleDataSource(connectionString);
                    break;
                case "oraoracle":
                    dataSource = new OraOracleDataSource(connectionString);
                    break;
                case "mysql":
                    dataSource = new MysqlDataSource(connectionString);
                    break;
                case "sqlite":
                    dataSource = new SqliteDataSource(connectionString);
                    break;
                default:
                    dataSource = new SqlDataSource(connectionString);
                    break;
            }

            return dataSource;
        }

        public static SklDataSource CreateInstance(string dataSource, string catalog, string username, string password, string databaseType)
        {
            string connectionString = "";
            switch (databaseType.ToLower())
            {
                case "sqlserver":
                    connectionString = "Data Source=" + dataSource + ";Initial Catalog=" + catalog + ";User ID=" + username + ";Password=" + password;
                    break;
                case "oracle":
                    connectionString = "Data Source=" + dataSource + ";User ID=" + username + ";Password=" + password;
                    break;
                case "oraoracle":
                    connectionString = "Data Source=" + dataSource + ";User ID=" + username + ";Password=" + password;
                    break;
            }
            return DataSourceFactory.CreateInstance(connectionString, databaseType);
        }

        #endregion
    }
}