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