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, "评分汇总");
    }
Example #3
0
    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, "员工确认");
    }