Пример #1
0
        public QueryResult GetUserSource(CpsUserSourceQueryFilter query)
        {
            int totalCount;
            var dataTable = ObjectFactory <ICpsUserDA> .Instance.GetUserSource(query, out totalCount);

            return(new QueryResult()
            {
                Data = dataTable,
                TotalCount = totalCount
            });
        }
Пример #2
0
        /// <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);
        }
Пример #3
0
        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);
        }