/// <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 <EvaluateLevelInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <EvaluateLevelInfo> list = new List <EvaluateLevelInfo>();
Query q = EvaluateLevel.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
EvaluateLevelCollection collection = new EvaluateLevelCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (EvaluateLevel evaluateLevel in collection)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo();
LoadFromDAL(evaluateLevelInfo, evaluateLevel);
list.Add(evaluateLevelInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List <EvaluateLevelInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return(CachedEntityCommander.GetCache(cacheKey) as List <EvaluateLevelInfo>);
}
else
{
List <EvaluateLevelInfo> list = new List <EvaluateLevelInfo>();
EvaluateLevelCollection collection = new EvaluateLevelCollection();
Query qry = new Query(EvaluateLevel.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach (EvaluateLevel evaluateLevel in collection)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo();
LoadFromDAL(evaluateLevelInfo, evaluateLevel);
list.Add(evaluateLevelInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return(list);
}
}
//数据持久化
internal static void SaveToDb(EvaluateLevelInfo pEvaluateLevelInfo, EvaluateLevel pEvaluateLevel, bool pIsNew)
{
pEvaluateLevel.EvaluateLevelId = pEvaluateLevelInfo.evaluateLevelId;
pEvaluateLevel.EvaluateName = pEvaluateLevelInfo.evaluateName;
pEvaluateLevel.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pEvaluateLevel.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(EvaluateLevelInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pEvaluateLevelInfo.evaluateLevelId = pEvaluateLevel.EvaluateLevelId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)))
{
ResetCache();
}
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List <EvaluateLevelInfo> pList, EvaluateLevelCollection pCollection)
{
foreach (EvaluateLevel evaluateLevel in pCollection)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo();
LoadFromDAL(evaluateLevelInfo, evaluateLevel);
pList.Add(evaluateLevelInfo);
}
}
public EvaluateLevelInfo GetEvaluateLevelInfoById(int EvaluateLevelId)
{
EvaluateLevelInfo evaluateLevelInfo = null;//
try
{
evaluateLevelInfo = new EvaluateLevelInfo(EvaluateLevelId);
}
catch (AppException)
{
return null;
}
return evaluateLevelInfo;
}
public EvaluateLevelInfo GetEvaluateLevelInfoById(int EvaluateLevelId)
{
EvaluateLevelInfo evaluateLevelInfo = null; //
try
{
evaluateLevelInfo = new EvaluateLevelInfo(EvaluateLevelId);
}
catch (AppException)
{
return(null);
}
return(evaluateLevelInfo);
}
private void LoadFromId(int evaluateLevelId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)))
{
EvaluateLevelInfo evaluateLevelInfo = Find(GetList(), evaluateLevelId);
if (evaluateLevelInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(evaluateLevelInfo, this);
}
else
{
EvaluateLevel evaluateLevel = new EvaluateLevel(evaluateLevelId);
if (evaluateLevel.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, evaluateLevel);
}
}
protected void PageInit()
{
int TesId = Convert.ToInt32(Request["TechMaScoreId"].ToString());
TechMaScoreInfo tms = new TechMaScoreInfo(TesId);
lblSelfScore1.Text = tms.SelfScore1.ToString();
lblSelfScore2.Text = tms.SelfScore2.ToString();
lblSelfScore3.Text = tms.SelfScore3.ToString();
lblSelfScore4.Text = tms.SelfScore4.ToString();
lblSelfScore5.Text = tms.SelfScore5.ToString();
lblSelfScore6.Text = tms.SelfScore6.ToString();
lblSelfScore7.Text = tms.SelfScore7.ToString();
lblSelfScore8.Text = tms.SelfScore8.ToString();
lblSelfScore9.Text = tms.SelfScore9.ToString();
lblSelfScore10.Text = tms.SelfScore10.ToString();
lblSelfScore11.Text = tms.SelfScore11.ToString();
lblSelfScore12.Text = tms.SelfScore12.ToString();
lblSelfScore13.Text = tms.SelfScore13.ToString();
lblUpScore1.Text = tms.UpScore1.ToString();
lblUpScore2.Text = tms.UpScore2.ToString();
lblUpScore3.Text = tms.UpScore3.ToString();
lblUpScore4.Text = tms.UpScore4.ToString();
lblUpScore5.Text = tms.UpScore5.ToString();
lblUpScore6.Text = tms.UpScore6.ToString();
lblUpScore7.Text = tms.UpScore7.ToString();
lblUpScore8.Text = tms.UpScore8.ToString();
lblUpScore9.Text = tms.UpScore9.ToString();
lblUpScore10.Text = tms.UpScore10.ToString();
lblUpScore11.Text = tms.UpScore11.ToString();
lblUpScore12.Text = tms.UpScore12.ToString();
lblUpScore13.Text = tms.UpScore13.ToString();
lblSectScore1.Text = tms.SectScore1.ToString();
lblSectScore2.Text = tms.SectScore2.ToString();
lblSectScore3.Text = tms.SectScore3.ToString();
lblSectScore4.Text = tms.SectScore4.ToString();
lblSectScore5.Text = tms.SectScore5.ToString();
lblSectScore6.Text = tms.SectScore6.ToString();
lblSectScore7.Text = tms.SectScore7.ToString();
lblSectScore8.Text = tms.SectScore8.ToString();
lblSectScore9.Text = tms.SectScore9.ToString();
lblSectScore10.Text = tms.SectScore10.ToString();
lblSectScore11.Text = tms.SectScore11.ToString();
lblSectScore12.Text = tms.SectScore12.ToString();
lblSectScore13.Text = tms.SectScore13.ToString();
//ddlYear.SelectedValue = tms.YearId.ToString();
//ddlMonth.SelectedValue = tms.MonthId.ToString();
YearInfo year = new YearInfo(Convert.ToInt32(tms.YearId));
MonthInfo month = new MonthInfo(Convert.ToInt32(tms.MonthId));
lblDate.Text = year.YearName + "Äê" + month.MonthNames + "ÔÂ";
EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(tms.EmployeeId));
lblName.Text = em.EmployeeName.ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(Convert.ToInt32(em.PositionId)));
lblPosition.Text = position.PositionName;
lblSumScore.Text = tms.TotalScore.ToString();
lblViews.Text = tms.UpView.ToString();
if (tms.EvaluateLevelId.ToString() != "")
{
EvaluateLevelInfo ev = new EvaluateLevelInfo(Convert.ToInt32(tms.EvaluateLevelId));
lblLevel.Text = ev.EvaluateName.ToString();
}
else
{
lblLevel.Text = "";
}
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(EvaluateLevelInfo pEvaluateLevelInfoTo)
{
Copy(this, pEvaluateLevelInfoTo);
}
public List <EvaluateLevelInfo> GetEvaluateLevelInfoList()
{
return(EvaluateLevelInfo.GetList());
}
public object SaveEvaluateLevelInfo(EvaluateLevelInfo evaluateLevelInfo)
{
evaluateLevelInfo.Save();
return(evaluateLevelInfo.EvaluateLevelId);
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List<EvaluateLevelInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return CachedEntityCommander.GetCache(cacheKey) as List< EvaluateLevelInfo>;
}
else
{
List< EvaluateLevelInfo> list =new List< EvaluateLevelInfo>();
EvaluateLevelCollection collection=new EvaluateLevelCollection();
Query qry = new Query(EvaluateLevel.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach(EvaluateLevel evaluateLevel in collection)
{
EvaluateLevelInfo evaluateLevelInfo= new EvaluateLevelInfo();
LoadFromDAL(evaluateLevelInfo,evaluateLevel);
list.Add(evaluateLevelInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return list;
}
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(EvaluateLevelInfo pEvaluateLevelInfoTo)
{
Copy(this, pEvaluateLevelInfoTo);
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(EvaluateLevelInfo pEvaluateLevelInfoFrom, EvaluateLevelInfo pEvaluateLevelInfoTo)
{
pEvaluateLevelInfoTo.EvaluateLevelId = pEvaluateLevelInfoFrom.evaluateLevelId;
pEvaluateLevelInfoTo.EvaluateName = pEvaluateLevelInfoFrom.evaluateName;
pEvaluateLevelInfoTo.Loaded = pEvaluateLevelInfoFrom.Loaded;
}
public object SaveEvaluateLevelInfo(EvaluateLevelInfo evaluateLevelInfo)
{
evaluateLevelInfo.Save();
return evaluateLevelInfo . EvaluateLevelId;
}
public void DeleteById(EvaluateLevelInfo pEvaluateLevelInfo)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo(pEvaluateLevelInfo.EvaluateLevelId);
evaluateLevelInfo.Delete();
}
protected void PageInit()
{
int asid = Convert.ToInt32(Request["AssistantScoreId"].ToString());
AssistantScoreInfo at = new AssistantScoreInfo(asid);
EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(at.EmployeeId));
lblName.Text = em.EmployeeName.ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(em.PositionId));
lblPosition.Text = position.PositionName.ToString();
DepartInfo depart = new DepartInfo(Convert.ToInt32(em.DepartId));
lblDepart.Text = depart.DepartName.ToString();
//ddlYear.SelectedValue = at.YearId.ToString();
//ddlMonth.SelectedValue = at.MonthId.ToString();
YearInfo year = new YearInfo(Convert.ToInt32(at.YearId));
MonthInfo month = new MonthInfo(Convert.ToInt32(at.MonthId));
lblDate.Text = year.YearName + "Äê" + month.MonthNames + "ÔÂ";
lblSelfas1.Text = at.Selfas1.ToString();
lblSelfas2.Text = at.Selfas2.ToString();
lblSelfas3.Text = at.Selfas3.ToString();
lblSelfas4.Text = at.Selfas4.ToString();
lblSelfas5.Text = at.Selfas5.ToString();
lblSelfas6.Text = at.Selfas6.ToString();
lblSelfas7.Text = at.Selfas7.ToString();
lblSelfas8.Text = at.Selfas8.ToString();
lblSelfas9.Text = at.Selfas9.ToString();
lblSelfas10.Text = at.Selfas10.ToString();
lblSelfas11.Text = at.Selfas11.ToString();
lblSelfas12.Text = at.Selfas12.ToString();
lblSelfas13.Text = at.Selfas13.ToString();
lblSelfas14.Text = at.Selfas14.ToString();
lblSelfas15.Text = at.Selfas15.ToString();
lblSelfas16.Text = at.Selfas16.ToString();
lblSelfas17.Text = at.Selfas17.ToString();
lblSelfas18.Text = at.Selfas18.ToString();
lblSelfas19.Text = at.Selfas19.ToString();
lblUpas1.Text = at.Upas1.ToString();
lblUpas2.Text = at.Upas2.ToString();
lblUpas3.Text = at.Upas3.ToString();
lblUpas4.Text = at.Upas4.ToString();
lblUpas5.Text = at.Upas5.ToString();
lblUpas6.Text = at.Upas6.ToString();
lblUpas7.Text = at.Upas7.ToString();
lblUpas8.Text = at.Upas8.ToString();
lblUpas9.Text = at.Upas9.ToString();
lblUpas10.Text = at.Upas10.ToString();
lblUpas11.Text = at.Upas11.ToString();
lblUpas12.Text = at.Upas12.ToString();
lblUpas13.Text = at.Upas13.ToString();
lblUpas14.Text = at.Upas14.ToString();
lblUpas15.Text = at.Upas15.ToString();
lblUpas16.Text = at.Upas16.ToString();
lblUpas17.Text = at.Upas17.ToString();
lblUpas18.Text = at.Upas18.ToString();
lblUpas19.Text = at.Upas19.ToString();
lblSecas1.Text = at.Secas1.ToString();
lblSecas2.Text = at.Secas2.ToString();
lblSecas3.Text = at.Secas3.ToString();
lblSecas4.Text = at.Secas4.ToString();
lblSecas5.Text = at.Secas5.ToString();
lblSecas6.Text = at.Secas6.ToString();
lblSecas7.Text = at.Secas7.ToString();
lblSecas8.Text = at.Secas8.ToString();
lblSecas9.Text = at.Secas9.ToString();
lblSecas10.Text = at.Secas10.ToString();
lblSecas11.Text = at.Secas11.ToString();
lblSecas12.Text = at.Secas12.ToString();
lblSecas13.Text = at.Secas13.ToString();
lblSecas14.Text = at.Secas14.ToString();
lblSecas15.Text = at.Secas15.ToString();
lblSecas16.Text = at.Secas16.ToString();
lblSecas17.Text = at.Secas17.ToString();
lblSecas18.Text = at.Secas18.ToString();
lblSecas19.Text = at.Secas19.ToString();
lblTotalScore.Text = at.TotalScore.ToString();
if (at.EvaluateLevelId.ToString() != "")
{
EvaluateLevelInfo le = new EvaluateLevelInfo(Convert.ToInt32(at.EvaluateLevelId));
lblLevel.Text = le.EvaluateName.ToString();
}
else
{
lblLevel.Text = "";
}
lblViews.Text = at.UpViews.ToString();
}
protected void PageInit()
{
int TesId = Convert.ToInt32(Request["TechEmScoreId"].ToString());
TechEmScoreInfo tes = new TechEmScoreInfo(TesId);
lblSelfPlan.Text=tes.SelfPlan.ToString();
lblSelfWorkTotal.Text = tes.SelfWorkTotal.ToString();
lblSelfWorkSpeed.Text = tes.SelfWorkSpeed.ToString();
lblSelfCommunicate.Text = tes.SelfCommunicate.ToString();
lblSelfDescipline.Text = tes.SelfDescipline.ToString();
lblSelfExecute.Text = tes.SelfExecute.ToString();
lblSelfRoute.Text = tes.SelfRoute.ToString();
lblSelfProfession.Text = tes.SelfProfession.ToString();
lblSelfAttitude.Text = tes.SelfAttitude.ToString();
lblSelfComplex.Text = tes.SelfComplex.ToString();
lblSelfSpeciality.Text = tes.SelfSpeciality.ToString();
lblUpPlan.Text = tes.UpPlan.ToString();
lblUpWorkTotal.Text = tes.UpWorkTotal.ToString();
lblUpWorkSpeed.Text = tes.UpWorkSpeed.ToString();
lblUpCommunicate.Text = tes.UpCommunicate.ToString();
lblUpDescipline.Text = tes.UpDescipline.ToString();
lblUpExecute.Text = tes.UpExecute.ToString();
lblUpRoute.Text = tes.UpRoute.ToString();
lblUpProfession.Text = tes.UpProfession.ToString();
lblUpAttitude.Text = tes.UpAttitude.ToString();
lblUpComplex.Text = tes.UpComplex.ToString();
lblUpSpeciality.Text = tes.UpSpeciality.ToString();
lblSecPlan.Text = tes.SectPlan.ToString();
lblSecWorkTotal.Text = tes.SectWorkTotal.ToString();
lblSecWorkSpeed.Text = tes.SectWorkSpeed.ToString();
lblSecCommunicate.Text = tes.SectCommunicate.ToString();
lblSecDescipline.Text = tes.SectDescipline.ToString();
lblSecExecute.Text = tes.SectExecute.ToString();
lblSecRoute.Text = tes.SectRoute.ToString();
lblSecProfession.Text = tes.SectProfession.ToString();
lblSecAttitude.Text = tes.SectAttitude.ToString();
lblSecComplex.Text = tes.SectComplex.ToString();
lblSecSpeciality.Text = tes.SectSpeciality.ToString();
//ddlYear.SelectedValue = tes.YearId.ToString();
//ddlMonth.SelectedValue = tes.MonthId.ToString();
YearInfo year = new YearInfo(Convert.ToInt32(tes.YearId));
MonthInfo month = new MonthInfo(Convert.ToInt32(tes.MonthId));
lblDate.Text = year.YearName + "Äê" + month.MonthNames + "ÔÂ";
EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(tes.EmployeeId));
lblName.Text = em.EmployeeName.ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(Convert.ToInt32(em.PositionId)));
lblPosition.Text = position.PositionName;
lblReason.Text = tes.Reason.ToString();
lblAddMinusScore.Text = tes.AddMinusSocre.ToString();
lblSumScore.Text = tes.TotalScore.ToString();
lblViews.Text = tes.UpViews.ToString();
EvaluateLevelInfo el = new EvaluateLevelInfo(Convert.ToInt32(tes.EvaluateLevelId));
lblLevels.Text = el.EvaluateName.ToString();
lblPlan.Text = tes.PlanFinish.ToString();
lblActual.Text = tes.ActualFinish.ToString();
lblPercent.Text = tes.FinishRate.ToString();
lblUp.Text = tes.FinishScore.ToString();
lblUp1.Text = tes.FinishScore.ToString();
}
//protected void ddlDataBind()
//{
// DataTable dt = TechEmScoreInfo.getYearddl();
// ddlYear.DataSource = dt;
// ddlYear.DataTextField = "YearName";
// ddlYear.DataValueField = "YearId";
// DataRow row = dt.NewRow();
// row["YearName"] = "��ѡ�����";
// dt.Rows.InsertAt(row, 0);
// ddlYear.DataBind();
// DataTable dt1 = TechEmScoreInfo.getMonthddl();
// ddlMonth.DataSource = dt1;
// ddlMonth.DataTextField = "MonthNames";
// ddlMonth.DataValueField = "MonthId";
// DataRow row1 = dt1.NewRow();
// row1["MonthNames"] = "��ѡ���·�";
// dt1.Rows.InsertAt(row1, 0);
// ddlMonth.DataBind();
//}
protected void PageInit()
{
int fsid = Convert.ToInt32(Request["FrontScoreId"].ToString());
FrontScoreInfo fs = new FrontScoreInfo(fsid);
EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(fs.EmployeeId));
lblName.Text = em.EmployeeName.ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(em.PositionId));
lblPosition.Text = position.PositionName.ToString();
DepartInfo depart = new DepartInfo(Convert.ToInt32(em.DepartId));
lblDepart.Text = depart.DepartName.ToString();
//ddlYear.SelectedValue = fs.YearId.ToString();
//ddlMonth.SelectedValue = fs.MonthId.ToString();
YearInfo year = new YearInfo(Convert.ToInt32(fs.YearId));
MonthInfo month = new MonthInfo(Convert.ToInt32(fs.MonthId));
lblDate.Text = year.YearName + "��" + month.MonthNames + "��";
lblSelffs1.Text = fs.Selffs1.ToString();
lblSelffs2.Text = fs.Selffs2.ToString();
lblSelffs3.Text = fs.Selffs3.ToString();
lblSelffs4.Text = fs.Selffs4.ToString();
lblSelffs5.Text = fs.Selffs5.ToString();
lblSelffs6.Text = fs.Selffs6.ToString();
lblSelffs7.Text = fs.Selffs7.ToString();
lblSelffs9.Text = fs.Selffs9.ToString();
lblSelffs10.Text = fs.Selffs10.ToString();
lblSelffs11.Text = fs.Selffs11.ToString();
lblSelffs12.Text = fs.Selffs12.ToString();
lblSelffs13.Text = fs.Selffs13.ToString();
lblSelffs14.Text = fs.Selffs14.ToString();
lblSelffs15.Text = fs.Selffs15.ToString();
lblSelffs16.Text = fs.Selffs16.ToString();
lblSelffs17.Text = fs.Selffs17.ToString();
lblSelffs18.Text = fs.Selffs18.ToString();
lblSelffs19.Text = fs.Selffs19.ToString();
lblSelffs20.Text = fs.Selffs20.ToString();
lblSelffs21.Text = fs.Selffs21.ToString();
lblUpfs1.Text = fs.Upfs1.ToString();
lblUpfs2.Text = fs.Upfs2.ToString();
lblUpfs3.Text = fs.Upfs3.ToString();
lblUpfs4.Text = fs.Upfs4.ToString();
lblUpfs5.Text = fs.Upfs5.ToString();
lblUpfs6.Text = fs.Upfs6.ToString();
lblUpfs7.Text = fs.Upfs7.ToString();
lblUpfs9.Text = fs.Upfs9.ToString();
lblUpfs10.Text = fs.Upfs10.ToString();
lblUpfs11.Text = fs.Upfs11.ToString();
lblUpfs12.Text = fs.Upfs12.ToString();
lblUpfs13.Text = fs.Upfs13.ToString();
lblUpfs14.Text = fs.Upfs14.ToString();
lblUpfs15.Text = fs.Upfs15.ToString();
lblUpfs16.Text = fs.Upfs16.ToString();
lblUpfs17.Text = fs.Upfs17.ToString();
lblUpfs18.Text = fs.Upfs18.ToString();
lblUpfs19.Text = fs.Upfs19.ToString();
lblUpfs20.Text = fs.Upfs20.ToString();
lblUpfs21.Text = fs.Upfs21.ToString();
lblSectfs1.Text = fs.Secfs1.ToString();
lblSectfs2.Text = fs.Secfs2.ToString();
lblSectfs3.Text = fs.Secfs3.ToString();
lblSectfs4.Text = fs.Secfs4.ToString();
lblSectfs5.Text = fs.Secfs5.ToString();
lblSectfs6.Text = fs.Secfs6.ToString();
lblSectfs7.Text = fs.Secfs7.ToString();
lblSectfs9.Text = fs.Secfs9.ToString();
lblSectfs10.Text = fs.Secfs10.ToString();
lblSectfs11.Text = fs.Secfs11.ToString();
lblSectfs12.Text = fs.Secfs12.ToString();
lblSectfs13.Text = fs.Secfs13.ToString();
lblSectfs14.Text = fs.Secfs14.ToString();
lblSectfs15.Text = fs.Secfs15.ToString();
lblSectfs16.Text = fs.Secfs16.ToString();
lblSectfs17.Text = fs.Secfs17.ToString();
lblSectfs18.Text = fs.Secfs18.ToString();
lblSectfs19.Text = fs.Secfs19.ToString();
lblSectfs20.Text = fs.Secfs20.ToString();
lblSectfs21.Text = fs.Secfs21.ToString();
lblTotalScore.Text = fs.TotalScore.ToString();
if (fs.EvaluateLevelId.ToString() != "")
{
EvaluateLevelInfo le = new EvaluateLevelInfo(Convert.ToInt32(fs.EvaluateLevelId));
lblLevel.Text = le.EvaluateName.ToString();
}
else
{
lblLevel.Text = "";
}
lblViews.Text = fs.UpViews.ToString();
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List< EvaluateLevelInfo> pList, EvaluateLevelCollection pCollection)
{
foreach (EvaluateLevel evaluateLevel in pCollection)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo();
LoadFromDAL(evaluateLevelInfo, evaluateLevel );
pList.Add(evaluateLevelInfo);
}
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(EvaluateLevelInfo pEvaluateLevelInfoFrom, EvaluateLevelInfo pEvaluateLevelInfoTo)
{
pEvaluateLevelInfoTo.EvaluateLevelId = pEvaluateLevelInfoFrom.evaluateLevelId;
pEvaluateLevelInfoTo.EvaluateName = pEvaluateLevelInfoFrom.evaluateName;
pEvaluateLevelInfoTo.Loaded=pEvaluateLevelInfoFrom.Loaded;
}
public void DeleteById(EvaluateLevelInfo pEvaluateLevelInfo)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo(pEvaluateLevelInfo.EvaluateLevelId);
evaluateLevelInfo.Delete();
}
/// <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<EvaluateLevelInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
{
if(pPageIndex<=1)
pPageIndex=1;
List< EvaluateLevelInfo> list = new List< EvaluateLevelInfo>();
Query q = EvaluateLevel .CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression,pOrderBy.ToString());
EvaluateLevelCollection collection=new EvaluateLevelCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (EvaluateLevel evaluateLevel in collection)
{
EvaluateLevelInfo evaluateLevelInfo = new EvaluateLevelInfo();
LoadFromDAL(evaluateLevelInfo, evaluateLevel);
list.Add(evaluateLevelInfo);
}
pRecordCount=q.GetRecordCount();
return list;
}
public List <EvaluateLevelInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
return(EvaluateLevelInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
}
//从后台获取数据
internal static void LoadFromDAL(EvaluateLevelInfo pEvaluateLevelInfo, EvaluateLevel pEvaluateLevel)
{
pEvaluateLevelInfo.evaluateLevelId = pEvaluateLevel.EvaluateLevelId;
pEvaluateLevelInfo.evaluateName = pEvaluateLevel.EvaluateName;
pEvaluateLevelInfo.Loaded=true;
}
//从后台获取数据
internal static void LoadFromDAL(EvaluateLevelInfo pEvaluateLevelInfo, EvaluateLevel pEvaluateLevel)
{
pEvaluateLevelInfo.evaluateLevelId = pEvaluateLevel.EvaluateLevelId;
pEvaluateLevelInfo.evaluateName = pEvaluateLevel.EvaluateName;
pEvaluateLevelInfo.Loaded = true;
}
//数据持久化
internal static void SaveToDb(EvaluateLevelInfo pEvaluateLevelInfo, EvaluateLevel pEvaluateLevel,bool pIsNew)
{
pEvaluateLevel.EvaluateLevelId = pEvaluateLevelInfo.evaluateLevelId;
pEvaluateLevel.EvaluateName = pEvaluateLevelInfo.evaluateName;
pEvaluateLevel.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pEvaluateLevel.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(EvaluateLevelInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pEvaluateLevelInfo.evaluateLevelId = pEvaluateLevel.EvaluateLevelId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(EvaluateLevelInfo)))
{
ResetCache();
}
}
protected void PageInit()
{
EmployeeInfo em = (EmployeeInfo)Session["Employee"];
lblName.Text = em.EmployeeName.ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(em.PositionId));
lblPosition.Text = position.PositionName.ToString();
DepartInfo depart = new DepartInfo(Convert.ToInt32(em.DepartId));
lblDepart.Text = depart.DepartName.ToString();
int basid = Convert.ToInt32(Request["BasEmScoreId"].ToString());
BasEmScoreInfo bas = new BasEmScoreInfo(basid);
YearInfo year = new YearInfo(Convert.ToInt32(bas.YearId));
MonthInfo month = new MonthInfo(Convert.ToInt32(bas.MonthId));
lblDate.Text = year.YearName + "Äê" + month.MonthNames + "ÔÂ";
lblSelfbas1.Text = bas.Selfbas1.ToString();
lblSelfbas2.Text = bas.Selfbas2.ToString();
lblSelfbas3.Text = bas.Selfbas3.ToString();
lblSelfbas4.Text = bas.Selfbas4.ToString();
lblSelfbas5.Text = bas.Selfbas5.ToString();
lblSelfbas6.Text = bas.Selfbas6.ToString();
lblSelfbas7.Text = bas.Selfbas7.ToString();
lblSelfbas8.Text = bas.Selfbas8.ToString();
lblSelfbas9.Text = bas.Selfbas9.ToString();
lblSelfbas10.Text = bas.Selfbas10.ToString();
lblSelfbas11.Text = bas.Selfbas11.ToString();
lblSelfbas12.Text = bas.Selfbas12.ToString();
lblSelfbas13.Text = bas.Selfbas13.ToString();
lblSelfbas14.Text = bas.Selfbas14.ToString();
lblSelfbas15.Text = bas.Selfbas15.ToString();
lblSelfbas16.Text = bas.Selfbas16.ToString();
lblSelfbas17.Text = bas.Selfbas17.ToString();
lblUpbas1.Text = bas.Upbas1.ToString();
lblUpbas2.Text = bas.Upbas2.ToString();
lblUpbas3.Text = bas.Upbas3.ToString();
lblUpbas4.Text = bas.Upbas4.ToString();
lblUpbas5.Text = bas.Upbas5.ToString();
lblUpbas6.Text = bas.Upbas6.ToString();
lblUpbas7.Text = bas.Upbas7.ToString();
lblUpbas8.Text = bas.Upbas8.ToString();
lblUpbas9.Text = bas.Upbas9.ToString();
lblUpbas10.Text = bas.Upbas10.ToString();
lblUpbas11.Text = bas.Upbas11.ToString();
lblUpbas12.Text = bas.Upbas12.ToString();
lblUpbas13.Text = bas.Upbas13.ToString();
lblUpbas14.Text = bas.Upbas14.ToString();
lblUpbas15.Text = bas.Upbas15.ToString();
lblUpbas16.Text = bas.Upbas16.ToString();
lblUpbas17.Text = bas.Upbas17.ToString();
lblSecbas1.Text = bas.Secbas1.ToString();
lblSecbas2.Text = bas.Secbas2.ToString();
lblSecbas3.Text = bas.Secbas3.ToString();
lblSecbas4.Text = bas.Secbas4.ToString();
lblSecbas5.Text = bas.Secbas5.ToString();
lblSecbas6.Text = bas.Secbas6.ToString();
lblSecbas7.Text = bas.Secbas7.ToString();
lblSecbas8.Text = bas.Secbas8.ToString();
lblSecbas9.Text = bas.Secbas9.ToString();
lblSecbas10.Text = bas.Secbas10.ToString();
lblSecbas11.Text = bas.Secbas11.ToString();
lblSecbas12.Text = bas.Secbas12.ToString();
lblSecbas13.Text = bas.Secbas13.ToString();
lblSecbas14.Text = bas.Secbas14.ToString();
lblSecbas15.Text = bas.Secbas15.ToString();
lblSecbas16.Text = bas.Secbas16.ToString();
lblSecbas17.Text = bas.Secbas17.ToString();
lblTotalScore.Text = bas.TotalScore.ToString();
if (bas.EvaluateLevelId.ToString() != "")
{
EvaluateLevelInfo le = new EvaluateLevelInfo(Convert.ToInt32(bas.EvaluateLevelId));
lblLevel.Text = le.EvaluateName.ToString();
}
else
{
lblLevel.Text = "";
}
lblViews.Text = bas.UpViews.ToString();
}