生成测试数据，导入MySQL

public class BISDT
    {
        public static void DoTest()
        {
            for (int i = 0; i < 4; i++)
                CreateDataToDB();
        }

        static void CreateDataToDB()
        {
            // ready txt file
            Random rd = new Random();
            StreamWriter sw = new StreamWriter("bis06.txt", false, Encoding.UTF8);

            string sql = "{1},{0},{0},{0},{0},{0} ,{0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0},{0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0},{0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0}, {0},0, ,0,0,0,0,0,{2}, ,{2}";
            //double tnum = ;
            //string bcode = ;

            for (int i = 0; i < 1000000; i++)
            {
                sw.WriteLine(sql, rd.Next(100, 99999) + Math.Round(rd.NextDouble(), 3), Guid.NewGuid().ToString().Replace("-", "").ToUpper(), DateTime.Now);
                Console.Write(".");
            }

            sw.Close();
            Console.WriteLine("end");

            //load to db

            MySqlConnection con = new MySqlConnection("Data Source=192.168.10.102;database=neware_bis_test;user id=root;password=123456;Port=3308;");
            MySqlCommand cmd = new MySqlCommand();
            cmd.Connection = con;

            string cmdText = "LOAD DATA local INFILE 'D:\\BIS\\tdata\\code\\bis06.txt' INTO TABLE battery_test2 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";


            con.Open();


            cmd.CommandText = cmdText;

            cmd.ExecuteNonQuery();

            Console.Write("db ok");



            con.Close();
        }
    }