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