/// <summary> /// 從TimeControl資料表取得資料 /// </summary> /// <param name="cTimeControlName"></param> /// <returns></returns> public static DataTable ORCS_TimeControl_SELECT(object cTimeControlName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "SELECT * FROM ORCS_TimeControl WHERE cTimeControlName LIKE '" + cTimeControlName + "' ORDER BY iTimeControlID ASC "; return(ORCSDB.GetDataSet(strSQL).Tables[0]); }
/// <summary> /// 從TimeControl資料表取得資料 /// </summary> /// <param name="cTimeControlName"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static DataTable ORCS_TimeControl_SELECT_TimeConName_GroupID(object cTimeControlName, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "SELECT * FROM ORCS_TimeControl WHERE cTimeControlName LIKE '" + cTimeControlName + "' AND iClassGroupID LIKE '" + iClassGroupID + "' ORDER BY iTimeControlID ASC "; return(ORCSDB.GetDataSet(strSQL).Tables[0]); }
/// <summary> /// 在TimeControl資料表存入資料 /// </summary> /// <param name="cTimeControlName"></param> /// <param name="cTime"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_TimeControl_INSERT_TimeName_Time_GroupID(object cTimeControlName, object cTime, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_TimeControl(cTimeControlName, cTime, iClassGroupID) VALUES('" + cTimeControlName + "','" + cTime + "','" + iClassGroupID + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在TimeControl資料表刪除資料 /// </summary> /// <param name="cTimeControlName"></param> /// <returns></returns> public static int ORCS_TimeControl_DELETE(object cTimeControlName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_TimeControl WHERE cTimeControlName LIKE '" + cTimeControlName + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在TimeControl資料表刪除資料 /// </summary> /// <param name="cTimeControlName"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_TimeControl_DELETE_TimeConName_GroupID(object cTimeControlName, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "DELETE ORCS_TimeControl WHERE cTimeControlName LIKE '" + cTimeControlName + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在SystemControl資料表存入資料 /// </summary> /// <param name="cSysControlName"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_SystemControl_INSERT_SysName_GroupID(object cSysControlName, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_SystemControl(cSysControlName, iClassGroupID ,iAnswerMode) VALUES('" + cSysControlName + "','" + iClassGroupID + "','0')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在SystemControl資料表存入資料 /// </summary> /// <param name="cSysControlName"></param> /// <returns></returns> public static int ORCS_SystemControl_INSERT(object cSysControlName) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "INSERT INTO ORCS_SystemControl(cSysControlName) VALUES('" + cSysControlName + "')"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在SystemControl資料表更新資料 /// </summary> /// <param name="cSysControlName"></param> /// <param name="iSysControlParam"></param> /// <param name="cStartTime"></param> /// <param name="cEndTime"></param> /// <param name="iClassGroupID"></param> /// <param name="iAnswerMode"></param> /// <returns></returns> public static int ORCS_SystemControl_UPDATE_SysName_Param_StartTime_EndTime_GroupID_AnswerMode(object cSysControlName, object iSysControlParam, object cStartTime, object cEndTime, object iClassGroupID, object iAnswerMode) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_SystemControl SET iSysControlParam = '" + iSysControlParam + "' ,cStartTime = '" + cStartTime + "' ,cEndTime = '" + cEndTime + "' ,iAnswerMode = '" + iAnswerMode + "' WHERE cSysControlName LIKE '" + cSysControlName + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在SystemControl資料表更新資料 /// </summary> /// <param name="cSysControlName"></param> /// <param name="cEndTime"></param> /// <param name="iClassGroupID"></param> /// <returns></returns> public static int ORCS_SystemControl_UPDATE_SysName_EndTime_GroupID(object cSysControlName, object cEndTime, object iClassGroupID) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_SystemControl SET cEndTime = '" + cEndTime + "' WHERE cSysControlName LIKE '" + cSysControlName + "' AND iClassGroupID LIKE '" + iClassGroupID + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }
/// <summary> /// 在SystemControl資料表更新資料 /// </summary> /// <param name="cSysControlName"></param> /// <param name="iSysControlParam"></param> /// <returns></returns> public static int ORCS_SystemControl_UPDATE(object cSysControlName, object iSysControlParam) { clsORCSDB ORCSDB = new clsORCSDB(); string strSQL = "UPDATE ORCS_SystemControl SET iSysControlParam = '" + iSysControlParam + "' WHERE cSysControlName LIKE '" + cSysControlName + "'"; try { ORCSDB.ExecuteNonQuery(strSQL); } catch { return(-1); } return(0); }