/// <summary> /// 查询配件 /// </summary> /// <returns></returns> public virtual DataTable QueryAccessory(AccessoryQueryFilter queryCriteria, out int totalCount) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryAccessory"); var pagingInfo = new PagingInfoEntity { SortField = queryCriteria.PagingInfo.SortBy, StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize, MaximumRows = queryCriteria.PagingInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "AccessoryInfo.SysNo DESC")) { if (!String.IsNullOrEmpty(queryCriteria.AccessoryName)) { dataCommand.AddInputParameter("@AccessoryName", DbType.String, queryCriteria.AccessoryName); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "AccessoriesName", DbType.String, "@AccessoryName", QueryConditionOperatorType.Like, queryCriteria.AccessoryName); } dataCommand.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = dataCommand.ExecuteDataTable(); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }
public QueryResult QueryAccessory(AccessoryQueryFilter request) { int totalCount; var dataTable = ObjectFactory <IAccessoryQueryDA> .Instance.QueryAccessory(request, out totalCount); return(new QueryResult { Data = dataTable, TotalCount = totalCount }); }