//------------------------------------------- private List<DDDClass.FullCardNumber> GetCardFullNumber(int dataBlockId, string paramName) { DDDClass.FullCardNumber fullCardNumber = new DDDClass.FullCardNumber(); List<DDDClass.FullCardNumber> fullCardNumberList = new List<DDDClass.FullCardNumber>(); SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION()); string currentParamName; List<string> cardIssuingMemberState = new List<string>(); List<string> cardType = new List<string>(); 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 + ".cardIssuingMemberState"; cardIssuingMemberState = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardType"; cardType = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardNumber.cardConsecutiveIndex"; cardConsecutiveIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardNumber.cardRenewalIndex"; cardRenewalIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardNumber.cardReplacementIndex"; cardReplacementIndex = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardNumber.driverIdentification"; driverIdentification = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); currentParamName = paramName + ".cardNumber.ownerIdentification"; ownerIdentification = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName); if (cardRenewalIndex.Count == ownerIdentification.Count && cardType.Count == cardIssuingMemberState.Count) { for (int i = 0; i < cardRenewalIndex.Count; i++) { fullCardNumber = new DDDClass.FullCardNumber(); fullCardNumber.cardIssuingMemberState = new DDDClass.NationNumeric(Convert.ToInt16(cardIssuingMemberState[i])); fullCardNumber.cardType = new DDDClass.EquipmentType(Convert.ToByte(cardType[i])); fullCardNumber.cardNumber.cardConsecutiveIndex = new DDDClass.CardConsecutiveIndex(cardConsecutiveIndex[i]); fullCardNumber.cardNumber.cardRenewalIndex = new DDDClass.CardRenewalIndex(cardRenewalIndex[i]); fullCardNumber.cardNumber.cardReplacementIndex = new DDDClass.CardReplacementIndex(cardReplacementIndex[i]); fullCardNumber.cardNumber.driverIdentification = driverIdentification[i]; fullCardNumber.cardNumber.ownerIdentification = ownerIdentification[i]; fullCardNumberList.Add(fullCardNumber); } } return fullCardNumberList; }
public DDDClass.VuDownloadActivityData Get_VehicleOverview_VuDownloadActivityData(int dataBlockId) { SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION()); string paramName; DDDClass.VuDownloadActivityData vuDownloadActivityData = new DDDClass.VuDownloadActivityData(); paramName = "vehicleOverview.vuDownloadActivityData.companyOrWorkshopName.name"; string companyOrWorkshopName = sqldbRecords.Get_ParamValue(dataBlockId, paramName); paramName = "vehicleOverview.vuDownloadActivityData.downloadingTime"; string downloadingTime = sqldbRecords.Get_ParamValue(dataBlockId, paramName); DDDClass.FullCardNumber cardNumber = new DDDClass.FullCardNumber(); cardNumber = GetCardFullNumber(dataBlockId, "vehicleOverview.vuDownloadActivityData.fullCardNumber")[0]; System.Text.UTF8Encoding enc = new System.Text.UTF8Encoding(); byte[] _bytes = enc.GetBytes(companyOrWorkshopName); vuDownloadActivityData.companyOrWorkshopName.name = _bytes; vuDownloadActivityData.downloadingTime = new DDDClass.TimeReal(Convert.ToUInt32(downloadingTime)); vuDownloadActivityData.fullCardNumber = cardNumber; return vuDownloadActivityData; }