/// <summary> /// 增加上課初始時間記錄 /// </summary> /// <param name="iClassGroupID"></param> /// <param name="cStartTime"></param> /// <returns></returns> public static int addInintialClassTimeRecord(object iClassGroupID, object cStartTime) { clsORCSDB ORCSDB = new clsORCSDB(); //取得該堂課最新一筆記錄 DataTable dtClassTimeRecord = getLastClassTimeRecord(iClassGroupID); //如果沒有上課記錄代表第一次上課 if (dtClassTimeRecord.Rows.Count == 0) { string strSQL = "INSERT INTO ORCS_ClassTimeRecord(iClassGroupID,cStartTime,iClassTime,bIsReRollCall) VALUES('" + iClassGroupID + "','" + cStartTime + "','" + "1" + "','" + "0" + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } } else //以最後一堂課的堂次再加1做為新的堂次 { string strSQL = "INSERT INTO ORCS_ClassTimeRecord(iClassGroupID,cStartTime,iClassTime,bIsReRollCall) VALUES('" + iClassGroupID + "','" + cStartTime + "','" + (int.Parse(dtClassTimeRecord.Rows[0]["iClassTime"].ToString()) + 1) + "','" + "0" + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } } return(0); }
/// <summary> /// 根據NodeID刪除節點 /// </summary> /// <param name="NodeID"></param> /// <returns></returns> public static int ORCS_Group_Delete_By_NodeID(string NodeID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE " + TB_ORCS_Group + " WHERE " + TF_Group_NodeID + " LIKE '" + NodeID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 更新學生上傳作品檔案資料 /// </summary> /// <param name="cExerciseCondID"></param> /// <param name="cExerciseID"></param> /// <param name="cUserID"></param> /// <param name="cFileName"></param> /// <returns></returns> public static int ORCS_FileUploadData_UPDATE(object cExerciseCondID, object cExerciseID, object cUserID, object cFileName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_FileUploadData SET cFileName = '" + cFileName + "' WHERE cExerciseCondID LIKE '" + cExerciseCondID + "' AND cExerciseID LIKE '" + cExerciseID + "' AND cUserID LIKE '" + cUserID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據TempGroup的ParentID(iClassGroupID)刪除群組 /// </summary> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_TempGroup_DELETE_by_ParentGroupID(object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_TempGroup WHERE iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在ORCS_TextUploadData資料表存入資料 /// </summary> /// <param name="cExerciseCondID"></param> /// <param name="cExerciseID"></param> /// <param name="cUserID"></param> /// <param name="cFileName"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_TextUploadData_INSERT(object cExerciseCondID, object cExerciseID, object cUserID, object cTextContent, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_TextUploadData(cExerciseCondID, cExerciseID, cUserID, txtTextContent, iClassGroupID) VALUES('" + cExerciseCondID + "','" + cExerciseID + "','" + cUserID + "','" + cTextContent + "','" + iClassGroupID + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在ExerciseCondition資料表存入資料 /// </summary> /// <param name="cExerciseID"></param> /// <param name="cUserID"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_ExerciseCondition_INSERT_ExerciseID_UserID_GroupID(object cExerciseID, object cUserID, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_ExerciseCondition(cExerciseID, cUserID, iClassGroupID) VALUES('" + cExerciseID + "','" + cUserID + "','" + iClassGroupID + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在ExerciseConditionHistory資料表存入資料 /// </summary> /// <param name="cExerciseCondID"></param> /// <param name="cExerciseID"></param> /// <param name="cUserID"></param> /// <param name="iExerciseState"></param> /// <param name="iClassGroupID"></param> /// <param name="cCaseID"></param> /// <param name="cPaperID"></param> /// <returns></returns> public static int ORCS_ExerciseConditionHistory_INSERT(object cExerciseCondID, object cExerciseID, object cUserID, object iExerciseState, object iClassGroupID, object cCaseID, object cPaperID, object iAnswerMode) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_ExerciseConditionHistory(cExerciseCondID, cExerciseID, cUserID, iExerciseState, iClassGroupID, cCaseID, cPaperID, iAnswerMode) VALUES('" + cExerciseCondID + "','" + cExerciseID + "','" + cUserID + "','" + iExerciseState + "','" + iClassGroupID + "','" + cCaseID + "','" + cPaperID + "','" + iAnswerMode + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在User資料表存入資料 /// </summary> /// <param name="cUserID"></param> /// <param name="cPassword"></param> /// <param name="cUserName"></param> /// <param name="cAuthority"></param> /// <returns></returns> public static int ORCS_User_INSERT(object cUserID, object cPassword, object cUserName, object cAuthority) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_User(cUserID, cPassword, cUserName, cAuthority) VALUES('" + cUserID + "','" + cPassword + "','" + cUserName + "','" + cAuthority + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 更新學生出席狀態 /// </summary> /// <param name="cUserID"></param> /// <param name="cPassword"></param> /// <returns></returns> public static int ORCS_User_UPDATE_UserID_Password(object cUserID, object cPassword) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_ORCS SET cPassword = '******' WHERE cUserID LIKE '" + cUserID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據GroupID刪除群組使用者 /// </summary> /// <param name="cUserID"></param> /// <param name="iGroupID"></param> /// <param name="cGroupClassify"></param> /// <returns></returns> public static int ORCS_MeetingIdentity_DELETE_by_GroupID(object iGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_MeetingIdentity WHERE iGroupID LIKE '" + iGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 更新TempGroup資料表 /// </summary> /// <param name="iTempGroupID"></param> /// <param name="cTempGroupName"></param> /// <returns></returns> public static int ORCS_TempGroup_UPDATE(object iTempGroupID, object cTempGroupName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_TempGroup SET cTempGroupName = '" + cTempGroupName + "' WHERE iTempGroupID LIKE '" + iTempGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 儲存某組別的主席和紀錄者 /// </summary> /// <param name="cUserID"></param> /// <param name="iGroupID"></param> /// <param name="cGroupClassify"></param> /// <returns></returns> public static int ORCS_MeetingIdentity_INSERT(object iGroupID, object cUserID, object cIdentityType) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_MeetingIdentity(iGroupID, cUserID, cIdentityType) VALUES('" + iGroupID + "','" + cUserID + "','" + cIdentityType + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在SchoolGroup資料表存入資料 /// </summary> /// <param name="cSchoolGroupName"></param> /// <returns></returns> public static int ORCS_SchoolGroup_INSERT(object cSchoolGroupName, object cSchoolGroupParentNodeID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_SchoolGroup(cSchoolGroupName,iParentNodeID) VALUES('" + cSchoolGroupName + "','" + cSchoolGroupParentNodeID + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 更新學生作答狀態 /// </summary> /// <param name="cExerciseID"></param> /// <param name="cUserID"></param> /// <param name="iExerciseState"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_ExerciseCondition_UPDATE(object cExerciseID, object cUserID, object iExerciseState, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_ExerciseCondition SET iExerciseState = '" + iExerciseState + "' WHERE cExerciseID LIKE '" + cExerciseID + "' AND cUserID LIKE '" + cUserID + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據UserID和GroupID刪除使用者出席狀態資料 /// </summary> /// <param name="cUserID"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_StudentAttendance_DELETE_by_UserID_GroupID(object cUserID, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_StudentAttendance WHERE cUserID LIKE '" + cUserID + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據ExerciseID和GroupID刪除使用者出席狀態資料 /// </summary> /// <param name="cExerciseID"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_ExerciseCondition_DELETE_by_cExerciseID_GroupID(object cExerciseID, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_ExerciseCondition WHERE cExerciseID LIKE '" + cExerciseID + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在StudentAttendanceHistory資料表存入資料 /// </summary> /// <param name="cAttendanceID"></param> /// <param name="cUserID"></param> /// <param name="iAttendanceCond"></param> /// <param name="cAttendanceTime"></param> /// <param name="cIPAddress"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_StudentAttendanceHistory_INSERT(object cAttendanceID, object cUserID, object iAttendanceCond, object cAttendanceTime, object cIPAddress, object iClassGroupID, object iGroupMode) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_StudentAttendanceHistory(cAttendanceID, cUserID, iAttendanceCond, cAttendanceTime, cIPAddress, iClassGroupID, iGroupMode) VALUES('" + cAttendanceID + "','" + cUserID + "','" + iAttendanceCond + "','" + cAttendanceTime + "','" + cIPAddress + "','" + iClassGroupID + "','" + iGroupMode + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 更新學生出席狀態,由於是自動檢查學生狀態無法得知該學生IP位址 /// </summary> /// <param name="cUserID"></param> /// <param name="iAttendanceCond"></param> /// <param name="cAttendanceTime"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_StudentAttendance_WithoutIPAddress_UPDATE(object cUserID, object iAttendanceCond, object cAttendanceTime, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_StudentAttendance SET iAttendanceCond = '" + iAttendanceCond + "', cAttendanceTime = '" + cAttendanceTime + "' WHERE cUserID LIKE '" + cUserID + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在StudentAttendance資料表存入資料 /// </summary> /// <param name="cUserID"></param> /// <param name="iAttendanceCond"></param> /// <returns></returns> public static int ORCS_StudentAttendance_INSERT(object cUserID, object iAttendanceCond) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_StudentAttendance(cUserID, iAttendanceCond) VALUES('" + cUserID + "','" + iAttendanceCond + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在StudentAttendance資料表存入資料 /// </summary> /// <param name="cUserID"></param> /// <param name="iAttendanceCond"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_StudentAttendance_INSERT_UserID_AttCond_GroupID_iGroupMode(object cUserID, object iAttendanceCond, object iClassGroupID, object iGroupMode) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_StudentAttendance(cUserID, iAttendanceCond, iClassGroupID , iGroupMode) VALUES('" + cUserID + "','" + iAttendanceCond + "','" + iClassGroupID + "','" + iGroupMode + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 從ClassTimeTable刪除群組 /// </summary> /// <param name="iClassGroupID"></param> /// <param name="cStartTime"></param> /// <returns></returns> public static int ORCS_ClassTimeTable_DELETE_by_ClassGroupID_StartTime(object iClassGroupID, object cStartTime) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_ClassTimeTable WHERE iClassGroupID LIKE '" + iClassGroupID + "' AND cStartTime LIKE '" + cStartTime + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在ClassTimeTable資料表存入資料 /// </summary> /// <param name="iClassGroupID"></param> /// <param name="cStartTime"></param> /// <param name="cEndTime"></param> /// <returns></returns> public static int ORCS_ClassTimeTable_INSERT(object iClassGroupID, object cStartTime, object cEndTime) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_ClassTimeTable(iClassGroupID, cStartTime, cEndTime) VALUES('" + iClassGroupID + "','" + cStartTime + "','" + cEndTime + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在TempGroup資料表存入資料 /// </summary> /// <param name="cTempGroupName"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_TempGroup_INSERT(object cTempGroupName, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_TempGroup(cTempGroupName, iClassGroupID) VALUES('" + cTempGroupName + "','" + iClassGroupID + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 更新學生上傳作品檔案資料 /// </summary> /// <param name="cExerciseCondID"></param> /// <param name="cExerciseID"></param> /// <param name="cUserID"></param> /// <param name="cFileName"></param> /// <returns></returns> public static int ORCS_TextUploadData_UPDATE(object cExerciseCondID, object cExerciseID, object cUserID, object cTextContent) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_TextUploadData SET txtTextContent = '" + cTextContent + "' WHERE cExerciseCondID LIKE '" + cExerciseCondID + "' AND cExerciseID LIKE '" + cExerciseID + "' AND cUserID LIKE '" + cUserID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據NodeID更新節點的IsNextNodeDepartment /// </summary> /// <param name="isNextNodeDepartment"></param> /// <param name="nodeID"></param> /// <returns></returns> public static int ORCS_Group_UPDATE_IsNextNodeDepartment_BY_NodeID(object nodeID, object isNextNodeDepartment) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE " + TB_ORCS_Group + " SET " + TF_Group_IsNextNodeDepartment + " = " + isNextNodeDepartment + " WHERE " + TF_Group_NodeID + " LIKE '" + nodeID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據NodeID更新NodeName /// </summary> /// <param name="NodeID"></param> /// <param name="NodeName"></param> /// <returns></returns> public static int ORCS_Group_UPDATE_NodeName_BY_NodeID(object NodeID, object NodeName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE " + TB_ORCS_Group + " SET " + TF_Group_NodeName + " = '" + NodeName + "' WHERE " + TF_Group_NodeID + " LIKE '" + NodeID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在ORCS_GroupClassification資料表存入節點類別 /// </summary> /// <param name="cNodeClassificationName">節點類別名稱</param> /// <returns></returns> public static int ORCS_GroupClassification_INSERT(object cNodeClassificationName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO " + TB_ORCS_GroupClassification + "(" + TF_GroupClassification_cGroupNodeClassificationName + ") VALUES('" + cNodeClassificationName + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在群組資料表存入資料 /// </summary> /// <param name="cUserID"></param> /// <param name="iGroupID"></param> /// <returns></returns> public static int ORCS_GroupMember_INSERT(object cUserID, object iGroupID, object cGroupClassify) { clsORCSDB ORCSDB = new clsORCSDB(); string strAthority = AllSystemUserUtil.GetAuthourityByUserID(cUserID.ToString()); string strTableName = GetTableNameByGroupClassify(cGroupClassify.ToString(), strAthority); string strSQL = "INSERT INTO " + strTableName + "(cUserID, iGroupID) VALUES('" + cUserID + "','" + iGroupID + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 根據UserID、GroupID和GroupClassify刪除群組使用者 /// </summary> /// <param name="cUserID"></param> /// <param name="iGroupID"></param> /// <param name="cGroupClassify"></param> /// <returns></returns> public static int ORCS_GroupMember_DELETE_by_UserID_GroupID_Classify(object cUserID, object iGroupID, object cGroupClassify) { string strAthority = AllSystemUserUtil.GetAuthourityByUserID(cUserID.ToString()); string strTableName = GetTableNameByGroupClassify(cGroupClassify.ToString(), strAthority); clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE " + strTableName + " WHERE cUserID LIKE '" + cUserID + "' AND iGroupID LIKE '" + iGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 當登入或重新簽到會增加學生出席記錄 /// </summary> /// <param name="iClassGroupID"></param> /// <param name="cUserID"></param> /// <param name="cAttendanceTime"></param> /// <param name="iAttendanceCond"></param> /// <returns></returns> public static int addStudentAttendanceRecord(object iClassGroupID, object cUserID, object cAttendanceTime, object iAttendanceCond, object iGroupMode) { clsORCSDB ORCSDB = new clsORCSDB(); //取得該堂課程最後堂次 DataTable dtClassTimeRecord = clsClassTimeRecord.getLastClassTimeRecord(iClassGroupID); string strSQL = "INSERT INTO ORCS_StudentAttendanceRecord(iClassGroupID, cUserID,cAttendanceTime,iAttendanceCond,iClassTime,iGroupMode) VALUES('" + iClassGroupID + "','" + cUserID + "','" + cAttendanceTime + "','" + iAttendanceCond + "','" + dtClassTimeRecord.Rows[0]["iClassTime"].ToString() + "','" + iGroupMode + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }