public static tsh_PadronesARBADataset.tsh_PadronesARBARow GetFechaPublicacionDeUltimaActualizacion()
{
tsh_PadronesARBADataset data = new tsh_PadronesARBADataset();
try
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "tsh_PadronesARBA");
SqlCommand cmd = new SqlCommand("Pr_tsh_PadronARBA_GetFechaPublicacionDeUltimaActualizacion", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = cmd;
adapter.Fill(data);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
if (data.tsh_PadronesARBA.Rows.Count == 1)
{
return((tsh_PadronesARBADataset.tsh_PadronesARBARow)data.tsh_PadronesARBA.Rows[0]);
}
return(null);
}
/// <summary>
/// Envia los cambios del tsh_PadronesARBADataset a la base de datos.
/// </summary>
public static void Update(tsh_PadronesARBADataset dataSet)
{
ApplicationAssert.Check(dataSet != null, "El argumento dataSet no debe ser nulo.", ApplicationAssert.LineNumber);
ApplicationAssert.Check(dataSet.tsh_PadronesARBA.Rows.Count > 0, "La tabla dataSet.tsh_PadronesARBADataTable debe poseer alguna fila.", ApplicationAssert.LineNumber);
SentenciasReplicacion replication = new SentenciasReplicacion();
replication.IdConexion = Security.IdConexion;
replication.SucGeneradora = Security.IdSucursal;
//Para todas las sucursales
replication.Destino = null;
replication.VersionBD = null;
replication.NombreTabla = "dataaccess.tsh_PadronesARBA";
mz.erp.dataaccess.tsh_PadronesARBA.Replicacion = replication;
mz.erp.dataaccess.tsh_PadronesARBA.Update(dataSet);
}
public static tsh_PadronesARBADataset.tsh_PadronesARBARow GetByPk(Int64 IdPadron)
{
tsh_PadronesARBADataset data = new tsh_PadronesARBADataset();
SqlCommand cmd = new SqlCommand("Pr_tsh_PadronesARBA_GetByPk", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdPadron", SqlDbType.BigInt));
cmd.Parameters["@IdPadron"].Value = IdPadron;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.TableMappings.Add("Table", "tsh_PadronesARBA");
adapter.Fill(data);
if (data.tsh_PadronesARBA.Rows.Count == 1)
{
return((tsh_PadronesARBADataset.tsh_PadronesARBARow)data.tsh_PadronesARBA.Rows[0]);
}
return(null);
}
public static tsh_PadronesARBADataset GetList()
{
tsh_PadronesARBADataset data = new tsh_PadronesARBADataset();
return((tsh_PadronesARBADataset)GetList(data));
}
public static void Update(tsh_PadronesARBADataset dataSet)
{
Update(dataSet.tsh_PadronesARBA);
}
