private static List <EcuFunctionStructs.EcuFaultCode> GetFaultCodes(SQLiteConnection mDbConnection, string variantId)
{
List <EcuFunctionStructs.EcuFaultCode> ecuFaultCodeList = new List <EcuFunctionStructs.EcuFaultCode>();
string sql = string.Format(@"SELECT ID, CODE FROM XEP_FAULTCODES WHERE ECUVARIANTID = {0}", variantId);
using (SQLiteCommand command = new SQLiteCommand(sql, mDbConnection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
EcuFunctionStructs.EcuFaultCode ecuFaultCode = new EcuFunctionStructs.EcuFaultCode(
reader["ID"].ToString(),
reader["CODE"].ToString());
ecuFaultCodeList.Add(ecuFaultCode);
List <EcuFunctionStructs.EcuFaultCodeLabel> ecuFaultCodeLabelList = GetFaultCodeLabels(mDbConnection, ecuFaultCode);
List <string> ecuFaultLabelIdList = new List <string>();
foreach (EcuFunctionStructs.EcuFaultCodeLabel ecuFaultCodeLabel in ecuFaultCodeLabelList)
{
ecuFaultLabelIdList.Add(ecuFaultCodeLabel.Id);
}
ecuFaultCode.EcuFaultCodeLabelIdList = ecuFaultLabelIdList;
ecuFaultCode.EcuFaultCodeLabelList = ecuFaultCodeLabelList;
}
}
}
return(ecuFaultCodeList);
}
private static List <EcuFunctionStructs.EcuFaultCodeLabel> GetFaultCodeLabels(SQLiteConnection mDbConnection, EcuFunctionStructs.EcuFaultCode ecuFaultCode)
{
List <EcuFunctionStructs.EcuFaultCodeLabel> ecuFaultCodeLabelList = new List <EcuFunctionStructs.EcuFaultCodeLabel>();
string sql = string.Format(@"SELECT LABELS.ID LABELID, CODE, SAECODE, " + SqlTitleItems + ", RELEVANCE, DATATYPE " +
"FROM XEP_FAULTLABELS LABELS, XEP_REFFAULTLABELS REFLABELS WHERE CODE = {0} AND LABELS.ID = REFLABELS.LABELID AND REFLABELS.ID = {1}",
ecuFaultCode.Code, ecuFaultCode.Id);
using (SQLiteCommand command = new SQLiteCommand(sql, mDbConnection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ecuFaultCodeLabelList.Add(new EcuFunctionStructs.EcuFaultCodeLabel(reader["LABELID"].ToString(),
reader["CODE"].ToString(),
reader["SAECODE"].ToString(),
GetTranslation(reader),
reader["RELEVANCE"].ToString(),
reader["DATATYPE"].ToString()));
}
}
}
return(ecuFaultCodeLabelList);
}
