/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<JournalInfoEntity></returns>
public Pager<JournalInfoEntity> GetJournalInfoPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("JournalInfo","JournalID,JournalName,SiteUrl,ServiceStartDate,ServiceEndDate,Linkman,LinkTel,Fax,Email,Mobile,Address,ZipCode,AuthorizationCode,Status,Note,AddDate",query.Order,query.Where,query.CurrentPage,query.PageSize,out recordCount);
Pager<JournalInfoEntity> pager = new Pager<JournalInfoEntity>();
if(ds != null && ds.Tables.Count > 0)
{
pager.ItemList= MakeJournalInfoList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<AuthorInfoEntity></returns>
public Pager<AuthorInfoEntity> GetAuthorInfoPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("AuthorInfo", "AuthorID,JournalID,LoginName,Pwd,RealName,Mobile,LoginIP,LoginCount,LoginDate,Status,GroupID,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager<AuthorInfoEntity> pager = new Pager<AuthorInfoEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeAuthorInfoList(ds.Tables[0]);
foreach (AuthorInfoEntity item in pager.ItemList)
{
item.Pwd = "";
}
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<SysAccountInfoEntity></returns>
public Pager<SysAccountInfoEntity> GetSysAccountInfoPageList(CommonQuery query)
{
return SysAccountInfoBusiness.GetSysAccountInfoPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<PayNoticeEntity></returns>
public Pager<PayNoticeEntity> GetPayNoticePageList(CommonQuery query)
{
return PayNoticeBusProvider.GetPayNoticePageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<SiteConfigEntity></returns>
public Pager<SiteConfigEntity> GetSiteConfigPageList(CommonQuery query)
{
return SiteConfigDataAccess.Instance.GetSiteConfigPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<FinancePayDetailEntity></returns>
public Pager<FinancePayDetailEntity> GetFinancePayDetailPageList(CommonQuery query)
{
return FinancePayDetailDataAccess.Instance.GetFinancePayDetailPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<RoleInfoEntity></returns>
public Pager<RoleInfoEntity> GetRoleInfoPageList(CommonQuery query)
{
return RoleInfoBusProvider.GetRoleInfoPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<DictValueEntity></returns>
public Pager<DictValueEntity> GetDictValuePageList(CommonQuery query)
{
return DictValueBusProvider.GetDictValuePageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<FlowNodeConditionEntity></returns>
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(CommonQuery query)
{
return FlowNodeConditionBusProvider.GetFlowNodeConditionPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<FlowNodeConditionEntity></returns>
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("FlowNodeCondition","FlowConditionID,JournalID,OperationID,ConditionType,ConditionExp,AddDate",query.Order,query.Where,query.CurrentPage,query.PageSize,out recordCount);
Pager<FlowNodeConditionEntity> pager = new Pager<FlowNodeConditionEntity>();
if(ds != null && ds.Tables.Count > 0)
{
pager.ItemList= MakeFlowNodeConditionList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<MenuEntity></returns>
public Pager<MenuEntity> GetMenuPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("Menu", "MenuID,JournalID,PMenuID,MenuName,MenuUrl,IconUrl,SortID,MenuType,GroupID,Status,IsContentMenu,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager<MenuEntity> pager = new Pager<MenuEntity>();
if(ds != null && ds.Tables.Count > 0)
{
pager.ItemList= MakeMenuList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<FinanceContributeEntity></returns>
public Pager<FinanceContributeEntity> GetFinanceContributePageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("FinanceContribute", "PKID,JournalID,CID,FeeType,Amount,PayType,RemitBillNo,InUser,InComeDate,InvoiceNo,PostNo,SendDate,Note,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager<FinanceContributeEntity> pager = new Pager<FinanceContributeEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeFinanceContributeList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<FinanceContributeEntity></returns>
public Pager<FinanceContributeEntity> GetFinanceContributePageList(CommonQuery query)
{
return FinanceContributeBusProvider.GetFinanceContributePageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<AuthorInfoEntity></returns>
public Pager<AuthorInfoEntity> GetAuthorInfoPageList(CommonQuery query)
{
return AuthorInfoBusProvider.GetAuthorInfoPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<ApiServerInfoEntity></returns>
public Pager<ApiServerInfoEntity> GetApiServerInfoPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("ApiServerInfo","ApiServerID,SiteName,SiteUrl,Status,Note,AddDate",query.Order,query.Where,query.CurrentPage,query.PageSize,out recordCount);
Pager<ApiServerInfoEntity> pager = new Pager<ApiServerInfoEntity>();
if(ds != null && ds.Tables.Count > 0)
{
pager.ItemList= MakeApiServerInfoList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<FinanceContributeEntity></returns>
public Pager<FinanceContributeEntity> GetFinanceContributePageList(CommonQuery query)
{
return FinanceContributeDataAccess.Instance.GetFinanceContributePageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<MessageRecodeEntity></returns>
public Pager<MessageRecodeEntity> GetMessageRecodePageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("MessageRecode", "*", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager<MessageRecodeEntity> pager = new Pager<MessageRecodeEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeMessageRecodeList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<SiteChannelEntity></returns>
public Pager<SiteChannelEntity> GetSiteChannelPageList(CommonQuery query)
{
return SiteChannelBusProvider.GetSiteChannelPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<DictEntity></returns>
public Pager<DictEntity> GetDictPageList(CommonQuery query)
{
return DictDataAccess.Instance.GetDictPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<IssueDownLogEntity></returns>
public Pager<IssueDownLogEntity> GetIssueDownLogPageList(CommonQuery query)
{
return IssueDownLogBusProvider.GetIssueDownLogPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<GuestbookEntity></returns>
public Pager<GuestbookEntity> GetGuestbookPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("Guestbook","MessageID,JournalID,PMessageID,UserName,Email,Tel,Title,MessageContent,IP,AddDate",query.Order,query.Where,query.CurrentPage,query.PageSize,out recordCount);
Pager<GuestbookEntity> pager = new Pager<GuestbookEntity>();
if(ds != null && ds.Tables.Count > 0)
{
pager.ItemList= MakeGuestbookList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<GuestbookEntity></returns>
public Pager<GuestbookEntity> GetGuestbookPageList(CommonQuery query)
{
return GuestbookBusProvider.GetGuestbookPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<IssueDownLogEntity></returns>
public Pager<IssueDownLogEntity> GetIssueDownLogPageList(CommonQuery query)
{
return IssueDownLogDataAccess.Instance.GetIssueDownLogPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<FlowNodeConditionEntity></returns>
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(CommonQuery query)
{
return FlowNodeConditionDataAccess.Instance.GetFlowNodeConditionPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<FinancePayDetailEntity></returns>
public Pager<FinancePayDetailEntity> GetFinancePayDetailPageList(CommonQuery query)
{
return FinancePayDetailBusProvider.GetFinancePayDetailPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<SysAccountInfoEntity></returns>
public Pager<SysAccountInfoEntity> GetSysAccountInfoPageList(CommonQuery query)
{
return SysAccountInfoDataAccess.Instance.GetSysAccountInfoPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<ApiServerInfoEntity></returns>
public Pager<ApiServerInfoEntity> GetApiServerInfoPageList(CommonQuery query)
{
return ApiServerInfoBusProvider.GetApiServerInfoPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询实体对象</param>
/// <returns>Pager<SiteNoticeEntity></returns>
public Pager<SiteNoticeEntity> GetSiteNoticePageList(CommonQuery query)
{
return SiteNoticeBusProvider.GetSiteNoticePageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<ContactWayEntity></returns>
public Pager<ContactWayEntity> GetContactWayPageList(CommonQuery query)
{
return ContactWayDataAccess.Instance.GetContactWayPageList(query);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<AuthorDetailEntity></returns>
public Pager<AuthorDetailEntity> GetAuthorDetailPageList(CommonQuery query)
{
return AuthorDetailDataAccess.Instance.GetAuthorDetailPageList(query);
}