int ILabelInfo.GetSearchCount(NoPersonKeywordView keywordView) { Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不为空!"); int result = 0; string message = string.Empty; MiicConditionCollections condition = keywordView.visitor(this); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); try { result = dbService.GetCount <LabelInfo>(null, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
public bool HasCommunityTopic(string communityID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID:不能为空"); bool result = false; if (items.Exists(o => o.CommunityID == communityID) == true) { result = true; } else { string message = string.Empty; MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <TopicInfo, string>(o => o.CommunityID), communityID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition); MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <TopicInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <TopicInfo, string>(o => o.ID)); int count = dbService.GetCount <TopicInfo>(column, condition, out message, true); if (count > 0) { result = true; } } return(result); }
/// <summary> /// 根据机构ID获取企业留言信息数 /// </summary> /// <param name="orgID">机构ID</param> /// <returns>留言信息数</returns> public int GetOrgCommentCount(string orgID) { int result = 0; string message = string.Empty; MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.OrgID), orgID, DbType.String, MiicDBOperatorSetting.Equal); MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgCommentInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgCommentInfo, string>(o => o.ID)); try { result = dbService.GetCount <OrgCommentInfo>(idColumn, new MiicConditionSingle(orgIDCondition), out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 举报查询(用于管理) /// </summary> /// <param name="keywordView">关键字视图</param> /// <param name="page">分页,默认不分页</param> /// <returns>举报列表</returns> //public DataTable Search(NoPersonKeywordView keywordView, MiicPage page) //{ // DataTable result = new DataTable(); // string message = string.Empty; // MiicConditionCollections condition = keywordView.visitor(this); // List<MiicOrderBy> order = new List<MiicOrderBy>(); // MiicOrderBy timesOrder = new MiicOrderBy() // { // PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, int?>(o => o.ReportTimes), // Desc = true // }; // order.Add(timesOrder); // condition.order = order; // MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName<ReportInfoOn>(), // Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, string>(o => o.ReportPublishID), // Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID), // MiicDBOperatorSetting.Equal, // MiicDBRelationSetting.InnerJoin); // MiicColumnCollections columns = new MiicColumnCollections(); // MiicColumn publishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID)); // columns.Add(publishIDColumn); // MiicColumn titleColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.Title)); // columns.Add(titleColumn); // MiicColumn contentColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.Content)); // columns.Add(contentColumn); // MiicColumn typeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.Type)); // columns.Add(typeColumn); // MiicColumn hasAccColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.HasAcc)); // columns.Add(hasAccColumn); // MiicColumn createTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, DateTime?>(o => o.CreateTime)); // columns.Add(createTimeColumn); // MiicColumn reportTimesColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<ReportInfoOn>(), // Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, int?>(o => o.ReportTimes)); // columns.Add(reportTimesColumn); // try // { // if (page == null) // { // result = dbService.GetInformations(columns, relation, condition, out message); // } // else // { // result = dbService.GetInformationsPage(columns, relation, condition, page, out message); // } // } // catch (Exception ex) // { // Config.IlogicLogService.Write(new LogicLog() // { // AppName = Config.AppName, // ClassName = ClassName, // NamespaceName = NamespaceName, // MethodName = MethodBase.GetCurrentMethod().Name, // Message = ex.Message, // Oper = Config.Oper // }); // } // return result; //} /// <summary> /// 举报查询数(用于管理) /// </summary> /// <param name="keywordView">关键字视图</param> /// <returns>举报列表数</returns> //public int GetSearchCount(NoPersonKeywordView keywordView) //{ // int result = 0; // string message = string.Empty; // MiicConditionCollections condition = keywordView.visitor(this); // MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName<ReportInfoOn>(), // Config.Attribute.GetSqlColumnNameByPropertyName<ReportInfoOn, string>(o => o.ReportPublishID), // Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID), // MiicDBOperatorSetting.Equal, // MiicDBRelationSetting.InnerJoin); // MiicColumn publishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName<PublishInfo>(), // Config.Attribute.GetSqlColumnNameByPropertyName<PublishInfo, string>(o => o.ID)); // try // { // result = dbService.GetCount(publishIDColumn, relation, condition, out message); // } // catch (Exception ex) // { // Config.IlogicLogService.Write(new LogicLog() // { // AppName = Config.AppName, // ClassName = ClassName, // NamespaceName = NamespaceName, // MethodName = MethodBase.GetCurrentMethod().Name, // Message = ex.Message, // Oper = Config.Oper // }); // } // return result; //} /// <summary> /// 受理举报 /// </summary> /// <param name="publishID">被举报微博ID</param> /// <returns>true/false</returns> public bool HandleReport(string publishID) { string message = string.Empty; string message1 = string.Empty; int count = 0; bool result = false; MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <ReportInfo, string>(o => o.PublishID), publishID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition); string sql = DBService.UpdateConditionSql <ReportInfo>(new ReportInfo { ReportStatus = ((int)MiicYesNoSetting.Yes).ToString() }, condition, out message); try { result = dbService.excuteSql(sql, out count, out message1); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
public virtual MiicConditionCollections visitor(GroupInfoDao groupInfo) { MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No); MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition groupNameCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupInfo, string>(o => o.Name), keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, groupNameCondition)); MiicCondition groupRemarkCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.Remark), keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, groupRemarkCondition)); result.Add(keywordCondition); MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberID), userID, DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(userIDCondition)); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <GroupInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(validCondition)); return(result); }
public int GetPersonBlackListCount(GeneralSimpleGroupSearchView searchView) { Contract.Requires <ArgumentNullException>(searchView != null, "参数searchView:不能为空"); int result = 0; MiicConditionCollections conditions = searchView.visitor(this); MiicCondition isBlackListCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.IsBlackList), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(isBlackListCondition)); string message = string.Empty; try { result = dbService.GetCount <AddressBookInfo>(null, conditions, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 根据讨论ID获取messagecount /// </summary> /// <param name="topicID">讨论ID</param> /// <returns>messagecount</returns> public int GetMessageCountByTopicID(string topicID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(topicID), "参数topicID:不能为空"); string message = string.Empty; int result = 0; MiicCondition topicCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, string>(o => o.TopicID), topicID, DbType.String, DB.Setting.MiicDBOperatorSetting.Equal); MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <MessageInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, string>(o => o.ID)); try { result = dbService.GetCount <MessageInfo>(idColumn, new MiicConditionSingle(topicCondition), out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 获取浏览该行业圈子信息的列表 /// </summary> /// <param name="publishID">行业圈子信息ID</param> /// <returns>浏览信息列表</returns> public DataTable GetBrowseInfosByPublishID(string publishID) { DataTable result = new DataTable(); MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID), publishID, DbType.String, MiicDBOperatorSetting.Equal); string message = string.Empty; MiicColumn allColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>()); MiicColumnCollections columns = new MiicColumnCollections(); columns.Add(allColumn); MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition); try { result = dbService.GetInformations <BrowseInfo>(columns, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 获取行业圈子信息评论总数 /// </summary> /// <param name="publishID">行业圈子信息ID</param> /// <returns>评论总数</returns> public int GetCommentCount(string publishID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(publishID), "参数publishID:不能为空"); int result = 0; string message = string.Empty; MiicCondition infoCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommentInfo, string>(o => o.PublishID), publishID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(infoCondition); MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CommentInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <CommentInfo, string>(o => o.ID)); try { result = dbService.GetCount <CommentInfo>(column, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 行业圈子浏览DAO访问器 /// </summary> /// <param name="communityBrowseInfoDao"></param> /// <returns></returns> public MiicConditionCollections visitor(Community.Behavior.BrowseInfoDao communityBrowseInfoDao) { MiicConditionCollections condition = new MiicConditionCollections(); MiicCondition isHintCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.Behavior.BrowseInfo, string>(o => o.IsHinted), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, isHintCondition)); MiicConditionCollections keyworCondition = new MiicConditionCollections(); MiicCondition momentsTitleCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.PublishInfo, string>(o => o.Title), Keyword, DbType.String, MiicDBOperatorSetting.Like); keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, momentsTitleCondition)); MiicCondition momentsContentCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.PublishInfo, string>(o => o.Content), Keyword, DbType.String, MiicDBOperatorSetting.Like); keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, momentsContentCondition)); condition.Add(keyworCondition); MiicCondition browserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Community.Behavior.BrowseInfo, string>(o => o.BrowserID), UserID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(browserIDCondition)); return(condition); }
public override MiicConditionCollections visitor(PublishInfoDao publishInfoDao) { MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.EditStatus), ((int)MiicYesNoSetting.No).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, editStatusCondition)); //发表人是用户 MiicCondition createrIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterID), this.UserID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(createrIDCondition)); //默认时间倒序排列 List <MiicOrderBy> order = new List <MiicOrderBy>(); order.Add(new MiicOrderBy() { Desc = false, PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, DateTime?>(o => o.PublishTime) }); condition.order = order; return(condition); }
public MiicConditionCollections visitor(CommunityInfoDao communityInfoDao) { MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition applicantIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.MemberID), MemberID, DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applicantIDCondition)); MiicConditionCollections responseStatusCondition = new MiicConditionCollections(); MiicCondition applyCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus), ((int)ApplyStatusSetting.Apply).ToString(), DbType.String, MiicDBOperatorSetting.Equal); responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applyCondition)); MiicCondition inviteCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus), ((int)ApplyStatusSetting.Invite).ToString(), DbType.String, MiicDBOperatorSetting.Equal); responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, inviteCondition)); result.Add(responseStatusCondition); MiicCondition comminityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.CommunityID), CommunityID, DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(comminityIDCondition)); return(result); }
int IAddressBookInfo.GetPersonAllAddressBookCount(string userID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空"); int result = 0; string message = string.Empty; MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID), userID, DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition)); MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.ID)); try { result = dbService.GetCount <AddressBookInfo>(idColumn, conditions, out message, true); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
public virtual MiicConditionCollections visitor(AddressBookInfoDao addressBookInfo) { MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No); MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition addresserName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName), keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, addresserName)); MiicCondition remarkName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <AddressBookInfo, string>(o => o.Remark), keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, remarkName)); result.Add(keywordCondition); MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID), userID, DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(userIDCondition)); return(result); }
/// <summary> /// 获取浏览该行业圈子信息的数量 /// </summary> /// <param name="publishID">行业圈子信息ID</param> /// <returns>浏览数</returns> public int?GetBrowseCountByPublishID(string publishID) { int result = 0; MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID), publishID, DbType.String, MiicDBOperatorSetting.Equal); string message = string.Empty; MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.ID)); MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition); try { result = dbService.GetCount <BrowseInfo>(column, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
public DataTable GetOrganizationDetailInfo(string orgID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(orgID), "参数orgID:不能为空"); DataTable result = new DataTable(); string message = string.Empty; MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <OrganizationInfo, string>(o => o.OrgID), orgID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(orgIDCondition); MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <OrganizationInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrganizationInfo, string>(o => o.OrgID), Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.OrgID), MiicDBOperatorSetting.Equal, MiicDBRelationSetting.LeftJoin); MiicColumnCollections columns = new MiicColumnCollections(); MiicColumn orgAllColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrganizationInfo>()); columns.Add(orgAllColumns); MiicColumn fileIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.ID)); columns.Add(fileIDColumn); MiicColumn fileNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FileName)); columns.Add(fileNameColumn); MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FilePath)); columns.Add(filePathColumn); MiicColumn uploadTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, DateTime?>(o => o.UploadTime)); columns.Add(uploadTimeColumn); MiicColumn fileTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FilePath)); columns.Add(fileTypeColumn); try { result = dbService.GetInformations(columns, relation, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
DataTable IAddressBookInfo.GetPersonAllAddressBookList(string userID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空"); DataTable result = new DataTable(); string message = string.Empty; MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID), Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID), MiicDBOperatorSetting.Equal, MiicDBRelationSetting.InnerJoin); MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID), userID, DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition)); MiicColumnCollections columns = new MiicColumnCollections(); MiicColumn addresserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID)); columns.Add(addresserIDColumn); MiicColumn addresserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName)); columns.Add(addresserNameColumn); MiicColumn remarkColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.Remark)); columns.Add(remarkColumn); MiicColumn addresserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserUrl)); columns.Add(addresserUrlColumn); MiicColumn oftenUsedColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.OftenUsed)); columns.Add(oftenUsedColumn); try { result = dbService.GetInformations(columns, relation, conditions, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
bool IAddressBookInfo.Remove(string firestUserID, string secondUserID) { bool result = false; string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; List <string> sqls = new List <string>(); MiicConditionCollections firstCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition firstMyUserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID), firestUserID, DbType.String, MiicDBOperatorSetting.Equal); firstCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, firstMyUserIDCondition)); MiicCondition firstAddresserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID), secondUserID, DbType.String, MiicDBOperatorSetting.Equal); firstCondition.Add(new MiicConditionLeaf(firstAddresserIDCondition)); sqls.Add(DBService.DeleteConditionsSql <AddressBookInfo>(firstCondition, out message1)); MiicConditionCollections secondCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition secondMyUserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID), secondUserID, DbType.String, MiicDBOperatorSetting.Equal); secondCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, secondMyUserIDCondition)); MiicCondition secondAddresserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID), firestUserID, DbType.String, MiicDBOperatorSetting.Equal); secondCondition.Add(new MiicConditionLeaf(secondAddresserIDCondition)); sqls.Add(DBService.DeleteConditionsSql <AddressBookInfo>(secondCondition, out message2)); try { result = dbService.excuteSqls(sqls, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { items.RemoveAll(o => (o.AddresserID == firestUserID && o.MyUserID == secondUserID) || (o.AddresserID == secondUserID && o.MyUserID == firestUserID)); } return(result); }
/// <summary> /// 获取最热行业圈子信息(条件:长篇、已发布的、有效的、上线的) /// </summary> /// <param name="top">top默认:15</param> /// <returns>最热行业圈子信息列表</returns> public DataTable GetTopHotestBrowseInfo(int top) { DataTable result = new DataTable(); string message = string.Empty; MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition longInfoCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType), ((int)PublishInfoTypeSetting.Long).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, longInfoCondition)); MiicCondition publishStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, DateTime?>(o => o.PublishTime), null, DbType.DateTime, MiicDBOperatorSetting.NotIsNull); condition.Add(new MiicConditionLeaf(publishStatusCondition)); MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.EditStatus), ((int)MiicYesNoSetting.No).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(editStatusCondition)); MiicOrderBy orderby = new MiicOrderBy() { Desc = true, PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.BrowseNum) }; List <MiicOrderBy> order = new List <MiicOrderBy>(); order.Add(orderby); condition.order = order; MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>()); MiicColumnCollections columns = new MiicColumnCollections(new MiicTop(top)); try { result = dbService.GetInformations <PublishInfo>(columns, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 是否联系人对自己可见 /// </summary> /// <param name="myID"></param> /// <param name="addresserID"></param> /// <returns></returns> public bool CanSeeAddresser(string myID, string addresserID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(myID), "参数myID:不能为空"); Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(addresserID), "参数addresserID:不能为空"); bool result = false; string message = string.Empty; MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition myIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID), addresserID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, myIDCondition)); MiicCondition addresserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID), myID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(addresserIDCondition)); MiicCondition canSeeAddresserCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.CanSeeMe), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(canSeeAddresserCondition)); MiicColumn idColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.ID)); try { int addresser = dbService.GetCount <AddressBookInfo>(idColumn, condition, out message); if (addresser == 1) { result = true; } else { result = false; } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
public DataTable Search(GeneralSimpleGroupSearchView searchView, MiicPage page) { Contract.Requires <ArgumentNullException>(searchView != null, "参数searchView:不能为空"); DataTable result = new DataTable(); string message = string.Empty; MiicConditionCollections conditions = searchView.visitor(this); MiicCondition isBlackListCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.IsBlackList), ((int)MiicYesNoSetting.No).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(isBlackListCondition)); List <MiicOrderBy> order = new List <MiicOrderBy>(); order.Add(new MiicOrderBy() { Desc = true, PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName) }); order.Add(new MiicOrderBy() { Desc = true, PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.OftenUsed) }); conditions.order = order; MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID), Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID), MiicDBOperatorSetting.Equal, MiicDBRelationSetting.InnerJoin); MiicColumnCollections columns = new MiicColumnCollections(); MiicColumn addressBookInfoColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>()); columns.Add(addressBookInfoColumns); MiicColumn ImageUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl)); columns.Add(ImageUrlColumn); MiicColumn NickNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(), "", Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName), "NickName"); columns.Add(NickNameColumn); if (page != null) { result = dbService.GetInformationsPage(columns, relation, conditions, page, out message); } else { result = dbService.GetInformations(columns, relation, conditions, out message); } return(result); }
/// <summary> /// 获得用户所有信息 /// </summary> /// <returns></returns> DataTable IUserInfo.GetAllUserInfos() { DataTable result = new DataTable(); string message = string.Empty; MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <UserInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <UserInfo, string>(o => o.UserID), Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ID), MiicDBOperatorSetting.Equal, MiicDBRelationSetting.LeftJoin); MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); //选择有效地,没有被禁止的,已经被激活的 MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.DisabledFlag), ((int)MiicYesNoSetting.No).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, disabledFlagCondition)); MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ActivateFlag), ((int)UserActivateSetting.Agree).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(activateFlagCondition)); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(validCondition)); MiicColumnCollections columns = new MiicColumnCollections(); MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <UserInfo>()); columns.Add(column); try { result = dbService.GetInformations(columns, relation, conditions, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
bool ICommon <RegisterTypeInfo> .Delete(string id) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id:不能为空"); bool result = false; string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; List <string> sqls = new List <string>(); sqls.Add(DBService.DeleteSql(new RegisterTypeInfo() { ID = id }, out message1)); MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition registerTypeID = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimRegisterType, string>(o => o.RegisterTypeID), id, DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, registerTypeID)); MiicCondition valid = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimRegisterType, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(valid)); sqls.Add(DBService.UpdateConditionsSql <DimRegisterType>(new DimRegisterType() { EndTime = DateTime.Now, Valid = ((int)MiicValidTypeSetting.InValid).ToString() }, conditions, out message2)); try { result = dbService.excuteSqls(sqls, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { DeleteCache(o => o.ID == id); } return(result); }
bool ICommunityInfo.IsAdmin(string userID, string communityID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空"); bool result = false; string message = string.Empty; MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition isAdminCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.IsAdmin), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, isAdminCondition)); MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberID), userID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(userIDCondition)); if (!string.IsNullOrEmpty(communityID)) { MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.CommunityID), communityID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(communityIDCondition)); } MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CommunityMember>(), Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.ID)); try { int count = dbService.GetCount <CommunityMember>(column, condition, out message); if (count > 0) { result = true; } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 根据标签主题获取所有发布博文附件列表 /// </summary> /// <param name="labelID">标签主题ID</param> /// <returns>附件列表</returns> public List <AccessoryInfo> GetAccessoryListByLabelID(string labelID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelID), "参数labelID:不能为空"); List <AccessoryInfo> result = new List <AccessoryInfo>(); string message = string.Empty; MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <PublishLabelRelation>(), Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.PublishID), Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID), MiicDBOperatorSetting.Equal, MiicDBRelationSetting.InnerJoin); MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID), labelID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition); MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)); MiicColumnCollections columns = new MiicColumnCollections(); columns.Add(filePathColumn); try { DataTable dt = dbService.GetInformations(columns, relation, condition, out message); foreach (var dr in dt.AsEnumerable()) { result.Add(new AccessoryInfo() { ID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)].ToString(), PublishID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID)].ToString(), FileName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName)].ToString(), FilePath = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)].ToString(), UploadTime = (DateTime?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime)], FileType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType)].ToString() }); } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
List <CommunityMember> ICommunityInfo.GetMemberInfoListByCommunityID(string communityID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID:不能为空"); string message = string.Empty; List <CommunityMember> result = new List <CommunityMember>(); try { result = subitems.FindAll(o => o.CommunityID == communityID); if (result.Count == 0) { MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.CommunityID), communityID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition); DataTable dt = dbService.GetInformations <CommunityMember>(null, condition, out message); subitems.RemoveAll(o => o.CommunityID == communityID); if (dt.Rows.Count > 0) { foreach (var item in dt.AsEnumerable()) { result.Add(new CommunityMember() { ID = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.ID)].ToString(), CommunityID = communityID, IsAdmin = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.IsAdmin)].ToString(), JoinTime = (DateTime?)item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, DateTime?>(o => o.JoinTime)], MemberID = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberID)].ToString(), MemberName = item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberName)].ToString(), SortNo = (int?)item[Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, int?>(o => o.SortNo)] }); } subitems.AddRange(result); } } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
bool ICommunityInfo.IsApplicationHandledByApplyID(string applyID) { Contract.Requires <ArgumentNullException>(applyID != null, "参数applyID:不能为空"); bool result = false; int count = 0; string message = string.Empty; MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition applicantIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ID), applyID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applicantIDCondition)); MiicConditionCollections responseStatusCondition = new MiicConditionCollections(); MiicCondition applyCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus), ((int)ApplyStatusSetting.Apply).ToString(), DbType.String, MiicDBOperatorSetting.Equal); responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, applyCondition)); MiicCondition inviteCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ResponseStatus), ((int)ApplyStatusSetting.Invite).ToString(), DbType.String, MiicDBOperatorSetting.Equal); responseStatusCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, inviteCondition)); condition.Add(responseStatusCondition); try { count = dbService.GetCount <CommunityApplicationInfo>(new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CommunityApplicationInfo>(), Config.Attribute.GetSqlColumnNameByPropertyName <CommunityApplicationInfo, string>(o => o.ID)), condition, out message); if (count == 0) { result = true; } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
/// <summary> /// 根据微博ID获取所有微博附件列表 /// </summary> /// <param name="publishID">微博ID</param> /// <returns>微博附件列表</returns> public List <AccessoryInfo> GetAccessoryList(string publishID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(publishID), "参数publishID:不能为空"); List <AccessoryInfo> result = new List <AccessoryInfo>(); MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID), publishID, DbType.String, MiicDBOperatorSetting.Equal); string message = string.Empty; MiicColumn allColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>()); MiicColumnCollections columns = new MiicColumnCollections(); columns.Add(allColumn); MiicConditionSingle condition = new MiicConditionSingle(publishIDCondition); try { DataTable dt = dbService.GetInformations <AccessoryInfo>(columns, condition, out message); if (dt.Rows.Count != 0) { subitems.RemoveAll(o => o.PublishID == publishID); foreach (var item in dt.AsEnumerable()) { result.Add(new AccessoryInfo() { ID = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)].ToString(), PublishID = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID)].ToString(), FileName = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName)].ToString(), FilePath = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)].ToString(), UploadTime = (DateTime?)item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime)], FileType = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType)].ToString() }); } subitems.AddRange(result); } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
DataTable IGroupInfo.GetDetailMemberInfoListByGroupID(string groupID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(groupID), "参数groupID:不能为空"); string message = string.Empty; DataTable result = new DataTable(); MiicCondition groupIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.GroupID), groupID, DbType.String, MiicDBOperatorSetting.Equal); MiicConditionSingle condition = new MiicConditionSingle(groupIDCondition); MiicColumnCollections column = new MiicColumnCollections(); MiicColumn memberAll = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <GroupMember>()); column.Add(memberAll); MiicColumn userUrl = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl)); column.Add(userUrl); MiicColumn userName = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName)); column.Add(userName); MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <GroupMember>(), Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberID), Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(), Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID), MiicDBOperatorSetting.Equal, MiicDBRelationSetting.InnerJoin); try { result = dbService.GetInformations(column, relation, condition, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
List <SimplePersonUserView> IUserInfo.GetSimplePersonUserInfos(List <string> ids) { List <SimplePersonUserView> result = new List <SimplePersonUserView>(); string message = string.Empty; MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition idsCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID), ids, DbType.String, MiicDBOperatorSetting.In); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, idsCondition)); MiicColumnCollections columns = new MiicColumnCollections(); MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>()); columns.Add(column); try { DataTable dt = dbService.GetInformations <SimplePersonUserView>(columns, conditions, out message); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.AsEnumerable()) { result.Add(new SimplePersonUserView() { UserID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID)].ToString(), OrgName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.OrgName)].ToString(), SocialCode = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.SocialCode)].ToString(), UserLevel = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserLevel)].ToString(), UserName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserName)].ToString(), UserType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserType)].ToString(), UserUrl = dr[Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserUrl)].ToString() }); } } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }