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