public DataSourceResult GetPage(DataSourceRequest request, string wherecondition, string status, int curruserid) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@page", request.Page)); param.Add(new SqlParameter("@pagesize", request.PageSize)); param.Add(new SqlParameter("@wherecondition", wherecondition)); param.Add(new SqlParameter("@status", status)); param.Add(new SqlParameter("@curruserid", curruserid)); param.Add(new SqlParameter("@sort", CustomModel.GetSortStringFormRequest(request))); var data = new SqlHelper().ExecuteQuery("p_BillDetail_Search", param); request.Page = 1; request.Filters = null; var result = data.ToDataSourceResult(request); result.Total = data.Rows.Count > 0 ? Convert.ToInt32(data.Rows[0]["rowcount"]) : 0; return(result); }