/// <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);
}
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>
/// 获取浏览该行业圈子信息的数量
/// </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);
}
/// <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>
/// 举报查询（用于管理）
/// </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 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);
}
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);
}
/// <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);
}
/// <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="commentSearchView">评论查询视图</param>
/// <returns>评论总数</returns>
public int GetCommentCount(CommentSearchView commentSearchView)
{
int result = 0;
string message = string.Empty;
MiicCondition infoCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommentInfo, string>(o => o.PublishID),
commentSearchView.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
{
if (commentSearchView.WithAddress == MiicYesNoSetting.No)
{
result = dbService.GetCount <CommentInfo>(column, condition, out message);
}
else
{
Dictionary <String, String> paras = new Dictionary <String, String>();
paras.Add("PUBLISH_ID", commentSearchView.PublishID);
paras.Add("USER_ID", commentSearchView.UserID);
string storeProcedureName = "GetAddressMomentsCommentCount";
DataTable countDt = dbService.QueryStoredProcedure <string>(storeProcedureName, paras, out message);
if (countDt != null && countDt.Rows.Count == 1)
{
result = (int)countDt.Rows[0]["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>
/// 批量禁用标签
/// </summary>
/// <param name="labelIDs">标签ID组</param>
/// <returns>yes/no</returns>
public bool DisableLabels(List <string> labelIDs)
{
Contract.Requires <ArgumentNullException>(labelIDs != null && labelIDs.Count != 0, "参数labelIDs：不能为空！");
bool result = false;
string message = string.Empty;
string message1 = string.Empty;
List <string> sqls = new List <string>();
foreach (var item in labelIDs)
{
MiicCondition labelIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID),
item,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(labelIDCondition);
sqls.Add(DBService.UpdateConditionSql <LabelInfo>(new LabelInfo()
{
Valid = ((int)MiicValidTypeSetting.InValid).ToString()
}, condition, out message1));
}
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)
{
foreach (var item in labelIDs)
{
DeleteCache(o => o.ID == item);
}
}
return(result);
}
bool ICommon <LabelInfo> .Update(LabelInfo labelInfo)
{
Contract.Requires <ArgumentNullException>(labelInfo != null, "参数labelInfo:不能为空！");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelInfo.ID), "参数LabelInfo.ID:不能为空，因为是主键");
string message = string.Empty;
string message1 = string.Empty;
string message2 = string.Empty;
bool result = false;
List <string> sqls = new List <string>();
sqls.Add(DBService.UpdateSql(labelInfo, out message1));
MiicCondition labelIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID),
labelInfo.ID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(labelIDCondition);
sqls.Add(DBService.UpdateConditionSql <PublishLabelRelation>(new PublishLabelRelation()
{
LabelName = labelInfo.LabelName
}, condition, 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 == labelInfo.ID);
}
return(result);
}
/// <summary>
/// 删除Label信息(管理员使用)
/// </summary>
/// <param name="id">id</param>
/// <returns>Yes/No</returns>
/// <remarks>包括Relation的内容，级联</remarks>
public bool DeepDelete(string id)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id：不能为空！");
bool result = false;
string message = string.Empty,
message1 = string.Empty,
message2 = string.Empty;
List <string> sqls = new List <string>();
MiicCondition labelIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(labelIDCondition);
sqls.Add(DBService.DeleteConditionSql <PublishLabelRelation>(condition, out message1));
sqls.Add(DBService.DeleteSql(new LabelInfo()
{
ID = id
}, 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 IMessageInfo.DeepDelete(string id)
{
bool result = false;
string message = string.Empty,
message1 = string.Empty,
message2 = string.Empty;
List <string> sqls = new List <string>();
MiicCondition topicIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, string>(o => o.TopicID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(topicIDCondition);
sqls.Add(DBService.DeleteConditionSql <MessageInfo>(condition, out message1));
sqls.Add(DBService.DeleteSql(new TopicInfo()
{
ID = id
}, 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(true, o => o.ID == id, o => o.TopicID == id);
}
return(result);
}
public bool RecoverCollect(string publishID)
{
Contract.Requires <ArgumentNullException>(publishID != null, "参数publishID:不能为空");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(publishID), "参数publishID:不能为空");
bool result = false;
string message = string.Empty;
int count = 0;
MiicCondition collectPublishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.PublishID),
publishID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle collectCondition = new MiicConditionSingle(collectPublishIDCondition);
try
{
result = dbService.UpdateCondition <CollectInfo>(new CollectInfo()
{
CollectValid = ((int)MiicValidTypeSetting.Valid).ToString()
}, collectCondition, out count, 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.PublishID == publishID);
}
return(result);
}
bool ICommon <TopicInfo> .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;
string message3 = string.Empty;
List <string> sqls = new List <string>();
TopicInfo temp = ((ICommon <TopicInfo>) this).GetInformation(id);
try
{
if (temp != null)
{
if (temp.MessageCount > 0)
{
sqls.Add(DBService.UpdateSql <TopicInfo>(new TopicInfo()
{
ID = id,
Valid = ((int)MiicValidTypeSetting.InValid).ToString(),
EndTime = DateTime.Now
}, out message1));
}
else
{
sqls.Add(DBService.DeleteSql <TopicInfo>(new TopicInfo()
{
ID = id
}, out message2));
}
//提醒级联
MiicCondition noticeIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.PublishID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle noticeCondition = new MiicConditionSingle(noticeIDCondition);
sqls.Add(DBService.DeleteConditionSql <NoticeInfo>(noticeCondition, out message3));
result = dbService.excuteSqls(sqls, out message);
}
else
{
throw new ArgumentException("参数id：赋值无效");
}
}
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(true, o => o.ID == id, o => o.TopicID == id);
}
return(result);
}
bool ICommon <TradeInfo> .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;
string message3 = string.Empty;
string message4 = string.Empty;
List <string> sqls = new List <string>();
MiicCondition idCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <TradeSubInfo, string>(o => o.TradeID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(idCondition);
//级联删除子行业
sqls.Add(DBService.DeleteConditionSql <TradeSubInfo>(condition, out message2));
//删除行业
sqls.Add(DBService.DeleteSql <TradeInfo>(new TradeInfo()
{
ID = id
}, out message1));
//更新维度表
MiicConditionCollections tradeConditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition tradeID = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimTradeInfo, string>(o => o.TradeID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
tradeConditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, tradeID));
MiicCondition valid = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimTradeInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
tradeConditions.Add(new MiicConditionLeaf(valid));
sqls.Add(DBService.UpdateConditionsSql <DimTradeInfo>(new DimTradeInfo()
{
EndTime = DateTime.Now,
Valid = ((int)MiicValidTypeSetting.InValid).ToString()
}, tradeConditions, out message3));
MiicConditionCollections subTradeConditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition subTradeID = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimTradeSubInfo, string>(o => o.TradeID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
subTradeConditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, subTradeID));
MiicCondition subTradeValid = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimTradeSubInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
subTradeConditions.Add(new MiicConditionLeaf(subTradeValid));
sqls.Add(DBService.UpdateConditionsSql <DimTradeSubInfo>(new DimTradeSubInfo()
{
EndTime = DateTime.Now,
Valid = ((int)MiicValidTypeSetting.InValid).ToString()
}, subTradeConditions, out message4));
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);
TradeSubInfoDao.DeleteCache(o => o.TradeID == id);
}
return(result);
}
bool ICommon <LabelInfo> .Delete(string id)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id:不能为空");
bool result = false;
string message = string.Empty;
bool isUsed = IsUsed(id);
if (isUsed == false)
{
int count = 0;
try
{
result = dbService.Delete(new LabelInfo()
{
ID = id
}, out count, 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
});
}
}
else
{
string message1 = string.Empty;
List <string> sqls = new List <string>();
sqls.Add(DBService.UpdateSql <LabelInfo>(new LabelInfo()
{
ID = id,
Valid = ((int)MiicValidTypeSetting.InValid).ToString(),
EndTime = DateTime.Now
}, out message1));
MiicCondition labelIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID),
id,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(labelIDCondition);
sqls.Add(DBService.UpdateConditionSql(new PublishLabelRelation()
{
Valid = ((int)MiicValidTypeSetting.InValid).ToString()
}, condition, out message1));
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);
}
