public String PriceList()
{
PriceListViewData view = new PriceListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = 1;
view.PageData.PageSize = 10;
view.PageData.PagintionJsFunction = "window.System.PriceList.search()";
view.PageData.OrderBy = "StartPlace, DestinationPlace, InterimPlace, Type, LuggageAmount";
string sql = @"SELECT * FROM dbo.PriceList";
view.List = new Pagintion(sql, null, view.PageData).ToList <PriceList>();
return(PageViewHelper.LoadPage("/System/PriceList.aspx", view));
}
public String SelectPrice(double amount, string type)
{
PriceListViewData view = new PriceListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = 1;
view.PageData.PageSize = 10;
view.PageData.PagintionJsFunction = "window.System.SelectPrice.search()";
view.PageData.OrderBy = "StartPlace, DestinationPlace, InterimPlace, Type, LuggageAmount";
view.Amount = amount;
view.Type = type;
string sql = @"SELECT * FROM dbo.PriceList WHERE LuggageAmount= @Amount AND [Type] = @Type";
view.List = new Pagintion(sql, new { Amount = amount, Type = type }, view.PageData).ToList <PriceList>();
return(PageViewHelper.LoadPage("/System/SelectPrice.aspx", view));
}
public string SelectSearch(SearchKeyPaginationData pd)
{
PriceListViewData view = new PriceListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.SelectPrice.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT * FROM dbo.PriceList WHERE StartPlace LIKE '%' + @Place + '%' OR DestinationPlace LIKE '%' + @Place + '%' OR InterimPlace LIKE '%' + @Place + '%'";
view.List = new Pagintion(sql, new { Place = pd.SearchKey }, view.PageData).ToList <PriceList>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/SelectPrice.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(PaginationData pd)
{
PriceListViewData view = new PriceListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.PriceList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT * FROM dbo.PriceList";
view.List = new Pagintion(sql, null, view.PageData).ToList <PriceList>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/PriceList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
