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