/// <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="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>
/// 反查未读的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="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>
/// 根据讨论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);
}
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);
}
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);
}
/// <summary>
/// 判断当前用户是否对制定朋友圈信息收藏
/// </summary>
/// <param name="momentsBehaviorView"></param>
/// <returns></returns>
public bool IsCollect(MyBehaviorView momentsBehaviorView)
{
Contract.Requires <ArgumentNullException>(momentsBehaviorView != null, "参数momentsBehaviorView:不能为空");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(momentsBehaviorView.PublishID), "参数momentsBehaviorView.PublishID:不能为空");
bool result = false;
string message = string.Empty;
MiicConditionCollections condition = momentsBehaviorView.visitor(this);
MiicColumn collectID = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID));
try
{
int count = dbService.GetCount <CollectInfo>(collectID, 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="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="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>
/// <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);
}
/// <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);
}
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);
}
/// <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);
}
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);
}
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>
/// 获取我的/某人@离线未读信息
/// </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>
/// 检测标签名称的唯一性
/// </summary>
/// <param name="communityID">圈子ID</param>
/// <param name="labelName">标签名称</param>
/// <returns>不存在true 存在false</returns>
public bool UniqueLabel(string communityID, string labelName)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID：不能为空！");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelName), "参数labelName：不能为空！");
bool result = false;
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections();
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CommunityID),
communityID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, communityIDCondition));
MiicCondition labelNameCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.LabelName),
labelName.Trim(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(labelNameCondition));
MiicColumn labelIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID));
try
{
int count = dbService.GetCount <LabelInfo>(labelIDColumn, condition, out message);
if (count == 0)
{
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);
}
/// <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="keywordView">关键字视图</param>
/// <returns>收藏信息总数</returns>
public int GetCollectCount(MyKeywordView keywordView)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
int result = 0;
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
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);
List <MiicFriendRelation> relations = new List <MiicFriendRelation>();
relations.Add(collectRelation);
relations.Add(accRelation);
MiicRelationCollections relation = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(), relations);
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID));
try
{
result = dbService.GetCount(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>
/// 获取朋友圈信息评论总数
/// </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="labelID">标签ID</param>
/// <returns>使用true 未使用false</returns>
public bool HasUsed(string labelID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelID), "参数labelID：不能为空！");
bool result = false;
string message = string.Empty;
MiicCondition labelIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID),
labelID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicColumn labelIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishLabelRelation>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID));
try
{
int count = dbService.GetCount <PublishLabelRelation>(labelIDColumn, new MiicConditionSingle(labelIDCondition), out message);
if (count == 0)
{
result = false;
}
else
{
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="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);
}
bool ICommon <AccessoryInfo> .Delete(string id)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id:不能为空");
bool result = false;
int count = 0;
string message = string.Empty;
AccessoryInfo item = ((ICommon <AccessoryInfo>) this).GetInformation(id);
MiicCondition publishCondtion = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
item.PublishID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>());
bool fileResult = false;
try
{
int accCount = dbService.GetCount <AccessoryInfo>(column, new MiicConditionSingle(publishCondtion), out message);
try
{
if (!string.IsNullOrEmpty(item.FilePath))
{
File.Delete(HttpContext.Current.Server.MapPath(item.FilePath));
if (item.FileType == ((int)AccFileTypeSetting.Photo).ToString())
{
File.Delete(HttpContext.Current.Server.MapPath("/file/temp/PublishInfoAcc/Photo/" + Path.GetFileName(item.FilePath)));
}
else
{
File.Delete(HttpContext.Current.Server.MapPath("/file/temp/PublishInfoAcc/File/" + Path.GetFileName(item.FilePath)));
}
}
fileResult = 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
});
}
if (fileResult == true)
{
if (accCount > 1)
{
result = dbService.Delete(new AccessoryInfo()
{
ID = id
}, out count, out message);
}
else if (accCount == 1)
{
List <string> sqls = new List <string>();
sqls.Add(DBService.UpdateSql <PublishInfo>(new PublishInfo()
{
ID = item.PublishID,
HasAcc = ((int)MiicYesNoSetting.No).ToString()
}, out message));
sqls.Add(DBService.DeleteSql <AccessoryInfo>(new AccessoryInfo()
{
ID = id
}, out message));
result = dbService.excuteSqls(sqls, out message);
}
else
{
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
});
}
if (result == true)
{
DeleteCache(o => o.ID == id);
}
return(result);
}
