public static IList <TDatoRevision> GetTDatosRevision(TRevision revision, SqlCeConnection conn)
{
IList <TDatoRevision> datosRevision = new List <TDatoRevision>();
if (revision == null)
{
return(datosRevision);
}
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM DatosRevision WHERE revision_id = {0} ORDER BY posicion",
revision.RevisionId);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TDatoRevision datoRevision = new TDatoRevision()
{
DatosId = dr.GetInt32(0),
TRevision = GetTRevisionC(dr.GetInt32(1), conn),
Valor = dr.GetString(2),
Tipo = dr.GetString(3),
Posicion = dr.GetInt32(4),
Nombre = dr.GetString(5)
};
datosRevision.Add(datoRevision);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(datosRevision);
}
public static TDatoRevision GetTDatoRevision(int id, SqlCeConnection conn)
{
TDatoRevision datoRevision = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM DatosRevision WHERE datos_id = {0}", id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
datoRevision = new TDatoRevision()
{
DatosId = dr.GetInt32(0),
TRevision = GetTRevision(dr.GetInt32(1), conn),
Valor = dr.GetString(2),
Tipo = dr.GetString(3),
Posicion = dr.GetInt32(4),
Nombre = dr.GetString(5)
};
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(datoRevision);
}
public static void TSave(TDatoRevision tdr, SqlCeConnection conn)
{
string sql = "";
// primero verificamos que si el elemento está
TDatoRevision ttdr = GetTDatoRevision(tdr.DatosId, conn);
if (ttdr == null)
{
sql = @"INSERT INTO DatosRevision(datos_id, revision_id, valor, tipo, posicion, nombre)
VALUES({0},{1},'{2}','{3}',{4},'{5}')";
}
else
{
sql = @"UPDATE DatosRevision SET
revision_id={1},
valor='{2}',
tipo='{3}',
posicion={4},
nombre = '{5}'
WHERE datos_id={0}";
}
sql = String.Format(sql, tdr.DatosId, tdr.TRevision.RevisionId, tdr.Valor, tdr.Tipo, tdr.Posicion, tdr.Nombre);
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
int nrec = cmd.ExecuteNonQuery();
}
}
public static TDatoRevision GetTDatoRevision(int id, SqlCeConnection conn)
{
TDatoRevision datoRevision = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM DatosRevision WHERE datos_id = {0}", id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
datoRevision = new TDatoRevision();
datoRevision.DatosId = dr.GetInt32(0);
datoRevision.TRevision = GetTRevisionC(dr.GetInt32(1), conn);
datoRevision.Tipo = dr.GetString(3);
datoRevision.Posicion = dr.GetInt32(4);
datoRevision.Nombre = dr.GetString(5);
if (dr[2] != DBNull.Value)
{
datoRevision.Valor = dr.GetString(2);
}
datoRevision.Abm = dr.GetByte(6);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(datoRevision);
}
public static void TSave(TDatoRevision tdr, SqlCeConnection conn)
{
string sql = "";
sql = @"UPDATE DatosRevision SET
revision_id={1},
tipo='{2}',
posicion={3},
nombre = '{4}',
valor = '{5}',
abm = 3
WHERE datos_id={0};";
sql = String.Format(sql, tdr.DatosId, tdr.TRevision.RevisionId, tdr.Tipo, tdr.Posicion, tdr.Nombre, tdr.Valor);
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
int nrec = cmd.ExecuteNonQuery();
}
}
