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.五專集體報名表, "北中南五專(優先)免試入學集體報名表"));
        }
Ejemplo n.º 2
0
        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.休學證明書, "休學證明書"));
        }
Ejemplo n.º 3
0
        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;
                }
            };
        }
Ejemplo n.º 4
0
 static public void Main()
 {
     FISCA.Presentation.RibbonBarItem report = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
     report["報表"]["公務統計相關報表"]["原住民族別統計"].Click += delegate
     {
         Form2 f = new Form2();
         f.ShowDialog();
     };
 }
Ejemplo n.º 5
0
        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();
                };
            }
        }
Ejemplo n.º 6
0
        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.高中職學校學生異動報告, "高中職學校學生異動報告"));
        }
Ejemplo n.º 7
0
        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"));
        }
Ejemplo n.º 8
0
        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大過名單, "大過累計達標準名單(客製)"));
        }
Ejemplo n.º 9
0
        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, "學籍表(雙語部)"));
        }
Ejemplo n.º 10
0
        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.班級學期成績單, "班級學期成績單"));
        }
Ejemplo n.º 11
0
        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, "複製課程成績"));
        }
Ejemplo n.º 12
0
        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.班級學期成績通知單, "學期成績通知單(含補考成績)"));
        }
Ejemplo n.º 14
0
        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>());
        }
Ejemplo n.º 15
0
        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
        }
Ejemplo n.º 16
0
        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", "高中職學校班級及學生概況"));
        }
Ejemplo n.º 17
0
        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", "兄弟姊妹資訊報表範例"));
        }