/// <summary>
/// 获取登录用户的行为FLAG 查询语句
/// </summary>
/// <param name="PublishInfoDao"></param>
/// <returns>querySql</returns>
public string visitor(PublishInfoDao PublishInfoDao)
{
string querySql = string.Empty;
querySql = "SELECT * FROM dbo.GetMyCommunityBehaviorFlags('" + LoginUserID + "','" + PublishID + "')";
return(querySql);
}
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>
/// 朋友圈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);
}
