public override List <ComBanner> GetPageList(SearchComBanner condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
Script.Select().ALL().From().Where();
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <ComBanner> lists = Script.GetList <ComBanner>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <NewsType> GetPageList(SearchNewsType condition, DevNet.Common.Pagination pagination)
{
Script.Select().ALL().From().Where();
if (!string.IsNullOrEmpty(condition.NewsTypeName))
{
Script.Like(NewsType.NewsTypeName_FieldName, condition.NewsTypeName);
}
if (condition.IsEnglish > 0)
{
Script.Where(NewsType.IsEnglish_FieldName, condition.IsEnglish);
}
Script.AddOrderBy().OrderBy(NewsType.ID_FieldName, DevNet.Common.ScriptQuery.SortEnum.ASC);
List <NewsType> lists = Script.GetList <NewsType>();
return(lists);
}
public override List <Messages> GetPageList(SearchMessages condition, DevNet.Common.Pagination pagination)
{
Script.Select().ALL().From().Where();
if (!string.IsNullOrEmpty(condition.MesTitle))
{
Script.Like(Messages.MesTitle_FieldName, condition.MesTitle);
}
Script.AddOrderBy().OrderBy(Messages.MesDate_FieldName, DevNet.Common.ScriptQuery.SortEnum.DESC);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <Messages> lists = Script.GetList <Messages>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <NewsDetail> GetPageList(SearchNewsDetail condition, DevNet.Common.Pagination pagination)
{
Script.Select().ALL().From().Where();
if (condition.NewsTypeID > 0)
{
Script.Where(NewsDetail.NewsTypeID_FieldName, condition.NewsTypeID);
}
if (condition.IsEnglish > 0)
{
Script.Where(NewsDetail.IsEnglish_FieldName, condition.IsEnglish);
}
Script.AddOrderBy().OrderBy(NewsDetail.AutoSort_FieldName, DevNet.Common.ScriptQuery.SortEnum.DESC).OrderBy(NewsDetail.ID_FieldName, DevNet.Common.ScriptQuery.SortEnum.DESC);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <NewsDetail> lists = Script.GetList <NewsDetail>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <DownLoad> GetPageList(SearchDownLoad condition, DevNet.Common.Pagination pagination)
{
Script.Select().ALL().From().Where();
if (!string.IsNullOrEmpty(condition.CpDLName))
{
Script.Where(DownLoad.DLName_FieldName, condition.CpDLName);
}
if (condition.IsEnglish > 0)
{
Script.Where(DownLoad.IsEnglish_FieldName, condition.IsEnglish);
}
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <DownLoad> lists = Script.GetList <DownLoad>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <NewsType> GetPageList(SearchNewsType condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
Script.Select().ALL().From().Where();
if (!string.IsNullOrEmpty(condition.NewsTypeName))
{
Script.Like(NewsType.NewsTypeName_FieldName, condition.NewsTypeName);
}
if (condition.IsEnglish > 0)
{
Script.Where(NewsType.IsEnglish_FieldName, condition.IsEnglish);
}
Script.AddOrderBy().OrderBy(sortFieldName, sortEnum);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <NewsType> lists = Script.GetList <NewsType>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <ProductType> GetPageList(SearchProductType condition, DevNet.Common.Pagination pagination)
{
Script.Select().ALL().From().Where();
if (!string.IsNullOrEmpty(condition.ProductTypeName))
{
Script.Like(ProductType.ID_FieldName, condition.ProductId);
}
if (condition.IsEnglish > 0)
{
Script.Where(ProductType.IsEnglish_FieldName, condition.IsEnglish);
}
;
Script.AddOrderBy().OrderBy(ProductType.AutoSort_FieldName, DevNet.Common.ScriptQuery.SortEnum.DESC).OrderBy(ProductType.ID_FieldName, DevNet.Common.ScriptQuery.SortEnum.ASC);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <ProductType> lists = Script.GetList <ProductType>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <JobDetail> GetPageList(SearchJobDetail condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
Script.Select().ALL().From().Where();
if (condition.CpJobTypeID > 0)
{
Script.Where(JobDetail.JobTypeID_FieldName, condition.CpJobTypeID);
}
if (condition.IsEnglish > 0)
{
Script.Where(JobDetail.IsEnglish_FieldName, condition.IsEnglish);
}
Script.AddOrderBy().OrderBy(sortFieldName, sortEnum);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <JobDetail> lists = Script.GetList <JobDetail>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <AdminUser> GetPageList(SearchAdminUser condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
Script.Select().ALL().From().Where();
if (!string.IsNullOrEmpty(condition.Account))
{
Script.Like(AdminUser.Account_FieldName, condition.Account);
}
if (!string.IsNullOrEmpty(condition.TrueName))
{
Script.Like(AdminUser.TrueName_FieldName, condition.TrueName);
}
Script.AddOrderBy().OrderBy(sortFieldName, sortEnum);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <AdminUser> lists = Script.GetList <AdminUser>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <CompanyInformationType> GetPageList(SearchCompanyInformationType condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override System.Data.DataTable GetPageTable(SearchSuccessStoriesType condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override System.Data.DataTable GetPageTable(SearchJobDetail condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override List <JobDetail> GetPageList(SearchJobDetail condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override List <CompanyInformationDetails> GetPageList(SearchCompanyInformationDetails condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
Script.Select().ALL().From().Where();
if (condition.CpInforType > 0)
{
Script.Where(CompanyInformationDetails.CompanyInformationTypeID_FieldName, condition.CpInforType);
}
if (condition.IsEnglish > 0)
{
Script.Where(CompanyInformationDetails.IsEnglish_FieldName, condition.IsEnglish);
}
Script.AddOrderBy().OrderBy(sortFieldName, sortEnum);
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
List <CompanyInformationDetails> lists = Script.GetList <CompanyInformationDetails>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <SuccessStories> GetPageList(SearchSuccessStories condition, DevNet.Common.Pagination pagination)
{
Script.Select().ALL().From().Where();
if (condition.SSType > 0)
{
Script.Where(SuccessStories.SSType_FieldName, condition.SSType);
}
if (condition.IsEnglish > 0)
{
Script.Where(SuccessStories.IsEnglish_FieldName, condition.IsEnglish);
}
Script.PageIndex = pagination.PageIndex;
Script.PageSize = pagination.PageSize;
Script.AddOrderBy().OrderBy(SuccessStories.AutoSort_FieldName, DevNet.Common.ScriptQuery.SortEnum.DESC).OrderBy(SuccessStories.ID_FieldName, DevNet.Common.ScriptQuery.SortEnum.DESC);
List <SuccessStories> lists = Script.GetList <SuccessStories>();
pagination.RecordCount = Script.RecordCount;
return(lists);
}
public override List <ProductPicture> GetPageList(SearchProductPicture condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override System.Data.DataTable GetPageTable(SearchCompanyInformationType condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
throw new System.NotImplementedException();
}
public override List <Contact> GetPageList(SearchContact condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override List <AdminUser> GetPageList(SearchAdminUser condition, DevNet.Common.Pagination pagination)
{
return(GetPageList(condition, pagination, AdminUser.AddDate_FieldName, DevNet.Common.ScriptQuery.SortEnum.ASC));
}
public override System.Data.DataTable GetPageTable(SearchCompanyInformationType condition, DevNet.Common.Pagination pagination)
{
throw new System.NotImplementedException();
}
public override List <ProductPicture> GetPageList(SearchProductPicture condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum)
{
throw new System.NotImplementedException();
}
