public string GetLookupDesc(string lookupKey, string code) { using (AIYunNetContext context = new AIYunNetContext()) { WebLookup lookup = context.WebLookUp.FirstOrDefault(lp => lp.LookupKey == lookupKey && lp.Code == code); return(lookup != null ? lookup.Description : string.Empty); } }
public int AddLookup(WebLookup webLookup) { using (AIYunNetContext context = new AIYunNetContext()) { context.WebLookUp.Add(webLookup); context.SaveChanges(); return(1); } }
public ActionResult AddLookup(string id) { //类别分组 List <string> loouplist = webCommonService.GetLookupGroupNameList(); IEnumerable <SelectListItem> loouplist1 = loouplist.Select(com => new SelectListItem { Value = com.ToString(), Text = com }); ViewBag.grouplist = loouplist1; WebLookup weblookup = webCommonService.GetLookup(Convert.ToInt32(id)); return(View(weblookup)); }
public ActionResult AddLookup(WebLookup webLookup) { int result = 0; if (webLookup != null && webLookup.LookupID > 0) { result = webCommonService.UpdateLookup(webLookup); } else { result = webCommonService.AddLookup(webLookup); } return(Json(new { RetCode = result }, JsonRequestBehavior.AllowGet)); }
public int DeleteLookup(int id) { using (AIYunNetContext context = new AIYunNetContext()) { WebLookup originalWebLookup = context.WebLookUp.Find(id); if (originalWebLookup != null) { originalWebLookup.Display = 0; context.SaveChanges(); return(1); } else { return(0); } } }
public int UpdateLookup(WebLookup webLookup) { using (AIYunNetContext context = new AIYunNetContext()) { WebLookup originalWebLookup = context.WebLookUp.Find(webLookup.LookupID); if (originalWebLookup != null) { originalWebLookup.LookupKey = webLookup.LookupKey; originalWebLookup.Code = webLookup.Code; originalWebLookup.Col2 = webLookup.Col2; originalWebLookup.Description = webLookup.Description; originalWebLookup.Display = webLookup.Display; originalWebLookup.EnglishName = webLookup.EnglishName; context.SaveChanges(); return(1); } else { return(0); } } }