目录
using QXQPS.Models;
using QXQPS.Vo;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace QXQPS.Areas.BasicdataManagment.Controllers
{
public class InformationController : Controller
{
// GET: BasicdataManagment/Information
Models.QXQPEntities myModels = new Models.QXQPEntities();
/// </summary>
/// <param name="bsgridPage"></param>
/// <returns></returns>
public ActionResult SelectSpare(BsgridPage bsgridPage, int FittingsTypeID)
{
var listSpare = (from tbSpare in myModels.SYS_FittingsInfo
join tbFittingsType in myModels.SYS_FittingsType on tbSpare.FittingsTypeID equals tbFittingsType.FittingsTypeID
join tbSystemUnit in myModels.SYS_SystemUnit on tbSpare.SystemUnitID equals tbSystemUnit.SystemUnitID
join tbVehicleType in myModels.SYS_VehicleType on tbSpare.VehicleTypeID equals tbVehicleType.VehicleTypeID
join tbSuppliers in myModels.SYS_Suppliers on tbSpare.SuppliersID equals tbSuppliers.SuppliersID
select new SpareVo
{
FittingsInfoID = tbSpare.FittingsInfoID,//
FittingsTypeID = tbFittingsType.FittingsTypeID,//商品类别ID
FittingsTypeName = tbFittingsType.FittingsTypeName,//商品类别
Barcode = tbSpare.Barcode,//
FittingsCode = tbSpare.FittingsCode,//邮件编码
FittingsName = tbSpare.FittingsName,//配件名称
Specification = tbSpare.Specification,//配件规格
SystemUnit = tbSystemUnit.SystemUnit,//单位
VehicleType = tbVehicleType.VehicleType,//车型
Brand = tbSpare.Brand,//品牌
Intake = tbSpare.Intake,//进价
OpenPrice = tbSpare.OpenPrice,//开单价
SalesPrice = tbSpare.SalesPrice,//销售价格
WholesalePrice = tbSpare.WholesalePrice,//批发价格
InventoryMax = tbSpare.InventoryMax,//库存上限
InventoryMin = tbSpare.InventoryMin,//库存下限
SuppliersName = tbSuppliers.SuppliersName,//
Remark = tbSpare.Remark,//备注
}).ToList();
if (FittingsTypeID > 0)
{
listSpare = listSpare.Where(m => m.FittingsTypeID == FittingsTypeID).ToList();
}
int count = listSpare.Count();
List<SpareVo> listFittingsType = listSpare.OrderByDescending(m => FittingsTypeID).Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();
Bsgrid<SpareVo> bsgrid = new Bsgrid<SpareVo>()
{
success = true,
totalRows = count,
curPage = bsgridPage.curPage,
data = listFittingsType,
};
return Json(bsgrid, JsonRequestBehavior.AllowGet);
}
/// <summary>