public long Nuevo(M_Mayor Mayor)
{
Dictionary <string, object> Parametros = new Dictionary <string, object>
{
{ "Cuenta", Mayor.Cuenta },
{ "Tipo_aux", Mayor.Tipo_aux },
{ "Id_auxiliar", Mayor.Id_auxiliar },
{ "Dv", Mayor.Dv },
{ "Saldo", Mayor.Saldo },
{ "Debitos", Mayor.Debitos },
{ "Creditos", Mayor.Creditos },
{ "Cod_empresa", Mayor.Cod_empresa },
{ "Año", Mayor.Año }
};
return(Data.EjecutarSPEscalar("{CALL sp_Nuevo_Mayor(?, ?, ?, ?, ?, ?, ?, ?, ?)}", Parametros));
}
public long Actualizar(M_Mayor Mayor)
{
return(Data.Accion("UPDATE Mayor SET Cuenta='" + Mayor.Cuenta + "'" + ",Tipo_aux='" + Mayor.Tipo_aux + "'" + ",Id_auxiliar=" + Mayor.Id_auxiliar + ",Dv='" + Mayor.Dv + "'" + ",Saldo=" + Mayor.Saldo + ",Debitos=" + Mayor.Debitos + ",Creditos=" + Mayor.Creditos + ",Cod_empresa=" + Mayor.Cod_empresa + ",Año=" + Mayor.Año + " WHERE Cuenta='" + Mayor.Cuenta + "'" + " and Tipo_aux='" + Mayor.Tipo_aux + "'" + " and Id_auxiliar=" + Mayor.Id_auxiliar + " and Cod_empresa=" + Mayor.Cod_empresa + ";"));
}
public long Insertar(M_Mayor Mayor)
{
return(Data.Accion("INSERT INTO Mayor (Cuenta,Tipo_aux,Id_auxiliar,Dv,Saldo,Debitos,Creditos,Cod_empresa,Año) VALUES (" + "'" + Mayor.Cuenta + "'" + ", '" + Mayor.Tipo_aux + "'" + "," + Mayor.Id_auxiliar + ", '" + Mayor.Dv + "'" + "," + Mayor.Saldo + "," + Mayor.Debitos + "," + Mayor.Creditos + "," + Mayor.Cod_empresa + "," + Mayor.Año + ");"));
}
