/// <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 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 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); }
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); }
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); }
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); }
/// <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); }
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> /// 检测标签名称的唯一性 /// </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> /// 获取我的/某人@离线未读信息 /// </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> /// 举报DAO访问器 /// </summary> /// <param name="communityReportInfoDao">举报</param> /// <returns></returns> public MiicConditionCollections visitor(Community.Behavior.ReportInfoDao communityReportInfoDao) { MiicConditionCollections condition = new MiicConditionCollections(); MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <ReportInfo, string>(o => o.PublishID), PublishID, DbType.String, MiicDBOperatorSetting.Equal); MiicCondition collectorIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <ReportInfo, string>(o => o.ReporterID), LoginUserID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, publishIDCondition)); condition.Add(new MiicConditionLeaf(collectorIDCondition)); return(condition); }
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 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); }
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 DataTable GetAreaInfosByPID(string pid) { DataTable result = new DataTable(); string message = string.Empty; MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition pidCondition; if (!string.IsNullOrEmpty(pid)) { pidCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AreaInfo, int?>(o => o.PID), pid, DbType.Int32, MiicDBOperatorSetting.Equal); } else { pidCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AreaInfo, int?>(o => o.PID), null, DbType.Int32, MiicDBOperatorSetting.IsNull); } conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, pidCondition)); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AreaInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(validCondition)); try { result = dbService.GetInformations <AreaInfo>(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> /// 点赞DAO访问器 /// </summary> /// <param name="praiseInfoDao">点赞</param> /// <returns></returns> public MiicConditionCollections visitor(Moments.Behavior.PraiseInfoDao praiseInfoDao) { MiicConditionCollections condition = new MiicConditionCollections(); MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, string>(o => o.PublishID), PublishID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, publishIDCondition)); MiicCondition praiserIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PraiseInfo, string>(o => o.PraiserID), UserID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(praiserIDCondition)); return(condition); }
public MiicConditionCollections vistor(PublishInfoDao publishDao) { MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.CommunityID), CommunityID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, communityIDCondition)); MiicCondition labelIDIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID), LabelID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(labelIDIDCondition)); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); 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)); MiicConditionCollections dateCondition = new MiicConditionCollections(); MiicCondition yearCondition = new MiicCondition(MiicSimpleDateTimeFunction.YearFunc <PublishInfo, DateTime?>(o => o.PublishTime), Year, DbType.String, MiicDBOperatorSetting.Equal); dateCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, yearCondition)); if (!string.IsNullOrEmpty(Month)) { MiicCondition monthCondition = new MiicCondition(MiicSimpleDateTimeFunction.MonthFunc <PublishInfo, DateTime?>(o => o.PublishTime), Month, DbType.String, MiicDBOperatorSetting.Equal); dateCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.And, monthCondition)); } condition.Add(dateCondition); return(condition); }
/// <summary> /// 登录访问器 /// </summary> /// <param name="miicSocialUserDao">登录DAO</param> /// <returns>登录访问生成条件</returns> public MiicConditionCollections visitor(MiicSocialUserDao miicSocialUserDao) { MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition passwordCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.SM3Password), getMD5bySM2(rsaPassword), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, passwordCondition)); MiicConditionCollections userCodeCondition = new MiicConditionCollections(MiicDBLogicSetting.And); MiicCondition socialCodeCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.SocialCode), socialCode, DbType.String, MiicDBOperatorSetting.Equal); userCodeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, socialCodeCondition)); MiicCondition mobileCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Mobile), socialCode, DbType.String, MiicDBOperatorSetting.Equal); userCodeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, mobileCondition)); result.Add(userCodeCondition); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(validCondition)); MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ActivateFlag), ((int)(MiicSimpleApproveStatusSetting.Agree)).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(activateFlagCondition)); MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.DisabledFlag), ((int)(MiicYesNoSetting.No)).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(disabledFlagCondition)); 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="communityID">圈子ID</param> /// <returns>标签集合</returns> public DataTable GetLabelInfosByCommunityID(string communityID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID:不能为空!"); string message = string.Empty; DataTable result = new DataTable(); MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); 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 validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); List <MiicOrderBy> orders = new List <MiicOrderBy>(); orders.Add(new MiicOrderBy() { Desc = false, PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, int?>(o => o.SortNo) }); condition.order = orders; try { result = dbService.GetInformations <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); }
/// <summary> /// 根据大行业ID获取小行业信息集合 /// </summary> /// <param name="tradeID">大行业ID</param> /// <returns>小行业信息集合</returns> public DataTable GetTradeSubInfosByTradeID(string tradeID) { DataTable result = new DataTable(); string message = string.Empty; MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition tradeIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <TradeSubInfo, string>(o => o.TradeID), tradeID, DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, tradeIDCondition)); MiicCondition pidCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <TradeSubInfo, string>(o => o.PID), null, DbType.String, MiicDBOperatorSetting.IsNull); conditions.Add(new MiicConditionLeaf(pidCondition)); List <MiicOrderBy> orders = new List <MiicOrderBy>(); orders.Add(new MiicOrderBy() { Desc = false, PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <TradeSubInfo, int?>(o => o.SortNo) }); conditions.order = orders; try { result = dbService.GetInformations <TradeSubInfo>(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); }
bool INoticeInfo <NoticeInfo> .ReadAllNotice(string noticerID, BusinessTypeSetting businessType) { bool result = false; int count = 0; string message = string.Empty; MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition sourceCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.Source), ((int)businessType).ToString(), DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, sourceCondition)); MiicCondition noticerIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.NoticerID), noticerID, DbType.String, MiicDBOperatorSetting.Equal); conditions.Add(new MiicConditionLeaf(noticerIDCondition)); try { result = dbService.UpdateConditions <NoticeInfo>(new NoticeInfo() { ReadStatus = ((int)MiicReadStatusSetting.Read).ToString() }, conditions, out count, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { items.RemoveAll(o => o.NoticerID == noticerID && o.Source == ((int)businessType).ToString()); } return(result); }
/// <summary> /// 标签是否被使用 /// </summary> /// <param name="labelID">标签ID</param> /// <returns>Yes/No</returns> private bool IsUsed(string labelID) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelID), "参数labelID:不能为空"); bool result = false; string message = string.Empty; MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition labelIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID), labelID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, labelIDCondition)); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); int count = 0; try { count = dbService.GetCount <PublishLabelRelation>(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 }); } if (count > 0) { result = true; } return(result); }
/// <summary> /// 朋友圈DAO访问器 /// </summary> /// <param name="publishInfoDao"></param> /// <returns></returns> public MiicConditionCollections visitor(PublishInfoDao publishInfoDao) { MiicConditionCollections condition = new MiicConditionCollections(); //编辑状态为草稿 MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.EditStatus), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, editStatusCondition)); MiicConditionCollections keyworCondition = new MiicConditionCollections(); MiicCondition microTitleCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Title), Keyword, DbType.String, MiicDBOperatorSetting.Like); keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, microTitleCondition)); MiicCondition microContentCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Content), Keyword, DbType.String, MiicDBOperatorSetting.Like); keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, microContentCondition)); condition.Add(keyworCondition); MiicCondition createrIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterID), userID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(createrIDCondition)); MiicCondition microTypeCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType), ((int)PublishInfoTypeSetting.Long).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(microTypeCondition)); return(condition); }
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); }
public MiicConditionCollections visitor(UserInfoDao userInfoDao) { MiicConditionCollections result = new MiicConditionCollections(); //关键字 MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition socialCode = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.SocialCode), this.Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, socialCode)); MiicCondition userName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName), this.Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, userName)); result.Add(keywordCondition); return(result); }