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