public bool ExistValueInActivity(int ValueId, ActivityEnumPrizeType PrizeType)
{
string query = "SELECT COUNT(*)\r\n FROM [Hishop_ActivityAwardItem]\r\n LEFT JOIN dbo.Hishop_Activity \r\n ON Hishop_Activity.ActivityId = Hishop_ActivityAwardItem.ActivityId\r\n WHERE PrizeType = @PrizeType AND PrizeValue = @PrizeValue AND EndDate >= GETDATE()";
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(query);
base.database.AddInParameter(sqlStringCommand, "PrizeValue", DbType.Int32, ValueId);
base.database.AddInParameter(sqlStringCommand, "PrizeType", DbType.Int32, (int)PrizeType);
return(Convert.ToInt32(base.database.ExecuteScalar(sqlStringCommand)) > 0);
}
public static bool ExistValueInActivity(int ValueId, ActivityEnumPrizeType PrizeType)
{
return(new ActivityDao().ExistValueInActivity(ValueId, PrizeType));
}
