示例#1
0
 /// <summary>Loads a Equity record using Metadata Parameters.</summary>
 /// <param name="transaction">Contains the parameters and exceptions for this command.</param>
 public new static void Load(ParameterList parameters)
 {
     // Accessor for the Equity Table.
     ServerDataModel.EquityDataTable equityTable = ServerDataModel.Equity;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     object description = parameters["description"].Value;
     object groupPermission = parameters["groupPermission"].Value;
     object hidden = parameters["hidden"].Value;
     string name = parameters["name"];
     object owner = parameters["owner"].Value;
     object ownerPermission = parameters["ownerPermission"].Value;
     object readOnly = parameters["readOnly"].Value;
     object worldPermission = parameters["worldPermission"].Value;
     string externalCountryId = parameters["countryId"];
     object externalTypeCode = parameters["typeCode"].Value;
     object symbol = parameters["symbol"].Value;
     string externalEquityId = parameters["equityId"];
     object issuerId = parameters["issuerId"].Value;
     object externalExchangeId = parameters["exchangeId"].Value;
     string externalSettlementId = parameters["settlementId"];
     object externalSecurityTypeCode = parameters["securityTypeCode"].Value;
     string externalEquityTypeCode = parameters["equityTypeCode"];
     object priceFactor = parameters["priceFactor"].Value;
     object quantityFactor = parameters["quantityFactor"].Value;
     object sharesOutstanding = parameters["sharesOutstanding"].Value;
     // The row versioning is largely disabled for external operations.  The value is returned to the caller in the
     // event it's needed for operations within the batch.
     long rowVersion = long.MinValue;
     // Resolve External Identifiers
     int countryId = Country.FindRequiredKey(configurationId, "countryId", externalCountryId);
     object typeCode = Type.FindOptionalKey(configurationId, "typeCode", externalTypeCode);
     int equityId = Security.FindKey(configurationId, "equityId", externalEquityId);
     object exchangeId = Exchange.FindOptionalKey(configurationId, "exchangeId", externalExchangeId);
     int settlementId = Security.FindRequiredKey(configurationId, "settlementId", externalSettlementId);
     object securityTypeCode = SecurityType.FindOptionalKey(configurationId, "securityTypeCode", externalSecurityTypeCode);
     int equityTypeCode = EquityType.FindRequiredKey(configurationId, "equityTypeCode", externalEquityTypeCode);
     ServerDataModel.EquityRow equityRow = equityTable.FindByEquityId(equityId);
     // The load operation will create a record if it doesn't exist, or update an existing record.  The external
     // identifier is used to determine if a record exists with the same key.
     if ((equityRow == null))
     {
         // Populate the 'externalId' varaibles so that the external identifier can be used to find the row when an
         // external method is called with the same 'configurationId' parameter.
         int externalKeyIndex = Equity.GetExternalKeyIndex(configurationId, "equityId");
         object[] externalIdArray = new object[8];
         externalIdArray[externalKeyIndex] = externalEquityId;
         object externalId0 = externalIdArray[0];
         object externalId1 = externalIdArray[1];
         object externalId2 = externalIdArray[2];
         object externalId3 = externalIdArray[3];
         object externalId4 = externalIdArray[4];
         object externalId5 = externalIdArray[5];
         object externalId6 = externalIdArray[6];
         object externalId7 = externalIdArray[7];
         // Call the internal method to complete the operation.
         MarkThree.Quasar.Core.Equity.Insert(adoTransaction, sqlTransaction, ref rowVersion, description, externalId0, externalId1, externalId2, externalId3, externalId4, externalId5, externalId6, externalId7, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, countryId, typeCode, symbol, issuerId, exchangeId, settlementId, securityTypeCode, equityTypeCode, priceFactor, quantityFactor, sharesOutstanding);
     }
     else
     {
         // While the optimistic concurrency checking is disabled for the external methods, the internal methods
         // still need to perform the check.  This ncurrency checking logic by finding the current row version to be
         // will bypass the coused when the internal method is called.
         rowVersion = ((long)(equityRow[equityTable.RowVersionColumn]));
         // Call the internal method to complete the operation.
         MarkThree.Quasar.Core.Equity.Update(adoTransaction, sqlTransaction, ref rowVersion, description, null, null, null, null, null, null, null, null, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, countryId, typeCode, symbol, equityId, issuerId, exchangeId, settlementId, securityTypeCode, equityTypeCode, priceFactor, quantityFactor, sharesOutstanding);
     }
     // Return values.
     parameters["rowVersion"] = rowVersion;
 }