/// <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 <TechEmScoreInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { if (pPageIndex <= 1) { pPageIndex = 1; } List <TechEmScoreInfo> list = new List <TechEmScoreInfo>(); Query q = TechEmScore.CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression, pOrderBy.ToString()); TechEmScoreCollection collection = new TechEmScoreCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (TechEmScore techEmScore in collection) { TechEmScoreInfo techEmScoreInfo = new TechEmScoreInfo(); LoadFromDAL(techEmScoreInfo, techEmScore); list.Add(techEmScoreInfo); } pRecordCount = q.GetRecordCount(); return(list); }
//从后台获取数据 internal static void LoadFromDAL(TechEmScoreInfo pTechEmScoreInfo, TechEmScore pTechEmScore) { pTechEmScoreInfo.techEmScoreId = pTechEmScore.TechEmScoreId; pTechEmScoreInfo.selfPlan = pTechEmScore.SelfPlan; pTechEmScoreInfo.selfWorkTotal = pTechEmScore.SelfWorkTotal; pTechEmScoreInfo.selfWorkSpeed = pTechEmScore.SelfWorkSpeed; pTechEmScoreInfo.selfCommunicate = pTechEmScore.SelfCommunicate; pTechEmScoreInfo.selfDescipline = pTechEmScore.SelfDescipline; pTechEmScoreInfo.selfExecute = pTechEmScore.SelfExecute; pTechEmScoreInfo.selfRoute = pTechEmScore.SelfRoute; pTechEmScoreInfo.selfProfession = pTechEmScore.SelfProfession; pTechEmScoreInfo.selfAttitude = pTechEmScore.SelfAttitude; pTechEmScoreInfo.selfComplex = pTechEmScore.SelfComplex; pTechEmScoreInfo.selfSpeciality = pTechEmScore.SelfSpeciality; pTechEmScoreInfo.upPlan = pTechEmScore.UpPlan; pTechEmScoreInfo.upWorkTotal = pTechEmScore.UpWorkTotal; pTechEmScoreInfo.upWorkSpeed = pTechEmScore.UpWorkSpeed; pTechEmScoreInfo.upCommunicate = pTechEmScore.UpCommunicate; pTechEmScoreInfo.upDescipline = pTechEmScore.UpDescipline; pTechEmScoreInfo.upExecute = pTechEmScore.UpExecute; pTechEmScoreInfo.upRoute = pTechEmScore.UpRoute; pTechEmScoreInfo.upProfession = pTechEmScore.UpProfession; pTechEmScoreInfo.upAttitude = pTechEmScore.UpAttitude; pTechEmScoreInfo.upComplex = pTechEmScore.UpComplex; pTechEmScoreInfo.upSpeciality = pTechEmScore.UpSpeciality; pTechEmScoreInfo.sectPlan = pTechEmScore.SectPlan; pTechEmScoreInfo.sectWorkTotal = pTechEmScore.SectWorkTotal; pTechEmScoreInfo.sectWorkSpeed = pTechEmScore.SectWorkSpeed; pTechEmScoreInfo.sectCommunicate = pTechEmScore.SectCommunicate; pTechEmScoreInfo.sectDescipline = pTechEmScore.SectDescipline; pTechEmScoreInfo.sectExecute = pTechEmScore.SectExecute; pTechEmScoreInfo.sectRoute = pTechEmScore.SectRoute; pTechEmScoreInfo.sectProfession = pTechEmScore.SectProfession; pTechEmScoreInfo.sectAttitude = pTechEmScore.SectAttitude; pTechEmScoreInfo.sectComplex = pTechEmScore.SectComplex; pTechEmScoreInfo.sectSpeciality = pTechEmScore.SectSpeciality; pTechEmScoreInfo.planFinish = pTechEmScore.PlanFinish; pTechEmScoreInfo.actualFinish = pTechEmScore.ActualFinish; pTechEmScoreInfo.finishRate = pTechEmScore.FinishRate; pTechEmScoreInfo.finishScore = pTechEmScore.FinishScore; pTechEmScoreInfo.reason = pTechEmScore.Reason; pTechEmScoreInfo.addMinusSocre = pTechEmScore.AddMinusSocre; pTechEmScoreInfo.totalScore = pTechEmScore.TotalScore; pTechEmScoreInfo.upViews = pTechEmScore.UpViews; pTechEmScoreInfo.employeeId = pTechEmScore.EmployeeId; pTechEmScoreInfo.isSubmit = pTechEmScore.IsSubmit; pTechEmScoreInfo.dateSpan = pTechEmScore.DateSpan; pTechEmScoreInfo.yearId = pTechEmScore.YearId; pTechEmScoreInfo.monthId = pTechEmScore.MonthId; pTechEmScoreInfo.evaluateLevelId = pTechEmScore.EvaluateLevelId; pTechEmScoreInfo.Loaded = true; }
/// <summary> /// 保存 /// </summary> public override void Save() { if (!m_Loaded) //新增 { TechEmScore techEmScore = new TechEmScore(); SaveToDb(this, techEmScore, true); } else //修改 { TechEmScore techEmScore = new TechEmScore(techEmScoreId); if (techEmScore.IsNew) { throw new AppException("该数据已经不存在了"); } SaveToDb(this, techEmScore, false); } }
/// <summary> /// 删除 /// </summary> /// <returns>是否成功</returns> public override void Delete() { if (!m_Loaded) { throw new AppException("尚未初始化"); } bool result = (TechEmScore.Delete(TechEmScoreId) == 1); //更新缓存 if (result && CachedEntityCommander.IsTypeRegistered(typeof(TechEmScoreInfo))) { ResetCache(); } if (!result) { throw new AppException("删除失败,数据可能被删除"); } }
private void LoadFromId(int techEmScoreId) { if (CachedEntityCommander.IsTypeRegistered(typeof(TechEmScoreInfo))) { TechEmScoreInfo techEmScoreInfo = Find(GetList(), techEmScoreId); if (techEmScoreInfo == null) { throw new AppException("未能在缓存中找到相应的键值对象"); } Copy(techEmScoreInfo, this); } else { TechEmScore techEmScore = new TechEmScore(techEmScoreId); if (techEmScore.IsNew) { throw new AppException("尚未初始化"); } LoadFromDAL(this, techEmScore); } }
//从后台获取数据 internal static void LoadFromDAL(TechEmScoreInfo pTechEmScoreInfo, TechEmScore pTechEmScore) { pTechEmScoreInfo.techEmScoreId = pTechEmScore.TechEmScoreId; pTechEmScoreInfo.selfPlan = pTechEmScore.SelfPlan; pTechEmScoreInfo.selfWorkTotal = pTechEmScore.SelfWorkTotal; pTechEmScoreInfo.selfWorkSpeed = pTechEmScore.SelfWorkSpeed; pTechEmScoreInfo.selfCommunicate = pTechEmScore.SelfCommunicate; pTechEmScoreInfo.selfDescipline = pTechEmScore.SelfDescipline; pTechEmScoreInfo.selfExecute = pTechEmScore.SelfExecute; pTechEmScoreInfo.selfRoute = pTechEmScore.SelfRoute; pTechEmScoreInfo.selfProfession = pTechEmScore.SelfProfession; pTechEmScoreInfo.selfAttitude = pTechEmScore.SelfAttitude; pTechEmScoreInfo.selfComplex = pTechEmScore.SelfComplex; pTechEmScoreInfo.selfSpeciality = pTechEmScore.SelfSpeciality; pTechEmScoreInfo.upPlan = pTechEmScore.UpPlan; pTechEmScoreInfo.upWorkTotal = pTechEmScore.UpWorkTotal; pTechEmScoreInfo.upWorkSpeed = pTechEmScore.UpWorkSpeed; pTechEmScoreInfo.upCommunicate = pTechEmScore.UpCommunicate; pTechEmScoreInfo.upDescipline = pTechEmScore.UpDescipline; pTechEmScoreInfo.upExecute = pTechEmScore.UpExecute; pTechEmScoreInfo.upRoute = pTechEmScore.UpRoute; pTechEmScoreInfo.upProfession = pTechEmScore.UpProfession; pTechEmScoreInfo.upAttitude = pTechEmScore.UpAttitude; pTechEmScoreInfo.upComplex = pTechEmScore.UpComplex; pTechEmScoreInfo.upSpeciality = pTechEmScore.UpSpeciality; pTechEmScoreInfo.sectPlan = pTechEmScore.SectPlan; pTechEmScoreInfo.sectWorkTotal = pTechEmScore.SectWorkTotal; pTechEmScoreInfo.sectWorkSpeed = pTechEmScore.SectWorkSpeed; pTechEmScoreInfo.sectCommunicate = pTechEmScore.SectCommunicate; pTechEmScoreInfo.sectDescipline = pTechEmScore.SectDescipline; pTechEmScoreInfo.sectExecute = pTechEmScore.SectExecute; pTechEmScoreInfo.sectRoute = pTechEmScore.SectRoute; pTechEmScoreInfo.sectProfession = pTechEmScore.SectProfession; pTechEmScoreInfo.sectAttitude = pTechEmScore.SectAttitude; pTechEmScoreInfo.sectComplex = pTechEmScore.SectComplex; pTechEmScoreInfo.sectSpeciality = pTechEmScore.SectSpeciality; pTechEmScoreInfo.planFinish = pTechEmScore.PlanFinish; pTechEmScoreInfo.actualFinish = pTechEmScore.ActualFinish; pTechEmScoreInfo.finishRate = pTechEmScore.FinishRate; pTechEmScoreInfo.finishScore = pTechEmScore.FinishScore; pTechEmScoreInfo.reason = pTechEmScore.Reason; pTechEmScoreInfo.addMinusSocre = pTechEmScore.AddMinusSocre; pTechEmScoreInfo.totalScore = pTechEmScore.TotalScore; pTechEmScoreInfo.upViews = pTechEmScore.UpViews; pTechEmScoreInfo.employeeId = pTechEmScore.EmployeeId; pTechEmScoreInfo.isSubmit = pTechEmScore.IsSubmit; pTechEmScoreInfo.dateSpan = pTechEmScore.DateSpan; pTechEmScoreInfo.yearId = pTechEmScore.YearId; pTechEmScoreInfo.monthId = pTechEmScore.MonthId; pTechEmScoreInfo.evaluateLevelId = pTechEmScore.EvaluateLevelId; pTechEmScoreInfo.Loaded=true; }
/// <summary> /// 保存 /// </summary> public override void Save() { if(!m_Loaded)//新增 { TechEmScore techEmScore=new TechEmScore(); SaveToDb(this, techEmScore,true); } else//修改 { TechEmScore techEmScore=new TechEmScore(techEmScoreId); if(techEmScore.IsNew) throw new AppException("该数据已经不存在了"); SaveToDb(this, techEmScore,false); } }
private void LoadFromId(int techEmScoreId) { if (CachedEntityCommander.IsTypeRegistered(typeof(TechEmScoreInfo))) { TechEmScoreInfo techEmScoreInfo=Find(GetList(), techEmScoreId); if(techEmScoreInfo==null) throw new AppException("未能在缓存中找到相应的键值对象"); Copy(techEmScoreInfo, this); } else { TechEmScore techEmScore=new TechEmScore( techEmScoreId); if(techEmScore.IsNew) throw new AppException("尚未初始化"); LoadFromDAL(this, techEmScore); } }
//数据持久化 internal static void SaveToDb(TechEmScoreInfo pTechEmScoreInfo, TechEmScore pTechEmScore,bool pIsNew) { pTechEmScore.TechEmScoreId = pTechEmScoreInfo.techEmScoreId; pTechEmScore.SelfPlan = pTechEmScoreInfo.selfPlan; pTechEmScore.SelfWorkTotal = pTechEmScoreInfo.selfWorkTotal; pTechEmScore.SelfWorkSpeed = pTechEmScoreInfo.selfWorkSpeed; pTechEmScore.SelfCommunicate = pTechEmScoreInfo.selfCommunicate; pTechEmScore.SelfDescipline = pTechEmScoreInfo.selfDescipline; pTechEmScore.SelfExecute = pTechEmScoreInfo.selfExecute; pTechEmScore.SelfRoute = pTechEmScoreInfo.selfRoute; pTechEmScore.SelfProfession = pTechEmScoreInfo.selfProfession; pTechEmScore.SelfAttitude = pTechEmScoreInfo.selfAttitude; pTechEmScore.SelfComplex = pTechEmScoreInfo.selfComplex; pTechEmScore.SelfSpeciality = pTechEmScoreInfo.selfSpeciality; pTechEmScore.UpPlan = pTechEmScoreInfo.upPlan; pTechEmScore.UpWorkTotal = pTechEmScoreInfo.upWorkTotal; pTechEmScore.UpWorkSpeed = pTechEmScoreInfo.upWorkSpeed; pTechEmScore.UpCommunicate = pTechEmScoreInfo.upCommunicate; pTechEmScore.UpDescipline = pTechEmScoreInfo.upDescipline; pTechEmScore.UpExecute = pTechEmScoreInfo.upExecute; pTechEmScore.UpRoute = pTechEmScoreInfo.upRoute; pTechEmScore.UpProfession = pTechEmScoreInfo.upProfession; pTechEmScore.UpAttitude = pTechEmScoreInfo.upAttitude; pTechEmScore.UpComplex = pTechEmScoreInfo.upComplex; pTechEmScore.UpSpeciality = pTechEmScoreInfo.upSpeciality; pTechEmScore.SectPlan = pTechEmScoreInfo.sectPlan; pTechEmScore.SectWorkTotal = pTechEmScoreInfo.sectWorkTotal; pTechEmScore.SectWorkSpeed = pTechEmScoreInfo.sectWorkSpeed; pTechEmScore.SectCommunicate = pTechEmScoreInfo.sectCommunicate; pTechEmScore.SectDescipline = pTechEmScoreInfo.sectDescipline; pTechEmScore.SectExecute = pTechEmScoreInfo.sectExecute; pTechEmScore.SectRoute = pTechEmScoreInfo.sectRoute; pTechEmScore.SectProfession = pTechEmScoreInfo.sectProfession; pTechEmScore.SectAttitude = pTechEmScoreInfo.sectAttitude; pTechEmScore.SectComplex = pTechEmScoreInfo.sectComplex; pTechEmScore.SectSpeciality = pTechEmScoreInfo.sectSpeciality; pTechEmScore.PlanFinish = pTechEmScoreInfo.planFinish; pTechEmScore.ActualFinish = pTechEmScoreInfo.actualFinish; pTechEmScore.FinishRate = pTechEmScoreInfo.finishRate; pTechEmScore.FinishScore = pTechEmScoreInfo.finishScore; pTechEmScore.Reason = pTechEmScoreInfo.reason; pTechEmScore.AddMinusSocre = pTechEmScoreInfo.addMinusSocre; pTechEmScore.TotalScore = pTechEmScoreInfo.totalScore; pTechEmScore.UpViews = pTechEmScoreInfo.upViews; pTechEmScore.EmployeeId = pTechEmScoreInfo.employeeId; pTechEmScore.IsSubmit = pTechEmScoreInfo.isSubmit; pTechEmScore.DateSpan = pTechEmScoreInfo.dateSpan; pTechEmScore.YearId = pTechEmScoreInfo.yearId; pTechEmScore.MonthId = pTechEmScoreInfo.monthId; pTechEmScore.EvaluateLevelId = pTechEmScoreInfo.evaluateLevelId; pTechEmScore.IsNew=pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pTechEmScore.Save(UserName); } catch(Exception ex) { LogManager.getInstance().getLogger(typeof(TechEmScoreInfo)).Error(ex); if(ex.Message.Contains("插入重复键"))//违反了唯一键 { throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pTechEmScoreInfo.techEmScoreId = pTechEmScore.TechEmScoreId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(TechEmScoreInfo))) { ResetCache(); } }
//数据持久化 internal static void SaveToDb(TechEmScoreInfo pTechEmScoreInfo, TechEmScore pTechEmScore, bool pIsNew) { pTechEmScore.TechEmScoreId = pTechEmScoreInfo.techEmScoreId; pTechEmScore.SelfPlan = pTechEmScoreInfo.selfPlan; pTechEmScore.SelfWorkTotal = pTechEmScoreInfo.selfWorkTotal; pTechEmScore.SelfWorkSpeed = pTechEmScoreInfo.selfWorkSpeed; pTechEmScore.SelfCommunicate = pTechEmScoreInfo.selfCommunicate; pTechEmScore.SelfDescipline = pTechEmScoreInfo.selfDescipline; pTechEmScore.SelfExecute = pTechEmScoreInfo.selfExecute; pTechEmScore.SelfRoute = pTechEmScoreInfo.selfRoute; pTechEmScore.SelfProfession = pTechEmScoreInfo.selfProfession; pTechEmScore.SelfAttitude = pTechEmScoreInfo.selfAttitude; pTechEmScore.SelfComplex = pTechEmScoreInfo.selfComplex; pTechEmScore.SelfSpeciality = pTechEmScoreInfo.selfSpeciality; pTechEmScore.UpPlan = pTechEmScoreInfo.upPlan; pTechEmScore.UpWorkTotal = pTechEmScoreInfo.upWorkTotal; pTechEmScore.UpWorkSpeed = pTechEmScoreInfo.upWorkSpeed; pTechEmScore.UpCommunicate = pTechEmScoreInfo.upCommunicate; pTechEmScore.UpDescipline = pTechEmScoreInfo.upDescipline; pTechEmScore.UpExecute = pTechEmScoreInfo.upExecute; pTechEmScore.UpRoute = pTechEmScoreInfo.upRoute; pTechEmScore.UpProfession = pTechEmScoreInfo.upProfession; pTechEmScore.UpAttitude = pTechEmScoreInfo.upAttitude; pTechEmScore.UpComplex = pTechEmScoreInfo.upComplex; pTechEmScore.UpSpeciality = pTechEmScoreInfo.upSpeciality; pTechEmScore.SectPlan = pTechEmScoreInfo.sectPlan; pTechEmScore.SectWorkTotal = pTechEmScoreInfo.sectWorkTotal; pTechEmScore.SectWorkSpeed = pTechEmScoreInfo.sectWorkSpeed; pTechEmScore.SectCommunicate = pTechEmScoreInfo.sectCommunicate; pTechEmScore.SectDescipline = pTechEmScoreInfo.sectDescipline; pTechEmScore.SectExecute = pTechEmScoreInfo.sectExecute; pTechEmScore.SectRoute = pTechEmScoreInfo.sectRoute; pTechEmScore.SectProfession = pTechEmScoreInfo.sectProfession; pTechEmScore.SectAttitude = pTechEmScoreInfo.sectAttitude; pTechEmScore.SectComplex = pTechEmScoreInfo.sectComplex; pTechEmScore.SectSpeciality = pTechEmScoreInfo.sectSpeciality; pTechEmScore.PlanFinish = pTechEmScoreInfo.planFinish; pTechEmScore.ActualFinish = pTechEmScoreInfo.actualFinish; pTechEmScore.FinishRate = pTechEmScoreInfo.finishRate; pTechEmScore.FinishScore = pTechEmScoreInfo.finishScore; pTechEmScore.Reason = pTechEmScoreInfo.reason; pTechEmScore.AddMinusSocre = pTechEmScoreInfo.addMinusSocre; pTechEmScore.TotalScore = pTechEmScoreInfo.totalScore; pTechEmScore.UpViews = pTechEmScoreInfo.upViews; pTechEmScore.EmployeeId = pTechEmScoreInfo.employeeId; pTechEmScore.IsSubmit = pTechEmScoreInfo.isSubmit; pTechEmScore.DateSpan = pTechEmScoreInfo.dateSpan; pTechEmScore.YearId = pTechEmScoreInfo.yearId; pTechEmScore.MonthId = pTechEmScoreInfo.monthId; pTechEmScore.EvaluateLevelId = pTechEmScoreInfo.evaluateLevelId; pTechEmScore.IsNew = pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pTechEmScore.Save(UserName); } catch (Exception ex) { LogManager.getInstance().getLogger(typeof(TechEmScoreInfo)).Error(ex); if (ex.Message.Contains("插入重复键")) //违反了唯一键 { throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pTechEmScoreInfo.techEmScoreId = pTechEmScore.TechEmScoreId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(TechEmScoreInfo))) { ResetCache(); } }
public static void DelTechEmScore(int ScoreId) { TechEmScore.Delete(ScoreId); }