protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oSalida_aud_uni.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_orden_carga", DbType.Int32, this._oSalida_aud_uni.Id_salida_orden_carga); GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte_tipo", DbType.Int32, this._oSalida_aud_uni.Id_transporte_tipo); GenericDataAccess.AddInParameter(this.comm, "?P_informa", DbType.String, this._oSalida_aud_uni.Informa); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oSalida_aud_uni.Referencia); GenericDataAccess.AddInParameter(this.comm, "?P_operador", DbType.String, this._oSalida_aud_uni.Operador); GenericDataAccess.AddInParameter(this.comm, "?P_placa", DbType.String, this._oSalida_aud_uni.Placa); GenericDataAccess.AddInParameter(this.comm, "?P_caja", DbType.String, this._oSalida_aud_uni.Caja); GenericDataAccess.AddInParameter(this.comm, "?P_caja1", DbType.String, this._oSalida_aud_uni.Caja1); GenericDataAccess.AddInParameter(this.comm, "?P_caja2", DbType.String, this._oSalida_aud_uni.Caja2); GenericDataAccess.AddInParameter(this.comm, "?P_sello", DbType.String, this._oSalida_aud_uni.Sello); GenericDataAccess.AddInParameter(this.comm, "?P_acta_informativa", DbType.String, this._oSalida_aud_uni.Acta_informativa); GenericDataAccess.AddInParameter(this.comm, "?P_vigilante", DbType.String, this._oSalida_aud_uni.Vigilante); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oEntrada_fondeo.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario", DbType.Int32, this._oEntrada_fondeo.Id_usuario); GenericDataAccess.AddInParameter(this.comm, "?P_fecha", DbType.DateTime, this._oEntrada_fondeo.Fecha); GenericDataAccess.AddInParameter(this.comm, "?P_importador", DbType.String, this._oEntrada_fondeo.Importador); GenericDataAccess.AddInParameter(this.comm, "?P_aduana", DbType.String, this._oEntrada_fondeo.Aduana); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oEntrada_fondeo.Referencia); GenericDataAccess.AddInParameter(this.comm, "?P_factura", DbType.String, this._oEntrada_fondeo.Factura); GenericDataAccess.AddInParameter(this.comm, "?P_codigo", DbType.String, this._oEntrada_fondeo.Codigo); GenericDataAccess.AddInParameter(this.comm, "?P_orden", DbType.String, this._oEntrada_fondeo.Orden); GenericDataAccess.AddInParameter(this.comm, "?P_vendor", DbType.String, this._oEntrada_fondeo.Vendor); GenericDataAccess.AddInParameter(this.comm, "?P_piezas", DbType.Int32, this._oEntrada_fondeo.Piezas); GenericDataAccess.AddInParameter(this.comm, "?P_valorfactura", DbType.Double, this._oEntrada_fondeo.Valorfactura); GenericDataAccess.AddInParameter(this.comm, "?P_folio", DbType.String, this._oEntrada_fondeo.Folio); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oEntrada_pre_carga.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte_tipo", DbType.Int32, this._oEntrada_pre_carga.Id_transporte_tipo); GenericDataAccess.AddInParameter(this.comm, "?P_bodega", DbType.String, this._oEntrada_pre_carga.Bodega); GenericDataAccess.AddInParameter(this.comm, "?P_cliente", DbType.String, this._oEntrada_pre_carga.Cliente); GenericDataAccess.AddInParameter(this.comm, "?P_ejecutivo", DbType.String, this._oEntrada_pre_carga.Ejecutivo); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oEntrada_pre_carga.Referencia); GenericDataAccess.AddInParameter(this.comm, "?P_operador", DbType.String, this._oEntrada_pre_carga.Operador); GenericDataAccess.AddInParameter(this.comm, "?P_placa", DbType.String, this._oEntrada_pre_carga.Placa); GenericDataAccess.AddInParameter(this.comm, "?P_caja", DbType.String, this._oEntrada_pre_carga.Caja); GenericDataAccess.AddInParameter(this.comm, "?P_caja1", DbType.String, this._oEntrada_pre_carga.Caja1); GenericDataAccess.AddInParameter(this.comm, "?P_caja2", DbType.String, this._oEntrada_pre_carga.Caja2); GenericDataAccess.AddInParameter(this.comm, "?P_sello", DbType.String, this._oEntrada_pre_carga.Sello); GenericDataAccess.AddInParameter(this.comm, "?P_observaciones", DbType.String, this._oEntrada_pre_carga.Observaciones); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oTarima_almacen_carga.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_tipo_carga", DbType.Int32, this._oTarima_almacen_carga.Id_tipo_carga); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario", DbType.Int32, this._oTarima_almacen_carga.Id_usuario); GenericDataAccess.AddInParameter(this.comm, "?P_id_tarima_almacen_trafico", DbType.Int32, this._oTarima_almacen_carga.Id_tarima_almacen_trafico); if (this._oTarima_almacen_carga.Id_salida == null) { GenericDataAccess.AddInParameter(this.comm, "?P_id_salida", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_id_salida", DbType.Int32, this._oTarima_almacen_carga.Id_salida); } GenericDataAccess.AddInParameter(this.comm, "?P_folio_orden_carga", DbType.String, this._oTarima_almacen_carga.Folio_orden_carga); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oEntrada_aud_mer.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_entrada_pre_carga", DbType.Int32, this._oEntrada_aud_mer.Id_entrada_pre_carga); GenericDataAccess.AddInParameter(this.comm, "?P_informa", DbType.String, this._oEntrada_aud_mer.Informa); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oEntrada_aud_mer.Referencia); GenericDataAccess.AddInParameter(this.comm, "?P_notificado", DbType.String, this._oEntrada_aud_mer.Notificado); GenericDataAccess.AddInParameter(this.comm, "?P_entrada_unica", DbType.Boolean, this._oEntrada_aud_mer.Entrada_unica); GenericDataAccess.AddInParameter(this.comm, "?P_no_entrada", DbType.Int32, this._oEntrada_aud_mer.No_entrada); GenericDataAccess.AddInParameter(this.comm, "?P_bulto_declarado", DbType.Int32, this._oEntrada_aud_mer.Bulto_declarado); GenericDataAccess.AddInParameter(this.comm, "?P_bulto_recibido", DbType.Int32, this._oEntrada_aud_mer.Bulto_recibido); GenericDataAccess.AddInParameter(this.comm, "?P_bulto_abierto", DbType.Int32, this._oEntrada_aud_mer.Bulto_abierto); GenericDataAccess.AddInParameter(this.comm, "?P_bulto_danado", DbType.Int32, this._oEntrada_aud_mer.Bulto_danado); GenericDataAccess.AddInParameter(this.comm, "?P_pallet", DbType.Int32, this._oEntrada_aud_mer.Pallet); GenericDataAccess.AddInParameter(this.comm, "?P_acta_informativa", DbType.String, this._oEntrada_aud_mer.Acta_informativa); GenericDataAccess.AddInParameter(this.comm, "?P_vigilante", DbType.String, this._oEntrada_aud_mer.Vigilante); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oSalida_orden_carga.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_tipo_carga", DbType.Int32, this._oSalida_orden_carga.Id_tipo_carga); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario", DbType.Int32, this._oSalida_orden_carga.Id_usuario); GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_trafico", DbType.Int32, this._oSalida_orden_carga.Id_salida_trafico); GenericDataAccess.AddInParameter(this.comm, "?P_folio_orden_carga", DbType.String, this._oSalida_orden_carga.Folio_orden_carga); GenericDataAccess.AddInParameter(this.comm, "?P_tiene_salida", DbType.Boolean, this._oSalida_orden_carga.Tiene_salida); if (this._oSalida_orden_carga.Observaciones_tranpsorte.Length == 0) { GenericDataAccess.AddInParameter(this.comm, "?P_observaciones_tranpsorte", DbType.String, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_observaciones_tranpsorte", DbType.String, this._oSalida_orden_carga.Observaciones_tranpsorte); } }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oSalida_orden_carga_rem.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_remision", DbType.Int32, this._oSalida_orden_carga_rem.Id_salida_remision); GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_orden_carga", DbType.Int32, this._oSalida_orden_carga_rem.Id_salida_orden_carga); if (this._oSalida_orden_carga_rem.Id_salida == null) { GenericDataAccess.AddInOutParameter(this.comm, "?P_id_salida", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInOutParameter(this.comm, "?P_id_salida", DbType.Int32, this._oSalida_orden_carga_rem.Id_salida); } GenericDataAccess.AddInParameter(this.comm, "?P_pallet", DbType.Int32, this._oSalida_orden_carga_rem.Pallet); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oSalida_orden_carga_rem.Referencia); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oSalida_remision_detail.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_remision", DbType.Int32, this._oSalida_remision_detail.Id_salida_remision); GenericDataAccess.AddInParameter(this.comm, "?P_bulto", DbType.Int32, this._oSalida_remision_detail.Bulto); GenericDataAccess.AddInParameter(this.comm, "?P_piezaxbulto", DbType.Int32, this._oSalida_remision_detail.Piezaxbulto); GenericDataAccess.AddInParameter(this.comm, "?P_piezas", DbType.Int32, this._oSalida_remision_detail.Piezas); GenericDataAccess.AddInParameter(this.comm, "?P_danado", DbType.Boolean, this._oSalida_remision_detail.Danado); if (this._oSalida_remision_detail.Lote == null) { GenericDataAccess.AddInParameter(this.comm, "?P_lote", DbType.String, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_lote", DbType.String, this._oSalida_remision_detail.Lote); } }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oEntrada_maquila.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_cliente", DbType.Int32, this._oEntrada_maquila.Id_cliente); GenericDataAccess.AddInParameter(this.comm, "?P_id_entrada", DbType.Int32, this._oEntrada_maquila.Id_entrada); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario", DbType.Int32, this._oEntrada_maquila.Id_usuario); GenericDataAccess.AddInParameter(this.comm, "?P_id_entrada_inventario", DbType.Int32, this._oEntrada_maquila.Id_entrada_inventario); GenericDataAccess.AddInParameter(this.comm, "?P_fecha_trabajo", DbType.DateTime, this._oEntrada_maquila.Fecha_trabajo); GenericDataAccess.AddInParameter(this.comm, "?P_pallet", DbType.Int32, this._oEntrada_maquila.Pallet); GenericDataAccess.AddInParameter(this.comm, "?P_bulto", DbType.Int32, this._oEntrada_maquila.Bulto); GenericDataAccess.AddInParameter(this.comm, "?P_pieza", DbType.Int32, this._oEntrada_maquila.Pieza); GenericDataAccess.AddInParameter(this.comm, "?P_pieza_danada", DbType.Int32, this._oEntrada_maquila.Pieza_danada); GenericDataAccess.AddInParameter(this.comm, "?P_bulto_faltante", DbType.Int32, this._oEntrada_maquila.Bulto_faltante); GenericDataAccess.AddInParameter(this.comm, "?P_bulto_sobrante", DbType.Int32, this._oEntrada_maquila.Bulto_sobrante); GenericDataAccess.AddInParameter(this.comm, "?P_pieza_faltante", DbType.Int32, this._oEntrada_maquila.Pieza_faltante); GenericDataAccess.AddInParameter(this.comm, "?P_pieza_sobrante", DbType.Int32, this._oEntrada_maquila.Pieza_sobrante); }
public static List <rptFondeo> FondeoGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptFondeo> lst = new List <rptFondeo>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZFondeo"); if (anio_ini == 1) { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, anio_ini); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, dia_ini); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, anio_fin); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, dia_fin); } DataTable dt = GenericDataAccess.ExecuteSelectCommand(comm); foreach (DataRow dr in dt.Rows) { rptFondeo o = new rptFondeo(); o.Fecha = Convert.ToDateTime(dr["fecha"]); o.Referencia = dr["referencia"].ToString(); o.Factura = dr["factura"].ToString(); o.Orden = dr["orden"].ToString(); o.Codigo = dr["codigo"].ToString(); o.Vendor = dr["vendor"].ToString(); o.Piezas = Convert.ToInt32(dr["piezas"]); o.ValorFactura = Convert.ToDouble(dr["valorfactura"]); lst.Add(o); } } catch { throw; } return(lst); }
public void fillLstTarifaByServicio(int id_cliente, int id_servicio) { try { this.comm = GenericDataAccess.CreateCommand( "select ms.id, cm.sku, cm.nombre, ms.precio " + "from cliente_mercancia cm " + "join mercancia_servicio ms on " + " cm.id = ms.id_cliente_mercancia " + " and cm.id_cliente = ?id_cliente " + " and ms.id_servicio = ?id_servicio "); GenericDataAccess.AddInParameter(this.comm, "?id_cliente", DbType.Int32, id_cliente); GenericDataAccess.AddInParameter(this.comm, "?id_servicio", DbType.Int32, id_servicio); this.dt = GenericDataAccess.ExecuteSelectCommand(this.comm); var qry = from result in this.dt.AsEnumerable() select new { id = result.Field <Int32>("id"), sku = result.Field <string>("sku"), nombre = result.Field <string>("nombre"), precio = result.Field <decimal>("precio") }; foreach (var item in qry) { Cliente_mercancia o = new Cliente_mercancia() { Id = item.id, Sku = item.sku, Nombre = item.nombre, Tarifa = item.precio }; this._lst.Add(o); } } catch { throw; } }
private DataTable getData(int anio, int mes) { DataTable dt = new DataTable(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZResAlm"); GenericDataAccess.AddInParameter(comm, "?P_anio", DbType.Int32, anio); GenericDataAccess.AddInParameter(comm, "?P_mes", DbType.Int32, mes); dt = GenericDataAccess.ExecuteSelectCommand(comm); } catch { throw; } return(dt); }
public void fillLstTarifaByClienteMercancia(int id_cliente, int total = 0) { try { this.comm = GenericDataAccess.CreateCommand( "select s.id, s.nombre, count(cm.id) cantidad " + "from servicio s " + "left join mercancia_servicio ms on " + " ms.id_servicio = s.id " + "left join cliente_mercancia cm on " + " cm.id = ms.id_cliente_mercancia " + " and cm.id_cliente = ?id_cliente " + "group by s.id"); GenericDataAccess.AddInParameter(this.comm, "?id_cliente", DbType.Int32, id_cliente); this.dt = GenericDataAccess.ExecuteSelectCommand(this.comm); var qry = from result in this.dt.AsEnumerable() select new { id = result.Field <Int32>("id"), servicio = result.Field <string>("nombre"), cantidad = result.Field <Int64>("cantidad") }; foreach (var item in qry) { Servicio o = new Servicio() { Id = item.id, Nombre = item.servicio, Tarifas = item.cantidad, Total_mercancia = total }; this._lst.Add(o); } } catch { throw; } }
public static List <rptRelDiaSal> RelDiaSalGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptRelDiaSal> lst = new List <rptRelDiaSal>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZRelDiaSal"); if (anio_ini == 1) { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, anio_ini); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, dia_ini); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, anio_fin); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, dia_fin); } DataTable dt = GenericDataAccess.ExecuteSelectCommand(comm); foreach (DataRow dr in dt.Rows) { rptRelDiaSal o = new rptRelDiaSal() { Fecha = Convert.ToDateTime(dr["fecha"]), Folio_salida = dr["folio_salida"].ToString(), Tarimas = Convert.ToInt32(dr["tarimas"]), Destino = dr["destino"].ToString() }; lst.Add(o); } } catch { throw; } return(lst); }
public static List <rptOrdenTrabajo> odntbjGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptOrdenTrabajo> lst = new List <rptOrdenTrabajo>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZOrdenTrabajo"); if (anio_ini == 1) { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, anio_ini); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, dia_ini); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, anio_fin); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, dia_fin); } DataTable dt = GenericDataAccess.ExecuteSelectCommand(comm); foreach (DataRow dr in dt.Rows) { rptOrdenTrabajo o = new rptOrdenTrabajo(); o.Supervisor = dr["supervisor"].ToString(); o.Folio = dr["folio"].ToString(); o.Referencia = dr["referencia"].ToString(); o.Fecha = Convert.ToDateTime(dr["fecha"]); lst.Add(o); } } catch { throw; } return(lst); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oSalida_remision.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_entrada", DbType.Int32, this._oSalida_remision.Id_entrada); GenericDataAccess.AddInParameter(this.comm, "?P_id_entrada_inventario", DbType.Int32, this._oSalida_remision.Id_entrada_inventario); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario_elaboro", DbType.Int32, this._oSalida_remision.Id_usuario_elaboro); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario_autorizo", DbType.Int32, this._oSalida_remision.Id_usuario_autorizo); GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_trafico", DbType.Int32, this._oSalida_remision.Id_salida_trafico); GenericDataAccess.AddInParameter(this.comm, "?P_folio_remision", DbType.String, this._oSalida_remision.Folio_remision); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oSalida_remision.Referencia); GenericDataAccess.AddInParameter(this.comm, "?P_codigo_cliente", DbType.String, this._oSalida_remision.Codigo_cliente); GenericDataAccess.AddInParameter(this.comm, "?P_codigo", DbType.String, this._oSalida_remision.Codigo); GenericDataAccess.AddInParameter(this.comm, "?P_orden", DbType.String, this._oSalida_remision.Orden); GenericDataAccess.AddInParameter(this.comm, "?P_fecha_remision", DbType.DateTime, this._oSalida_remision.Fecha_remision); GenericDataAccess.AddInParameter(this.comm, "?P_no_pallet", DbType.Int32, this._oSalida_remision.No_pallet); GenericDataAccess.AddInParameter(this.comm, "?P_etiqueta_rr", DbType.String, this._oSalida_remision.Etiqueta_rr); GenericDataAccess.AddInParameter(this.comm, "?P_fecha_recibido", DbType.DateTime, this._oSalida_remision.Fecha_recibido); GenericDataAccess.AddInParameter(this.comm, "?P_dano_especifico", DbType.String, this._oSalida_remision.Dano_especifico); GenericDataAccess.AddInParameter(this.comm, "?P_id_estatus", DbType.Int32, this._oSalida_remision.Id_estatus); GenericDataAccess.AddInParameter(this.comm, "?P_es_devolucion", DbType.Boolean, this._oSalida_remision.Es_devolucion); }
public static void procesarProforma(Cliente o) { IDbCommand comm = null; try { foreach (DateTime day in CommonFunctions.EachDay(new DateTime(2017, 12, 1), DateTime.Now)) { comm = GenericDataAccess.CreateCommandSP("sp_Calc_serv_unico_entrada"); GenericDataAccess.AddInParameter(comm, "?P_fecha", DbType.Date, day); GenericDataAccess.ExecuteSelectCommand(comm); comm = GenericDataAccess.CreateCommandSP("sp_Calc_serv_personalizado"); GenericDataAccess.AddInParameter(comm, "?P_fecha", DbType.Date, day); GenericDataAccess.ExecuteSelectCommand(comm); } } catch { throw; } }
public void fillLstNoTarifaByServicio(int id_cliente, int id_servicio) { try { this.comm = GenericDataAccess.CreateCommand( "select cm.sku, cm.nombre " + "from cliente_mercancia cm " + "where cm.id not in (select id_cliente_mercancia from mercancia_servicio where id_servicio = ?id_servicio) " + "and cm.id_cliente = ?id_cliente"); GenericDataAccess.AddInParameter(this.comm, "?id_cliente", DbType.Int32, id_cliente); GenericDataAccess.AddInParameter(this.comm, "?id_servicio", DbType.Int32, id_servicio); this.dt = GenericDataAccess.ExecuteSelectCommand(this.comm); var qry = from result in this.dt.AsEnumerable() select new { sku = result.Field <string>("sku"), nombre = result.Field <string>("nombre"), }; foreach (var item in qry) { Cliente_mercancia o = new Cliente_mercancia() { Id = 0, Sku = item.sku, Nombre = item.nombre, Tarifa = 0 }; this._lst.Add(o); } } catch { throw; } }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oSalida_transporte_condicion.Id); if (this._oSalida_transporte_condicion.Id_salida != null) { GenericDataAccess.AddInParameter(this.comm, "?P_id_salida", DbType.Int32, this._oSalida_transporte_condicion.Id_salida); } else { GenericDataAccess.AddInParameter(this.comm, "?P_id_salida", DbType.Int32, DBNull.Value); } GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte_condicion", DbType.Int32, this._oSalida_transporte_condicion.Id_transporte_condicion); if (this._oSalida_transporte_condicion.Id_salida_transporte_auditoria != null) { GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_transporte_auditoria", DbType.Int32, this._oSalida_transporte_condicion.Id_salida_transporte_auditoria); } else { GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_transporte_auditoria", DbType.Int32, DBNull.Value); } GenericDataAccess.AddInParameter(this.comm, "?P_si_no", DbType.Boolean, this._oSalida_transporte_condicion.Si_no); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oEntrada.Id); GenericDataAccess.AddInParameter(this.comm, "?P_id_bodega", DbType.Int32, this._oEntrada.Id_bodega); GenericDataAccess.AddInParameter(this.comm, "?P_bodega", DbType.String, this._oEntrada.Bodega); GenericDataAccess.AddInParameter(this.comm, "?P_folio", DbType.String, this._oEntrada.Folio); GenericDataAccess.AddInParameter(this.comm, "?P_folio_indice", DbType.String, this._oEntrada.Folio_indice); GenericDataAccess.AddInParameter(this.comm, "?P_fecha", DbType.DateTime, this._oEntrada.Fecha); if (this._oEntrada.Hora.Length == 0) { GenericDataAccess.AddInParameter(this.comm, "?P_hora", DbType.String, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_hora", DbType.String, this._oEntrada.Hora); } GenericDataAccess.AddInParameter(this.comm, "?P_id_cortina", DbType.Int32, this._oEntrada.Id_cortina); GenericDataAccess.AddInParameter(this.comm, "?P_cortina", DbType.String, this._oEntrada.Cortina); GenericDataAccess.AddInParameter(this.comm, "?P_id_cliente", DbType.Int32, this._oEntrada.Id_cliente); GenericDataAccess.AddInParameter(this.comm, "?P_cliente", DbType.String, this._oEntrada.Cliente); GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oEntrada.Referencia); GenericDataAccess.AddInParameter(this.comm, "?P_origen", DbType.String, this._oEntrada.Origen); GenericDataAccess.AddInParameter(this.comm, "?P_mercancia", DbType.String, this._oEntrada.Mercancia); GenericDataAccess.AddInParameter(this.comm, "?P_sello", DbType.String, this._oEntrada.Sello); GenericDataAccess.AddInParameter(this.comm, "?P_talon", DbType.String, this._oEntrada.Talon); GenericDataAccess.AddInParameter(this.comm, "?P_id_custodia", DbType.Int32, this._oEntrada.Id_custodia); GenericDataAccess.AddInParameter(this.comm, "?P_custodia", DbType.String, this._oEntrada.Custodia); GenericDataAccess.AddInParameter(this.comm, "?P_operador", DbType.String, this._oEntrada.Operador); GenericDataAccess.AddInParameter(this.comm, "?P_transporte_linea", DbType.String, this._oEntrada.Transporte_linea); GenericDataAccess.AddInParameter(this.comm, "?P_transporte_tipo", DbType.String, this._oEntrada.Transporte_tipo); GenericDataAccess.AddInParameter(this.comm, "?P_placa", DbType.String, this._oEntrada.Placa); GenericDataAccess.AddInParameter(this.comm, "?P_caja", DbType.String, this._oEntrada.Caja); GenericDataAccess.AddInParameter(this.comm, "?P_caja1", DbType.String, this._oEntrada.Caja1); GenericDataAccess.AddInParameter(this.comm, "?P_caja2", DbType.String, this._oEntrada.Caja2); GenericDataAccess.AddInParameter(this.comm, "?P_no_caja_cinta_aduanal", DbType.Int32, this._oEntrada.No_caja_cinta_aduanal); GenericDataAccess.AddInParameter(this.comm, "?P_no_pallet", DbType.Int32, this._oEntrada.No_pallet); GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_danado", DbType.Int32, this._oEntrada.No_bulto_danado); GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_abierto", DbType.Int32, this._oEntrada.No_bulto_abierto); GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_declarado", DbType.Int32, this._oEntrada.No_bulto_declarado); GenericDataAccess.AddInParameter(this.comm, "?P_no_pieza_declarada", DbType.Int32, this._oEntrada.No_pieza_declarada); GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_recibido", DbType.Int32, this._oEntrada.No_bulto_recibido); GenericDataAccess.AddInParameter(this.comm, "?P_no_pieza_recibida", DbType.Int32, this._oEntrada.No_pieza_recibida); GenericDataAccess.AddInParameter(this.comm, "?P_es_unica", DbType.Boolean, this._oEntrada.Es_unica); if (this._oEntrada.Hora_descarga.Length == 0) { GenericDataAccess.AddInParameter(this.comm, "?P_hora_descarga", DbType.String, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_hora_descarga", DbType.String, this._oEntrada.Hora_descarga); } GenericDataAccess.AddInParameter(this.comm, "?P_vigilante", DbType.String, this._oEntrada.Vigilante); GenericDataAccess.AddInParameter(this.comm, "?P_observaciones", DbType.String, this._oEntrada.Observaciones); GenericDataAccess.AddInParameter(this.comm, "?P_motivo_cancelacion", DbType.String, this._oEntrada.Motivo_cancelacion); GenericDataAccess.AddInParameter(this.comm, "?P_codigo", DbType.String, this._oEntrada.Codigo); GenericDataAccess.AddInParameter(this.comm, "?P_id_tipo_carga", DbType.Int32, this._oEntrada.Id_tipo_carga); GenericDataAccess.AddInParameter(this.comm, "?P_tipo_carga", DbType.String, this._oEntrada.Tipo_carga); //GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); //GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oEntrada.Id); //GenericDataAccess.AddInParameter(this.comm, "?P_id_bodega", DbType.Int32, this._oEntrada.Id_bodega); //GenericDataAccess.AddInParameter(this.comm, "?P_folio", DbType.String, this._oEntrada.Folio); //GenericDataAccess.AddInParameter(this.comm, "?P_folio_indice", DbType.String, this._oEntrada.Folio_indice); //GenericDataAccess.AddInParameter(this.comm, "?P_fecha", DbType.DateTime, this._oEntrada.Fecha); //GenericDataAccess.AddInParameter(this.comm, "?P_id_cortina", DbType.Int32, this._oEntrada.Id_cortina); //GenericDataAccess.AddInParameter(this.comm, "?P_id_cliente", DbType.Int32, this._oEntrada.Id_cliente); //GenericDataAccess.AddInParameter(this.comm, "?P_referencia", DbType.String, this._oEntrada.Referencia); //GenericDataAccess.AddInParameter(this.comm, "?P_origen", DbType.String, this._oEntrada.Origen); //GenericDataAccess.AddInParameter(this.comm, "?P_mercancia", DbType.String, this._oEntrada.Mercancia); //GenericDataAccess.AddInParameter(this.comm, "?P_sello", DbType.String, this._oEntrada.Sello); //GenericDataAccess.AddInParameter(this.comm, "?P_talon", DbType.String, this._oEntrada.Talon); //GenericDataAccess.AddInParameter(this.comm, "?P_id_custodia", DbType.Int32, this._oEntrada.Id_custodia); //GenericDataAccess.AddInParameter(this.comm, "?P_operador", DbType.String, this._oEntrada.Operador); //GenericDataAccess.AddInParameter(this.comm, "?P_no_caja_cinta_aduanal", DbType.Int32, this._oEntrada.No_caja_cinta_aduanal); //GenericDataAccess.AddInParameter(this.comm, "?P_no_pallet", DbType.Int32, this._oEntrada.No_pallet); //GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_danado", DbType.Int32, this._oEntrada.No_bulto_danado); //GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_abierto", DbType.Int32, this._oEntrada.No_bulto_abierto); //GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_declarado", DbType.Int32, this._oEntrada.No_bulto_declarado); //GenericDataAccess.AddInParameter(this.comm, "?P_no_pieza_declarada", DbType.Int32, this._oEntrada.No_pieza_declarada); //GenericDataAccess.AddInParameter(this.comm, "?P_no_bulto_recibido", DbType.Int32, this._oEntrada.No_bulto_recibido); //GenericDataAccess.AddInParameter(this.comm, "?P_no_pieza_recibida", DbType.Int32, this._oEntrada.No_pieza_recibida); //GenericDataAccess.AddInParameter(this.comm, "?P_es_unica", DbType.Boolean, this._oEntrada.Es_unica); //GenericDataAccess.AddInParameter(this.comm, "?P_vigilante", DbType.String, this._oEntrada.Vigilante); //GenericDataAccess.AddInParameter(this.comm, "?P_observaciones", DbType.String, this._oEntrada.Observaciones); //GenericDataAccess.AddInParameter(this.comm, "?P_motivo_cancelacion", DbType.String, this._oEntrada.Motivo_cancelacion); //GenericDataAccess.AddInParameter(this.comm, "?P_codigo", DbType.String, this._oEntrada.Codigo); //GenericDataAccess.AddInParameter(this.comm, "?P_id_tipo_carga", DbType.Int32, this._oEntrada.Id_tipo_carga); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oTarima_almacen_proveedor.Id); GenericDataAccess.AddInParameter(this.comm, "?P_nombre", DbType.String, this._oTarima_almacen_proveedor.Nombre); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oMercancia_unidad_empaque.Id); GenericDataAccess.AddInParameter(this.comm, "?P_nombre", DbType.String, this._oMercancia_unidad_empaque.Nombre); }
public static List <rptRemision> RemisionGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptRemision> lst = new List <rptRemision>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZRemision"); if (anio_ini == 1) { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, DBNull.Value); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(comm, "?P_anio_ini", DbType.Int32, anio_ini); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, dia_ini); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, anio_fin); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, dia_fin); } DataTable dt = GenericDataAccess.ExecuteSelectCommand(comm); foreach (DataRow dr in dt.Rows) { rptRemision o = new rptRemision(); o.Fecha_remision = Convert.ToDateTime(dr["fecha_remision"]); o.Folio_remision = dr["folio_remision"].ToString(); o.Aduana = dr["aduana"].ToString(); o.Referencia = dr["referencia"].ToString(); o.Orden = dr["orden_compra"].ToString(); o.Codigo = dr["codigo"].ToString(); o.Mercancia = dr["mercancia"].ToString(); o.Vendor = dr["vendor"].ToString(); o.Proveedor = dr["proveedor"].ToString(); o.Bultos = Convert.ToInt32(dr["bultos"]); o.Piezas = Convert.ToInt32(dr["piezas"]); DateTime.TryParse(dr["fecha_recibido"].ToString(), out fecha); o.Fecha_recibido = fecha; fecha = default(DateTime); o.Negocio = dr["negocio"].ToString(); o.Etiqueta_rr = dr["etiqueta_rr"].ToString(); DateTime.TryParse(dr["fecha_salida"].ToString(), out fecha); o.Fecha_salida = fecha; fecha = default(DateTime); o.Folio_salida = dr["folio_salida"].ToString(); bool.TryParse(dr["es_devolucion"].ToString(), out logica); o.Es_devolucion = logica; logica = false; lst.Add(o); } } catch { throw; } return(lst); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oTarima_almacen_trafico.Id); GenericDataAccess.AddInParameter(this.comm, "?P_fecha_solicitud", DbType.DateTime, this._oTarima_almacen_trafico.Fecha_solicitud); GenericDataAccess.AddInParameter(this.comm, "?P_fecha_carga_solicitada", DbType.DateTime, this._oTarima_almacen_trafico.Fecha_carga_solicitada); GenericDataAccess.AddInParameter(this.comm, "?P_hora_carga_solicitada", DbType.String, this._oTarima_almacen_trafico.Hora_carga_solicitada); if (this.O_Tarima_almacen_trafico.Id_transporte == null) { GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte", DbType.Int32, this._oTarima_almacen_trafico.Id_transporte); } GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte_tipo", DbType.Int32, this._oTarima_almacen_trafico.Id_transporte_tipo); if (this.O_Tarima_almacen_trafico.Id_transporte_tipo_cita == null) { GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte_tipo_cita", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_id_transporte_tipo_cita", DbType.Int32, this._oTarima_almacen_trafico.Id_transporte_tipo_cita); } GenericDataAccess.AddInParameter(this.comm, "?P_id_tipo_carga", DbType.Int32, this._oTarima_almacen_trafico.Id_tipo_carga); GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario_solicita", DbType.Int32, this._oTarima_almacen_trafico.Id_usuario_solicita); if (this.O_Tarima_almacen_trafico.Id_usuario_asigna == null) { GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario_asigna", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_id_usuario_asigna", DbType.Int32, this._oTarima_almacen_trafico.Id_usuario_asigna); } GenericDataAccess.AddInParameter(this.comm, "?P_id_salida_destino", DbType.Int32, this._oTarima_almacen_trafico.Id_salida_destino); GenericDataAccess.AddInParameter(this.comm, "?P_fecha_cita", DbType.DateTime, this._oTarima_almacen_trafico.Fecha_cita); GenericDataAccess.AddInParameter(this.comm, "?P_hora_cita", DbType.String, this._oTarima_almacen_trafico.Hora_cita); if (this._oTarima_almacen_trafico.Folio_cita == null) { GenericDataAccess.AddInParameter(this.comm, "?P_folio_cita", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_folio_cita", DbType.String, this._oTarima_almacen_trafico.Folio_cita); } GenericDataAccess.AddInParameter(this.comm, "?P_operador", DbType.String, this._oTarima_almacen_trafico.Operador); GenericDataAccess.AddInParameter(this.comm, "?P_placa", DbType.String, this._oTarima_almacen_trafico.Placa); GenericDataAccess.AddInParameter(this.comm, "?P_caja", DbType.String, this._oTarima_almacen_trafico.Caja); GenericDataAccess.AddInParameter(this.comm, "?P_caja1", DbType.String, this._oTarima_almacen_trafico.Caja1); GenericDataAccess.AddInParameter(this.comm, "?P_caja2", DbType.String, this._oTarima_almacen_trafico.Caja2); if (this.O_Tarima_almacen_trafico.Pallet == null) { GenericDataAccess.AddInParameter(this.comm, "?P_pallet", DbType.Int32, DBNull.Value); } else { GenericDataAccess.AddInParameter(this.comm, "?P_pallet", DbType.Int32, this._oTarima_almacen_trafico.Pallet); } }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oPersonal_tipo.Id); GenericDataAccess.AddInParameter(this.comm, "?P_nombre", DbType.String, this._oPersonal_tipo.Nombre); }
protected override void addParameters(int opcion) { GenericDataAccess.AddInParameter(this.comm, "?P_opcion", DbType.Int32, opcion); GenericDataAccess.AddInOutParameter(this.comm, "?P_id", DbType.Int32, this._oTransporte_condicion_categoria.Id); GenericDataAccess.AddInParameter(this.comm, "?P_nombre", DbType.String, this._oTransporte_condicion_categoria.Nombre); }