/// <summary>
/// 分页查询Topic信息
/// </summary>
public QueryResult <QR_Topic> QueryTopicList(QF_Topic filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryTopicList");
//DataCommand cmd = new DataCommand("QueryTopicList");
cmd.QuerySetCondition("TopicCategorySysNo", ConditionOperation.Equal, DbType.Int32, filter.TopicCategorySysNo);
cmd.QuerySetCondition("TopicStatus", ConditionOperation.Equal, DbType.Int32, 1);
cmd.QuerySetCondition("StartTime", ConditionOperation.LessThanEqual, DbType.DateTime, DateTime.Now);
cmd.QuerySetCondition("EndTime", ConditionOperation.MoreThanEqual, DbType.DateTime, DateTime.Now);
QueryResult <QR_Topic> result = cmd.Query <QR_Topic>(filter, " SysNo DESC");
return(result);
}
public static QueryResult <QR_Topic> QueryTopicList(QF_Topic filter)
{
var cmd = new DataCommand("QueryTopicList");
cmd.QuerySetCondition("t.Title", ConditionOperation.Like, DbType.String, filter.Title);
//if (filter.CategoryID!="0") {
// cmd.QuerySetCondition("tc.CategoryID", ConditionOperation.Equal, DbType.String, filter.CategoryID);
//}
if (filter.CategorySysNo > 0)
{
cmd.QuerySetCondition("t.TopicCategorySysNo", ConditionOperation.Equal, DbType.Int32, filter.CategorySysNo);
}
//if (!string.IsNullOrEmpty(filter.MasterName) && !string.IsNullOrWhiteSpace(filter.MasterName))
//{
// cmd.QuerySetCondition("tc.MasterName", ConditionOperation.Equal, DbType.String, filter.MasterName);
//}
cmd.QuerySetCondition("t.TopicStatus", ConditionOperation.Equal, DbType.Int32, filter.TopicStatus);
cmd.QuerySetCondition("t.TopicStatus", ConditionOperation.NotEqual, DbType.Int32, TopicStatus.Delete);
QueryResult <QR_Topic> result = cmd.Query <QR_Topic>(filter, "t.IsTop desc,t.EditDate DESC");
return(result);
}
public static QueryResult <QR_Topic> QueryTopicList(QF_Topic filter)
{
return(TopicDA.QueryTopicList(filter));
}
