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="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>
/// <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>
/// <returns></returns>
DataTable IUserInfo.GetAllUserInfos()
{
DataTable result = new DataTable();
string message = string.Empty;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <UserInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <UserInfo, string>(o => o.UserID),
Config.Attribute.GetSqlTableNameByClassName <MiicSocialUserInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
//选择有效地，没有被禁止的，已经被激活的
MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.DisabledFlag),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, disabledFlagCondition));
MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ActivateFlag),
((int)UserActivateSetting.Agree).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(activateFlagCondition));
MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(validCondition));
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <UserInfo>());
columns.Add(column);
try
{
result = dbService.GetInformations(columns, relation, conditions, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
public DataTable Search(GeneralSimpleGroupSearchView searchView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(searchView != null, "参数searchView:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections conditions = searchView.visitor(this);
MiicCondition isBlackListCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.IsBlackList),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(isBlackListCondition));
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName)
});
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.OftenUsed)
});
conditions.order = order;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn addressBookInfoColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>());
columns.Add(addressBookInfoColumns);
MiicColumn ImageUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl));
columns.Add(ImageUrlColumn);
MiicColumn NickNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
"",
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName), "NickName");
columns.Add(NickNameColumn);
if (page != null)
{
result = dbService.GetInformationsPage(columns, relation, conditions, page, out message);
}
else
{
result = dbService.GetInformations(columns, relation, conditions, out message);
}
return(result);
}
/// <summary>
/// 查询当前登录人员对指定行业圈子信息的收藏信息
/// </summary>
/// <param name="communityBehaviorView">用户行为（收藏）视图</param>
/// <returns>收藏信息</returns>
public CollectInfo GetUserCollectInfo(MyCommunityBehaviorView communityBehaviorView)
{
Contract.Requires <ArgumentNullException>(communityBehaviorView != null, "参数communityBehaviorView:不能为空");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityBehaviorView.PublishID), "参数communityBehaviorView.PublishID:不能为空");
CollectInfo result = null;
string message = string.Empty;
MiicConditionCollections condition = communityBehaviorView.visitor(this);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn collectAll = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>());
columns.Add(collectAll);
try
{
result = items.Find(o => o.PublishID == communityBehaviorView.PublishID && o.CollectorID == communityBehaviorView.LoginUserID);
if (result == null)
{
DataTable dt = dbService.GetInformations <CollectInfo>(columns, condition, out message);
if (dt != null && dt.Rows.Count == 1)
{
result = new CollectInfo()
{
ID = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID)].ToString(),
CollectorID = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorID)].ToString(),
CollectorName = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorName)].ToString(),
CollectTime = (DateTime?)dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, DateTime?>(o => o.CollectTime)],
PublishID = dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.PublishID)].ToString(),
SortNo = (int?)dt.Rows[0][Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, int?>(o => o.SortNo)]
};
}
if (result != null)
{
InsertCache(result);
}
}
else
{
string serializer = Config.Serializer.Serialize(result);
result = Config.Serializer.Deserialize <CollectInfo>(serializer);
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
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);
}
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);
}
/// <summary>
/// 获取我的/某人@离线未读信息
/// </summary>
/// <param name="userID">用户ID</param>
/// <returns>离线信息列表</returns>
public DataTable GetPersonOfflineNoticeList(string userID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeShowInfo, string>(o => o.NoticerID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition));
MiicCondition readStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeShowInfo, string>(o => o.ReadStatus),
((int)MiicReadStatusSetting.UnRead).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(readStatusCondition));
List <MiicOrderBy> orders = new List <MiicOrderBy>();
orders.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <NoticeShowInfo, DateTime?>(o => o.PublishTime)
});
condition.order = orders;
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <NoticeShowInfo>());
columns.Add(column);
try
{
result = dbService.GetInformations <NoticeShowInfo>(columns, condition, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
/// <summary>
/// 检测标签名称的唯一性
/// </summary>
/// <param name="communityID">圈子ID</param>
/// <param name="labelName">标签名称</param>
/// <returns>不存在true 存在false</returns>
public bool UniqueLabel(string communityID, string labelName)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(communityID), "参数communityID：不能为空！");
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelName), "参数labelName：不能为空！");
bool result = false;
string message = string.Empty;
MiicConditionCollections condition = new MiicConditionCollections();
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CommunityID),
communityID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, communityIDCondition));
MiicCondition labelNameCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.LabelName),
labelName.Trim(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(labelNameCondition));
MiicColumn labelIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID));
try
{
int count = dbService.GetCount <LabelInfo>(labelIDColumn, condition, out message);
if (count == 0)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
public DataTable GetRegisterTypeInfosByPID(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 <RegisterTypeInfo, string>(o => o.PID),
pid,
DbType.String,
MiicDBOperatorSetting.Equal);
}
else
{
pidCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <RegisterTypeInfo, string>(o => o.PID),
null,
DbType.String,
MiicDBOperatorSetting.IsNull);
}
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, pidCondition));
List <MiicOrderBy> orders = new List <MiicOrderBy>();
orders.Add(new MiicOrderBy()
{
Desc = false,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <RegisterTypeInfo, int?>(o => o.SortNo)
});
conditions.order = orders;
try
{
result = dbService.GetInformations <RegisterTypeInfo>(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="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);
}
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>
/// 我的收藏信息数
/// </summary>
/// <param name="keywordView">关键字视图</param>
/// <returns>收藏信息总数</returns>
public int GetCollectCount(MyKeywordView keywordView)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
int result = 0;
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicFriendRelation collectRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicFriendRelation accRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
List <MiicFriendRelation> relations = new List <MiicFriendRelation>();
relations.Add(collectRelation);
relations.Add(accRelation);
MiicRelationCollections relation = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(), relations);
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID));
try
{
result = dbService.GetCount(column, relation, condition, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
/// <summary>
/// 点赞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);
}
DataTable INoticeInfo <MessageInfo> .GetMyNoticeInfoList(MyNoticeView myNoticeView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(myNoticeView != null, "参数myNoticeView:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections conditions = myNoticeView.visitor(this);
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, DateTime?>(o => o.PublishTime)
});
conditions.order = order;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <MessageInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <MessageInfo, string>(o => o.PublisherID),
Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
try
{
if (page != null)
{
result = dbService.GetInformationsPage(null, relation, conditions, page, out message);
}
else
{
result = dbService.GetInformations(null, 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="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);
}
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="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);
}
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 MiicConditionCollections visitor(NoticeInfoDao noticeInfoDao)
{
MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition publishIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.PublishID),
this.PublishID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, publishIDCondition));
MiicCondition publisherIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.PublisherID),
this.PublisherID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(publisherIDCondition));
MiicCondition noticerIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.NoticerID),
this.NoticerID,
DbType.String,
MiicDBOperatorSetting.In);
result.Add(new MiicConditionLeaf(noticerIDCondition));
MiicCondition readStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.ReadStatus),
((int)MiicReadStatusSetting.UnRead).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(readStatusCondition));
MiicCondition sourceCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.Source),
this.Source,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(publisherIDCondition));
MiicCondition noticeTypeCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.NoticeType),
this.NoticeType,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(noticeTypeCondition));
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);
}
int IAddressBookInfo.GetPersonValidationMessageCount(string userID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
string message = string.Empty;
int result = 0;
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookApplicationInfo, string>(o => o.AddresserID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition));
MiicCondition responseStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookApplicationInfo, string>(o => o.ResponseStatus),
((int)ApplyStatusSetting.Apply).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(responseStatusCondition));
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookApplicationInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookApplicationInfo, string>(o => o.ID));
try
{
result = dbService.GetCount <AddressBookApplicationInfo>(column, conditions, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
public override MiicConditionCollections visitor(PublishInfoDao publishInfoDao)
{
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressPublishInfo, string>(o => o.EditStatus),
((int)MiicYesNoSetting.No).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, editStatusCondition));
MiicConditionCollections dateCondition = new MiicConditionCollections();
MiicCondition yearCondition = new MiicCondition(MiicSimpleDateTimeFunction.YearFunc <AddressPublishInfo, 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 <AddressPublishInfo, DateTime?>(o => o.PublishTime),
Month,
DbType.String,
MiicDBOperatorSetting.Equal);
dateCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.And, monthCondition));
}
condition.Add(dateCondition);
//发表人是用户
MiicCondition createrIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressPublishInfo, string>(o => o.CreaterID),
this.UserID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(createrIDCondition));
return(condition);
}
/// <summary>
/// 朋友圈收藏DAO访问器
/// </summary>
/// <param name="momentsCollectInfoDao"></param>
/// <returns></returns>
public MiicConditionCollections visitor(Moments.Behavior.CollectInfoDao momentsCollectInfoDao)
{
MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No);
//收藏人
MiicCondition collecterCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Moments.Behavior.CollectInfo, string>(o => o.CollectorID),
UserID,
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, collecterCondition));
//标题或内容匹配
MiicConditionCollections keyworCondition = new MiicConditionCollections();
MiicCondition titleCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Moments.PublishInfo, string>(o => o.Title),
Keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, titleCondition));
MiicCondition contentCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Moments.PublishInfo, string>(o => o.Content),
Keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keyworCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, contentCondition));
condition.Add(keyworCondition);
//有效收藏
MiicCondition collectValidCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.Moments.Behavior.CollectInfo, string>(o => o.CollectValid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
condition.Add(new MiicConditionLeaf(collectValidCondition));
return(condition);
}
public virtual MiicConditionCollections visitor(CommunityInfoDao communityInfo)
{
MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition keywordCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityInfo, string>(o => o.Name),
keyword,
DbType.String,
MiicDBOperatorSetting.Like);
result.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, keywordCondition));
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityMember, string>(o => o.MemberID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(userIDCondition));
MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <CommunityInfo, string>(o => o.Valid),
((int)MiicValidTypeSetting.Valid).ToString(),
DbType.String,
MiicDBOperatorSetting.Equal);
result.Add(new MiicConditionLeaf(validCondition));
return(result);
}
