public static List <T> GetPageList <T>(string joinTableName, string strWhere, int pageIndex, int pageSize, out int count) where T : new() { List <T> list = new List <T>(); StringBuilder strSql = new StringBuilder(); Type type = typeof(T); string tableName = GetTableName(type); //获得主键 PropertyInfo[] propertys = type.GetProperties(); string keys = string.Empty, tempPropName = string.Empty; foreach (PropertyInfo property in propertys) { tempPropName = property.Name; if (string.IsNullOrEmpty(keys)) { keys = GetTableKey(property, tempPropName); } if (!string.IsNullOrEmpty(keys)) { break; } } if (string.IsNullOrEmpty(keys)) { throw new Exception("未设置主键"); } DataTable table = CommonBase.GetTable(tableName + " TMP " + joinTableName, keys, keys + " DESC", strWhere, pageIndex, pageSize, out count); foreach (DataRow de in table.Rows) { T t = new T(); t = TranEntity <T>(propertys, de); list.Add(t); } return(list); }
/// <summary> /// 插入一个实体,直接插入 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <returns></returns> public static bool Insert <T>(T model) { return(CommonBase.RunListCommit(Insert(model, new List <CommonObject>()))); }
/// <summary> /// 删除一个实体,直接删除 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <returns></returns> public static bool Delete <T>(T model) { return(CommonBase.RunListCommit(Delete(model, new List <CommonObject>()))); }
/// <summary> /// 更新部分字段, /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <param name="fieldName">需要更新的字段数组</param> /// <returns></returns> public static bool Update <T>(T model, string[] fieldName) { return(CommonBase.RunListCommit(Update(model, fieldName, new List <CommonObject>()))); }