/// <summary> /// 给实体赋值 /// </summary> /// <param name="model">实体</param> /// <param name="colName">列名</param> /// <param name="value">值</param> public void SetModelValue(DataAccess.Model.V_PRODUCT_COMPONENT00 model, string colName, object value) { if (model == null || string.IsNullOrEmpty(colName)) { return; } //返回指定条件的实体 switch (colName) { case "Id": model.Id = (int)value; break; case "COM00_ID": model.COM00_ID = (string)value; break; case "COM00_PROD_ID": model.COM00_PROD_ID = (string)value; break; case "COM00_NAME1": model.COM00_NAME1 = (string)value; break; case "COM00_NUM": model.COM00_NUM = (int)value; break; case "COM00_WEIGHT": model.COM00_WEIGHT = (decimal)value; break; case "COM00_DEFAULTCOM": model.COM00_DEFAULTCOM = ConvertHelper.Ctinyint(value); break; case "COM00_QUAN1": model.COM00_QUAN1 = (int)value; break; case "COM00_QUAN2": model.COM00_QUAN2 = (int)value; break; case "COM00_DefQuan": model.COM00_DefQuan = (int)value; break; case "COM00_BOM_Cost": model.COM00_BOM_Cost = (decimal)value; break; case "COM00_ExpDateTime": model.COM00_ExpDateTime = (string)value; break; } }
/// <summary> /// 更新IIS缓存中指定Id记录 /// </summary> /// <param name="model">记录实体</param> public void SetModelForCache(DataAccess.Model.V_PRODUCT_COMPONENT00 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.V_PRODUCT_COMPONENT00 model, Dictionary <string, object> dic) { if (model == null || dic == null) { return; } //遍历字典,逐个给字段赋值 foreach (var d in dic) { SetModelValue(model, d.Key, d.Value); } }
/// <summary> /// 返回实体中指定字段名的值 /// </summary> /// <param name="model">实体</param> /// <param name="colName">获取的字段名</param> /// <returns></returns> private object GetFieldValue(DataAccess.Model.V_PRODUCT_COMPONENT00 model, string colName) { if (model == null || string.IsNullOrEmpty(colName)) { return(null); } //返回指定的列值 switch (colName) { case "Id": return(model.Id); case "COM00_ID": return(model.COM00_ID); case "COM00_PROD_ID": return(model.COM00_PROD_ID); case "COM00_NAME1": return(model.COM00_NAME1); case "COM00_NUM": return(model.COM00_NUM); case "COM00_WEIGHT": return(model.COM00_WEIGHT); case "COM00_DEFAULTCOM": return(model.COM00_DEFAULTCOM); case "COM00_QUAN1": return(model.COM00_QUAN1); case "COM00_QUAN2": return(model.COM00_QUAN2); case "COM00_DefQuan": return(model.COM00_DefQuan); case "COM00_BOM_Cost": return(model.COM00_BOM_Cost); case "COM00_ExpDateTime": return(model.COM00_ExpDateTime); } return(null); }
/// <summary> /// 将V_PRODUCT_COMPONENT00记录实体由普通的实体(DataAccess.Model.V_PRODUCT_COMPONENT00)转换为SubSonic插件生成的实体 /// </summary> /// <param name="model">普通的实体(DataAccess.Model.V_PRODUCT_COMPONENT00)</param> /// <returns>V_PRODUCT_COMPONENT00</returns> public V_PRODUCT_COMPONENT00 Transform(DataAccess.Model.V_PRODUCT_COMPONENT00 model) { if (model == null) { return(null); } return(new V_PRODUCT_COMPONENT00 { Id = model.Id, COM00_ID = model.COM00_ID, COM00_PROD_ID = model.COM00_PROD_ID, COM00_NAME1 = model.COM00_NAME1, COM00_NUM = model.COM00_NUM, COM00_WEIGHT = model.COM00_WEIGHT, COM00_DEFAULTCOM = model.COM00_DEFAULTCOM, COM00_QUAN1 = model.COM00_QUAN1, COM00_QUAN2 = model.COM00_QUAN2, COM00_DefQuan = model.COM00_DefQuan, COM00_BOM_Cost = model.COM00_BOM_Cost, COM00_ExpDateTime = model.COM00_ExpDateTime, }); }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.V_PRODUCT_COMPONENT00</returns> public DataAccess.Model.V_PRODUCT_COMPONENT00 GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.V_PRODUCT_COMPONENT00 model = null; Expression <Func <V_PRODUCT_COMPONENT00, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (int)value); expression = x => x.Id == (int)value; break; case "COM00_ID": model = list.SingleOrDefault(x => x.COM00_ID == (string)value); expression = x => x.COM00_ID == (string)value; break; case "COM00_PROD_ID": model = list.SingleOrDefault(x => x.COM00_PROD_ID == (string)value); expression = x => x.COM00_PROD_ID == (string)value; break; case "COM00_NAME1": model = list.SingleOrDefault(x => x.COM00_NAME1 == (string)value); expression = x => x.COM00_NAME1 == (string)value; break; case "COM00_NUM": model = list.SingleOrDefault(x => x.COM00_NUM == (int)value); expression = x => x.COM00_NUM == (int)value; break; case "COM00_WEIGHT": model = list.SingleOrDefault(x => x.COM00_WEIGHT == (decimal)value); expression = x => x.COM00_WEIGHT == (decimal)value; break; case "COM00_DEFAULTCOM": model = list.SingleOrDefault(x => x.COM00_DEFAULTCOM == (byte)value); expression = x => x.COM00_DEFAULTCOM == (byte)value; break; case "COM00_QUAN1": model = list.SingleOrDefault(x => x.COM00_QUAN1 == (int)value); expression = x => x.COM00_QUAN1 == (int)value; break; case "COM00_QUAN2": model = list.SingleOrDefault(x => x.COM00_QUAN2 == (int)value); expression = x => x.COM00_QUAN2 == (int)value; break; case "COM00_DefQuan": model = list.SingleOrDefault(x => x.COM00_DefQuan == (int)value); expression = x => x.COM00_DefQuan == (int)value; break; case "COM00_BOM_Cost": model = list.SingleOrDefault(x => x.COM00_BOM_Cost == (decimal)value); expression = x => x.COM00_BOM_Cost == (decimal)value; break; case "COM00_ExpDateTime": model = list.SingleOrDefault(x => x.COM00_ExpDateTime == (string)value); expression = x => x.COM00_ExpDateTime == (string)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = V_PRODUCT_COMPONENT00.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取V_PRODUCT_COMPONENT00表记录时出现异常", e); return(null); } }