public SuministrosConceptos SuministrosConceptosGetById(long Id)
{
try
{
DataSet ds = new DataSet();
Conexion oConexion = new Conexion();
OracleConnection cn = oConexion.getConexion();
cn.Open();
string sqlSelect = "select * from Suministros_Conceptos " +
"WHERE SMC_CODIGO=" + Id.ToString();
cmd = new OracleCommand(sqlSelect, cn);
adapter = new OracleDataAdapter(cmd);
cmd.ExecuteNonQuery();
adapter.Fill(ds);
DataTable dt;
dt = ds.Tables[0];
SuministrosConceptos NewEnt = new SuministrosConceptos();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
NewEnt = CargarSuministrosConceptos(dr);
}
return(NewEnt);
}
catch (Exception ex)
{
throw ex;
}
}
public long SuministrosConceptosAdd(SuministrosConceptos oSCo)
{
try
{
Conexion oConexion = new Conexion();
OracleConnection cn = oConexion.getConexion();
cn.Open();
// Clave Secuencia Smc_NUMERO
ds = new DataSet();
string query =
" DECLARE IDTEMP NUMBER(22,0); " +
" BEGIN " +
" SELECT(PKG_SECUENCIAS.FNC_PROX_SECUENCIA('SMC_NUMERO')) into IDTEMP from dual; " +
" insert into Suministros_Conceptos " +
"(SMC_CODIGO, SMC_FECHA_ALTA, SMC_FECHA_BAJA, " +
"EST_CODIGO, CPT_NUMERO, SUM_NUMERO) " +
"values(IDTEMP,";
if (oSCo.SmcFechaAlta == null)
{
query += "null, '";
}
else
{
query += "'" + oSCo.SmcFechaAlta.Value.ToString("dd/MM/yyyy") + "','";
}
if (oSCo.SmcFechaBaja == null)
{
query += "null, '";
}
else
{
query += "'" + oSCo.SmcFechaBaja.Value.ToString("dd/MM/yyyy") + "','";
}
query += oSCo.EstCodigo + "'," + oSCo.CptNumero + "," + oSCo.SumNumero + ") RETURNING IDTEMP INTO :id;" +
" END;";
//oSCo.SmcFechaBaja == null ? "null, '" : "'" + oSCo.SmcFechaBaja.Value.ToString("dd/MM/yyyy") + "','" +
cmd = new OracleCommand(query, cn);
cmd.Parameters.Add(new OracleParameter
{
ParameterName = ":id",
OracleDbType = OracleDbType.Int64,
Direction = ParameterDirection.Output
});
adapter = new OracleDataAdapter(cmd);
cmd.ExecuteNonQuery();
response = long.Parse(cmd.Parameters[":id"].Value.ToString());
cn.Close();
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public long SuministrosConceptosAdd(SuministrosConceptos oSuministrosConceptos)
{
SuministrosConceptosImpl oSuministrosConceptosImpl = new SuministrosConceptosImpl();
return(oSuministrosConceptosImpl.SuministrosConceptosAdd(oSuministrosConceptos));
}
public bool SuministrosConceptosUpdate(SuministrosConceptos oSuministrosConceptos)
{
SuministrosConceptosImpl oSuministrosConceptosImpl = new SuministrosConceptosImpl();
return(oSuministrosConceptosImpl.SuministrosConceptosUpdate(oSuministrosConceptos));
}
