TimeZone-时间戳测试

private static void NewMethod()
        {
            Console.WriteLine("请输入产品金额");
            Console.WriteLine("请输入输入参与人数");

            //时间转时间戳
            DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1));
            int start = (int)(DateTime.Now - startTime).TotalSeconds;
            int finish = 0;
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=.;database=DRAW;uid=sa;pwd=123456";
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string strSql = "insert into DRAW_A(code,time) values('{0}','{1}')";
            try
            {
                con.Open();
                int count = 100000;
                int random = 0;
                System.Random ram = new Random();

                for (int i = 0; i < count; i++)
                {
                    random = ram.Next(1, 5000);
                    cmd.CommandText = string.Format(strSql, random, DateTime.Now.ToString("yyyyMMddHHmmss"));
                    cmd.ExecuteNonQuery();
                }

                finish = (int)(DateTime.Now - startTime).TotalSeconds;
            }
            catch
            { }
            finally
            {
                con.Close();
            }

            Console.WriteLine(string.Format("start:{0},finish:{1}", start, finish));

            //时间戳转时间
            TimeSpan span = new TimeSpan(long.Parse(start.ToString() + "0000000"));
            Console.WriteLine(startTime.Add(span).ToString());

            span = new TimeSpan(long.Parse(finish.ToString() + "0000000"));
            Console.WriteLine(startTime.Add(span).ToString());

            Console.WriteLine(startTime.Add(span).ToOADate());
            Console.WriteLine((int)startTime.Add(span).ToOADate());

            DateTime dt = DateTime.FromOADate(startTime.Add(span).ToOADate());
            Console.WriteLine(dt.ToString());

            dt = DateTime.FromOADate((int)startTime.Add(span).ToOADate());
            Console.WriteLine(dt.ToString());
        }