InformationController

目录

1、 InformationController

1.1、 配件信息设置

1.2、 /// 查询商品类别

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. 配件信息设置

        public ActionResult Spare()//配件信息设置

        {

            return View();

        }

        /// <summary>

1. 1.         /// 查询商品类别

        /// </summary>

        /// <returns></returns>

        public ActionResult SelectFittingsType()

        {

            var listFittingsType = from tbFittingsType in myModels.SYS_FittingsType

                                   select tbFittingsType;

            return Json(listFittingsType, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

1. 1.         /// 修改

        /// </summary>

        /// <param name="FittingsInfoID"></param>

        /// <returns></returns>

        public ActionResult SelectSpareByID(int FittingsInfoID)

        {

            var list = myModels.SYS_FittingsInfo.Where(m => m.FittingsInfoID == FittingsInfoID).Select(m => new

            {

                FittingsInfoID = m.FittingsInfoID,//配件信息ID

                Picture = m.Picture,//图片

                FittingsCode = m.FittingsCode,//配件编码

                FittingsTypeID = m.FittingsTypeID,//商品类别

                FittingsName = m.FittingsName,//配件名称

                Barcode = m.Barcode,// 条码

                Specification = m.Specification,// 配件规格

                Brand = m.Brand,//品牌

                SystemUnitID = m.SystemUnitID,//单位

                VehicleTypeID = m.VehicleTypeID,//所属车型

                Intake = m.Intake,//进价

                SalesPrice = m.SalesPrice,//销售价格

                WholesalePrice = m.WholesalePrice,//批发价

                OpenPrice = m.OpenPrice,//开单价

                InventoryMax = m.InventoryMax,//库存上限

                InventoryMin = m.InventoryMin,//库存下限

                SuppliersID = m.SuppliersID,//供应商

                Remark = m.Remark//备注

            });

            return Json(list, JsonRequestBehavior.AllowGet);

        }