/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List <ToolNumInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { if (pPageIndex <= 1) { pPageIndex = 1; } List <ToolNumInfo> list = new List <ToolNumInfo>(); Query q = ToolNum.CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression, pOrderBy.ToString()); ToolNumCollection collection = new ToolNumCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (ToolNum toolNum in collection) { ToolNumInfo toolNumInfo = new ToolNumInfo(); LoadFromDAL(toolNumInfo, toolNum); list.Add(toolNumInfo); } pRecordCount = q.GetRecordCount(); return(list); }
/// <summary> /// 保存 /// </summary> public override void Save() { if (!m_Loaded) //新增 { ToolNum toolNum = new ToolNum(); SaveToDb(this, toolNum, true); } else //修改 { ToolNum toolNum = new ToolNum(toolNumId); if (toolNum.IsNew) { throw new AppException("该数据已经不存在了"); } SaveToDb(this, toolNum, false); } }
//从后台获取数据 internal static void LoadFromDAL(ToolNumInfo pToolNumInfo, ToolNum pToolNum) { pToolNumInfo.toolNumId = pToolNum.ToolNumId; pToolNumInfo.num1 = pToolNum.Num1; pToolNumInfo.num2 = pToolNum.Num2; pToolNumInfo.num3 = pToolNum.Num3; pToolNumInfo.num4 = pToolNum.Num4; pToolNumInfo.num5 = pToolNum.Num5; pToolNumInfo.num6 = pToolNum.Num6; pToolNumInfo.num7 = pToolNum.Num7; pToolNumInfo.num8 = pToolNum.Num8; pToolNumInfo.num9 = pToolNum.Num9; pToolNumInfo.num10 = pToolNum.Num10; pToolNumInfo.num11 = pToolNum.Num11; pToolNumInfo.num12 = pToolNum.Num12; pToolNumInfo.num13 = pToolNum.Num13; pToolNumInfo.num14 = pToolNum.Num14; pToolNumInfo.num15 = pToolNum.Num15; pToolNumInfo.num16 = pToolNum.Num16; pToolNumInfo.num17 = pToolNum.Num17; pToolNumInfo.num18 = pToolNum.Num18; pToolNumInfo.num19 = pToolNum.Num19; pToolNumInfo.num20 = pToolNum.Num20; pToolNumInfo.num21 = pToolNum.Num21; pToolNumInfo.num22 = pToolNum.Num22; pToolNumInfo.num23 = pToolNum.Num23; pToolNumInfo.num24 = pToolNum.Num24; pToolNumInfo.num25 = pToolNum.Num25; pToolNumInfo.num26 = pToolNum.Num26; pToolNumInfo.num27 = pToolNum.Num27; pToolNumInfo.num28 = pToolNum.Num28; pToolNumInfo.num29 = pToolNum.Num29; pToolNumInfo.num30 = pToolNum.Num30; pToolNumInfo.num31 = pToolNum.Num31; pToolNumInfo.num32 = pToolNum.Num32; pToolNumInfo.num33 = pToolNum.Num33; pToolNumInfo.num34 = pToolNum.Num34; pToolNumInfo.num35 = pToolNum.Num35; pToolNumInfo.num36 = pToolNum.Num36; pToolNumInfo.num37 = pToolNum.Num37; pToolNumInfo.num38 = pToolNum.Num38; pToolNumInfo.num39 = pToolNum.Num39; pToolNumInfo.num40 = pToolNum.Num40; pToolNumInfo.Loaded = true; }
/// <summary> /// 删除 /// </summary> /// <returns>是否成功</returns> public override void Delete() { if (!m_Loaded) { throw new AppException("尚未初始化"); } bool result = (ToolNum.Delete(ToolNumId) == 1); //更新缓存 if (result && CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo))) { ResetCache(); } if (!result) { throw new AppException("删除失败,数据可能被删除"); } }
private void LoadFromId(int toolNumId) { if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo))) { ToolNumInfo toolNumInfo = Find(GetList(), toolNumId); if (toolNumInfo == null) { throw new AppException("未能在缓存中找到相应的键值对象"); } Copy(toolNumInfo, this); } else { ToolNum toolNum = new ToolNum(toolNumId); if (toolNum.IsNew) { throw new AppException("尚未初始化"); } LoadFromDAL(this, toolNum); } }
//数据持久化 internal static void SaveToDb(ToolNumInfo pToolNumInfo, ToolNum pToolNum, bool pIsNew) { pToolNum.ToolNumId = pToolNumInfo.toolNumId; pToolNum.Num1 = pToolNumInfo.num1; pToolNum.Num2 = pToolNumInfo.num2; pToolNum.Num3 = pToolNumInfo.num3; pToolNum.Num4 = pToolNumInfo.num4; pToolNum.Num5 = pToolNumInfo.num5; pToolNum.Num6 = pToolNumInfo.num6; pToolNum.Num7 = pToolNumInfo.num7; pToolNum.Num8 = pToolNumInfo.num8; pToolNum.Num9 = pToolNumInfo.num9; pToolNum.Num10 = pToolNumInfo.num10; pToolNum.Num11 = pToolNumInfo.num11; pToolNum.Num12 = pToolNumInfo.num12; pToolNum.Num13 = pToolNumInfo.num13; pToolNum.Num14 = pToolNumInfo.num14; pToolNum.Num15 = pToolNumInfo.num15; pToolNum.Num16 = pToolNumInfo.num16; pToolNum.Num17 = pToolNumInfo.num17; pToolNum.Num18 = pToolNumInfo.num18; pToolNum.Num19 = pToolNumInfo.num19; pToolNum.Num20 = pToolNumInfo.num20; pToolNum.Num21 = pToolNumInfo.num21; pToolNum.Num22 = pToolNumInfo.num22; pToolNum.Num23 = pToolNumInfo.num23; pToolNum.Num24 = pToolNumInfo.num24; pToolNum.Num25 = pToolNumInfo.num25; pToolNum.Num26 = pToolNumInfo.num26; pToolNum.Num27 = pToolNumInfo.num27; pToolNum.Num28 = pToolNumInfo.num28; pToolNum.Num29 = pToolNumInfo.num29; pToolNum.Num30 = pToolNumInfo.num30; pToolNum.Num31 = pToolNumInfo.num31; pToolNum.Num32 = pToolNumInfo.num32; pToolNum.Num33 = pToolNumInfo.num33; pToolNum.Num34 = pToolNumInfo.num34; pToolNum.Num35 = pToolNumInfo.num35; pToolNum.Num36 = pToolNumInfo.num36; pToolNum.Num37 = pToolNumInfo.num37; pToolNum.Num38 = pToolNumInfo.num38; pToolNum.Num39 = pToolNumInfo.num39; pToolNum.Num40 = pToolNumInfo.num40; pToolNum.IsNew = pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pToolNum.Save(UserName); } catch (Exception ex) { LogManager.getInstance().getLogger(typeof(ToolNumInfo)).Error(ex); if (ex.Message.Contains("插入重复键")) //违反了唯一键 { throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pToolNumInfo.toolNumId = pToolNum.ToolNumId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo))) { ResetCache(); } }
//数据持久化 internal static void SaveToDb(ToolNumInfo pToolNumInfo, ToolNum pToolNum,bool pIsNew) { pToolNum.ToolNumId = pToolNumInfo.toolNumId; pToolNum.Num1 = pToolNumInfo.num1; pToolNum.Num2 = pToolNumInfo.num2; pToolNum.Num3 = pToolNumInfo.num3; pToolNum.Num4 = pToolNumInfo.num4; pToolNum.Num5 = pToolNumInfo.num5; pToolNum.Num6 = pToolNumInfo.num6; pToolNum.Num7 = pToolNumInfo.num7; pToolNum.Num8 = pToolNumInfo.num8; pToolNum.Num9 = pToolNumInfo.num9; pToolNum.Num10 = pToolNumInfo.num10; pToolNum.Num11 = pToolNumInfo.num11; pToolNum.Num12 = pToolNumInfo.num12; pToolNum.Num13 = pToolNumInfo.num13; pToolNum.Num14 = pToolNumInfo.num14; pToolNum.Num15 = pToolNumInfo.num15; pToolNum.Num16 = pToolNumInfo.num16; pToolNum.Num17 = pToolNumInfo.num17; pToolNum.Num18 = pToolNumInfo.num18; pToolNum.Num19 = pToolNumInfo.num19; pToolNum.Num20 = pToolNumInfo.num20; pToolNum.Num21 = pToolNumInfo.num21; pToolNum.Num22 = pToolNumInfo.num22; pToolNum.Num23 = pToolNumInfo.num23; pToolNum.Num24 = pToolNumInfo.num24; pToolNum.Num25 = pToolNumInfo.num25; pToolNum.Num26 = pToolNumInfo.num26; pToolNum.Num27 = pToolNumInfo.num27; pToolNum.Num28 = pToolNumInfo.num28; pToolNum.Num29 = pToolNumInfo.num29; pToolNum.Num30 = pToolNumInfo.num30; pToolNum.Num31 = pToolNumInfo.num31; pToolNum.Num32 = pToolNumInfo.num32; pToolNum.Num33 = pToolNumInfo.num33; pToolNum.Num34 = pToolNumInfo.num34; pToolNum.Num35 = pToolNumInfo.num35; pToolNum.Num36 = pToolNumInfo.num36; pToolNum.Num37 = pToolNumInfo.num37; pToolNum.Num38 = pToolNumInfo.num38; pToolNum.Num39 = pToolNumInfo.num39; pToolNum.Num40 = pToolNumInfo.num40; pToolNum.IsNew=pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pToolNum.Save(UserName); } catch(Exception ex) { LogManager.getInstance().getLogger(typeof(ToolNumInfo)).Error(ex); if(ex.Message.Contains("插入重复键"))//违反了唯一键 { throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pToolNumInfo.toolNumId = pToolNum.ToolNumId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo))) { ResetCache(); } }
//从后台获取数据 internal static void LoadFromDAL(ToolNumInfo pToolNumInfo, ToolNum pToolNum) { pToolNumInfo.toolNumId = pToolNum.ToolNumId; pToolNumInfo.num1 = pToolNum.Num1; pToolNumInfo.num2 = pToolNum.Num2; pToolNumInfo.num3 = pToolNum.Num3; pToolNumInfo.num4 = pToolNum.Num4; pToolNumInfo.num5 = pToolNum.Num5; pToolNumInfo.num6 = pToolNum.Num6; pToolNumInfo.num7 = pToolNum.Num7; pToolNumInfo.num8 = pToolNum.Num8; pToolNumInfo.num9 = pToolNum.Num9; pToolNumInfo.num10 = pToolNum.Num10; pToolNumInfo.num11 = pToolNum.Num11; pToolNumInfo.num12 = pToolNum.Num12; pToolNumInfo.num13 = pToolNum.Num13; pToolNumInfo.num14 = pToolNum.Num14; pToolNumInfo.num15 = pToolNum.Num15; pToolNumInfo.num16 = pToolNum.Num16; pToolNumInfo.num17 = pToolNum.Num17; pToolNumInfo.num18 = pToolNum.Num18; pToolNumInfo.num19 = pToolNum.Num19; pToolNumInfo.num20 = pToolNum.Num20; pToolNumInfo.num21 = pToolNum.Num21; pToolNumInfo.num22 = pToolNum.Num22; pToolNumInfo.num23 = pToolNum.Num23; pToolNumInfo.num24 = pToolNum.Num24; pToolNumInfo.num25 = pToolNum.Num25; pToolNumInfo.num26 = pToolNum.Num26; pToolNumInfo.num27 = pToolNum.Num27; pToolNumInfo.num28 = pToolNum.Num28; pToolNumInfo.num29 = pToolNum.Num29; pToolNumInfo.num30 = pToolNum.Num30; pToolNumInfo.num31 = pToolNum.Num31; pToolNumInfo.num32 = pToolNum.Num32; pToolNumInfo.num33 = pToolNum.Num33; pToolNumInfo.num34 = pToolNum.Num34; pToolNumInfo.num35 = pToolNum.Num35; pToolNumInfo.num36 = pToolNum.Num36; pToolNumInfo.num37 = pToolNum.Num37; pToolNumInfo.num38 = pToolNum.Num38; pToolNumInfo.num39 = pToolNum.Num39; pToolNumInfo.num40 = pToolNum.Num40; pToolNumInfo.Loaded=true; }
/// <summary> /// 保存 /// </summary> public override void Save() { if(!m_Loaded)//新增 { ToolNum toolNum=new ToolNum(); SaveToDb(this, toolNum,true); } else//修改 { ToolNum toolNum=new ToolNum(toolNumId); if(toolNum.IsNew) throw new AppException("该数据已经不存在了"); SaveToDb(this, toolNum,false); } }
private void LoadFromId(int toolNumId) { if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo))) { ToolNumInfo toolNumInfo=Find(GetList(), toolNumId); if(toolNumInfo==null) throw new AppException("未能在缓存中找到相应的键值对象"); Copy(toolNumInfo, this); } else { ToolNum toolNum=new ToolNum( toolNumId); if(toolNum.IsNew) throw new AppException("尚未初始化"); LoadFromDAL(this, toolNum); } }