/// <summary>
/// 记录条数获取
/// </summary>
/// <param name="whereClause"></param>
/// <returns></returns>
public int Count(string whereClause)
{
if (!string.IsNullOrEmpty(whereClause))
{
whereClause = string.Format(" WHERE {0}", whereClause);
}
var sqlClase = string.Format("SELECT COUNT(*) FROM {0} {1}", TableName, whereClause);
return(TypeParse.StrToInt(DbHelperSql.GetSingle(ConnectionString, sqlClase)));
}
/// <summary>
/// 数据是否存在
/// </summary>
/// <param name="whereClause"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Exists(string whereClause, SqlTransaction transaction)
{
if (!string.IsNullOrEmpty(whereClause))
{
whereClause = string.Format("WHERE {0}", whereClause);
}
var sqlClase = string.Format("IF EXISTS(SELECT 1 FROM {0} {1}) SELECT 1 ELSE SELECT 0", TableName, whereClause);
return(TypeParse.StrToInt(DbHelperSql.GetSingle(ConnectionString, sqlClase)) == 1);
}
/// <summary>
///
/// </summary>
/// <param name="sqlClause"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public object GetSingle(string sqlClause, params SqlParameter[] parameters)
{
return(DbHelperSql.GetSingle(ConnectionString, sqlClause, parameters));
}
