SupplierbasicController

目录

1、 SupplierbasicController

1.1、 /// 新增

1.2、 /// 修改

1.3、 /// 删除

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.         /// 新增

        /// </summary>

        /// <returns></returns>

        public ActionResult InsertSupplierbasic(SYS_Suppliers Suppliers)

        {

            string strMsg = "failed";

            try

            {

                var SuppliersCount = (from tbSuppliers in myModels.SYS_Suppliers

                                      where tbSuppliers.SuppliersID == Suppliers.SuppliersID ||

                                      tbSuppliers.SuppliersName == Suppliers.SuppliersName

                                      select tbSuppliers).Count();

                if (SuppliersCount == 0)

                {

                    myModels.SYS_Suppliers.Add(Suppliers);

                    myModels.SaveChanges();

                    strMsg = "success";

                }

                else

                {

                    strMsg = "该供应商名称已经存在，不需要重复输入数据！";

                }

            }

            catch (Exception e)

            {

                strMsg = "failed";

            }

            return Json(strMsg, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

1. 1.         /// 修改

        /// </summary>

        /// <param name="SuppliersID"></param>

        /// <returns></returns>

        public ActionResult UpdateSupplierbasicByID(int SuppliersID)

        {

            var list = myModels.SYS_Suppliers.Where(m => m.SuppliersID == SuppliersID).Select(m => new

            {

                SuppliersID = m.SuppliersID,//供应商ID

                SuppliersFirm = m.SuppliersFirm,//供应商号

                SuppliersName = m.SuppliersName,//供应商名称

                PinYinCode = m.PinYinCode,//拼音码

                MainBusiness = m.MainBusiness,//主要业务

                Address = m.Address,//地址

                Contacts = m.Contacts,//联系人

                TelePhone = m.TelePhone,//电话

                MobilePhone = m.MobilePhone,//手机

                Facsimile = m.Facsimile,//传真

                Mailbox = m.Mailbox,//邮箱

                Url = m.Url,//网址

                OpenBank = m.OpenBank,//开户行

                TaxNumber = m.TaxNumber,//税号

                InputPerson = m.InputPerson,//录入人

                StorageAdd = m.StorageAdd,//库房地址

                StorageTele = m.StorageTele,//库房电话

                Remark = m.Remark,//备注

                ToDeactivate = m.ToDeactivate,//停用标志

            });

            return Json(list, JsonRequestBehavior.AllowGet);

        }

1. 1.         /// 删除

        /// </summary>

        /// <param name="SuppliersID"></param>

        /// <returns></returns>

        public ActionResult DeleteSupplierbasic(int SuppliersID)

        {

            try

            {

                var listSupplierbasic = myModels.SYS_Suppliers

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

                myModels.SYS_Suppliers.Remove(listSupplierbasic);

                if (myModels.SaveChanges() > 0)

                {

                    return Json(true, JsonRequestBehavior.AllowGet);

                }

                else

                {

                    return Json(false, JsonRequestBehavior.AllowGet);

                }

            }

            catch (Exception E)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

        }

    }

}