/// <summary>
/// 查询分类属性
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void QueryCategoryAccessories(CategoryAccessoriesQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
CategoryAccessoriesQueryFilter filter = model.ConvertVM <CategoryAccessoriesQueryVM, CategoryAccessoriesQueryFilter>();
filter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
restClient.QueryDynamicData(GetRelativeUrl, filter,
(obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
if (!(args.Result == null || args.Result.Rows == null))
{
foreach (var item in args.Result.Rows)
{
item.IsChecked = false;
}
}
callback(obj, args);
}
);
}
public QueryResult QueryCategoryAccessories(CategoryAccessoriesQueryFilter request)
{
if (request == null)
{
throw new BizException(ResouceManager.GetMessageString("IM.CategoryAccessory", "CategoryAccessoryCondtionIsNull"));
}
int totalCount;
var data = ObjectFactory <ICategoryAccessoriesQueryDA> .Instance.QueryCategoryAccessories(request, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}
public DataTable QueryCategoryAccessories(CategoryAccessoriesQueryFilter queryCriteria, out int totalCount)
{
var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCategoryAccessories");
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, "C.SysNo DESC"))
{
if (queryCriteria.Category3SysNo > 0)
{
//dataCommand.AddInputParameter("@CategorySysNo", DbType.Int32, queryCriteria.CategorySysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C3Sysno",
DbType.Int32, "@Category3SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.Category3SysNo);
}
if (queryCriteria.Category2SysNo > 0)
{
//dataCommand.AddInputParameter("@CategorySysNo", DbType.Int32, queryCriteria.CategorySysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C2Sysno",
DbType.Int32, "@Category2SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.Category2SysNo);
}
if (queryCriteria.Category1SysNo > 0)
{
//dataCommand.AddInputParameter("@CategorySysNo", DbType.Int32, queryCriteria.CategorySysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"Z.SysNo",
DbType.Int32, "@Category1SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.Category1SysNo);
}
if (queryCriteria.Status != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C.Status",
DbType.Int32, "@Status",
QueryConditionOperatorType.Equal,
queryCriteria.Status.Value);
}
if (!string.IsNullOrEmpty(queryCriteria.AccessoriesName))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"AccessoriesName",
DbType.String, "@AccessoriesName",
QueryConditionOperatorType.Like,
queryCriteria.AccessoriesName);
}
if (queryCriteria.AccessoryOrder != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"AccessoryOrder",
DbType.Int32, "@AccessoryOrder",
QueryConditionOperatorType.Equal,
queryCriteria.AccessoryOrder.Value);
}
if (queryCriteria.IsDefault != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"IsDefault",
DbType.Int32, "@IsDefault",
QueryConditionOperatorType.Equal,
queryCriteria.IsDefault.Value);
}
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var enumList = new EnumColumnList {
{ "Status", typeof(CategoryAccessoriesStatus) }, { "IsDefault", typeof(IsDefault) }
};
DataTable dt = dataCommand.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
return(dt);
}
}
