public string Eliminar(DItemComprobacion ItemComprobacion)
{
string rpta = "";
SqlConnection SlqCon = new SqlConnection();
try
{
string sp = "SpItem_CompEliminar";
SlqCon.ConnectionString = Conexion.Cn;
SqlCommand SqlCmd = new SqlCommand(sp, SlqCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SlqCon.Open();
SqlCmd.Parameters.Add(new SqlParameter("@CODIGO", ItemComprobacion.Codigo));
rpta = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "NO se Elimino el Registro";
return(rpta);
}
catch (Exception ex)
{
rpta = ex.Message;
}
finally
{
if (SlqCon.State == ConnectionState.Open)
{
SlqCon.Close();
}
}
return(rpta);
}
public void Cargar(DItemComprobacion ItemComprobacion, ref DataRow dr)
{
try
{
ItemComprobacion.Codigo = (int)(dr["Codigo"] == DBNull.Value ? 0 : dr["Codigo"]);
ItemComprobacion.Metodo = (string)(dr["Metodo"] == DBNull.Value ? "" : dr["Metodo"]);
ItemComprobacion.Unidad = (string)(dr["Unidad"] == DBNull.Value ? "" : dr["Unidad"]);
ItemComprobacion.Rango = (double)(dr["Rango"] == DBNull.Value ? 0.0 : dr["Rango"]);
ItemComprobacion.Resolucion = (double)(dr["Resolucion"] == DBNull.Value ? 0.0 : dr["Resolucion"]);
ItemComprobacion.Criterio = (double)(dr["Criterio"] == DBNull.Value ? 0.0 : dr["Criterio"]);
}
catch (Exception ex)
{
throw ex;
}
}
public string Insertar(DItemComprobacion ItemComprobacion)
{
string rpta = "";
SqlConnection SlqCon = new SqlConnection();
try
{
string sp = "SpItem_CompInsertar";
SlqCon.ConnectionString = Conexion.Cn;
SqlCommand SqlCmd = new SqlCommand(sp, SlqCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SlqCon.Open();
//[Instanciando parámetro de Salida.]
//SqlParameter Codigo = new SqlParameter("@CODIGO", SqlDbType.Int);
//Codigo.Direction = ParameterDirection.Output;
//SqlCmd.Parameters.Add(Codigo);
SqlCmd.Parameters.Add(new SqlParameter("@CODIGO", SqlDbType.Int, 8, Convert.ToString(ParameterDirection.Output))).Value = DBNull.Value;
//SqlCmd.Parameters("@CODIGO").Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(new SqlParameter("@METODO", ItemComprobacion.Metodo));
SqlCmd.Parameters.Add(new SqlParameter("@UNIDAD", ItemComprobacion.Unidad));
SqlCmd.Parameters.Add(new SqlParameter("@RANGO", ItemComprobacion.Rango));
SqlCmd.Parameters.Add(new SqlParameter("@RESOLUCION", ItemComprobacion.Resolucion));
SqlCmd.Parameters.Add(new SqlParameter("@CRITERIO", ItemComprobacion.Criterio));
rpta = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "NO se Ingreso el Registro";
}
catch (Exception ex)
{
rpta = ex.Message;
}
finally
{
if (SlqCon.State == ConnectionState.Open)
{
SlqCon.Close();
}
}
return(rpta);
}
public string Actualizar(DItemComprobacion ItemComprobacion)
{
string rpta = "";
SqlConnection SlqCon = new SqlConnection();
try
{
string sp = "SpItem_CompActualizar";
SlqCon.ConnectionString = Conexion.Cn;
SqlCommand SqlCmd = new SqlCommand(sp, SlqCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SlqCon.Open();
SqlCmd.Parameters.Add(new SqlParameter("@CODIGO", ItemComprobacion.Codigo));
SqlCmd.Parameters.Add(new SqlParameter("@METODO", ItemComprobacion.Metodo));
SqlCmd.Parameters.Add(new SqlParameter("@UNIDAD", ItemComprobacion.Unidad));
SqlCmd.Parameters.Add(new SqlParameter("@RANGO", ItemComprobacion.Rango));
SqlCmd.Parameters.Add(new SqlParameter("@RESOLUCION", ItemComprobacion.Resolucion));
SqlCmd.Parameters.Add(new SqlParameter("@CRITERIO", ItemComprobacion.Criterio));
rpta = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "NO se Modifico el Registro";
}
catch (Exception ex)
{
rpta = ex.Message;
}
finally
{
if (SlqCon.State == ConnectionState.Open)
{
SlqCon.Close();
}
}
return(rpta);
}
public bool Obtener(DItemComprobacion ItemComprobacion)
{
DataTable DtResultado = new DataTable();
SqlConnection SlqCon = new SqlConnection();
try
{
string sp = "SpItem_CompObtener";
SlqCon.ConnectionString = Conexion.Cn;
SqlCommand SqlCmd = new SqlCommand(sp, SlqCon);
SlqCon.Open();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd);
SqlDat.SelectCommand.Parameters.Add(new SqlParameter("@CODIGO", ItemComprobacion.Codigo));
DataTable dt = new DataTable();
SqlDat.Fill(dt);
if ((dt.Rows.Count == 1))
{
DataRow dr = dt.Rows[0];
Cargar(ItemComprobacion, ref dr);
}
else
{
throw new Exception("No se pudo obtener el registro");
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
