public void Check()
{
ZipFileManager.ZipFileManager zfm = new ZipFileManager.ZipFileManager();
ClsNameRuleTest cnt = new ClsNameRuleTest();
ExcelParser.ExcelParser ep = new ExcelParser.ExcelParser();
string zipFilePath = "";
List <string> filePaths = null;
try
{
zipFilePath = zfm.UnZip(@"C:\Users\v-misun\Desktop\a\报告.zip");
filePaths = zfm.FindFile(zipFilePath, "*知识领域覆盖表*.*");
}
catch (Exception x)
{
AnalysisLog.AddLog("【系统】" + x.Message);
return;
}
if (filePaths.Count() == 0)
{
AnalysisLog.AddLog("【系统】未找到知识领域覆盖表");
return;
}
foreach (var path in filePaths)
{
try
{
ep.Init(path);
}
catch (Exception x)
{
AnalysisLog.AddLog("【系统】" + x.Message);
return;
}
try
{
// 数学+自然科学类占总分不得低于15%
int score = ep.GetScore("数学类") + ep.GetScore("自然科学类");
int totalScore = ep.GetTotalScore();
if ((double)score / (double)totalScore < 0.15)
{
AnalysisLog.AddLog(string.Format("【期望】数学+自然科学类占总分不得低于15% 【实际】{0:P2}", (double)score / (double)totalScore));
}
}
catch (Exception x)
{
AnalysisLog.AddLog("【系统】" + x.Message);
}
try
{
// 数学类课程名包含或者不得包含规则
List <ClassWithScore> classList = ep.GetClassName("数学类");
foreach (var c in classList)
{
bool ret = cnt.TestName(c.ClassName, "数学类");
if (ret == false)
{
AnalysisLog.AddLog(string.Format("【期望】数学类课程名包含或者不得包含规则 【实际】数学类课程名包含{0}", c.ClassName));
}
}
}
catch (Exception x)
{
AnalysisLog.AddLog("【系统】" + x.Message);
}
try
{
// 需存在教学大纲
List <string> subjectFilePaths = zfm.FindFile(zipFilePath, "*教学大纲.*");
SubjectParserCheck sp = new SubjectParserCheck();
if (subjectFilePaths.Count() == 0)
{
AnalysisLog.AddLog("【系统】无法找到教学大纲");
}
else
{
string subjectFilePath = subjectFilePaths[0];
sp.Init(subjectFilePath);
// 专业核心课在课程大纲出出现
List <string> professionalCoreClassList = ep.GetProfessinalCoreClass();
if (professionalCoreClassList.Count() > 0)
{
foreach (var i in professionalCoreClassList)
{
var ret = sp.FindClass(i);
if (ret == false)
{
AnalysisLog.AddLog(string.Format("【期望】专业核心课在教学大纲出现 【实际】课程{0}没有出现", i));
}
}
}
else
{
AnalysisLog.AddLog("【期望】专业核心课在教学大纲出现 【实际】未找到专业核心课");
}
}
}
catch (Exception x)
{
AnalysisLog.AddLog("【系统】" + x.Message);
}
try
{
// 需存在培养方案
List <string> trainingFilePaths = zfm.FindFile(zipFilePath, "*培养方案.*");
TrainingPlan.TrainingPlan tp = new TrainingPlan.TrainingPlan();
if (trainingFilePaths.Count() == 0)
{
AnalysisLog.AddLog("【系统】无法找到培养方案");
}
else
{
string trainingFilePath = trainingFilePaths[0];
tp.Init(trainingFilePath);
// 课程和学分在培养方案中可查询到
List <ClassWithScore> allClassWithScore = new List <ClassWithScore>();
allClassWithScore.Concat(ep.GetClassName("数学类"));
foreach (var i in allClassWithScore)
{
// 检查是否有课程
var isFindClass = tp.FindClass(i.ClassName);
if (isFindClass)
{
var isFindClassAndScore = tp.FindClassAndScore(i.ClassName, i.Score);
if (!isFindClassAndScore)
{
AnalysisLog.AddLog(string.Format("【期望】课程{0}与学分{1}在培养方案中存在 【实际】课程{0}学分与期望不符合", i.ClassName, i.Score));
}
}
else
{
AnalysisLog.AddLog(string.Format("【期望】课程{0}与学分{1}在培养方案中存在 【实际】课程{0}不存在", i.ClassName, i.Score));
}
}
}
}catch (Exception x)
{
AnalysisLog.AddLog("【系统】" + x.Message);
}
}
ep.Dispose();
}
public void Check()
{
ZipFileManager.ZipFileManager zfm = new ZipFileManager.ZipFileManager();
ClsNameRuleTest cnt = new ClsNameRuleTest();
ExcelParser.ExcelParser ep = new ExcelParser.ExcelParser();
string zipFilePath = "";
try
{
zipFilePath = zfm.UnZip(@"C:\Users\v-misun\Desktop\a\报告.zip");
}
catch (Exception x)
{
AnalysisResult.AnalysisLog.AddLog("【系统】" + x.Message);
}
SubjectParserCheck subjectParserCheck = new SubjectParserCheck();
try
{
// 找到教学大纲并进行初始化
var trainingPlan = zfm.FindFile(zipFilePath, "*教学大纲.*");
if (trainingPlan != null && trainingPlan.Count > 0)
{
subjectParserCheck.Init(trainingPlan.FirstOrDefault());
}
else
{
AnalysisResult.AnalysisLog.AddLog("【系统】无法找到教学大纲");
}
}
catch (Exception x)
{
AnalysisResult.AnalysisLog.AddLog("【系统】" + x.Message);
}
try
{
// 找到课程体系对毕业要求指标点的支撑关系表excel
var supportClassFiles = zfm.FindFile(zipFilePath, "*支撑关系表.*");
List <StrongSupportClass> strongSupportClassList = null;
if (supportClassFiles != null && supportClassFiles.Count > 0)
{
ep.Init(supportClassFiles.FirstOrDefault());
strongSupportClassList = ep.GetHighSupportClass();
}
else
{
AnalysisResult.AnalysisLog.AddLog("【系统】无法找到课程体系对毕业要求的支持关系表");
}
// 找到强支撑课程需要在课程大纲中出现，并且对应相应的支撑点。
if (strongSupportClassList != null && strongSupportClassList.Count > 0)
{
foreach (var strongSupportClass in strongSupportClassList)
{
var isHasClass = subjectParserCheck.FindClass(strongSupportClass.ClassName);
if (!isHasClass)
{
AnalysisResult.AnalysisLog.AddLog(string.Format("【期望】课程大纲中存在课程{0} 【实际】没有找到课程{0}", strongSupportClass.ClassName));
continue;
}
foreach (var supportPoint in strongSupportClass.SupportPoint)
{
var isHasSupportPoint = subjectParserCheck.FindClassWithSupportPoint(strongSupportClass.ClassName, supportPoint);
if (!isHasSupportPoint)
{
AnalysisResult.AnalysisLog.AddLog(string.Format("【期望】课程大纲中存在课程{0}与支撑点{1} 【实际】没有支撑点{1}", strongSupportClass.ClassName, supportPoint));
}
}
}
}
}
catch (Exception x)
{
AnalysisResult.AnalysisLog.AddLog("【系统】" + x.Message);
}
ep.Dispose();
}