public QueryResult GetUserSource(CpsUserSourceQueryFilter query) { int totalCount; var dataTable = ObjectFactory <ICpsUserDA> .Instance.GetUserSource(query, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 根据UserSysNo得到所有source /// </summary> /// <param name="UserSysNo"></param> /// <returns></returns> public DataTable GetUserSource(CpsUserSourceQueryFilter query, out int totalCount) { DataCommand cmd = DataCommandManager.GetDataCommand("GetUserSource"); cmd.SetParameterValue("@UserSysNo", query.UserSysNo); cmd.SetParameterValue("@PageIndex", query.PageInfo.PageIndex); cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize); DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(); totalCount = (int)cmd.GetParameterValue("@TotalCount"); return(dt); }
public void GetUserSource(int userSysNo, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { string GetUserSourceUrl = "ExternalSYSService/CpsUser/GetUserSource"; CpsUserSourceQueryFilter query = new CpsUserSourceQueryFilter() { UserSysNo = userSysNo, PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = PageIndex, PageSize = PageSize, SortBy = SortField } }; restClient.QueryDynamicData(GetUserSourceUrl, query, callback); }