public bool Exists(int s_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from jmp_statistics"); strSql.Append(" where "); strSql.Append(" s_id = @s_id "); SqlParameter[] parameters = { new SqlParameter("@s_id", SqlDbType.Int, 4) }; parameters[0].Value = s_id; return(DbHelperSQLTotal.Exists(strSql.ToString(), parameters)); }
public bool Exists(int r_id, int r_userid, decimal r_moneys, DateTime r_date) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from jmp_sales_user"); strSql.Append(" where "); strSql.Append(" r_id = @r_id and "); strSql.Append(" r_userid = @r_userid and "); strSql.Append(" r_moneys = @r_moneys and "); strSql.Append(" r_date = @r_date "); SqlParameter[] parameters = { new SqlParameter("@r_id", SqlDbType.Int, 4), new SqlParameter("@r_userid", SqlDbType.Int, 4), new SqlParameter("@r_moneys", SqlDbType.Money, 8), new SqlParameter("@r_date", SqlDbType.DateTime) }; parameters[0].Value = r_id; parameters[1].Value = r_userid; parameters[2].Value = r_moneys; parameters[3].Value = r_date; return(DbHelperSQLTotal.Exists(strSql.ToString(), parameters)); }