/// <summary>
/// @author : KhoaHT
/// @CreateDate:04/07/2008
/// @Description: static factory creating specific db util depend on specific connection type
/// </summary>
public static DBUtil MakeDBUtil(ConnectionFactory pConnection)
{
// In this version, only sqlconnection was supported
if (pConnection.DbType == "SQLConnection")
{
MSSQLServerUtil dbUtil = new MSSQLServerUtil(pConnection);
return dbUtil;
}
// not supported the other
else
throw new Exception("Invalid connection");
}
public PrWorkstation(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
public PrSchedule(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:04/07/2008
/// @Description: Static function get DB current systime
/// </summary>
public static DateTime getDBSystemTime(ConnectionFactory pConnection)
{
DBUtil dbUtil = MakeDBUtil(pConnection);
return dbUtil.GetDBSystemTime();
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:8/24/2009
/// @Description: Construction
/// </summary>
public PrWorkstationLog(ConnectionFactory pcnnFactory, string pstrQuery)
: base(pcnnFactory)
{
mDbCommand = mcnnFactory.MakeCommandStoreProc(pstrQuery);
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:8/24/2009
/// @Description: Construction
/// </summary>
public WorkstationLogSearchPK(ConnectionFactory pcnnFactory)
: base(pcnnFactory, "sp_ADV_WORKSTATION_LOG_Select_PK")
{
if (!pcnnFactory.IsFirstCreate(mDbCommand))
return;
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_ID_WORKSTATION_LOG, DbType.Int64, 8));
}
/// <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: 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>
/// Constructor no param
/// </summary>
public DBObject(ConnectionFactory pcnn)
{
Connection = pcnn;
}
public SysbaseUtil(ConnectionFactory pConnection)
: base(pConnection)
{
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:04/03/2008
/// @Description:
/// </summary>
/// <param name="pcnnFactory">ConnectionFactory</param>
public QTCCommand(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
public GeneralAccess(ConnectionFactory pConFactory)
{
ConnectFactory = pConFactory;
HshCommand = new Hashtable();
InitAllCommand();
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/07/2008
/// @Description:
/// </summary>
/// <param name="pcnnFactory">ConnectionFactory</param>
public PrDownloadLog(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description:
/// </summary>
/// <param name="pcnnFactory">ConnectionFactory</param>
public PrCustomer(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description:
/// </summary>
/// <param name="pcnnFactory">ConnectionFactory</param>
public PrArea(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
/// <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: Searh all WorkstationLog
/// </summary>
public static void Search(ConnectionFactory mcnnFactory, WorkstationLog pWorkstationLog, DataSet pDs)
{
Search(mcnnFactory, pWorkstationLog, pDs, STR_TABLE_NAME);
}
public MSAccessUtil(ConnectionFactory pConnection)
: base(pConnection)
{
}
/// <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);
}
public OracleUtil(ConnectionFactory pConnection)
: base(pConnection)
{
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:8/24/2009
/// @Description: Construction
/// </summary>
public WorkstationLogCreate(ConnectionFactory pcnnFactory)
: base(pcnnFactory, "sp_ADV_WORKSTATION_LOG_INSERT")
{
if (!pcnnFactory.IsFirstCreate(mDbCommand))
return;
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_RETURN_VALUE, DbType.Int64, ParameterDirection.ReturnValue));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_WORKSTATION_ID, DbType.Int32, 4));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_STATUS, DbType.Byte, 1));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_LAST_LOGIN_TIME, DbType.DateTime, 8));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_CURRENT_CLIP, DbType.String, 400));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_LAST_PLAY_TIME, DbType.DateTime, 8));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_LOG_DATE, DbType.DateTime, 8));
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:04/07/2008
/// @Description: Constructor
/// </summary>
public MSSQLServerUtil(ConnectionFactory pConnection)
: base(pConnection)
{
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:8/24/2009
/// @Description: Construction
/// </summary>
public WorkstationLogUpdatePK(ConnectionFactory pcnnFactory)
: base(pcnnFactory, "sp_ADV_WORKSTATION_LOG_Update_PK")
{
if (!pcnnFactory.IsFirstCreate(mDbCommand))
return;
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_ID_WORKSTATION_LOG, DbType.Int64, 8));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_ID_WORKSTATION_LOG_NEW, DbType.Int64, 8));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_WORKSTATION_ID, DbType.Int32, 4));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_STATUS, DbType.Byte, 1));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_LAST_LOGIN_TIME, DbType.DateTime, 8));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_CURRENT_CLIP, DbType.String, 400));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_LAST_PLAY_TIME, DbType.DateTime, 8));
mDbCommand.Parameters.Add(pcnnFactory.MakeParameter(STR_LOG_DATE, DbType.DateTime, 8));
}
public void Init(ConnectionFactory pConFactory,string sql)
{
this.IdbComma = pConFactory.MakeCommand();
this.IdbComma.Connection = pConFactory.ConIdbConnection;
this.IdbComma.CommandText = sql;
}
/// <summary>
/// @author : KhoaHT
/// @CreateDate:04/07/2008
/// @Description: Constructor
/// </summary>
public DBUtil(ConnectionFactory pConnection)
{
mConnection = pConnection;
}
public DB2Util(ConnectionFactory pConnection)
: base(pConnection)
{
}
/// <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;
}
/// <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 : TrungMT
/// @CreateDate:04/07/2008
/// @Description:
/// </summary>
/// <param name="pcnnFactory">ConnectionFactory</param>
public PrAdvProperties(ConnectionFactory pcnnFactory)
: base(pcnnFactory)
{
}
public MySQLUtil(ConnectionFactory pConnection)
: base(pConnection)
{
}
