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(); }