private void Frm_OC_SIn_Aprobar_Load(object sender, EventArgs e)
{
BE_OC_SIn_Aprobars controls = (BE_OC_SIn_Aprobars)BL_ObjControl_OC_SIn_Aprobar.PoblarOC_SIn_AprobarSelAll();
if (controls.Count > 0)
{
this.EnvioAlertaOCSinAprobar2();
}
this.Dispose();
}
public override BE_OC_SIn_Aprobars ObtenerOC_SIn_AprobarSelAll()
{
BE_OC_SIn_Aprobars facturars = new BE_OC_SIn_Aprobars();
DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.S10_Orden_Compra_Sin_Aprobar");
using (SqlDataReader reader = (SqlDataReader)this.BaseInterface.ExecuteReader(storedProcCommand))
{
while (reader.Read())
{
BE_OC_SIn_Aprobar item = new BE_OC_SIn_Aprobar(Convert.ToString(reader["PROYECTO"]), Convert.ToString(reader["NROORDEN"]), Convert.ToString(reader["TIPO"]),
Convert.ToString(reader["FORMADEPAGO"]), Convert.ToString(reader["MONEDA"]), Convert.ToString(reader["VALORNETO"]), Convert.ToString(reader["ESTADOOC"]),
Convert.ToString(reader["PROVEEDORRUC"]), Convert.ToString(reader["PROVEEDOR"]), Convert.ToString(reader["LUGARDEENTREGA"]), Convert.ToString(reader["FECHAORDEN"]),
Convert.ToString(reader["FECHAENTREGA"]), Convert.ToString(reader["PROCEDENCIA"]), Convert.ToString(reader["CENTROCOMPRA"]), Convert.ToString(reader["CREACIONUSUARIO"]),
Convert.ToString(reader["ACTUALIZACIONUSUARIO"]), Convert.ToString(reader["FECHAENVIOAPROBACION"]), Convert.ToString(reader["USUARIOA"]),
Convert.ToString(reader["COMPRADOR"]), Convert.ToString(reader["OBSERVACION"]));
facturars.Add(item);
}
}
return(facturars);
}
