/// <summary> /// Search result by conditions and get the current page. /// </summary> public List <OrderSearchResultBE> SearchByConditions() { int rowConut, pageCount, pageIndex, pageSize; pageIndex = View.CurrentPageIndex; pageSize = View.PageSize; OrderSearchParameterBE orderSearchParameterBE = new OrderSearchParameterBE() { CustomerName = View.CustomerName, StartDate = View.StartDate, EndDate = View.EndDate, ProductName = View.ProductName, SortExpression = View.SortExpression, SortDirection = View.SortDirection, PageStart = pageSize * pageIndex + 1, PageEnd = pageSize * (pageIndex + 1) }; List <OrderSearchResultBE> OrderSearchResultList = _controller.SearchByConditions(orderSearchParameterBE, out rowConut); pageCount = (int)Math.Ceiling((double)rowConut / (double)View.PageSize); View.TotalPageCount = pageCount; List <string> pageList = new List <string>(); pageList.Add("--"); for (int i = 1; i <= pageCount; i++) { pageList.Add(i.ToString()); } View.PageList = pageList; return(OrderSearchResultList); }
/// <summary> /// Search order information according to conditions and return an OrderSearchResultBE type list. /// </summary> /// <param name="customerName"></param> /// <param name="oper"></param> /// <param name="orderDate"></param> /// <param name="productName"></param> /// <returns></returns> public List <OrderSearchResultBE> SearchByConditions(OrderSearchParameterBE orderSearchParameterBE, out int rowCount) { OrderSearchManager orderSearchManager = new OrderSearchManager(); List <OrderSearchResultBE> searchResultBEList = new List <OrderSearchResultBE>(); searchResultBEList = orderSearchManager.GetOrderSearchResults(orderSearchParameterBE.CustomerName, orderSearchParameterBE.StartDate, orderSearchParameterBE.EndDate, orderSearchParameterBE.ProductName, orderSearchParameterBE.SortExpression, orderSearchParameterBE.SortDirection, orderSearchParameterBE.PageStart, orderSearchParameterBE.PageEnd, out rowCount); return(searchResultBEList); }
/// <summary> /// Get order details search result by conditions. --Lily /// </summary> /// <param name="orderSearchParameterBE"></param> /// <param name="rowConut">An output parameter, return the rowcount of search results.</param> /// <returns></returns> public List <OrderSearchResultBE> SearchByConditions(OrderSearchParameterBE orderSearchParameterBE, out int rowConut) { SearchByConditionsRequest request = new SearchByConditionsRequest() { OrderSearchConditions = orderSearchParameterBE }; SearchByConditionsResponse response = MyChannelFactory.CreateChannel().SearchByConditions(request); rowConut = response.RowCount; if (response != null) { if (response.IsFailed == true) { throw (new Exception(response.Message)); } } return(response.OrderSearchResultBEList); }
/// <summary> /// Get order details search result by conditions. --Lily /// </summary> /// <param name="orderSearchParameterBE"></param> /// <param name="rowConut">An output parameter, return the rowcount of search results.</param> /// <returns></returns> public List <OrderSearchResultBE> SearchByConditions(OrderSearchParameterBE orderSearchParameterBE, out int rowConut) { SearchByConditionsRequest request = new SearchByConditionsRequest() { OrderSearchConditions = orderSearchParameterBE }; SearchByConditionsResponse response = MyChannelFactory.CreateChannel().SearchByConditions(request); rowConut = response.RowCount; if (response.IsFailed == true) { ILog log = log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); log.Error("error", new Exception(response.Message)); log.Fatal("fatal", new Exception(response.Message)); throw (new Exception(response.Message)); } return(response.OrderSearchResultBEList); }
/// <summary> /// Call the SearchByConditions(...) method from BBLService, get the data and bind them to gridview. /// </summary> /// <param name="sortExpression"></param> /// <param name="sortDirection"></param> /// <param name="pageIndex"></param> public void QueryDB(string sortExpression, string sortDirection, int pageIndex) { string customerName, productName, startDate, endDate; int rowCount, pageStart, pageEnd, pageSize, pageCount; customerName = CustomerName.Text; productName = ProductName.Text; startDate = StartDate.Text; endDate = EndDate.Text; pageSize = SearchResult.PageSize; ViewState["pageSize"] = pageSize; pageStart = pageSize * pageIndex + 1; pageEnd = pageSize * (pageIndex + 1); Proxy searchproxy = new Proxy(); OrderSearchParameterBE orderSearchParameterBE = new OrderSearchParameterBE() { CustomerName = customerName, StartDate = startDate, EndDate = endDate, ProductName = productName, SortExpression = sortExpression, SortDirection = sortDirection, PageStart = pageStart, PageEnd = pageEnd, }; List <OrderSearchResultBE> orderSearchResultBEList = searchproxy.SearchByConditions(orderSearchParameterBE, out rowCount); pageCount = (int)Math.Ceiling((double)rowCount / (double)pageSize); ViewState["pageCount"] = pageCount; SearchResult.DataSource = orderSearchResultBEList; SearchResult.DataBind(); ComponentShow(true); lbCurrentPage.Text = (pageIndex + 1).ToString(); }
// <summary> /// Get order details and product details by conditions. --Lily /// </summary> /// <param name="orderSearchParameterBE"></param> /// <param name="rowConut">An output parameter, return the rowcount of search results.</param> /// <returns></returns> public List <OrderSearchResultBE> SearchByConditions(OrderSearchParameterBE orderSearchParameterBE, out int rowConut) { Proxy proxy = new Proxy(); return(proxy.SearchByConditions(orderSearchParameterBE, out rowConut)); }
/// <summary> /// Get order details and product details by conditions. --Lily /// </summary> /// <param name="orderSearchParameterBE"></param> /// <param name="rowConut">An output parameter, return the rowcount of search results.</param> /// <returns></returns> public virtual List <OrderSearchResultBE> SearchByConditions(OrderSearchParameterBE orderSearchParameterBE, out int rowConut) { return(_orderSearchService.SearchByConditions(orderSearchParameterBE, out rowConut)); }