/// <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 <TechMaScoreInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <TechMaScoreInfo> list = new List <TechMaScoreInfo>();
Query q = TechMaScore.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
TechMaScoreCollection collection = new TechMaScoreCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (TechMaScore techMaScore in collection)
{
TechMaScoreInfo techMaScoreInfo = new TechMaScoreInfo();
LoadFromDAL(techMaScoreInfo, techMaScore);
list.Add(techMaScoreInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
//从后台获取数据
internal static void LoadFromDAL(TechMaScoreInfo pTechMaScoreInfo, TechMaScore pTechMaScore)
{
pTechMaScoreInfo.techMaScoreId = pTechMaScore.TechMaScoreId;
pTechMaScoreInfo.reason = pTechMaScore.Reason;
pTechMaScoreInfo.addMinusScore = pTechMaScore.AddMinusScore;
pTechMaScoreInfo.totalScore = pTechMaScore.TotalScore;
pTechMaScoreInfo.upView = pTechMaScore.UpView;
pTechMaScoreInfo.evaluateLevelId = pTechMaScore.EvaluateLevelId;
pTechMaScoreInfo.yearId = pTechMaScore.YearId;
pTechMaScoreInfo.monthId = pTechMaScore.MonthId;
pTechMaScoreInfo.dateSpan = pTechMaScore.DateSpan;
pTechMaScoreInfo.employeeId = pTechMaScore.EmployeeId;
pTechMaScoreInfo.isSubmit = pTechMaScore.IsSubmit;
pTechMaScoreInfo.selfScore1 = pTechMaScore.SelfScore1;
pTechMaScoreInfo.selfScore2 = pTechMaScore.SelfScore2;
pTechMaScoreInfo.selfScore3 = pTechMaScore.SelfScore3;
pTechMaScoreInfo.selfScore4 = pTechMaScore.SelfScore4;
pTechMaScoreInfo.selfScore5 = pTechMaScore.SelfScore5;
pTechMaScoreInfo.selfScore6 = pTechMaScore.SelfScore6;
pTechMaScoreInfo.selfScore7 = pTechMaScore.SelfScore7;
pTechMaScoreInfo.selfScore8 = pTechMaScore.SelfScore8;
pTechMaScoreInfo.selfScore9 = pTechMaScore.SelfScore9;
pTechMaScoreInfo.selfScore10 = pTechMaScore.SelfScore10;
pTechMaScoreInfo.selfScore11 = pTechMaScore.SelfScore11;
pTechMaScoreInfo.selfScore12 = pTechMaScore.SelfScore12;
pTechMaScoreInfo.selfScore13 = pTechMaScore.SelfScore13;
pTechMaScoreInfo.upScore1 = pTechMaScore.UpScore1;
pTechMaScoreInfo.upScore2 = pTechMaScore.UpScore2;
pTechMaScoreInfo.upScore3 = pTechMaScore.UpScore3;
pTechMaScoreInfo.upScore4 = pTechMaScore.UpScore4;
pTechMaScoreInfo.upScore5 = pTechMaScore.UpScore5;
pTechMaScoreInfo.upScore6 = pTechMaScore.UpScore6;
pTechMaScoreInfo.upScore7 = pTechMaScore.UpScore7;
pTechMaScoreInfo.upScore8 = pTechMaScore.UpScore8;
pTechMaScoreInfo.upScore9 = pTechMaScore.UpScore9;
pTechMaScoreInfo.upScore10 = pTechMaScore.UpScore10;
pTechMaScoreInfo.upScore11 = pTechMaScore.UpScore11;
pTechMaScoreInfo.upScore12 = pTechMaScore.UpScore12;
pTechMaScoreInfo.upScore13 = pTechMaScore.UpScore13;
pTechMaScoreInfo.sectScore1 = pTechMaScore.SectScore1;
pTechMaScoreInfo.sectScore2 = pTechMaScore.SectScore2;
pTechMaScoreInfo.sectScore3 = pTechMaScore.SectScore3;
pTechMaScoreInfo.sectScore4 = pTechMaScore.SectScore4;
pTechMaScoreInfo.sectScore5 = pTechMaScore.SectScore5;
pTechMaScoreInfo.sectScore6 = pTechMaScore.SectScore6;
pTechMaScoreInfo.sectScore7 = pTechMaScore.SectScore7;
pTechMaScoreInfo.sectScore8 = pTechMaScore.SectScore8;
pTechMaScoreInfo.sectScore9 = pTechMaScore.SectScore9;
pTechMaScoreInfo.sectScore10 = pTechMaScore.SectScore10;
pTechMaScoreInfo.sectScore11 = pTechMaScore.SectScore11;
pTechMaScoreInfo.sectScore12 = pTechMaScore.SectScore12;
pTechMaScoreInfo.sectScore13 = pTechMaScore.SectScore13;
pTechMaScoreInfo.Loaded = true;
}
/// <summary>
/// 保存
/// </summary>
public override void Save()
{
if (!m_Loaded) //新增
{
TechMaScore techMaScore = new TechMaScore();
SaveToDb(this, techMaScore, true);
}
else //修改
{
TechMaScore techMaScore = new TechMaScore(techMaScoreId);
if (techMaScore.IsNew)
{
throw new AppException("该数据已经不存在了");
}
SaveToDb(this, techMaScore, false);
}
}
/// <summary>
/// 删除
/// </summary>
/// <returns>是否成功</returns>
public override void Delete()
{
if (!m_Loaded)
{
throw new AppException("尚未初始化");
}
bool result = (TechMaScore.Delete(TechMaScoreId) == 1);
//更新缓存
if (result && CachedEntityCommander.IsTypeRegistered(typeof(TechMaScoreInfo)))
{
ResetCache();
}
if (!result)
{
throw new AppException("删除失败，数据可能被删除");
}
}
private void LoadFromId(int techMaScoreId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(TechMaScoreInfo)))
{
TechMaScoreInfo techMaScoreInfo = Find(GetList(), techMaScoreId);
if (techMaScoreInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(techMaScoreInfo, this);
}
else
{
TechMaScore techMaScore = new TechMaScore(techMaScoreId);
if (techMaScore.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, techMaScore);
}
}
//数据持久化
internal static void SaveToDb(TechMaScoreInfo pTechMaScoreInfo, TechMaScore pTechMaScore, bool pIsNew)
{
pTechMaScore.TechMaScoreId = pTechMaScoreInfo.techMaScoreId;
pTechMaScore.Reason = pTechMaScoreInfo.reason;
pTechMaScore.AddMinusScore = pTechMaScoreInfo.addMinusScore;
pTechMaScore.TotalScore = pTechMaScoreInfo.totalScore;
pTechMaScore.UpView = pTechMaScoreInfo.upView;
pTechMaScore.EvaluateLevelId = pTechMaScoreInfo.evaluateLevelId;
pTechMaScore.YearId = pTechMaScoreInfo.yearId;
pTechMaScore.MonthId = pTechMaScoreInfo.monthId;
pTechMaScore.DateSpan = pTechMaScoreInfo.dateSpan;
pTechMaScore.EmployeeId = pTechMaScoreInfo.employeeId;
pTechMaScore.IsSubmit = pTechMaScoreInfo.isSubmit;
pTechMaScore.SelfScore1 = pTechMaScoreInfo.selfScore1;
pTechMaScore.SelfScore2 = pTechMaScoreInfo.selfScore2;
pTechMaScore.SelfScore3 = pTechMaScoreInfo.selfScore3;
pTechMaScore.SelfScore4 = pTechMaScoreInfo.selfScore4;
pTechMaScore.SelfScore5 = pTechMaScoreInfo.selfScore5;
pTechMaScore.SelfScore6 = pTechMaScoreInfo.selfScore6;
pTechMaScore.SelfScore7 = pTechMaScoreInfo.selfScore7;
pTechMaScore.SelfScore8 = pTechMaScoreInfo.selfScore8;
pTechMaScore.SelfScore9 = pTechMaScoreInfo.selfScore9;
pTechMaScore.SelfScore10 = pTechMaScoreInfo.selfScore10;
pTechMaScore.SelfScore11 = pTechMaScoreInfo.selfScore11;
pTechMaScore.SelfScore12 = pTechMaScoreInfo.selfScore12;
pTechMaScore.SelfScore13 = pTechMaScoreInfo.selfScore13;
pTechMaScore.UpScore1 = pTechMaScoreInfo.upScore1;
pTechMaScore.UpScore2 = pTechMaScoreInfo.upScore2;
pTechMaScore.UpScore3 = pTechMaScoreInfo.upScore3;
pTechMaScore.UpScore4 = pTechMaScoreInfo.upScore4;
pTechMaScore.UpScore5 = pTechMaScoreInfo.upScore5;
pTechMaScore.UpScore6 = pTechMaScoreInfo.upScore6;
pTechMaScore.UpScore7 = pTechMaScoreInfo.upScore7;
pTechMaScore.UpScore8 = pTechMaScoreInfo.upScore8;
pTechMaScore.UpScore9 = pTechMaScoreInfo.upScore9;
pTechMaScore.UpScore10 = pTechMaScoreInfo.upScore10;
pTechMaScore.UpScore11 = pTechMaScoreInfo.upScore11;
pTechMaScore.UpScore12 = pTechMaScoreInfo.upScore12;
pTechMaScore.UpScore13 = pTechMaScoreInfo.upScore13;
pTechMaScore.SectScore1 = pTechMaScoreInfo.sectScore1;
pTechMaScore.SectScore2 = pTechMaScoreInfo.sectScore2;
pTechMaScore.SectScore3 = pTechMaScoreInfo.sectScore3;
pTechMaScore.SectScore4 = pTechMaScoreInfo.sectScore4;
pTechMaScore.SectScore5 = pTechMaScoreInfo.sectScore5;
pTechMaScore.SectScore6 = pTechMaScoreInfo.sectScore6;
pTechMaScore.SectScore7 = pTechMaScoreInfo.sectScore7;
pTechMaScore.SectScore8 = pTechMaScoreInfo.sectScore8;
pTechMaScore.SectScore9 = pTechMaScoreInfo.sectScore9;
pTechMaScore.SectScore10 = pTechMaScoreInfo.sectScore10;
pTechMaScore.SectScore11 = pTechMaScoreInfo.sectScore11;
pTechMaScore.SectScore12 = pTechMaScoreInfo.sectScore12;
pTechMaScore.SectScore13 = pTechMaScoreInfo.sectScore13;
pTechMaScore.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pTechMaScore.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(TechMaScoreInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pTechMaScoreInfo.techMaScoreId = pTechMaScore.TechMaScoreId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(TechMaScoreInfo)))
{
ResetCache();
}
}
public static void DelTechMaScore(int scoreid)
{
TechMaScore.Delete(scoreid);
}
private void LoadFromId(int techMaScoreId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(TechMaScoreInfo)))
{
TechMaScoreInfo techMaScoreInfo=Find(GetList(), techMaScoreId);
if(techMaScoreInfo==null)
throw new AppException("未能在缓存中找到相应的键值对象");
Copy(techMaScoreInfo, this);
}
else
{ TechMaScore techMaScore=new TechMaScore( techMaScoreId);
if(techMaScore.IsNew)
throw new AppException("尚未初始化");
LoadFromDAL(this, techMaScore);
}
}
//数据持久化
internal static void SaveToDb(TechMaScoreInfo pTechMaScoreInfo, TechMaScore pTechMaScore,bool pIsNew)
{
pTechMaScore.TechMaScoreId = pTechMaScoreInfo.techMaScoreId;
pTechMaScore.Reason = pTechMaScoreInfo.reason;
pTechMaScore.AddMinusScore = pTechMaScoreInfo.addMinusScore;
pTechMaScore.TotalScore = pTechMaScoreInfo.totalScore;
pTechMaScore.UpView = pTechMaScoreInfo.upView;
pTechMaScore.EvaluateLevelId = pTechMaScoreInfo.evaluateLevelId;
pTechMaScore.YearId = pTechMaScoreInfo.yearId;
pTechMaScore.MonthId = pTechMaScoreInfo.monthId;
pTechMaScore.DateSpan = pTechMaScoreInfo.dateSpan;
pTechMaScore.EmployeeId = pTechMaScoreInfo.employeeId;
pTechMaScore.IsSubmit = pTechMaScoreInfo.isSubmit;
pTechMaScore.SelfScore1 = pTechMaScoreInfo.selfScore1;
pTechMaScore.SelfScore2 = pTechMaScoreInfo.selfScore2;
pTechMaScore.SelfScore3 = pTechMaScoreInfo.selfScore3;
pTechMaScore.SelfScore4 = pTechMaScoreInfo.selfScore4;
pTechMaScore.SelfScore5 = pTechMaScoreInfo.selfScore5;
pTechMaScore.SelfScore6 = pTechMaScoreInfo.selfScore6;
pTechMaScore.SelfScore7 = pTechMaScoreInfo.selfScore7;
pTechMaScore.SelfScore8 = pTechMaScoreInfo.selfScore8;
pTechMaScore.SelfScore9 = pTechMaScoreInfo.selfScore9;
pTechMaScore.SelfScore10 = pTechMaScoreInfo.selfScore10;
pTechMaScore.SelfScore11 = pTechMaScoreInfo.selfScore11;
pTechMaScore.SelfScore12 = pTechMaScoreInfo.selfScore12;
pTechMaScore.SelfScore13 = pTechMaScoreInfo.selfScore13;
pTechMaScore.UpScore1 = pTechMaScoreInfo.upScore1;
pTechMaScore.UpScore2 = pTechMaScoreInfo.upScore2;
pTechMaScore.UpScore3 = pTechMaScoreInfo.upScore3;
pTechMaScore.UpScore4 = pTechMaScoreInfo.upScore4;
pTechMaScore.UpScore5 = pTechMaScoreInfo.upScore5;
pTechMaScore.UpScore6 = pTechMaScoreInfo.upScore6;
pTechMaScore.UpScore7 = pTechMaScoreInfo.upScore7;
pTechMaScore.UpScore8 = pTechMaScoreInfo.upScore8;
pTechMaScore.UpScore9 = pTechMaScoreInfo.upScore9;
pTechMaScore.UpScore10 = pTechMaScoreInfo.upScore10;
pTechMaScore.UpScore11 = pTechMaScoreInfo.upScore11;
pTechMaScore.UpScore12 = pTechMaScoreInfo.upScore12;
pTechMaScore.UpScore13 = pTechMaScoreInfo.upScore13;
pTechMaScore.SectScore1 = pTechMaScoreInfo.sectScore1;
pTechMaScore.SectScore2 = pTechMaScoreInfo.sectScore2;
pTechMaScore.SectScore3 = pTechMaScoreInfo.sectScore3;
pTechMaScore.SectScore4 = pTechMaScoreInfo.sectScore4;
pTechMaScore.SectScore5 = pTechMaScoreInfo.sectScore5;
pTechMaScore.SectScore6 = pTechMaScoreInfo.sectScore6;
pTechMaScore.SectScore7 = pTechMaScoreInfo.sectScore7;
pTechMaScore.SectScore8 = pTechMaScoreInfo.sectScore8;
pTechMaScore.SectScore9 = pTechMaScoreInfo.sectScore9;
pTechMaScore.SectScore10 = pTechMaScoreInfo.sectScore10;
pTechMaScore.SectScore11 = pTechMaScoreInfo.sectScore11;
pTechMaScore.SectScore12 = pTechMaScoreInfo.sectScore12;
pTechMaScore.SectScore13 = pTechMaScoreInfo.sectScore13;
pTechMaScore.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pTechMaScore.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(TechMaScoreInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pTechMaScoreInfo.techMaScoreId = pTechMaScore.TechMaScoreId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(TechMaScoreInfo)))
{
ResetCache();
}
}
//从后台获取数据
internal static void LoadFromDAL(TechMaScoreInfo pTechMaScoreInfo, TechMaScore pTechMaScore)
{
pTechMaScoreInfo.techMaScoreId = pTechMaScore.TechMaScoreId;
pTechMaScoreInfo.reason = pTechMaScore.Reason;
pTechMaScoreInfo.addMinusScore = pTechMaScore.AddMinusScore;
pTechMaScoreInfo.totalScore = pTechMaScore.TotalScore;
pTechMaScoreInfo.upView = pTechMaScore.UpView;
pTechMaScoreInfo.evaluateLevelId = pTechMaScore.EvaluateLevelId;
pTechMaScoreInfo.yearId = pTechMaScore.YearId;
pTechMaScoreInfo.monthId = pTechMaScore.MonthId;
pTechMaScoreInfo.dateSpan = pTechMaScore.DateSpan;
pTechMaScoreInfo.employeeId = pTechMaScore.EmployeeId;
pTechMaScoreInfo.isSubmit = pTechMaScore.IsSubmit;
pTechMaScoreInfo.selfScore1 = pTechMaScore.SelfScore1;
pTechMaScoreInfo.selfScore2 = pTechMaScore.SelfScore2;
pTechMaScoreInfo.selfScore3 = pTechMaScore.SelfScore3;
pTechMaScoreInfo.selfScore4 = pTechMaScore.SelfScore4;
pTechMaScoreInfo.selfScore5 = pTechMaScore.SelfScore5;
pTechMaScoreInfo.selfScore6 = pTechMaScore.SelfScore6;
pTechMaScoreInfo.selfScore7 = pTechMaScore.SelfScore7;
pTechMaScoreInfo.selfScore8 = pTechMaScore.SelfScore8;
pTechMaScoreInfo.selfScore9 = pTechMaScore.SelfScore9;
pTechMaScoreInfo.selfScore10 = pTechMaScore.SelfScore10;
pTechMaScoreInfo.selfScore11 = pTechMaScore.SelfScore11;
pTechMaScoreInfo.selfScore12 = pTechMaScore.SelfScore12;
pTechMaScoreInfo.selfScore13 = pTechMaScore.SelfScore13;
pTechMaScoreInfo.upScore1 = pTechMaScore.UpScore1;
pTechMaScoreInfo.upScore2 = pTechMaScore.UpScore2;
pTechMaScoreInfo.upScore3 = pTechMaScore.UpScore3;
pTechMaScoreInfo.upScore4 = pTechMaScore.UpScore4;
pTechMaScoreInfo.upScore5 = pTechMaScore.UpScore5;
pTechMaScoreInfo.upScore6 = pTechMaScore.UpScore6;
pTechMaScoreInfo.upScore7 = pTechMaScore.UpScore7;
pTechMaScoreInfo.upScore8 = pTechMaScore.UpScore8;
pTechMaScoreInfo.upScore9 = pTechMaScore.UpScore9;
pTechMaScoreInfo.upScore10 = pTechMaScore.UpScore10;
pTechMaScoreInfo.upScore11 = pTechMaScore.UpScore11;
pTechMaScoreInfo.upScore12 = pTechMaScore.UpScore12;
pTechMaScoreInfo.upScore13 = pTechMaScore.UpScore13;
pTechMaScoreInfo.sectScore1 = pTechMaScore.SectScore1;
pTechMaScoreInfo.sectScore2 = pTechMaScore.SectScore2;
pTechMaScoreInfo.sectScore3 = pTechMaScore.SectScore3;
pTechMaScoreInfo.sectScore4 = pTechMaScore.SectScore4;
pTechMaScoreInfo.sectScore5 = pTechMaScore.SectScore5;
pTechMaScoreInfo.sectScore6 = pTechMaScore.SectScore6;
pTechMaScoreInfo.sectScore7 = pTechMaScore.SectScore7;
pTechMaScoreInfo.sectScore8 = pTechMaScore.SectScore8;
pTechMaScoreInfo.sectScore9 = pTechMaScore.SectScore9;
pTechMaScoreInfo.sectScore10 = pTechMaScore.SectScore10;
pTechMaScoreInfo.sectScore11 = pTechMaScore.SectScore11;
pTechMaScoreInfo.sectScore12 = pTechMaScore.SectScore12;
pTechMaScoreInfo.sectScore13 = pTechMaScore.SectScore13;
pTechMaScoreInfo.Loaded=true;
}
/// <summary>
/// 保存
/// </summary>
public override void Save()
{
if(!m_Loaded)//新增
{
TechMaScore techMaScore=new TechMaScore();
SaveToDb(this, techMaScore,true);
}
else//修改
{
TechMaScore techMaScore=new TechMaScore(techMaScoreId);
if(techMaScore.IsNew)
throw new AppException("该数据已经不存在了");
SaveToDb(this, techMaScore,false);
}
}
