/// <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);
}
