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