工作日记--将接口表直接变成查询的代码

private void button1_click(object sender, eventargs e)
        {
            string txt = this.richtextbox1.text;
            txt = txt.replace("\n", ",").replace("    ", "!").
                replace("        ", "!").        
                replace("            ", "!").
                replace("                ", "!").
                replace("                    ", "!").
                replace("                        ", "!").
                replace("                            ", "!").
                replace("                            ", "!").
                replace(",", "],max(case when col_name_en ='").
                replace("!", "' then actual else null end) as ").
                replace("as","as [").replace("[ ","[");
            this.richtextbox2.text = "max(case when col_name_en ='" + txt;
        }