SalescustomerController

目录

1、 SalescustomerController

1.1、 UpdateSales

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

1.1.2、 //保存数据库

1.2、 /// 删除

1. SalescustomerController 

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

    {

        // GET: BasicdataManagment/Salescustomer

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

1. 1. UpdateSales

        public ActionResult UpdateSales(SYS_SalesCustomer Sales)

        {

            var strMsg = "failed";

            try

            {

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

                var oldSalesRow = (from tbSales in myModels.SYS_SalesCustomer

                                   where tbSales.SalesCustomerID != Sales.SalesCustomerID &&

                                   (tbSales.CustomerCode == Sales.CustomerCode ||

                                   tbSales.IdNumber == Sales.IdNumber)

                                   select tbSales).Count();

                if (oldSalesRow == 0)

                {

                    if (Sales.CustomerName != null)

                    {

                        if (Sales.IdNumber != null)

                        {

                            if (Sales.CustomerCode != null)

                            {

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

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

                                myModels.SaveChanges();

                                strMsg = "success";

                            }

                            else

                            {

                                strMsg = "编号不能为空，请输入完整信息";

                            }

                        }

                        else

                        {

                            strMsg = "身份证不能为空，请输入完整信息";

                        }

                    }

                    else

                    {

                        strMsg = "客户名称不能为空，请输入完整信息";

                    }

                }

                else

                {

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

                }

            }

            catch (Exception)

            {

                strMsg = "failed";

            }

            return Json(strMsg, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

1. 1.         /// 删除

        /// </summary>

        /// <param name="SalesCustomerID"></param>

        /// <returns></returns>

        public ActionResult DeleteSales(int SalesCustomerID)

        {

            try

            {

                var listSales = myModels.SYS_SalesCustomer

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

                myModels.SYS_SalesCustomer.Remove(listSales);

                if (myModels.SaveChanges() > 0)

                {

                    return Json(true, JsonRequestBehavior.AllowGet);

                }

                else

                {

                    return Json(false, JsonRequestBehavior.AllowGet);

                }

            }

            catch (Exception e)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

        }

    }

}