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>())));
}
