protected void btnImport_Click(object sender, ImageClickEventArgs e) { PerformanceTaskModel searchModel = new PerformanceTaskModel(); searchModel.TaskNo = txtSearchTask.Value.Trim(); //启用状态 searchModel.Title = inptSearchTitle.Value.Trim(); string selSearchTaskFlag = Request.Form["selSearchTaskFlag"].ToString(); if (selSearchTaskFlag != "0") { searchModel.TaskFlag = selSearchTaskFlag; } //启用状态 string selSearchTaskNum = Request.Form["selSearchTaskNum"].ToString(); if (selSearchTaskNum != "0") { searchModel.TaskNum = selSearchTaskNum; } string selTaskStatus = Request.Form["selTaskStatus"].ToString(); if (selTaskStatus != "0") { searchModel.Status = selTaskStatus; } string selSearchTaskYear = Request.Form["selSearchTaskYear"].ToString(); if (selSearchTaskYear != "0") { searchModel.TaskDate = selSearchTaskYear; } searchModel.EditFlag = txtSearchScoreEmployee.Value; //查询数据 DataTable dtData = PerformanceSummaryBus.SearchSurmmaryInfo(searchModel); //导出标题 string headerTitle = "被考核人|任务编号|任务主题|考核期间类型|考核期间|考核模板|考核总得分|累计扣分|累计加分|实际得分|考核等级|考核建议|总评人|总评时间"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "passEmployeeName|TaskNo|Title|TaskFlag|TaskNum|templateName|TotalScore|KillScore|AddScore|RealScore|LevelType|AdviceType|EvaluaterName|EvaluateDate"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "考核总评"); }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { PerformanceTaskModel searchModel = new PerformanceTaskModel(); searchModel.TaskNo = txtSearchTask.Value.Trim(); //启用状态 searchModel.Title = inptSearchTitle.Value.Trim(); string selSearchTaskFlag = Request.Form["selSearchTaskFlag"].ToString(); if (selSearchTaskFlag != "0") { searchModel.TaskFlag = selSearchTaskFlag; } string selSearchTaskNum = Request.Form["selSearchTaskNum"].ToString(); //启用状态 if (selSearchTaskNum != "0") { searchModel.TaskNum = selSearchTaskNum; } string selSearchTaskYear = Request.Form["selSearchTaskYear"].ToString(); if (selSearchTaskYear != "0") { searchModel.TaskDate = selSearchTaskYear; } //查询数据 DataTable dtData = PerformanceSummaryBus.SearchTaskInfo(searchModel); //导出标题 string headerTitle = "任务编号|任务主题|考核期间类型|考核期间|考核开始日期|考核结束日期|任务状态|创建人|创建时间|汇总人|汇总日期"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "TaskNo|Title|TaskFlag|TaskNum|StartDate|EndDate|Status|Creator|CreateDate|Summaryer|SummaryDate"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "评分汇总"); }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { PerformanceTaskModel searchModel = new PerformanceTaskModel(); searchModel.TaskFlag = Request.Form["selSearchTaskFlag"].ToString(); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; searchModel.EditFlag = userInfo.EmployeeID.ToString(); searchModel.CompanyCD = userInfo.CompanyCD; //查询数据 DataTable dtData = PerformanceSummaryBus.SearchSurmmaryCheckInfo(searchModel); //导出标题 string headerTitle = "被考核人|任务主题|考核期间类型|考核期间|考核模板|考核总得分|累计扣分|累计加分|实际得分|考核等级|考核建议|总评人|总评时间|确认时间"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "passEmployeeName|Title|TaskFlag|TaskNum|templateName|TotalScore|KillScore|AddScore|RealScore|LevelType|AdviceType|EvaluaterName|EvaluateDate|SignDate"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "员工确认"); }