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);
}
