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