/// <summary> /// 更新IIS缓存中指定Id记录 /// </summary> /// <param name="model">记录实体</param> public void SetModelForCache(DataAccess.Model.EMPLOYEE model) { //从缓存中读取记录列表 var list = GetList(); //从缓存中删除记录 DelCache(model.Id); //添加记录 list.Add(model); }
/// <summary> /// 给实体赋值 /// </summary> /// <param name="model">实体</param> /// <param name="dic">列名与值</param> public void SetModelValue(DataAccess.Model.EMPLOYEE model, Dictionary <string, object> dic) { if (model == null || dic == null) { return; } //遍历字典,逐个给字段赋值 foreach (var d in dic) { SetModelValue(model, d.Key, d.Value); } }
/// <summary> /// 将EMPLOYEE记录实体由普通的实体(DataAccess.Model.EMPLOYEE)转换为SubSonic插件生成的实体 /// </summary> /// <param name="model">普通的实体(DataAccess.Model.EMPLOYEE)</param> /// <returns>EMPLOYEE</returns> public EMPLOYEE Transform(DataAccess.Model.EMPLOYEE model) { if (model == null) { return(null); } return(new EMPLOYEE { Id = model.Id, EMP_ID = model.EMP_ID, EMP_NAME = model.EMP_NAME, EMP_Birthday = model.EMP_Birthday, EMP_ADD = model.EMP_ADD, EMP_TEL = model.EMP_TEL, EMP_ZIP = model.EMP_ZIP, EMP_EMAIL = model.EMP_EMAIL, EMP_MOBILE = model.EMP_MOBILE, EMP_MEMO = model.EMP_MEMO, EMP_ENABLE = model.EMP_ENABLE, EMP_SEX = model.EMP_SEX, EMP_CodeID = model.EMP_CodeID, EMP_LEVEL = model.EMP_LEVEL, EMP_PASSWORD = model.EMP_PASSWORD, EMP_BDATE = model.EMP_BDATE, EMP_EDATE = model.EMP_EDATE, EMP_WAGE = model.EMP_WAGE, EMP_Education = model.EMP_Education, CRT_DATETIME = model.CRT_DATETIME, CRT_USER_ID = model.CRT_USER_ID, MOD_DATETIME = model.MOD_DATETIME, MOD_USER_ID = model.MOD_USER_ID, LAST_UPDATE = model.LAST_UPDATE, STATUS = model.STATUS, }); }
/// <summary> /// 给实体赋值 /// </summary> /// <param name="model">实体</param> /// <param name="colName">列名</param> /// <param name="value">值</param> public void SetModelValue(DataAccess.Model.EMPLOYEE model, string colName, object value) { if (model == null || string.IsNullOrEmpty(colName)) { return; } //返回指定条件的实体 switch (colName) { case "Id": model.Id = (int)value; break; case "EMP_ID": model.EMP_ID = (string)value; break; case "EMP_NAME": model.EMP_NAME = (string)value; break; case "EMP_Birthday": model.EMP_Birthday = (DateTime)value; break; case "EMP_ADD": model.EMP_ADD = (string)value; break; case "EMP_TEL": model.EMP_TEL = (string)value; break; case "EMP_ZIP": model.EMP_ZIP = (string)value; break; case "EMP_EMAIL": model.EMP_EMAIL = (string)value; break; case "EMP_MOBILE": model.EMP_MOBILE = (string)value; break; case "EMP_MEMO": model.EMP_MEMO = (string)value; break; case "EMP_ENABLE": model.EMP_ENABLE = (int)value; break; case "EMP_SEX": model.EMP_SEX = (int)value; break; case "EMP_CodeID": model.EMP_CodeID = (string)value; break; case "EMP_LEVEL": model.EMP_LEVEL = (int)value; break; case "EMP_PASSWORD": model.EMP_PASSWORD = (string)value; break; case "EMP_BDATE": model.EMP_BDATE = (DateTime)value; break; case "EMP_EDATE": model.EMP_EDATE = (DateTime)value; break; case "EMP_WAGE": model.EMP_WAGE = (decimal)value; break; case "EMP_Education": model.EMP_Education = (int)value; break; case "CRT_DATETIME": model.CRT_DATETIME = (DateTime)value; break; case "CRT_USER_ID": model.CRT_USER_ID = (string)value; break; case "MOD_DATETIME": model.MOD_DATETIME = (DateTime)value; break; case "MOD_USER_ID": model.MOD_USER_ID = (string)value; break; case "LAST_UPDATE": model.LAST_UPDATE = (DateTime)value; break; case "STATUS": model.STATUS = ConvertHelper.Ctinyint(value); break; } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.EMPLOYEE</returns> public DataAccess.Model.EMPLOYEE GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.EMPLOYEE model = null; Expression <Func <EMPLOYEE, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (int)value); expression = x => x.Id == (int)value; break; case "EMP_ID": model = list.SingleOrDefault(x => x.EMP_ID == (string)value); expression = x => x.EMP_ID == (string)value; break; case "EMP_NAME": model = list.SingleOrDefault(x => x.EMP_NAME == (string)value); expression = x => x.EMP_NAME == (string)value; break; case "EMP_Birthday": model = list.SingleOrDefault(x => x.EMP_Birthday == (DateTime)value); expression = x => x.EMP_Birthday == (DateTime)value; break; case "EMP_ADD": model = list.SingleOrDefault(x => x.EMP_ADD == (string)value); expression = x => x.EMP_ADD == (string)value; break; case "EMP_TEL": model = list.SingleOrDefault(x => x.EMP_TEL == (string)value); expression = x => x.EMP_TEL == (string)value; break; case "EMP_ZIP": model = list.SingleOrDefault(x => x.EMP_ZIP == (string)value); expression = x => x.EMP_ZIP == (string)value; break; case "EMP_EMAIL": model = list.SingleOrDefault(x => x.EMP_EMAIL == (string)value); expression = x => x.EMP_EMAIL == (string)value; break; case "EMP_MOBILE": model = list.SingleOrDefault(x => x.EMP_MOBILE == (string)value); expression = x => x.EMP_MOBILE == (string)value; break; case "EMP_MEMO": model = list.SingleOrDefault(x => x.EMP_MEMO == (string)value); expression = x => x.EMP_MEMO == (string)value; break; case "EMP_ENABLE": model = list.SingleOrDefault(x => x.EMP_ENABLE == (int)value); expression = x => x.EMP_ENABLE == (int)value; break; case "EMP_SEX": model = list.SingleOrDefault(x => x.EMP_SEX == (int)value); expression = x => x.EMP_SEX == (int)value; break; case "EMP_CodeID": model = list.SingleOrDefault(x => x.EMP_CodeID == (string)value); expression = x => x.EMP_CodeID == (string)value; break; case "EMP_LEVEL": model = list.SingleOrDefault(x => x.EMP_LEVEL == (int)value); expression = x => x.EMP_LEVEL == (int)value; break; case "EMP_PASSWORD": model = list.SingleOrDefault(x => x.EMP_PASSWORD == (string)value); expression = x => x.EMP_PASSWORD == (string)value; break; case "EMP_BDATE": model = list.SingleOrDefault(x => x.EMP_BDATE == (DateTime)value); expression = x => x.EMP_BDATE == (DateTime)value; break; case "EMP_EDATE": model = list.SingleOrDefault(x => x.EMP_EDATE == (DateTime)value); expression = x => x.EMP_EDATE == (DateTime)value; break; case "EMP_WAGE": model = list.SingleOrDefault(x => x.EMP_WAGE == (decimal)value); expression = x => x.EMP_WAGE == (decimal)value; break; case "EMP_Education": model = list.SingleOrDefault(x => x.EMP_Education == (int)value); expression = x => x.EMP_Education == (int)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; case "STATUS": model = list.SingleOrDefault(x => x.STATUS == (byte)value); expression = x => x.STATUS == (byte)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = EMPLOYEE.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取EMPLOYEE表记录时出现异常", e); return(null); } }
/// <summary> /// 返回实体中指定字段名的值 /// </summary> /// <param name="model">实体</param> /// <param name="colName">获取的字段名</param> /// <returns></returns> private object GetFieldValue(DataAccess.Model.EMPLOYEE model, string colName) { if (model == null || string.IsNullOrEmpty(colName)) { return(null); } //返回指定的列值 switch (colName) { case "Id": return(model.Id); case "EMP_ID": return(model.EMP_ID); case "EMP_NAME": return(model.EMP_NAME); case "EMP_Birthday": return(model.EMP_Birthday); case "EMP_ADD": return(model.EMP_ADD); case "EMP_TEL": return(model.EMP_TEL); case "EMP_ZIP": return(model.EMP_ZIP); case "EMP_EMAIL": return(model.EMP_EMAIL); case "EMP_MOBILE": return(model.EMP_MOBILE); case "EMP_MEMO": return(model.EMP_MEMO); case "EMP_ENABLE": return(model.EMP_ENABLE); case "EMP_SEX": return(model.EMP_SEX); case "EMP_CodeID": return(model.EMP_CodeID); case "EMP_LEVEL": return(model.EMP_LEVEL); case "EMP_PASSWORD": return(model.EMP_PASSWORD); case "EMP_BDATE": return(model.EMP_BDATE); case "EMP_EDATE": return(model.EMP_EDATE); case "EMP_WAGE": return(model.EMP_WAGE); case "EMP_Education": return(model.EMP_Education); case "CRT_DATETIME": return(model.CRT_DATETIME); case "CRT_USER_ID": return(model.CRT_USER_ID); case "MOD_DATETIME": return(model.MOD_DATETIME); case "MOD_USER_ID": return(model.MOD_USER_ID); case "LAST_UPDATE": return(model.LAST_UPDATE); case "STATUS": return(model.STATUS); } return(null); }