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