/// <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
});
}
