public List<UserEntity> GetUsers(int skip, int pagesize, string userName, out int count)
{
StringBuilder sql = new StringBuilder();
sql.Append(" select Uid,Name,Photo,RolesIds,Status from t_users ");
if (!string.IsNullOrEmpty(userName))
{
sql.Append(" where Uid like @Uid ");
}
if (pagesize != 0)
{
sql.Append(" Limit @count Offset @skip ");
}
SQLiteParameter[] para = new SQLiteParameter[] {
new SQLiteParameter("@count", pagesize),
new SQLiteParameter("@skip", skip),
new SQLiteParameter("@Uid", "%"+userName+"%")
};
SqlLiteHelper sqliteHelper = new SqlLiteHelper();
DataTable dataTable = sqliteHelper.GetDataTable(sql.ToString(), para);
List<UserEntity> userEntities = new List<UserEntity>();
foreach (DataRow dataRow in dataTable.Rows)
{
userEntities.Add(Conver2Entity(dataRow));
}
count = sqliteHelper.GetCount("t_users");
return userEntities;
}
/// <summary>获取角色列表
/// </summary>
/// <param name="skip">跳过的记录数</param>
/// <param name="count">获取的数量</param>
/// <returns></returns>
public List<RoleEntity> GetRoles(int skip, int pagesize, string RoleName, out int count)
{
StringBuilder sql = new StringBuilder();
sql.Append("select Id,Name,RightIds,IsSuper from t_roles ");
if (!string.IsNullOrEmpty(RoleName))
{
sql.Append(" where Name=@Name ");
}
if (pagesize != 0)
{
sql.Append(" Limit @count Offset @skip ");
}
SqlLiteHelper sqliteHelper = new SqlLiteHelper();
SQLiteParameter[] para = new SQLiteParameter[] {
new SQLiteParameter("@count", pagesize), new SQLiteParameter("@skip", skip),
new SQLiteParameter("@Name", RoleName)
};
DataTable dataTable = sqliteHelper.GetDataTable(sql.ToString(), para);
List<RoleEntity> roleEntities = new List<RoleEntity>();
foreach (DataRow dataRow in dataTable.Rows)
{
roleEntities.Add(Conver2Entity(dataRow));
}
count = sqliteHelper.GetCount("t_roles");
return roleEntities;
}
