public bool Borrar_registros(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_BorraxFiltro", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@fechini", SqlDbType.DateTime).Value = BE.fechini; cmd.Parameters.Add("@fechfin", SqlDbType.DateTime).Value = BE.fechfin; cmd.Parameters.Add("@tipmov", SqlDbType.Char).Value = BE.tipmov; cmd.Parameters.Add("@realpend", SqlDbType.Char).Value = BE.realpend; cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; cmd.Parameters.Add("@cencosid", SqlDbType.Char,5).Value = BE.cencosid; cmd.Parameters.Add("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid; cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio; cmd.Parameters.Add("@perimes", SqlDbType.Char, 2).Value = BE.perimes; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Delete(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@items", SqlDbType.Char, 5).Value = BE.items; cmd.Parameters.Add("@status", SqlDbType.Char).Value = BE.status; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_DocsPeriodo_rollo(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbTaMovimientosdet_SEARCH_DocsPeriodoRollo", cnx)) { DataSet ds = new DataSet(); { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@accion", SqlDbType.Char, 2).Value = BE.accion; cmd.Parameters.Add("@serref", SqlDbType.Char, 4).Value = BE.serref; cmd.Parameters.Add("@numref", SqlDbType.Char, 10).Value = BE.numref; cmd.Parameters.Add("@ser_op", SqlDbType.Char, 4).Value = BE.ser_op; cmd.Parameters.Add("@num_op", SqlDbType.Char, 10).Value = BE.num_op; cmd.Parameters.Add("@serguia", SqlDbType.Char, 4).Value = BE.serguia; cmd.Parameters.Add("@numguia", SqlDbType.Char, 10).Value = BE.numguia; cmd.Parameters.Add("@serfac", SqlDbType.Char, 4).Value = BE.serfac; cmd.Parameters.Add("@numfac", SqlDbType.Char, 10).Value = BE.numfac; cmd.Parameters.Add("@lineaid", SqlDbType.Char, 3).Value = BE.lineaid; cmd.Parameters.Add("@grupoid", SqlDbType.Char, 4).Value = BE.grupoid; cmd.Parameters.Add("@subgrupoid", SqlDbType.Char, 10).Value = BE.subgrupoid; cmd.Parameters.Add("@productid", SqlDbType.Char, 13).Value = BE.productid; cmd.Parameters.Add("@fechdocini", SqlDbType.DateTime).Value = BE.fechdocini; cmd.Parameters.Add("@fechdocfin", SqlDbType.DateTime).Value = BE.fechdocfin; cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private DataTable Movimiento_rollokardex() { try { var TablaRollokardex = new DataTable("Rollokardex"); var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = VariablesPublicas.Moduloid.Trim(); BE.local = VariablesPublicas.Local.Trim(); BE.lineaid = lineaid; BE.grupoid = grupoid; BE.subgrupoid = subgrupoid; BE.productid = productid; BE.colorid = colorid; BE.rollo = rollo; BE.fechdocini = Convert.ToDateTime(fechdocini.Trim().Substring(0, 10)); BE.fechdocfin = Convert.ToDateTime(fechdocfin.Trim().Substring(0, 10)); if (almacaccionid.Trim().Length > 0) { BE.almacaccionid = almacaccionid; } TablaRollokardex = BL.GetAll_rollokardex(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaRollokardex != null) { return TablaRollokardex; } else { return null; } } catch (Exception ex) { return null; } }
private DataTable Movimiento_mov_ordprod() { var TablaMov_ordprod = new DataTable("Productostock"); try { var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = moduloid.Trim(); BE.local = local.Trim(); BE.fechdocini = Convert.ToDateTime(fechdocini.Trim().Substring(0, 10)); BE.fechdocfin = Convert.ToDateTime(fechdocfin.Trim().Substring(0, 10)); if (serop_ini.Trim().Length > 0) { BE.ser_opi = serop_ini.Trim().PadLeft(4, '0'); } if (numop_ini.Trim().Length > 0) { BE.num_opi = numop_ini.Trim().PadLeft(10, '0'); } if (serop_fin.Trim().Length > 0) { BE.ser_opf = serop_fin.Trim().PadLeft(4, '0'); } if (numop_fin.Trim().Length > 0) { BE.num_opf = numop_fin.Trim().PadLeft(10, '0'); } if (almacaccionid.Trim().Length > 0) { BE.almacaccionid = almacaccionid; } TablaMov_ordprod = BL.GetAll_ConsumoxOP(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaMov_ordprod != null) { return TablaMov_ordprod; } else { return null; } } catch (Exception ex) { return null; } }
private DataTable Movimiento_mov_balancestock() { var TablaMov_balancestock = new DataTable("mov_balancestock"); try { var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = VariablesPublicas.Moduloid.Trim(); BE.local = VariablesPublicas.Local.Trim(); BE.perianio = VariablesPublicas.perianio.Trim(); BE.perimesini = VariablesPublicas.Perimesini.Trim(); BE.perimesfin = VariablesPublicas.Perimesfin.Trim(); BE.lineaid = lineaid.Trim(); BE.grupoid = grupoid.Trim(); BE.subgrupoid = subgrupoid.Trim(); BE.productidini = productidini.Trim(); BE.productidfin = productidfin.Trim(); if (accion) { BE.accion = "0"; } else { BE.accion = "1"; } TablaMov_balancestock = BL.GetAll_Balance(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaMov_balancestock != null) { return TablaMov_balancestock; } else { return null; } } catch (Exception ex) { return null; } }
public DataSet GetOne(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetOne(empresaid, BE); }
public DataSet GetAll_MpvProd(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_MpvProd(empresaid, BE); }
public DataSet GetAll_HistorialxProducto(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_HistorialxProducto(empresaid, BE); }
public DataSet Get_DocOP(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_SEARCH_docuOP", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@ser_op", SqlDbType.Char, 4).Value = BE.ser_op; cmd.Parameters.Add("@num_op", SqlDbType.Char, 10).Value = BE.num_op; cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_rollokardex(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_SEARCH_kardexRollo", cnx)) { DataSet ds = new DataSet(); { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@lineaid", SqlDbType.Char, 3).Value = BE.lineaid; cmd.Parameters.Add("@grupoid", SqlDbType.Char, 4).Value = BE.grupoid; cmd.Parameters.Add("@subgrupoid", SqlDbType.Char, 10).Value = BE.subgrupoid; cmd.Parameters.Add("@productid", SqlDbType.Char, 13).Value = BE.productid; cmd.Parameters.Add("@rollo", SqlDbType.Char, 10).Value = BE.rollo; cmd.Parameters.Add("@colorid", SqlDbType.Char, 3).Value = BE.colorid; cmd.Parameters.Add("@fechdocini", SqlDbType.DateTime).Value = BE.fechdocini; cmd.Parameters.Add("@fechdocfin", SqlDbType.DateTime).Value = BE.fechdocfin; cmd.Parameters.Add("@almacaccionid", SqlDbType.VarChar, 2).Value = BE.almacaccionid; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_Rango(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_SEARCH_Rango", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@productid", SqlDbType.Char, 13).Value = BE.productid; cmd.Parameters.Add("@perianioini", SqlDbType.Char, 4).Value = BE.perianioini; cmd.Parameters.Add("@perimesini", SqlDbType.Char, 2).Value = BE.perimesini; cmd.Parameters.Add("@perianiofin", SqlDbType.Char, 4).Value = BE.perianiofin; cmd.Parameters.Add("@perimesfin", SqlDbType.Char, 2).Value = BE.perimesfin; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_MpvProd(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_MOVPROD", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@status", SqlDbType.Char).Value = BE.status; cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; cmd.Parameters.Add("@productid", SqlDbType.Char, 13).Value = BE.productid; cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid; cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio; cmd.Parameters.Add("@perimes", SqlDbType.Char, 2).Value = BE.perimes; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
//GetAll_KardexEstacion public DataSet GetAll_KardexEstacion(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_SEARCH_kardexEstacion", cnx)) { DataSet ds = new DataSet(); { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@productid", SqlDbType.Char, 13).Value = BE.productid; cmd.Parameters.Add("@codigo", SqlDbType.Char, 8).Value = BE.codigo; cmd.Parameters.Add("@filtro", SqlDbType.Char, 1).Value = BE.filtro; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_Imprimir(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_SEARCH_Balance", cnx)) { DataSet ds = new DataSet(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; // 0320 cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; // 001 cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio; cmd.Parameters.Add("@perimesini", SqlDbType.Char, 2).Value = BE.perimesini; cmd.Parameters.Add("@perimesfin", SqlDbType.Char, 2).Value = BE.perimesfin; cmd.Parameters.Add("@lineaid", SqlDbType.Char, 3).Value = BE.lineaid; cmd.Parameters.Add("@grupoid", SqlDbType.Char, 4).Value = BE.grupoid; cmd.Parameters.Add("@subgrupoid", SqlDbType.Char, 10).Value = BE.subgrupoid; cmd.Parameters.Add("@productidini", SqlDbType.Char, 13).Value = BE.productidini; // rango del codigo de producto cmd.Parameters.Add("@productidfin", SqlDbType.Char, 13).Value = BE.productidfin; try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
// public DataSet GetAll_Docsemitidos(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_Docsemitidos(empresaid, BE); }
public DataSet GetAll_DocsPeriodo_rollo(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_DocsPeriodo_rollo(empresaid, BE); }
public DataSet ListadoComprasxModelo(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_SEARCH_compras", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@lineaid", SqlDbType.Char, 3).Value = BE.lineaid; cmd.Parameters.Add("@grupoid", SqlDbType.Char, 4).Value = BE.grupoid; cmd.Parameters.Add("@subgrupoid", SqlDbType.Char, 3).Value = BE.subgrupoid; cmd.Parameters.Add("@fechini", SqlDbType.DateTime).Value = BE.fechdocini; cmd.Parameters.Add("@fechfin", SqlDbType.DateTime).Value = BE.fechdocfin; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_KardexEstacion(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_KardexEstacion(empresaid, BE); }
public bool Update(string empresaid, tb_me_movimientosdet BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbMeMovimientosdet_UPDATE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@items", SqlDbType.Char, 5).Value = BE.items; cmd.Parameters.Add("@status", SqlDbType.Char).Value = BE.status; cmd.Parameters.Add("@diarioid", SqlDbType.Char, 4).Value = BE.diarioid; cmd.Parameters.Add("@asiento", SqlDbType.Char, 6).Value = BE.asiento; cmd.Parameters.Add("@asientoitems", SqlDbType.Char, 5).Value = BE.asientoitems; cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid; cmd.Parameters.Add("@tipoperacionid", SqlDbType.Char, 2).Value = BE.tipoperacionid; cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; cmd.Parameters.Add("@ctactename", SqlDbType.VarChar, 70).Value = BE.ctactename; cmd.Parameters.Add("@ctacteaccionid", SqlDbType.Char, 2).Value = BE.ctacteaccionid; cmd.Parameters.Add("@direcnume", SqlDbType.VarChar, 3).Value = BE.direcnume; cmd.Parameters.Add("@direcname", SqlDbType.VarChar, 25).Value = BE.direcname; cmd.Parameters.Add("@productid", SqlDbType.Char, 13).Value = BE.productid; cmd.Parameters.Add("@productname", SqlDbType.Char, 70).Value = BE.productname; cmd.Parameters.Add("@rollo", SqlDbType.Char, 10).Value = BE.rollo; cmd.Parameters.Add("@fechdoc", SqlDbType.DateTime).Value = BE.fechdoc; cmd.Parameters.Add("@itemref", SqlDbType.Char, 5).Value = BE.itemref; cmd.Parameters.Add("@cantidad", SqlDbType.Decimal).Value = BE.cantidad; cmd.Parameters.Add("@valor", SqlDbType.Decimal).Value = BE.valor; cmd.Parameters.Add("@importe", SqlDbType.Decimal).Value = BE.importe; cmd.Parameters.Add("@cantidadcta", SqlDbType.Decimal).Value = BE.cantidadcta; cmd.Parameters.Add("@cantidadfac", SqlDbType.Decimal).Value = BE.cantidadfac; cmd.Parameters.Add("@precioanterior", SqlDbType.Decimal).Value = BE.precioanterior; cmd.Parameters.Add("@precunit", SqlDbType.Decimal).Value = BE.precunit; cmd.Parameters.Add("@importfac", SqlDbType.Decimal).Value = BE.importfac; cmd.Parameters.Add("@dscto1", SqlDbType.Decimal).Value = BE.dscto1; cmd.Parameters.Add("@dscto2", SqlDbType.Decimal).Value = BE.dscto2; cmd.Parameters.Add("@dscto3", SqlDbType.Decimal).Value = BE.dscto3; cmd.Parameters.Add("@tipref", SqlDbType.Char, 2).Value = BE.tipref; cmd.Parameters.Add("@serref", SqlDbType.Char, 4).Value = BE.serref; cmd.Parameters.Add("@numref", SqlDbType.Char, 10).Value = BE.numref; cmd.Parameters.Add("@fechref", SqlDbType.DateTime).Value = BE.fechref; cmd.Parameters.Add("@tipoperef", SqlDbType.Char, 2).Value = BE.tipoperef; cmd.Parameters.Add("@tip_op", SqlDbType.Char, 2).Value = BE.tip_op; cmd.Parameters.Add("@ser_op", SqlDbType.Char, 4).Value = BE.ser_op; cmd.Parameters.Add("@num_op", SqlDbType.Char, 10).Value = BE.num_op; cmd.Parameters.Add("@tipfac", SqlDbType.Char, 2).Value = BE.tipfac; cmd.Parameters.Add("@serfac", SqlDbType.Char, 4).Value = BE.serfac; cmd.Parameters.Add("@numfac", SqlDbType.Char, 10).Value = BE.numfac; cmd.Parameters.Add("@fechfac", SqlDbType.DateTime).Value = BE.fechfac; cmd.Parameters.Add("@tipguia", SqlDbType.Char, 2).Value = BE.tipguia; cmd.Parameters.Add("@serguia", SqlDbType.Char, 4).Value = BE.serguia; cmd.Parameters.Add("@numguia", SqlDbType.Char, 10).Value = BE.numguia; cmd.Parameters.Add("@fechguia", SqlDbType.DateTime).Value = BE.fechguia; cmd.Parameters.Add("@tipnotac", SqlDbType.Char, 2).Value = BE.tipnotac; cmd.Parameters.Add("@sernotac", SqlDbType.Char, 4).Value = BE.sernotac; cmd.Parameters.Add("@numnotac", SqlDbType.Char, 10).Value = BE.numnotac; cmd.Parameters.Add("@fechnotac", SqlDbType.DateTime).Value = BE.fechnotac; cmd.Parameters.Add("@cencosid", SqlDbType.Char, 5).Value = BE.cencosid; cmd.Parameters.Add("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid; cmd.Parameters.Add("@moneda", SqlDbType.Char, 1).Value = BE.moneda; cmd.Parameters.Add("@tcamb", SqlDbType.Decimal).Value = BE.tcamb; cmd.Parameters.Add("@tiptransac", SqlDbType.Char, 1).Value = BE.tiptransac; cmd.Parameters.Add("@motivotrasladoid", SqlDbType.Char, 2).Value = BE.motivotrasladoid; cmd.Parameters.Add("@mottrasladointid", SqlDbType.Char, 2).Value = BE.mottrasladointid; cmd.Parameters.Add("@statcostopromed", SqlDbType.Char, 1).Value = BE.statcostopromed; cmd.Parameters.Add("@incprec", SqlDbType.Char, 1).Value = BE.incprec; cmd.Parameters.Add("@igv", SqlDbType.Decimal).Value = BE.igv; cmd.Parameters.Add("@totimpto", SqlDbType.Decimal).Value = BE.totimpto; cmd.Parameters.Add("@glosa", SqlDbType.VarChar, 30).Value = BE.glosa; cmd.Parameters.Add("@statdigitadoprec", SqlDbType.Char, 1).Value = BE.statdigitadoprec; cmd.Parameters.Add("@aniosemana", SqlDbType.Char, 7).Value = BE.aniosemana; cmd.Parameters.Add("@aniosemanaconfirm", SqlDbType.Char, 7).Value = BE.aniosemanaconfirm; cmd.Parameters.Add("@codctadebe", SqlDbType.Char, 10).Value = BE.codctadebe; cmd.Parameters.Add("@codctahaber", SqlDbType.Char, 10).Value = BE.codctahaber; cmd.Parameters.Add("@fechentrega", SqlDbType.DateTime).Value = BE.fechentrega; cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio; cmd.Parameters.Add("@perimes", SqlDbType.Char, 2).Value = BE.perimes; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_rollokardex(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_rollokardex(empresaid, BE); }
public bool Insert(string empresaid, tb_me_movimientosdet BE) { return tablaDA.Insert(empresaid, BE); }
private void ImpresionKardexArticulo() { var TablaProductokardex_tela = new DataTable(); var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = modulo; BE.local = local; BE.lineaid = lineaid.Text.Trim(); BE.grupoid = grupoid.Text.Trim(); BE.subgrupoid = subgrupoid.Text.Trim(); BE.productid = productid.Text.Trim(); BE.colorid = colorid.Text.Trim(); BE.mottrasladointid = mottrasladointid.Text.Trim(); BE.Ubicacion = produbic.Text.Trim(); BE.ctacte = ctacte.Text.Trim(); BE.direcnume = direcnume.ToString(); BE.fechdocini = Convert.ToDateTime(fechdocini.Text.Substring(0, 10)); BE.fechdocfin = Convert.ToDateTime(fechdocfin.Text.Substring(0, 10)); BE.serref = serref.Text.Trim(); BE.numref = numdococ1.Text.Trim() + numdococ.Text.Trim(); if (almacaccionid.SelectedValue.ToString() != string.Empty) { BE.almacaccionid = almacaccionid.SelectedValue.ToString(); } TablaProductokardex_tela = BL.GetAll_productokardex(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaProductokardex_tela.Rows.Count == 0) { MessageBox.Show("No existe Información Procesada", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { var miForma = new Frm_Reportes(); var reporteRollokardex = new REPORTES.CR_productokardex(); miForma.Text = "Reporte de Kardex x Articulo"; reporteRollokardex.DataDefinition.FormulaFields["fechdoc"].Text = "'DE: " + fechdocini.Text.Substring(0, 10) + " AL:" + fechdocfin.Text.Substring(0, 10) + "'"; reporteRollokardex.DataDefinition.FormulaFields["almacen"].Text = "'" + VariablesPublicas.EmpresaTipo + "'"; if (modulo.Trim() == "0810") { reporteRollokardex.DataDefinition.FormulaFields["name"].Text = "'TIENDA : " + VariablesPublicas.Local + " - " + VariablesPublicas.nombrelocal + "'"; } else { reporteRollokardex.DataDefinition.FormulaFields["name"].Text = "'LOCAL : " + VariablesPublicas.Local + " - " + VariablesPublicas.nombrelocal + "'"; } if (modulo == "0320") { reporteRollokardex.DataDefinition.FormulaFields["varitems"].Text = "'ROLLO'"; } else { reporteRollokardex.DataDefinition.FormulaFields["varitems"].Text = "''"; } miForma.Table = TablaProductokardex_tela; miForma.Reporte = reporteRollokardex; miForma.Show(); } }
public DataSet ListadoComprasxModelo(string empresaid, tb_me_movimientosdet BE) { return tablaDA.ListadoComprasxModelo(empresaid, BE); }
private DataTable Movimiento_mov_docsemitido() { var TablaMov_docsemitido = new DataTable("Mov_docsemitido"); try { var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = moduloid.Trim(); BE.local = local.Trim(); if (tipdoc != null && tipdoc.Trim().Length > 0) { BE.tipodoc = tipdoc.Trim(); } BE.mottrasladointid = mottrasladointid.Trim(); BE.ctacte = ctacte.Trim(); BE.fechdocini = Convert.ToDateTime(fechdocini.Trim().Substring(0, 10)); BE.fechdocfin = Convert.ToDateTime(fechdocfin.Trim().Substring(0, 10)); BE.modcalculo = modcalculo; BE.accion = almacaccionid.Trim(); TablaMov_docsemitido = BL.GetAll_Docsemitidos(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaMov_docsemitido != null) { return TablaMov_docsemitido; } else { return null; } } catch (Exception ex) { return null; } }
public bool Borrar_registros(string empresaid, tb_me_movimientosdet BE) { return tablaDA.Borrar_registros(empresaid, BE); }
private DataTable Movimiento_productokardex_tela() { var TablaProductokardex_tela = new DataTable("Productokardex_tela"); try { var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = moduloid.Trim(); BE.local = local.Trim(); BE.lineaid = lineaid; BE.grupoid = grupoid; BE.subgrupoid = subgrupoid; BE.productid = productid; BE.colorid = colorid; BE.rollo = rollo; BE.mottrasladointid = mottrasladointid; BE.Ubicacion = Produbic; BE.ctacte = ctacte; BE.direcnume = direcnume; BE.fechdocini = Convert.ToDateTime(fechdocini.Trim().Substring(0, 10)); BE.fechdocfin = Convert.ToDateTime(fechdocfin.Trim().Substring(0, 10)); if (almacaccionid.Trim().Length > 0) { BE.almacaccionid = almacaccionid; } TablaProductokardex_tela = BL.GetAll_productokardex(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaProductokardex_tela != null) { return TablaProductokardex_tela; } else { return null; } } catch (Exception ex) { return null; } }
public bool Delete(string empresaid, tb_me_movimientosdet BE) { return tablaDA.Delete(empresaid, BE); }
private DataTable Listado_ComprasxModelo() { var TablaListadoComprasxModelo = new DataTable("TablaListadoComprasxModelo"); try { var BL = new tb_me_movimientosdetBL(); var BE = new tb_me_movimientosdet(); BE.moduloid = moduloid.Trim(); BE.lineaid = lineaid; BE.grupoid = grupoid; BE.subgrupoid = subgrupoid; BE.fechdocini = Convert.ToDateTime(fechdocini); BE.fechdocfin = Convert.ToDateTime(fechdocfin); TablaListadoComprasxModelo = BL.ListadoComprasxModelo(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaListadoComprasxModelo != null) { return TablaListadoComprasxModelo; } else { return TablaListadoComprasxModelo; } } catch (Exception ex) { throw ex; } }
public DataSet GetAll_ConsumoxOP(string empresaid, tb_me_movimientosdet BE) { return tablaDA.GetAll_ConsumoxOP(empresaid, BE); }