public ActionResult CreateOutboundItem(OBoutboundItem OutboundItem) { string gencode = string.Empty; string lastgencode = (from u in db.OBoutboundItems.ToList() where u.OutBoundPlanCode == OutboundItem.OutBoundPlanCode orderby u.OutboundItemCode descending select u.OutboundItemCode).FirstOrDefault(); if (lastgencode == null) { gencode = "OBI0001"; } else { gencode = lastgencode.Substring(3); int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1; gencode = string.Format("OBI{0}", upId.ToString().PadLeft(4, '0')); } OutboundItem.OutboundItemCode = gencode; OutboundItem.Is_Deleted = false; OutboundItem.Create_Date = DateTime.Now; OutboundItem.Create_User = user.UserID; OutboundItem.Update_Date = DateTime.Now; OutboundItem.Update_User = user.UserID; try { db.OBoutboundItems.Add(OutboundItem); db.SaveChanges(); } catch (Exception err) { } return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetOutboundItem(int ID) { OBoutboundItem item = (from c in db.OBoutboundItems where c.ID == ID select c).FirstOrDefault(); return(Json(new { item = item }, JsonRequestBehavior.AllowGet)); }