SupplierbasicController

目录

1、 SupplierbasicController

1.1、 UpdateSupplierbasic

1.1.1、 //判断修改后的数据是否与数据库重复

1.1.2、 //保存数据库

1. SupplierbasicController 

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 SupplierbasicController : Controller

    {

        // GET: BasicdataManagment/Supplierbasic

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

1. 1. UpdateSupplierbasic

        public ActionResult UpdateSupplierbasic(SYS_Suppliers Suppliers)

        {

            var strMsg = "failed";

            try

            {

1. 1. 1.                 //判断修改后的数据是否与数据库重复

                var oldSuppliersRow = (from tbSuppliers in myModels.SYS_Suppliers

                                       where tbSuppliers.SuppliersID != Suppliers.SuppliersID &&

                                       (tbSuppliers.SuppliersFirm == Suppliers.SuppliersFirm)

                                       select tbSuppliers).Count();

                if (oldSuppliersRow == 0)

                {

                    myModels.Entry(Suppliers).State = System.Data.Entity.EntityState.Modified;

1. 1. 1.                     //保存数据库

                    myModels.SaveChanges();

                    strMsg = "success";

                }

                else

                {

                    strMsg = "该客户信息已经存在，不需要重复录入！";

                }

            }

            catch (Exception)

            {

                strMsg = "failed";

            }

            return Json(strMsg, JsonRequestBehavior.AllowGet);

        }

        /// <summary>