PRivate static string ConnectionString = "**";                 /// <summary>        ///  更新數(shù)據(jù)   沒有sql參數(shù)就直接執(zhí)行          /// </summary>        /// <param name="sql"> 需要執(zhí)行的 sql </param>        /// <param name="o">傳遞的實(shí)體類對(duì)象 要求該類中字段必須和 sql參數(shù)名稱一致 不區(qū)分大小寫 </param>        /// <returns></returns>        public static int UpdateModel(string sql, object o)        {            var s = sql.Split('@');            return Update(sql, s.Length == 1 ? null : GetSqlParameters(o, s));        }        /// <summary>        ///  查詢數(shù)據(jù)        /// </summary>        /// <typeparam name="T">映射的實(shí)體類</typeparam>        /// <param name="sql">執(zhí)行的SQL語句</param>        /// <param name="o">傳遞的實(shí)體類對(duì)象 要求該類中字段必須和 sql參數(shù)名稱一致 不區(qū)分大小寫 </param>        /// <returns></returns>        public static List<T> SeleteModel<T>(string sql, object o) where T : class, new()        {            var s = sql.Split('@');            return Select<T>(sql, s.Length == 1 ? null : GetSqlParameters(o, s));        }        /// <summary>        /// 動(dòng)態(tài)創(chuàng)建SqlParameter 對(duì)象        /// </summary>        /// <param name="o">傳遞的實(shí)體類對(duì)象 要求該類中字段必須和 sql參數(shù)名稱一致 不區(qū)分大小寫 </param>        /// <param name="s">切割后的SQL 語句</param>        /// <returns></returns>        private static SqlParameter[] GetSqlParameters(object o, string[] s)        {            s = s.Select(c => c.Split(' ')[0].Trim()).ToArray();             Type t = o.GetType();            if (t == typeof(object))                throw new Exception("UpdateModel  傳遞的類型是OBJECT 類型");            // 反射 讀取字段 驗(yàn)證是否是 SQL 中的參數(shù)            var tlist =                t.GetFields(BindingFlags.Public | BindingFlags.Instance)                    .Where(c => c.GetValue(o) != null & s.FirstOrDefault(a => a.ToLower() == c.Name.ToLower()) != null)                    .ToList();            // 判斷得到的數(shù)據(jù) 是否和 需要的數(shù)據(jù) 數(shù)量一致            if (tlist.Count() != s.Count() - 1)                throw new Exception("傳遞的實(shí)體中有值參數(shù) 和 sql 中需要的 數(shù)量不相等");            SqlParameter[] sp = new SqlParameter[tlist.Count()];            for (int i = 0; i < s.Length - 1; i++)            {                sp[i] = new SqlParameter(s[i + 1].Trim(), tlist.FirstOrDefault(c => c.Name.ToLower() == s[i + 1].ToLower()).GetValue(o));            }            return sp;        }        private static List<T> SeleteModel<T>(SqlDataReader data) where T : class, new()        {            // 獲取列 個(gè)數(shù)            int iFieldCount = data.FieldCount;            List<T> list = new List<T>();            while (data.Read())            {                T tType = new T();                for (int i = 0; i < iFieldCount; i++)                {                    // 反射注入字段值                    string dataName = data.GetName(i);                    FieldInfo fie = tType.GetType().GetField(dataName);                    if (fie == null)                        continue;                    fie.SetValue(tType, data[dataName]);                }                list.Add(tType);            }            return list;        }        private static List<T> Select<T>(string sql, SqlParameter[] sp) where T : class, new()        {            using (SqlConnection conn = new SqlConnection(ConnectionString))            {                using (SqlCommand com = new SqlCommand(sql, conn))                {                    conn.Open();                    if (sp != null)                        com.Parameters.AddRange(sp);                    return SeleteModel<T>(com.ExecuteReader());                }            }        }        private static int Update(string sql, SqlParameter[] sp)        {            using (SqlConnection conn = new SqlConnection(ConnectionString))            {                using (SqlCommand com = new SqlCommand(sql, conn))                {                    conn.Open();                    if (sp != null)                         com.Parameters.AddRange(sp);                     return com.ExecuteNonQuery();                }            }        }