/// <summary>
/// 新增
/// </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));
}
public ActionResult UpdateWarehouse(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.Entry(Warehouse).State = System.Data.Entity.EntityState.Modified;
if (myModels.SaveChanges() > 0)
{
strMsg = "success";
}
//}
//else
//{
// strMsg = "exist";
//}
}
else
{
strMsg = "nofull";
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
