c# DataSet数据存到List集合里

提供一个方法：   DataSet数据存到List集合里

        private void GetVW_STAT_SSGL_ZLTJ()
        {
           //VW_STAT_SSGL_ZLTJModel
            DataSet set = MySqlHelper.ExecuteDataSet(connectionCX, "select * from VW_STAT_SSGL_ZLTJ");
            try
            {
                List<VW_STAT_SSGL_ZLTJModel> list = new List<VW_STAT_SSGL_ZLTJModel>();
                DateTime dt = DateTime.Now;
                for (int i = 0; i < set.Tables[0].Rows.Count; i++)
                {
                    VW_STAT_SSGL_ZLTJModel sm = new VW_STAT_SSGL_ZLTJModel();
                    sm.TJRQ = set.Tables[0].Rows[i]["TJRQ"].ToString();
                    sm.XZQH = set.Tables[0].Rows[i]["XZQH"].ToString();
                    sm.RWZS = Convert.ToInt32(set.Tables[0].Rows[i]["RWZS"]);
                    sm.HSZS = Convert.ToInt32(set.Tables[0].Rows[i]["HSZS"]);
                    sm.XZQHMC = set.Tables[0].Rows[i]["XZQHMC"].ToString();
                    sm.SJ = dt;
                    list.Add(sm);
                }
                string namse = DataHelper.GetSqlNamesByModel(new VW_STAT_SSGL_ZLTJModel());
                string values = DataHelper.GetSqlValuesByModel(list, new VW_STAT_SSGL_ZLTJModel());
                MySqlHelper.ClearDataByName("VW_STAT_SSGL_ZLTJ", connection);
                MySqlHelper.InsertDataByName("VW_STAT_SSGL_ZLTJ", namse, values, connection);
                Console.WriteLine(DateTime.Now + "数据入库成功");

            }
            catch (Exception ex)
            {
                Console.WriteLine("Error___ " + DateTime.Now + ex.Message);
                WriteLogsHelper.ErrorLogs(" ", ex.Message, " ");
            }
        }