/// <summary> /// 影响行数 /// </summary> /// <param name="tableName">表名</param> /// <param name="where">条件</param> /// <param name="param">参数化</param> /// <returns>返回数量</returns> public int RecordCount(string tableName, StringBuilder where, SqlParam[] param) { this.GetInstance(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(1) FROM " + tableName + " WHERE 1=1"); strSql.Append(where); return(DbCommon.GetInt(db.GetObjectValue(strSql, param))); }
/// <summary> /// 影响行数 /// </summary> /// <param name="tableName">表名</param> /// <param name="ht">参数</param> /// <returns>返回数量</returns> public int RecordCount(string tableName, Hashtable ht) { this.GetInstance(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(1) FROM " + tableName + " WHERE 1=1"); foreach (string key in ht.Keys) { strSql.Append(" AND " + key + " = " + DbCommon.ParamKey + "" + key + ""); } return(DbCommon.GetInt(db.GetObjectValue(strSql, DbCommon.GetParameter(ht)))); }
/// <summary> /// 影响行数 /// </summary> /// <param name="tableName">表名</param> /// <param name="pkName">字段主键</param> /// <param name="pkVal">字段值</param> /// <returns>返回数量</returns> public int RecordCount(string tableName, string pkName, string pkVal) { this.GetInstance(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(1) FROM " + tableName + ""); strSql.Append(" where " + pkName + " = " + DbCommon.ParamKey + pkName); SqlParam[] param = { new SqlParam(DbCommon.ParamKey + pkName + "", pkVal) }; return(DbCommon.GetInt(db.GetObjectValue(strSql, param))); }
/// <summary> /// 摘要: /// 数据分页 /// 参数: /// sql:传入要执行sql语句 /// param:参数化 /// orderField:排序字段 /// orderType:排序类型 /// pageIndex:当前页 /// pageSize:页大小 /// count:返回查询条数 /// </summary> public IList GetPageList <T>(string sql, SqlParam[] param, string orderField, string orderType, int pageIndex, int pageSize, ref int count) { StringBuilder builder = new StringBuilder(); try { count = DbCommon.GetInt(GetObjectValue(new StringBuilder("Select Count(1) From (" + sql + ") t"), param)); int num = (pageIndex - 1) * pageSize; int num2 = pageSize; int num3 = num + num2 + 1; builder.Append("select * from(select t.*,rownum rn from(" + sql + " order by " + orderField + " " + orderType + ") t where rownum<" + num3 + ") where rn>" + num + ""); return(GetDataListBySQL <T>(builder, param)); } catch (Exception e) { DbLog.WriteException(e); return(null);; } }