使用反射来完成数据插入

        private void Execute<T>(T model,string sql, List<EleQuantity> list, bool fos)
        {
            Type t = model.GetType();
            PropertyInfo[] PropertyList = t.GetProperties();
            using (MySqlTransaction tar = myCon.BeginTransaction())
            {
                try
                {
                    MySqlCommand cmd = myCon.CreateCommand();
                    cmd.Transaction = tar;
                    cmd.CommandText = sql;
                    foreach (var item in list)
                    {

                        foreach (var prlist in PropertyList)
                        {
                            string name = prlist.Name;                  //这里只是为了调试查看属性值
                            object value = prlist.GetValue(item, null);
                            cmd.Parameters.AddRange(new[]
                            { 
                               
                                new MySqlParameter(name, value)
                            });
                        }
                        cmd.ExecuteNonQuery();
                        cmd.Parameters.Clear();
                    }
                    tar.Commit();
                    if (fos)
                    {
                        myCon.Close();
                    }
                }
                catch (Exception)
                {
                    tar.Rollback();
                    myCon.Close();
                    throw;
                }
            }

        }