InformationController

目录

1、 InformationController

1.1、 /// 新增

1.1.1、 //判断配件信息表是否存在新增的配件信息

1.2、 /// 删除

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="FittingsInfo"></param>

        /// <returns></returns>

        public ActionResult InsertSpare(SYS_FittingsInfo FittingsInfo)

        {

            string strMsg = "fail";

            try

            {

1. 1. 1.                 //判断配件信息表是否存在新增的配件信息

                var SelectCount = (from tbFittingsInfo in myModels.SYS_FittingsInfo

                                   where tbFittingsInfo.FittingsInfoID == FittingsInfo.FittingsInfoID ||

                                   tbFittingsInfo.FittingsName == FittingsInfo.FittingsName

                                   select tbFittingsInfo).Count();

                if (SelectCount == 0)

                {

                    myModels.SYS_FittingsInfo.Add(FittingsInfo);

                    myModels.SaveChanges();

                    strMsg = "success";

                }

                else

                {

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

                }

            }

            catch (Exception e)

            {

                strMsg = "failed";

            }

            return Json(strMsg, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

1. 1.         /// 删除

        /// </summary>

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

        /// <returns></returns>

        public ActionResult DeleteSpare(int FittingsInfoID)

        {

            try

            {

                var listSpare = myModels.SYS_FittingsInfo

                    .Where(m => m.FittingsInfoID == FittingsInfoID).Single();

                myModels.SYS_FittingsInfo.Remove(listSpare);

                if (myModels.SaveChanges() > 0)

                {

                    return Json(true, JsonRequestBehavior.AllowGet);

                }

                else

                {

                    return Json(false, JsonRequestBehavior.AllowGet);

                }

            }

            catch (Exception e)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

        }

    }

}