private void AddWareGroups()
{
DataTable MyTable = DBase.GetWareGroups();
foreach (DataRow MyRow in MyTable.Rows)
{
string ItemDescription = MyRow.Field<string>(1);
string ItemKey = MyRow.Field<string>(2);
MyItem NewItem = new MyItem();
NewItem.Header = ItemKey + " - " + ItemDescription;
if (ItemKey.Length == 1)
{
this.Items.Add(NewItem);
}
else if (ItemKey.Length == 2 || ItemKey.Length == 5 || ItemKey.Length == 6)
{
IterateSubItems(1, NewItem, ItemKey, this.Items);
}
else // if (ItemKey.Length == 4 || ItemKey.Length == 8)
{
IterateSubItems(2, NewItem, ItemKey, this.Items);
}
}
}
/// <summary>
/// ARCHIVO LL
/// </summary>
/// <param name="Str_Turno_block"></param>
/// <param name="FechaInicio"></param>
/// <param name="IdPlazaCobro"></param>
/// <param name="CabeceraTag"></param>
/// <param name="Tramo"></param>
/// <returns></returns>
public void Registro_usuarios_telepeaje(string Str_Turno_block, DateTime FechaInicio, string IdPlazaCobro, string CabeceraTag, string Tramo, string Conexion)
{
string StrQuerys;
string Cabecera;
string Nombre_archivo = string.Empty;
int Int_turno = 0;
string H_inicio_turno = string.Empty;
string H_fin_turno = string.Empty;
string No_registros = string.Empty;
string Str_detalle = string.Empty;
double Dbl_registros;
string StrClaseExcedente;
string Tag_iag;
string LenText;
int KeyAscii;
bool Validar = false;
List <string> Val = new List <string>();
DataTable dataTableCa = new DataTable();
EnumerableRowCollection <DataRow> dataRows;
var IdCarril = string.Empty;
var NumCarril = string.Empty;
var NumPlaza = string.Empty;
var NumTramo = string.Empty;
OracleConnection ConexionDim = new OracleConnection(Conexion);
MetodosGlbRepository MtGlb = new MetodosGlbRepository();
try
{
if (Str_Turno_block.Substring(0, 2) == "06")
{
Int_turno = 5;
H_inicio_turno = FechaInicio.ToString("MM/dd/yyyy") + " 06:00:00";
H_fin_turno = FechaInicio.ToString("MM/dd/yyyy") + " 13:59:59";
}
else if (Str_Turno_block.Substring(0, 2) == "14")
{
Int_turno = 6;
H_inicio_turno = FechaInicio.ToString("MM/dd/yyyy") + " 14:00:00";
H_fin_turno = FechaInicio.ToString("MM/dd/yyyy") + " 21:59:59";
}
else if (Str_Turno_block.Substring(0, 2) == "22")
{
Int_turno = 4;
H_inicio_turno = FechaInicio.AddDays(-1).ToString("MM/dd/yyyy") + " 22:00:00";
H_fin_turno = FechaInicio.ToString("MM/dd/yyyy") + " 05:59:59";
}
if (IdPlazaCobro.Length == 3)
{
if (IdPlazaCobro == "108")
{
Nombre_archivo = "0001";
}
else if (IdPlazaCobro == "109")
{
Nombre_archivo = "001B";
}
else if (IdPlazaCobro == "107")
{
Nombre_archivo = "0107";
}
else if (IdPlazaCobro == "061")
{
Nombre_archivo = "061B";
}
else if (IdPlazaCobro == "086" || IdPlazaCobro == "083" || IdPlazaCobro == "027")
{
Nombre_archivo = "01" + IdPlazaCobro.Substring(1, 2);
}
else
{
Nombre_archivo = "0" + IdPlazaCobro;
}
}
Nombre_archivo = Nombre_archivo + FechaInicio.ToString("MM") + FechaInicio.ToString("dd") + "." + Int_turno + "II";
System.IO.StreamWriter Osw = new System.IO.StreamWriter(Carpeta + Nombre_archivo);
System.IO.StreamWriter Osw2 = new System.IO.StreamWriter(Carpeta2 + Nombre_archivo);
Archivo_5 = Nombre_archivo;
Cabecera = CabeceraTag;
if (IdPlazaCobro.Length == 3)
{
if (IdPlazaCobro == "108")
{
Cabecera = Cabecera + "0001";
}
else if (IdPlazaCobro == "109")
{
Cabecera = Cabecera + "001B";
}
else if (IdPlazaCobro == "107")
{
Cabecera = Cabecera + "0107";
}
else if (IdPlazaCobro == "061")
{
Cabecera = Cabecera + "061B";
}
else if (IdPlazaCobro == "086" || IdPlazaCobro == "083" || IdPlazaCobro == "027")
{
Cabecera = Cabecera + "01" + IdPlazaCobro.Substring(1, 2);
}
else
{
Cabecera = Cabecera + "0" + IdPlazaCobro;
}
}
Cabecera = Cabecera + FechaInicio.ToString("MM") + FechaInicio.ToString("dd") + "." + Int_turno + "II" + FechaInicio.ToString("dd/MM/yyyy") + Int_turno;
//CABECERA INICIO REGISTROS
//CABECERA FIN
//inicio detalle
DateTime _H_inicio_turno = DateTime.ParseExact(H_inicio_turno, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
DateTime _H_fin_turno = DateTime.ParseExact(H_fin_turno, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
/*****************************************************************************/
MtGlb.ConnectionOpen(ConexionDim);
/*****************************************************************************/
StrQuerys = "SELECT DATE_TRANSACTION, VOIE, EVENT_NUMBER, FOLIO_ECT, Version_Tarif, ID_PAIEMENT, " +
"TAB_ID_CLASSE, TYPE_CLASSE.LIBELLE_COURT1 AS CLASE_MARCADA, NVL(TRANSACTION.Prix_Total,0) as MONTO_MARCADO, " +
"ACD_CLASS, TYPE_CLASSE_ETC.LIBELLE_COURT1 AS CLASE_DETECTADA, NVL(TRANSACTION.transaction_CPT1 / 100, 0) as MONTO_DETECTADO, CONTENU_ISO, CODE_GRILLE_TARIF, ID_OBS_MP, ID_OBS_TT, ISSUER_ID " +
"FROM TRANSACTION " +
"JOIN TYPE_CLASSE ON TAB_ID_CLASSE = TYPE_CLASSE.ID_CLASSE " +
"LEFT JOIN TYPE_CLASSE TYPE_CLASSE_ETC ON ACD_CLASS = TYPE_CLASSE_ETC.ID_CLASSE " +
"WHERE " +
"(DATE_DEBUT_POSTE >= TO_DATE('" + _H_inicio_turno.ToString("yyyyMMddHHmmss") + "','YYYYMMDDHH24MISS')) AND (DATE_DEBUT_POSTE <= TO_DATE('" + _H_fin_turno.ToString("yyyyMMddHHmmss") + "','YYYYMMDDHH24MISS')) " +
" AND (ID_PAIEMENT = 15 or ID_OBS_MP = 30) " +
"AND (TRANSACTION.Id_Voie = '1' " +
"OR TRANSACTION.Id_Voie = '2' " +
"OR TRANSACTION.Id_Voie = '3' " +
"OR TRANSACTION.Id_Voie = '4' " +
"OR TRANSACTION.Id_Voie = 'X') AND (MODE_REGLEMENT = 'IAV ') " +
"ORDER BY DATE_TRANSACTION";
if (MtGlb.QueryDataSet(StrQuerys, "TRANSACTION", ConexionDim))
{
Dbl_registros = 0;
/***********************************************************************/
//Connection.Open();
//string Query = @"SELECT t.idTramo, t.nomTramo, p.idPlaza, p.nomPlaza, c.idCarril, c.numCarril, c.numTramo
// FROM TYPE_PLAZA p
// INNER JOIN TYPE_TRAMO t ON t.idenTramo = p.idTramo
// INNER JOIN TYPE_CARRIL c ON c.idPlaza = p.idenPlaza
// WHERE t.idTramo = @tramo and p.idPlaza = @plaza";
//string Query = @"SELECT d.ID_Delegacion, d.Nom_Delegacion, p.ID_Plaza, p.Nom_Plaza, c.Num_Gea, c.num_Capufe, c.Num_Tramo " +
// "FROM TYPE_PLAZA p " +
// "INNER JOIN TYPE_TRAMO d on d.ID_Delegacion = d.ID_Delegacion " +
// "INNER JOIN TYPE_CARRIL c on c.ID_Plaza = p.ID_Plaza " +
// "WHERE d.ID_Delegacion = @tramo and p.ID_Plaza = @plaza";
//using (SqlCommand Cmd = new SqlCommand(Query, Connection))
//{
// Cmd.Parameters.Add(new SqlParameter("tramo", Tramo));
// Cmd.Parameters.Add(new SqlParameter("plaza", IdPlazaCobro));
// //Cmd.Parameters.Add(new SqlParameter("plaza", IdPlazaCobro.Substring(1, 2)));
// //Cmd.Parameters.Add(new SqlParameter("carril", MtGlb.oDataRow["Voie"].ToString().Substring(1, 2)));
// try
// {
// SqlDataAdapter Da = new SqlDataAdapter(Cmd);
// Da.Fill(dataTableCa);
// }
// catch (Exception ex)
// {
// Message = ex.Message + " " + ex.StackTrace;
// }
// finally
// {
// Cmd.Dispose();
// Connection.Close();
// }
//}
var props = typeof(Type_Carril).GetProperties();
DataTable dt = new DataTable("Type_Carril");
var idpla = IdPlazaCobro.Substring(1, 2);
var Carriles_Tramos = db.Type_Plaza.GroupJoin(db.Type_Carril, pla => pla.Id_Plaza, car => car.Plaza_Id, (pla, car) => new { pla, car }).Where(x => x.pla.Num_Plaza == idpla).ToList();
dt.Columns.AddRange(
props.Select(p => new DataColumn(p.Name, p.PropertyType)).ToArray()
);
Carriles_Tramos.FirstOrDefault().car.ToList().ForEach(
i => dt.Rows.Add(props.Select(p => p.GetValue(i, null)).ToArray())
);
///***********************************************************************/
foreach (DataRow item in MtGlb.Ds.Tables["TRANSACTION"].Rows)
{
if (item["ID_OBS_MP"].ToString() == "00" || item["ID_OBS_MP"].ToString() == "30")
{
Str_detalle = string.Empty;
Str_detalle = Convert.ToDateTime(item["DATE_TRANSACTION"]).ToString("dd/MM/yyyy") + ",";
/****************/
dataRows = from MyRow in dt.AsEnumerable()
// where MyRow.Field<string>("idCarril") == item["Voie"].ToString().Substring(1, 2)
where MyRow.Field <string>("Num_Gea") == item["Voie"].ToString().Substring(1, 2)
select MyRow;
foreach (DataRow value in dataRows)
{
//NumCarril = value["numCarril"].ToString();
//NumTramo = value["numTramo"].ToString();
//NumPlaza = value["idPlaza"].ToString();
NumCarril = value["Num_Capufe"].ToString();
NumTramo = value["Num_Tramo"].ToString();
NumPlaza = value.Field <Type_Plaza>("Type_Plaza").Num_Plaza.ToString();
}
/****************/
if (dataRows.Count() != 0)
{
Str_detalle = Str_detalle + NumTramo + ",";
Str_detalle = Str_detalle + NumCarril + ",";
}
else
{
Str_detalle = Str_detalle + ",,";
}
//Cuerpo Caracter X(1)
Str_detalle = Str_detalle + item["Voie"].ToString().Substring(0, 1) + ",";
//Hora de evento Caracter hhmmss
Str_detalle = Str_detalle + Convert.ToDateTime(item["DATE_TRANSACTION"]).ToString("HHmmss") + ",";
//numero tarjeta iave
Validar = true;
Tag_iag = MtGlb.IIf(item["CONTENU_ISO"].ToString().Trim() == "FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF", "", item["CONTENU_ISO"].ToString().TrimStart());
if (Tag_iag.Length != 8) //Tag 00000000
{
Tag_iag = Tag_iag.Substring(0, 14).Trim();
}
if (Tag_iag.Length == 13 && Tag_iag.Substring(0, 3) == "009")
{
Tag_iag = Tag_iag.Substring(0, 3) + Tag_iag.Substring(5, 8);
}
LenText = Tag_iag.Length.ToString();
for (int c = 0; c < Convert.ToInt32(LenText); c++)
{
KeyAscii = (int)Convert.ToChar(Tag_iag.Substring(c, 1));
if ((KeyAscii >= 33) && (KeyAscii <= 47) || (KeyAscii >= 58) && (KeyAscii <= 64) || (KeyAscii >= 91) && (KeyAscii <= 96) || (KeyAscii >= 123) && (KeyAscii <= 126))
{
Validar = false;
KeyAscii = 8;
}
}
Str_detalle = Str_detalle + Tag_iag.Trim() + ",";
//situacion tarjeta iave
if (Convert.ToInt32(item["ID_PAIEMENT"]) == 15)
{
Str_detalle = Str_detalle + "V" + ",";
}
else
{
Str_detalle = Str_detalle + "I" + ",";
}
//clave transportsta iave
Str_detalle = Str_detalle + ",";
//clase vehiculo iave
Str_detalle = Str_detalle + ",";
//importe usuario iave
Str_detalle = Str_detalle + item["MONTO_DETECTADO"] + ",";
//numero de evento ect
Str_detalle = Str_detalle + item["EVENT_NUMBER"] + ",";
//Número de turno Entero 9
Str_detalle = Str_detalle + Int_turno + ",";
//numero de ejes segun ect
if (!DBNull.Value.Equals(item["CLASE_DETECTADA"]))
{
StrClaseExcedente = string.Empty;
if (item["CLASE_DETECTADA"].ToString() == "T01A")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "L";
}
else if (item["CLASE_DETECTADA"].ToString() == "T01M")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "L";
}
else if (item["CLASE_DETECTADA"].ToString() == "T01T")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "L";
}
else if (item["CLASE_DETECTADA"].ToString() == "T02B")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T03B")
{
Str_detalle = Str_detalle + "3" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T04B")
{
Str_detalle = Str_detalle + "4" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T02C")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T03C")
{
Str_detalle = Str_detalle + "3" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T04C")
{
Str_detalle = Str_detalle + "4" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T05C")
{
Str_detalle = Str_detalle + "5" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T06C")
{
Str_detalle = Str_detalle + "6" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T07C")
{
Str_detalle = Str_detalle + "7" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T08C")
{
Str_detalle = Str_detalle + "8" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "T09C")
{
Str_detalle = Str_detalle + "9" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "TL01A")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "TL02A")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (item["CLASE_DETECTADA"].ToString() == "TLnnA")
{
Str_detalle = Str_detalle + item["ID_OBS_TT"] + ",";
Str_detalle = Str_detalle + "L";
}
else if (item["CLASE_DETECTADA"].ToString() == "T01P")
{
Str_detalle = Str_detalle + "1" + ",";
Str_detalle = Str_detalle + "L";
}
else if (item["CLASE_DETECTADA"].ToString() == "TP01C")
{
Str_detalle = Str_detalle + "9" + ",";
Str_detalle = Str_detalle + "L";
}
else if (item["CLASE_DETECTADA"].ToString() == "TPnnC")
{
Str_detalle = Str_detalle + item["ID_OBS_TT"] + ",";
Str_detalle = Str_detalle + "P";
}
else
{
Str_detalle = Str_detalle + "No detectada" + ",0,";
}
}
else
{
Str_detalle = Str_detalle + "0,";
}
}
/****************************************************************/
else
{
//inicio clase detectada
StrQuerys = "SELECT DATE_TRANSACTION, VOIE, EVENT_NUMBER, FOLIO_ECT, Version_Tarif, ID_PAIEMENT, " +
"TAB_ID_CLASSE, TYPE_CLASSE.LIBELLE_COURT1 AS CLASE_MARCADA, NVL(TRANSACTION.Prix_Total,0) as MONTO_MARCADO, " +
"ACD_CLASS, TYPE_CLASSE_ETC.LIBELLE_COURT1 AS CLASE_DETECTADA, NVL(TRANSACTION.transaction_CPT1 / 100, 0) as MONTO_DETECTADO, CONTENU_ISO, CODE_GRILLE_TARIF, ID_OBS_MP, ID_OBS_TT, ISSUER_ID " +
"FROM TRANSACTION " +
"JOIN TYPE_CLASSE ON TAB_ID_CLASSE = TYPE_CLASSE.ID_CLASSE " +
"LEFT JOIN TYPE_CLASSE TYPE_CLASSE_ETC ON ACD_CLASS = TYPE_CLASSE_ETC.ID_CLASSE " +
"WHERE " +
"(DATE_DEBUT_POSTE >= TO_DATE('" + _H_inicio_turno.ToString("yyyyMMddHHmmss") + "','YYYYMMDDHH24MISS')) AND (DATE_DEBUT_POSTE <= TO_DATE('" + _H_fin_turno.ToString("yyyyMMddHHmmss") + "','YYYYMMDDHH24MISS')) " +
"AND VOIE = '" + item["VOIE"] + "' " +
"AND ID_OBS_SEQUENCE <> '7777' " +
"AND EVENT_NUMBER = " + item["EVENT_NUMBER"] + " " +
"AND (TRANSACTION.Id_Voie = '1' " +
"OR TRANSACTION.Id_Voie = '2' " +
"OR TRANSACTION.Id_Voie = '3' " +
"OR TRANSACTION.Id_Voie = '4' " +
"OR TRANSACTION.Id_Voie = 'X') " +
"ORDER BY DATE_TRANSACTION desc";
if (MtGlb.QueryDataSet3(StrQuerys, "TRANSACTION", ConexionDim))
{
Str_detalle = Convert.ToDateTime(MtGlb.oDataRow3["DATE_TRANSACTION"]).ToString("dd/MM/yyyy") + ",";
/****************/
dataRows = from MyRow in dt.AsEnumerable()
//where MyRow.Field<string>("idCarril") == MtGlb.oDataRow3["Voie"].ToString().Substring(1, 2)
where MyRow.Field <string>("Num_Carril") == MtGlb.oDataRow3["Voie"].ToString().Substring(1, 2)
select MyRow;
foreach (DataRow value in dataRows)
{
//NumCarril = value["numCarril"].ToString();
//NumTramo = value["numTramo"].ToString();
//NumPlaza = value["idPlaza"].ToString();
NumCarril = value["Num_Capufe"].ToString();
NumTramo = value["Num_Tramo"].ToString();
NumPlaza = value.Field <Type_Plaza>("Type_Plaza").Num_Plaza.ToString();
}
/***************/
if (dataRows.Count() != 0)
{
Str_detalle = Str_detalle + NumTramo + ",";
Str_detalle = Str_detalle + NumCarril + ",";
}
else
{
Str_detalle = Str_detalle + ",,";
}
//Cuerpo Caracter X(1)
Str_detalle = Str_detalle + MtGlb.oDataRow3["Voie"].ToString().Substring(0, 1) + ",";
//Hora de evento Caracter hhmmss
Str_detalle = Str_detalle + Convert.ToDateTime(MtGlb.oDataRow3["DATE_TRANSACTION"]).ToString("HHmmss") + ",";
//numero tarjeta iave
Validar = true;
Tag_iag = MtGlb.IIf(MtGlb.oDataRow3["CONTENU_ISO"].ToString().Trim() == "FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF", "", MtGlb.oDataRow3["CONTENU_ISO"].ToString().TrimStart());
if (Tag_iag.Length != 8) //Tag 00000000
{
Tag_iag = Tag_iag.Substring(0, 14).Trim();
}
if (Tag_iag.Length == 13 && Tag_iag.Substring(0, 3) == "009")
{
Tag_iag = Tag_iag.Substring(0, 3) + Tag_iag.Substring(5, 8);
}
LenText = Tag_iag.Length.ToString();
for (int c = 0; c < Convert.ToInt32(LenText); c++)
{
KeyAscii = (int)Convert.ToChar(Tag_iag.Substring(c, 1));
if ((KeyAscii >= 33) && (KeyAscii <= 47) || (KeyAscii >= 58) && (KeyAscii <= 64) || (KeyAscii >= 91) && (KeyAscii <= 96) || (KeyAscii >= 123) && (KeyAscii <= 126))
{
Validar = false;
KeyAscii = 8;
}
}
Str_detalle = Str_detalle + Tag_iag.Trim() + ",";
//situacion tarjeta iave
if (Convert.ToInt32(MtGlb.oDataRow3["ID_PAIEMENT"]) == 15)
{
Str_detalle = Str_detalle + "V" + ",";
}
else
{
Str_detalle = Str_detalle + "I" + ",";
}
//clave transportsta iave
Str_detalle = Str_detalle + ",";
//clase vehiculo iave
Str_detalle = Str_detalle + ",";
//importe usuario iave
Str_detalle = Str_detalle + item["MONTO_DETECTADO"] + ",";
//numero de evento ect
Str_detalle = Str_detalle + MtGlb.oDataRow3["EVENT_NUMBER"] + ",";
//Número de turno Entero 9
Str_detalle = Str_detalle + Int_turno + ",";
//numero de ejes segun ect
if (!DBNull.Value.Equals(MtGlb.oDataRow3["CLASE_DETECTADA"]))
{
StrClaseExcedente = string.Empty;
if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T01A")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "L";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T01M")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "L";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T01T")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "L";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T02B")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T03B")
{
Str_detalle = Str_detalle + "3" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T04B")
{
Str_detalle = Str_detalle + "4" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T02C")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T03C")
{
Str_detalle = Str_detalle + "3" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T04C")
{
Str_detalle = Str_detalle + "4" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T05C")
{
Str_detalle = Str_detalle + "5" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T06C")
{
Str_detalle = Str_detalle + "6" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T07C")
{
Str_detalle = Str_detalle + "7" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T08C")
{
Str_detalle = Str_detalle + "8" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T09C")
{
Str_detalle = Str_detalle + "9" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "TL01A")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "TL02A")
{
Str_detalle = Str_detalle + "2" + ",";
Str_detalle = Str_detalle + "P";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "TLnnA")
{
Str_detalle = Str_detalle + MtGlb.oDataRow3["ID_OBS_TT"] + ",";
Str_detalle = Str_detalle + "L";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "T01P")
{
Str_detalle = Str_detalle + "1" + ",";
Str_detalle = Str_detalle + "L";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "TP01C")
{
Str_detalle = Str_detalle + "9" + ",";
Str_detalle = Str_detalle + "L";
}
else if (MtGlb.oDataRow3["CLASE_DETECTADA"].ToString() == "TPnnC")
{
Str_detalle = Str_detalle + MtGlb.oDataRow3["ID_OBS_TT"] + ",";
Str_detalle = Str_detalle + "P";
}
else
{
Str_detalle = Str_detalle + "No detectada" + ",0,";
}
}
else
{
Str_detalle = Str_detalle + "0,";
}
}
}
//II Fin
//fin clase detectada
if (Validar)
{
Dbl_registros = Dbl_registros + 1;
Val.Add(Str_detalle);
//oSW.WriteLine(str_detalle)
//----------------------
}
}
if (Convert.ToString(Dbl_registros).Length == 1)
{
No_registros = "0000" + Dbl_registros;
}
else if (Convert.ToString(Dbl_registros).Length == 2)
{
No_registros = "000" + Dbl_registros;
}
else if (Convert.ToString(Dbl_registros).Length == 3)
{
No_registros = "00" + Dbl_registros;
}
else if (Convert.ToString(Dbl_registros).Length == 4)
{
No_registros = "0" + Dbl_registros;
}
else if (Convert.ToString(Dbl_registros).Length == 5)
{
No_registros = Dbl_registros.ToString();
}
Cabecera = Cabecera + No_registros;
Osw.WriteLine(Cabecera);
Osw2.WriteLine(Cabecera);
// CABECERA FIN
}
else
{
Cabecera = Cabecera + "00000";
Osw.WriteLine(Cabecera);
Osw2.WriteLine(Cabecera);
}
//fin detalle
/*********************/
MtGlb.ConnectionOpen(ConexionDim);
foreach (var item in Val)
{
Osw.WriteLine(item);
Osw2.WriteLine(item);
}
Osw.Flush();
Osw.Close();
Osw2.Flush();
Osw2.Close();
Message = "Todo bien";
}
catch (Exception ex)
{
Message = ex.Message + " " + ex.StackTrace;
Message = Message.Replace(System.Environment.NewLine, " ");
}
}