public void GetPagingSKU_SKU_AttributesService_Test()
{
SearchSKU_AttributesModel searchModel = new SearchSKU_AttributesModel()
{
PagedIndex = 1,
PagedSize = 10
};
var result = this._SKU_AttributesService.GetPagingSKU_Attributess(searchModel);
Assert.IsTrue(result.Data.TotalCount > 0);
}
/// <summary>
/// 列表数据
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public JsonResult List(SearchSKU_AttributesModel searchModel)
{
searchModel.IsSKU = 1;
searchModel.AttributeName = string.IsNullOrEmpty(searchModel.AttributeName) ? null : searchModel.AttributeName.Trim();
var result = _SkuAttributesService.GetPagingSKU_Attributess(searchModel);
var data = new
{
rows = result.Data,
total = result.Data.TotalCount,
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页获取规格列表
/// </summary>
/// <param name="model">规格搜索模型</param>
/// <returns>规格列表数据</returns>
public ResultModel GetPagingSKU_Attributess(SearchSKU_AttributesModel model)
{
var whereExpr = _database.Db.SKU_Attributes.AttributeName.Like("%" + model.AttributeName + "%");
if (model.IsSKU.HasValue)
{
whereExpr = new SimpleExpression(whereExpr, new SimpleExpression(_database.Db.SKU_Attributes.IsSKU, model.IsSKU.Value, SimpleExpressionType.Equal), SimpleExpressionType.And);
}
var result = new ResultModel
{
Data =
new SimpleDataPagedList <SKU_AttributesModel>(_database.Db.SKU_Attributes.FindAll(whereExpr).OrderByUpdateDTDescending(),
model.PagedIndex, model.PagedSize)
};
return(result);
}
