public DDDClass.CardIdentification Get_EF_Identification_CardIdentification(int dataBlockId) { SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION()); string paramName = "ef_identification.cardIdentification"; string currentParamName; DDDClass.CardIdentification cardIdentification = new DDDClass.CardIdentification(); string cardExpiryDate; string cardIssueDate; string cardIssuingAuthorityName; string cardIssuingMemberState; string cardValidityBegin; DDDClass.CardNumber cardNumber = new DDDClass.CardNumber(); currentParamName = paramName + ".cardExpiryDate"; cardExpiryDate = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName); currentParamName = paramName + ".cardIssueDate"; cardIssueDate = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName); currentParamName = paramName + ".cardIssuingAuthorityName.name"; cardIssuingAuthorityName = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName); currentParamName = paramName + ".cardIssuingMemberState"; cardIssuingMemberState = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName); currentParamName = paramName + ".cardValidityBegin"; cardValidityBegin = sqldbRecords.Get_ParamValue(dataBlockId, currentParamName); currentParamName = paramName + ".cardNumber"; cardNumber = GetCardNumber(dataBlockId, currentParamName)[0];//Зайти внутрь попалить cardIdentification.cardExpiryDate = new DDDClass.TimeReal(Convert.ToInt64(cardExpiryDate)); cardIdentification.cardIssueDate = new DDDClass.TimeReal(Convert.ToInt64(cardIssueDate)); cardIdentification.cardIssuingAuthorityName.setName(cardIssuingAuthorityName); cardIdentification.cardIssuingMemberState = new DDDClass.NationNumeric(Convert.ToByte(cardIssuingMemberState)); cardIdentification.cardValidityBegin = new DDDClass.TimeReal(cardValidityBegin); cardIdentification.cardNumber = cardNumber; return cardIdentification; }
private List<DDDClass.CardNumber> GetCardNumber(int dataBlockId, string paramName) { SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION()); string currentParamName; List<DDDClass.CardNumber> cardNumberList = new List<DDDClass.CardNumber>(); DDDClass.CardNumber cardNumber = new DDDClass.CardNumber(); List<string> cardConsecutiveIndex = new List<string>(); List<string> cardRenewalIndex = new List<string>(); List<string> cardReplacementIndex = new List<string>(); List<string> driverIdentification = new List<string>(); List<string> ownerIdentification = new List<string>(); currentParamName = paramName + ".cardConsecutiveIndex"; cardConsecutiveIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardRenewalIndex"; cardRenewalIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardReplacementIndex"; cardReplacementIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".driverIdentification"; driverIdentification = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".ownerIdentification"; ownerIdentification = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); if (cardRenewalIndex.Count == ownerIdentification.Count && driverIdentification.Count == cardConsecutiveIndex.Count) { for (int i = 0; i < cardRenewalIndex.Count; i++) { cardNumber = new DDDClass.CardNumber(); cardNumber.cardConsecutiveIndex = new DDDClass.CardConsecutiveIndex(cardConsecutiveIndex[i]); cardNumber.cardRenewalIndex = new DDDClass.CardRenewalIndex(cardRenewalIndex[i]); cardNumber.cardReplacementIndex = new DDDClass.CardReplacementIndex(cardReplacementIndex[i]); cardNumber.driverIdentification = driverIdentification[i]; cardNumber.ownerIdentification = ownerIdentification[i]; cardNumberList.Add(cardNumber); } } return cardNumberList; }