예제 #1
0
        public static string ExecuteTrans(List <string> list, List <DynamicParameters> parms = null)
        {
            string result = "成功";

            string connectstring = ConnStrings.Replace("DBType=SqlServer", "").Replace("DBType=Oracle", "").Replace("DBType=MySql", "");

            using (IDbConnection dbConnection = new SqlConnection(connectstring))
            {
                dbConnection.Open();

                IDbTransaction dbTransaction = dbConnection.BeginTransaction();

                try
                {
                    int num = 0;

                    using (List <string> .Enumerator enumerator = list.GetEnumerator())
                    {
                        while (enumerator.MoveNext())
                        {
                            string current = enumerator.Current;

                            bool flag2 = parms != null && parms.Count - 1 >= num;

                            if (flag2)
                            {
                                dbConnection.Execute(current, parms[num], dbTransaction, CommandTimeout, CommandType.Text);
                            }
                            else
                            {
                                dbConnection.Execute(current, null, dbTransaction, CommandTimeout, CommandType.Text);
                            }

                            num++;
                        }
                    }

                    dbTransaction.Commit();

                    AppLog.WriteDbLog(dbConnection.ConnectionString, string.Join(",", list.ToArray()), result, null);
                }
                catch (Exception ex)
                {
                    dbTransaction.Rollback();

                    AppLog.WriteDbLog(dbConnection.ConnectionString, string.Join(",", list.ToArray()), result + "->" + ex.Message, null);

                    return(result);
                }
            }

            return("OK");
        }
예제 #2
0
 public static string GetConnectionString(string connectionName = "TicketDB")
 {
     return(ConnStrings.GetConnString(connectionName));
 }