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(); } }