/// <summary> /// 分页获取数据 /// </summary> /// <param name="start">起始记录号</param> /// <param name="limit">每页记录数</param> /// <param name="type">方式:0sql升序分页,1sql降序分页;10存储过程升序,11存储过程降序</param> /// <param name="Extconditions">EXT查询条件</param> /// <param name="conditions">普通查询条件</param> /// <returns>返回符合记录的当前页数据</returns> public IList <T> FindAllByPage(int start, int limit, int type, string Extconditions, string where) { CJSearchSql CJSearchSql = new CJSearchSql(); string con = CJSearchSql.GetConditonSQL(Extconditions); con = con.Length <= 0 ? where : con + (where.Length > 0 ? " and " + where : ""); if (type == 0) { return(CJDAL.FindAllByPageAsc(start, limit, con)); } else if (type == 1) { return(CJDAL.FindAllByPageDesc(start, limit, con)); } else if (type == 10) { return(CJDAL.FindByProcPage(start, limit, con, 0)); } else if (type == 11) { return(CJDAL.FindByProcPage(start, limit, con, 1)); } else { return(null); } }
public DataTable GetDtByCondition(string Extconditions) { CJSearchSql CJSearchSql = new CJSearchSql(); string con = CJSearchSql.GetConditonSQL(Extconditions); return(CJDAL.GetDtByCondition(con)); }
/// <summary> /// 查找符合条件记录的总条数 /// </summary> /// <param name="Extconditions">Ext查询条件</param> /// <param name="conditions">普通查询条件</param> /// <returns>返回符合的记录条数</returns> public string GetTotalCount(string Extconditions, string where) { CJSearchSql CJSearchSql = new CJSearchSql(); string con = CJSearchSql.GetConditonSQL(Extconditions); con = con.Length <= 0 ? where : con + (where.Length > 0 ? " and " + where : ""); return(CJDAL.GetTotalCount(con)); }