/// <summary> /// 查询属性 /// </summary> /// <param name="queryCriteria"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryPropertyList(PropertyQueryFilter queryCriteria, out int totalCount) { DataCommand dc = DataCommandManager.GetDataCommand("QueryPropertyList"); if (string.IsNullOrEmpty(queryCriteria.PropertyName)) { dc.SetParameterValue("@PropertyDescription", ""); } else { dc.SetParameterValue("@PropertyDescription", "%" + queryCriteria.PropertyName.Trim() + "%"); } dc.SetParameterValue("@IsActive", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status); 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); }
public QueryResult QueryProperty(PropertyQueryFilter request) { if (request == null) { throw new BizException(ResouceManager.GetMessageString("IM.Property", "RequestIsNull")); } int totalCount; var data = ObjectFactory <IPropertyQueryDA> .Instance.QueryPropertyList(request, out totalCount); var source = new QueryResult { Data = data, TotalCount = totalCount }; return(source); }