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