sqlserver2008升级2016存储过程语法修改工具V2

  private void btnUpdate_Click(object sender, EventArgs e)
        {
   
            List<string> listFileName = Directory.GetFiles(@AppConfig.FilePath).ToList();
            StringBuilder text = new StringBuilder();
            bool twoLine = false;
            //StringBuilder strBox = new StringBuilder();
            listFileName.ForEach(f =>
            {
   
                File.Delete(@"D:\temp2\" + Path.GetFileName(f));
                StreamWriter sw = new StreamWriter(@"D:\temp2\" + Path.GetFileName(f), true, Encoding.UTF8);
                using (FileStream fs = new FileStream(f, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
                {
   
                    using (StreamReader sr = new StreamReader(fs, Encoding.UTF8))
                    {
       //raiserror 99999999 'no data by b2b order info.'
                         //update by wangjp 20201027 begin
                         //Regex regex = new Regex(@"^[0-9]{1,7}$");
                        Regex regex = new Regex(@"^[0-9]{1,8}$");
                        //update by wangjp 20201027 end
                        while (sr.Peek() > -1)
                        {
   
                            string line = sr.ReadLine();
                            if (twoLine)
                            {
   
                                text.Append(line.Replace('\'', '"').Split('"').ToList()[0] + "',16,1)");
                                sw.WriteLine(text);
                                text.Clear();
                                twoLine = false;
                                continue;
                            }
                            if ((line.IndexOf("raiserror", StringComparison.CurrentCultureIgnoreCase) != -1) &&
                               (!line.Trim().StartsWith("/*")) && (!line.Trim().EndsWith("*/")) && (!line.Trim().StartsWith("--"))
                               && (!line.Contains("@")) && (!line.Trim().EndsWith("\"")) && (!line.Trim().EndsWith("'"))
                               && (!line.Trim().EndsWith(";")) && (!line.Trim().EndsWith(")"))
                               && (!(line.Split('\'').ToList().Where(x => !string.IsNullOrEmpty(x.Trim())).Last().ToUpper()