public static int AutoAddCustomerShip(int ctmId, string Name1, string Name2, string SimpleName, string DeadWeight, string Length, string Width, string TEUS, string Class, string Remark, int UserID) { try { TugDataEntities db = new TugDataEntities(); System.Linq.Expressions.Expression<Func<CustomerShip, bool>> exp = u => u.Name1 == Name1; CustomerShip obj = db.CustomerShip.Where(exp).FirstOrDefault(); if (obj != null) { //var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, objid = obj.IDX }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); //return Json(ret); //throw new Exception("船名称已存在!"); return obj.IDX; } { TugDataModel.CustomerShip ship = new CustomerShip(); ship.CustomerID = ctmId;// Util.toint(Request.Form["CustomerID"]); ship.ShipTypeID = -1;//Util.toint(Request.Form["ShipTypeID"]); ship.Name1 = Name1; ship.Name2 = Name2; ship.SimpleName = SimpleName; ship.DeadWeight = Util.toint(DeadWeight); ship.Length = Util.toint(Length); ship.Width = Util.toint(Width); ship.TEUS = Util.toint(TEUS); ship.Class = Class; ship.Remark = Remark; ship.OwnerID = -1; ship.CreateDate = ship.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; ship.UserID = UserID; ship.UserDefinedCol1 = ""; ship.UserDefinedCol2 = ""; ship.UserDefinedCol3 = ""; ship.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"] != "") // ship.UserDefinedCol5 = Util.tonumeric(Request.Form["UserDefinedCol5"]); //if (Request.Form["UserDefinedCol6"] != "") // ship.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); //if (Request.Form["UserDefinedCol7"] != "") // ship.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); //if (Request.Form["UserDefinedCol8"] != "") // ship.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); ship.UserDefinedCol9 = ""; ship.UserDefinedCol10 = ""; ship = db.CustomerShip.Add(ship); db.SaveChanges(); //var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, objid=ship.IDX }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); //return Json(ret); return ship.IDX; } } catch (Exception ex) { throw ex; //var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //return Json(ret); } }
public ActionResult AddEdit_Only() { this.Internationalization(); #region Add if (Request.Form["oper"].Equals("add")) { try { TugDataEntities db = new TugDataEntities(); { TugDataModel.CustomerShip ship = new CustomerShip(); //ship.CustomerID = ctmId;// Util.toint(Request.Form["CustomerID"]); ship.ShipTypeID = -1;//Util.toint(Request.Form["ShipTypeID"]); ship.Name1 = Request.Form["Name1"]; ship.Name2 = Request.Form["Name2"]; ship.SimpleName = Request.Form["SimpleName"]; ship.DeadWeight = Util.toint(Request.Form["DeadWeight"]); ship.Length = Util.toint(Request.Form["Length"]); ship.Width = Util.toint(Request.Form["Width"]); ship.TEUS = Util.toint(Request.Form["TEUS"]); ship.Class = Request.Form["Class"]; ship.Remark = Request.Form["Remark"]; ship.OwnerID = -1; ship.CreateDate = ship.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; ship.UserID = Session.GetDataFromSession<int>("userid"); ship.UserDefinedCol1 = Request.Form["UserDefinedCol1"]; ship.UserDefinedCol2 = Request.Form["UserDefinedCol2"]; ship.UserDefinedCol3 = Request.Form["UserDefinedCol3"]; ship.UserDefinedCol4 = Request.Form["UserDefinedCol4"]; if (Request.Form["UserDefinedCol5"] != "") ship.UserDefinedCol5 = Util.tonumeric(Request.Form["UserDefinedCol5"]); if (Request.Form["UserDefinedCol6"] != "") ship.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); if (Request.Form["UserDefinedCol7"] != "") ship.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); if (Request.Form["UserDefinedCol8"] != "") ship.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); ship.UserDefinedCol9 = Request.Form["UserDefinedCol9"]; ship.UserDefinedCol10 = Request.Form["UserDefinedCol10"]; ship = db.CustomerShip.Add(ship); db.SaveChanges(); var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); return Json(ret); } } catch (Exception) { var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //Response.Write(@Resources.Common.EXCEPTION_MESSAGE); return Json(ret); } } #endregion Add #region Edit if (Request.Form["oper"].Equals("edit")) { try { TugDataEntities db = new TugDataEntities(); int idx = Util.toint(Request.Form["IDX"]); string name1 = Request.Form["Name1"]; System.Linq.Expressions.Expression<Func<CustomerShip, bool>> exp = u => u.Name1 == name1 && u.IDX != idx; CustomerShip obj = db.CustomerShip.Where(exp).FirstOrDefault(); if (obj != null) { return Json(new { code = Resources.Common.ERROR_CODE, message = "船名称已存在!" });//Resources.Common.ERROR_MESSAGE } CustomerShip ship = db.CustomerShip.Where(u => u.IDX == idx).FirstOrDefault(); if (ship == null) { return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }); } else { //ship.CustomerID = ctmId;// Util.toint(Request.Form["CustomerID"]); ship.ShipTypeID = -1; //Util.toint(Request.Form["ShipTypeID"]); ship.Name1 = Request.Form["Name1"]; ship.Name2 = Request.Form["Name2"]; ship.SimpleName = Request.Form["SimpleName"]; ship.DeadWeight = Util.toint(Request.Form["DeadWeight"]); ship.Length = Util.toint(Request.Form["Length"]); ship.Width = Util.toint(Request.Form["Width"]); ship.TEUS = Util.toint(Request.Form["TEUS"]); ship.Class = Request.Form["Class"]; ship.Remark = Request.Form["Remark"]; ship.OwnerID = -1; ship.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; ship.UserID = Session.GetDataFromSession<int>("userid"); ship.UserDefinedCol1 = Request.Form["UserDefinedCol1"]; ship.UserDefinedCol2 = Request.Form["UserDefinedCol2"]; ship.UserDefinedCol3 = Request.Form["UserDefinedCol3"]; ship.UserDefinedCol4 = Request.Form["UserDefinedCol4"]; if (Request.Form["UserDefinedCol5"] != "") ship.UserDefinedCol5 = Util.tonumeric(Request.Form["UserDefinedCol5"]); if (Request.Form["UserDefinedCol6"] != "") ship.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); if (Request.Form["UserDefinedCol7"] != "") ship.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); if (Request.Form["UserDefinedCol8"] != "") ship.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); ship.UserDefinedCol9 = Request.Form["UserDefinedCol9"]; ship.UserDefinedCol10 = Request.Form["UserDefinedCol10"]; db.Entry(ship).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); var orderList = db.OrderInfor.Where(u => u.ShipID == idx).ToList(); if (orderList != null) { foreach (var item in orderList) { item.ShipName = ship.Name1; db.Entry(item).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }); } } catch (Exception exp) { return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }); } } #endregion Edit return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }); }