public QueryResult QueryPropertyValueListByPropertySysNo(PropertyValueQueryFilter request)
        {
            if (request == null)
            {
                throw new BizException(ResouceManager.GetMessageString("IM.Property", "RequestIsNull"));
            }
            int totalCount;
            var data = ObjectFactory <IPropertyQueryDA> .Instance.QueryPropertyValueListByPropertySysNo(request, out totalCount);

            var source = new QueryResult {
                Data = data, TotalCount = totalCount
            };

            return(source);
        }
Exemple #2
0
        /// <summary>
        /// 根据PropertySysNo获取属性值列表
        /// </summary>
        /// <param name="queryCriteria"></param>
        /// <returns></returns>
        public DataTable QueryPropertyValueListByPropertySysNo(PropertyValueQueryFilter queryCriteria, out int totalCount)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("QueryPropertyValueListByPropertySysNo");

            dc.SetParameterValue("@PropertySysNo", queryCriteria.PropertySysNo);
            dc.SetParameterValue("@CompanyCode", "8601");

            dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
            dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
            dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);

            var source = dc.ExecuteDataTable();

            totalCount = (int)dc.GetParameterValue("@TotalCount");

            return(source);
        }