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

程序员文章站 2022-04-08 17:45:59

private void button1_Click(object sender, EventArgs e) { string txt = this.richTextBox1.Text; txt = txt.Replace("\n", ",").Replace(" ", "!"). Replac..... ......

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;
        }

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

上一篇：使用python 获取进程pid号的方法

下一篇：这辈子、下辈子、也配不齐