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