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", "兄弟姊妹資訊報表範例")); }