/// <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);
}
