/// <summary> /// 根據TB_SchoolOrClassOrTempGroup組成節點資料串列 /// </summary> /// <returns></returns> public static List <clsGroupNode> GetNodeDatasBy_TB_SchoolOrClassOrTempGroup(DataTable dtNodeDatas, string GroupClassifacationName) { List <clsGroupNode> NodeDatas = new List <clsGroupNode>(); switch (GroupClassifacationName) { case clsGroupNode.GroupClassification_SchoolGroup: foreach (DataRow dtNodeData in dtNodeDatas.Rows) { clsGroupNode nodeData = new clsGroupNode( dtNodeData[TF_ORCS_SchoolGroup_SchoolGroupID].ToString(), dtNodeData[TF_ORCS_SchoolGroup_SchoolGroupName].ToString(), dtNodeData[TF_ORCS_SchoolGroup_ParentNodeID].ToString(), "0", clsGroupNode.GroupClassification_SchoolGroup ); NodeDatas.Add(nodeData); } break; case clsGroupNode.GroupClassification_ClassGroup: foreach (DataRow dtNodeData in dtNodeDatas.Rows) { clsGroupNode nodeData = new clsGroupNode( dtNodeData[TF_ORCS_ClassGroup_ClassGroupID].ToString(), dtNodeData[TF_ORCS_ClassGroup_ClassGroupName].ToString(), dtNodeData[TF_ORCS_ClassGroup_SchoolGroupID].ToString(), "0", clsGroupNode.GroupClassification_ClassGroup ); NodeDatas.Add(nodeData); } break; case clsGroupNode.GroupClassification_TempGroup: foreach (DataRow dtNodeData in dtNodeDatas.Rows) { clsGroupNode nodeData = new clsGroupNode( dtNodeData[TF_ORCS_TempGroup_TempGroupID].ToString(), dtNodeData[TF_ORCS_TempGroup_TempGroupName].ToString(), dtNodeData[TF_ORCS_TempGroup_ClassGroupID].ToString(), "0", clsGroupNode.GroupClassification_TempGroup ); NodeDatas.Add(nodeData); } break; default: break; } return(NodeDatas); }
/// <summary> /// 設定小組資訊 /// </summary> public static void SetGroupTeams() { GroupTeams = new List <clsGroupNode>(); DataTable TeamDatas = ORCS_TempGroup_SELECT_All(); foreach (DataRow TeamData in TeamDatas.Rows) { clsGroupNode groupNode = new clsGroupNode(TeamData[TF_ORCS_TempGroup_TempGroupID].ToString(), TeamData[TF_ORCS_TempGroup_TempGroupName].ToString(), TeamData[TF_ORCS_TempGroup_ClassGroupID].ToString(), "false", clsGroupNode.GroupClassification_TempGroup); GroupDepartments.Add(groupNode); } }
/// <summary> /// 設定課程資訊 /// </summary> public static void SetGroupCourses() { GroupCourses = new List <clsGroupNode>(); DataTable CourseDatas = ORCS_classGroup_SELECT_All(); foreach (DataRow CourseData in CourseDatas.Rows) { clsGroupNode groupNode = new clsGroupNode(CourseData[TF_ORCS_ClassGroup_ClassGroupID].ToString(), CourseData[TF_ORCS_ClassGroup_ClassGroupName].ToString(), CourseData[TF_ORCS_ClassGroup_SchoolGroupID].ToString(), "false", clsGroupNode.GroupClassification_ClassGroup); GroupCourses.Add(groupNode); } }
/// <summary> /// 設定部門資訊 /// </summary> public static void SetGroupDepartments() { GroupDepartments = new List <clsGroupNode>(); DataTable DepartmentDatas = ORCS_SchoolGroup_SELECT_All(); foreach (DataRow DepartmentData in DepartmentDatas.Rows) { clsGroupNode groupNode = new clsGroupNode(DepartmentData[TF_ORCS_SchoolGroup_SchoolGroupID].ToString(), DepartmentData[TF_ORCS_SchoolGroup_SchoolGroupName].ToString(), DepartmentData[TF_ORCS_SchoolGroup_ParentNodeID].ToString(), "false", clsGroupNode.GroupClassification_SchoolGroup); GroupDepartments.Add(groupNode); } }
/// <summary> /// 設定群組資訊 /// </summary> public static void SetGroups() { Groups = new List <clsGroupNode>(); DataTable GroupDatas = ORCS_Group_SELECT_All(); foreach (DataRow GroupData in GroupDatas.Rows) { clsGroupNode groupNode = new clsGroupNode(GroupData[TF_Group_NodeID].ToString(), GroupData[TF_Group_NodeName].ToString(), GroupData[TF_Group_ParentNodeID].ToString(), GroupData[TF_Group_IsNextNodeDepartment].ToString(), GroupData[TF_Group_NodeClassificationID].ToString()); Groups.Add(groupNode); } }
/// <summary> /// 根據部門ID取得所有課程 /// </summary> /// <returns></returns> public static List <clsGroupNode> GetAllCourseByDepartment(string strDepartmentID) { DataTable dtCourseGroups = ORCS_ClassGroup_SELECT_By_cSchoolGroupID(strDepartmentID); List <clsGroupNode> groupNodes = new List <clsGroupNode>(); foreach (DataRow drCourseGroup in dtCourseGroups.Rows) { clsGroupNode groupNode = new clsGroupNode(drCourseGroup[TF_ORCS_ClassGroup_ClassGroupID].ToString(), drCourseGroup[TF_ORCS_ClassGroup_ClassGroupName].ToString(), drCourseGroup[TF_ORCS_ClassGroup_SchoolGroupID].ToString(), "false", clsGroupNode.GroupClassification_ClassGroup); groupNodes.Add(groupNode); } return(groupNodes); }
/// <summary> /// 取得所有部門 /// </summary> /// <returns></returns> public static List <clsGroupNode> GetAllDepartment() { DataTable dtSchoolGroups = ORCS_SchoolGroup_SELECT_All(); List <clsGroupNode> groupNodes = new List <clsGroupNode>(); foreach (DataRow drSchoolGroup in dtSchoolGroups.Rows) { clsGroupNode groupNode = new clsGroupNode(drSchoolGroup[TF_ORCS_SchoolGroup_SchoolGroupID].ToString(), drSchoolGroup[TF_ORCS_SchoolGroup_SchoolGroupName].ToString(), drSchoolGroup[TF_ORCS_SchoolGroup_ParentNodeID].ToString(), "false", clsGroupNode.GroupClassification_SchoolGroup); groupNodes.Add(groupNode); } return(groupNodes); }
/// <summary> /// 根據TB_Group組成節點資料串列 /// </summary> /// <returns></returns> public static List <clsGroupNode> GetNodeDatasBy_TB_Group(DataTable dtNodeDatas) { //Get LevelGroup node data list List <clsGroupNode> NodeDatas = new List <clsGroupNode>(); foreach (DataRow dtNodeData in dtNodeDatas.Rows) { clsGroupNode nodeData = new clsGroupNode( dtNodeData[clsGroup.TF_Group_NodeID].ToString(), dtNodeData[clsGroup.TF_Group_NodeName].ToString(), dtNodeData[clsGroup.TF_Group_ParentNodeID].ToString(), dtNodeData[clsGroup.TF_Group_IsNextNodeDepartment].ToString(), dtNodeData[clsGroup.TF_Group_NodeClassificationID].ToString() ); NodeDatas.Add(nodeData); } return(NodeDatas); }