protected void gvScore_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //����ƶ���ÿ��ʱ��ɫ����Ч�� e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //�����������ָ����״Ϊ"С��" e.Row.Attributes["style"] = "Cursor:hand"; LinkButton lbtName = e.Row.FindControl("lbtnName") as LinkButton; Button btnSubmit = e.Row.FindControl("btnSubmit") as Button; if (lbtName.Text == "�κ���") { int basid = Convert.ToInt32(gvScore.DataKeys[e.Row.RowIndex]["DriverScoreId"].ToString()); DriverScoreInfo ds = new DriverScoreInfo(basid); if (ds.IsSubmit == 2) { btnSubmit.Enabled = false; } } else if (lbtName.Text == "�Ų�") { int fid = Convert.ToInt32(gvScore.DataKeys[e.Row.RowIndex]["NurseScoreId"].ToString()); NurseScoreInfo ma = new NurseScoreInfo(fid); if (ma.IsSubmit == 2) { btnSubmit.Enabled = false; } } } }
protected void btnSubmit_Click(object sender, EventArgs e) { int DsScoreId = Convert.ToInt32(((Button)sender).CommandArgument.ToString()); DriverScoreInfo ds = new DriverScoreInfo(DsScoreId); ds.IsSubmit = 1; int recvid = Convert.ToInt32(Common.getEmployeeIdOfAdmin()); EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(ds.EmployeeId)); EmployeeInfo ems = new EmployeeInfo(recvid); MessageInfo.Msgs1(recvid, ds.DriverScoreId, "~/Score/DriveScoreApprove.aspx", em.EmployeeName + "����������", em.EmployeeName, "daiban", em.EmployeeName + "����������"); MessageInfo.SendMail(ems.Qq, "����������", em.EmployeeName + "����������"); ds.Save(); gvDataBind(); }
public DriverScoreInfo GetDriverScoreInfoById(int DriverScoreId) { DriverScoreInfo driverScoreInfo = null;// try { driverScoreInfo = new DriverScoreInfo(DriverScoreId); } catch (AppException) { return null; } return driverScoreInfo; }
protected void btnSave_Click(object sender, EventArgs e) { if (IsPageValid()) { int emid = Convert.ToInt32(Session["EmployeeId"]); DriverScoreInfo ds = new DriverScoreInfo(); ds.EmployeeId = emid; ds.YearId = Convert.ToInt32(ddlYear.SelectedValue); ds.MonthId = Convert.ToInt32(ddlMonth.SelectedValue); ds.DateSpan = ddlYear.SelectedItem.Text + "��" + ddlMonth.SelectedItem.Text + "��"; ds.EvaluateLevelId = 6; ds.TotalScore = "����"; ds.IsSubmit = 0; ds.Selfds1 = Request.Form["Selfds1"].ToString(); ds.Selfds2 = Request.Form["Selfds2"].ToString(); ds.Selfds3 = Request.Form["Selfds3"].ToString(); ds.Selfds4 = Request.Form["Selfds4"].ToString(); ds.Selfds5 = Request.Form["Selfds5"].ToString(); ds.Selfds6 = Request.Form["Selfds6"].ToString(); ds.Selfds7 = Request.Form["Selfds7"].ToString(); ds.Selfds8 = Request.Form["Selfds8"].ToString(); ds.Selfds9 = Request.Form["Selfds9"].ToString(); ds.Selfds10 = Request.Form["Selfds10"].ToString(); ds.Selfds11 = Request.Form["Selfds11"].ToString(); ds.Selfds12 = Request.Form["Selfds12"].ToString(); ds.Selfds13 = Request.Form["Selfds13"].ToString(); ds.Selfds14 = Request.Form["Selfds14"].ToString(); ds.Selfds15 = Request.Form["Selfds15"].ToString(); ds.Selfds16 = Request.Form["Selfds16"].ToString(); ds.Selfds17 = Request.Form["Selfds17"].ToString(); ds.Selfds18 = Request.Form["Selfds18"].ToString(); ds.Selfds19 = Request.Form["Selfds19"].ToString(); ds.Selfds20 = Request.Form["Selfds20"].ToString(); ds.Selfds21 = Request.Form["Selfds21"].ToString(); ds.Selfds22 = Request.Form["Selfds22"].ToString(); ds.Selfds23 = Request.Form["Selfds23"].ToString(); ds.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('����ɹ���');</script>"); } }
protected void PageInit() { int dsid=Convert.ToInt32(Request["DriverScoreId"].ToString()); DriverScoreInfo ds=new DriverScoreInfo(dsid); EmployeeInfo em=new EmployeeInfo(Convert.ToInt32(ds.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=ds.YearId.ToString(); //ddlMonth.SelectedValue=ds.MonthId.ToString(); YearInfo year = new YearInfo(Convert.ToInt32(ds.YearId)); MonthInfo month = new MonthInfo(Convert.ToInt32(ds.MonthId)); lblDate.Text = year.YearName + "Äê" + month.MonthNames + "ÔÂ"; lblSelfds1.Text=ds.Selfds1.ToString(); lblSelfds2.Text=ds.Selfds2.ToString(); lblSelfds3.Text=ds.Selfds3.ToString(); lblSelfds4.Text=ds.Selfds4.ToString(); lblSelfds5.Text=ds.Selfds5.ToString(); lblSelfds6.Text=ds.Selfds6.ToString(); lblSelfds7.Text=ds.Selfds7.ToString(); lblSelfds8.Text=ds.Selfds8.ToString(); lblSelfds9.Text=ds.Selfds9.ToString(); lblSelfds10.Text=ds.Selfds10.ToString(); lblSelfds11.Text=ds.Selfds11.ToString(); lblSelfds12.Text=ds.Selfds12.ToString(); lblSelfds13.Text=ds.Selfds13.ToString(); lblSelfds14.Text=ds.Selfds14.ToString(); lblSelfds15.Text=ds.Selfds15.ToString(); lblSelfds16.Text=ds.Selfds16.ToString(); lblSelfds17.Text=ds.Selfds17.ToString(); lblSelfds18.Text=ds.Selfds18.ToString(); lblSelfds19.Text=ds.Selfds19.ToString(); lblSelfds20.Text=ds.Selfds20.ToString(); lblSelfds21.Text=ds.Selfds21.ToString(); lblSelfds22.Text=ds.Selfds22.ToString(); lblSelfds23.Text=ds.Selfds23.ToString(); lblUpds1.Text=ds.Upds1.ToString(); lblUpds2.Text=ds.Upds2.ToString(); lblUpds3.Text=ds.Upds3.ToString(); lblUpds4.Text=ds.Upds4.ToString(); lblUpds5.Text=ds.Upds5.ToString(); lblUpds6.Text=ds.Upds6.ToString(); lblUpds7.Text=ds.Upds7.ToString(); lblUpds8.Text=ds.Upds8.ToString(); lblUpds9.Text=ds.Upds9.ToString(); lblUpds10.Text=ds.Upds10.ToString(); lblUpds11.Text=ds.Upds11.ToString(); lblUpds12.Text=ds.Upds12.ToString(); lblUpds13.Text=ds.Upds13.ToString(); lblUpds14.Text=ds.Upds14.ToString(); lblUpds15.Text=ds.Upds15.ToString(); lblUpds16.Text=ds.Upds16.ToString(); lblUpds17.Text=ds.Upds17.ToString(); lblUpds18.Text=ds.Upds18.ToString(); lblUpds19.Text=ds.Upds19.ToString(); lblUpds20.Text=ds.Upds20.ToString(); lblUpds21.Text=ds.Upds21.ToString(); lblUpds22.Text=ds.Upds22.ToString(); lblUpds23.Text=ds.Upds23.ToString(); lblSectds1.Text=ds.Secds1.ToString(); lblSectds2.Text=ds.Secds2.ToString(); lblSectds3.Text=ds.Secds3.ToString(); lblSectds4.Text=ds.Secds4.ToString(); lblSectds5.Text=ds.Secds5.ToString(); lblSectds6.Text=ds.Secds6.ToString(); lblSectds7.Text=ds.Secds7.ToString(); lblSectds8.Text=ds.Secds8.ToString(); lblSectds9.Text=ds.Secds9.ToString(); lblSectds10.Text=ds.Secds10.ToString(); lblSectds11.Text=ds.Secds11.ToString(); lblSectds12.Text=ds.Secds12.ToString(); lblSectds13.Text=ds.Secds13.ToString(); lblSectds14.Text=ds.Secds14.ToString(); lblSectds15.Text=ds.Secds15.ToString(); lblSectds16.Text=ds.Secds16.ToString(); lblSectds17.Text=ds.Secds17.ToString(); lblSectds18.Text=ds.Secds18.ToString(); lblSectds19.Text=ds.Secds19.ToString(); lblSectds20.Text=ds.Secds20.ToString(); lblSectds21.Text=ds.Secds21.ToString(); lblSectds22.Text=ds.Secds22.ToString(); lblSectds23.Text=ds.Secds23.ToString(); lblTotalScore.Text = ds.TotalScore.ToString(); }
protected void gvScore_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //����ƶ���ÿ��ʱ��ɫ����Ч�� e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //�����������ָ����״Ϊ"С��" e.Row.Attributes["style"] = "Cursor:hand"; if (!Convert.IsDBNull(gvScore.DataKeys[e.Row.RowIndex].Value)) { int tesid = Convert.ToInt32(gvScore.DataKeys[e.Row.RowIndex].Value); DriverScoreInfo ds = new DriverScoreInfo(tesid); if (ds.IsSubmit != 0) { Button btnSubmit = e.Row.FindControl("btnSubmit") as Button; Button btnEdit = e.Row.FindControl("btnEdit") as Button; Button btnDelete = e.Row.FindControl("btnDelete") as Button; btnSubmit.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; } } } }
//数据持久化 internal static void SaveToDb(DriverScoreInfo pDriverScoreInfo, DriverScore pDriverScore,bool pIsNew) { pDriverScore.DriverScoreId = pDriverScoreInfo.driverScoreId; pDriverScore.DateSpan = pDriverScoreInfo.dateSpan; pDriverScore.EvaluateLevelId = pDriverScoreInfo.evaluateLevelId; pDriverScore.TotalScore = pDriverScoreInfo.totalScore; pDriverScore.UpViews = pDriverScoreInfo.upViews; pDriverScore.YearId = pDriverScoreInfo.yearId; pDriverScore.MonthId = pDriverScoreInfo.monthId; pDriverScore.EmployeeId = pDriverScoreInfo.employeeId; pDriverScore.IsSubmit = pDriverScoreInfo.isSubmit; pDriverScore.Selfds1 = pDriverScoreInfo.selfds1; pDriverScore.Selfds2 = pDriverScoreInfo.selfds2; pDriverScore.Selfds3 = pDriverScoreInfo.selfds3; pDriverScore.Selfds4 = pDriverScoreInfo.selfds4; pDriverScore.Selfds5 = pDriverScoreInfo.selfds5; pDriverScore.Selfds6 = pDriverScoreInfo.selfds6; pDriverScore.Selfds7 = pDriverScoreInfo.selfds7; pDriverScore.Selfds8 = pDriverScoreInfo.selfds8; pDriverScore.Selfds9 = pDriverScoreInfo.selfds9; pDriverScore.Selfds10 = pDriverScoreInfo.selfds10; pDriverScore.Selfds11 = pDriverScoreInfo.selfds11; pDriverScore.Selfds12 = pDriverScoreInfo.selfds12; pDriverScore.Selfds13 = pDriverScoreInfo.selfds13; pDriverScore.Selfds14 = pDriverScoreInfo.selfds14; pDriverScore.Selfds15 = pDriverScoreInfo.selfds15; pDriverScore.Selfds16 = pDriverScoreInfo.selfds16; pDriverScore.Selfds17 = pDriverScoreInfo.selfds17; pDriverScore.Selfds18 = pDriverScoreInfo.selfds18; pDriverScore.Selfds19 = pDriverScoreInfo.selfds19; pDriverScore.Selfds20 = pDriverScoreInfo.selfds20; pDriverScore.Selfds21 = pDriverScoreInfo.selfds21; pDriverScore.Selfds22 = pDriverScoreInfo.selfds22; pDriverScore.Selfds23 = pDriverScoreInfo.selfds23; pDriverScore.Upds1 = pDriverScoreInfo.upds1; pDriverScore.Upds2 = pDriverScoreInfo.upds2; pDriverScore.Upds3 = pDriverScoreInfo.upds3; pDriverScore.Upds4 = pDriverScoreInfo.upds4; pDriverScore.Upds5 = pDriverScoreInfo.upds5; pDriverScore.Upds6 = pDriverScoreInfo.upds6; pDriverScore.Upds7 = pDriverScoreInfo.upds7; pDriverScore.Upds8 = pDriverScoreInfo.upds8; pDriverScore.Upds9 = pDriverScoreInfo.upds9; pDriverScore.Upds10 = pDriverScoreInfo.upds10; pDriverScore.Upds11 = pDriverScoreInfo.upds11; pDriverScore.Upds12 = pDriverScoreInfo.upds12; pDriverScore.Upds13 = pDriverScoreInfo.upds13; pDriverScore.Upds14 = pDriverScoreInfo.upds14; pDriverScore.Upds15 = pDriverScoreInfo.upds15; pDriverScore.Upds16 = pDriverScoreInfo.upds16; pDriverScore.Upds17 = pDriverScoreInfo.upds17; pDriverScore.Upds18 = pDriverScoreInfo.upds18; pDriverScore.Upds19 = pDriverScoreInfo.upds19; pDriverScore.Upds20 = pDriverScoreInfo.upds20; pDriverScore.Upds21 = pDriverScoreInfo.upds21; pDriverScore.Upds22 = pDriverScoreInfo.upds22; pDriverScore.Upds23 = pDriverScoreInfo.upds23; pDriverScore.Secds1 = pDriverScoreInfo.secds1; pDriverScore.Secds2 = pDriverScoreInfo.secds2; pDriverScore.Secds3 = pDriverScoreInfo.secds3; pDriverScore.Secds4 = pDriverScoreInfo.secds4; pDriverScore.Secds5 = pDriverScoreInfo.secds5; pDriverScore.Secds6 = pDriverScoreInfo.secds6; pDriverScore.Secds7 = pDriverScoreInfo.secds7; pDriverScore.Secds8 = pDriverScoreInfo.secds8; pDriverScore.Secds9 = pDriverScoreInfo.secds9; pDriverScore.Secds10 = pDriverScoreInfo.secds10; pDriverScore.Secds11 = pDriverScoreInfo.secds11; pDriverScore.Secds12 = pDriverScoreInfo.secds12; pDriverScore.Secds13 = pDriverScoreInfo.secds13; pDriverScore.Secds14 = pDriverScoreInfo.secds14; pDriverScore.Secds15 = pDriverScoreInfo.secds15; pDriverScore.Secds16 = pDriverScoreInfo.secds16; pDriverScore.Secds17 = pDriverScoreInfo.secds17; pDriverScore.Secds18 = pDriverScoreInfo.secds18; pDriverScore.Secds19 = pDriverScoreInfo.secds19; pDriverScore.Secds20 = pDriverScoreInfo.secds20; pDriverScore.Secds21 = pDriverScoreInfo.secds21; pDriverScore.Secds22 = pDriverScoreInfo.secds22; pDriverScore.Secds23 = pDriverScoreInfo.secds23; pDriverScore.IsNew=pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pDriverScore.Save(UserName); } catch(Exception ex) { LogManager.getInstance().getLogger(typeof(DriverScoreInfo)).Error(ex); if(ex.Message.Contains("插入重复键"))//违反了唯一键 { throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pDriverScoreInfo.driverScoreId = pDriverScore.DriverScoreId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(DriverScoreInfo))) { ResetCache(); } }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List< DriverScoreInfo> pList, DriverScoreCollection pCollection) { foreach (DriverScore driverScore in pCollection) { DriverScoreInfo driverScoreInfo = new DriverScoreInfo(); LoadFromDAL(driverScoreInfo, driverScore ); pList.Add(driverScoreInfo); } }
//从后台获取数据 internal static void LoadFromDAL(DriverScoreInfo pDriverScoreInfo, DriverScore pDriverScore) { pDriverScoreInfo.driverScoreId = pDriverScore.DriverScoreId; pDriverScoreInfo.dateSpan = pDriverScore.DateSpan; pDriverScoreInfo.evaluateLevelId = pDriverScore.EvaluateLevelId; pDriverScoreInfo.totalScore = pDriverScore.TotalScore; pDriverScoreInfo.upViews = pDriverScore.UpViews; pDriverScoreInfo.yearId = pDriverScore.YearId; pDriverScoreInfo.monthId = pDriverScore.MonthId; pDriverScoreInfo.employeeId = pDriverScore.EmployeeId; pDriverScoreInfo.isSubmit = pDriverScore.IsSubmit; pDriverScoreInfo.selfds1 = pDriverScore.Selfds1; pDriverScoreInfo.selfds2 = pDriverScore.Selfds2; pDriverScoreInfo.selfds3 = pDriverScore.Selfds3; pDriverScoreInfo.selfds4 = pDriverScore.Selfds4; pDriverScoreInfo.selfds5 = pDriverScore.Selfds5; pDriverScoreInfo.selfds6 = pDriverScore.Selfds6; pDriverScoreInfo.selfds7 = pDriverScore.Selfds7; pDriverScoreInfo.selfds8 = pDriverScore.Selfds8; pDriverScoreInfo.selfds9 = pDriverScore.Selfds9; pDriverScoreInfo.selfds10 = pDriverScore.Selfds10; pDriverScoreInfo.selfds11 = pDriverScore.Selfds11; pDriverScoreInfo.selfds12 = pDriverScore.Selfds12; pDriverScoreInfo.selfds13 = pDriverScore.Selfds13; pDriverScoreInfo.selfds14 = pDriverScore.Selfds14; pDriverScoreInfo.selfds15 = pDriverScore.Selfds15; pDriverScoreInfo.selfds16 = pDriverScore.Selfds16; pDriverScoreInfo.selfds17 = pDriverScore.Selfds17; pDriverScoreInfo.selfds18 = pDriverScore.Selfds18; pDriverScoreInfo.selfds19 = pDriverScore.Selfds19; pDriverScoreInfo.selfds20 = pDriverScore.Selfds20; pDriverScoreInfo.selfds21 = pDriverScore.Selfds21; pDriverScoreInfo.selfds22 = pDriverScore.Selfds22; pDriverScoreInfo.selfds23 = pDriverScore.Selfds23; pDriverScoreInfo.upds1 = pDriverScore.Upds1; pDriverScoreInfo.upds2 = pDriverScore.Upds2; pDriverScoreInfo.upds3 = pDriverScore.Upds3; pDriverScoreInfo.upds4 = pDriverScore.Upds4; pDriverScoreInfo.upds5 = pDriverScore.Upds5; pDriverScoreInfo.upds6 = pDriverScore.Upds6; pDriverScoreInfo.upds7 = pDriverScore.Upds7; pDriverScoreInfo.upds8 = pDriverScore.Upds8; pDriverScoreInfo.upds9 = pDriverScore.Upds9; pDriverScoreInfo.upds10 = pDriverScore.Upds10; pDriverScoreInfo.upds11 = pDriverScore.Upds11; pDriverScoreInfo.upds12 = pDriverScore.Upds12; pDriverScoreInfo.upds13 = pDriverScore.Upds13; pDriverScoreInfo.upds14 = pDriverScore.Upds14; pDriverScoreInfo.upds15 = pDriverScore.Upds15; pDriverScoreInfo.upds16 = pDriverScore.Upds16; pDriverScoreInfo.upds17 = pDriverScore.Upds17; pDriverScoreInfo.upds18 = pDriverScore.Upds18; pDriverScoreInfo.upds19 = pDriverScore.Upds19; pDriverScoreInfo.upds20 = pDriverScore.Upds20; pDriverScoreInfo.upds21 = pDriverScore.Upds21; pDriverScoreInfo.upds22 = pDriverScore.Upds22; pDriverScoreInfo.upds23 = pDriverScore.Upds23; pDriverScoreInfo.secds1 = pDriverScore.Secds1; pDriverScoreInfo.secds2 = pDriverScore.Secds2; pDriverScoreInfo.secds3 = pDriverScore.Secds3; pDriverScoreInfo.secds4 = pDriverScore.Secds4; pDriverScoreInfo.secds5 = pDriverScore.Secds5; pDriverScoreInfo.secds6 = pDriverScore.Secds6; pDriverScoreInfo.secds7 = pDriverScore.Secds7; pDriverScoreInfo.secds8 = pDriverScore.Secds8; pDriverScoreInfo.secds9 = pDriverScore.Secds9; pDriverScoreInfo.secds10 = pDriverScore.Secds10; pDriverScoreInfo.secds11 = pDriverScore.Secds11; pDriverScoreInfo.secds12 = pDriverScore.Secds12; pDriverScoreInfo.secds13 = pDriverScore.Secds13; pDriverScoreInfo.secds14 = pDriverScore.Secds14; pDriverScoreInfo.secds15 = pDriverScore.Secds15; pDriverScoreInfo.secds16 = pDriverScore.Secds16; pDriverScoreInfo.secds17 = pDriverScore.Secds17; pDriverScoreInfo.secds18 = pDriverScore.Secds18; pDriverScoreInfo.secds19 = pDriverScore.Secds19; pDriverScoreInfo.secds20 = pDriverScore.Secds20; pDriverScoreInfo.secds21 = pDriverScore.Secds21; pDriverScoreInfo.secds22 = pDriverScore.Secds22; pDriverScoreInfo.secds23 = pDriverScore.Secds23; pDriverScoreInfo.Loaded=true; }
public void DeleteById(DriverScoreInfo pDriverScoreInfo) { DriverScoreInfo driverScoreInfo = new DriverScoreInfo(pDriverScoreInfo.DriverScoreId); driverScoreInfo.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<DriverScoreInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount) { if(pPageIndex<=1) pPageIndex=1; List< DriverScoreInfo> list = new List< DriverScoreInfo>(); Query q = DriverScore .CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression,pOrderBy.ToString()); DriverScoreCollection collection=new DriverScoreCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (DriverScore driverScore in collection) { DriverScoreInfo driverScoreInfo = new DriverScoreInfo(); LoadFromDAL(driverScoreInfo, driverScore); list.Add(driverScoreInfo); } pRecordCount=q.GetRecordCount(); return list; }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List<DriverScoreInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(DriverScoreInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return CachedEntityCommander.GetCache(cacheKey) as List< DriverScoreInfo>; } else { List< DriverScoreInfo> list =new List< DriverScoreInfo>(); DriverScoreCollection collection=new DriverScoreCollection(); Query qry = new Query(DriverScore.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach(DriverScore driverScore in collection) { DriverScoreInfo driverScoreInfo= new DriverScoreInfo(); LoadFromDAL(driverScoreInfo,driverScore); list.Add(driverScoreInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(DriverScoreInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return list; } }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(DriverScoreInfo pDriverScoreInfoFrom, DriverScoreInfo pDriverScoreInfoTo) { pDriverScoreInfoTo.DriverScoreId = pDriverScoreInfoFrom.driverScoreId; pDriverScoreInfoTo.DateSpan = pDriverScoreInfoFrom.dateSpan; pDriverScoreInfoTo.EvaluateLevelId = pDriverScoreInfoFrom.evaluateLevelId; pDriverScoreInfoTo.TotalScore = pDriverScoreInfoFrom.totalScore; pDriverScoreInfoTo.UpViews = pDriverScoreInfoFrom.upViews; pDriverScoreInfoTo.YearId = pDriverScoreInfoFrom.yearId; pDriverScoreInfoTo.MonthId = pDriverScoreInfoFrom.monthId; pDriverScoreInfoTo.EmployeeId = pDriverScoreInfoFrom.employeeId; pDriverScoreInfoTo.IsSubmit = pDriverScoreInfoFrom.isSubmit; pDriverScoreInfoTo.Selfds1 = pDriverScoreInfoFrom.selfds1; pDriverScoreInfoTo.Selfds2 = pDriverScoreInfoFrom.selfds2; pDriverScoreInfoTo.Selfds3 = pDriverScoreInfoFrom.selfds3; pDriverScoreInfoTo.Selfds4 = pDriverScoreInfoFrom.selfds4; pDriverScoreInfoTo.Selfds5 = pDriverScoreInfoFrom.selfds5; pDriverScoreInfoTo.Selfds6 = pDriverScoreInfoFrom.selfds6; pDriverScoreInfoTo.Selfds7 = pDriverScoreInfoFrom.selfds7; pDriverScoreInfoTo.Selfds8 = pDriverScoreInfoFrom.selfds8; pDriverScoreInfoTo.Selfds9 = pDriverScoreInfoFrom.selfds9; pDriverScoreInfoTo.Selfds10 = pDriverScoreInfoFrom.selfds10; pDriverScoreInfoTo.Selfds11 = pDriverScoreInfoFrom.selfds11; pDriverScoreInfoTo.Selfds12 = pDriverScoreInfoFrom.selfds12; pDriverScoreInfoTo.Selfds13 = pDriverScoreInfoFrom.selfds13; pDriverScoreInfoTo.Selfds14 = pDriverScoreInfoFrom.selfds14; pDriverScoreInfoTo.Selfds15 = pDriverScoreInfoFrom.selfds15; pDriverScoreInfoTo.Selfds16 = pDriverScoreInfoFrom.selfds16; pDriverScoreInfoTo.Selfds17 = pDriverScoreInfoFrom.selfds17; pDriverScoreInfoTo.Selfds18 = pDriverScoreInfoFrom.selfds18; pDriverScoreInfoTo.Selfds19 = pDriverScoreInfoFrom.selfds19; pDriverScoreInfoTo.Selfds20 = pDriverScoreInfoFrom.selfds20; pDriverScoreInfoTo.Selfds21 = pDriverScoreInfoFrom.selfds21; pDriverScoreInfoTo.Selfds22 = pDriverScoreInfoFrom.selfds22; pDriverScoreInfoTo.Selfds23 = pDriverScoreInfoFrom.selfds23; pDriverScoreInfoTo.Upds1 = pDriverScoreInfoFrom.upds1; pDriverScoreInfoTo.Upds2 = pDriverScoreInfoFrom.upds2; pDriverScoreInfoTo.Upds3 = pDriverScoreInfoFrom.upds3; pDriverScoreInfoTo.Upds4 = pDriverScoreInfoFrom.upds4; pDriverScoreInfoTo.Upds5 = pDriverScoreInfoFrom.upds5; pDriverScoreInfoTo.Upds6 = pDriverScoreInfoFrom.upds6; pDriverScoreInfoTo.Upds7 = pDriverScoreInfoFrom.upds7; pDriverScoreInfoTo.Upds8 = pDriverScoreInfoFrom.upds8; pDriverScoreInfoTo.Upds9 = pDriverScoreInfoFrom.upds9; pDriverScoreInfoTo.Upds10 = pDriverScoreInfoFrom.upds10; pDriverScoreInfoTo.Upds11 = pDriverScoreInfoFrom.upds11; pDriverScoreInfoTo.Upds12 = pDriverScoreInfoFrom.upds12; pDriverScoreInfoTo.Upds13 = pDriverScoreInfoFrom.upds13; pDriverScoreInfoTo.Upds14 = pDriverScoreInfoFrom.upds14; pDriverScoreInfoTo.Upds15 = pDriverScoreInfoFrom.upds15; pDriverScoreInfoTo.Upds16 = pDriverScoreInfoFrom.upds16; pDriverScoreInfoTo.Upds17 = pDriverScoreInfoFrom.upds17; pDriverScoreInfoTo.Upds18 = pDriverScoreInfoFrom.upds18; pDriverScoreInfoTo.Upds19 = pDriverScoreInfoFrom.upds19; pDriverScoreInfoTo.Upds20 = pDriverScoreInfoFrom.upds20; pDriverScoreInfoTo.Upds21 = pDriverScoreInfoFrom.upds21; pDriverScoreInfoTo.Upds22 = pDriverScoreInfoFrom.upds22; pDriverScoreInfoTo.Upds23 = pDriverScoreInfoFrom.upds23; pDriverScoreInfoTo.Secds1 = pDriverScoreInfoFrom.secds1; pDriverScoreInfoTo.Secds2 = pDriverScoreInfoFrom.secds2; pDriverScoreInfoTo.Secds3 = pDriverScoreInfoFrom.secds3; pDriverScoreInfoTo.Secds4 = pDriverScoreInfoFrom.secds4; pDriverScoreInfoTo.Secds5 = pDriverScoreInfoFrom.secds5; pDriverScoreInfoTo.Secds6 = pDriverScoreInfoFrom.secds6; pDriverScoreInfoTo.Secds7 = pDriverScoreInfoFrom.secds7; pDriverScoreInfoTo.Secds8 = pDriverScoreInfoFrom.secds8; pDriverScoreInfoTo.Secds9 = pDriverScoreInfoFrom.secds9; pDriverScoreInfoTo.Secds10 = pDriverScoreInfoFrom.secds10; pDriverScoreInfoTo.Secds11 = pDriverScoreInfoFrom.secds11; pDriverScoreInfoTo.Secds12 = pDriverScoreInfoFrom.secds12; pDriverScoreInfoTo.Secds13 = pDriverScoreInfoFrom.secds13; pDriverScoreInfoTo.Secds14 = pDriverScoreInfoFrom.secds14; pDriverScoreInfoTo.Secds15 = pDriverScoreInfoFrom.secds15; pDriverScoreInfoTo.Secds16 = pDriverScoreInfoFrom.secds16; pDriverScoreInfoTo.Secds17 = pDriverScoreInfoFrom.secds17; pDriverScoreInfoTo.Secds18 = pDriverScoreInfoFrom.secds18; pDriverScoreInfoTo.Secds19 = pDriverScoreInfoFrom.secds19; pDriverScoreInfoTo.Secds20 = pDriverScoreInfoFrom.secds20; pDriverScoreInfoTo.Secds21 = pDriverScoreInfoFrom.secds21; pDriverScoreInfoTo.Secds22 = pDriverScoreInfoFrom.secds22; pDriverScoreInfoTo.Secds23 = pDriverScoreInfoFrom.secds23; pDriverScoreInfoTo.Loaded=pDriverScoreInfoFrom.Loaded; }
public object SaveDriverScoreInfo(DriverScoreInfo driverScoreInfo) { driverScoreInfo.Save(); return driverScoreInfo . DriverScoreId; }
/// <summary> /// 复制为另一个对象 /// </summary> /// <param name="pIndustryTypeInfoTo"></param> public void CopyTo(DriverScoreInfo pDriverScoreInfoTo) { Copy(this, pDriverScoreInfoTo); }
protected void PageInit() { int dsid = Convert.ToInt32(Request["DsScoreId"].ToString()); DriverScoreInfo ds = new DriverScoreInfo(dsid); EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(ds.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 = ds.YearId.ToString(); ddlMonth.SelectedValue = ds.MonthId.ToString(); Selfds1 = ds.Selfds1.ToString(); Selfds2 = ds.Selfds2.ToString(); Selfds3 = ds.Selfds3.ToString(); Selfds4 = ds.Selfds4.ToString(); Selfds5 = ds.Selfds5.ToString(); Selfds6 = ds.Selfds6.ToString(); Selfds7 = ds.Selfds7.ToString(); Selfds8 = ds.Selfds8.ToString(); Selfds9 = ds.Selfds9.ToString(); Selfds10 = ds.Selfds10.ToString(); Selfds11 = ds.Selfds11.ToString(); Selfds12 = ds.Selfds12.ToString(); Selfds13 = ds.Selfds13.ToString(); Selfds14 = ds.Selfds14.ToString(); Selfds15 = ds.Selfds15.ToString(); Selfds16 = ds.Selfds16.ToString(); Selfds17 = ds.Selfds17.ToString(); Selfds18 = ds.Selfds18.ToString(); Selfds19 = ds.Selfds19.ToString(); Selfds20 = ds.Selfds20.ToString(); Selfds21 = ds.Selfds21.ToString(); Selfds22 = ds.Selfds22.ToString(); Selfds23 = ds.Selfds23.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { int dsid = Convert.ToInt32(Request["DriverScoreId"].ToString()); DriverScoreInfo ds = new DriverScoreInfo(dsid); ds.Upds1 = Request.Form["Upds1"].ToString(); ds.Upds2 = Request.Form["Upds2"].ToString(); ds.Upds3 = Request.Form["Upds3"].ToString(); ds.Upds4 = Request.Form["Upds4"].ToString(); ds.Upds5 = Request.Form["Upds5"].ToString(); ds.Upds6 = Request.Form["Upds6"].ToString(); ds.Upds7 = Request.Form["Upds7"].ToString(); ds.Upds8 = Request.Form["Upds8"].ToString(); ds.Upds9 = Request.Form["Upds9"].ToString(); ds.Upds10 = Request.Form["Upds10"].ToString(); ds.Upds11 = Request.Form["Upds11"].ToString(); ds.Upds12 = Request.Form["Upds12"].ToString(); ds.Upds13 = Request.Form["Upds13"].ToString(); ds.Upds14 = Request.Form["Upds14"].ToString(); ds.Upds15 = Request.Form["Upds15"].ToString(); ds.Upds16 = Request.Form["Upds16"].ToString(); ds.Upds17 = Request.Form["Upds17"].ToString(); ds.Upds18 = Request.Form["Upds18"].ToString(); ds.Upds19 = Request.Form["Upds19"].ToString(); ds.Upds20 = Request.Form["Upds20"].ToString(); ds.Upds21 = Request.Form["Upds21"].ToString(); ds.Upds22 = Request.Form["Upds22"].ToString(); ds.Upds23 = Request.Form["Upds23"].ToString(); ds.Secds1 = Convert.ToString(Math.Round(float.Parse(lblSelfds1.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds1"].ToString()), 2) * 0.6); ds.Secds2 = Convert.ToString(Math.Round(float.Parse(lblSelfds2.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds2"].ToString()), 2) * 0.6); ds.Secds3 = Convert.ToString(Math.Round(float.Parse(lblSelfds3.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds3"].ToString()), 2) * 0.6); ds.Secds4 = Convert.ToString(Math.Round(float.Parse(lblSelfds4.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds4"].ToString()), 2) * 0.6); ds.Secds5 = Convert.ToString(Math.Round(float.Parse(lblSelfds5.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds5"].ToString()), 2) * 0.6); ds.Secds6 = Convert.ToString(Math.Round(float.Parse(lblSelfds6.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds6"].ToString()), 2) * 0.6); ds.Secds7 = Convert.ToString(Math.Round(float.Parse(lblSelfds7.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds7"].ToString()), 2) * 0.6); ds.Secds8 = Convert.ToString(Math.Round(float.Parse(lblSelfds8.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds8"].ToString()), 2) * 0.6); ds.Secds9 = Convert.ToString(Math.Round(float.Parse(lblSelfds9.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds9"].ToString()), 2) * 0.6); ds.Secds10 = Convert.ToString(Math.Round(float.Parse(lblSelfds10.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds10"].ToString()), 2) * 0.6); ds.Secds11 = Convert.ToString(Math.Round(float.Parse(lblSelfds11.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds11"].ToString()), 2) * 0.6); ds.Secds12 = Convert.ToString(Math.Round(float.Parse(lblSelfds12.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds12"].ToString()), 2) * 0.6); ds.Secds13 = Convert.ToString(Math.Round(float.Parse(lblSelfds13.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds13"].ToString()), 2) * 0.6); ds.Secds14 = Convert.ToString(Math.Round(float.Parse(lblSelfds14.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds14"].ToString()), 2) * 0.6); ds.Secds15 = Convert.ToString(Math.Round(float.Parse(lblSelfds15.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds15"].ToString()), 2) * 0.6); ds.Secds16 = Convert.ToString(Math.Round(float.Parse(lblSelfds16.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds16"].ToString()), 2) * 0.6); ds.Secds17 = Convert.ToString(Math.Round(float.Parse(lblSelfds17.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds17"].ToString()), 2) * 0.6); ds.Secds18 = Convert.ToString(Math.Round(float.Parse(lblSelfds18.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds18"].ToString()), 2) * 0.6); ds.Secds19 = Convert.ToString(Math.Round(float.Parse(lblSelfds19.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds19"].ToString()), 2) * 0.6); ds.Secds20 = Convert.ToString(Math.Round(float.Parse(lblSelfds20.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds20"].ToString()), 2) * 0.6); ds.Secds21 = Convert.ToString(Math.Round(float.Parse(lblSelfds21.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds21"].ToString()), 2) * 0.6); ds.Secds22 = Convert.ToString(Math.Round(float.Parse(lblSelfds22.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds22"].ToString()), 2) * 0.6); ds.Secds23 = Convert.ToString(Math.Round(float.Parse(lblSelfds23.Text.ToString()), 2) * 0.4 + Math.Round(float.Parse(Request.Form["Upds23"].ToString()), 2) * 0.6); ds.TotalScore = Request.Form["hid"].ToString(); float Score = float.Parse(Request.Form["hid"].ToString()); if (Score > 90) { ds.EvaluateLevelId = 2; } else if (Score > 75 && Score < 90) { ds.EvaluateLevelId = 3; } else if (Score > 60 && Score < 75) { ds.EvaluateLevelId = 4; } else if (Score < 60) { ds.EvaluateLevelId = 5; } ds.IsSubmit = 2; ds.UpViews = Request.Form["UpViews"].ToString(); ds.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('����ɹ���');</script>"); }