匹配数据库GO，用来分隔多个SQL程序读取

匹配数据库GO，用来分隔多个sql程序读取

//格式化sql，多个执行语句之间可能有go语句，过滤掉go，分成多个sql来执行
sql = System.Text.RegularExpressions.Regex.Replace(sql, @"[^a-zA-Z0-9]go[^a-zA-Z0-9]","\r\nGO\r\n", System.Text.RegularExpressions.RegexOptions.IgnoreCase);

string[] sqlbuffer = System.Text.RegularExpressions.Regex.Split(sql, @"\r\nGO\r\n");

public static int runSql(string[] sqlbuffer)
        {
            int returnInt = 1;
            //string sOut;
            string sql = "";

                foreach (string varcommandText in sqlbuffer)
                {
                    if (varcommandText != string.Empty)
                    {
                        sql = varcommandText;

                        try
                        {
                            DbHelper db = new DbHelper();

                            DbCommand cmd = db.GetSqlStringCommond(sql);

                            db.ExecuteNonQuery(cmd);

                            //CFunc.WriteFile("单行sql:"+sql + "  - sql\n", "sqlLog");
                        }
                        catch (Exception ee)
                        {
                            CFunc.WriteFile(sql + "运行失败,"+ee.Message+" \n", "sqlLog");
                            returnInt = -13;
                        }

                        //DBHelper.ExecuteCommand(sql);
                    }
                }




            return returnInt;
        }