目录
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();
public ActionResult UpdateSales(SYS_SalesCustomer Sales)
{
var strMsg = "failed";
try
{
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;
myModels.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "编号不能为空,请输入完整信息";
}
}
else
{
strMsg = "身份证不能为空,请输入完整信息";
}
}
else
{
strMsg = "客户名称不能为空,请输入完整信息";
}
}
else
{
strMsg = "该客户信息已存在,不需要重复录入!";
}
}
catch (Exception)
{
strMsg = "failed";
}
return Json(strMsg, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// </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);
}
}
}
}