目录
1、 WarehouseController
1.1、 /// 新增
1.1.1、 //定义返回
1.1.2、 //名称不能为空
1.1.3、 //查询是否已存在该仓库
1.1.4、 //新增仓库
1.2、 /// 删除
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 WarehouseController : Controller
{
// GET: BasicdataManagment/Warehouse
Models.QXQPEntities myModels = new Models.QXQPEntities();
-
- /// 新增
/// </summary>
/// <param name="Warehouse"></param>
/// <returns></returns>
public ActionResult InsertWarehouse(SYS_Warehouse Warehouse)
{
-
-
- //定义返回
-
string strMsg = "fail";
try
{
-
-
- //名称不能为空
-
if (!string.IsNullOrEmpty(Warehouse.WarehouseNum) && !string.IsNullOrEmpty(Warehouse.WarehouseName))
{
-
-
- //查询是否已存在该仓库
-
var oldCount = (from tbWarehouse in myModels.SYS_Warehouse
where tbWarehouse.WarehouseID == Warehouse.WarehouseID ||
tbWarehouse.WarehouseNum == Warehouse.WarehouseNum ||
tbWarehouse.WarehouseName == Warehouse.WarehouseName
select tbWarehouse).Count();
if (oldCount == 0)
{
-
-
- //新增仓库
-
myModels.SYS_Warehouse.Add(Warehouse);
if (myModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
else
{
strMsg = "exist";
}
}
else
{
strMsg = "nofull";
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return Json(strMsg, JsonRequestBehavior.AllowGet);
}
/// <summary>
-
- /// 删除
/// </summary>
/// <param name="WarehouseID"></param>
/// <returns></returns>
public ActionResult DeleteWarehouse(int WarehouseID)
{
try
{
var listWarehouse = myModels.SYS_Warehouse
.Where(m => m.WarehouseID == WarehouseID).Single();
myModels.SYS_Warehouse.Remove(listWarehouse);
if (myModels.SaveChanges() > 0)
{
return Json(true, JsonRequestBehavior.AllowGet);
}
else
{
return Json(false, JsonRequestBehavior.AllowGet);
}
}
catch (Exception E)
{
return Json(false, JsonRequestBehavior.AllowGet);
}
}
}
}
