文本处理sql

        private void insMSG(string dlgContent)
        {
            char delimCharV = '|';
            string[] splitV = null;
            splitV = dlgContent.Split(delimCharV);

                for (int x = 1; x < splitV.Length; x++)
                {
                    char delimChar = '~';
                    string[] sp = null;
                    string[] split = new string[4];
                    sp = splitV[x].Split(delimChar);

                    if (sp.Length < 2)
                    {
                        x++;
                    }
                    else
                    {
                        split[0] = sp[1].Trim().Substring(0, 19);
                        split[1] = sp[1].Trim().Substring(20, 4);

                        if (sp[2].Trim().Substring(0, 2) == "0,")
                        {
                            sp[2] = sp[2].Replace("0,", "9988,");
                        }

                        split[2] = sp[2].Trim().Substring(0, 4);

                        split[3] = sp[2].Substring(5, sp[2].Length - 5);

                        if (split[3].Length > 1500)
                        {
                            split[3] = split[3].Substring(0, 200);
                        }

                        string insertCmd = "insert into sayDlg (tdate,tfrom,tto,ttext)  values (@tdate,@tfrom,@tto,@ttext)";
                        SqlCommand cmd = new SqlCommand(insertCmd, sqlcon);

                        cmd.Parameters.Add("@tdate", SqlDbType.VarChar).Value = split[0];
                        cmd.Parameters.Add("@tfrom", SqlDbType.VarChar).Value = split[1];
                        cmd.Parameters.Add("@tto", SqlDbType.VarChar).Value = split[2];
                        cmd.Parameters.Add("@ttext", SqlDbType.VarChar).Value = split[3];
                        sqlcon.Open();
                        cmd.ExecuteNonQuery();
                        sqlcon.Close();
                    }                       
                   
                }
        }