void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"UPDATE {0} SET " +
"{1}=?, {2}=?, {3}=?, {4}=?, {5}=?, {6}=? " +
"WHERE {7}=? AND {8}=?;",
TableName,
// Data
GetFieldName(QueryValues.CharName),
GetFieldName(QueryValues.CorpName),
GetFieldName(QueryValues.CorpID),
GetFieldName(QueryValues.LimitedKey),
GetFieldName(QueryValues.FullKey),
GetFieldName(QueryValues.RegCode),
// Key
GetFieldName(QueryValues.UserID),
GetFieldName(QueryValues.CharID)));
// Data
dbCommand.AddParameter((long)QueryValues.CharName);
dbCommand.AddParameter((long)QueryValues.CorpName);
dbCommand.AddParameter((long)QueryValues.CorpID);
dbCommand.AddParameter((long)QueryValues.LimitedKey);
dbCommand.AddParameter((long)QueryValues.FullKey);
dbCommand.AddParameter((long)QueryValues.RegCode);
// Key
dbCommand.AddParameter((long)QueryValues.UserID);
dbCommand.AddParameter((long)QueryValues.CharID);
}
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"INSERT INTO {0} ({1}, {2}, {3}, {4}, {5}, " +
"{6}, {7}, {8}) " +
"VALUES(?,?,?,?,?,?,?,?);",
TableName,
// Key
GetFieldName(QueryValues.UserID),
GetFieldName(QueryValues.CharID),
// Data
GetFieldName(QueryValues.CharName),
GetFieldName(QueryValues.CorpName),
GetFieldName(QueryValues.CorpID),
GetFieldName(QueryValues.LimitedKey),
GetFieldName(QueryValues.FullKey),
GetFieldName(QueryValues.RegCode)));
// Key
dbCommand.AddParameter((long)QueryValues.UserID);
dbCommand.AddParameter((long)QueryValues.CharID);
// Data
dbCommand.AddParameter((long)QueryValues.CharName);
dbCommand.AddParameter((long)QueryValues.CorpName);
dbCommand.AddParameter((long)QueryValues.CorpID);
dbCommand.AddParameter((long)QueryValues.LimitedKey);
dbCommand.AddParameter((long)QueryValues.FullKey);
dbCommand.AddParameter((long)QueryValues.RegCode);
}
void IDBRecord.FillCommandUpdate(Database.DatabaseCommand dbCommand)
{
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.CharID);
dbCommand.SetParamValue((long)QueryValues.AccountID, m_DataObject.AccountID);
dbCommand.SetParamValue((long)QueryValues.AccountKey, m_DataObject.AccountKey);
dbCommand.SetParamValue((long)QueryValues.balance, m_DataObject.balance);
}
void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
{
// key
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.charID);
dbCommand.SetParamValue((long)QueryValues.jobID, m_DataObject.jobID);
dbCommand.SetParamValue((long)QueryValues.installerID, m_DataObject.installerID);
dbCommand.SetParamValue((long)QueryValues.installTime, m_DataObject.installTime);
}
void IDBRecord.FillCommandInsert(Database.DatabaseCommand dbCommand)
{
dbCommand.SetParamValue((long)QueryValues.CorpID, m_DataObject.CorpID);
dbCommand.SetParamValue((long)QueryValues.standingType, m_DataObject.standingType);
dbCommand.SetParamValue((long)QueryValues.ID, m_DataObject.ID);
dbCommand.SetParamValue((long)QueryValues.Name, m_DataObject.Name);
dbCommand.SetParamValue((long)QueryValues.standing, m_DataObject.standing);
}
void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
{
// key
dbCommand.SetParamValue((long)QueryValues.charID, m_DataObject.charID);
dbCommand.SetParamValue((long)QueryValues.orderID, m_DataObject.orderID);
dbCommand.SetParamValue((long)QueryValues.stationID, m_DataObject.stationID);
dbCommand.SetParamValue((long)QueryValues.typeID, m_DataObject.typeID);
dbCommand.SetParamValue((long)QueryValues.accountKey, m_DataObject.accountKey);
dbCommand.SetParamValue((long)QueryValues.issued, m_DataObject.issued);
}
void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
{
// key
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.CharID);
dbCommand.SetParamValue((long)QueryValues.refID, m_DataObject.refID);
dbCommand.SetParamValue((long)QueryValues.refTypeID, m_DataObject.refTypeID);
dbCommand.SetParamValue((long)QueryValues.date, m_DataObject.date);
dbCommand.SetParamValue((long)QueryValues.ownerID1, m_DataObject.ownerID1);
dbCommand.SetParamValue((long)QueryValues.ownerID2, m_DataObject.ownerID2);
dbCommand.SetParamValue((long)QueryValues.argID, m_DataObject.argID);
}
void IDBRecord.FillCommandUpdate(Database.DatabaseCommand dbCommand)
{
// data
dbCommand.SetParamValue((long)QueryValues.CorpID, m_DataObject.CorpID);
dbCommand.SetParamValue((long)QueryValues.standingType, m_DataObject.standingType);
dbCommand.SetParamValue((long)QueryValues.ID, m_DataObject.ID);
dbCommand.SetParamValue((long)QueryValues.Name, m_DataObject.Name);
dbCommand.SetParamValue((long)QueryValues.standing, m_DataObject.standing);
// key
dbCommand.SetParamValue((long)QueryValues.Key_ID, m_DataObject.Key_ID);
}
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"DELETE FROM {0} " +
"WHERE {1}=?;",
TableName,
GetFieldName(QueryValues.Key_ID)));
// key
dbCommand.AddParameter((long)QueryValues.Key_ID);
}
void IDBRecord.FillCommandUpdate(Database.DatabaseCommand dbCommand)
{
// Key
dbCommand.SetParamValue((long)QueryValues.UserID, m_DataObject.UserID);
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.CharID);
// Data
dbCommand.SetParamValue((long)QueryValues.CharName, m_DataObject.CharName);
dbCommand.SetParamValue((long)QueryValues.CorpName, m_DataObject.CorpName);
dbCommand.SetParamValue((long)QueryValues.CorpID, m_DataObject.CorpID);
dbCommand.SetParamValue((long)QueryValues.LimitedKey, m_DataObject.LimitedKey);
dbCommand.SetParamValue((long)QueryValues.FullKey, m_DataObject.FullKey);
dbCommand.SetParamValue((long)QueryValues.RegCode, m_DataObject.RegCode);
}
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand)
{
IDBRecord iobj = this as IDBRecord;
dbCommand.SetCommand(String.Format(
"DELETE FROM {0} " +
"WHERE {1}=? AND {2}=? AND {3}=? AND {4}=? AND {5}=? AND {6}=? AND {7}=?;",
TableName,
iobj.GetFieldName((long)QueryValues.CharID),
iobj.GetFieldName((long)QueryValues.refID),
iobj.GetFieldName((long)QueryValues.refTypeID),
iobj.GetFieldName((long)QueryValues.date),
iobj.GetFieldName((long)QueryValues.ownerID1),
iobj.GetFieldName((long)QueryValues.ownerID2),
iobj.GetFieldName((long)QueryValues.argID)));
}
void IDBRecord.FillCommandInsert(Database.DatabaseCommand dbCommand)
{
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.CharID);
dbCommand.SetParamValue((long)QueryValues.refID, m_DataObject.refID);
dbCommand.SetParamValue((long)QueryValues.refTypeID, m_DataObject.refTypeID);
dbCommand.SetParamValue((long)QueryValues.date, m_DataObject.date);
dbCommand.SetParamValue((long)QueryValues.ownerID1, m_DataObject.ownerID1);
dbCommand.SetParamValue((long)QueryValues.ownerID2, m_DataObject.ownerID2);
dbCommand.SetParamValue((long)QueryValues.argID, m_DataObject.argID);
dbCommand.SetParamValue((long)QueryValues.ownerName1, m_DataObject.ownerName1);
dbCommand.SetParamValue((long)QueryValues.ownerName2, m_DataObject.ownerName2);
dbCommand.SetParamValue((long)QueryValues.argName1, m_DataObject.argName1);
dbCommand.SetParamValue((long)QueryValues.amount, m_DataObject.amount);
dbCommand.SetParamValue((long)QueryValues.balance, m_DataObject.balance);
dbCommand.SetParamValue((long)QueryValues.reason, m_DataObject.reason);
}
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"DELETE FROM {0} " +
"WHERE {1}=? AND {2}=? AND {3}=?;",
TableName,
// key
GetFieldName(QueryValues.CharID),
GetFieldName(QueryValues.AccountID),
GetFieldName(QueryValues.AccountKey)));
// key
dbCommand.AddParameter((long)QueryValues.CharID);
dbCommand.AddParameter((long)QueryValues.AccountID);
dbCommand.AddParameter((long)QueryValues.AccountKey);
}
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"INSERT INTO {0} ( {1}, {2}, {3}, {4}, {5}, " +
" {6}, {7}, {8}, {9}, {10}, " +
"{11}, {12}, {13}, {14}, {15}, " +
"{16}) " +
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);",
TableName,
// key
GetFieldName(QueryValues.charID),
GetFieldName(QueryValues.orderID),
GetFieldName(QueryValues.stationID),
GetFieldName(QueryValues.typeID),
GetFieldName(QueryValues.accountKey),
GetFieldName(QueryValues.issued),
// data
GetFieldName(QueryValues.ownerID),
GetFieldName(QueryValues.volEntered),
GetFieldName(QueryValues.volRemaining),
GetFieldName(QueryValues.minVolume),
GetFieldName(QueryValues.orderState),
GetFieldName(QueryValues.range),
GetFieldName(QueryValues.duration),
GetFieldName(QueryValues.escrow),
GetFieldName(QueryValues.price),
GetFieldName(QueryValues.bid)));
// key
dbCommand.AddParameter((long)QueryValues.charID);
dbCommand.AddParameter((long)QueryValues.orderID);
dbCommand.AddParameter((long)QueryValues.stationID);
dbCommand.AddParameter((long)QueryValues.typeID);
dbCommand.AddParameter((long)QueryValues.accountKey);
dbCommand.AddParameter((long)QueryValues.issued);
// data
dbCommand.AddParameter((long)QueryValues.ownerID);
dbCommand.AddParameter((long)QueryValues.volEntered);
dbCommand.AddParameter((long)QueryValues.volRemaining);
dbCommand.AddParameter((long)QueryValues.minVolume);
dbCommand.AddParameter((long)QueryValues.orderState);
dbCommand.AddParameter((long)QueryValues.range);
dbCommand.AddParameter((long)QueryValues.duration);
dbCommand.AddParameter((long)QueryValues.escrow);
dbCommand.AddParameter((long)QueryValues.price);
dbCommand.AddParameter((long)QueryValues.bid);
}
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"UPDATE {0} SET {1}=?, {2}=?, {3}=?, {4}=?, {5}=?, " +
"{6}=?, {7}=?, {8}=?, {9}=?, {10}=? " +
"WHERE {11}=? AND {12}=? AND {13}=? AND {14}=? AND {15}=? AND {16}=?;",
TableName,
// data
GetFieldName(QueryValues.ownerID),
GetFieldName(QueryValues.volEntered),
GetFieldName(QueryValues.volRemaining),
GetFieldName(QueryValues.minVolume),
GetFieldName(QueryValues.orderState),
GetFieldName(QueryValues.range),
GetFieldName(QueryValues.duration),
GetFieldName(QueryValues.escrow),
GetFieldName(QueryValues.price),
GetFieldName(QueryValues.bid),
// key
GetFieldName(QueryValues.charID),
GetFieldName(QueryValues.orderID),
GetFieldName(QueryValues.stationID),
GetFieldName(QueryValues.typeID),
GetFieldName(QueryValues.accountKey),
GetFieldName(QueryValues.issued)));
// data
dbCommand.AddParameter((long)QueryValues.ownerID);
dbCommand.AddParameter((long)QueryValues.volEntered);
dbCommand.AddParameter((long)QueryValues.volRemaining);
dbCommand.AddParameter((long)QueryValues.minVolume);
dbCommand.AddParameter((long)QueryValues.orderState);
dbCommand.AddParameter((long)QueryValues.range);
dbCommand.AddParameter((long)QueryValues.duration);
dbCommand.AddParameter((long)QueryValues.escrow);
dbCommand.AddParameter((long)QueryValues.price);
dbCommand.AddParameter((long)QueryValues.bid);
// key
dbCommand.AddParameter((long)QueryValues.charID);
dbCommand.AddParameter((long)QueryValues.orderID);
dbCommand.AddParameter((long)QueryValues.stationID);
dbCommand.AddParameter((long)QueryValues.typeID);
dbCommand.AddParameter((long)QueryValues.accountKey);
dbCommand.AddParameter((long)QueryValues.issued);
}
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"INSERT INTO {0} ({1}, {2}, {3}, {4}) " +
"VALUES(?, ?, ?, ?);",
TableName,
GetFieldName(QueryValues.CharID),
GetFieldName(QueryValues.AccountID),
GetFieldName(QueryValues.AccountKey),
GetFieldName(QueryValues.balance)));
// key
dbCommand.AddParameter((long)QueryValues.CharID);
dbCommand.AddParameter((long)QueryValues.AccountID);
dbCommand.AddParameter((long)QueryValues.AccountKey);
// data
dbCommand.AddParameter((long)QueryValues.balance);
}
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"INSERT INTO {0} ({1}, {2}, {3}, {4}, {5}) " +
"VALUES(?, ?, ?, ?, ?);",
TableName,
GetFieldName(QueryValues.CorpID),
GetFieldName(QueryValues.standingType),
GetFieldName(QueryValues.ID),
GetFieldName(QueryValues.Name),
GetFieldName(QueryValues.standing)));
// data
dbCommand.AddParameter((long)QueryValues.CorpID);
dbCommand.AddParameter((long)QueryValues.standingType);
dbCommand.AddParameter((long)QueryValues.ID);
dbCommand.AddParameter((long)QueryValues.Name);
dbCommand.AddParameter((long)QueryValues.standing);
}
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"UPDATE {0} SET {1}=? " +
"WHERE {2}=? AND {3}=? AND {4}=?;",
TableName,
// data
GetFieldName(QueryValues.balance),
// key
GetFieldName(QueryValues.CharID),
GetFieldName(QueryValues.AccountID),
GetFieldName(QueryValues.AccountKey)));
// data
dbCommand.AddParameter((long)QueryValues.balance);
// key
dbCommand.AddParameter((long)QueryValues.CharID);
dbCommand.AddParameter((long)QueryValues.AccountID);
dbCommand.AddParameter((long)QueryValues.AccountKey);
}
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
IDBRecord iobj = this as IDBRecord;
dbCommand.SetCommand(String.Format(
"UPDATE {0} SET {1}=?, {2}=?, {3}=?, {4}=?, {5}=?, {6}=? " +
"WHERE {7}=? AND {8}=? AND {9}=? AND {10}=? AND {11}=? AND {12}=? AND {13}=?;",
TableName,
// data
iobj.GetFieldName((long)QueryValues.ownerName1),
iobj.GetFieldName((long)QueryValues.ownerName2),
iobj.GetFieldName((long)QueryValues.argName1),
iobj.GetFieldName((long)QueryValues.amount),
iobj.GetFieldName((long)QueryValues.balance),
iobj.GetFieldName((long)QueryValues.reason),
// key
iobj.GetFieldName((long)QueryValues.CharID),
iobj.GetFieldName((long)QueryValues.refID),
iobj.GetFieldName((long)QueryValues.refTypeID),
iobj.GetFieldName((long)QueryValues.date),
iobj.GetFieldName((long)QueryValues.ownerID1),
iobj.GetFieldName((long)QueryValues.ownerID2),
iobj.GetFieldName((long)QueryValues.argID)));
// data
dbCommand.AddParameter((long)QueryValues.ownerName1);
dbCommand.AddParameter((long)QueryValues.ownerName2);
dbCommand.AddParameter((long)QueryValues.argName1);
dbCommand.AddParameter((long)QueryValues.amount);
dbCommand.AddParameter((long)QueryValues.balance);
dbCommand.AddParameter((long)QueryValues.reason);
// key
dbCommand.AddParameter((long)QueryValues.CharID);
dbCommand.AddParameter((long)QueryValues.refID);
dbCommand.AddParameter((long)QueryValues.refTypeID);
dbCommand.AddParameter((long)QueryValues.date);
dbCommand.AddParameter((long)QueryValues.ownerID1);
dbCommand.AddParameter((long)QueryValues.ownerID2);
dbCommand.AddParameter((long)QueryValues.argID);
}
void IDBRecord.FillCommandUpdate(Database.DatabaseCommand dbCommand)
{
// key
dbCommand.SetParamValue((long)QueryValues.charID, m_DataObject.charID);
dbCommand.SetParamValue((long)QueryValues.orderID, m_DataObject.orderID);
dbCommand.SetParamValue((long)QueryValues.stationID, m_DataObject.stationID);
dbCommand.SetParamValue((long)QueryValues.typeID, m_DataObject.typeID);
dbCommand.SetParamValue((long)QueryValues.accountKey, m_DataObject.accountKey);
dbCommand.SetParamValue((long)QueryValues.issued, m_DataObject.issued);
// data
dbCommand.SetParamValue((long)QueryValues.ownerID, m_DataObject.ownerID);
dbCommand.SetParamValue((long)QueryValues.volEntered, m_DataObject.volEntered);
dbCommand.SetParamValue((long)QueryValues.volRemaining, m_DataObject.volRemaining);
dbCommand.SetParamValue((long)QueryValues.minVolume, m_DataObject.minVolume);
dbCommand.SetParamValue((long)QueryValues.orderState, m_DataObject.orderState);
dbCommand.SetParamValue((long)QueryValues.range, m_DataObject.range);
dbCommand.SetParamValue((long)QueryValues.duration, m_DataObject.duration);
dbCommand.SetParamValue((long)QueryValues.escrow, m_DataObject.escrow);
dbCommand.SetParamValue((long)QueryValues.price, m_DataObject.price);
dbCommand.SetParamValue((long)QueryValues.bid, m_DataObject.bid);
}
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand)
{
IDBRecord iobj = this as IDBRecord;
dbCommand.SetCommand(String.Format(
"INSERT INTO {0} ({1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}" +
"{9}, {10}, {11}, {12}, {13}) " +
"VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);",
TableName,
iobj.GetFieldName((long)QueryValues.CharID),
iobj.GetFieldName((long)QueryValues.refID),
iobj.GetFieldName((long)QueryValues.refTypeID),
iobj.GetFieldName((long)QueryValues.date),
iobj.GetFieldName((long)QueryValues.ownerID1),
iobj.GetFieldName((long)QueryValues.ownerID2),
iobj.GetFieldName((long)QueryValues.argID),
iobj.GetFieldName((long)QueryValues.ownerName1),
iobj.GetFieldName((long)QueryValues.ownerName2),
iobj.GetFieldName((long)QueryValues.argName1),
iobj.GetFieldName((long)QueryValues.amount),
iobj.GetFieldName((long)QueryValues.balance),
iobj.GetFieldName((long)QueryValues.reason)));
// key
dbCommand.AddParameter((long)QueryValues.CharID);
dbCommand.AddParameter((long)QueryValues.refID);
dbCommand.AddParameter((long)QueryValues.refTypeID);
dbCommand.AddParameter((long)QueryValues.date);
dbCommand.AddParameter((long)QueryValues.ownerID1);
dbCommand.AddParameter((long)QueryValues.ownerID2);
dbCommand.AddParameter((long)QueryValues.argID);
// data
dbCommand.AddParameter((long)QueryValues.ownerName1);
dbCommand.AddParameter((long)QueryValues.ownerName2);
dbCommand.AddParameter((long)QueryValues.argName1);
dbCommand.AddParameter((long)QueryValues.amount);
dbCommand.AddParameter((long)QueryValues.balance);
dbCommand.AddParameter((long)QueryValues.reason);
}
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"DELETE FROM {0} " +
"WHERE {1}=? AND {2}=? AND {3}=? AND {4}=? AND {5}=? AND {6}=?;",
TableName,
// key
GetFieldName(QueryValues.charID),
GetFieldName(QueryValues.orderID),
GetFieldName(QueryValues.stationID),
GetFieldName(QueryValues.typeID),
GetFieldName(QueryValues.accountKey),
GetFieldName(QueryValues.issued)));
// key
dbCommand.AddParameter((long)QueryValues.charID);
dbCommand.AddParameter((long)QueryValues.orderID);
dbCommand.AddParameter((long)QueryValues.stationID);
dbCommand.AddParameter((long)QueryValues.typeID);
dbCommand.AddParameter((long)QueryValues.accountKey);
dbCommand.AddParameter((long)QueryValues.issued);
}
void IDBRecord.FillCommandUpdate(Database.DatabaseCommand dbCommand)
{
// key
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.charID);
dbCommand.SetParamValue((long)QueryValues.jobID, m_DataObject.jobID);
dbCommand.SetParamValue((long)QueryValues.installerID, m_DataObject.installerID);
dbCommand.SetParamValue((long)QueryValues.installTime, m_DataObject.installTime);
// data
dbCommand.SetParamValue((long)QueryValues.assemblyLineID, m_DataObject.assemblyLineID);
dbCommand.SetParamValue((long)QueryValues.containerID, m_DataObject.containerID);
dbCommand.SetParamValue((long)QueryValues.installedItemID, m_DataObject.installedItemID);
dbCommand.SetParamValue((long)QueryValues.installedItemLocationID, m_DataObject.installedItemLocationID);
dbCommand.SetParamValue((long)QueryValues.installedItemQuantity, m_DataObject.installedItemQuantity);
dbCommand.SetParamValue((long)QueryValues.installedItemProductivityLevel, m_DataObject.installedItemProductivityLevel);
dbCommand.SetParamValue((long)QueryValues.installedItemMaterialLevel, m_DataObject.installedItemMaterialLevel);
dbCommand.SetParamValue((long)QueryValues.installedItemLicensedProductionRunsRemaining, m_DataObject.installedItemLicensedProductionRunsRemaining);
dbCommand.SetParamValue((long)QueryValues.outputLocationID, m_DataObject.outputLocationID);
dbCommand.SetParamValue((long)QueryValues.runs, m_DataObject.runs);
dbCommand.SetParamValue((long)QueryValues.licensedProductionRuns, m_DataObject.licensedProductionRuns);
dbCommand.SetParamValue((long)QueryValues.installedInSolarSystemID, m_DataObject.installedInSolarSystemID);
dbCommand.SetParamValue((long)QueryValues.containerLocationID, m_DataObject.containerLocationID);
dbCommand.SetParamValue((long)QueryValues.materialMultiplier, m_DataObject.materialMultiplier);
dbCommand.SetParamValue((long)QueryValues.charMaterialMultiplier, m_DataObject.charMaterialMultiplier);
dbCommand.SetParamValue((long)QueryValues.timeMultiplier, m_DataObject.timeMultiplier);
dbCommand.SetParamValue((long)QueryValues.charTimeMultiplier, m_DataObject.charTimeMultiplier);
dbCommand.SetParamValue((long)QueryValues.installedItemTypeID, m_DataObject.installedItemTypeID);
dbCommand.SetParamValue((long)QueryValues.outputTypeID, m_DataObject.outputTypeID);
dbCommand.SetParamValue((long)QueryValues.containerTypeID, m_DataObject.containerTypeID);
dbCommand.SetParamValue((long)QueryValues.installedItemCopy, m_DataObject.installedItemCopy);
dbCommand.SetParamValue((long)QueryValues.completed, m_DataObject.completed);
dbCommand.SetParamValue((long)QueryValues.completedSuccessfully, m_DataObject.completedSuccessfully);
dbCommand.SetParamValue((long)QueryValues.installedItemFlag, m_DataObject.installedItemFlag);
dbCommand.SetParamValue((long)QueryValues.outputFlag, m_DataObject.outputFlag);
dbCommand.SetParamValue((long)QueryValues.activityID, m_DataObject.activityID);
dbCommand.SetParamValue((long)QueryValues.completedStatus, m_DataObject.completedStatus);
dbCommand.SetParamValue((long)QueryValues.beginProductionTime, m_DataObject.beginProductionTime);
dbCommand.SetParamValue((long)QueryValues.endProductionTime, m_DataObject.endProductionTime);
dbCommand.SetParamValue((long)QueryValues.pauseProductionTime, m_DataObject.pauseProductionTime);
}
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"UPDATE {0} SET {1}=?, {2}=?, {3}=?, {4}=?, {5}=? " +
"WHERE {6}=?;",
TableName,
// data
GetFieldName(QueryValues.CorpID),
GetFieldName(QueryValues.standingType),
GetFieldName(QueryValues.ID),
GetFieldName(QueryValues.Name),
GetFieldName(QueryValues.standing),
// key
GetFieldName((long)QueryValues.Key_ID)));
// data
dbCommand.AddParameter((long)QueryValues.CorpID);
dbCommand.AddParameter((long)QueryValues.standingType);
dbCommand.AddParameter((long)QueryValues.ID);
dbCommand.AddParameter((long)QueryValues.Name);
dbCommand.AddParameter((long)QueryValues.standing);
// key
dbCommand.AddParameter((long)QueryValues.Key_ID);
}
void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
{
throw new NotImplementedException();
}
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
throw new NotImplementedException();
}
void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
{
// Key
dbCommand.SetParamValue((long)QueryValues.UserID, m_DataObject.UserID);
dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.CharID);
}
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
{
dbCommand.SetCommand(String.Format(
"UPDATE {0} SET " +
" {5}=?, {6}=?, {7}=?, {8}=?, {9}=?, {10}=?, " +
"{11}=?, {12}=?, {13}=?, {14}=?, {15}=?, {16}=?, " +
"{17}=?, {18}=?, {19}=?, {20}=?, {21}=?, {22}=?, " +
"{23}=?, {24}=?, {25}=?, {26}=?, {27}=?, {28}=?, " +
"{29}=?, {30}=?, {31}=?, {32}=?, {33}=?, {34}=? " +
"WHERE {1}=? AND {2}=? AND {3}=? AND {4}=?;",
TableName,
// key
GetFieldName(QueryValues.CharID),
GetFieldName(QueryValues.jobID),
GetFieldName(QueryValues.installerID),
GetFieldName(QueryValues.installTime),
// data
GetFieldName(QueryValues.assemblyLineID),
GetFieldName(QueryValues.containerID),
GetFieldName(QueryValues.installedItemID),
GetFieldName(QueryValues.installedItemLocationID),
GetFieldName(QueryValues.installedItemQuantity),
GetFieldName(QueryValues.installedItemProductivityLevel),
GetFieldName(QueryValues.installedItemMaterialLevel),
GetFieldName(QueryValues.installedItemLicensedProductionRunsRemaining),
GetFieldName(QueryValues.outputLocationID),
GetFieldName(QueryValues.runs),
GetFieldName(QueryValues.licensedProductionRuns),
GetFieldName(QueryValues.installedInSolarSystemID),
GetFieldName(QueryValues.containerLocationID),
GetFieldName(QueryValues.materialMultiplier),
GetFieldName(QueryValues.charMaterialMultiplier),
GetFieldName(QueryValues.timeMultiplier),
GetFieldName(QueryValues.charTimeMultiplier),
GetFieldName(QueryValues.installedItemTypeID),
GetFieldName(QueryValues.outputTypeID),
GetFieldName(QueryValues.containerTypeID),
GetFieldName(QueryValues.installedItemCopy),
GetFieldName(QueryValues.completed),
GetFieldName(QueryValues.completedSuccessfully),
GetFieldName(QueryValues.installedItemFlag),
GetFieldName(QueryValues.outputFlag),
GetFieldName(QueryValues.activityID),
GetFieldName(QueryValues.completedStatus),
GetFieldName(QueryValues.beginProductionTime),
GetFieldName(QueryValues.endProductionTime),
GetFieldName(QueryValues.pauseProductionTime)));
// data
dbCommand.AddParameter((long)QueryValues.assemblyLineID);
dbCommand.AddParameter((long)QueryValues.containerID);
dbCommand.AddParameter((long)QueryValues.installedItemID);
dbCommand.AddParameter((long)QueryValues.installedItemLocationID);
dbCommand.AddParameter((long)QueryValues.installedItemQuantity);
dbCommand.AddParameter((long)QueryValues.installedItemProductivityLevel);
dbCommand.AddParameter((long)QueryValues.installedItemMaterialLevel);
dbCommand.AddParameter((long)QueryValues.installedItemLicensedProductionRunsRemaining);
dbCommand.AddParameter((long)QueryValues.outputLocationID);
dbCommand.AddParameter((long)QueryValues.runs);
dbCommand.AddParameter((long)QueryValues.licensedProductionRuns);
dbCommand.AddParameter((long)QueryValues.installedInSolarSystemID);
dbCommand.AddParameter((long)QueryValues.containerLocationID);
dbCommand.AddParameter((long)QueryValues.materialMultiplier);
dbCommand.AddParameter((long)QueryValues.charMaterialMultiplier);
dbCommand.AddParameter((long)QueryValues.timeMultiplier);
dbCommand.AddParameter((long)QueryValues.charTimeMultiplier);
dbCommand.AddParameter((long)QueryValues.installedItemTypeID);
dbCommand.AddParameter((long)QueryValues.outputTypeID);
dbCommand.AddParameter((long)QueryValues.containerTypeID);
dbCommand.AddParameter((long)QueryValues.installedItemCopy);
dbCommand.AddParameter((long)QueryValues.completed);
dbCommand.AddParameter((long)QueryValues.completedSuccessfully);
dbCommand.AddParameter((long)QueryValues.installedItemFlag);
dbCommand.AddParameter((long)QueryValues.outputFlag);
dbCommand.AddParameter((long)QueryValues.activityID);
dbCommand.AddParameter((long)QueryValues.completedStatus);
dbCommand.AddParameter((long)QueryValues.beginProductionTime);
dbCommand.AddParameter((long)QueryValues.endProductionTime);
dbCommand.AddParameter((long)QueryValues.pauseProductionTime);
// key
dbCommand.AddParameter((long)QueryValues.CharID);
dbCommand.AddParameter((long)QueryValues.jobID);
dbCommand.AddParameter((long)QueryValues.installerID);
dbCommand.AddParameter((long)QueryValues.installTime);
}
void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
{
IDBRecord iobj = this as IDBRecord;
dbCommand.SetParamValue((long)QueryValues.Key_ID, m_DataObject.Key_ID);
}
