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