예제 #1
0
        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);
        }
예제 #2
0
        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);
        }
예제 #3
0
 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);
 }
예제 #4
0
 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);
 }
예제 #5
0
 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);
 }
예제 #6
0
 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);
 }
예제 #7
0
 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);
 }
예제 #8
0
 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);
 }
예제 #9
0
        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);
        }
예제 #10
0
 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);
 }
예제 #11
0
        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)));
        }
예제 #12
0
 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);
 }
예제 #13
0
        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);
        }
예제 #14
0
            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);
            }
예제 #15
0
            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);
            }
예제 #16
0
        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);
        }
예제 #17
0
        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);
        }
예제 #18
0
        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);
        }
예제 #19
0
        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);
        }
예제 #20
0
 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);
 }
예제 #21
0
        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);
        }
예제 #22
0
            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);
            }
예제 #23
0
 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);
 }
예제 #24
0
        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);
        }
예제 #25
0
 void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
 {
     throw new NotImplementedException();
 }
예제 #26
0
 void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand)
 {
     throw new NotImplementedException();
 }
예제 #27
0
 void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
 {
     // Key
     dbCommand.SetParamValue((long)QueryValues.UserID, m_DataObject.UserID);
     dbCommand.SetParamValue((long)QueryValues.CharID, m_DataObject.CharID);
 }
예제 #28
0
            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);
            }
예제 #29
0
        void IDBRecord.FillCommandDelete(Database.DatabaseCommand dbCommand)
        {
            IDBRecord iobj = this as IDBRecord;

            dbCommand.SetParamValue((long)QueryValues.Key_ID, m_DataObject.Key_ID);
        }