/// <summary>Gets REST url.</summary>
/// <param name="urlKey">Url key.</param>
/// <param name="addClientId">Denotes whether client identifier should be composed into final url.</param>
/// <param name="pagination">Pagination object.</param>
/// <param name="additionalUrlParams">Additional parameters.</param>
/// <returns>Final REST url.</returns>
public String GetRestUrl(String urlKey, Boolean addClientId, Pagination pagination, Dictionary<String, String> additionalUrlParams)
{
String url;
if (!addClientId)
{
url = "/v2.01" + urlKey;
}
else
{
url = "/v2.01/" + _root.Config.ClientId + urlKey;
}
bool paramsAdded = false;
if (pagination != null)
{
url += "?page=" + pagination.Page + "&per_page=" + pagination.ItemsPerPage;
paramsAdded = true;
}
if (additionalUrlParams != null)
{
foreach (string key in additionalUrlParams.Keys)
{
url += paramsAdded ? Constants.URI_QUERY_PARAMS_SEPARATOR : Constants.URI_QUERY_SEPARATOR;
url += key + "=" + Uri.EscapeDataString(additionalUrlParams[key]);
paramsAdded = true;
}
}
return url;
}
void BindPromoteSales()
{
int num2;
int promotiontype = 0;
if (int.TryParse(this.Page.Request.QueryString["promoteType"], out num2))
{
promotiontype = num2;
}
Pagination pagination = new Pagination();
pagination.PageIndex = this.pager.PageIndex;
pagination.PageSize = this.pager.PageSize;
int totalPromotes = 0;
DataTable table = CommentBrowser.GetPromotes(pagination, promotiontype, out totalPromotes);
table.Columns.Add("PromoteTypeName");
if ((table != null) && (table.Rows.Count > 0))
{
foreach (DataRow row in table.Rows)
{
row["PromoteTypeName"] = this.ConvertPromoteType((PromoteType) ((int) row["PromoteType"]));
}
this.rptPromoteSales.DataSource = table;
this.rptPromoteSales.DataBind();
}
this.pager.TotalRecords = totalPromotes;
}
protected void GridPaging()
{
try
{
int startRecordNumber = (CurPageNum - 1) * pageSize + 1;
int endRecordNumber = startRecordNumber + gvApplicationNotApproved.Rows.Count - 1;
if (gvApplicationNotApproved.Rows.Count == 0)
startRecordNumber = 0;
int totalPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(totalRows) / Convert.ToDecimal(pageSize)));
lblPagingLeft.Text = "Showing " + startRecordNumber + " to " + endRecordNumber + " of " + totalRows;
StringBuilder sb = new StringBuilder();
sb.Append(@"<div class='Pages'><div class='Paginator'>");
Pagination pagingstring = new Pagination();
pagingstring.CurPage = CurPageNum;
pagingstring.BaseUrl = Request.Url.GetLeftPart(UriPartial.Path).ToString();
pagingstring.TotalRows = totalRows;
pagingstring.PerPage = pageSize;
pagingstring.PrevLink = "< Prev";
pagingstring.NextLink = "Next >";
pagingstring.LastLink = "Last >";
pagingstring.FirstLink = "< First";
sb.Append(pagingstring.GetPageLinks());
sb.Append(@"</div></div><br clear='all' />");
ltrlPaging.Text = sb.ToString();
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "adminApplications.GridPaging", ex);
}
}
private void showData()
{
string ID = Request.QueryString["ID"];
int total = 0;
_Page = Request.QueryString["Page"] == null ? "1" : this.IsPostBack ? "1" : Request.QueryString["Page"];
_Limit = ddlPageSize.SelectedValue;
dt = DataAccess.getProjectLogo("-1", _Page, _Limit, ref total);
_Total = total.ToString();
int from, to;
from = _Total == "0" ? 0 : (1 + (Convert.ToInt32(_Page) - 1) * Convert.ToInt32(ddlPageSize.SelectedValue));
to = Convert.ToInt32(ddlPageSize.SelectedValue) * Convert.ToInt32(_Page) <= Convert.ToInt32(_Total) ? Convert.ToInt32(ddlPageSize.SelectedValue) * Convert.ToInt32(_Page) : Convert.ToInt32(_Total);
_Status = "<span class='actived_true'>Viewing " + from.ToString() + " to " + to.ToString() + " of " + _Total + "</span>";
Pagination pg = new Pagination();
pg.Limit = Convert.ToInt32(_Limit);
pg.PageNumber = Convert.ToInt32(_Page);
pg.Total = Convert.ToInt64(_Total);
pg.Page = "Pages";
pg.First = "|<";
pg.Next = ">";
pg.Previous = "<";
pg.Last = ">|";
pg.ItemShowNumber = 10;
pg.URL = "";//Session["PageOriginal"].ToString();
_Pagination = pg.getStringPagination();
//loadColFilter();
}
public void Test_Client_GetKycDocuments()
{
ListPaginated<KycDocumentDTO> result = null;
ListPaginated<KycDocumentDTO> result2 = null;
try
{
result = this.Api.Clients.GetKycDocuments(null, null);
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Pagination pagination = new Pagination(1, 2);
Sort sort = new Sort();
sort.AddField("CreationDate", SortDirection.asc);
result = this.Api.Clients.GetKycDocuments(pagination, null, sort);
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
sort = new Sort();
sort.AddField("CreationDate", SortDirection.desc);
result2 = this.Api.Clients.GetKycDocuments(pagination, null, sort);
Assert.IsNotNull(result2);
Assert.IsTrue(result2.Count > 0);
Assert.IsTrue(result[0].Id != result2[0].Id);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
private void showData()
{
string ID = Request.QueryString["Id"];
int total = 0;
_Page = Request.QueryString["Page"] == null ? "1" : this.IsPostBack ? "1" : Request.QueryString["Page"];
_Limit = "10";
projects = DataAccess.getProjects("-1", _Page, _Limit, ref total);
_Total = total.ToString();
int from, to;
from = _Total == "0" ? 0 : (1 + (Convert.ToInt32(_Page) - 1) * 10);
to = 10 * Convert.ToInt32(_Page) <= Convert.ToInt32(_Total) ? 10 * Convert.ToInt32(_Page) : Convert.ToInt32(_Total);
//_Status = "<span class='actived_true'>Hiển thị từ " + from.ToString() + " đến " + to.ToString() + " trong tổng số " + _Total + " bản ghi</span>";
Pagination pg = new Pagination();
pg.Limit = Convert.ToInt32(_Limit);
pg.PageNumber = Convert.ToInt32(_Page);
pg.Total = Convert.ToInt64(_Total);
pg.Page = "";
pg.First = "|<";
pg.Next = ">";
pg.Previous = "<";
pg.Last = ">|";
pg.ItemShowNumber = 10;
pg.URL = "";//Session["PageOriginal"].ToString();
_Pagination = pg.getStringPagination();
//loadColFilter();
}
public void Test_Events_GetAll_SortByCreationDate()
{
try
{
PayInCardWebDTO payIn1 = GetJohnsNewPayInCardWeb();
PayInCardWebDTO payIn2 = GetJohnsNewPayInCardWeb();
FilterEvents eventsFilter = new FilterEvents();
eventsFilter.BeforeDate = payIn2.CreationDate;
eventsFilter.AfterDate = payIn1.CreationDate;
eventsFilter.Type = EventType.PAYIN_NORMAL_CREATED;
Sort sort = new Sort();
sort.AddField("Date", SortDirection.desc);
Pagination pagination = new Pagination();
ListPaginated<EventDTO> result = this.Api.Events.GetAll(pagination, eventsFilter, sort);
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 1);
Assert.IsTrue(result[0].Date > result[1].Date);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
//
// GET: /Badminton/Model/
public ActionResult Index(Pagination page)
{
IList<Model> list = _daoFactory.ModelDao().GetAll();
page.TotalRows = list.Count;
ViewData["nav"] = page;
return View(list);
}
protected void GridPaging()
{
try
{
int totalPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(totalRows) / Convert.ToDecimal(pageSize)));
//lblPagingLeft.Text = "Showing " + CurPageNum + " to " + totalPages + " of " + totalRows + " entries";
StringBuilder sb = new StringBuilder();
sb.Append(@"<div class='Pages'><div class='Paginator'>");
Pagination pagingstring = new Pagination();
pagingstring.CurPage = CurPageNum;
pagingstring.BaseUrl = Request.Url.GetLeftPart(UriPartial.Path).ToString();
pagingstring.TotalRows = totalRows;
pagingstring.PerPage = pageSize;
pagingstring.PrevLink = "< Prev";
pagingstring.NextLink = "Next >";
pagingstring.LastLink = "Last >";
pagingstring.FirstLink = "< First";
sb.Append(pagingstring.GetPageLinks());
sb.Append(@"</div></div><br clear='all' />");
//ltrlPaging.Text = sb.ToString();
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "adminStakeholders.GridPaging", ex);
}
}
public ActionResult ProductsPartial(string categoryID = null, bool? fromIndexPage = null, int pageNumber = 1)
{
using (var proxy = new ServiceProxy<IProductService>())
{
var numberOfProductsPerPage = ByteartRetailConfigurationReader.Instance.ProductsPerPage;
var pagination = new Pagination { PageSize = numberOfProductsPerPage, PageNumber = pageNumber };
ProductDataObjectListWithPagination productsWithPagination =
string.IsNullOrEmpty(categoryID) ?
proxy.Channel.GetProductsWithPagination(pagination) :
proxy.Channel.GetProductsForCategoryWithPagination(new Guid(categoryID), pagination);
if (fromIndexPage != null &&
!fromIndexPage.Value)
{
if (string.IsNullOrEmpty(categoryID))
ViewBag.CategoryName = "所有商品";
else
{
var category = proxy.Channel.GetCategoryByID(new Guid(categoryID), QuerySpec.Empty);
ViewBag.CategoryName = category.Name;
}
}
else
ViewBag.CategoryName = null;
ViewBag.CategoryID = categoryID;
ViewBag.FromIndexPage = fromIndexPage;
if (fromIndexPage == null || fromIndexPage.Value)
ViewBag.Action = "Index";
else
ViewBag.Action = "Category";
ViewBag.IsFirstPage = productsWithPagination.Pagination.PageNumber == 1;
ViewBag.IsLastPage = productsWithPagination.Pagination.PageNumber == productsWithPagination.Pagination.TotalPages;
return PartialView(productsWithPagination);
}
}
public ActionResult ProductsPartial(string categoryId = null, bool? fromIndexPage = null, int pageNumber = 1)
{
using (var client = new HttpClient())
{
var numberOfProductsPerPage = int.Parse(ConfigurationManager.AppSettings["productsPerPage"]);
var pagination = new Pagination { PageSize = numberOfProductsPerPage, PageNumber = pageNumber };
ProductDtoWithPagination productsDtoWithPagination = null;
//productsDtoWithPagination = string.IsNullOrEmpty((categoryId)) ?
// client.GetAsync("").Result:
// client.GetAsync("").Result;
if (string.IsNullOrEmpty(categoryId))
ViewBag.CategoryName = "所有商品";
else
{
var category = client.GetAsync("").Result;
//ViewBag.CategoryName = category.Name;
}
ViewBag.CategoryId = categoryId;
ViewBag.FromIndexPage = fromIndexPage;
if (fromIndexPage == null || fromIndexPage.Value)
ViewBag.Action = "Index";
else
ViewBag.Action = "Category";
ViewBag.IsFirstPage = productsDtoWithPagination.Pagination.PageNumber == 1;
ViewBag.IsLastPage = productsDtoWithPagination.Pagination.PageNumber == productsDtoWithPagination.Pagination.TotalPages;
return PartialView(productsDtoWithPagination);
}
}
public void ExpectedValueForLowerboundWithEvenVariance()
{
Pagination p = new Pagination(100, 5, 10, 10);
//5 - 4
Assert.AreEqual(1, p.Lowerbound);
}
public void ExpectedValueForLowerboundWithOddVariance()
{
Pagination p = new Pagination(100, 5, 10, 7);
//5 - 3
Assert.AreEqual(2, p.Lowerbound);
}
private Paginator CreatePaginator(int page, int perPage, int pages, string baseUrl, string urlFormat, IEnumerable<DocumentFile> documents)
{
// It is important that this query is not executed here (aka: do not add ToList() or ToArray()). This
// query should be executed by the rendering engine so the returned documents are rendered first.
var pagedDocuments = documents.Skip((page - 1) * perPage).Take(perPage);
var pagination = new Pagination();
if (pages > 1 && !String.IsNullOrEmpty(urlFormat))
{
pagination.Page = page;
pagination.PerPage = perPage;
pagination.TotalPage = pages;
pagination.NextPageUrl = page < pages ? this.UrlForPage(page + 1, baseUrl, urlFormat) : null;
pagination.PreviousPageUrl = page > 1 ? this.UrlForPage(page - 1, baseUrl, urlFormat) : null;
var start = Math.Max(1, page - 3);
var end = Math.Min(pages, start + 6);
start = Math.Max(start, end - 6);
pagination.Pages = this.CreatePages(page, start, end, baseUrl, urlFormat).ToList();
}
return new Paginator(pagedDocuments, pagination);
}
public IPagination<Person> Get([FromUri] PagingCriteria pagingCriteria, [FromUri] Person personFilter, [FromUri] bool OrderBy, [FromUri] string OrderOn)
{
int totalRecords = 0;
Entities.OrderBy order = OrderBy ? Entities.OrderBy.Ascending : Entities.OrderBy.Descending;
var orderBy = new PersonOrderBy
{
Id = OrderOn == "Id" ? order : Entities.OrderBy.None,
FirstName = OrderOn == "FirstName" ? order : Entities.OrderBy.None,
LastName = OrderOn == "LastName" ? order : Entities.OrderBy.None,
Age = OrderOn == "Age" ? order : Entities.OrderBy.None,
};
var dataResult = _personRepository.GetByPaging(pagingCriteria, personFilter, orderBy, out totalRecords);
IPagination<Person> result = new Pagination<Person>
{
Records = dataResult.ToList(),
TotalItems = totalRecords,
PageSize = pagingCriteria.PageSize,
Page = pagingCriteria.Page
};
return result;
}
public int page { get; set; } // used to keep track of what page the list has loaded up to
public ProductList()
{
results = new ObservableCollection<Listing>();
@params = new Page_Parameters();
pagination = new Pagination();
page = 1;
}
public void ExpectedValueForHasPreviousPage()
{
Pagination p = new Pagination(2, 2, 1);
Assert.IsTrue(p.HasPreviousPage);
p = new Pagination(2, 1, 1);
Assert.IsTrue(!p.HasPreviousPage);
}
public ProductList(string Type)
{
listType = Type;
page = 1;
results = new ObservableCollection<Listing>();
@params = new Page_Parameters();
pagination = new Pagination();
}
public ActionResult Index(int page=1)
{
if (!this._nhanvien_permission.Contains("donhang_view"))
{
return _fail_permission("donhang_view");
}
DonHangController ctr=new DonHangController();
//
Boolean timkiem_ngay_from;
Boolean timkiem_ngay_to;
DateTime ngay_from = TextLibrary.ToDateTime(timkiem_donhang["ngay_from"], out timkiem_ngay_from);
DateTime ngay_to = TextLibrary.ToDateTime(timkiem_donhang["ngay_to"], out timkiem_ngay_to);
Boolean timkiem_ngay = timkiem_ngay_from && timkiem_ngay_to;
//Pagination
Pagination pg = new Pagination();
int max_item_per_page = TextLibrary.ToInt(this.timkiem_donhang["max_item_per_page"]);//get from setting
pg.set_current_page(page);
pg.set_max_item_per_page(max_item_per_page);
pg.set_total_item(
ctr.timkiem_count(
timkiem_donhang["id"],
timkiem_donhang["khachhang_ten"],
TextLibrary.ToInt(timkiem_donhang["tongtien_from"]),
TextLibrary.ToInt(timkiem_donhang["tongtien_to"]),
timkiem_ngay,
ngay_from,
ngay_to,
timkiem_donhang["thanhtoan_tructuyen"],
timkiem_donhang["trangthai"],
timkiem_donhang["active"]
)
);
pg.update();
ViewBag.pagination = pg;
ViewBag.DonHang_List = ctr.timkiem(
timkiem_donhang["id"],
timkiem_donhang["khachhang_ten"],
TextLibrary.ToInt(timkiem_donhang["tongtien_from"]),
TextLibrary.ToInt(timkiem_donhang["tongtien_to"]),
timkiem_ngay,
ngay_from,
ngay_to,
timkiem_donhang["thanhtoan_tructuyen"],
timkiem_donhang["trangthai"],
timkiem_donhang["active"],
timkiem_donhang["order_by"],
TextLibrary.ToBoolean(timkiem_donhang["order_desc"])
,pg.start_point,pg.max_item_per_page
);
ViewBag.timkiem_donhang = timkiem_donhang;
//pagination
this._set_activetab(new String[] { "QuanLyDonHang","DonHang_"+timkiem_donhang["trangthai"] });
return View();
}
/// <summary>
///
/// </summary>
/// <param name="posts"></param>
/// <param name="pagination"></param>
/// <returns></returns>
public BlogPostWrapper InitBlogPostWrapper(IEnumerable<BlogPostDTO> posts, Pagination pagination)
{
var result = new BlogPostWrapper
{
BlogPosts = posts,
Pagination = pagination
};
return result;
}
public ActionResult Index()
{
var model = new DashboardViewModel();
int records;
var pagination = new Pagination();
model.LatestArticles = adminService.GetArticlesByPage(pagination, totalRecords: out records).Take(5);
model.LatestUsers = adminService.GetUsersByPage(pagination, totalRecords: out records).Take(5);
return View("Dashboard", model);
}
private void BindSuppliers()
{
Pagination page = new Pagination();
page.PageIndex = pager.PageIndex;
page.PageSize = hrefPageSize.SelectedSize;
DbQueryResult suppliers = ProductLineHelper.GetSuppliers(page);
grdSuppliers.DataSource = suppliers.Data;
grdSuppliers.DataBind();
pager1.TotalRecords = pager.TotalRecords = suppliers.TotalRecords;
}
void BindData()
{
Pagination page = new Pagination();
page.PageIndex = this.pager.PageIndex;
page.PageSize = page.PageSize;
DbQueryResult productConsultations = ProductBrowser.GetProductConsultations(page, this.productId);
this.rptRecords.DataSource = productConsultations.Data;
this.rptRecords.DataBind();
this.pager.TotalRecords = productConsultations.TotalRecords;
}
private void BindCoupons()
{
Pagination page = new Pagination();
page.PageSize = pageSize;
page.PageIndex = pageIndex;
DbQueryResult newCoupons = SubsiteCouponHelper.GetNewCoupons(page);
grdCoupons.DataSource = newCoupons.Data;
grdCoupons.DataBind();
pager.TotalRecords = newCoupons.TotalRecords;
}
protected override void Initialize()
{
pagination = new Pagination(jQuery.Select("#admin-collection-users-pagination"), ChangePage, GetTotalPage, "right");
jQuery.Select("#admin-collection-users-add-submit").Click(SubmitAddForm);
jQuery.Select("#admin-collection-users-form").Submit(SubmitAddForm);
jQuery.Select("#admin-collection-users-delete-btn").Click(DeleteButtonClicked);
jQuery.Select("#admin-collection-users-allow-btn").Click(AllowButtonClicked);
jQuery.Select("#admin-collection-users-deny-btn").Click(DenyButtonClicked);
Utility.FixDropdownTouch(jQuery.Select("#admin-collection-users-action-dropdown"));
}
private MangasModule(Action loginRefreshCallback)
: base("mangas-module", loginRefreshCallback)
{
items = new MangaListItemJson[] { };
currentPage = 1;
pagination = new Pagination(jQuery.Select(".mangas-pagination", attachedObject), ChangePage, GetTotalPage, "centered");
jQuery.Document.Keyup(OnKeyUp);
jQuery.Document.Click(DocumentClick);
Refresh();
}
public ActionResult Index(ListViewModel<Article> model)
{
if (model == null)
model = new ListViewModel<Article>();
int totalRecords = 0;
var pagination = new Pagination(model.PageNumber, model.PageSize, model.SortColumn, model.SortDirection);
model.Rows = articleService.GetArticlesByPage(pagination, out totalRecords);
model.TotalRecords = totalRecords;
return View(model);
}
public List<Cases> LoadCases(Pagination pagination, CaseType caseType)
{
var cases = CasesData.LoadCases(pagination, caseType);
LoadCaseItems(cases);
if (cases != null && cases.Count > 0)
{
var items = new List<CaseItem>();
cases.ForEach(c => { if (c.CaseItems != null)items.AddRange(c.CaseItems); });
LoadCaseItemAttachment(items);
}
return cases ?? new List<Cases>(0);
}
private void BindPrint()
{
Pagination pagination2 = new Pagination();
pagination2.PageIndex = pager.PageIndex;
pagination2.PageSize = pager.PageSize;
Pagination query = pagination2;
DbQueryResult printTasks = SalesHelper.GetPrintTasks(query);
grdTasks.DataSource = printTasks.Data;
grdTasks.DataBind();
pager.TotalRecords = printTasks.TotalRecords;
pager1.TotalRecords = printTasks.TotalRecords;
}
private void BindRelatedProducts()
{
Pagination page = new Pagination();
page.PageSize = 10;
page.PageIndex = pagerSubject.PageIndex;
page.SortOrder = SortAction.Desc;
page.SortBy = "DisplaySequence";
DbQueryResult relatedArticsProducts = ArticleHelper.GetRelatedArticsProducts(page, articId);
dlstSearchProducts.DataSource = relatedArticsProducts.Data;
dlstSearchProducts.DataBind();
pagerSubject.TotalRecords = relatedArticsProducts.TotalRecords;
}
protected async Task <ListPaginated <T> > GetList <T>(MethodKey methodKey, Pagination pagination, string entityId, Sort sort, Dictionary <String, String> additionalUrlParams)
where T : EntityBase, new()
{
return(await this.GetList <T>(methodKey, pagination, entityId, null, sort, additionalUrlParams));
}
/// <summary>Gets the collection of Dto instances from API.</summary>
/// <typeparam name="T">Type on behalf of which the request is being called.</typeparam>
/// <param name="methodKey">Relevant method key.</param>
/// <param name="pagination">Pagination object.</param>
/// <returns>Collection of Dto instances returned from API.</returns>
protected async Task <ListPaginated <T> > GetList <T>(MethodKey methodKey, Pagination pagination)
where T : EntityBase, new()
{
return(await GetList <T>(methodKey, pagination, sort : null));
}
/// <summary>
/// 分页查询DataTable
/// </summary>
/// <param name="strWhere">条件</param>
/// <param name="strOrderByFileds">排序字段，如name asc,age desc</param>
/// <param name="paging"></param>
/// <returns></returns>
public DataTable QueryEx(string strWhere, string strOrderByFileds, ref Pagination paging)
{
return(BaseDal.QueryEx(strWhere, strOrderByFileds, ref paging));
}
/// <summary>
/// 数据库表数据列表
/// </summary>
/// <param name="dataBaseLinkId">库连接</param>
/// <param name="tableName">表明</param>
/// <param name="switchWhere">条件</param>
/// <param name="logic">逻辑</param>
/// <param name="keyword">关键字</param>
/// <param name="pagination">分页参数</param>
/// <returns></returns>
public DataTable GetTableDataList(string dataBaseLinkId, string tableName, string switchWhere, string logic, string keyword, Pagination pagination)
{
return(service.GetTableDataList(dataBaseLinkId, tableName, switchWhere, logic, keyword, pagination));
}
/// <summary>
/// 公告列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <CommentEntity> GetPageList(Pagination pagination, string queryJson)
{
return(service.GetPageList(pagination, queryJson));
}
/// <summary>
/// 定性指标等级报告列表
/// </summary>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <BpeRA002Entity> GetQualitativeReportList(Pagination pagination, string queryJson)
{
return(bpeRA002Service.GetList(pagination, queryJson));
}
/// <summary>
/// 综合评价等级报告列表
/// </summary>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <BpeRA003Entity> GetComprehensiveReportList(Pagination pagination, string queryJson)
{
return(bpeRA003Service.GetList(pagination, queryJson));
}
public IEnumerable <SchemeWeightModel> GetSchemeWeighList(Pagination pagination, string queryJson)
{
return(bpeRA001Service.GetSchemeWeighList(pagination, queryJson));
}
/// <summary>
/// 获取高风险作业列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns>返回分页列表</returns>
public DataTable GetPageDataTable(Pagination pagination, string queryJson)
{
return(service.GetPageDataTable(pagination, queryJson));
}
/// <summary>
/// 执行返回数据列表
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="paging"></param>
/// <returns></returns>
public List <TEntity> ExecuteList(string sql, ref Pagination paging)
{
return(BaseDal.ExecuteList(sql, ref paging));
}
/// <summary>
/// 执行返回数据集
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="cmdType">命令类型</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public DataTable ExecuteDataTable(string sql, ref Pagination paging, params SugarParameter[] parameters)
{
return(BaseDal.ExecuteDataTable(sql, ref paging, parameters));
}
/// <summary>
/// 获取数据 app段展示
/// </summary>
/// <param name="pagination"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public DataTable GetEntity(Pagination pagination)
{
return(service.GetTable(pagination));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _sto_UnitBusiness.GetDataList(condition, keyword, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 分页查询数据DataTable
/// </summary>
/// <param name="where">数据</param>
/// <param name="orderBy">排序</param>
/// <param name="paging">分页信息</param>
/// <returns></returns>
public DataTable QueryPageEx(ref Pagination paging, string where = "", string orderBy = "")
{
return(BaseDal.QueryPageEx(ref paging, where, orderBy));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns>返回分页列表</returns>
public IEnumerable <ToolsEntity> GetPageList(Pagination pagination, string queryJson)
{
return(this.BaseRepository().FindList(pagination));
}
/// <summary>
/// 分页查询数据DataTable
/// </summary>
/// <param name="whereExpression">查询条件</param>
/// <param name="paging"></param>
/// <param name="strOrderByFileds">排序字段，如name asc,age desc</param>
/// <returns></returns>
public DataTable QueryPageEx(Expression <Func <TEntity, bool> > whereExpression, ref Pagination paging, string strOrderByFileds = null)
{
return(BaseDal.QueryPageEx(whereExpression, ref paging, strOrderByFileds));
}
/// <summary>
/// 获取页面显示列表数据
/// </summary>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <Mes_BackSupplyHeadEntity> GetPageList(Pagination pagination, string queryJson)
{
try
{
var strSql = new StringBuilder();
strSql.Append("SELECT ");
strSql.Append(@"
distinct
t.ID,
t.B_BackSupplyNo,
t.B_StockCode,
t.B_StockName,
t.B_OrderDate,
t.B_Status,
dbo.GetUserNameById(t.B_CreateBy) B_CreateBy,
t.B_CreateDate,
dbo.GetUserNameById(t.B_UpdateBy) B_UpdateBy,
t.B_UpdateDate,
dbo.GetUserNameById(t.B_DeleteBy) B_DeleteBy,
t.B_DeleteDate,
dbo.GetUserNameById(t.B_UploadBy) B_UploadBy,
t.B_UploadDate,
t.B_Remark
");
strSql.Append(" FROM Mes_BackSupplyHead t left join Mes_BackSupplyDetail s on(t.B_BackSupplyNo=s.B_BackSupplyNo)");
strSql.Append(" WHERE 1=1 and t.B_Status=3");
var queryParam = queryJson.ToJObject();
// 虚拟参数
var dp = new DynamicParameters(new { });
if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty())
{
dp.Add("startTime", queryParam["StartTime"].ToDate(), DbType.DateTime);
dp.Add("endTime", queryParam["EndTime"].ToDate(), DbType.DateTime);
strSql.Append(" AND ( t.B_CreateDate >= @startTime AND t.B_CreateDate <= @endTime ) ");
}
if (!queryParam["OrderDate_S"].IsEmpty() && !queryParam["OrderDate_E"].IsEmpty())//新增单据时间
{
dp.Add("OrderDate_S", queryParam["OrderDate_S"].ToDate(), DbType.DateTime);
dp.Add("OrderDate_E", queryParam["OrderDate_E"].ToDate(), DbType.DateTime);
strSql.Append(" AND ( t.B_OrderDate >= @OrderDate_S AND t.B_OrderDate <= @OrderDate_E ) ");
}
if (!queryParam["B_OrderDate"].IsEmpty())
{
dp.Add("B_OrderDate", "%" + queryParam["B_OrderDate"].ToString() + "%", DbType.String);
strSql.Append(" AND t.B_CreateDate Like @B_CreateDate ");
}
if (!queryParam["M_GoodsName"].IsEmpty())
{
dp.Add("M_GoodsName", "%" + queryParam["M_GoodsName"].ToString() + "%", DbType.String);
strSql.Append(" AND s.B_GoodsName Like @M_GoodsName ");
}
if (!queryParam["B_BackSupplyNo"].IsEmpty())
{
dp.Add("B_BackSupplyNo", "%" + queryParam["B_BackSupplyNo"].ToString() + "%", DbType.String);
strSql.Append(" AND t.B_BackSupplyNo Like @B_BackSupplyNo ");
}
if (!queryParam["B_StockCode"].IsEmpty())
{
dp.Add("B_StockCode", "%" + queryParam["B_StockCode"].ToString() + "%", DbType.String);
strSql.Append(" AND t.B_StockCode Like @B_StockCode ");
}
if (!queryParam["B_StockName"].IsEmpty())
{
dp.Add("B_StockName", "%" + queryParam["B_StockName"].ToString() + "%", DbType.String);
strSql.Append(" AND t.B_StockName Like @B_StockName ");
}
return(this.BaseRepository().FindList <Mes_BackSupplyHeadEntity>(strSql.ToString(), dp, pagination));
}
catch (Exception ex)
{
if (ex is ExceptionEx)
{
throw;
}
else
{
throw ExceptionEx.ThrowServiceException(ex);
}
}
}
/// <summary>
/// 分页查询数据DataTable
/// </summary>
/// <param name="whereExpression">查询条件</param>
/// <param name="paging">分页信息</param>
/// <returns></returns>
public DataTable QueryPageEx(Expression <Func <TEntity, bool> > whereExpression, ref Pagination paging)
{
return(BaseDal.QueryPageEx(whereExpression, ref paging));
}
/// <summary>
/// 分页查询DataTable
/// </summary>
/// <param name="strWhere">条件</param>
/// <param name="strOrderByFileds">排序字段，如name asc,age desc</param>
/// <param name="paging">分页信息</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public DataTable QueryEx(string strWhere, string strOrderByFileds, ref Pagination paging, params SugarParameter[] parameters)
{
return(BaseDal.QueryEx(strWhere, strOrderByFileds, ref paging, parameters));
}
public ActionResult GetGoodsGrantListExt(Pagination pagination, string grantType, string storeID = "1001")
{
var goodsList = GoodsBLL.instance.GetGoodsGrantListExt(int.Parse(storeID), grantType);
return(Content(GetPagingJson(goodsList, pagination)));
}
/// <summary>
/// 分页查询DataTable
/// </summary>
/// <param name="paging">分页信息</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public DataTable QueryEx(ref Pagination paging, params SugarParameter[] parameters)
{
return(BaseDal.QueryEx(ref paging, parameters));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _tagBusiness.GetDataList(condition, keyword, pagination).Select(m => new { m.Id, m.TagName }).ToList();;
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
public IEnumerable <BpcSM001Entity> GetPageList(Pagination pagination, string queryJson)
{
return(_bpcSm001Service.GetPageList(pagination, queryJson));
}
public async Task <IEnumerable <Order> > GetListAsync(Expression <Func <Order, bool> > pWhereClause = null, Expression <Func <Order, object> > pInclude = null, Pagination pPagination = null)
{
return(await _orderRepository.GetListAsync(pWhereClause, pInclude, pPagination));
}
/// <summary>Gets the collection of Dto instances from API.</summary>
/// <typeparam name="T">Type on behalf of which the request is being called.</typeparam>
/// <param name="methodKey">Relevant method key.</param>
/// <param name="pagination">Pagination object.</param>
/// <param name="entityId">Entity identifier.</param>
/// <param name="sort">Sort.</param>
/// <returns>Collection of Dto instances returned from API.</returns>
protected async Task <ListPaginated <T> > GetList <T>(MethodKey methodKey, Pagination pagination, string entityId, Sort sort = null)
where T : EntityBase, new()
{
return(await GetList <T>(methodKey, pagination, entityId, null, sort, null));
}
public IEnumerable <Order> GetList(Expression <Func <Order, bool> > pWhereClause = null, Expression <Func <Order, object> > pInclude = null, Pagination pPagination = null)
{
return(this._orderRepository.GetList(pWhereClause, pInclude, pPagination));
}
/// <summary>Gets transactions for the wallet.</summary>
/// <param name="walletId">Wallet identifier.</param>
/// <param name="pagination">Pagination.</param>
/// <param name="sort">Sort.</param>
/// <returns>Transactions for wallet returned from API.</returns>
public async Task <ListPaginated <TransactionDTO> > GetTransactions(String walletId, Pagination pagination, Sort sort = null)
{
return(await GetTransactions(walletId, pagination, new FilterTransactions(), sort));
}
/// <summary>
/// 执行返回数据集
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="paging"></param>
/// <returns></returns>
public DataTable ExecuteDataTable(string sql, ref Pagination paging)
{
return(BaseDal.ExecuteDataTable(sql, ref paging));
}
/// <summary>
/// 执行返回数据列表
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="paging">命令类型</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public List <TEntity> ExecuteList(string sql, ref Pagination paging, params SugarParameter[] parameters)
{
return(BaseDal.ExecuteList(sql, ref paging, parameters));
}
/// <summary>
/// 获取流程列表分页数据
/// </summary>
/// <param name="pagination">分页参数</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
return(infoserver.GetPageList(pagination, queryJson));
}
