public void dltByIdTransporteTipo() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Transporte_tipo_transporte"); addParameters(7); GenericDataAccess.ExecuteNonQuery(this.comm); } catch { throw; } }
public override void udt() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Transporte_tipo_transporte"); addParameters(3); GenericDataAccess.ExecuteNonQuery(this.comm); } catch { throw; } }
public static List <rptPiso> PisoGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin, int id_bodega, int id_cuenta, int existencia) { List <rptPiso> lst = new List <rptPiso>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZPiso"); 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); } GenericDataAccess.AddInParameter(comm, "?P_bodega", DbType.Int32, id_bodega); GenericDataAccess.AddInParameter(comm, "?P_cuenta", DbType.Int32, id_cuenta); GenericDataAccess.AddInParameter(comm, "?P_existencia", DbType.Int32, existencia); DataTable dt = GenericDataAccess.ExecuteSelectCommand(comm); foreach (DataRow dr in dt.Rows) { rptPiso o = new rptPiso(); o.Bodega = dr["bodega"].ToString(); o.Referencia = dr["referencia"].ToString(); o.Cuenta = dr["cuenta"].ToString(); o.FechaEntrada = Convert.ToDateTime(dr["fecha"]); o.Pza_e = Convert.ToInt32(dr["pza_e"]); o.Bto_e = Convert.ToInt32(dr["bto_e"]); o.Tar_e = Convert.ToInt32(dr["tar_e"]); o.Pza_s = Convert.ToInt32(dr["pza_s"]); o.Bto_s = Convert.ToInt32(dr["bto_s"]); o.Tar_s = Convert.ToInt32(dr["tar_s"]); o.Pza_i = Convert.ToInt32(dr["pza_i"]); o.Bto_i = Convert.ToInt32(dr["bto_i"]); o.Tar_i = Convert.ToInt32(dr["tar_i"]); lst.Add(o); } } catch { throw; } return(lst); }
internal void getByIdEntrada(bool withDetail = true) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Entrada_inventario"); addParameters(withDetail ? 5 : 6); this.dt = GenericDataAccess.ExecuteSelectCommand(comm); this._lst = new List <Entrada_inventario>(); foreach (DataRow dr in dt.Rows) { Entrada_inventario o = new Entrada_inventario(); if (withDetail) { BindByDataRow(dr, o); //o.Ubicacion = dr["ubicacion"].ToString(); if (dr["consec"] != DBNull.Value) { int.TryParse(dr["consec"].ToString(), out entero); o.Consec = entero; entero = 0; } //o.Comprador = dr["comprador"].ToString(); o.Proveedor = dr["proveedor"].ToString(); o.Nom = dr["nom"].ToString(); } else { int.TryParse(dr["id"].ToString(), out entero); o.Id = entero; entero = 0; if (dr["id_entrada"] != DBNull.Value) { int.TryParse(dr["id_entrada"].ToString(), out entero); o.Id_entrada = entero; entero = 0; } o.Orden_compra = dr["orden_compra"].ToString(); o.Codigo = dr["codigo"].ToString(); o.Mercancia = dr["mercancia"].ToString(); o.Mercancia += Entrada_inventario_loteMng.getLotesByIdEntradaInventario(o.Id); } this._lst.Add(o); } } catch { throw; } }
public static List <rptMaquila> MaquilaGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptMaquila> lst = new List <rptMaquila>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZMaquila"); 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) { rptMaquila o = new rptMaquila(); o.FechaEntrada = Convert.ToDateTime(dr["fecha_entrada"]); o.Folio_entrada = dr["folio_entrada"].ToString(); o.Referencia = dr["referencia"].ToString(); o.Folio_ot = dr["folio_ot"].ToString(); o.Fecha_ot = Convert.ToDateTime(dr["fecha_ot"]); o.Ref_cte = dr["ref_cte"].ToString(); o.Supervisor = dr["supervisor"].ToString(); o.Servcio = dr["servicio"].ToString(); o.Etiqueta = dr["etiqueta"].ToString(); o.Ref_serv = dr["ref_serv"].ToString(); o.Pzas_sol = Convert.ToInt32(dr["pzas_sol"]); o.Fecha_maq = dr["fecha_maq"].ToString(); o.Piezas_maq = Convert.ToInt32(dr["piezas_maq"]); o.Bultos_maq = Convert.ToInt32(dr["bultos_maq"]); o.Pallets_maq = Convert.ToInt32(dr["pallets_maq"]); lst.Add(o); } } catch { throw; } return(lst); }
internal void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Usuario_cancelacion"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oUsuario_cancelacion.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public override void add() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Personal_foto"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm); this._oPersonal_foto.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
internal void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Salida_orden_carga_rem"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oSalida_orden_carga_rem.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public override void add() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Cliente_codigo_cancelado"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm); this._oCliente_codigo_cancelado.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Personal_registro_ext"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oPersonal_registro_ext.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public override void add() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Entrada_transporte_condicion"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm); this._oEntrada_transporte_condicion.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Cliente_copia_operacion"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oCliente_copia_operacion.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public override void add() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Salida_orden_carga_tc"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm); this._oSalida_orden_carga_tc.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public override void add() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Tarima_almacen_remision"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm); this._oTarima_almacen_remision.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public override void selById() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Folio"); addParameters(1); this.dt = GenericDataAccess.ExecuteSelectCommand(comm); if (dt.Rows.Count == 1) { DataRow dr = dt.Rows[0]; this._oFolio.Tipo = dr["tipo"].ToString(); if (dr["anio_actual"] != DBNull.Value) { int.TryParse(dr["anio_actual"].ToString(), out entero); this._oFolio.Anio_actual = entero; entero = 0; } if (dr["actual"] != DBNull.Value) { int.TryParse(dr["actual"].ToString(), out entero); this._oFolio.Actual = entero; entero = 0; } if (dr["digitos"] != DBNull.Value) { int.TryParse(dr["digitos"].ToString(), out entero); this._oFolio.Digitos = entero; entero = 0; } if (dr["folio_inicial"] != DBNull.Value) { int.TryParse(dr["folio_inicial"].ToString(), out entero); this._oFolio.Folio_inicial = entero; entero = 0; } } else if (dt.Rows.Count > 1) { throw new Exception("Error de integridad"); } else { throw new Exception("No existe información para el registro solicitado"); } } catch { throw; } }
internal void add(IDbTransaction tran) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Entrada_liverpool"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, tran); this._oEntrada_liverpool.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
internal void dltByCliente(int id_cliente, IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Cliente_copia_operacion"); this.O_Cliente_copia_operacion.Id_cliente = id_cliente; addParameters(6); GenericDataAccess.ExecuteNonQuery(this.comm); } catch { throw; } }
public void getFolio(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Folio"); addParameters(5); this.dt = GenericDataAccess.ExecuteSelectCommand(comm, trans); if (dt.Rows.Count == 1) { DataRow dr = dt.Rows[0]; this._oFolio.Tipo = dr["tipo"].ToString(); if (dr["anio_actual"] != DBNull.Value) { int.TryParse(dr["anio_actual"].ToString(), out entero); this._oFolio.Anio_actual = entero; entero = 0; } if (dr["actual"] != DBNull.Value) { int.TryParse(dr["actual"].ToString(), out entero); this._oFolio.Actual = entero; entero = 0; } if (dr["digitos"] != DBNull.Value) { int.TryParse(dr["digitos"].ToString(), out entero); this._oFolio.Digitos = entero; entero = 0; } if (dr["folio_inicial"] != DBNull.Value) { int.TryParse(dr["folio_inicial"].ToString(), out entero); this._oFolio.Folio_inicial = entero; entero = 0; } } else if (dt.Rows.Count > 1) { throw new Exception("Error de integridad"); } else { throw new Exception("No existe folios asigndos"); } } catch { throw; } }
public override void selById() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Entrada_parcial"); addParameters(1); this.dt = GenericDataAccess.ExecuteSelectCommand(comm); if (dt.Rows.Count == 1) { DataRow dr = dt.Rows[0]; if (dr["id_entrada"] != DBNull.Value) { int.TryParse(dr["id_entrada"].ToString(), out entero); this._oEntrada_parcial.Id_entrada = entero; entero = 0; } if (dr["id_usuario"] != DBNull.Value) { int.TryParse(dr["id_usuario"].ToString(), out entero); this._oEntrada_parcial.Id_usuario = entero; entero = 0; } if (dr["no_entrada"] != DBNull.Value) { int.TryParse(dr["no_entrada"].ToString(), out entero); this._oEntrada_parcial.No_entrada = entero; entero = 0; } this._oEntrada_parcial.Referencia = dr["referencia"].ToString(); if (dr["es_ultima"] != DBNull.Value) { bool.TryParse(dr["es_ultima"].ToString(), out logica); this._oEntrada_parcial.Es_ultima = logica; logica = false; } } else if (dt.Rows.Count > 1) { throw new Exception("Error de integridad"); } else { throw new Exception("No existe información para el registro solicitado"); } } catch { throw; } }
internal void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Tarima_almacen_resto"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oTarima_almacen_resto.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Entrada_aud_mer_files"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oEntrada_aud_mer_files.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); } catch { throw; } }
public static List <rptInvTotDia> RelInvTotDiaGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptInvTotDia> lst = new List <rptInvTotDia>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZRelInvTotDia"); 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) { rptInvTotDia o = new rptInvTotDia() { Fecha = Convert.ToDateTime(dr["fecha"]), Codigo = dr["codigo"].ToString(), Pallet = dr["pallet"].ToString(), Descripcion = dr["descripcion"].ToString(), Cajas = Convert.ToInt32(dr["cajas"]), Piezas = Convert.ToInt32(dr["piezas"]), Resto = Convert.ToInt32(dr["resto"]), Total_piezas = Convert.ToInt32(dr["total_piezas"]), Tarima = Convert.ToInt32(dr["tarima"]), Tipo = dr["tipo"].ToString(), Rr = dr["rr"].ToString(), Ubicacion = dr["ubicacion"].ToString(), Proveedor_origen = dr["proveedor_origen"].ToString() }; lst.Add(o); } } catch { throw; } return(lst); }
public DataTable getDataEntrada() { DataTable dt = new DataTable(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZRelEntradas"); if (this._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, this._anio_ini); GenericDataAccess.AddInParameter(comm, "?P_dia_ini", DbType.Int32, this._dia_ini); GenericDataAccess.AddInParameter(comm, "?P_anio_fin", DbType.Int32, this._anio_fin); GenericDataAccess.AddInParameter(comm, "?P_dia_fin", DbType.Int32, this._dia_fin); } if (this._idBodega != 0) { GenericDataAccess.AddInParameter(comm, "?P_id_bodega", DbType.Int32, this._idBodega); } else { GenericDataAccess.AddInParameter(comm, "?P_id_bodega", DbType.Int32, DBNull.Value); } if (this._idCliente != 0) { GenericDataAccess.AddInParameter(comm, "?P_id_cliente", DbType.Int32, this._idCliente); } else { GenericDataAccess.AddInParameter(comm, "?P_id_cliente", DbType.Int32, DBNull.Value); } dt = GenericDataAccess.ExecuteSelectCommand(comm); } catch { throw; } return(dt); }
public DataTable getDataSalida(int IdBodega, int IdCliente, int anio_ini, int dia_ini, int anio_fin, int dia_fin) { DataTable dt = new DataTable(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZCancSal"); 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); } if (IdBodega != 0) { GenericDataAccess.AddInParameter(comm, "?P_id_bodega", DbType.Int32, IdBodega); } else { GenericDataAccess.AddInParameter(comm, "?P_id_bodega", DbType.Int32, DBNull.Value); } if (IdCliente != 0) { GenericDataAccess.AddInParameter(comm, "?P_id_cliente", DbType.Int32, IdCliente); } else { GenericDataAccess.AddInParameter(comm, "?P_id_cliente", DbType.Int32, DBNull.Value); } dt = GenericDataAccess.ExecuteSelectCommand(comm); } catch { throw; } return(dt); }
public static List <rptProdDiario> ProdDiarioGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptProdDiario> lst = new List <rptProdDiario>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZProdDiario"); //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) { rptProdDiario o = new rptProdDiario() { Bodega = dr["bodega"].ToString(), Cuenta = dr["cuenta"].ToString(), Cliente = dr["cliente"].ToString(), Ot = dr["ot"].ToString(), Pedimento = dr["pedimento"].ToString(), Trafico = dr["trafico"].ToString(), Proceso = dr["proceso"].ToString(), Pza_sol = Convert.ToInt32(dr["pza_sol"]), Maq = Convert.ToInt32(dr["maq"]), Sin_proc = Convert.ToInt32(dr["sin_proc"]), Bultos = Convert.ToInt32(dr["bultos"]), Pallets = Convert.ToInt32(dr["pallets"]), }; lst.Add(o); } } catch { throw; } return(lst); }
public void add(IDbTransaction trans) { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Salida_parcial"); addParameters(2); GenericDataAccess.ExecuteNonQuery(this.comm, trans); this._oSalida_parcial.Id = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_id")); this._oSalida_parcial.No_salida = Convert.ToInt32(GenericDataAccess.getParameterValue(comm, "?P_no_salida")); } catch { throw; } }
public static List <rptRelDiaEnt> RelDiaEntGet(int anio_ini, int dia_ini, int anio_fin, int dia_fin) { List <rptRelDiaEnt> lst = new List <rptRelDiaEnt>(); try { IDbCommand comm = GenericDataAccess.CreateCommandSP("sp_ZRelDiaEnt"); 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) { rptRelDiaEnt o = new rptRelDiaEnt() { Rr = dr["rr"].ToString(), Proveedor = dr["proveedor"].ToString(), Referencia = dr["referencia"].ToString(), Fecha_ingreso = Convert.ToDateTime(dr["fecha_ingreso"]), Code = dr["code"].ToString(), Descripcion = dr["descripcion"].ToString(), Cantidad_piezas = Convert.ToInt32(dr["cantidad_piezas"]), Cantidad_tarimas = Convert.ToInt32(dr["cantidad_tarimas"]), Piezas_calidad = Convert.ToInt32(dr["piezas_calidad"]), Tipo_producto = dr["tipo_producto"].ToString(), Observaciones = dr["observaciones"].ToString(), Proveedor_origen = dr["proveedor_origen"].ToString() }; lst.Add(o); } } catch { throw; } return(lst); }
internal int udtVendor() { int success = -1; try { this.comm = GenericDataAccess.CreateCommandSP("sp_Entrada_inventario_cambios"); addParameters(7); success = GenericDataAccess.ExecuteNonQuery(this.comm); } catch { throw; } return(success); }
internal int GetNumCond() { int num; try { this.comm = GenericDataAccess.CreateCommandSP("sp_Transporte_condicion_cliente"); addParameters(6); num = Convert.ToInt32(GenericDataAccess.ExecuteScalar(this.comm)); } catch { throw; } return(num); }
internal int countByFolio(IDbTransaction trans) { int cantidad = -1; try { this.comm = GenericDataAccess.CreateCommandSP("sp_Salida_compartida"); addParameters(13); cantidad = Convert.ToInt32(GenericDataAccess.ExecuteScalar(this.comm, trans)); } catch { throw; } return(cantidad); }