public static IEnumerable <SubscribeMessage> LoadMessages(MessageQueryFilter filter, out int totalCount) { var sql = DataCommandHelper.GetDataCommandSql("LoadMessages", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { string whereStr = "WHERE 1 = 1"; if (!string.IsNullOrWhiteSpace(filter.Topic)) { whereStr += " AND `subscribemessage`.`Topic`=@Topic"; } if (!string.IsNullOrWhiteSpace(filter.ReferenceIdentifier)) { whereStr += " AND `message`.`ReferenceIdentifier`=@ReferenceIdentifier"; } if (filter.CreateDateFrom.HasValue) { whereStr += " AND `message`.`CreateDate`>=@CreateDateFrom"; } if (filter.CreateDateTo.HasValue) { whereStr += " AND `message`.`CreateDate`<@CreateDateTo"; } whereStr += " Order By `message`.`CreateDate` DESC"; sql = sql.Replace("#StrWhere#", whereStr); var result = conn.QueryMultiple(sql, filter); var messages = result.Read <SubscribeMessage>(); totalCount = result.ReadFirstOrDefault <int>(); return(messages); } }
public static IEnumerable <SubscribeMessage> LoadFailedMessages(MessageQueryFilter filter, out int totalCount) { return(MessageDA.LoadFailedMessages(filter, out totalCount)); }