public string SearchFriends(MyKeywordView keywordView, MiicPage page)
{
string result = CommonService.InitialJsonList;
Miic.Friends.User.IUserInfo IuserInfo = new Miic.Friends.User.UserInfoDao();
DataTable dt = IuserInfo.Search(keywordView, page);
if (dt.Rows.Count > 0)
{
var temp = from dr in dt.AsEnumerable()
select new
{
ID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID)],
UserType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserType)],
UserName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName)],
RealName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.RealName)],
Sex = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.Sex)],
OrgName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.OrgName)],
UserUrl = CommonService.GetManageFullUrl(dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl)].ToString()),
IsMyFriend = Convert.IsDBNull(dr["ADDRESS_BOOK_" + Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.ID)]) == false || (!string.IsNullOrEmpty(this.UserID) && dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID)].ToString() == this.UserID) ? true : false
};
result = Config.Serializer.Serialize(temp);
}
return(result);
}
/// <summary>
/// 我的收藏信息数
/// </summary>
/// <param name="keywordView">关键字视图</param>
/// <returns>收藏信息总数</returns>
public int GetCollectCount(MyKeywordView keywordView)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
int result = 0;
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicFriendRelation collectRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicFriendRelation accRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
List <MiicFriendRelation> relations = new List <MiicFriendRelation>();
relations.Add(collectRelation);
relations.Add(accRelation);
MiicRelationCollections relation = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(), relations);
MiicColumn column = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID));
try
{
result = dbService.GetCount(column, relation, condition, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
/// <summary>
/// 我的收藏信息列表
/// </summary>
/// <param name="keywordView">关键字视图</param>
/// <param name="orderView">排序视图</param>
/// <param name="page">分页</param>
/// <returns>收藏信息列表</returns>
public DataTable GetCollectInfos(MyKeywordView keywordView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
List <MiicOrderBy> orders = new List <MiicOrderBy>();
MiicColumnCollections column = new MiicColumnCollections();
MiicConditionCollections condition = keywordView.visitor(this);
MiicOrderBy collectOrder = new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, DateTime?>(o => o.CollectTime)
};
orders.Add(collectOrder);
condition.order = orders;
MiicFriendRelation collectRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicFriendRelation accRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicFriendRelation userRelation = new MiicFriendRelation(Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
List <MiicFriendRelation> relations = new List <MiicFriendRelation>();
relations.Add(collectRelation);
relations.Add(accRelation);
relations.Add(userRelation);
MiicRelationCollections relation = new MiicRelationCollections(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(), relations);
MiicColumn microPartakePublishInfoAllColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>());
column.Add(microPartakePublishInfoAllColumns);
MiicColumn microCollectInfoIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
string.Empty,
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID),
"CommunityCollectInfoID");
column.Add(microCollectInfoIDColumn);
MiicColumn collectTime = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, DateTime?>(o => o.CollectTime));
column.Add(collectTime);
//收藏人员表
MiicColumn collectorIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorID));
column.Add(collectorIDColumn);
MiicColumn collectorNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <CollectInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorName));
column.Add(collectorNameColumn);
MiicColumn microAccessoryIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
string.Empty,
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID),
"CommunityAccessoryInfoID");
column.Add(microAccessoryIDColumn);
MiicColumn fileNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName));
column.Add(fileNameColumn);
MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath));
column.Add(filePathColumn);
MiicColumn uploadTime = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime));
column.Add(uploadTime);
MiicColumn fileTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType));
column.Add(fileTypeColumn);
MiicColumn orgNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.OrgName));
column.Add(orgNameColumn);
MiicColumn userUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserUrl));
column.Add(userUrlColumn);
MiicColumn userTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Manage.User.SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserType));
column.Add(userTypeColumn);
try
{
if (page == null)
{
result = dbService.GetInformations(column, relation, condition, out message);
}
else
{
result = dbService.GetInformationsPage(column, relation, condition, page, out message, MiicDBPageRowNumberSetting.DenseRank);
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
public int GetCollectInfoCount(MyKeywordView keywordView)
{
return(((CollectInfoDao)IcollectInfo).GetCollectCount(keywordView));
}
public string GetCollectInfos(MyKeywordView keywordView, MiicPage page)
{
string result = CommonService.InitialJsonList;
DataTable dt = ((CollectInfoDao)IcollectInfo).GetCollectInfos(keywordView, page);
if (dt.Rows.Count > 0)
{
var temp = from dr in dt.AsEnumerable()
group dr by
new
{
ID = dr["CommunityCollectInfo" + Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.ID)].ToString(),
PublishInfoID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID)].ToString(),
Title = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Title)].ToString(),
DetailContent = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Content)].ToString(),
Content = CommonService.DelImgStr(dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType)].ToString(), dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Content)].ToString(), false),
CreaterID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterID)].ToString(),
CreaterName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.CreaterName)].ToString(),
CreaterOrgName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.OrgName)].ToString(),
CreaterUserUrl = CommonService.GetManageFullUrl(dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserUrl)].ToString()),
CreaterUserType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Manage.User.SimplePersonUserView, string>(o => o.UserType)].ToString(),
CreateTime = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, DateTime?>(o => o.CreateTime)],
EditStatus = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.EditStatus)].ToString(),
PublishTime = (DateTime?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, DateTime?>(o => o.PublishTime)],
PublishType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType)].ToString(),
BrowseNum = (int?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.BrowseNum)],
PraiseNum = (int?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.PraiseNum)],
TreadNum = (int?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.TreadNum)],
TransmitNum = (int?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.TransmitNum)],
CollectNum = (int?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.CollectNum)],
CommentNum = (int?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, int?>(o => o.CommentNum)]
} into g
select new
{
ID = g.Key.ID,
PublishInfoID = g.Key.PublishInfoID,
Title = g.Key.Title,
DetailContent = g.Key.DetailContent,
Content = g.Key.Content,
CreaterID = g.Key.CreaterID,
CreaterName = g.Key.CreaterName,
CreaterOrgName = g.Key.CreaterOrgName,
CreaterUserUrl = g.Key.CreaterUserUrl,
CreaterUserType = g.Key.CreaterUserType,
CreateTime = g.Key.CreateTime,
EditStatus = g.Key.EditStatus,
PublishTime = g.Key.PublishTime,
PublishType = g.Key.PublishType,
BrowseNum = g.Key.BrowseNum,
PraiseNum = g.Key.PraiseNum,
TreadNum = g.Key.TreadNum,
TransmitNum = g.Key.TransmitNum,
CollectNum = g.Key.CollectNum,
IsCollect = (from item in g.AsParallel()
where Convert.IsDBNull(item[Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorID)]) == false &&
item[Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorID)].ToString() == UserID
select new
{
CollectorID = item[Config.Attribute.GetSqlColumnNameByPropertyName <CollectInfo, string>(o => o.CollectorID)].ToString()
}).Distinct().Count() == 0 ? false : true,
AccInfos = (from item in g
where Convert.IsDBNull(item["CommunityAccessoryInfo" + Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)]) == false
select new
{
MicroAccessoryInfoID = item["CommunityAccessoryInfo" + Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)].ToString(),
FileName = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName)].ToString(),
FilePath = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)].ToString(),
UploadTime = (DateTime?)item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime)],
FileType = item[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType)].ToString()
}).Distinct()
};
result = Config.Serializer.Serialize(temp);
}
return(result);
}
/// <summary>
/// 获取用户关注过的行业圈子信息数目
/// </summary>
/// <param name="keywordView">关键字视图</param>
/// <returns></returns>
public int GetHintedBrowseCount(MyKeywordView keywordView)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不能为空");
int result = 0;
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID),
Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.ID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn browseIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.ID));
columns.Add(browseIDColumn);
MiicColumn browserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.BrowserID));
columns.Add(browserIDColumn);
MiicColumn browserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.BrowserName));
columns.Add(browserNameColumn);
MiicColumn publishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <BrowseInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <BrowseInfo, string>(o => o.PublishID));
columns.Add(publishIDColumn);
MiicColumn microTitleColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Title));
columns.Add(microTitleColumn);
MiicColumn microContentColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.Content));
columns.Add(microContentColumn);
MiicColumn microTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <PublishInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishInfo, string>(o => o.PublishType));
columns.Add(microTypeColumn);
try
{
DataTable dt = dbService.GetInformations(columns, relation, condition, out message);
DataView dtView = dt.DefaultView;
result = (dtView.ToTable(true)).Rows.Count;
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
public int GetSearchFriendsCount(MyKeywordView keywordView)
{
Miic.Friends.User.IUserInfo IuserInfo = new Miic.Friends.User.UserInfoDao();
return(IuserInfo.GetSearchCount(keywordView));
}
