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