目录
1、 InformationController
1.1、 配件信息设置
1.2、 /// 查询商品类别
1.3、 /// 新增
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();
public ActionResult Spare()//配件信息设置
{
return View();
}
/// <summary>
-
- /// 查询商品类别
/// </summary>
/// <returns></returns>
public ActionResult SelectFittingsType()
{
var listFittingsType = from tbFittingsType in myModels.SYS_FittingsType
select tbFittingsType;
return Json(listFittingsType, JsonRequestBehavior.AllowGet);
}
/// <summary>
-
- /// 新增
/// </summary>
/// <param name="FittingsInfo"></param>
/// <returns></returns>
public ActionResult InsertSpare(SYS_FittingsInfo FittingsInfo)
{
string strMsg = "fail";
try
{
-
- //判断配件信息表是否存在新增的配件信息
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);
}