public DataTable GetOrganizationDetailInfo(string orgID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(orgID), "参数orgID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <OrganizationInfo, string>(o => o.OrgID),
orgID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(orgIDCondition);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <OrganizationInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrganizationInfo, string>(o => o.OrgID),
Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.OrgID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn orgAllColumns = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrganizationInfo>());
columns.Add(orgAllColumns);
MiicColumn fileIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.ID));
columns.Add(fileIDColumn);
MiicColumn fileNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FileName));
columns.Add(fileNameColumn);
MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FilePath));
columns.Add(filePathColumn);
MiicColumn uploadTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, DateTime?>(o => o.UploadTime));
columns.Add(uploadTimeColumn);
MiicColumn fileTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <OrgProductInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <OrgProductInfo, string>(o => o.FilePath));
columns.Add(fileTypeColumn);
try
{
result = dbService.GetInformations(columns, relation, condition, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
DataTable IAddressBookInfo.GetPersonAllAddressBookList(string userID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(userID), "参数userID:不能为空");
DataTable result = new DataTable();
string message = string.Empty;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID),
Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicConditionCollections conditions = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.MyUserID),
userID,
DbType.String,
MiicDBOperatorSetting.Equal);
conditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition));
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn addresserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserID));
columns.Add(addresserIDColumn);
MiicColumn addresserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.AddresserName));
columns.Add(addresserNameColumn);
MiicColumn remarkColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.Remark));
columns.Add(remarkColumn);
MiicColumn addresserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <SimplePersonUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <SimplePersonUserView, string>(o => o.UserUrl));
columns.Add(addresserUrlColumn);
MiicColumn oftenUsedColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AddressBookInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AddressBookInfo, string>(o => o.OftenUsed));
columns.Add(oftenUsedColumn);
try
{
result = dbService.GetInformations(columns, relation, conditions, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
/// <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="labelID">标签主题ID</param>
/// <returns>附件列表</returns>
public List <AccessoryInfo> GetAccessoryListByLabelID(string labelID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(labelID), "参数labelID:不能为空");
List <AccessoryInfo> result = new List <AccessoryInfo>();
string message = string.Empty;
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <PublishLabelRelation>(),
Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.PublishID),
Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
MiicCondition communityIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <PublishLabelRelation, string>(o => o.LabelID),
labelID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(communityIDCondition);
MiicColumn filePathColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <AccessoryInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath));
MiicColumnCollections columns = new MiicColumnCollections();
columns.Add(filePathColumn);
try
{
DataTable dt = dbService.GetInformations(columns, relation, condition, out message);
foreach (var dr in dt.AsEnumerable())
{
result.Add(new AccessoryInfo()
{
ID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.ID)].ToString(),
PublishID = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.PublishID)].ToString(),
FileName = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileName)].ToString(),
FilePath = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FilePath)].ToString(),
UploadTime = (DateTime?)dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, DateTime?>(o => o.UploadTime)],
FileType = dr[Config.Attribute.GetSqlColumnNameByPropertyName <AccessoryInfo, string>(o => o.FileType)].ToString()
});
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
DataTable IGroupInfo.GetDetailMemberInfoListByGroupID(string groupID)
{
Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(groupID), "参数groupID:不能为空");
string message = string.Empty;
DataTable result = new DataTable();
MiicCondition groupIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.GroupID),
groupID,
DbType.String,
MiicDBOperatorSetting.Equal);
MiicConditionSingle condition = new MiicConditionSingle(groupIDCondition);
MiicColumnCollections column = new MiicColumnCollections();
MiicColumn memberAll = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <GroupMember>());
column.Add(memberAll);
MiicColumn userUrl = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserUrl));
column.Add(userUrl);
MiicColumn userName = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName));
column.Add(userName);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <GroupMember>(),
Config.Attribute.GetSqlColumnNameByPropertyName <GroupMember, string>(o => o.MemberID),
Config.Attribute.GetSqlTableNameByClassName <Miic.Friends.User.SimpleUserView>(),
Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.InnerJoin);
try
{
result = dbService.GetInformations(column, relation, condition, out message);
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
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="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);
}
DataTable ILabelInfo.Search(NoPersonKeywordView keywordView, MiicPage page)
{
Contract.Requires <ArgumentNullException>(keywordView != null, "参数keywordView:不为空！");
DataTable result = new DataTable();
string message = string.Empty;
MiicConditionCollections condition = keywordView.visitor(this);
MiicRelation relation = new MiicRelation(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID),
Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.LabelID),
MiicDBOperatorSetting.Equal,
MiicDBRelationSetting.LeftJoin);
MiicColumnCollections columns = new MiicColumnCollections();
MiicColumn labelIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.ID));
columns.Add(labelIDColumn);
MiicColumn labelNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.LabelName));
columns.Add(labelNameColumn);
MiicColumn createTimeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, DateTime?>(o => o.CreateTime));
columns.Add(createTimeColumn);
MiicColumn createrIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterID));
columns.Add(createrIDColumn);
MiicColumn createrNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, string>(o => o.CreaterName));
columns.Add(createrNameColumn);
MiicColumn sortNoColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelInfo, int?>(o => o.SortNo));
columns.Add(sortNoColumn);
MiicColumn labelSearchPublishIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.PublishID));
columns.Add(labelSearchPublishIDColumn);
MiicColumn labelSearchUserIDColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserID));
columns.Add(labelSearchUserIDColumn);
MiicColumn labelSearchUserNameColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserName));
columns.Add(labelSearchUserNameColumn);
MiicColumn labelSearchUserTypeColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserType));
columns.Add(labelSearchUserTypeColumn);
MiicColumn labelSearchUserUrlColumn = new MiicColumn(Config.Attribute.GetSqlTableNameByClassName <LabelSearchInfo>(),
Config.Attribute.GetSqlColumnNameByPropertyName <LabelSearchInfo, string>(o => o.UserUrl));
columns.Add(labelSearchUserUrlColumn);
try
{
if (page != null)
{
List <MiicOrderBy> order = new List <MiicOrderBy>();
order.Add(new MiicOrderBy()
{
Desc = true,
PropertyName = Config.Attribute.GetSqlColumnNameByPropertyNameWithTable <LabelInfo, int?>(o => o.SortNo)
});
condition.order = order;
result = dbService.GetInformationsPage(columns, relation, condition, page, out message, MiicDBPageRowNumberSetting.DenseRank);
}
else
{
result = dbService.GetInformations(columns, relation, condition, out message);
}
}
catch (Exception ex)
{
Config.IlogicLogService.Write(new LogicLog()
{
AppName = Config.AppName,
ClassName = ClassName,
NamespaceName = NamespaceName,
MethodName = MethodBase.GetCurrentMethod().Name,
Message = ex.Message,
Oper = Config.Oper
});
}
return(result);
}
