InformationController

目录

1、 InformationController

1.1、 /// 查询

1.1.1、 配件信息ID

1.1.2、 条码

1.1.3、 供应商

1. InformationController 

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();

1. 1.         /// 查询

        /// </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,//

1. 1. 1. 配件信息ID

                                 FittingsTypeID = tbFittingsType.FittingsTypeID,//商品类别ID

                                 FittingsTypeName = tbFittingsType.FittingsTypeName,//商品类别

                                 Barcode = tbSpare.Barcode,//

1. 1. 1. 条码

                                 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,//

1. 1. 1. 供应商

                                 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>