//-------------------------------------------
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;
}
