/// <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); }