/// <summary>
/// 获取浏览该行业圈子信息的列表
/// </summary>
/// <param name="publishID">行业圈子信息ID</param>
/// <returns>浏览信息列表</returns>
public DataTable GetBrowseInfosByPublishID(string publishID)
{
DataTable result = new DataTable();
MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID),
publishID,
DbType.String,
MiicDBOperatorSetting.Equal);
string message = string.Empty;
MiicColumn allColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>());
MiicColumnCollections columns = new MiicColumnCollections();
columns.Add(allColumn);
MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition);
try
{
result = dbService.GetInformations <BrowseInfo>(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>
/// 反查未读的NoticeID
/// </summary>
/// <param name="unreadNoticeView">未读通知视图</param>
/// <returns></returns>
public DataTable GetUnReadNoticeID(GetUnreadNoticeView unreadNoticeView)
{
Contract.Requires <ArgumentNullException>(unreadNoticeView != null, "参数unreadNoticeView:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = unreadNoticeView.visitor(this);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <NoticeInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.ID));
columns.Add(idColumn);
MiicColumn noticerIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <NoticeInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.NoticerID));
columns.Add(noticerIDColumn);
try
{
result = dbService.GetInformations <NoticeInfo>(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="communityBehaviorView">用户行为（点赞）视图</param>
/// <returns>点赞信息</returns>
public PraiseInfo GetUserPraiseInfo(MyCommunityBehaviorView communityBehaviorView)
{
Contract.Requires <ArgumentNullException>(communityBehaviorView != null, "参数communityBehaviorView:不能为空");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityBehaviorView.PublishID), "参数communityBehaviorView.PublishID:不能为空");
PraiseInfo result = null;
string message = string.Empty;
MiicConditionCollections condition = communityBehaviorView.visitor(this);
MiicColumn praiseAll = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PraiseInfo>());
MiicColumnCollections columns = new MiicColumnCollections();
columns.Add(praiseAll);
try
{
result = items.Find(o => o.PublishID == communityBehaviorView.PublishID && o.PraiserID == communityBehaviorView.LoginUserID);
if (result == null)
{
DataTable dt = dbService.GetInformations <PraiseInfo>(columns, condition, out message);
if (dt != null && dt.Rows.Count == 1)
{
result = new PraiseInfo()
{
ID = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, string>(o => o.ID)].ToString(),
PraiserID = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, string>(o => o.PraiserID)].ToString(),
PraiserName = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, string>(o => o.PraiserName)].ToString(),
PraiseTime = (DateTime?)dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, DateTime?>(o => o.PraiseTime)],
PublishID = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, string>(o => o.PublishID)].ToString(),
SortNo = (int?)dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, int?>(o => o.SortNo)]
};
}
else
{
result = null;
}
if (result != null)
{
InsertCache(result);
}
}
else
{
string serializer = Config.Serializer.Serialize(result);
result = Config.Serializer.Deserialize <PraiseInfo>(serializer);
}
}
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);
}
public DataTable GetOrganizationDetailInfo(string orgID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(orgID), "参数orgID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <OrganizationInfo, string>(o => o.OrgID),
orgID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(orgIDCondition);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <OrganizationInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrganizationInfo, string>(o => o.OrgID),
Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.OrgID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn orgAllColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrganizationInfo>());
columns.Add(orgAllColumns);
MiicColumn fileIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.ID));
columns.Add(fileIDColumn);
MiicColumn fileNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FileName));
columns.Add(fileNameColumn);
MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FilePath));
columns.Add(filePathColumn);
MiicColumn uploadTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, DateTime?>(o => o.UploadTime));
columns.Add(uploadTimeColumn);
MiicColumn fileTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FilePath));
columns.Add(fileTypeColumn);
try
{
result = dbService.GetInformations(columns, relation, 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);
}
DataTable IAddressBookInfo.GetPersonAllAddressBookList(string userID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition));
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn addresserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID));
columns.Add(addresserIDColumn);
MiicColumn addresserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName));
columns.Add(addresserNameColumn);
MiicColumn remarkColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.Remark));
columns.Add(remarkColumn);
MiicColumn addresserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserUrl));
columns.Add(addresserUrlColumn);
MiicColumn oftenUsedColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.OftenUsed));
columns.Add(oftenUsedColumn);
try
{
result = dbService.GetInformations(columns, relation, conditions, 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="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>
/// <returns></returns>
DataTable IUserInfo.GetAllUserInfos()
{
DataTable result = new DataTable();
string message = string.Empty;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <UserInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <UserInfo, string>(o => o.UserID),
Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
//选择有效地，没有被禁止的，已经被激活的
MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.DisabledFlag),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, disabledFlagCondition));
MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ActivateFlag),
((int)UserActivateSetting.Agree).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(activateFlagCondition));
MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(validCondition));
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <UserInfo>());
columns.Add(column);
try
{
result = dbService.GetInformations(columns, relation, conditions, 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);
}
public DataTable Search(GeneralSimpleGroupSearchView searchView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(searchView != null, "参数searchView:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections conditions = searchView.visitor(this);
MiicCondition isBlackListCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.IsBlackList),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(isBlackListCondition));
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName)
});
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.OftenUsed)
});
conditions.order = order;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn addressBookInfoColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>());
columns.Add(addressBookInfoColumns);
MiicColumn ImageUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl));
columns.Add(ImageUrlColumn);
MiicColumn NickNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
"",
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName), "NickName");
columns.Add(NickNameColumn);
if (page != null)
{
result = dbService.GetInformationsPage(columns, relation, conditions, page, out message);
}
else
{
result = dbService.GetInformations(columns, relation, conditions, out message);
}
return(result);
}
/// <summary>
/// 根据标签主题获取所有发布博文附件列表
/// </summary>
/// <param name="labelID">标签主题ID</param>
/// <returns>附件列表</returns>
public List <AccessoryInfo> GetAccessoryListByLabelID(string labelID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelID), "参数labelID:不能为空");
List <AccessoryInfo> result = new List <AccessoryInfo>();
string message = string.Empty;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <PublishLabelRelation>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.PublishID),
Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID),
labelID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition);
MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath));
MiicColumnCollections columns = new MiicColumnCollections();
columns.Add(filePathColumn);
try
{
DataTable dt = dbService.GetInformations(columns, relation, condition, out message);
foreach (var dr in dt.AsEnumerable())
{
result.Add(new AccessoryInfo()
{
ID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)].ToString(),
PublishID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID)].ToString(),
FileName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName)].ToString(),
FilePath = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)].ToString(),
UploadTime = (DateTime?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime)],
FileType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType)].ToString()
});
}
}
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>
/// 根据微博ID获取所有微博附件列表
/// </summary>
/// <param name="publishID">微博ID</param>
/// <returns>微博附件列表</returns>
public List <AccessoryInfo> GetAccessoryList(string publishID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(publishID), "参数publishID:不能为空");
List <AccessoryInfo> result = new List <AccessoryInfo>();
MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
publishID,
DbType.String,
MiicDBOperatorSetting.Equal);
string message = string.Empty;
MiicColumn allColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>());
MiicColumnCollections columns = new MiicColumnCollections();
columns.Add(allColumn);
MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition);
try
{
DataTable dt = dbService.GetInformations <AccessoryInfo>(columns, condition, out message);
if (dt.Rows.Count != 0)
{
subitems.RemoveAll(o => o.PublishID == publishID);
foreach (var item in dt.AsEnumerable())
{
result.Add(new AccessoryInfo()
{
ID = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)].ToString(),
PublishID = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID)].ToString(),
FileName = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName)].ToString(),
FilePath = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)].ToString(),
UploadTime = (DateTime?)item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime)],
FileType = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType)].ToString()
});
}
subitems.AddRange(result);
}
}
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);
}
DataTable IGroupInfo.GetDetailMemberInfoListByGroupID(string groupID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(groupID), "参数groupID:不能为空");
string message = string.Empty;
DataTable result = new DataTable();
MiicCondition groupIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.GroupID),
groupID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(groupIDCondition);
MiicColumnCollections column = new MiicColumnCollections();
MiicColumn memberAll = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <GroupMember>());
column.Add(memberAll);
MiicColumn userUrl = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl));
column.Add(userUrl);
MiicColumn userName = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName));
column.Add(userName);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <GroupMember>(),
Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
try
{
result = dbService.GetInformations(column, relation, 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);
}
List <SimplePersonUserView> IUserInfo.GetSimplePersonUserInfos(List <string> ids)
{
List <SimplePersonUserView> result = new List <SimplePersonUserView>();
string message = string.Empty;
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition idsCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID),
ids,
DbType.String,
MiicDBOperatorSetting.In);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, idsCondition));
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>());
columns.Add(column);
try
{
DataTable dt = dbService.GetInformations <SimplePersonUserView>(columns, conditions, out message);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.AsEnumerable())
{
result.Add(new SimplePersonUserView()
{
UserID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID)].ToString(),
OrgName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.OrgName)].ToString(),
SocialCode = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.SocialCode)].ToString(),
UserLevel = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserLevel)].ToString(),
UserName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserName)].ToString(),
UserType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserType)].ToString(),
UserUrl = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserUrl)].ToString()
});
}
}
}
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="userID">用户ID</param>
/// <returns>离线信息列表</returns>
public DataTable GetPersonOfflineNoticeList(string userID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeShowInfo, string>(o => o.NoticerID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition));
MiicCondition readStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeShowInfo, string>(o => o.ReadStatus),
((int)MiicReadStatusSetting.UnRead).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(readStatusCondition));
List <MiicOrderBy> orders = new List <MiicOrderBy>();
orders.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <NoticeShowInfo, DateTime?>(o => o.PublishTime)
});
condition.order = orders;
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <NoticeShowInfo>());
columns.Add(column);
try
{
result = dbService.GetInformations <NoticeShowInfo>(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>
/// 根据讨论组ID获取所有讨论组成员
/// </summary>
/// <param name="groupID">讨论组ID</param>
/// <returns>讨论组成员列表</returns>
List <GroupMember> IGroupInfo.GetGroupMemberList(string groupID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(groupID), "参数groupID:不能为空");
List <GroupMember> result = new List <GroupMember>();
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.GroupID),
groupID,
DbType.String,
MiicDBOperatorSetting.Equal);
string message = string.Empty;
MiicColumn allColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <GroupMember>());
MiicColumnCollections columns = new MiicColumnCollections();
columns.Add(allColumn);
MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition);
try
{
DataTable dt = dbService.GetInformations <GroupMember>(columns, condition, out message);
if (dt.Rows.Count != 0)
{
foreach (DataRow item in dt.AsEnumerable())
{
result.Add(new GroupMember()
{
ID = item[Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.ID)].ToString(),
MemberID = item[Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberID)].ToString(),
MemberName = item[Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberName)].ToString(),
GroupID = item[Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.GroupID)].ToString(),
JoinTime = (DateTime?)item[Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, DateTime?>(o => o.JoinTime)],
Remark = item[Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.Remark)].ToString()
});
}
}
}
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="publishID">行业圈子信息ID</param>
/// <param name="page">分页</param>
/// <returns>行业圈子信息评论列表</returns>
public DataTable GetCommentList(string publishID, MiicPage page)
{
DataTable result = new DataTable();
MiicColumnCollections column = new MiicColumnCollections();
List <MiicOrderBy> orders = new List <MiicOrderBy>();
string message = string.Empty;
string sql = string.Empty;
Cookie cookie = new Cookie();
string UserID = cookie.GetCookie("MiicID", out message);
if (string.IsNullOrEmpty(UserID))
{
throw new Miic.MiicException.MiicCookieArgumentNullException("UserID不能为空，Cookie失效");
}
sql += "SELECT * FROM GetCommunityCommentListWithAddress('" + UserID + "','" + publishID + "') ";
if (page != null)
{
sql = "WITH INFO_PAGE AS ( SELECT row_number() OVER ( ORDER BY Temp.COMMENT_TIME DESC) as row,Temp.* FROM ( " + sql;
sql += " ) as Temp) ";
sql += "SELECT * FROM INFO_PAGE where row between " + page.pageStart + " and " + page.pageEnd + ";";
}
else
{
sql += " ORDER BY COMMENT_TIME DESC";
}
try
{
result = dbService.querySql(sql, 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);
}
DataTable ILabelInfo.Search(NoPersonKeywordView keywordView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不为空！");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.LabelID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn labelIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID));
columns.Add(labelIDColumn);
MiicColumn labelNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.LabelName));
columns.Add(labelNameColumn);
MiicColumn createTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, DateTime?>(o => o.CreateTime));
columns.Add(createTimeColumn);
MiicColumn createrIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterID));
columns.Add(createrIDColumn);
MiicColumn createrNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterName));
columns.Add(createrNameColumn);
MiicColumn sortNoColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, int?>(o => o.SortNo));
columns.Add(sortNoColumn);
MiicColumn labelSearchPublishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.PublishID));
columns.Add(labelSearchPublishIDColumn);
MiicColumn labelSearchUserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserID));
columns.Add(labelSearchUserIDColumn);
MiicColumn labelSearchUserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserName));
columns.Add(labelSearchUserNameColumn);
MiicColumn labelSearchUserTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserType));
columns.Add(labelSearchUserTypeColumn);
MiicColumn labelSearchUserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserUrl));
columns.Add(labelSearchUserUrlColumn);
try
{
if (page != null)
{
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <LabelInfo, int?>(o => o.SortNo)
});
condition.order = order;
result = dbService.GetInformationsPage(columns, relation, condition, page, out message, MiicDBPageRowNumberSetting.DenseRank);
}
else
{
result = dbService.GetInformations(columns, relation, 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="commentSearchView">评论查询视图</param>
/// <param name="page">分页</param>
/// <returns>朋友圈信息评论列表</returns>
public DataTable GetCommentList(CommentSearchView commentSearchView, MiicPage page)
{
DataTable result = new DataTable();
MiicColumnCollections column = new MiicColumnCollections();
List <MiicOrderBy> orders = new List <MiicOrderBy>();
string message = string.Empty;
string sql = string.Empty;
sql += "SELECT * FROM GetCommentListWithAddress('" + commentSearchView.UserID + "','" + commentSearchView.PublishID + "') ";
if (page != null)
{
sql = "WITH INFO_PAGE AS ( SELECT row_number() OVER ( ORDER BY Temp.COMMENT_TIME DESC) as row,Temp.* FROM ( " + sql;
sql += " ) as Temp) ";
sql += "SELECT * FROM INFO_PAGE where row between " + page.pageStart + " and " + page.pageEnd + ";";
}
else
{
sql += " ORDER BY COMMENT_TIME DESC";
}
try
{
//if (commentSearchView.WithAddress == MiicYesNoSetting.No)
//{
result = dbService.querySql(sql, out message);
//}
//else
//{
// if (page == null)
// {
// Dictionary<String, String> paras = new Dictionary<String, String>();
// paras.Add("PUBLISH_ID", commentSearchView.PublishID);
// paras.Add("USER_ID", commentSearchView.UserID);
// paras.Add("PAGE_START", string.Empty);
// paras.Add("PAGE_END", string.Empty);
// string storeProcedureName = "GetAddressMomentsComment";
// result = dbService.QueryStoredProcedure<string>(storeProcedureName, paras, out message);
// }
// else
// {
// Dictionary<String, String> paras = new Dictionary<String, String>();
// paras.Add("PUBLISH_ID", commentSearchView.PublishID);
// paras.Add("USER_ID", commentSearchView.UserID);
// paras.Add("PAGE_START", page.pageStart);
// paras.Add("PAGE_END", page.pageEnd);
// string storeProcedureName = "GetAddressMomentsComment";
// result = dbService.QueryStoredProcedure<string>(storeProcedureName, paras, 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>
/// <returns></returns>
public int GetHintedBrowseCount(MyKeywordView keywordView)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
int result = 0;
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID),
Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn browseIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.ID));
columns.Add(browseIDColumn);
MiicColumn browserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.BrowserID));
columns.Add(browserIDColumn);
MiicColumn browserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.BrowserName));
columns.Add(browserNameColumn);
MiicColumn publishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID));
columns.Add(publishIDColumn);
MiicColumn microTitleColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Title));
columns.Add(microTitleColumn);
MiicColumn microContentColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Content));
columns.Add(microContentColumn);
MiicColumn microTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType));
columns.Add(microTypeColumn);
try
{
DataTable dt = dbService.GetInformations(columns, relation, condition, out message);
DataView dtView = dt.DefaultView;
result = (dtView.ToTable(true)).Rows.Count;
}
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>
/// 根据标签ID获取指定标签集合
/// </summary>
/// <param name="labelIDs">标签ID数组</param>
/// <returns>标签集合</returns>
DataTable ILabelInfo.GetLabelListWithIDs(List <string> labelIDs)
{
Contract.Requires <ArgumentNullException>(labelIDs != null, "参数labelIDs:不为空！");
Contract.Requires <ArgumentOutOfRangeException>(labelIDs.Count != 0, "参数labelIDs:不为空！");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <LabelInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, validCondition));
MiicConditionCollections idsCondition = new MiicConditionCollections();
for (int i = 0, lableCount = labelIDs.Count; i < lableCount; i++)
{
if (i == 0)
{
idsCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <LabelInfo, string>(o => o.ID),
labelIDs[i],
DbType.String,
MiicDBOperatorSetting.Equal)));
}
else
{
idsCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <LabelInfo, string>(o => o.ID),
labelIDs[i],
DbType.String,
MiicDBOperatorSetting.Equal)));
}
}
condition.Add(idsCondition);
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <LabelInfo, int?>(o => o.SortNo)
});
condition.order = order;
MiicRelationCollections realtions = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>());
MiicFriendRelation searchInfoRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.LabelID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
realtions.Add(searchInfoRelation);
MiicFriendRelation userInfoRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
realtions.Add(userInfoRelation);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn labelIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID));
columns.Add(labelIDColumn);
MiicColumn labelNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.LabelName));
columns.Add(labelNameColumn);
MiicColumn createTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, DateTime?>(o => o.CreateTime));
columns.Add(createTimeColumn);
MiicColumn createrIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterID));
columns.Add(createrIDColumn);
MiicColumn createrNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
"",
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName)
, Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterName));
columns.Add(createrNameColumn);
MiicColumn labelSearchCommunityIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.CommunityID));
columns.Add(labelSearchCommunityIDColumn);
MiicColumn labelSearchPublishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.PublishID));
columns.Add(labelSearchPublishIDColumn);
MiicColumn labelSearchUserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserID));
columns.Add(labelSearchUserIDColumn);
MiicColumn labelSearchUserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserName));
columns.Add(labelSearchUserNameColumn);
MiicColumn labelSearchUserTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserType));
columns.Add(labelSearchUserTypeColumn);
MiicColumn labelSearchUserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserUrl));
columns.Add(labelSearchUserUrlColumn);
try
{
result = dbService.GetInformations(columns, realtions, 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);
}
