/// <summary>
/// 获取最热行业圈子信息（条件：长篇、已发布的、有效的、上线的）
/// </summary>
/// <param name="top">top默认：15</param>
/// <returns>最热行业圈子信息列表</returns>
public DataTable GetTopHotestBrowseInfo(int top)
{
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition longInfoCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType),
((int)PublishInfoTypeSetting.Long).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, longInfoCondition));
MiicCondition publishStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, DateTime?>(o => o.PublishTime),
null,
DbType.DateTime,
MiicDBOperatorSetting.NotIsNull);
condition.Add(new MiicConditionLeaf(publishStatusCondition));
MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.EditStatus),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(editStatusCondition));
MiicOrderBy orderby = new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.BrowseNum)
};
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(orderby);
condition.order = order;
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>());
MiicColumnCollections columns = new MiicColumnCollections(new MiicTop(top));
try
{
result = dbService.GetInformations <PublishInfo>(columns, condition, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
/// <summary>
/// 我的收藏信息列表
/// </summary>
/// <param name="keywordView">关键字视图</param>
/// <param name="orderView">排序视图</param>
/// <param name="page">分页</param>
/// <returns>收藏信息列表</returns>
public DataTable GetCollectInfos(MyKeywordView keywordView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
List <MiicOrderBy> orders = new List <MiicOrderBy>();
MiicColumnCollections column = new MiicColumnCollections();
MiicConditionCollections condition = keywordView.visitor(this);
MiicOrderBy collectOrder = new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, DateTime?>(o => o.CollectTime)
};
orders.Add(collectOrder);
condition.order = orders;
MiicFriendRelation collectRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicFriendRelation accRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicFriendRelation userRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
List <MiicFriendRelation> relations = new List <MiicFriendRelation>();
relations.Add(collectRelation);
relations.Add(accRelation);
relations.Add(userRelation);
MiicRelationCollections relation = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(), relations);
MiicColumn microPartakePublishInfoAllColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>());
column.Add(microPartakePublishInfoAllColumns);
MiicColumn microCollectInfoIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
string.Empty,
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID),
"CommunityCollectInfoID");
column.Add(microCollectInfoIDColumn);
MiicColumn collectTime = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, DateTime?>(o => o.CollectTime));
column.Add(collectTime);
//收藏人员表
MiicColumn collectorIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorID));
column.Add(collectorIDColumn);
MiicColumn collectorNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorName));
column.Add(collectorNameColumn);
MiicColumn microAccessoryIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
string.Empty,
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID),
"CommunityAccessoryInfoID");
column.Add(microAccessoryIDColumn);
MiicColumn fileNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName));
column.Add(fileNameColumn);
MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath));
column.Add(filePathColumn);
MiicColumn uploadTime = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime));
column.Add(uploadTime);
MiicColumn fileTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType));
column.Add(fileTypeColumn);
MiicColumn orgNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.OrgName));
column.Add(orgNameColumn);
MiicColumn userUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserUrl));
column.Add(userUrlColumn);
MiicColumn userTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserType));
column.Add(userTypeColumn);
try
{
if (page == null)
{
result = dbService.GetInformations(column, relation, condition, out message);
}
else
{
result = dbService.GetInformationsPage(column, relation, condition, page, out message, MiicDBPageRowNumberSetting.DenseRank);
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
/// <summary>
/// 获得企业留言列表
/// </summary>
/// <param name="orgID">企业ID</param>
/// <param name="page">分页</param>
/// <returns>留言列表信息</returns>
public DataTable GetOrgCommentInfos(string orgID, MiicPage page)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(orgID), "参数orgID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicRelationCollections relation = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <OrgCommentInfo>());
MiicFriendRelation fromRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.FromCommenterID),
new MiicTableName()
{
TableAliasName = "FROM_USER",
TableName = Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>()
},
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
relation.Add(fromRelation);
MiicFriendRelation toRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.ToCommenterID),
new MiicTableName()
{
TableAliasName = "TO_USER",
TableName = Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>()
},
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
relation.Add(toRelation);
MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.OrgID),
orgID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionCollections conditions = new MiicConditionCollections();
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, orgIDCondition));
List <MiicOrderBy> order = new List <MiicOrderBy>();
MiicOrderBy timeOrder = new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, DateTime?>(o => o.CommentTime)
};
order.Add(timeOrder);
conditions.order = order;
MiicColumn allColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgCommentInfo>());
MiicColumnCollections column = new MiicColumnCollections();
column.Add(allColumn);
MiicColumn fromUserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(),
"FROM_USER",
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.MicroUserUrl),
"FROM_USER_URL");
column.Add(fromUserUrlColumn);
MiicColumn fromUserTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(),
"FROM_USER",
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType),
"FROM_USER_TYPE");
column.Add(fromUserTypeColumn);
MiicColumn toUserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(),
"TO_USER",
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.MicroUserUrl),
"TO_USER_URL");
column.Add(toUserUrlColumn);
MiicColumn toUserTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(),
"TO_USER",
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType),
"TO_USER_TYPE");
column.Add(toUserTypeColumn);
try
{
if (page == null)
{
result = dbService.GetInformations(column, relation, conditions, out message);
}
else
{
result = dbService.GetInformationsPage(column, relation, conditions, page, out message);
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
