private void Fill(out Banco oObj, NullableDataReader dr) { oObj = new Banco(dr.GetInt16("id_Banco"), dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion"), dr.GetBoolean("frecuente"), dr.GetNullableString("webSite") == null ?"":dr.GetString("webSite") ); }
private void Fill(out Pais oObj, NullableDataReader dr) { oObj = new Pais(dr.GetInt16("codigoPais"), dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion"), dr.GetNullableString("gentilicio") == null ? "" : dr.GetString("gentilicio"), dr.GetBoolean("tieneConvenio"), dr.GetBoolean("mercosur") ); }
private void Fill(out Devolucion oObj, NullableDataReader dr) { oObj = new Devolucion(dr.GetDateTime("fechaMovimiento"), dr.GetNullableString("destino") == null ? "" : dr.GetString("destino"), dr.GetNullableString("Observaciones") == null?"":dr.GetString("Observaciones"), dr.GetNullableString("Certificado") == null ? "" : dr.GetString("Certificado"), this.TraeFaltanteDevolucionXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaMovimiento").ToShortDateString()), dr.GetNullableDateTime("fechaNotificacion"), dr.GetNullableDateTime("fechaPresentacion") ); }
public static List <EstadoReclamo> Traer_Proximos(int idEstado) { string sql = "EstadoReclamo_Proximo"; Database db = DatabaseFactory.CreateDatabase("DAT_V01"); DbCommand dbCommand = db.GetStoredProcCommand(sql); DbParameterCollection dbParametros = null; db.AddInParameter(dbCommand, "@idEstado", DbType.Int32, idEstado); List <EstadoReclamo> ListEstado = new List <EstadoReclamo>(); EstadoReclamo oEst = null; try { dbParametros = dbCommand.Parameters; using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand))) { while (ds.Read()) { oEst = new EstadoReclamo(); oEst.DescEstado = ds["DescEstado"].ToString(); oEst.IdEstado = int.Parse(ds["IdEstado"].ToString()); oEst.Control = ds.GetNullableString("Control"); oEst.ControlTexto = ds.GetNullableString("ControlTexto"); oEst.ControlIdModelo = ds.GetNullableInt32("ControlIdModelo") == null ? 0 : ds.GetInt32("ControlIdModelo"); oEst.EsFinal = ds.GetNullableBoolean("EsFinal") == null ? false : ds.GetBoolean("EsFinal"); oEst.FecManual = ds.GetNullableBoolean("FecManual") == null ? false : ds.GetBoolean("FecManual"); oEst.MensajeInfo = ds.GetNullableString("MensajeInfo"); oEst.EstadoAnme = ds.GetNullableInt32("EstadoAnme") == null ? 0 : ds.GetInt32("EstadoAnme"); oEst.PaseAutomatico = ds.GetNullableBoolean("PaseAutomatico") == null ? false : ds.GetBoolean("PaseAutomatico"); oEst.TieneObservacion = ds.GetNullableBoolean("TieneObservacion") == null ? false : ds.GetBoolean("TieneObservacion"); ListEstado.Add(oEst); } ds.Close(); ds.Dispose(); } return(ListEstado); } catch (Exception ex) { log.Error(string.Format("{0}->{1}->Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message)); throw new Exception("Error en EstadoDAO.Trae_Todos", ex); } finally { db = null; dbCommand.Dispose(); } }
private void Fill(out Ingresos oObj, NullableDataReader dr) { AuxiliaresDatos oAuxDao = new AuxiliaresDatos(); oObj = new Ingresos(dr.GetNullableByte("idTipoIngreso") == null ? null : oAuxDao.Traer_TipoIngreso(dr.GetByte("idTipoIngreso")), dr.GetNullableDateTime("fechaIngreso"), this.TraeIngresadosXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaIngreso")), dr.GetNullableString("observacion") == null ? "" : dr.GetString("observacion") ); }
private void Fill(out Movimiento_Solicitud oObj, NullableDataReader dr) { Estado iEstado = new Estado(dr.GetInt32("cod_estado"), dr.GetString("descripcionEstado")); Sector iSector = new Sector(dr.GetInt32("cod_sector"), dr.GetString("descripcionSector")); oObj = new Movimiento_Solicitud(dr.GetDateTime("fecha_Movimiento") , iEstado , iSector , dr.GetNullableString("observaciones") == null ? "":dr.GetString("observaciones") ); }
private void Fill(out Documento_Causante oObj, NullableDataReader dr) { oObj = new Documento_Causante(dr.GetInt64("id_Beneficiario"), dr.GetString("numDoc"), dr.GetInt16("codigoDocumento"), dr.GetString("abrevDTDoc"), dr.GetBoolean("docADP"), dr.GetNullableString("abrevPais") == null ? "" : dr.GetString("abrevPais"), dr.GetNullableInt16("PaisPK"), dr.GetDateTime("fechaAlta"), dr.GetNullableDateTime("fechaBaja") ); }
private void Fill(out SolicitudesEFechasSolicitud oObj, NullableDataReader dr) { oObj = new SolicitudesEFechasSolicitud( dr.GetInt64("id_Beneficiario") , dr.GetInt16("codPrestacion") , dr.GetString("ApeNomCompleto") , dr.GetNullableString("cuip") == null ? "" : dr.GetString("cuip") , dr.GetString("DescripcionPrestacion") , dr.GetInt16("pais_PK") , dr.GetString("PaisDescCompleto") , dr.GetBoolean("Mercosur") , dr.GetString("referencia_exterior") , dr.GetString("ubicacion_Fisica") , dr.GetDateTime("fAMSolicitud") , dr.GetDateTime("fechaIngreso") ); }
private void Fill(out TipoDocumentacion oObj, NullableDataReader dr) { oObj = new TipoDocumentacion(dr.GetInt32("codTipoDocumentacion"), dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion") ); }
public WorkTimeEstimateDataSet GetWorkTimeEstimateToPrint( int appId, int prjId, string depCode, string reportType, Dictionary <string, string> param) { LOGGER.Finest("Entering GetWorkTimeEstimateToPrint"); OracleConnection connection = null; OracleParameter appIdParam = null; OracleParameter prjIdParam = null; OracleParameter depCodeParam = null; OracleParameter reportTypeParam = null; OracleParameter prjNumberParam = null; OracleParameter prjNameParam = null; OracleParameter weightParam = null; OracleParameter qtyParam = null; OracleParameter repDateParam = null; OracleParameter authorParam = null; OracleParameter itemsParam = null; OracleParameter itemsDepParam = null; NullableDataReader nullableReader = null; // // WorkTimeEstimateDataSet result = new WorkTimeEstimateDataSet(); // // OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; try { connection = getConnection(); cmd.CommandText = "WB_PCK_REPORTS_WORK.get_work_time_estimate"; cmd.Connection = connection; appIdParam = SQLUtil.CreateInt32OracleParam("P_APP_ID", cmd, appId, ParameterDirection.Input); prjIdParam = SQLUtil.CreateInt32OracleParam("p_prj_id", cmd, prjId, ParameterDirection.Input); depCodeParam = SQLUtil.CreateVarcharOracleParam("p_dep_code", cmd, depCode, ParameterDirection.Input); reportTypeParam = SQLUtil.CreateVarcharOracleParam("p_report_type", cmd, reportType, ParameterDirection.Input); prjNumberParam = SQLUtil.CreateVarcharOracleParam("o_prj_number", cmd, null, ParameterDirection.Output); prjNameParam = SQLUtil.CreateVarcharOracleParam("o_prj_name", cmd, null, ParameterDirection.Output); weightParam = SQLUtil.CreateInt32OracleParam("o_weight", cmd, null, ParameterDirection.Output); qtyParam = SQLUtil.CreateInt32OracleParam("o_qty", cmd, null, ParameterDirection.Output); repDateParam = SQLUtil.CreateDateOracleParam("o_rep_date", cmd, null, ParameterDirection.Output); authorParam = SQLUtil.CreateVarcharOracleParam("o_author", cmd, null, ParameterDirection.Output); itemsParam = SQLUtil.CreateCursorOracleParameter("o_items", OracleDbType.RefCursor, cmd); itemsDepParam = SQLUtil.CreateCursorOracleParameter("o_items_dep", OracleDbType.RefCursor, cmd); cmd.ExecuteNonQuery(); WorkTimeEstimateDataSet.WorkTimeMainTableRow row = result.WorkTimeMainTable.NewWorkTimeMainTableRow(); row.ID = prjId.ToString(); row.ProjNumber = SQLUtil.GetStringValue(prjNumberParam); row.ProjName = SQLUtil.GetStringValue(prjNameParam); row.Weight = SQLUtil.GetDecimalValue(weightParam).HasValue ? SQLUtil.GetDecimalValue(weightParam).ToString() : "---"; row.Qty = SQLUtil.GetDecimalValue(qtyParam).HasValue ? SQLUtil.GetDecimalValue(qtyParam).ToString() : "---"; row.AllWeight = SQLUtil.GetDecimalValue(weightParam).HasValue ? SQLUtil.GetDecimalValue(weightParam).ToString() : "---"; row.ReportDate = SQLUtil.GetDateValue(repDateParam).HasValue ? SQLUtil.GetDateValue(repDateParam).Value.Date.ToShortDateString() : "---"; row.Author = SQLUtil.GetStringValue(authorParam); result.WorkTimeMainTable.AddWorkTimeMainTableRow(row); if (!((OracleRefCursor)itemsParam.Value).IsNull) { nullableReader = new NullableDataReader(((OracleRefCursor)itemsParam.Value).GetDataReader()); string TYPE = string.Empty; string name = string.Empty; string drawing_number = string.Empty; string activePath = string.Empty; WorkTimeEstimateDataSet.WorkTimePathRow path = null; while (nullableReader.Read()) { string iPath = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_path")); if (string.IsNullOrEmpty(iPath)) { continue; } WorkTimeEstimateDataSet.WorkTimeItemSimpleRow item = result.WorkTimeItemSimple.NewWorkTimeItemSimpleRow(); item.ID = prjId.ToString(); item.ItemID = nullableReader.GetNullableDecimal("pwei_id").ToString(); item.IsProduct = nullableReader.GetNullableDecimal("pwei_is_product").ToString(); item.ParentID = nullableReader.GetNullableDecimal("pwei_parent_pwei_id").ToString(); TYPE = nullableReader.GetNullableString("pwei_itm_type"); name = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_name")); drawing_number = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_drawing_number")); item.DrawingNumber = drawing_number; item.Qty = nullableReader.GetNullableDecimal("pwei_qty").ToString(); item.QtyPerProj = nullableReader.GetNullableDecimal("pwei_qty_per_prj").ToString(); if (nullableReader.GetNullableString("pwei_product_brand") != null) { item.ProductBrand = nullableReader.GetNullableString("pwei_product_brand"); } else { item.ProductBrand = ""; } string tmp_sizeCut = nullableReader.GetNullableString("pwei_size_cut"); string tmp_addInfo = nullableReader.GetNullableString("pwei_add_info"); item.SizeCut = string.IsNullOrEmpty(tmp_sizeCut) ? "" : ConvertUtil.ConvertToSpecialChars(tmp_sizeCut.Replace("X", " x ").Replace("L=", "L= ")); if (!string.IsNullOrEmpty(tmp_addInfo)) { item.SizeCut += string.Format("\n{0}", tmp_addInfo); } item.SizeCut = ConvertUtil.ConvertToSpecialChars(item.SizeCut); if (param.ContainsKey("productSize")) { if (!item.SizeCut.ToLower().Contains(param["productSize"])) { continue; } } // material gatunek string tempPrName = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_pr_name")); if (!string.IsNullOrEmpty(tempPrName)) { item.PrName = tempPrName + "\n" + ConvertUtil.ConvertToSpecialChars(item.ProductBrand); } else { item.PrName = " " + "\n" + ConvertUtil.ConvertToSpecialChars(item.ProductBrand); } if (param.ContainsKey("materialType")) { if (!item.PrName.ToLower().Contains(param["materialType"])) { continue; } } item.ProgramNumber = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_program_number")); decimal?value = nullableReader.GetNullableDecimal("pwei_ls"); item.LS = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.LS.Equals("0,000")) { item.LS = "0"; } value = nullableReader.GetNullableDecimal("pwei_es"); item.ES = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.ES.Equals("0,000")) { item.ES = "0"; } value = nullableReader.GetNullableDecimal("pwei_bn"); item.BN = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.BN.Equals("0,000")) { item.BN = "0"; } value = nullableReader.GetNullableDecimal("pwei_pt"); item.PT = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.PT.Equals("0,000")) { item.PT = "0"; } value = nullableReader.GetNullableDecimal("pwei_bw"); item.BW = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.BW.Equals("0,000")) { item.BW = "0"; } value = nullableReader.GetNullableDecimal("pwei_bz"); item.BZ = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.BZ.Equals("0,000")) { item.BZ = "0"; } value = nullableReader.GetNullableDecimal("pwei_ph"); item.PH = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.PH.Equals("0,000")) { item.PH = "0"; } value = nullableReader.GetNullableDecimal("pwei_wp"); item.WP = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.WP.Equals("0,000")) { item.WP = "0"; } value = nullableReader.GetNullableDecimal("pwei_rp"); item.RP = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.RP.Equals("0,000")) { item.RP = "0"; } value = nullableReader.GetNullableDecimal("pwei_po"); item.PO = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.PO.Equals("0,000")) { item.PO = "0"; } value = nullableReader.GetNullableDecimal("pwei_mw"); item.MW = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.MW.Equals("0,000")) { item.MW = "0"; } value = nullableReader.GetNullableDecimal("pwei_mc"); item.MC = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.MC.Equals("0,000")) { item.MC = "0"; } value = nullableReader.GetNullableDecimal("pwei_ML"); item.ML = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.ML.Equals("0,000")) { item.ML = "0"; } value = nullableReader.GetNullableDecimal("pwei_KO"); item.KO = value.HasValue ? string.Format("{0:f2}", value.Value) : ""; if (item.KO.Equals("0,000")) { item.KO = "0"; } item.PlanNumber = nullableReader.GetNullableDecimal("pwei_lp").HasValue ? nullableReader.GetNullableDecimal("pwei_lp").Value.ToString() : ""; if (param.ContainsKey("planNo")) { if (!(item.PlanNumber.ToLower() == param["planNo"].ToLower())) { continue; } } item.WorkTimeMainTableRow = row; result.WorkTimeItemSimple.AddWorkTimeItemSimpleRow(item); } } } catch (Exception ex) { LOGGER.Error("Problem occured while GetWorkTimeEstimateToPrint!" + ex.Message, ex); throw new Exception("Problem occured while GetWorkTimeEstimateToPrint!" + ex.Message, ex); } finally { SQLUtil.Close(appIdParam); SQLUtil.Close(prjIdParam); SQLUtil.Close(depCodeParam); SQLUtil.Close(reportTypeParam); SQLUtil.Close(prjNumberParam); SQLUtil.Close(prjNameParam); SQLUtil.Close(weightParam); SQLUtil.Close(qtyParam); SQLUtil.Close(repDateParam); SQLUtil.Close(authorParam); SQLUtil.Close(itemsParam); SQLUtil.Close(itemsDepParam); SQLUtil.Close(nullableReader); SQLUtil.Close(cmd); ReleaseConnection(connection); } return(result); }