public string Get_SysMapCodeValue(string MapCode) { using (sartas3 db = new sartas3()) { sys_codemap map = db.sys_codemap.SingleOrDefault(n => n.Code == MapCode); if (map != null) { return(map.Value); } else { return(null); } } }
public List <sys_code> Get_AlarmTypeList() { using (sartas3 db = new sartas3()) { sys_codemap map = db.sys_codemap.SingleOrDefault(n => n.Code == "AlarmType"); if (map != null) { List <sys_code> res = db.sys_code.Where(n => n.CodeMap_ID == map.CodeMap_ID && n.Remark != "smart").ToList(); return(res); } else { return(null); } } }
/// <summary> /// 通过MapCode,查询系统字典信息 /// </summary> /// <param name="MapCode"></param> /// <returns></returns> public List <sys_code> Get_SysCodeByMapCode(string MapCode) { using (sartas3 db = new sartas3()) { sys_codemap map = db.sys_codemap.SingleOrDefault(n => n.Code == MapCode); if (map != null) { List <sys_code> res = db.sys_code.Where(n => n.CodeMap_ID == map.CodeMap_ID).ToList(); return(res); } else { return(null); } } }