Example #1
0
        /// <summary>
        /// 获取列表模型
        /// <para>(可通过重写GetByDataRow函数更改填充模型数据方式)</para>
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="model"></param>
        /// <param name="wh">sql条件(where字符任意)</param>
        /// <returns></returns>
        public static List <T> FindList(string wh = "")
        {
            List <T> rl  = new List <T>();
            string   sql = GetSelectSQL <T>(wh);

            if (!string.IsNullOrEmpty(sql))
            {
                DataTable dt = Dbop.GetDataTable(sql);
                foreach (DataRow dr in dt.Rows)
                {
                    rl.Add(GetModelByDataRow <T>(dr));
                }
            }
            return(rl);
        }
Example #2
0
        /// <summary>
        /// 获取单个模型
        /// <para>(可通过重写GetByDataRow函数更改填充模型数据方式)</para>
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="model"></param>
        /// <param name="wh">sql条件(where字符任意)</param>
        /// <returns></returns>
        public static T Find(string wh = "")
        {
            string sql = GetSelectSQL <T>(wh);

            if (string.IsNullOrEmpty(sql))
            {
                return(default(T));
            }
            sql = sql.Insert(6, " TOP 1");
            DataTable dt = Dbop.GetDataTable(sql);

            if (dt.Rows.Count == 0)
            {
                return(default(T));
            }
            return(GetModelByDataRow <T>(dt.Rows[0]));
        }