public static void main()
{ // [ischoolkingdom] Vicky更動，原107年五專(優先)免試入學相關報表，移除"107年"字樣
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
item1["報表"]["成績相關報表"]["五專(優先)免試入學相關報表"]["北中南五專(優先)免試入學集體報名表"].Enable = false;
item1["報表"]["成績相關報表"]["五專(優先)免試入學相關報表"]["北中南五專(優先)免試入學集體報名表"].Click += delegate
{
Report report = new Report();
report.ShowDialog();
};
K12.Presentation.NLDPanels.Student.SelectedSourceChanged += delegate
{
if (K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0 && Permissions.五專集體報名表權限)
{
item1["報表"]["成績相關報表"]["五專(優先)免試入學相關報表"]["北中南五專(優先)免試入學集體報名表"].Enable = true;
}
else
{
item1["報表"]["成績相關報表"]["五專(優先)免試入學相關報表"]["北中南五專(優先)免試入學集體報名表"].Enable = false;
}
};
//權限設定
Catalog permission = RoleAclSource.Instance["學生"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.五專集體報名表, "北中南五專(優先)免試入學集體報名表"));
}
public static void Main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
item1["報表"].Image = Properties.Resources.Report;
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
item1["報表"]["學籍相關報表"]["休學證明書"].Enable = false;
item1["報表"]["學籍相關報表"]["休學證明書"].Click += delegate
{
DropOutForm form = new DropOutForm(K12.Presentation.NLDPanels.Student.SelectedSource);
form.ShowDialog();
};
K12.Presentation.NLDPanels.Student.SelectedSourceChanged += delegate
{
if (K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0 && Permissions.休學證明書權限)
{
item1["報表"]["學籍相關報表"]["休學證明書"].Enable = true;
}
else
{
item1["報表"]["學籍相關報表"]["休學證明書"].Enable = false;
}
};
//權限設定
Catalog permission = RoleAclSource.Instance["學生"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.休學證明書, "休學證明書"));
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
//權限設定
Catalog permission2 = RoleAclSource.Instance["學生"]["功能按鈕"];
permission2.Add(new RibbonFeature("{A5A44C03-6835-42C4-BAE6-6C932AC3B4BB}", "ConductGradeReport(for Grade 5-12)"));
var btnReport2 = item1["報表"]["成績相關報表"]["ConductGradeReport(for Gr.5-12;2015 年以後適用)"];
btnReport2.Image = Properties.Resources.report_3_xxl;
btnReport2.Enable = false;
btnReport2.Click += delegate
{
new SemesterReportCard().ShowDialog();
};
K12.Presentation.NLDPanels.Student.SelectedSourceChanged += delegate
{
if (K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0 &&
FISCA.Permission.UserAcl.Current["{A5A44C03-6835-42C4-BAE6-6C932AC3B4BB}"].Executable
)
{
btnReport2.Enable = true;
}
else
{
btnReport2.Enable = false;
}
};
//權限設定
Catalog permission = RoleAclSource.Instance["學生"]["功能按鈕"];
permission.Add(new RibbonFeature("{03880A25-AE37-468E-BEC9-C0BC51C3D269}", "質性評量成績單(for Grade 1-4)"));
var btnReport = item1["報表"]["成績相關報表"]["質性評量成績單(for Gr.1-4;2015 年以後適用)"];
btnReport.Image = Properties.Resources.report_3_xxl;
btnReport.Enable = false;
btnReport.Click += delegate
{
new GradeYearReportCard().ShowDialog();
};
K12.Presentation.NLDPanels.Student.SelectedSourceChanged += delegate
{
if (K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0 &&
FISCA.Permission.UserAcl.Current["{03880A25-AE37-468E-BEC9-C0BC51C3D269}"].Executable
)
{
btnReport.Enable = true;
}
else
{
btnReport.Enable = false;
}
};
}
static public void Main()
{
FISCA.Presentation.RibbonBarItem report = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
report["報表"]["公務統計相關報表"]["原住民族別統計"].Click += delegate
{
Form2 f = new Form2();
f.ShowDialog();
};
}
public static void main()
{
{
Catalog permission = RoleAclSource.Instance["教務作業"]["學生家長查詢"];
permission.Add(new RibbonFeature("{9C50900E-56C2-4ADC-A53B-DAE771D2F0EF}", "關閉線上查詢"));
FISCA.Presentation.RibbonBarItem eduitem1 = FISCA.Presentation.MotherForm.RibbonBarItems["教務作業", "學生家長查詢"];
var btn = eduitem1["關閉線上查詢"];
btn.Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
btn.Enable = FISCA.Permission.UserAcl.Current["{9C50900E-56C2-4ADC-A53B-DAE771D2F0EF}"].Executable;
btn.Click += delegate
{
new BlockConfig().ShowDialog();
};
}
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["教務作業", "資料統計"];
item1["報表"].Image = Properties.Resources.Report;
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
item1["報表"]["高中職學校學生異動報告"].Enable = Permissions.高中職學校學生異動報告權限;
item1["報表"]["高中職學校學生異動報告"].Click += delegate
{
Form1 fm = new Form1();
fm.ShowDialog();
};
//權限設定
Catalog permission = RoleAclSource.Instance["教務作業"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.高中職學校學生異動報告, "高中職學校學生異動報告"));
}
public static void Main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["教務作業", "資料統計"];
item1["報表"].Image = Properties.Resources.Report;
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
item1["報表"]["班級及學生概況1"].Enable = Permissions.班級及學生概況1權限;
item1["報表"]["班級及學生概況1"].Click += delegate
{
Printer printer = new Printer();
printer.Start();
};
//權限設定
Catalog permission = RoleAclSource.Instance["教務作業"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.班級及學生概況1, "班級及學生概況1"));
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學務作業", "資料統計"];
item1["報表"].Image = Properties.Resources.Report;
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
item1["報表"]["大過累計達標準名單(客製)"].Enable = Permissions.犯過累計滿2大過名單權限;
item1["報表"]["大過累計達標準名單(客製)"].Click += delegate
{
Printer printer = new Printer();
printer.ShowDialog();
};
//權限設定
Catalog permission = RoleAclSource.Instance["學務作業"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.犯過累計滿2大過名單, "大過累計達標準名單(客製)"));
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
item1["報表"]["學籍相關報表"]["學籍表(雙語部)"].Enable = false;
item1["報表"]["學籍相關報表"]["學籍表(雙語部)"].Click += delegate
{
new Reporter(K12.Presentation.NLDPanels.Student.SelectedSource).ShowDialog();
};
K12.Presentation.NLDPanels.Student.SelectedSourceChanged += delegate
{
item1["報表"]["學籍相關報表"]["學籍表(雙語部)"].Enable = K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0 && Permissions.StudentRecordReport權限;
};
Catalog permission = RoleAclSource.Instance["學生"]["報表"];
permission.Add(new RibbonFeature(Permissions.StudentRecordReport, "學籍表(雙語部)"));
}
public static void Main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["班級", "資料統計"];
item1["報表"]["成績相關報表"]["班級學期成績單"].Enable = false;
item1["報表"]["成績相關報表"]["班級學期成績單"].Click += delegate
{
new MainForm().ShowDialog();
};
K12.Presentation.NLDPanels.Class.SelectedSourceChanged += delegate
{
item1["報表"]["成績相關報表"]["班級學期成績單"].Enable = K12.Presentation.NLDPanels.Class.SelectedSource.Count > 0 && Permissions.班級學期成績單權限;
};
//權限設定
Catalog permission = RoleAclSource.Instance["班級"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.班級學期成績單, "班級學期成績單"));
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["課程", "教務"];
item1["複製課程成績"].Image = Properties.Resources.attribute_up_64;
item1["複製課程成績"].Enable = false;
item1["複製課程成績"].Click += delegate
{
new MainForm().ShowDialog();
};
K12.Presentation.NLDPanels.Course.SelectedSourceChanged += delegate
{
item1["複製課程成績"].Enable = Permissions.CopyCourseScore權限 && K12.Presentation.NLDPanels.Course.SelectedSource.Count == 1;
};
Catalog permission1 = RoleAclSource.Instance["課程"]["功能按鈕"];
permission1.Add(new RibbonFeature(Permissions.CopyCourseScore, "複製課程成績"));
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["班級", "資料統計"];
item1["報表"].Image = Properties.Resources.Report;
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
K12.Presentation.NLDPanels.Class.SelectedSourceChanged += delegate
{
item1["報表"]["學務相關報表"]["懲戒特殊表現(功過相抵)"].Enable = Permissions.懲戒特殊表現權限 && (K12.Presentation.NLDPanels.Class.SelectedSource.Count > 0);
};
item1["報表"]["學務相關報表"]["懲戒特殊表現(功過相抵)"].Click += delegate
{
Printer printer = new Printer(K12.Presentation.NLDPanels.Class.SelectedSource);
printer.ShowDialog();
};
//權限設定
Catalog permission = RoleAclSource.Instance["班級"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.懲戒特殊表現, "懲戒特殊表現(功過相抵)"));
}
public static void Main()
{
//學生
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
item1["報表"]["成績相關報表"]["學期成績通知單(含補考成績)"].Enable = false;
item1["報表"]["成績相關報表"]["學期成績通知單(含補考成績)"].Click += delegate
{
new MainForm(MainForm.PrintType.學生).ShowDialog();
};
K12.Presentation.NLDPanels.Student.SelectedSourceChanged += delegate
{
item1["報表"]["成績相關報表"]["學期成績通知單(含補考成績)"].Enable = K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0 && Permissions.學生學期成績通知單權限;
};
//權限設定
Catalog permission = RoleAclSource.Instance["學生"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.學生學期成績通知單, "學期成績通知單(含補考成績)"));
//班級
FISCA.Presentation.RibbonBarItem item2 = FISCA.Presentation.MotherForm.RibbonBarItems["班級", "資料統計"];
item2["報表"]["成績相關報表"]["學期成績通知單(含補考成績)"].Enable = false;
item2["報表"]["成績相關報表"]["學期成績通知單(含補考成績)"].Click += delegate
{
new MainForm(MainForm.PrintType.班級).ShowDialog();
};
K12.Presentation.NLDPanels.Class.SelectedSourceChanged += delegate
{
item2["報表"]["成績相關報表"]["學期成績通知單(含補考成績)"].Enable = K12.Presentation.NLDPanels.Class.SelectedSource.Count > 0 && Permissions.班級學期成績通知單權限;
};
//權限設定
Catalog permission2 = RoleAclSource.Instance["班級"]["功能按鈕"];
permission2.Add(new RibbonFeature(Permissions.班級學期成績通知單, "學期成績通知單(含補考成績)"));
}
public static void main()
{
//第一個 RibbonBar 功能
FISCA.Presentation.RibbonBarItem item = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "康橋"];
item["第一個程式"].Enable = FISCA.Permission.UserAcl.Current["09613d9c-56b6-4511-b046-5b40689d5955"].Executable;
item["第一個程式"].Click += delegate
{
MessageBox.Show("Hello FISCA!");
};
//權限控管
Catalog ribbon = RoleAclSource.Instance["學生"]["功能按鈕"];
ribbon.Add(new RibbonFeature("09613d9c-56b6-4511-b046-5b40689d5955", "是否執行Hello"));
//Sync UDT Schema
FISCA.UDT.SchemaManager sch = new FISCA.UDT.SchemaManager(FISCA.Authentication.DSAServices.DefaultConnection);
sch.SyncSchema(new SiblingRecord());
//ADD資料項目
K12.Presentation.NLDPanels.Student.AddDetailBulider(
new FISCA.Presentation.DetailBulider <UCSiblingItem>());
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["教務作業", "資料統計"];
item1["報表"].Image = Properties.Resources.Report;
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
item1["報表"]["新生入學方式統計表"].Enable = Permissions.新生入學方式統計表權限;
item1["報表"]["新生入學方式統計表"].Click += delegate
{
Form2 form = new Form2();
form.ShowDialog();
};
//權限設定
Catalog permission = RoleAclSource.Instance["教務作業"]["功能按鈕"];
permission.Add(new RibbonFeature(Permissions.新生入學方式統計表, "新生入學方式統計表"));
//2017/2/8 穎驊註解，原本因應公務統計報表 "新生入學方式統計報表"項目 而新增提供的預設類別項目，
//為了防止 所有使用本類別模組的學校(包含 沒有使用公務統計報表模組的學校) 一併被提供到預設定類別項目
//將下面的CODE 自MOD_Tagging模組 Tagging 專案 其 Program 移轉過來
//如此一來就只有 使用公務統計報表模組的學校會被新增類別項目
#region 加入預設的入學方式、入學身分、原住民類別
List <string> EnterSchoolWays = new List <string>();
List <string> EnterSchoolIdentities = new List <string>();
List <string> aboList = new List <string>();
List <string> aboList2 = new List <string>();
//九種入學方式
EnterSchoolWays.Add("免試入學--校內直升");
EnterSchoolWays.Add("免試入學--就學區免試(含共同就學區)");
EnterSchoolWays.Add("免試入學--技優甄審");
EnterSchoolWays.Add("免試入學--免試獨招");
EnterSchoolWays.Add("免試入學--其他");
EnterSchoolWays.Add("特色招生--考試分發");
EnterSchoolWays.Add("特色招生--甄選入學");
EnterSchoolWays.Add("適性輔導安置(十二年安置)");
EnterSchoolWays.Add("其他");
//四種入學身分
EnterSchoolIdentities.Add("一般生(非外加錄取)");
EnterSchoolIdentities.Add("外加錄取--原住民生");
EnterSchoolIdentities.Add("外加錄取--身心障礙生");
EnterSchoolIdentities.Add("外加錄取--其他");
//十七種 原住民身分
aboList.Add("阿美族");
aboList.Add("泰雅族");
aboList.Add("排灣族");
aboList.Add("布農族");
aboList.Add("卑南族");
aboList.Add("鄒(曹)族");
aboList.Add("魯凱族");
aboList.Add("賽夏族");
aboList.Add("雅美族或達悟族");
aboList.Add("卲族");
aboList.Add("噶瑪蘭族");
aboList.Add("太魯閣族(含 德魯固族)");
aboList.Add("撒奇萊雅族");
aboList.Add("賽德克族");
aboList.Add("拉阿魯哇族");
aboList.Add("卡那卡那富族");
aboList.Add("其他");
aboList2.Add("阿美族");
aboList2.Add("泰雅族");
aboList2.Add("排灣族");
aboList2.Add("布農族");
aboList2.Add("卑南族");
aboList2.Add("鄒(曹)族");
aboList2.Add("魯凱族");
aboList2.Add("賽夏族");
aboList2.Add("雅美族或達悟族");
aboList2.Add("卲族");
aboList2.Add("噶瑪蘭族");
aboList2.Add("太魯閣族(含 德魯固族)");
aboList2.Add("撒奇萊雅族");
aboList2.Add("賽德克族");
aboList2.Add("拉阿魯哇族");
aboList2.Add("卡那卡那富族");
aboList2.Add("其他");
// 若學校本來自己就有"原住民" Tag ，則以加入他的原住民項目 為主，幫他補齊。
bool Tag_Prefix原校內為原住民 = false;
//排除已加入的名單，避免重覆insert會爆掉
foreach (TagConfigRecord each in TagConfig.SelectAll())
{
if (each.Prefix == "入學方式")
{
if (EnterSchoolWays.Contains(each.Name))
{
EnterSchoolWays.Remove(each.Name);
}
}
if (each.Prefix == "入學身分")
{
if (EnterSchoolIdentities.Contains(each.Name))
{
EnterSchoolIdentities.Remove(each.Name);
}
}
if (each.Prefix == "原住民")
{
if (aboList.Contains(each.Name))
{
aboList.Remove(each.Name);
}
Tag_Prefix原校內為原住民 = true;
}
if (each.Prefix == "原住民族別")
{
if (aboList.Contains(each.Name))
{
aboList2.Remove(each.Name);
}
}
}
// 加入 入學方式 Tag
foreach (string aboRaceName in EnterSchoolWays)
{
TagConfigRecord _current_tag;
_current_tag = new TagConfigRecord();
_current_tag.Category = TagCategory.Student.ToString();
_current_tag.Prefix = "入學方式";
_current_tag.Name = aboRaceName;
_current_tag.Color = System.Drawing.Color.White;
TagConfig.Insert(_current_tag);
}
// 加入 入學身分 Tag
foreach (string aboRaceName in EnterSchoolIdentities)
{
TagConfigRecord _current_tag;
_current_tag = new TagConfigRecord();
_current_tag.Category = TagCategory.Student.ToString();
_current_tag.Prefix = "入學身分";
_current_tag.Name = aboRaceName;
_current_tag.Color = System.Drawing.Color.White;
TagConfig.Insert(_current_tag);
}
//加入 原住民Tag
if (Tag_Prefix原校內為原住民)
{
foreach (string aboRaceName in aboList)
{
TagConfigRecord _current_tag;
_current_tag = new TagConfigRecord();
_current_tag.Category = TagCategory.Student.ToString();
_current_tag.Prefix = "原住民";
_current_tag.Name = aboRaceName;
_current_tag.Color = System.Drawing.Color.White;
TagConfig.Insert(_current_tag);
}
}
else
{
foreach (string aboRaceName in aboList2)
{
TagConfigRecord _current_tag;
_current_tag = new TagConfigRecord();
_current_tag.Category = TagCategory.Student.ToString();
_current_tag.Prefix = "原住民族別";
_current_tag.Name = aboRaceName;
_current_tag.Color = System.Drawing.Color.White;
TagConfig.Insert(_current_tag);
}
}
#endregion
}
public static void main()
{
FISCA.Presentation.RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["教務作業", "資料統計"];
item1["報表"].Size = FISCA.Presentation.RibbonBarButton.MenuButtonSize.Large;
item1["報表"]["高中職學校班級及學生概況"].Enable = UserAcl.Current["SH.School.SchoolStatistics"].Executable;
item1["報表"]["高中職學校班級及學生概況"].Click += delegate
{
//運用Aspose元件來新增活頁簿
Aspose.Cells.Workbook ScoreWorkBook = new Aspose.Cells.Workbook();
System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog();
saveFileDialog.FileName = "高中職學校班級及學生概況.xls";
saveFileDialog.AddExtension = true;
saveFileDialog.DefaultExt = "xls";
string filename = (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) ? saveFileDialog.FileName : "";
// ScoreWorkBook.Open(System.Windows.Forms.Application.StartupPath + "\\Customize\\高中職學校班級及學生概況.xlt");
ScoreWorkBook.Open(new System.IO.MemoryStream(Properties.Resources.高中職學校班級及學生概況));
Program.ErrorList.Clear();
#region 普通科
ClassStatistics ClassSat = new ClassStatistics();
ClassSat.StartStatistics(0);
ScoreWorkBook.Worksheets[0].Name = "高中職學校班級及學生概況-普通科";
ScoreWorkBook.Worksheets[0].Cells[4, 0].PutValue(SmartSchool.Customization.Data.SystemInformation.SchoolCode);
//一年級班級數總計
ScoreWorkBook.Worksheets[0].Cells[7, 5].PutValue(ClassSat.Level1Count24);
ScoreWorkBook.Worksheets[0].Cells[7, 7].PutValue(ClassSat.Level1Count34);
ScoreWorkBook.Worksheets[0].Cells[7, 9].PutValue(ClassSat.Level1Count44);
ScoreWorkBook.Worksheets[0].Cells[7, 11].PutValue(ClassSat.Level1Count54);
ScoreWorkBook.Worksheets[0].Cells[7, 13].PutValue(ClassSat.Level1Count55);
//二年級班級數總計
ScoreWorkBook.Worksheets[0].Cells[8, 5].PutValue(ClassSat.Level2Count24);
ScoreWorkBook.Worksheets[0].Cells[8, 7].PutValue(ClassSat.Level2Count34);
ScoreWorkBook.Worksheets[0].Cells[8, 9].PutValue(ClassSat.Level2Count44);
ScoreWorkBook.Worksheets[0].Cells[8, 11].PutValue(ClassSat.Level2Count54);
ScoreWorkBook.Worksheets[0].Cells[8, 13].PutValue(ClassSat.Level2Count55);
//三年級班級數總計
ScoreWorkBook.Worksheets[0].Cells[9, 5].PutValue(ClassSat.Level3Count24);
ScoreWorkBook.Worksheets[0].Cells[9, 7].PutValue(ClassSat.Level3Count34);
ScoreWorkBook.Worksheets[0].Cells[9, 9].PutValue(ClassSat.Level3Count44);
ScoreWorkBook.Worksheets[0].Cells[9, 11].PutValue(ClassSat.Level3Count54);
ScoreWorkBook.Worksheets[0].Cells[9, 13].PutValue(ClassSat.Level3Count55);
//四年級班級數總計
ScoreWorkBook.Worksheets[0].Cells[10, 5].PutValue(ClassSat.Level4Count24);
ScoreWorkBook.Worksheets[0].Cells[10, 7].PutValue(ClassSat.Level4Count34);
ScoreWorkBook.Worksheets[0].Cells[10, 9].PutValue(ClassSat.Level4Count44);
ScoreWorkBook.Worksheets[0].Cells[10, 11].PutValue(ClassSat.Level4Count54);
ScoreWorkBook.Worksheets[0].Cells[10, 13].PutValue(ClassSat.Level4Count55);
//一年級學生數總計
ScoreWorkBook.Worksheets[0].Cells[15, 5].PutValue(ClassSat.SR15C5);
ScoreWorkBook.Worksheets[0].Cells[15, 6].PutValue(ClassSat.SR15C6);
ScoreWorkBook.Worksheets[0].Cells[15, 7].PutValue(ClassSat.SR15C7);
ScoreWorkBook.Worksheets[0].Cells[15, 8].PutValue(ClassSat.SR15C8);
ScoreWorkBook.Worksheets[0].Cells[15, 9].PutValue(ClassSat.SR15C9);
ScoreWorkBook.Worksheets[0].Cells[15, 10].PutValue(ClassSat.SR15C10);
ScoreWorkBook.Worksheets[0].Cells[15, 11].PutValue(ClassSat.SR15C11);
ScoreWorkBook.Worksheets[0].Cells[15, 12].PutValue(ClassSat.SR15C12);
ScoreWorkBook.Worksheets[0].Cells[15, 13].PutValue(ClassSat.SR15C13);
ScoreWorkBook.Worksheets[0].Cells[15, 14].PutValue(ClassSat.SR15C14);
ScoreWorkBook.Worksheets[0].Cells[16, 5].PutValue(ClassSat.SR16C5);
ScoreWorkBook.Worksheets[0].Cells[16, 6].PutValue(ClassSat.SR16C6);
ScoreWorkBook.Worksheets[0].Cells[16, 7].PutValue(ClassSat.SR16C7);
ScoreWorkBook.Worksheets[0].Cells[16, 8].PutValue(ClassSat.SR16C8);
ScoreWorkBook.Worksheets[0].Cells[16, 9].PutValue(ClassSat.SR16C9);
ScoreWorkBook.Worksheets[0].Cells[16, 10].PutValue(ClassSat.SR16C10);
ScoreWorkBook.Worksheets[0].Cells[16, 11].PutValue(ClassSat.SR16C11);
ScoreWorkBook.Worksheets[0].Cells[16, 12].PutValue(ClassSat.SR16C12);
ScoreWorkBook.Worksheets[0].Cells[16, 13].PutValue(ClassSat.SR16C13);
ScoreWorkBook.Worksheets[0].Cells[16, 14].PutValue(ClassSat.SR16C14);
//二年級學生數總計
ScoreWorkBook.Worksheets[0].Cells[17, 5].PutValue(ClassSat.SR17C5);
ScoreWorkBook.Worksheets[0].Cells[17, 6].PutValue(ClassSat.SR17C6);
ScoreWorkBook.Worksheets[0].Cells[17, 7].PutValue(ClassSat.SR17C7);
ScoreWorkBook.Worksheets[0].Cells[17, 8].PutValue(ClassSat.SR17C8);
ScoreWorkBook.Worksheets[0].Cells[17, 9].PutValue(ClassSat.SR17C9);
ScoreWorkBook.Worksheets[0].Cells[17, 10].PutValue(ClassSat.SR17C10);
ScoreWorkBook.Worksheets[0].Cells[17, 11].PutValue(ClassSat.SR17C11);
ScoreWorkBook.Worksheets[0].Cells[17, 12].PutValue(ClassSat.SR17C12);
ScoreWorkBook.Worksheets[0].Cells[17, 13].PutValue(ClassSat.SR17C13);
ScoreWorkBook.Worksheets[0].Cells[17, 14].PutValue(ClassSat.SR17C14);
ScoreWorkBook.Worksheets[0].Cells[18, 5].PutValue(ClassSat.SR18C5);
ScoreWorkBook.Worksheets[0].Cells[18, 6].PutValue(ClassSat.SR18C6);
ScoreWorkBook.Worksheets[0].Cells[18, 7].PutValue(ClassSat.SR18C7);
ScoreWorkBook.Worksheets[0].Cells[18, 8].PutValue(ClassSat.SR18C8);
ScoreWorkBook.Worksheets[0].Cells[18, 9].PutValue(ClassSat.SR18C9);
ScoreWorkBook.Worksheets[0].Cells[18, 10].PutValue(ClassSat.SR18C10);
ScoreWorkBook.Worksheets[0].Cells[18, 11].PutValue(ClassSat.SR18C11);
ScoreWorkBook.Worksheets[0].Cells[18, 12].PutValue(ClassSat.SR18C12);
ScoreWorkBook.Worksheets[0].Cells[18, 13].PutValue(ClassSat.SR18C13);
ScoreWorkBook.Worksheets[0].Cells[18, 14].PutValue(ClassSat.SR18C14);
//三年級學生數總計
ScoreWorkBook.Worksheets[0].Cells[19, 5].PutValue(ClassSat.SR19C5);
ScoreWorkBook.Worksheets[0].Cells[19, 6].PutValue(ClassSat.SR19C6);
ScoreWorkBook.Worksheets[0].Cells[19, 7].PutValue(ClassSat.SR19C7);
ScoreWorkBook.Worksheets[0].Cells[19, 8].PutValue(ClassSat.SR19C8);
ScoreWorkBook.Worksheets[0].Cells[19, 9].PutValue(ClassSat.SR19C9);
ScoreWorkBook.Worksheets[0].Cells[19, 10].PutValue(ClassSat.SR19C10);
ScoreWorkBook.Worksheets[0].Cells[19, 11].PutValue(ClassSat.SR19C11);
ScoreWorkBook.Worksheets[0].Cells[19, 12].PutValue(ClassSat.SR19C12);
ScoreWorkBook.Worksheets[0].Cells[19, 13].PutValue(ClassSat.SR19C13);
ScoreWorkBook.Worksheets[0].Cells[19, 14].PutValue(ClassSat.SR19C14);
ScoreWorkBook.Worksheets[0].Cells[20, 5].PutValue(ClassSat.SR20C5);
ScoreWorkBook.Worksheets[0].Cells[20, 6].PutValue(ClassSat.SR20C6);
ScoreWorkBook.Worksheets[0].Cells[20, 7].PutValue(ClassSat.SR20C7);
ScoreWorkBook.Worksheets[0].Cells[20, 8].PutValue(ClassSat.SR20C8);
ScoreWorkBook.Worksheets[0].Cells[20, 9].PutValue(ClassSat.SR20C9);
ScoreWorkBook.Worksheets[0].Cells[20, 10].PutValue(ClassSat.SR20C10);
ScoreWorkBook.Worksheets[0].Cells[20, 11].PutValue(ClassSat.SR20C11);
ScoreWorkBook.Worksheets[0].Cells[20, 12].PutValue(ClassSat.SR20C12);
ScoreWorkBook.Worksheets[0].Cells[20, 13].PutValue(ClassSat.SR20C13);
ScoreWorkBook.Worksheets[0].Cells[20, 14].PutValue(ClassSat.SR20C14);
//四年級學生數總計
ScoreWorkBook.Worksheets[0].Cells[21, 5].PutValue(ClassSat.SR21C5);
ScoreWorkBook.Worksheets[0].Cells[21, 6].PutValue(ClassSat.SR21C6);
ScoreWorkBook.Worksheets[0].Cells[21, 7].PutValue(ClassSat.SR21C7);
ScoreWorkBook.Worksheets[0].Cells[21, 8].PutValue(ClassSat.SR21C8);
ScoreWorkBook.Worksheets[0].Cells[21, 9].PutValue(ClassSat.SR21C9);
ScoreWorkBook.Worksheets[0].Cells[21, 10].PutValue(ClassSat.SR21C10);
ScoreWorkBook.Worksheets[0].Cells[21, 11].PutValue(ClassSat.SR21C11);
ScoreWorkBook.Worksheets[0].Cells[21, 12].PutValue(ClassSat.SR21C12);
ScoreWorkBook.Worksheets[0].Cells[21, 13].PutValue(ClassSat.SR21C13);
ScoreWorkBook.Worksheets[0].Cells[21, 14].PutValue(ClassSat.SR21C14);
ScoreWorkBook.Worksheets[0].Cells[22, 5].PutValue(ClassSat.SR22C5);
ScoreWorkBook.Worksheets[0].Cells[22, 6].PutValue(ClassSat.SR22C6);
ScoreWorkBook.Worksheets[0].Cells[22, 7].PutValue(ClassSat.SR22C7);
ScoreWorkBook.Worksheets[0].Cells[22, 8].PutValue(ClassSat.SR22C8);
ScoreWorkBook.Worksheets[0].Cells[22, 9].PutValue(ClassSat.SR22C9);
ScoreWorkBook.Worksheets[0].Cells[22, 10].PutValue(ClassSat.SR22C10);
ScoreWorkBook.Worksheets[0].Cells[22, 11].PutValue(ClassSat.SR22C11);
ScoreWorkBook.Worksheets[0].Cells[22, 12].PutValue(ClassSat.SR22C12);
ScoreWorkBook.Worksheets[0].Cells[22, 13].PutValue(ClassSat.SR22C13);
ScoreWorkBook.Worksheets[0].Cells[22, 14].PutValue(ClassSat.SR22C14);
//延修生學生數總計
ScoreWorkBook.Worksheets[0].Cells[23, 5].PutValue(ClassSat.SR23C5);
ScoreWorkBook.Worksheets[0].Cells[23, 6].PutValue(ClassSat.SR23C6);
ScoreWorkBook.Worksheets[0].Cells[23, 7].PutValue(ClassSat.SR23C7);
ScoreWorkBook.Worksheets[0].Cells[23, 8].PutValue(ClassSat.SR23C8);
ScoreWorkBook.Worksheets[0].Cells[23, 9].PutValue(ClassSat.SR23C9);
ScoreWorkBook.Worksheets[0].Cells[23, 10].PutValue(ClassSat.SR23C10);
ScoreWorkBook.Worksheets[0].Cells[23, 11].PutValue(ClassSat.SR23C11);
ScoreWorkBook.Worksheets[0].Cells[23, 12].PutValue(ClassSat.SR23C12);
ScoreWorkBook.Worksheets[0].Cells[23, 13].PutValue(ClassSat.SR23C13);
ScoreWorkBook.Worksheets[0].Cells[23, 14].PutValue(ClassSat.SR23C14);
ScoreWorkBook.Worksheets[0].Cells[24, 5].PutValue(ClassSat.SR24C5);
ScoreWorkBook.Worksheets[0].Cells[24, 6].PutValue(ClassSat.SR24C6);
ScoreWorkBook.Worksheets[0].Cells[24, 7].PutValue(ClassSat.SR24C7);
ScoreWorkBook.Worksheets[0].Cells[24, 8].PutValue(ClassSat.SR24C8);
ScoreWorkBook.Worksheets[0].Cells[24, 9].PutValue(ClassSat.SR24C9);
ScoreWorkBook.Worksheets[0].Cells[24, 10].PutValue(ClassSat.SR24C10);
ScoreWorkBook.Worksheets[0].Cells[24, 11].PutValue(ClassSat.SR24C11);
ScoreWorkBook.Worksheets[0].Cells[24, 12].PutValue(ClassSat.SR24C12);
ScoreWorkBook.Worksheets[0].Cells[24, 13].PutValue(ClassSat.SR24C13);
ScoreWorkBook.Worksheets[0].Cells[24, 14].PutValue(ClassSat.SR24C14);
#endregion
#region 職業科
ClassStatistics ClassSat1 = new ClassStatistics();
ClassSat1.StartStatistics(1);
ScoreWorkBook.Worksheets[1].Name = "高中職學校班級及學生概況-職業科";
ScoreWorkBook.Worksheets[1].Cells[4, 0].PutValue(SmartSchool.Customization.Data.SystemInformation.SchoolCode);
//一年級班級數總計
ScoreWorkBook.Worksheets[1].Cells[7, 5].PutValue(ClassSat1.Level1Count24);
ScoreWorkBook.Worksheets[1].Cells[7, 7].PutValue(ClassSat1.Level1Count34);
ScoreWorkBook.Worksheets[1].Cells[7, 9].PutValue(ClassSat1.Level1Count44);
ScoreWorkBook.Worksheets[1].Cells[7, 11].PutValue(ClassSat1.Level1Count54);
ScoreWorkBook.Worksheets[1].Cells[7, 13].PutValue(ClassSat1.Level1Count55);
//二年級班級數總計
ScoreWorkBook.Worksheets[1].Cells[8, 5].PutValue(ClassSat1.Level2Count24);
ScoreWorkBook.Worksheets[1].Cells[8, 7].PutValue(ClassSat1.Level2Count34);
ScoreWorkBook.Worksheets[1].Cells[8, 9].PutValue(ClassSat1.Level2Count44);
ScoreWorkBook.Worksheets[1].Cells[8, 11].PutValue(ClassSat1.Level2Count54);
ScoreWorkBook.Worksheets[1].Cells[8, 13].PutValue(ClassSat1.Level2Count55);
//三年級班級數總計
ScoreWorkBook.Worksheets[1].Cells[9, 5].PutValue(ClassSat1.Level3Count24);
ScoreWorkBook.Worksheets[1].Cells[9, 7].PutValue(ClassSat1.Level3Count34);
ScoreWorkBook.Worksheets[1].Cells[9, 9].PutValue(ClassSat1.Level3Count44);
ScoreWorkBook.Worksheets[1].Cells[9, 11].PutValue(ClassSat1.Level3Count54);
ScoreWorkBook.Worksheets[1].Cells[9, 13].PutValue(ClassSat1.Level3Count55);
//四年級班級數總計
ScoreWorkBook.Worksheets[1].Cells[10, 5].PutValue(ClassSat1.Level4Count24);
ScoreWorkBook.Worksheets[1].Cells[10, 7].PutValue(ClassSat1.Level4Count34);
ScoreWorkBook.Worksheets[1].Cells[10, 9].PutValue(ClassSat1.Level4Count44);
ScoreWorkBook.Worksheets[1].Cells[10, 11].PutValue(ClassSat1.Level4Count54);
ScoreWorkBook.Worksheets[1].Cells[10, 13].PutValue(ClassSat1.Level4Count55);
//一年級學生數總計
ScoreWorkBook.Worksheets[1].Cells[15, 5].PutValue(ClassSat1.SR15C5);
ScoreWorkBook.Worksheets[1].Cells[15, 6].PutValue(ClassSat1.SR15C6);
ScoreWorkBook.Worksheets[1].Cells[15, 7].PutValue(ClassSat1.SR15C7);
ScoreWorkBook.Worksheets[1].Cells[15, 8].PutValue(ClassSat1.SR15C8);
ScoreWorkBook.Worksheets[1].Cells[15, 9].PutValue(ClassSat1.SR15C9);
ScoreWorkBook.Worksheets[1].Cells[15, 10].PutValue(ClassSat1.SR15C10);
ScoreWorkBook.Worksheets[1].Cells[15, 11].PutValue(ClassSat1.SR15C11);
ScoreWorkBook.Worksheets[1].Cells[15, 12].PutValue(ClassSat1.SR15C12);
ScoreWorkBook.Worksheets[1].Cells[15, 13].PutValue(ClassSat1.SR15C13);
ScoreWorkBook.Worksheets[1].Cells[15, 14].PutValue(ClassSat1.SR15C14);
ScoreWorkBook.Worksheets[1].Cells[16, 5].PutValue(ClassSat1.SR16C5);
ScoreWorkBook.Worksheets[1].Cells[16, 6].PutValue(ClassSat1.SR16C6);
ScoreWorkBook.Worksheets[1].Cells[16, 7].PutValue(ClassSat1.SR16C7);
ScoreWorkBook.Worksheets[1].Cells[16, 8].PutValue(ClassSat1.SR16C8);
ScoreWorkBook.Worksheets[1].Cells[16, 9].PutValue(ClassSat1.SR16C9);
ScoreWorkBook.Worksheets[1].Cells[16, 10].PutValue(ClassSat1.SR16C10);
ScoreWorkBook.Worksheets[1].Cells[16, 11].PutValue(ClassSat1.SR16C11);
ScoreWorkBook.Worksheets[1].Cells[16, 12].PutValue(ClassSat1.SR16C12);
ScoreWorkBook.Worksheets[1].Cells[16, 13].PutValue(ClassSat1.SR16C13);
ScoreWorkBook.Worksheets[1].Cells[16, 14].PutValue(ClassSat1.SR16C14);
//二年級學生數總計
ScoreWorkBook.Worksheets[1].Cells[17, 5].PutValue(ClassSat1.SR17C5);
ScoreWorkBook.Worksheets[1].Cells[17, 6].PutValue(ClassSat1.SR17C6);
ScoreWorkBook.Worksheets[1].Cells[17, 7].PutValue(ClassSat1.SR17C7);
ScoreWorkBook.Worksheets[1].Cells[17, 8].PutValue(ClassSat1.SR17C8);
ScoreWorkBook.Worksheets[1].Cells[17, 9].PutValue(ClassSat1.SR17C9);
ScoreWorkBook.Worksheets[1].Cells[17, 10].PutValue(ClassSat1.SR17C10);
ScoreWorkBook.Worksheets[1].Cells[17, 11].PutValue(ClassSat1.SR17C11);
ScoreWorkBook.Worksheets[1].Cells[17, 12].PutValue(ClassSat1.SR17C12);
ScoreWorkBook.Worksheets[1].Cells[17, 13].PutValue(ClassSat1.SR17C13);
ScoreWorkBook.Worksheets[1].Cells[17, 14].PutValue(ClassSat1.SR17C14);
ScoreWorkBook.Worksheets[1].Cells[18, 5].PutValue(ClassSat1.SR18C5);
ScoreWorkBook.Worksheets[1].Cells[18, 6].PutValue(ClassSat1.SR18C6);
ScoreWorkBook.Worksheets[1].Cells[18, 7].PutValue(ClassSat1.SR18C7);
ScoreWorkBook.Worksheets[1].Cells[18, 8].PutValue(ClassSat1.SR18C8);
ScoreWorkBook.Worksheets[1].Cells[18, 9].PutValue(ClassSat1.SR18C9);
ScoreWorkBook.Worksheets[1].Cells[18, 10].PutValue(ClassSat1.SR18C10);
ScoreWorkBook.Worksheets[1].Cells[18, 11].PutValue(ClassSat1.SR18C11);
ScoreWorkBook.Worksheets[1].Cells[18, 12].PutValue(ClassSat1.SR18C12);
ScoreWorkBook.Worksheets[1].Cells[18, 13].PutValue(ClassSat1.SR18C13);
ScoreWorkBook.Worksheets[1].Cells[18, 14].PutValue(ClassSat1.SR18C14);
//三年級學生數總計
ScoreWorkBook.Worksheets[1].Cells[19, 5].PutValue(ClassSat1.SR19C5);
ScoreWorkBook.Worksheets[1].Cells[19, 6].PutValue(ClassSat1.SR19C6);
ScoreWorkBook.Worksheets[1].Cells[19, 7].PutValue(ClassSat1.SR19C7);
ScoreWorkBook.Worksheets[1].Cells[19, 8].PutValue(ClassSat1.SR19C8);
ScoreWorkBook.Worksheets[1].Cells[19, 9].PutValue(ClassSat1.SR19C9);
ScoreWorkBook.Worksheets[1].Cells[19, 10].PutValue(ClassSat1.SR19C10);
ScoreWorkBook.Worksheets[1].Cells[19, 11].PutValue(ClassSat1.SR19C11);
ScoreWorkBook.Worksheets[1].Cells[19, 12].PutValue(ClassSat1.SR19C12);
ScoreWorkBook.Worksheets[1].Cells[19, 13].PutValue(ClassSat1.SR19C13);
ScoreWorkBook.Worksheets[1].Cells[19, 14].PutValue(ClassSat1.SR19C14);
ScoreWorkBook.Worksheets[1].Cells[20, 5].PutValue(ClassSat1.SR20C5);
ScoreWorkBook.Worksheets[1].Cells[20, 6].PutValue(ClassSat1.SR20C6);
ScoreWorkBook.Worksheets[1].Cells[20, 7].PutValue(ClassSat1.SR20C7);
ScoreWorkBook.Worksheets[1].Cells[20, 8].PutValue(ClassSat1.SR20C8);
ScoreWorkBook.Worksheets[1].Cells[20, 9].PutValue(ClassSat1.SR20C9);
ScoreWorkBook.Worksheets[1].Cells[20, 10].PutValue(ClassSat1.SR20C10);
ScoreWorkBook.Worksheets[1].Cells[20, 11].PutValue(ClassSat1.SR20C11);
ScoreWorkBook.Worksheets[1].Cells[20, 12].PutValue(ClassSat1.SR20C12);
ScoreWorkBook.Worksheets[1].Cells[20, 13].PutValue(ClassSat1.SR20C13);
ScoreWorkBook.Worksheets[1].Cells[20, 14].PutValue(ClassSat1.SR20C14);
//四年級學生數總計
ScoreWorkBook.Worksheets[1].Cells[21, 5].PutValue(ClassSat1.SR21C5);
ScoreWorkBook.Worksheets[1].Cells[21, 6].PutValue(ClassSat1.SR21C6);
ScoreWorkBook.Worksheets[1].Cells[21, 7].PutValue(ClassSat1.SR21C7);
ScoreWorkBook.Worksheets[1].Cells[21, 8].PutValue(ClassSat1.SR21C8);
ScoreWorkBook.Worksheets[1].Cells[21, 9].PutValue(ClassSat1.SR21C9);
ScoreWorkBook.Worksheets[1].Cells[21, 10].PutValue(ClassSat1.SR21C10);
ScoreWorkBook.Worksheets[1].Cells[21, 11].PutValue(ClassSat1.SR21C11);
ScoreWorkBook.Worksheets[1].Cells[21, 12].PutValue(ClassSat1.SR21C12);
ScoreWorkBook.Worksheets[1].Cells[21, 13].PutValue(ClassSat1.SR21C13);
ScoreWorkBook.Worksheets[1].Cells[21, 14].PutValue(ClassSat1.SR21C14);
ScoreWorkBook.Worksheets[1].Cells[22, 5].PutValue(ClassSat1.SR22C5);
ScoreWorkBook.Worksheets[1].Cells[22, 6].PutValue(ClassSat1.SR22C6);
ScoreWorkBook.Worksheets[1].Cells[22, 7].PutValue(ClassSat1.SR22C7);
ScoreWorkBook.Worksheets[1].Cells[22, 8].PutValue(ClassSat1.SR22C8);
ScoreWorkBook.Worksheets[1].Cells[22, 9].PutValue(ClassSat1.SR22C9);
ScoreWorkBook.Worksheets[1].Cells[22, 10].PutValue(ClassSat1.SR22C10);
ScoreWorkBook.Worksheets[1].Cells[22, 11].PutValue(ClassSat1.SR22C11);
ScoreWorkBook.Worksheets[1].Cells[22, 12].PutValue(ClassSat1.SR22C12);
ScoreWorkBook.Worksheets[1].Cells[22, 13].PutValue(ClassSat1.SR22C13);
ScoreWorkBook.Worksheets[1].Cells[22, 14].PutValue(ClassSat1.SR22C14);
//延修生學生數總計
ScoreWorkBook.Worksheets[1].Cells[23, 5].PutValue(ClassSat1.SR23C5);
ScoreWorkBook.Worksheets[1].Cells[23, 6].PutValue(ClassSat1.SR23C6);
ScoreWorkBook.Worksheets[1].Cells[23, 7].PutValue(ClassSat1.SR23C7);
ScoreWorkBook.Worksheets[1].Cells[23, 8].PutValue(ClassSat1.SR23C8);
ScoreWorkBook.Worksheets[1].Cells[23, 9].PutValue(ClassSat1.SR23C9);
ScoreWorkBook.Worksheets[1].Cells[23, 10].PutValue(ClassSat1.SR23C10);
ScoreWorkBook.Worksheets[1].Cells[23, 11].PutValue(ClassSat1.SR23C11);
ScoreWorkBook.Worksheets[1].Cells[23, 12].PutValue(ClassSat1.SR23C12);
ScoreWorkBook.Worksheets[1].Cells[23, 13].PutValue(ClassSat1.SR23C13);
ScoreWorkBook.Worksheets[1].Cells[23, 14].PutValue(ClassSat1.SR23C14);
ScoreWorkBook.Worksheets[1].Cells[24, 5].PutValue(ClassSat1.SR24C5);
ScoreWorkBook.Worksheets[1].Cells[24, 6].PutValue(ClassSat1.SR24C6);
ScoreWorkBook.Worksheets[1].Cells[24, 7].PutValue(ClassSat1.SR24C7);
ScoreWorkBook.Worksheets[1].Cells[24, 8].PutValue(ClassSat1.SR24C8);
ScoreWorkBook.Worksheets[1].Cells[24, 9].PutValue(ClassSat1.SR24C9);
ScoreWorkBook.Worksheets[1].Cells[24, 10].PutValue(ClassSat1.SR24C10);
ScoreWorkBook.Worksheets[1].Cells[24, 11].PutValue(ClassSat1.SR24C11);
ScoreWorkBook.Worksheets[1].Cells[24, 12].PutValue(ClassSat1.SR24C12);
ScoreWorkBook.Worksheets[1].Cells[24, 13].PutValue(ClassSat1.SR24C13);
ScoreWorkBook.Worksheets[1].Cells[24, 14].PutValue(ClassSat1.SR24C14);
#endregion
#region 綜合高中
ClassStatistics ClassSat2 = new ClassStatistics();
ClassSat2.StartStatistics(2);
ScoreWorkBook.Worksheets[2].Name = "高中職學校班級及學生概況-綜合高中";
ScoreWorkBook.Worksheets[2].Cells[4, 0].PutValue(SmartSchool.Customization.Data.SystemInformation.SchoolCode);
//一年級班級數總計
ScoreWorkBook.Worksheets[2].Cells[7, 5].PutValue(ClassSat2.Level1Count24);
ScoreWorkBook.Worksheets[2].Cells[7, 7].PutValue(ClassSat2.Level1Count34);
ScoreWorkBook.Worksheets[2].Cells[7, 9].PutValue(ClassSat2.Level1Count44);
ScoreWorkBook.Worksheets[2].Cells[7, 11].PutValue(ClassSat2.Level1Count54);
ScoreWorkBook.Worksheets[2].Cells[7, 13].PutValue(ClassSat2.Level1Count55);
//二年級班級數總計
ScoreWorkBook.Worksheets[2].Cells[8, 5].PutValue(ClassSat2.Level2Count24);
ScoreWorkBook.Worksheets[2].Cells[8, 7].PutValue(ClassSat2.Level2Count34);
ScoreWorkBook.Worksheets[2].Cells[8, 9].PutValue(ClassSat2.Level2Count44);
ScoreWorkBook.Worksheets[2].Cells[8, 11].PutValue(ClassSat2.Level2Count54);
ScoreWorkBook.Worksheets[2].Cells[8, 13].PutValue(ClassSat2.Level2Count55);
//三年級班級數總計
ScoreWorkBook.Worksheets[2].Cells[9, 5].PutValue(ClassSat2.Level3Count24);
ScoreWorkBook.Worksheets[2].Cells[9, 7].PutValue(ClassSat2.Level3Count34);
ScoreWorkBook.Worksheets[2].Cells[9, 9].PutValue(ClassSat2.Level3Count44);
ScoreWorkBook.Worksheets[2].Cells[9, 11].PutValue(ClassSat2.Level3Count54);
ScoreWorkBook.Worksheets[2].Cells[9, 13].PutValue(ClassSat2.Level3Count55);
//四年級班級數總計
ScoreWorkBook.Worksheets[2].Cells[10, 5].PutValue(ClassSat2.Level4Count24);
ScoreWorkBook.Worksheets[2].Cells[10, 7].PutValue(ClassSat2.Level4Count34);
ScoreWorkBook.Worksheets[2].Cells[10, 9].PutValue(ClassSat2.Level4Count44);
ScoreWorkBook.Worksheets[2].Cells[10, 11].PutValue(ClassSat2.Level4Count54);
ScoreWorkBook.Worksheets[2].Cells[10, 13].PutValue(ClassSat2.Level4Count55);
//一年級學生數總計
ScoreWorkBook.Worksheets[2].Cells[15, 5].PutValue(ClassSat2.SR15C5);
ScoreWorkBook.Worksheets[2].Cells[15, 6].PutValue(ClassSat2.SR15C6);
ScoreWorkBook.Worksheets[2].Cells[15, 7].PutValue(ClassSat2.SR15C7);
ScoreWorkBook.Worksheets[2].Cells[15, 8].PutValue(ClassSat2.SR15C8);
ScoreWorkBook.Worksheets[2].Cells[15, 9].PutValue(ClassSat2.SR15C9);
ScoreWorkBook.Worksheets[2].Cells[15, 10].PutValue(ClassSat2.SR15C10);
ScoreWorkBook.Worksheets[2].Cells[15, 11].PutValue(ClassSat2.SR15C11);
ScoreWorkBook.Worksheets[2].Cells[15, 12].PutValue(ClassSat2.SR15C12);
ScoreWorkBook.Worksheets[2].Cells[15, 13].PutValue(ClassSat2.SR15C13);
ScoreWorkBook.Worksheets[2].Cells[15, 14].PutValue(ClassSat2.SR15C14);
ScoreWorkBook.Worksheets[2].Cells[16, 5].PutValue(ClassSat2.SR16C5);
ScoreWorkBook.Worksheets[2].Cells[16, 6].PutValue(ClassSat2.SR16C6);
ScoreWorkBook.Worksheets[2].Cells[16, 7].PutValue(ClassSat2.SR16C7);
ScoreWorkBook.Worksheets[2].Cells[16, 8].PutValue(ClassSat2.SR16C8);
ScoreWorkBook.Worksheets[2].Cells[16, 9].PutValue(ClassSat2.SR16C9);
ScoreWorkBook.Worksheets[2].Cells[16, 10].PutValue(ClassSat2.SR16C10);
ScoreWorkBook.Worksheets[2].Cells[16, 11].PutValue(ClassSat2.SR16C11);
ScoreWorkBook.Worksheets[2].Cells[16, 12].PutValue(ClassSat2.SR16C12);
ScoreWorkBook.Worksheets[2].Cells[16, 13].PutValue(ClassSat2.SR16C13);
ScoreWorkBook.Worksheets[2].Cells[16, 14].PutValue(ClassSat2.SR16C14);
//二年級學生數總計
ScoreWorkBook.Worksheets[2].Cells[17, 5].PutValue(ClassSat2.SR17C5);
ScoreWorkBook.Worksheets[2].Cells[17, 6].PutValue(ClassSat2.SR17C6);
ScoreWorkBook.Worksheets[2].Cells[17, 7].PutValue(ClassSat2.SR17C7);
ScoreWorkBook.Worksheets[2].Cells[17, 8].PutValue(ClassSat2.SR17C8);
ScoreWorkBook.Worksheets[2].Cells[17, 9].PutValue(ClassSat2.SR17C9);
ScoreWorkBook.Worksheets[2].Cells[17, 10].PutValue(ClassSat2.SR17C10);
ScoreWorkBook.Worksheets[2].Cells[17, 11].PutValue(ClassSat2.SR17C11);
ScoreWorkBook.Worksheets[2].Cells[17, 12].PutValue(ClassSat2.SR17C12);
ScoreWorkBook.Worksheets[2].Cells[17, 13].PutValue(ClassSat2.SR17C13);
ScoreWorkBook.Worksheets[2].Cells[17, 14].PutValue(ClassSat2.SR17C14);
ScoreWorkBook.Worksheets[2].Cells[18, 5].PutValue(ClassSat2.SR18C5);
ScoreWorkBook.Worksheets[2].Cells[18, 6].PutValue(ClassSat2.SR18C6);
ScoreWorkBook.Worksheets[2].Cells[18, 7].PutValue(ClassSat2.SR18C7);
ScoreWorkBook.Worksheets[2].Cells[18, 8].PutValue(ClassSat2.SR18C8);
ScoreWorkBook.Worksheets[2].Cells[18, 9].PutValue(ClassSat2.SR18C9);
ScoreWorkBook.Worksheets[2].Cells[18, 10].PutValue(ClassSat2.SR18C10);
ScoreWorkBook.Worksheets[2].Cells[18, 11].PutValue(ClassSat2.SR18C11);
ScoreWorkBook.Worksheets[2].Cells[18, 12].PutValue(ClassSat2.SR18C12);
ScoreWorkBook.Worksheets[2].Cells[18, 13].PutValue(ClassSat2.SR18C13);
ScoreWorkBook.Worksheets[2].Cells[18, 14].PutValue(ClassSat2.SR18C14);
//三年級學生數總計
ScoreWorkBook.Worksheets[2].Cells[19, 5].PutValue(ClassSat2.SR19C5);
ScoreWorkBook.Worksheets[2].Cells[19, 6].PutValue(ClassSat2.SR19C6);
ScoreWorkBook.Worksheets[2].Cells[19, 7].PutValue(ClassSat2.SR19C7);
ScoreWorkBook.Worksheets[2].Cells[19, 8].PutValue(ClassSat2.SR19C8);
ScoreWorkBook.Worksheets[2].Cells[19, 9].PutValue(ClassSat2.SR19C9);
ScoreWorkBook.Worksheets[2].Cells[19, 10].PutValue(ClassSat2.SR19C10);
ScoreWorkBook.Worksheets[2].Cells[19, 11].PutValue(ClassSat2.SR19C11);
ScoreWorkBook.Worksheets[2].Cells[19, 12].PutValue(ClassSat2.SR19C12);
ScoreWorkBook.Worksheets[2].Cells[19, 13].PutValue(ClassSat2.SR19C13);
ScoreWorkBook.Worksheets[2].Cells[19, 14].PutValue(ClassSat2.SR19C14);
ScoreWorkBook.Worksheets[2].Cells[20, 5].PutValue(ClassSat2.SR20C5);
ScoreWorkBook.Worksheets[2].Cells[20, 6].PutValue(ClassSat2.SR20C6);
ScoreWorkBook.Worksheets[2].Cells[20, 7].PutValue(ClassSat2.SR20C7);
ScoreWorkBook.Worksheets[2].Cells[20, 8].PutValue(ClassSat2.SR20C8);
ScoreWorkBook.Worksheets[2].Cells[20, 9].PutValue(ClassSat2.SR20C9);
ScoreWorkBook.Worksheets[2].Cells[20, 10].PutValue(ClassSat2.SR20C10);
ScoreWorkBook.Worksheets[2].Cells[20, 11].PutValue(ClassSat2.SR20C11);
ScoreWorkBook.Worksheets[2].Cells[20, 12].PutValue(ClassSat2.SR20C12);
ScoreWorkBook.Worksheets[2].Cells[20, 13].PutValue(ClassSat2.SR20C13);
ScoreWorkBook.Worksheets[2].Cells[20, 14].PutValue(ClassSat2.SR20C14);
//四年級學生數總計
ScoreWorkBook.Worksheets[2].Cells[21, 5].PutValue(ClassSat2.SR21C5);
ScoreWorkBook.Worksheets[2].Cells[21, 6].PutValue(ClassSat2.SR21C6);
ScoreWorkBook.Worksheets[2].Cells[21, 7].PutValue(ClassSat2.SR21C7);
ScoreWorkBook.Worksheets[2].Cells[21, 8].PutValue(ClassSat2.SR21C8);
ScoreWorkBook.Worksheets[2].Cells[21, 9].PutValue(ClassSat2.SR21C9);
ScoreWorkBook.Worksheets[2].Cells[21, 10].PutValue(ClassSat2.SR21C10);
ScoreWorkBook.Worksheets[2].Cells[21, 11].PutValue(ClassSat2.SR21C11);
ScoreWorkBook.Worksheets[2].Cells[21, 12].PutValue(ClassSat2.SR21C12);
ScoreWorkBook.Worksheets[2].Cells[21, 13].PutValue(ClassSat2.SR21C13);
ScoreWorkBook.Worksheets[2].Cells[21, 14].PutValue(ClassSat2.SR21C14);
ScoreWorkBook.Worksheets[2].Cells[22, 5].PutValue(ClassSat2.SR22C5);
ScoreWorkBook.Worksheets[2].Cells[22, 6].PutValue(ClassSat2.SR22C6);
ScoreWorkBook.Worksheets[2].Cells[22, 7].PutValue(ClassSat2.SR22C7);
ScoreWorkBook.Worksheets[2].Cells[22, 8].PutValue(ClassSat2.SR22C8);
ScoreWorkBook.Worksheets[2].Cells[22, 9].PutValue(ClassSat2.SR22C9);
ScoreWorkBook.Worksheets[2].Cells[22, 10].PutValue(ClassSat2.SR22C10);
ScoreWorkBook.Worksheets[2].Cells[22, 11].PutValue(ClassSat2.SR22C11);
ScoreWorkBook.Worksheets[2].Cells[22, 12].PutValue(ClassSat2.SR22C12);
ScoreWorkBook.Worksheets[2].Cells[22, 13].PutValue(ClassSat2.SR22C13);
ScoreWorkBook.Worksheets[2].Cells[22, 14].PutValue(ClassSat2.SR22C14);
//延修生學生數總計
ScoreWorkBook.Worksheets[2].Cells[23, 5].PutValue(ClassSat2.SR23C5);
ScoreWorkBook.Worksheets[2].Cells[23, 6].PutValue(ClassSat2.SR23C6);
ScoreWorkBook.Worksheets[2].Cells[23, 7].PutValue(ClassSat2.SR23C7);
ScoreWorkBook.Worksheets[2].Cells[23, 8].PutValue(ClassSat2.SR23C8);
ScoreWorkBook.Worksheets[2].Cells[23, 9].PutValue(ClassSat2.SR23C9);
ScoreWorkBook.Worksheets[2].Cells[23, 10].PutValue(ClassSat2.SR23C10);
ScoreWorkBook.Worksheets[2].Cells[23, 11].PutValue(ClassSat2.SR23C11);
ScoreWorkBook.Worksheets[2].Cells[23, 12].PutValue(ClassSat2.SR23C12);
ScoreWorkBook.Worksheets[2].Cells[23, 13].PutValue(ClassSat2.SR23C13);
ScoreWorkBook.Worksheets[2].Cells[23, 14].PutValue(ClassSat2.SR23C14);
ScoreWorkBook.Worksheets[2].Cells[24, 5].PutValue(ClassSat2.SR24C5);
ScoreWorkBook.Worksheets[2].Cells[24, 6].PutValue(ClassSat2.SR24C6);
ScoreWorkBook.Worksheets[2].Cells[24, 7].PutValue(ClassSat2.SR24C7);
ScoreWorkBook.Worksheets[2].Cells[24, 8].PutValue(ClassSat2.SR24C8);
ScoreWorkBook.Worksheets[2].Cells[24, 9].PutValue(ClassSat2.SR24C9);
ScoreWorkBook.Worksheets[2].Cells[24, 10].PutValue(ClassSat2.SR24C10);
ScoreWorkBook.Worksheets[2].Cells[24, 11].PutValue(ClassSat2.SR24C11);
ScoreWorkBook.Worksheets[2].Cells[24, 12].PutValue(ClassSat2.SR24C12);
ScoreWorkBook.Worksheets[2].Cells[24, 13].PutValue(ClassSat2.SR24C13);
ScoreWorkBook.Worksheets[2].Cells[24, 14].PutValue(ClassSat2.SR24C14);
#endregion
try
{
if (Program.ErrorList.Count > 0)
{
int rowIdx = 1;
foreach (string str in Program.ErrorList)
{
ScoreWorkBook.Worksheets[3].Cells[rowIdx, 0].PutValue(str);
rowIdx++;
}
System.Windows.Forms.MessageBox.Show("產生過程有發生問題，請到工作表Error檢視。");
}
if (Program.ErrorList.Count == 0)
{
ScoreWorkBook.Worksheets.RemoveAt(3);
}
ScoreWorkBook.Save(filename);
System.Diagnostics.Process.Start(filename);
}
catch
{
System.Windows.Forms.MessageBox.Show("指定路徑無法存取。", "建立檔案失敗", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
};
//權限設定
Catalog permission = RoleAclSource.Instance["教務作業"]["功能按鈕"];
permission.Add(new RibbonFeature("SH.School.SchoolStatistics", "高中職學校班級及學生概況"));
}
public static void main()
{
////第一個 RibbonBar 功能
//FISCA.Presentation.RibbonBarItem item = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "康橋"];
//item["第一個程式"].Enable = FISCA.Permission.UserAcl.Current["09613d9c-56b6-4511-b046-5b40689d5955"].Executable;
//item["第一個程式"].Click += delegate
//{
// MessageBox.Show("Hello FISCA!");
//};
FISCA.Presentation.RibbonBarItem item_e = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "康橋"];
item_e["匯出兄弟姊妹資訊"].Enable = FISCA.Permission.UserAcl.Current["20DD29B1-20E8-42C4-ACB6-3958FEF8A8C1"].Executable;
item_e["匯出兄弟姊妹資訊"].Click += delegate
{
// 最少選一位學生
if (K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0)
{
// 使用匯出 API
SmartSchool.API.PlugIn.Export.Exporter exporter = new MOD_siblings_ImportExport.ImportExport.ExportSiblingRecord();
// 使用匯出精靈
ImportExport.ExportStudentV2 wizard = new ImportExport.ExportStudentV2(exporter.Text, exporter.Image);
exporter.InitializeExport(wizard);
wizard.ShowDialog();
}
};
FISCA.Presentation.RibbonBarItem item_i = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "康橋"];
item_i["匯入兄弟姊妹資訊"].Enable = FISCA.Permission.UserAcl.Current["800D8794-BB03-4497-A53B-E8BED38DFB2B"].Executable;
item_i["匯入兄弟姊妹資訊"].Click += delegate
{
// 載入所有學生與狀態，資料匯入比對使用
Global._AllStudentNumberStatusIDTemp = Global.GetAllStudenNumberStatusDict();
ImportExport.ImportSiblingRecord importSiblingRecord = new ImportExport.ImportSiblingRecord();
importSiblingRecord.Execute();
};
// 載入自訂驗證規則
#region 自訂驗證規則
FactoryProvider.RowFactory.Add(new ValidationRule.SiblingRowValidatorFactory());
#endregion
// 報表
FISCA.Presentation.RibbonBarItem item = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "康橋"];
item["兄弟姊妹資訊報表範例"].Enable = FISCA.Permission.UserAcl.Current["CBFDCD41-49D8-4972-A7B9-7CFD93FCB9C4"].Executable;
item["兄弟姊妹資訊報表範例"].Click += delegate
{
// 最少選一位學生
if (K12.Presentation.NLDPanels.Student.SelectedSource.Count > 0)
{
Report.SiblingRecordRpt siblingRecordRpt = new Report.SiblingRecordRpt(K12.Presentation.NLDPanels.Student.SelectedSource);
siblingRecordRpt.Report();
}
};
Catalog catalog_e = RoleAclSource.Instance["學生"]["功能按鈕"];
catalog_e.Add(new RibbonFeature("20DD29B1-20E8-42C4-ACB6-3958FEF8A8C1", "匯出兄弟姊妹資訊"));
catalog_e.Add(new RibbonFeature("800D8794-BB03-4497-A53B-E8BED38DFB2B", "匯入兄弟姊妹資訊"));
catalog_e.Add(new RibbonFeature("CBFDCD41-49D8-4972-A7B9-7CFD93FCB9C4", "兄弟姊妹資訊報表範例"));
}