/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <returns>DataAccess.Model.COMPONENT00</returns> public DataAccess.Model.COMPONENT00 GetModelForCache(long id) { try { //从缓存中读取指定Id记录 var model = GetModelForCache(x => x.Id == id); if (model == null) { //从数据库中读取 var tem = COMPONENT00.SingleOrDefault(x => x.Id == id); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取COMPONENT00表记录时出现异常", e); return(null); } }
/// <summary> /// 获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <param name="isCache">是否从缓存中读取</param> /// <returns>DataAccess.Model.COMPONENT00</returns> public DataAccess.Model.COMPONENT00 GetModel(long id, bool isCache = true) { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //从缓存中获取List var list = GetList(); if (list == null) { return(null); } else { //在List查询指定主键Id的记录 return(list.SingleOrDefault(x => x.Id == id)); } } else { //从数据库中直接读取 var model = COMPONENT00.SingleOrDefault(x => x.Id == id); if (model == null) { return(null); } else { //对查询出来的实体进行转换 return(Transform(model)); } } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.COMPONENT00</returns> public DataAccess.Model.COMPONENT00 GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.COMPONENT00 model = null; Expression <Func <COMPONENT00, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (int)value); expression = x => x.Id == (int)value; break; case "COM_ID": model = list.SingleOrDefault(x => x.COM_ID == (string)value); expression = x => x.COM_ID == (string)value; break; case "PROD_ID": model = list.SingleOrDefault(x => x.PROD_ID == (string)value); expression = x => x.PROD_ID == (string)value; break; case "Num": model = list.SingleOrDefault(x => x.Num == (int)value); expression = x => x.Num == (int)value; break; case "WEIGHT": model = list.SingleOrDefault(x => x.WEIGHT == (decimal)value); expression = x => x.WEIGHT == (decimal)value; break; case "DefaultCOM": model = list.SingleOrDefault(x => x.DefaultCOM == (byte)value); expression = x => x.DefaultCOM == (byte)value; break; case "QUAN1": model = list.SingleOrDefault(x => x.QUAN1 == (int)value); expression = x => x.QUAN1 == (int)value; break; case "QUAN2": model = list.SingleOrDefault(x => x.QUAN2 == (int)value); expression = x => x.QUAN2 == (int)value; break; case "DefQuan": model = list.SingleOrDefault(x => x.DefQuan == (int)value); expression = x => x.DefQuan == (int)value; break; case "BOM_Cost": model = list.SingleOrDefault(x => x.BOM_Cost == (decimal)value); expression = x => x.BOM_Cost == (decimal)value; break; case "ExpDateTime": model = list.SingleOrDefault(x => x.ExpDateTime == (DateTime)value); expression = x => x.ExpDateTime == (DateTime)value; break; case "CRT_DATETIME": model = list.SingleOrDefault(x => x.CRT_DATETIME == (DateTime)value); expression = x => x.CRT_DATETIME == (DateTime)value; break; case "CRT_USER_ID": model = list.SingleOrDefault(x => x.CRT_USER_ID == (string)value); expression = x => x.CRT_USER_ID == (string)value; break; case "MOD_DATETIME": model = list.SingleOrDefault(x => x.MOD_DATETIME == (DateTime)value); expression = x => x.MOD_DATETIME == (DateTime)value; break; case "MOD_USER_ID": model = list.SingleOrDefault(x => x.MOD_USER_ID == (string)value); expression = x => x.MOD_USER_ID == (string)value; break; case "LAST_UPDATE": model = list.SingleOrDefault(x => x.LAST_UPDATE == (DateTime)value); expression = x => x.LAST_UPDATE == (DateTime)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = COMPONENT00.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取COMPONENT00表记录时出现异常", e); return(null); } }