Greetings, I would like to know what value returns me executenonquery in case I do not affect any field, example
string respuesta = "";
SqlConnection SqlConexion = new SqlConnection();
try
{
SqlConexion.ConnectionString = Conexion.ConexionPalmComSync;
SqlConexion.Open();
SqlCommand SqlComando = new SqlCommand();
SqlComando.Connection = SqlConexion;
SqlComando.CommandText = "SP_INGRESAR_CONDUCE";
SqlComando.CommandType = CommandType.StoredProcedure;
SqlParameter ParDate = new SqlParameter();
ParDate.ParameterName = "@date";
ParDate.SqlDbType = SqlDbType.DateTime;
ParDate.Value = Conduce.Date;
SqlComando.Parameters.Add(ParDate);
SqlParameter ParVendedor = new SqlParameter();
ParVendedor.ParameterName = "@vendedor";
ParVendedor.SqlDbType = SqlDbType.VarChar;
ParVendedor.Size = 10;
ParVendedor.Value = Conduce.Vendedor;
SqlComando.Parameters.Add(ParVendedor);
respuesta = SqlComando.ExecuteNonQuery() == 0 ? "Ya existe en el sistema" : "OK";
}
catch (Exception ex)
{
respuesta = ex.Message;
}
finally
{
if (SqlConexion.State == ConnectionState.Open) SqlConexion.Close();
}
return respuesta;
I want to know what value it returns to me in case I'm not affected by any row
This is the stored procedure I think it's the procedure
ALTER PROCEDURE [dbo]. [SP_INGRESAR_CONDUCE] @date datetime, @ varchar seller (10) ACE BEGIN SET NOCOUNT OFF;
DECLARE @PALMID VARCHAR(10)
DECLARE @TRANSNUM VARCHAR(16)
DECLARE @CODPROD VARCHAR(16)
DECLARE @DESCRIP VARCHAR(45)
DECLARE @CANTIDAD INT
DECLARE @ALMORIGEN VARCHAR(10)
DECLARE @ALMDESTIONO VARCHAR(10)
DECLARE @FECTRANS DATETIME
DECLARE @IDVENDEDOR VARCHAR(10)
DECLARE @IDAYUDANTE VARCHAR(10)
DECLARE @IDAYUDANTE2 VARCHAR(10)
DECLARE @TIPODOCUMENTO VARCHAR(14)
DECLARE @CODRUTA VARCHAR(14)
DECLARE @RECIBIDOEN DATETIME
DECLARE @IPADDRESS VARCHAR(20)
DECLARE @PROCESADO INT
DECLARE @ROWID INT
DECLARE @COD VARCHAR(16)
DECLARE @VENDEDOR_DEVOLUCION VARCHAR(10)
DECLARE CUR_INGRESAR_CONDUCE CURSOR
FOR SELECT * FROM IN_TRANSINV WHERE FECTRANS = @date and IDVENDEDOR = @vendedor
OPEN CUR_INGRESAR_CONDUCE
FETCH NEXT FROM CUR_INGRESAR_CONDUCE INTO @PALMID, @TRANSNUM, @CODPROD, @DESCRIP,
@CANTIDAD, @ALMORIGEN, @ALMDESTIONO, @FECTRANS, @IDVENDEDOR, @IDAYUDANTE, @IDAYUDANTE2,
@TIPODOCUMENTO, @CODRUTA, @RECIBIDOEN, @IPADDRESS, @PROCESADO, @ROWID
WHILE(@@FETCH_STATUS = 0)
BEGIN
SET @COD = DBO.FT_COD_DEVOLUCION('D0000000')
SET @VENDEDOR_DEVOLUCION = (SELECT IDVENDEDOR from OUT_CONFIG where PALMID = @PALMID)
IF NOT EXISTS(SELECT * FROM SITGPIntegration.DBO.RelacionConduce
WHERE TipoDocumento = 'Conduce' and NoDocumento = @TRANSNUM)
BEGIN
IF NOT EXISTS(SELECT ORDDOCID FROM GPHN.DBO.SVC00700 WHERE ORDDOCID = @TRANSNUM)
BEGIN
EXEC SP_INSERTAR_CABECERA @TRANSNUM,'','','',1,@FECTRANS,'1900-01-01 00:00:00.000','','','','','','','',@ALMORIGEN,'',@ALMDESTIONO,306130.00000,0,'','','','sa'
END
ELSE
BEGIN
EXEC SP_INSERTAR_ERROR_CABEZA @ALMORIGEN,@TRANSNUM,'Violation of PRIMARY KEY constraint ''PKSVC00700''. Cannot insert duplicate key in object ''dbo.SVC00700''. The statement has been terminated.',@FECTRANS
END
IF NOT EXISTS(SELECT ORDDOCID FROM GPHN.DBO.SVC00701 WHERE ORDDOCID = @TRANSNUM)
BEGIN
EXEC SP_INSERTAR_DETALLE @TRANSNUM,16384,1,@CODPROD,@DESCRIP,'1X1UND',@CANTIDAD,@CANTIDAD,0,0,0,0,0,0,0,'',0,0,'',0,'',0,@ALMORIGEN,'',@ALMDESTIONO,1,1,0,0,''
END
EXEC SP_INSERTAR_CONDUCE @TRANSNUM,'Conduce',@IDVENDEDOR,@CODRUTA,@FECTRANS,@IDAYUDANTE,@IDAYUDANTE2,'sa',''
/*DEVOLUCION*/
IF NOT EXISTS(SELECT ORDDOCID FROM GPHN.DBO.SVC00700 WHERE ORDDOCID = @COD)
BEGIN
EXEC SP_INSERTAR_CABECERA @COD ,'','','',1,@FECTRANS,'1900-01-01 00:00:00.000','','','','','','','',@ALMORIGEN,'','SAN ISIDRO',306130.00000,0,'','','','sa'
END
IF NOT EXISTS(SELECT ORDDOCID FROM GPHN.DBO.SVC00701 WHERE ORDDOCID = @COD)
BEGIN
EXEC SP_INSERTAR_DETALLE @COD,16384,1,@CODPROD,@DESCRIP,'1X1UND',@CANTIDAD,@CANTIDAD,0,0,0,0,0,0,0,'',0,0,'',0,'',0,@ALMORIGEN,'','SAN ISIDRO',1,1,0,0,''
END
IF NOT EXISTS(SELECT NoDocumento FROM SITGPIntegration.dbo.RelacionConduce WHERE NoDocumento = @COD)
BEGIN
EXEC SP_INSERTAR_CONDUCE @COD,'Devolucion',@VENDEDOR_DEVOLUCION,@CODRUTA,@FECTRANS,@IDAYUDANTE,@IDAYUDANTE2,'sa',''
END
FETCH NEXT FROM CUR_INGRESAR_CONDUCE INTO @PALMID, @TRANSNUM, @CODPROD, @DESCRIP,
@CANTIDAD, @ALMORIGEN, @ALMDESTIONO, @FECTRANS, @IDVENDEDOR, @IDAYUDANTE, @IDAYUDANTE2,
@TIPODOCUMENTO, @CODRUTA, @RECIBIDOEN, @IPADDRESS, @PROCESADO, @ROWID
END
ELSE
BEGIN
BREAK
END
END
CLOSE CUR_INGRESAR_CONDUCE
DEALLOCATE CUR_INGRESAR_CONDUCE
END
GO