int ILabelInfo.GetSearchCount(NoPersonKeywordView keywordView)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不为空！");
int result = 0;
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(validCondition));
try
{
result = dbService.GetCount <LabelInfo>(null, 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);
}
public bool HasCommunityTopic(string communityID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID:不能为空");
bool result = false;
if (items.Exists(o => o.CommunityID == communityID) == true)
{
result = true;
}
else
{
string message = string.Empty;
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <TopicInfo, string>(o => o.CommunityID),
communityID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition);
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <TopicInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <TopicInfo, string>(o => o.ID));
int count = dbService.GetCount <TopicInfo>(column, condition, out message, true);
if (count > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 根据机构ID获取企业留言信息数
/// </summary>
/// <param name="orgID">机构ID</param>
/// <returns>留言信息数</returns>
public int GetOrgCommentCount(string orgID)
{
int result = 0;
string message = string.Empty;
MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.OrgID),
orgID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgCommentInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.ID));
try
{
result = dbService.GetCount <OrgCommentInfo>(idColumn, new MiicConditionSingle(orgIDCondition), 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="page">分页，默认不分页</param>
/// <returns>举报列表</returns>
//public DataTable Search(NoPersonKeywordView keywordView, MiicPage page)
//{
// DataTable result = new DataTable();
// string message = string.Empty;
// MiicConditionCollections condition = keywordView.visitor(this);
// List<MiicOrderBy> order = new List<MiicOrderBy>();
// MiicOrderBy timesOrder = new MiicOrderBy()
// {
// PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, int?>(o => o.ReportTimes),
// Desc = true
// };
// order.Add(timesOrder);
// condition.order = order;
// MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName<ReportInfoOn>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, string>(o => o.ReportPublishID),
// Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID),
// MiicDBOperatorSetting.Equal,
// MiicDBRelationSetting.InnerJoin);
// MiicColumnCollections columns = new MiicColumnCollections();
// MiicColumn publishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID));
// columns.Add(publishIDColumn);
// MiicColumn titleColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.Title));
// columns.Add(titleColumn);
// MiicColumn contentColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.Content));
// columns.Add(contentColumn);
// MiicColumn typeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.Type));
// columns.Add(typeColumn);
// MiicColumn hasAccColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.HasAcc));
// columns.Add(hasAccColumn);
// MiicColumn createTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, DateTime?>(o => o.CreateTime));
// columns.Add(createTimeColumn);
// MiicColumn reportTimesColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<ReportInfoOn>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, int?>(o => o.ReportTimes));
// columns.Add(reportTimesColumn);
// try
// {
// if (page == null)
// {
// result = dbService.GetInformations(columns, relation, condition, out message);
// }
// else
// {
// result = dbService.GetInformationsPage(columns, relation, condition, 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;
//}
/// <summary>
/// 举报查询数（用于管理）
/// </summary>
/// <param name="keywordView">关键字视图</param>
/// <returns>举报列表数</returns>
//public int GetSearchCount(NoPersonKeywordView keywordView)
//{
// int result = 0;
// string message = string.Empty;
// MiicConditionCollections condition = keywordView.visitor(this);
// MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName<ReportInfoOn>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, string>(o => o.ReportPublishID),
// Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID),
// MiicDBOperatorSetting.Equal,
// MiicDBRelationSetting.InnerJoin);
// MiicColumn publishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(),
// Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID));
// try
// {
// result = dbService.GetCount(publishIDColumn, 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="publishID">被举报微博ID</param>
/// <returns>true/false</returns>
public bool HandleReport(string publishID)
{
string message = string.Empty;
string message1 = string.Empty;
int count = 0;
bool result = false;
MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <ReportInfo, string>(o => o.PublishID),
publishID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition);
string sql = DBService.UpdateConditionSql <ReportInfo>(new ReportInfo
{
ReportStatus = ((int)MiicYesNoSetting.Yes).ToString()
}, condition, out message);
try
{
result = dbService.excuteSql(sql, out count, out message1);
}
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 virtual MiicConditionCollections visitor(GroupInfoDao groupInfo)
{
MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition groupNameCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupInfo, string>(o => o.Name),
keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, groupNameCondition));
MiicCondition groupRemarkCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.Remark),
keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, groupRemarkCondition));
result.Add(keywordCondition);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(userIDCondition));
MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <GroupInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(validCondition));
return(result);
}
public int GetPersonBlackListCount(GeneralSimpleGroupSearchView searchView)
{
Contract.Requires <ArgumentNullException>(searchView != null, "参数searchView:不能为空");
int result = 0;
MiicConditionCollections conditions = searchView.visitor(this);
MiicCondition isBlackListCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.IsBlackList),
((int)MiicYesNoSetting.Yes).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(isBlackListCondition));
string message = string.Empty;
try
{
result = dbService.GetCount <AddressBookInfo>(null, 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>
/// 根据讨论ID获取messagecount
/// </summary>
/// <param name="topicID">讨论ID</param>
/// <returns>messagecount</returns>
public int GetMessageCountByTopicID(string topicID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(topicID), "参数topicID:不能为空");
string message = string.Empty;
int result = 0;
MiicCondition topicCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, string>(o => o.TopicID),
topicID,
DbType.String,
DB.Setting.MiicDBOperatorSetting.Equal);
MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <MessageInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, string>(o => o.ID));
try
{
result = dbService.GetCount <MessageInfo>(idColumn, new MiicConditionSingle(topicCondition), 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="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>
/// 获取行业圈子信息评论总数
/// </summary>
/// <param name="publishID">行业圈子信息ID</param>
/// <returns>评论总数</returns>
public int GetCommentCount(string publishID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(publishID), "参数publishID:不能为空");
int result = 0;
string message = string.Empty;
MiicCondition infoCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommentInfo, string>(o => o.PublishID),
publishID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(infoCondition);
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CommentInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CommentInfo, string>(o => o.ID));
try
{
result = dbService.GetCount <CommentInfo>(column, 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>
/// 行业圈子浏览DAO访问器
/// </summary>
/// <param name="communityBrowseInfoDao"></param>
/// <returns></returns>
public MiicConditionCollections visitor(Community.Behavior.BrowseInfoDao communityBrowseInfoDao)
{
MiicConditionCollections condition = new MiicConditionCollections();
MiicCondition isHintCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.Behavior.BrowseInfo, string>(o => o.IsHinted),
((int)MiicYesNoSetting.Yes).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, isHintCondition));
MiicConditionCollections keyworCondition = new MiicConditionCollections();
MiicCondition momentsTitleCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.PublishInfo, string>(o => o.Title),
Keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, momentsTitleCondition));
MiicCondition momentsContentCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.PublishInfo, string>(o => o.Content),
Keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, momentsContentCondition));
condition.Add(keyworCondition);
MiicCondition browserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.Behavior.BrowseInfo, string>(o => o.BrowserID),
UserID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(browserIDCondition));
return(condition);
}
public override MiicConditionCollections visitor(PublishInfoDao publishInfoDao)
{
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.EditStatus),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, editStatusCondition));
//发表人是用户
MiicCondition createrIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterID),
this.UserID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(createrIDCondition));
//默认时间倒序排列
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = false,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, DateTime?>(o => o.PublishTime)
});
condition.order = order;
return(condition);
}
public MiicConditionCollections visitor(CommunityInfoDao communityInfoDao)
{
MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition applicantIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.MemberID),
MemberID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applicantIDCondition));
MiicConditionCollections responseStatusCondition = new MiicConditionCollections();
MiicCondition applyCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus),
((int)ApplyStatusSetting.Apply).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applyCondition));
MiicCondition inviteCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus),
((int)ApplyStatusSetting.Invite).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, inviteCondition));
result.Add(responseStatusCondition);
MiicCondition comminityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.CommunityID),
CommunityID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(comminityIDCondition));
return(result);
}
int IAddressBookInfo.GetPersonAllAddressBookCount(string userID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
int result = 0;
string message = string.Empty;
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));
MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.ID));
try
{
result = dbService.GetCount <AddressBookInfo>(idColumn, conditions, out message, true);
}
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 virtual MiicConditionCollections visitor(AddressBookInfoDao addressBookInfo)
{
MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition addresserName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName),
keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, addresserName));
MiicCondition remarkName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <AddressBookInfo, string>(o => o.Remark),
keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, remarkName));
result.Add(keywordCondition);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(userIDCondition));
return(result);
}
/// <summary>
/// 获取浏览该行业圈子信息的数量
/// </summary>
/// <param name="publishID">行业圈子信息ID</param>
/// <returns>浏览数</returns>
public int?GetBrowseCountByPublishID(string publishID)
{
int result = 0;
MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID),
publishID,
DbType.String,
MiicDBOperatorSetting.Equal);
string message = string.Empty;
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.ID));
MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition);
try
{
result = dbService.GetCount <BrowseInfo>(column, 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);
}
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);
}
bool IAddressBookInfo.Remove(string firestUserID, string secondUserID)
{
bool result = false;
string message = string.Empty;
string message1 = string.Empty;
string message2 = string.Empty;
List <string> sqls = new List <string>();
MiicConditionCollections firstCondition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition firstMyUserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID),
firestUserID,
DbType.String,
MiicDBOperatorSetting.Equal);
firstCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, firstMyUserIDCondition));
MiicCondition firstAddresserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
secondUserID,
DbType.String,
MiicDBOperatorSetting.Equal);
firstCondition.Add(new MiicConditionLeaf(firstAddresserIDCondition));
sqls.Add(DBService.DeleteConditionsSql <AddressBookInfo>(firstCondition, out message1));
MiicConditionCollections secondCondition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition secondMyUserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID),
secondUserID,
DbType.String,
MiicDBOperatorSetting.Equal);
secondCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, secondMyUserIDCondition));
MiicCondition secondAddresserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
firestUserID,
DbType.String,
MiicDBOperatorSetting.Equal);
secondCondition.Add(new MiicConditionLeaf(secondAddresserIDCondition));
sqls.Add(DBService.DeleteConditionsSql <AddressBookInfo>(secondCondition, out message2));
try
{
result = dbService.excuteSqls(sqls, 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
});
}
if (result == true)
{
items.RemoveAll(o => (o.AddresserID == firestUserID && o.MyUserID == secondUserID) || (o.AddresserID == secondUserID && o.MyUserID == firestUserID));
}
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>
/// <param name="myID"></param>
/// <param name="addresserID"></param>
/// <returns></returns>
public bool CanSeeAddresser(string myID, string addresserID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(myID), "参数myID:不能为空");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(addresserID), "参数addresserID:不能为空");
bool result = false;
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition myIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID),
addresserID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, myIDCondition));
MiicCondition addresserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
myID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(addresserIDCondition));
MiicCondition canSeeAddresserCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.CanSeeMe),
((int)MiicYesNoSetting.Yes).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(canSeeAddresserCondition));
MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.ID));
try
{
int addresser = dbService.GetCount <AddressBookInfo>(idColumn, condition, out message);
if (addresser == 1)
{
result = true;
}
else
{
result = false;
}
}
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>
/// <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);
}
bool ICommon <RegisterTypeInfo> .Delete(string id)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id:不能为空");
bool result = false;
string message = string.Empty;
string message1 = string.Empty;
string message2 = string.Empty;
List <string> sqls = new List <string>();
sqls.Add(DBService.DeleteSql(new RegisterTypeInfo()
{
ID = id
}, out message1));
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition registerTypeID = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimRegisterType, string>(o => o.RegisterTypeID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, registerTypeID));
MiicCondition valid = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimRegisterType, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(valid));
sqls.Add(DBService.UpdateConditionsSql <DimRegisterType>(new DimRegisterType()
{
EndTime = DateTime.Now,
Valid = ((int)MiicValidTypeSetting.InValid).ToString()
}, conditions, out message2));
try
{
result = dbService.excuteSqls(sqls, 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
});
}
if (result == true)
{
DeleteCache(o => o.ID == id);
}
return(result);
}
bool ICommunityInfo.IsAdmin(string userID, string communityID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
bool result = false;
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition isAdminCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.IsAdmin),
((int)MiicYesNoSetting.Yes).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, isAdminCondition));
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(userIDCondition));
if (!string.IsNullOrEmpty(communityID))
{
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.CommunityID),
communityID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(communityIDCondition));
}
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CommunityMember>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.ID));
try
{
int count = dbService.GetCount <CommunityMember>(column, condition, out message);
if (count > 0)
{
result = true;
}
}
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="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);
}
List <CommunityMember> ICommunityInfo.GetMemberInfoListByCommunityID(string communityID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID:不能为空");
string message = string.Empty;
List <CommunityMember> result = new List <CommunityMember>();
try
{
result = subitems.FindAll(o => o.CommunityID == communityID);
if (result.Count == 0)
{
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.CommunityID),
communityID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition);
DataTable dt = dbService.GetInformations <CommunityMember>(null, condition, out message);
subitems.RemoveAll(o => o.CommunityID == communityID);
if (dt.Rows.Count > 0)
{
foreach (var item in dt.AsEnumerable())
{
result.Add(new CommunityMember()
{
ID = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.ID)].ToString(),
CommunityID = communityID,
IsAdmin = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.IsAdmin)].ToString(),
JoinTime = (DateTime?)item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, DateTime?>(o => o.JoinTime)],
MemberID = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberID)].ToString(),
MemberName = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberName)].ToString(),
SortNo = (int?)item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, int?>(o => o.SortNo)]
});
}
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);
}
bool ICommunityInfo.IsApplicationHandledByApplyID(string applyID)
{
Contract.Requires <ArgumentNullException>(applyID != null, "参数applyID:不能为空");
bool result = false;
int count = 0;
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition applicantIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ID),
applyID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applicantIDCondition));
MiicConditionCollections responseStatusCondition = new MiicConditionCollections();
MiicCondition applyCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus),
((int)ApplyStatusSetting.Apply).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applyCondition));
MiicCondition inviteCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus),
((int)ApplyStatusSetting.Invite).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, inviteCondition));
condition.Add(responseStatusCondition);
try
{
count = dbService.GetCount <CommunityApplicationInfo>(new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CommunityApplicationInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ID)), condition, out message);
if (count == 0)
{
result = true;
}
}
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);
}
