CategoriesController

目录

1、 CategoriesController

1.1、 配件大类设置

1.2、 /// 查询配件大类

1.3、 /// 新增

1.3.1、 //判断配件大类表中是否已经存在新增的配件大类信息

1. CategoriesController 

using QXQPS.Models;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace QXQPS.Areas.BasicdataManagment.Controllers

{

    public class CategoriesController : Controller

    {

        // GET: BasicdataManagment/Categories

        Models.QXQPEntities myModels = new Models.QXQPEntities();

1. 1. 配件大类设置

        public ActionResult Accessories()//配件大类设置

        {

            return View();

        }

        /// <summary>

1. 1.         /// 查询配件大类

        /// </summary>

        /// <returns></returns>

        public ActionResult SelectAccessories()

        {

            var list = from tbAccessories in myModels.SYS_FittingsType

                       select tbAccessories;

            return Json(list, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

1. 1.         /// 新增

        /// </summary>

        /// <param name="FittingsType"></param>

        /// <returns></returns>

        public ActionResult InsertFittingsType(SYS_FittingsType FittingsType)

        {

            string strMsg = "failed";

            try

            {

1. 1. 1.                 //判断配件大类表中是否已经存在新增的配件大类信息

                var SelectCount = (from tbFittingsType in myModels.SYS_FittingsType

                                   where tbFittingsType.FittingsTypeID == FittingsType.FittingsTypeID ||

                                   tbFittingsType.FittingsTypeNum == FittingsType.FittingsTypeNum &&

                                   tbFittingsType.FittingsTypeName == FittingsType.FittingsTypeName

                                   select tbFittingsType).Count();

                if (SelectCount == 0)

                {

                    myModels.SYS_FittingsType.Add(FittingsType);

                    myModels.SaveChanges();

                    strMsg = "success";

                }

                else

                {

                    strMsg = "该配件大类已经存在，不需要重复输入数据！";

                }

            }

            catch (Exception e)

            {

                strMsg = "failed";

            }

            return Json(strMsg, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

原文地址：https://blog.csdn.net/weixin_42132177/article/details/142653489

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！