Beispiel #1
0
        /// <summary>
        /// 获取导出类型列表
        /// </summary>
        /// <returns></returns>
        //public List<CS_Master_2> GetExportTypeList()
        //{
        //    using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
        //    {
        //        List<CS_Master_2> exportTypeList = new List<CS_Master_2>();
        //        Guid exportTypeVguid = Guid.Parse(Common.Tools.MasterVGUID.ExportType);
        //        exportTypeList = _dbMsSql.Queryable<CS_Master_2>().Where(i => i.VGUID == exportTypeVguid).ToList().OrderBy("MasterCode", OrderByType.Asc).ToList();

        //        return exportTypeList;
        //    }
        //}

        /// <summary>
        /// 查询问卷报表信息列表
        /// </summary>
        /// <param name="searchQuestionReport"></param>
        /// <returns></returns>
        public U_QuestionReport GetQuestionReport(Search_QuestionReport searchQuestionReport)
        {
            using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
            {
                U_QuestionReport reportEntity = new U_QuestionReport();
                string           sql          = @"EXEC usp_ExercisesAnswerquestionsInfotmation @ExercisesName,@DepartmentVGUID";
                DataTable        dt           = new DataTable();
                dt = _dbMsSql.GetDataTable(sql, new
                {
                    QuestionName    = searchQuestionReport.QuestionName,
                    DepartmentVGUID = string.IsNullOrEmpty(CurrentUser.GetCurrentUser().Department) ? "" : CurrentUser.GetCurrentUser().Department
                });
                //reportEntity.questionMain = GetExerciseMainList(dt);
                return(reportEntity);
            }
        }
        /// <summary>
        /// 获取导出类型
        /// </summary>
        /// <returns></returns>
        //public List<CS_Master_2> GetExportTypeList()
        //{
        //    return _ss.GetExportTypeList();
        //}

        /// <summary>
        /// 查询问卷报表信息列表
        /// </summary>
        /// <param name="searchScoreReport"></param>
        /// <returns></returns>
        public U_QuestionReport GetQuestionReport(Search_QuestionReport searchScoreReport)
        {
            return(_ss.GetQuestionReport(searchScoreReport));
        }