BLL:
public List<xjz.Model.user> GetModelList(string strWhere, int pageNo, int pageSize, string orderBy)
{DataSet ds = dal.GetList(strWhere, pageNo, pageSize, orderBy);
return DataTableToList(ds.Tables[0]);
}
DAL:
public DataSet GetList(string strWhere, int pageNo, int pageSize, string orderBy)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserId,UserName,UserPassword,Email,Tel,UserSex,TureName,UserAge,UserXingQu,UserTouXiang,LastLoginIp,UserJiFen,UserZhuCeTime,LastLoginTime,Type,SelfIntroduction,Tuijian,ClassNum,SchoolId ");
strSql.Append(" FROM user ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" Order By " + orderBy + " ");
strSql.Append(" limit " + ((pageNo - 1) * pageSize) + "," + pageSize + " ");
return DbHelperMySQL.Query(strSql.ToString());
}