/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: search some WorkstationLog depend parameter filter /// </summary> public DataSet Retrieves(WorkstationLog pWorkstationLog) { try { Open(); return PrWorkstationLog.Search(Connection, pWorkstationLog); } catch (Exception exp) { throw exp; } finally { Close(); } }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Delete 1 WorkstationLog with primary key /// </summary> public int Delete(WorkstationLog pWorkstationLog) { int intRowAffected = 0; try { Open(); intRowAffected = PrWorkstationLog.Delete(Connection, pWorkstationLog); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intRowAffected; }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Insert 1 WorkstationLog and return WorkstationLog auto increment /// </summary> public int Add(WorkstationLog pWorkstationLog) { int intReturn = -1; try { Open(); intReturn = PrWorkstationLog.Create(Connection, pWorkstationLog); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intReturn; }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Searh all WorkstationLog /// </summary> public static DataSet Search(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog, string pstrTableName) { WorkstationLogSearch search = new WorkstationLogSearch(mcnnFactory); search.WorkstationLog = pWorkstationLog; return search.ExcuteDataSet(pstrTableName); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Searh all WorkstationLog /// </summary> public static void Search(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog, DataSet pDs) { Search(mcnnFactory, pWorkstationLog, pDs, STR_TABLE_NAME); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Searh all WorkstationLog /// </summary> public static void Search(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog, DataSet pDs, string pstrTableName) { WorkstationLogSearch search = new WorkstationLogSearch(mcnnFactory); search.WorkstationLog = pWorkstationLog; search.ExcuteDataSet(pDs, pstrTableName); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Delete 1 WorkstationLog with pk /// </summary> /// <param name="pWorkstationLog ">WorkstationLog public static int Delete(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog) { WorkstationLogDelete delete = new WorkstationLogDelete(mcnnFactory); delete.WorkstationLog = pWorkstationLog; return delete.ExecuteNonQuery(); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Create new WorkstationLog and return auto increment /// </summary> /// </p><param name="pWorkstationLog ">WorkstationLog public static int Create(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog) { WorkstationLogCreate create = new WorkstationLogCreate(mcnnFactory); create.WorkstationLog = pWorkstationLog; create.ExecuteNonQuery(); return (int)create.ReturnValue; }
private void UpdateClipPlay(int schedule_id,string clipName) { WorkstationLog wlog = new WorkstationLog(); wlog.SCHEDULE_ID = schedule_id; wlog.WORKSTATIONID = workstation.WorkstationId; wlog.CURRENTCLIP = clipName; wlog.LASTLOGINTIME = workstation.LogTime; wlog.LASTPLAYTIME = DateTime.Now; wlog.LOGDATE = DateTime.Now; wlog.STATUS = (byte)1; BWorkstationLog bwlog = new BWorkstationLog(); bwlog.Update(wlog); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: retrieve 1 WorkstationLog with ID_WORKSTATION_LOG /// </summary> /// </p><param name="plngIDWORKSTATIONLOG">long public DataSet RetrievesIDWORKSTATIONLOG(long plngIDWORKSTATIONLOG) { WorkstationLog workstationlog = new WorkstationLog(); workstationlog.IDWORKSTATIONLOG = plngIDWORKSTATIONLOG; return Retrieves(workstationlog); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: retrieve 1 WorkstationLog with WORKSTATION_ID /// </summary> /// <param name="pintWORKSTATIONID">int public DataSet RetrievesWORKSTATIONID(int pintWORKSTATIONID) { WorkstationLog workstationlog = new WorkstationLog(); workstationlog.WORKSTATIONID = pintWORKSTATIONID; return Retrieves(workstationlog); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: retrieve 1 WorkstationLog with STATUS /// </summary> /// <param name="pobjectSTATUS">object public DataSet RetrievesSTATUS(byte pobjectSTATUS) { WorkstationLog workstationlog = new WorkstationLog(); workstationlog.STATUS = pobjectSTATUS; return Retrieves(workstationlog); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: retrieve 1 WorkstationLog with LOG_DATE /// </summary> /// <param name="pdteLOGDATE">DateTime public DataSet RetrievesLOGDATE(DateTime pdteLOGDATE) { WorkstationLog workstationlog = new WorkstationLog(); workstationlog.LOGDATE = pdteLOGDATE; return Retrieves(workstationlog); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: retrieve 1 WorkstationLog with LAST_PLAY_TIME /// </summary> /// <param name="pdteLASTPLAYTIME">DateTime public DataSet RetrievesLASTPLAYTIME(DateTime pdteLASTPLAYTIME) { WorkstationLog workstationlog = new WorkstationLog(); workstationlog.LASTPLAYTIME = pdteLASTPLAYTIME; return Retrieves(workstationlog); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Searh all WorkstationLog /// </summary> public static DataSet Search(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog) { return Search(mcnnFactory, pWorkstationLog, STR_TABLE_NAME); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: Update 1 WorkstationLog with PK /// </summary> /// <param name="pWorkstationLog ">WorkstationLog public static int Update(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog) { WorkstationLogUpdate update = new WorkstationLogUpdate(mcnnFactory); update.WorkstationLog = pWorkstationLog; return update.ExecuteNonQuery(); }
/// <summary> /// @author : KhoaHT /// @CreateDate:8/24/2009 /// @Description: retrieve 1 WorkstationLog with CURRENT_CLIP /// </summary> /// <param name="pstrCURRENTCLIP">string public DataSet RetrievesCURRENTCLIP(string pstrCURRENTCLIP) { WorkstationLog workstationlog = new WorkstationLog(); workstationlog.CURRENTCLIP = pstrCURRENTCLIP; return Retrieves(workstationlog); }