/// <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)); }