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 + ");")); }