public void QueryProduct(ProductQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductQueryFilter filter;
filter = model.ConvertVM <ProductQueryVM, ProductQueryFilter>();
filter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
string relativeUrl = "/IMService/Product/QueryProduct";
restClient.QueryDynamicData(relativeUrl, filter,
(obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
if (!(args == null || args.Result == null || args.Result.Rows == null))
{
foreach (var item in args.Result.Rows)
{
item.IsChecked = false;
}
}
callback(obj, args);
}
);
}
public ActionResult QueryProductList(ProductQueryVM queryModel)
{
var result = new List <ProductInfoViewModel>();
using (var dbContext = new TicketCodeTestDBContext())
{
var efProducts = dbContext.Tproduct.ToList();
if (queryModel.productname != null)
{
efProducts = efProducts.Where(item => item.Name == queryModel.productname).ToList();
}
if (queryModel.productid != null)
{
efProducts = efProducts.Where(item => item.Id == queryModel.productid).ToList();
}
if (queryModel.suppliername != null)
{
}
if (queryModel.status != null)
{
efProducts = efProducts.Where(item => item.Status == queryModel.status).ToList();
}
if (queryModel.class1 != null)
{
efProducts = efProducts.Where(item => item.Class1 == queryModel.class1).ToList();
}
if (queryModel.class2 != null)
{
efProducts = efProducts.Where(item => item.Class2 == queryModel.class2).ToList();
}
foreach (var item in efProducts)
{
var productInfoVM = new ProductInfoViewModel();
#region convert db to viewmodel
productInfoVM.productname = item.Name;
productInfoVM.title = item.Title;
productInfoVM.productid = item.Id;
var efSupplier = dbContext.Tsupplier.Find(item.SupplierId);
if (efSupplier != null)
{
productInfoVM.suppliername = efSupplier.Name;
}
productInfoVM.class1 = item.Class1;
productInfoVM.class2 = item.Class2;
productInfoVM.saleprice = item.SalePrice;
productInfoVM.avaiablestock = item.AvailableStock;
productInfoVM.saleamount = item.SaleAmount;
productInfoVM.currentremain = item.AvailableStock;
productInfoVM.productstatus = item.Status;
#endregion
var checkrow = "<a href=\"#\" onclick=\"checkProduct(this)\">查看</a>";
var editrow = "<a href=\"#\" onclick=\"editProduct(this)\">编辑</a>";
var deleterow = "<a href=\"#\" onclick=\"removeProduct(this)\">删除</a>";
productInfoVM.operation = checkrow + " " + editrow + " " + deleterow;
#region 商品上下架状态
var operationStatus = item.Status == 0 ? "切换为上架" : "切换为下架";
var currentStatus = item.Status == 0 ? "已下架" : "已上架";
productInfoVM.status = string.Format("{0} <a href=\"#\" class=\"easyui-linkbutton\" iconCls=\"icon-search\" onclick=\"switchProductStatus()\">{1}</a>"
, currentStatus, operationStatus);
#endregion
result.Add(productInfoVM);
}
}
return(Json(result));
}
