private int SortStudent(StudentObj x, StudentObj y)
{
string xx = x.ClassName.PadLeft(20, '0');
xx += x.SeatNo.PadLeft(3, '0');
xx += x.StudentNumber.PadLeft(20, '0');
string yy = y.ClassName.PadLeft(20, '0');
yy += y.SeatNo.PadLeft(3, '0');
yy += y.StudentNumber.PadLeft(20, '0');
return(xx.CompareTo(yy));
}
//多元學習表現
private int GetScore(StudentObj obj)
{
int score = obj.ServiceLearningScore;
score += obj.MeritDemeritScore;
score += obj.SportFitnessScore;
if (score > 16)
{
score = 16;
}
return(score);
}
private void DataBuilding(object sender, DoWorkEventArgs e)
{
_BW.ReportProgress(0);
//取得結束時間 並轉成 像是 2018/05/10 格式
String endDate = dateTimeInput1.Value.ToString("yyyy/MM/dd");
SaveSetting();
//MappingData
_MappingData = new Dictionary <string, List <string> >();
foreach (DataGridViewRow row in dataGridViewX1.Rows)
{
if (row.Cells[0].Value != null)
{
string tagName = row.Cells[0].Value.ToString();
if (!_MappingData.ContainsKey(tagName))
{
_MappingData.Add(tagName, new List <string>());
}
if (row.Cells[1].Value != null)
{
string tagText = row.Cells[1].Value.ToString();
if (_Column2Items.ContainsKey(tagText))
{
string tagId = _Column2Items[tagText];
if (!_MappingData[tagName].Contains(tagId))
{
_MappingData[tagName].Add(tagId);
}
}
}
}
}
Dictionary <string, StudentObj> studentDic = new Dictionary <string, StudentObj>();
List <string> students = K12.Presentation.NLDPanels.Student.SelectedSource;
string ids = string.Join("','", students);
_BW.ReportProgress(10);
//基本資料
DataTable dt = _Q.Select("SELECT student.id,student.name,student.id_number,class.class_name,student.seat_no,student.student_number,student.birthdate,student.contact_phone,student.sms_phone,student.mailing_address,student.permanent_address,class.grade_year FROM student LEFT JOIN class ON ref_class_id = class.id WHERE student.id IN ('" + ids + "')");
foreach (DataRow row in dt.Rows)
{
StudentObj obj = new StudentObj(row);
if (!studentDic.ContainsKey(obj.Id))
{
studentDic.Add(obj.Id, obj);
}
}
_BW.ReportProgress(15);
//基本資料-TagId
dt = _Q.Select("SELECT ref_student_id,ref_tag_id FROM tag_student WHERE ref_student_id IN ('" + ids + "')");
foreach (DataRow row in dt.Rows)
{
string id = row["ref_student_id"].ToString();
string tagid = row["ref_tag_id"].ToString();
if (studentDic.ContainsKey(id))
{
if (!studentDic[id].TagIds.Contains(tagid))
{
studentDic[id].TagIds.Add(tagid);
}
}
}
_BW.ReportProgress(20);
//服務學習紀錄
dt = _Q.Select("SELECT ref_student_id,hours FROM $k12.service.learning.record WHERE ref_student_id IN ('" + ids + "') AND occur_date <= '" + endDate + "' ::timestamp");
foreach (DataRow row in dt.Rows)
{
string id = row["ref_student_id"].ToString();
if (studentDic.ContainsKey(id))
{
studentDic[id].ServiceHours += decimal.Parse(row["hours"].ToString());
}
}
_BW.ReportProgress(30);
//幹部紀錄
dt = _Q.Select("SELECT studentid,schoolyear,semester,cadrename FROM $behavior.thecadre WHERE studentid IN ('" + ids + "')");
List <string> checkList = new List <string>();
foreach (DataRow row in dt.Rows)
{
string id = row["studentid"].ToString();
string schoolyear = row["schoolyear"].ToString();
string semester = row["semester"].ToString();
string cadrename = row["cadrename"].ToString();
string key = id + "_" + schoolyear + "_" + semester;
if (!checkList.Contains(key))
{
if (studentDic.ContainsKey(id))
{
if (!cadrename.Contains("副"))
{
studentDic[id].CadreTimes++;
checkList.Add(key);
continue;
}
if (cadrename.Contains("副班") || cadrename.Contains("副社"))
{
studentDic[id].CadreTimes++;
checkList.Add(key);
continue;
}
}
}
}
_BW.ReportProgress(40);
////獎懲紀錄
//List<AutoSummaryRecord> records = AutoSummary.Select(students, null);
//foreach (AutoSummaryRecord record in records)
//{
// string id = record.RefStudentID;
// if (studentDic.ContainsKey(id))
// {
// studentDic[id].MeritA += record.MeritA;
// studentDic[id].MeritB += record.MeritB;
// studentDic[id].MeritC += record.MeritC;
// studentDic[id].DemeritA += record.DemeritA;
// studentDic[id].DemeritB += record.DemeritB;
// studentDic[id].DemeritC += record.DemeritC;
// }
//}
// 2018/5/15 穎驊新增，自羿均那邊拿到他調整好 高中職免試入學抓取資料的SQL
// 提出其中 獎懲的部分稍作調整，作為新的五專免試入學學生獎懲資料抓取方式
// 其最大的特色是，可以設定截止時間、過濾銷過紀錄、自動加總非明細資料(轉學生適用)、
// 且無論該學期有無學習歷程，只要有計獎懲一律計算，不會因為該學期休學而不計算
List <string> sidList = new List <string>();
foreach (string sid in studentDic.Keys)
{
sidList.Add("SELECT " + sid + "::BIGINT AS id ");
}
string target_student_s = String.Join(" UNION ALL ", sidList);
string sql = string.Format(@"WITH target_datetime AS(
SELECT
'{0}'::TIMESTAMP AS end_date
) ,target_student AS(
{1}
) ,target_sems_demerit AS(
SELECT
target_student.id
,CASE
WHEN SUM(大過) IS NULL
THEN 0
ELSE SUM(大過)
END AS 大過支數
,CASE
WHEN SUM(小過) IS NULL
THEN 0
ELSE SUM(小過)
END AS 小過支數
,CASE
WHEN SUM(警告) IS NULL
THEN 0
ELSE SUM(警告)
END AS 警告支數
FROM
target_student
LEFT OUTER JOIN (
SELECT
sems_moral_score.ref_student_id
, CAST( regexp_replace( xpath_string(sems_moral_score.initial_summary,'/InitialSummary/DisciplineStatistics/Demerit/@A'), '^$', '0') AS INTEGER) AS 大過
, CAST( regexp_replace( xpath_string(sems_moral_score.initial_summary,'/InitialSummary/DisciplineStatistics/Demerit/@B'), '^$', '0') AS INTEGER) AS 小過
, CAST( regexp_replace( xpath_string(sems_moral_score.initial_summary,'/InitialSummary/DisciplineStatistics/Demerit/@C'), '^$', '0') AS INTEGER) AS 警告
FROM
sems_moral_score
) AS sems_demerit ON target_student.id = sems_demerit.ref_student_id
GROUP BY
target_student.id
) ,target_demerit AS(
SELECT
target_student.id
,CASE
WHEN SUM(大過) IS NULL
THEN 0
ELSE SUM(大過)
END AS 大過支數
,CASE
WHEN SUM(小過) IS NULL
THEN 0
ELSE SUM(小過)
END AS 小過支數
,CASE
WHEN SUM(警告) IS NULL
THEN 0
ELSE SUM(警告)
END AS 警告支數
FROM
target_student
LEFT OUTER JOIN(
SELECT
discipline.ref_student_id
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Demerit/@A'), '^$', '0') AS INTEGER) AS 大過
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Demerit/@B'), '^$', '0') AS INTEGER) AS 小過
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Demerit/@C'), '^$', '0') AS INTEGER) AS 警告
FROM
target_datetime
LEFT OUTER JOIN discipline
ON discipline.occur_date <= target_datetime.end_date
WHERE
merit_flag = 0
AND xpath_string(discipline.detail,'/Discipline/Demerit/@Cleared') <> '是'
AND ref_student_id IN(SELECT * FROM target_student)
UNION ALL
SELECT
discipline.ref_student_id
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Demerit/@A'), '^$', '0') AS INTEGER) AS 大過
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Demerit/@B'), '^$', '0') AS INTEGER) AS 小過
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Demerit/@C'), '^$', '0') AS INTEGER) AS 警告
FROM
target_datetime
LEFT OUTER JOIN(
SELECT
*
, CASE
WHEN xpath_string(discipline.detail,'/Discipline/Demerit/@ClearDate') = ''
THEN '1970/1/1'::TIMESTAMP
ELSE xpath_string(discipline.detail,'/Discipline/Demerit/@ClearDate')::TIMESTAMP
END AS cleardate
FROM
discipline
) discipline ON discipline.occur_date <= target_datetime.end_date
WHERE
merit_flag = 0
AND xpath_string(discipline.detail,'/Discipline/Demerit/@Cleared') = '是'
AND discipline.cleardate > (SELECT end_date FROM target_datetime)
AND ref_student_id IN(SELECT id FROM target_student)
) AS target_discipline ON target_student.id = target_discipline.ref_student_id
GROUP BY target_student.id
) ,total_demerit AS(
SELECT
total.id
, CASE WHEN SUM(大過支數) IS NULL THEN 0 ELSE SUM(大過支數) END AS 大過支數
, CASE WHEN SUM(小過支數) IS NULL THEN 0 ELSE SUM(小過支數) END AS 小過支數
, CASE WHEN SUM(警告支數) IS NULL THEN 0 ELSE SUM(警告支數) END AS 警告支數
FROM(
SELECT * FROM target_demerit
UNION ALL
SELECT * FROM target_sems_demerit
) AS total
GROUP BY
total.id
) ,target_sems_merit AS(
SELECT
target_student.id
,CASE
WHEN SUM(大功) IS NULL
THEN 0
ELSE SUM(大功)
END AS 大功支數
,CASE
WHEN SUM(小功) IS NULL
THEN 0
ELSE SUM(小功)
END AS 小功支數
,CASE
WHEN SUM(嘉獎) IS NULL
THEN 0
ELSE SUM(嘉獎)
END AS 嘉獎支數
FROM
target_student
LEFT OUTER JOIN (
SELECT
sems_moral_score.ref_student_id
, CAST( regexp_replace( xpath_string(sems_moral_score.initial_summary,'/InitialSummary/DisciplineStatistics/Merit/@A'), '^$', '0') AS INTEGER) AS 大功
, CAST( regexp_replace( xpath_string(sems_moral_score.initial_summary,'/InitialSummary/DisciplineStatistics/Merit/@B'), '^$', '0') AS INTEGER) AS 小功
, CAST( regexp_replace( xpath_string(sems_moral_score.initial_summary,'/InitialSummary/DisciplineStatistics/Merit/@C'), '^$', '0') AS INTEGER) AS 嘉獎
FROM
sems_moral_score
) AS sems_merit ON target_student.id = sems_merit.ref_student_id
GROUP BY
target_student.id
) ,target_merit AS(
SELECT
ref_student_id AS id
,CASE
WHEN SUM(大功) IS NULL
THEN 0
ELSE SUM(大功)
END AS 大功支數
,CASE
WHEN SUM(小功) IS NULL
THEN 0
ELSE SUM(小功)
END AS 小功支數
,CASE
WHEN SUM(嘉獎) IS NULL
THEN 0
ELSE SUM(嘉獎)
END AS 嘉獎支數
FROM(
SELECT
discipline.ref_student_id
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Merit/@A'), '^$', '0') AS INTEGER) AS 大功
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Merit/@B'), '^$', '0') AS INTEGER) AS 小功
, CAST( regexp_replace( xpath_string(discipline.detail,'/Discipline/Merit/@C'), '^$', '0') AS INTEGER) AS 嘉獎
FROM
target_datetime
LEFT OUTER JOIN discipline
ON discipline.occur_date <= target_datetime.end_date
WHERE
merit_flag = 1
AND ref_student_id IN(SELECT * FROM target_student)
) AS target_discipline
GROUP BY ref_student_id
) ,total_merit AS (
SELECT
total.id
, CASE WHEN SUM(大功支數) IS NULL THEN 0 ELSE SUM(大功支數) END AS 大功支數
, CASE WHEN SUM(小功支數) IS NULL THEN 0 ELSE SUM(小功支數) END AS 小功支數
, CASE WHEN SUM(嘉獎支數) IS NULL THEN 0 ELSE SUM(嘉獎支數) END AS 嘉獎支數
FROM(
SELECT * FROM target_merit
UNION ALL
SELECT * FROM target_sems_merit
) AS total
GROUP BY
total.id
)
SELECT
target_student.id
,CASE WHEN total_merit.大功支數 is null THEN 0 ELSE total_merit.大功支數 END as 大功支數
,CASE WHEN total_merit.小功支數 is null THEN 0 ELSE total_merit.小功支數 END as 小功支數
,CASE WHEN total_merit.嘉獎支數 is null THEN 0 ELSE total_merit.嘉獎支數 END as 嘉獎支數
,CASE WHEN total_demerit.大過支數 is null THEN 0 ELSE total_demerit.大過支數 END as 大過支數
,CASE WHEN total_demerit.小過支數 is null THEN 0 ELSE total_demerit.小過支數 END as 小過支數
,CASE WHEN total_demerit.警告支數 is null THEN 0 ELSE total_demerit.警告支數 END as 警告支數
FROM
target_student
LEFT OUTER JOIN total_demerit
ON total_demerit.id = target_student.id
LEFT OUTER JOIN total_merit
ON total_merit.id = target_student.id
" , endDate, target_student_s);
QueryHelper qh = new QueryHelper();
DataTable dt_discipline = qh.Select(sql);
foreach (DataRow row in dt_discipline.Rows)
{
string id = "" + row["id"];
if (studentDic.ContainsKey(id))
{
studentDic[id].MeritA = int.Parse("" + row["大功支數"]);
studentDic[id].MeritB = int.Parse("" + row["小功支數"]);
studentDic[id].MeritC = int.Parse("" + row["嘉獎支數"]);
studentDic[id].DemeritA = int.Parse("" + row["大過支數"]);
studentDic[id].DemeritB = int.Parse("" + row["小過支數"]);
studentDic[id].DemeritC = int.Parse("" + row["警告支數"]);
}
}
_BW.ReportProgress(45);
_BW.ReportProgress(50);
//獎懲紀錄功過相抵
foreach (StudentObj obj in studentDic.Values)
{
obj.MeritDemeritTransfer();
}
_BW.ReportProgress(60);
//體適能
//先確認UDT存在
dt = _Q.Select("SELECT name FROM _udt_table where name='ischool_student_fitness'");
if (dt.Rows.Count > 0)
{
dt = _Q.Select("SELECT ref_student_id,sit_and_reach_degree, standing_long_jump_degree, sit_up_degree, cardiorespiratory_degree FROM $ischool_student_fitness WHERE ref_student_id IN ('" + ids + "')");
foreach (DataRow row in dt.Rows)
{
string id = row["ref_student_id"].ToString();
if (studentDic.ContainsKey(id))
{
//擇優判斷
if (GetScore(row) > studentDic[id].SportFitnessScore)
{
studentDic[id].sit_and_reach_degree = row["sit_and_reach_degree"].ToString();
studentDic[id].sit_up_degree = row["sit_up_degree"].ToString();
studentDic[id].standing_long_jump_degree = row["standing_long_jump_degree"].ToString();
studentDic[id].cardiorespiratory_degree = row["cardiorespiratory_degree"].ToString();
}
}
}
}
_BW.ReportProgress(65);
//均衡學習-年級對照
Dictionary <string, Dictionary <string, string> > SchoolyearSemesteerToGrade = new Dictionary <string, Dictionary <string, string> >();
foreach (JHSemesterHistoryRecord record in JHSemesterHistory.SelectByStudentIDs(students))
{
foreach (SemesterHistoryItem item in record.SemesterHistoryItems)
{
if (!SchoolyearSemesteerToGrade.ContainsKey(item.RefStudentID))
{
SchoolyearSemesteerToGrade.Add(item.RefStudentID, new Dictionary <string, string>());
}
string key = item.SchoolYear + "_" + item.Semester;
if (!SchoolyearSemesteerToGrade[item.RefStudentID].ContainsKey(key))
{
if (item.Semester == 1)
{
SchoolyearSemesteerToGrade[item.RefStudentID].Add(key, item.GradeYear + "上");
}
else if (item.Semester == 2)
{
SchoolyearSemesteerToGrade[item.RefStudentID].Add(key, item.GradeYear + "下");
}
}
}
}
_BW.ReportProgress(70);
//均衡學習-領域分數
List <JHSemesterScoreRecord> recs = JHSemesterScore.SelectByStudentIDs(students);
foreach (JHSemesterScoreRecord rec in recs)
{
foreach (DomainScore score in rec.Domains.Values)
{
string id = score.RefStudentID;
string key = score.SchoolYear + "_" + score.Semester;
string grade = "";
if (SchoolyearSemesteerToGrade.ContainsKey(id))
{
if (SchoolyearSemesteerToGrade[id].ContainsKey(key))
{
grade = SchoolyearSemesteerToGrade[id][key];
}
}
if (studentDic.ContainsKey(id))
{
string domain = score.Domain;
if ((domain == "健康與體育" || domain == "藝術與人文" || domain == "綜合活動") && !string.IsNullOrWhiteSpace(grade))
{
if (!studentDic[id].DomainScores.ContainsKey(domain))
{
studentDic[id].DomainScores.Add(domain, new Dictionary <string, decimal>());
}
if (!studentDic[id].DomainScores[domain].ContainsKey(grade))
{
decimal value = score.Score.HasValue ? score.Score.Value : 0;
studentDic[id].DomainScores[domain].Add(grade, value);
}
}
}
}
}
_BW.ReportProgress(80);
//排序
List <StudentObj> list = studentDic.Values.ToList();
list.Sort(SortStudent);
int progress = 80;
decimal per = (decimal)(100 - progress) / studentDic.Count;
int count = 0;
//Objects轉Table
Dictionary <string, int> CloumnIndex = new Dictionary <string, int>();
CloumnIndex.Add("身分證字統一編號", 0);
CloumnIndex.Add("學生姓名", 1);
CloumnIndex.Add("出生年(民國年)", 2);
CloumnIndex.Add("出生月", 3);
CloumnIndex.Add("出生日", 4);
CloumnIndex.Add("年級", 5);
CloumnIndex.Add("班級", 6);
CloumnIndex.Add("座號", 7);
CloumnIndex.Add("報名資格", 8);
CloumnIndex.Add("郵遞區號", 9);
CloumnIndex.Add("地址", 10);
CloumnIndex.Add("市內電話", 11);
CloumnIndex.Add("行動電話", 12);
CloumnIndex.Add("特種生加分類別", 13);
CloumnIndex.Add("報名費減免身分", 14);
CloumnIndex.Add("競賽", 15);
CloumnIndex.Add("擔任幹部", 16);
CloumnIndex.Add("服務時數", 17);
CloumnIndex.Add("服務學習", 18);
CloumnIndex.Add("累計嘉獎", 19);
CloumnIndex.Add("累計小功", 20);
CloumnIndex.Add("累計大功", 21);
CloumnIndex.Add("累計警告", 22);
CloumnIndex.Add("累計小過", 23);
CloumnIndex.Add("累計大過", 24);
CloumnIndex.Add("日常生活表現評量", 25);
CloumnIndex.Add("肌耐力", 26);
CloumnIndex.Add("柔軟度", 27);
CloumnIndex.Add("瞬發力", 28);
CloumnIndex.Add("心肺耐力", 29);
CloumnIndex.Add("體適能", 30);
CloumnIndex.Add("多元學習表現", 31);
CloumnIndex.Add("技藝教育成績", 32);
CloumnIndex.Add("技藝優良", 33);
CloumnIndex.Add("弱勢身分", 34);
CloumnIndex.Add("弱勢積分", 35);
CloumnIndex.Add("健康與體育", 36);
CloumnIndex.Add("藝術與人文", 37);
CloumnIndex.Add("綜合活動", 38);
CloumnIndex.Add("均衡學習", 39);
CloumnIndex.Add("家長意見", 40);
CloumnIndex.Add("導師意見", 41);
CloumnIndex.Add("輔導教師意見", 42);
CloumnIndex.Add("適性輔導", 43);
CloumnIndex.Add("其他比序項目_全民英檢", 44);
CloumnIndex.Add("合計", 45);
CloumnIndex.Add("報名「北區」五專學校代碼", 46);
CloumnIndex.Add("報名「中區」五專學校代碼", 47);
CloumnIndex.Add("報名「南區」五專學校代碼", 48);
CloumnIndex.Add("競賽名稱", 49);
//CloumnIndex.Add("其他比序項目_多益測驗", 50);
int index = 1;
Workbook wb = new Workbook(new MemoryStream(Properties.Resources.Template));
Cells cs = wb.Worksheets[0].Cells;
foreach (StudentObj obj in list)
{
cs[index, CloumnIndex["身分證字統一編號"]].PutValue(obj.IdNumber);
cs[index, CloumnIndex["學生姓名"]].PutValue(obj.Name);
cs[index, CloumnIndex["出生年(民國年)"]].PutValue(obj.Birth_Year.ToString().PadLeft(3, '0'));
cs[index, CloumnIndex["出生月"]].PutValue(obj.Birth_Month.ToString().PadLeft(2, '0'));
cs[index, CloumnIndex["出生日"]].PutValue(obj.Birth_Day.ToString().PadLeft(2, '0'));
cs[index, CloumnIndex["年級"]].PutValue(obj.GradeYear);
cs[index, CloumnIndex["班級"]].PutValue(obj.ClassName);
cs[index, CloumnIndex["座號"]].PutValue(obj.SeatNo);
cs[index, CloumnIndex["報名資格"]].PutValue(CheckTagId(obj.TagIds, 報名資格));
cs[index, CloumnIndex["郵遞區號"]].PutValue(obj.ZipCode);
cs[index, CloumnIndex["地址"]].PutValue(obj.Address);
cs[index, CloumnIndex["市內電話"]].PutValue(obj.Contact_Phone);
cs[index, CloumnIndex["行動電話"]].PutValue(obj.SMS_Phone);
cs[index, CloumnIndex["特種生加分類別"]].PutValue(CheckTagId(obj.TagIds, 特種生加分類別));
cs[index, CloumnIndex["報名費減免身分"]].PutValue(CheckTagId(obj.TagIds, 報名費減免身分));
cs[index, CloumnIndex["擔任幹部"]].PutValue(obj.CadreTimesScore);
cs[index, CloumnIndex["服務時數"]].PutValue(obj.ServiceHours);
cs[index, CloumnIndex["服務學習"]].PutValue(obj.ServiceLearningScore);
cs[index, CloumnIndex["累計嘉獎"]].PutValue(obj.MeritC);
cs[index, CloumnIndex["累計小功"]].PutValue(obj.MeritB);
cs[index, CloumnIndex["累計大功"]].PutValue(obj.MeritA);
cs[index, CloumnIndex["累計警告"]].PutValue(obj.DemeritC);
cs[index, CloumnIndex["累計小過"]].PutValue(obj.DemeritB);
cs[index, CloumnIndex["累計大過"]].PutValue(obj.DemeritA);
cs[index, CloumnIndex["日常生活表現評量"]].PutValue(obj.MeritDemeritScore);
cs[index, CloumnIndex["肌耐力"]].PutValue(obj.CheckScore("仰臥起坐"));
cs[index, CloumnIndex["柔軟度"]].PutValue(obj.CheckScore("坐姿體前彎"));
cs[index, CloumnIndex["瞬發力"]].PutValue(obj.CheckScore("立定跳遠"));
cs[index, CloumnIndex["心肺耐力"]].PutValue(obj.CheckScore("心肺適能"));
cs[index, CloumnIndex["體適能"]].PutValue(obj.SportFitnessScore);
int x = index + 1;
string formula = "=IF(P" + x + "+S" + x + "+Z" + x + "+AE" + x + ">16,16,P" + x + "+S" + x + "+Z" + x + "+AE" + x + ")";
cs[index, CloumnIndex["多元學習表現"]].Formula = formula;
string[] tag = CheckTagId(obj.TagIds);
cs[index, CloumnIndex["弱勢身分"]].PutValue(tag[0]);
cs[index, CloumnIndex["弱勢積分"]].PutValue(tag[1]);
Dictionary <string, decimal> dic = obj.GetDomainScores();
cs[index, CloumnIndex["健康與體育"]].PutValue(dic.ContainsKey("健康與體育") ? dic["健康與體育"] : 0);
cs[index, CloumnIndex["藝術與人文"]].PutValue(dic.ContainsKey("藝術與人文") ? dic["藝術與人文"] : 0);
cs[index, CloumnIndex["綜合活動"]].PutValue(dic.ContainsKey("綜合活動") ? dic["綜合活動"] : 0);
cs[index, CloumnIndex["均衡學習"]].PutValue(obj.DomainItemScore);
cs[index, CloumnIndex["其他比序項目_全民英檢"]].PutValue(CheckTagId(obj.TagIds, 其他比序項目_全民英檢));
//cs[index, CloumnIndex["其他比序項目_多益測驗"]].PutValue(CheckTagId(obj.TagIds, 其他比序項目_多益測驗));
formula = "=IF(AF" + x + "+AH" + x + "+AJ" + x + "+AN" + x + "+AR" + x + ">30,30,AF" + x + "+AH" + x + "+AJ" + x + "+AN" + x + "+AR" + x + ")";
cs[index, CloumnIndex["合計"]].Formula = formula;
index++;
count++;
progress += (int)(count * per);
_BW.ReportProgress(progress);
}
//wb.Worksheets[0].AutoFitColumns();
e.Result = wb;
}