修改後的企業庫

企業庫很好用，可是原先的企業庫都是要配置的，應該起來十分不方便，修改了企業庫部分代碼,使得我在程式裡可以這樣使用

 

 1
 2        /**//// <summary>
 3        /// 儲存資料
 4        /// </summary>
 5        private void SaveData(XmlDocument xmlData)
 6        {
 7            DB = DatabaseFactory.CreateDatabase((TransLine.EndConnection as DatabaseConnection).ConnectString, (TransLine.EndConnection as DatabaseConnection).DBDataProvider.Name);
 8
 9            using (DbConnection conn = DB.CreateConnection())
10            {
11                try
12                {
13                    conn.Open();
14                }
15                catch (Exception err)
16                {
17                    throw new Exception("開啟資料連線錯誤：" + err.Message);
18                }
19
20                using (DbCommand cmd = conn.CreateCommand())
21                {
22                    cmd.CommandTimeout = 600;
23                    cmd.Connection = conn;
24                    DbTransaction trans = conn.BeginTransaction();
25                    cmd.Transaction = trans;
26                    foreach (XmlNode dataRow in xmlData.DocumentElement.ChildNodes)
27                    {
28                        try
29                        {
30                            DataRowInToDatabase(cmd, dataRow);
31                            StatusReport("成功", false);
32                        }
33                        catch (Exception err)
34                        {
35                            if (trans != null)
36                                trans.Rollback();
37
38                            StatusReport("失敗", true);
39                            throw err;
40                        }
41                    }
42                    trans.Commit();
43                }
44            }
45        }