public bool Delete(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd1 = new SqlCommand("gspTbAdMovimientos_DELETE", cnx)) { cmd1.CommandTimeout = 0; cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd1.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd1.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd1.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd1.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd1.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status; cmd1.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; try { cnx.Open(); if (cmd1.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private void data_Tabladetallemovmov_referencia() { try { Decimal xxprecventa = 0; Decimal xxcostoultimo = 0; Decimal xxstock = 0; Decimal xxcostopromed = 0; griddetallemov.AutoGenerateColumns = false; var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); var dt = new DataTable(); BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipfac.Text.Trim(); BE.serdoc = serfac.Text.Trim().PadLeft(4, '0'); BE.numdoc = numfac.Text.Trim().PadLeft(6, '0'); dt = null; //BL.GetAll_datosdetalle(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { statcostopromed = dt.Rows[0]["statcostopromed"].ToString(); tiptransac = dt.Rows[0]["tiptransac"].ToString(); incprec = dt.Rows[0]["incprec"].ToString().Trim(); } if (Tabladetallemov != null) { Tabladetallemov.Clear(); } foreach (DataRow fila in dt.Rows) { var BL2 = new tb_ad_local_stockBL(); var BE2 = new tb_ad_local_stock(); var dt2 = new DataTable(); BE2.moduloid = modulo; BE2.productid = fila["productid"].ToString(); dt2.Clear(); dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; if (dt2.Rows.Count > 0) { if (almacaccionid.Trim() == "20" || almacaccionid.Trim() == "21") { lbl_valor.Text = "Cost.Prom"; xxprecventa = 0; xxcostopromed = Convert.ToDecimal(dt2.Rows[0]["costopromed"]); } else { if (almacaccionid.Trim() == "10" || almacaccionid.Trim() == "11") { lbl_valor.Text = "Cost.Ultm"; xxcostoultimo = Convert.ToDecimal(dt2.Rows[0]["costoultimo"]); } } xxstock = Convert.ToDecimal(dt2.Rows[0]["stock"]); } row = Tabladetallemov.NewRow(); row["itemref"] = fila["itemref"].ToString(); row["items"] = fila["items"].ToString(); row["productid"] = fila["productid"].ToString().Trim(); row["productname"] = fila["productname"].ToString().Trim(); row["rollo"] = fila["rollo"].ToString(); row["stock"] = xxstock; row["stock_old"] = xxstock; row["precventa"] = xxprecventa; row["costoultimo"] = xxcostoultimo; row["costopromed"] = xxcostopromed; var cantidad = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4); var cantidadcta = Math.Round(Convert.ToDecimal(fila["cantidadcta"]), 4); Decimal total; total = cantidad - cantidadcta; row["cantidad"] = total; row["cantidad_old"] = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4); row["precunit"] = Math.Round(Convert.ToDecimal(Convert.ToDecimal(fila["precunit"]).ToString("###,###,##0.000000")), 6); row["importfac"] = Math.Round(Convert.ToDecimal(fila["importfac"]), 2); row["valor"] = Math.Round(Convert.ToDecimal(fila["valor"]), 6); row["importe"] = Math.Round(Convert.ToDecimal(fila["importe"]), 6); row["totimpto"] = Math.Round(Math.Round(Convert.ToDecimal(fila["importe"]), 6) * (Convert.ToDecimal(18) / 100), 6); row["almacaccionid"] = almacaccionid.Trim(); row["unmed"] = fila["unmed"].ToString().Trim(); row["ubicacion"] = fila["ubicacion"].ToString().Trim(); row["nostock"] = xnostock; Tabladetallemov.Rows.Add(row); } griddetallemov.DataSource = Tabladetallemov; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataSet GetAll(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbTaMovimientoscab_SEARCH", 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, 1).Value = BE.status; cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid; cmd.Parameters.Add("@tipoperacionid", SqlDbType.Char, 2).Value = BE.tipoperacionid; cmd.Parameters.Add("@ctacteaccionid", SqlDbType.Char, 2).Value = BE.ctacteaccionid; //cmd.Parameters.Add("@fechdoc", SqlDbType.DateTime).Value = BE.fechdoc; cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; cmd.Parameters.Add("@ctactename", SqlDbType.VarChar, 70).Value = BE.ctactename; cmd.Parameters.Add("@direcnume", SqlDbType.Char, 6).Value = BE.direcnume; cmd.Parameters.Add("@direcname", SqlDbType.VarChar, 25).Value = BE.direcname; cmd.Parameters.Add("@direcdeta", SqlDbType.VarChar, 70).Value = BE.direcdeta; cmd.Parameters.Add("@tipdid", SqlDbType.Char, 1).Value = BE.tipdid; cmd.Parameters.Add("@nmruc", SqlDbType.Char, 11).Value = BE.nmruc; 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("@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("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid; cmd.Parameters.Add("@cencosid", SqlDbType.Char, 5).Value = BE.cencosid; //cmd.Parameters.Add("@dscto3", SqlDbType.Decimal).Value = BE.dscto3; //cmd.Parameters.Add("@totdscto1", SqlDbType.Decimal).Value = BE.totdscto1; //cmd.Parameters.Add("@totdscto2", SqlDbType.Decimal).Value = BE.totdscto2; //cmd.Parameters.Add("@totdscto3", SqlDbType.Decimal).Value = BE.totdscto3; cmd.Parameters.Add("@condpago", SqlDbType.Char, 4).Value = BE.condpago; //cmd.Parameters.Add("@transporte", SqlDbType.Decimal).Value = BE.transporte; //cmd.Parameters.Add("@embalaje", SqlDbType.Decimal).Value = BE.embalaje; //cmd.Parameters.Add("@otros", SqlDbType.Decimal).Value = BE.otros; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; //cmd.Parameters.Add("@igv", SqlDbType.Decimal).Value = BE.igv; cmd.Parameters.Add("@incprec", SqlDbType.Char, 1).Value = BE.incprec; //cmd.Parameters.Add("@totimpto", SqlDbType.Decimal).Value = BE.totimpto; //cmd.Parameters.Add("@valventa", SqlDbType.Decimal).Value = BE.valventa; //cmd.Parameters.Add("@totimporte", SqlDbType.Decimal).Value = BE.totimporte; //cmd.Parameters.Add("@bruto", SqlDbType.Decimal).Value = BE.bruto; //cmd.Parameters.Add("@cargo", SqlDbType.Decimal).Value = BE.cargo; //cmd.Parameters.Add("@abono", SqlDbType.Decimal).Value = BE.abono; //cmd.Parameters.Add("@tcamb", SqlDbType.Decimal).Value = BE.tcamb; cmd.Parameters.Add("@glosa", SqlDbType.VarChar, 300).Value = BE.glosa; //cmd.Parameters.Add("@totpzas", SqlDbType.Decimal).Value = BE.totpzas; //cmd.Parameters.Add("@fechentrega", SqlDbType.DateTime).Value = BE.fechentrega; //cmd.Parameters.Add("@fechpago", SqlDbType.DateTime).Value = BE.fechpago; //cmd.Parameters.Add("@fechcancel", SqlDbType.DateTime).Value = BE.fechcancel; cmd.Parameters.Add("@moneda", SqlDbType.Char).Value = BE.moneda; cmd.Parameters.Add("@transpid", SqlDbType.Char, 5).Value = BE.transpid; cmd.Parameters.Add("@transpname", SqlDbType.VarChar, 40).Value = BE.transpname; cmd.Parameters.Add("@motivotrasladoid", SqlDbType.Char, 2).Value = BE.motivotrasladoid; cmd.Parameters.Add("@mottrasladointid", SqlDbType.Char, 2).Value = BE.mottrasladointid; //cmd.Parameters.Add("@items", SqlDbType.Decimal).Value = BE.items; 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(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Update(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbAdMovimientos_UPDATE", cnx)) { 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("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status; cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid; cmd.Parameters.Add("@tipoperacionid", SqlDbType.Char, 2).Value = BE.tipoperacionid; cmd.Parameters.Add("@ctacteaccionid", SqlDbType.Char, 2).Value = BE.ctacteaccionid; cmd.Parameters.Add("@fechdoc", SqlDbType.DateTime).Value = fecha(BE.fechdoc); cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; cmd.Parameters.Add("@ctactename", SqlDbType.VarChar, 70).Value = BE.ctactename; cmd.Parameters.Add("@direcnume", SqlDbType.Char, 6).Value = BE.direcnume; cmd.Parameters.Add("@direcname", SqlDbType.VarChar, 25).Value = BE.direcname; cmd.Parameters.Add("@direcdeta", SqlDbType.VarChar, 70).Value = BE.direcdeta; cmd.Parameters.Add("@tipdid", SqlDbType.Char, 1).Value = BE.tipdid; cmd.Parameters.Add("@nmruc", SqlDbType.Char, 11).Value = BE.nmruc; 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 = fecha(BE.fechref); 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("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid; cmd.Parameters.Add("@cencosid", SqlDbType.Char, 5).Value = BE.cencosid; cmd.Parameters.Add("@totdscto1", SqlDbType.Decimal).Value = BE.totdsctoEmp; cmd.Parameters.Add("@totdscto2", SqlDbType.Decimal).Value = BE.totdsctoTar; cmd.Parameters.Add("@totdscto3", SqlDbType.Decimal).Value = BE.totdsctoAdd; cmd.Parameters.Add("@condpago", SqlDbType.Char, 4).Value = BE.condpago; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; cmd.Parameters.Add("@igv", SqlDbType.Decimal).Value = BE.tasaigv; cmd.Parameters.Add("@incprec", SqlDbType.Char, 1).Value = BE.incprec; cmd.Parameters.Add("@totimpto", SqlDbType.Decimal).Value = BE.totimpto; cmd.Parameters.Add("@valventa", SqlDbType.Decimal).Value = BE.valventa; cmd.Parameters.Add("@totimporte", SqlDbType.Decimal).Value = BE.totimporte; cmd.Parameters.Add("@tcamb", SqlDbType.Decimal).Value = BE.tcamb; cmd.Parameters.Add("@glosa", SqlDbType.VarChar, 300).Value = BE.glosa; cmd.Parameters.Add("@totpzas", SqlDbType.Decimal).Value = BE.totpzas; cmd.Parameters.Add("@moneda", SqlDbType.Char).Value = BE.moneda; cmd.Parameters.Add("@transpid", SqlDbType.Char, 5).Value = BE.transpid; cmd.Parameters.Add("@transpname", SqlDbType.VarChar, 40).Value = BE.transpname; cmd.Parameters.Add("@motivotrasladoid", SqlDbType.Char, 2).Value = BE.motivotrasladoid; cmd.Parameters.Add("@mottrasladointid", SqlDbType.Char, 2).Value = BE.mottrasladointid; cmd.Parameters.Add("@items", SqlDbType.Decimal).Value = BE.items; 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; cmd.Parameters.Add("@tarjimporte1", SqlDbType.Decimal).Value = BE.tarjimporte; cmd.Parameters.Add("@efectivo", SqlDbType.Decimal).Value = BE.efectivo; /***************************************************************************************/ // cmd.Parameters.Add("@XMLnew", SqlDbType.Xml).Value = BE.GetItemXML(); cmd.Parameters.Add("@XMLold", SqlDbType.Xml).Value = BE.GetItemXML2(); if (BE.tipodoc == "BV" || BE.tipodoc == "FA") { cmd.Parameters.Add("@XMLT", SqlDbType.Xml).Value = BE.TarjetasXML(); } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet Sunat141_RegVentas(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbAdMovimientos_Sunat141_RegVentas", 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("@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); } } } }
public DataSet GetAll_paginacion(string empresaid, tb_ad_movimientos BE) { return tablaDA.GetAll_paginacion(empresaid, BE); }
private void Update() { _cal_Igv(); try { if (cabecera_valida()) { #region Datos de Cabecera var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); var Detalle = new tb_ad_movimientos.Item(); var ListaItems = new List<tb_ad_movimientos.Item>(); var Detalle2 = new tb_ad_movimientos.Tarjetas(); var ListaTarjetas = new List<tb_ad_movimientos.Tarjetas>(); BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipodoc.SelectedValue.ToString(); BE.serdoc = serdoc.Text.Trim(); BE.numdoc = numdoc.Text.ToString(); BE.fechdoc = Convert.ToDateTime(fechdoc.Text); BE.moneda = moneda.SelectedValue.ToString().Trim(); BE.tcamb = Convert.ToDecimal(tcamb.Text.Trim()); if (tipguia.Text.Trim().Length > 0 && serguia.Text.Trim().Length > 0 && numguia.Text.Trim().Length > 0) { almacaccionid = "21"; BE.almacaccionid = almacaccionid.ToString(); } else { BE.almacaccionid = almacaccionid.Trim(); } BE.tipoperacionid = tip_operacion.ToString(); BE.ctacteaccionid = string.Empty; BE.ctacte = ctacte.Text.Trim().ToUpper(); BE.nmruc = nmruc.Text.Trim(); BE.ctactename = ctactename.Text.Trim().ToUpper(); BE.direcnume = direcnume.Trim().ToUpper(); BE.vendorid = vendperid.Text.ToString(); if (serfac.Text.Trim().Length > 0 && numfac.Text.Trim().Length > 0) { BE.tipfac = tipfac.SelectedItem.ToString(); BE.serfac = serfac.Text.Trim().ToString().PadLeft(4, '0'); BE.numfac = numfac.Text.Trim().ToString().PadLeft(10, '0'); if (!fechfac.IsEmpty) { BE.fechfac = Convert.ToDateTime(fechfac.Text.Trim()); } //BE.recep_name = recep_name.Text.Trim(); //BE.recep_dni = recep_dni.Text.Trim(); //if (!recep_fecha.IsEmpty) //{ // BE.recep_fecha = Convert.ToDateTime(recep_fecha.Text.Trim()); //} } if (serguia.Text.Trim().Length > 0 && numguia.Text.Trim().Length > 0) { BE.tipguia = tipguia.Text.Trim(); BE.serguia = serguia.Text.Trim().ToString().PadLeft(4, '0'); BE.numguia = numguia.Text.Trim().ToString().PadLeft(10, '0'); if (!fechguia.IsEmpty) { BE.fechguia = Convert.ToDateTime(fechguia.Text.Trim()); } } if (sernotac.Text.Trim().Length > 0 && numnotac.Text.Trim().Length > 0) { BE.tipnotac = tipnotac.Text.Trim(); BE.sernotac = sernotac.Text.Trim().ToString().PadLeft(4, '0'); BE.numnotac = numnotac.Text.Trim().ToString().PadLeft(10, '0'); if (!fechnotac.IsEmpty) { BE.fechnotac = Convert.ToDateTime(fechnotac.Text.Trim()); } } BE.tipimptoid = tipimptotasa.SelectedValue.ToString().Trim(); BE.incprec = Equivalencias.Left(cbo_incprec.Text.Trim(), 1); BE.items = Convert.ToDecimal(itemsT.Text.Trim()); BE.totpzas = Convert.ToDecimal(totpzas.Text.Trim()); BE.tasaigv = igv; BE.totimpto = Convert.ToDecimal(totimpto.Text.Trim()); BE.valventa = Convert.ToDecimal(valventa.Text.Trim()); BE.totimporte = Convert.ToDecimal(totimporte.Text.Trim()); BE.glosa = glosa.Text.Trim().ToUpper().ToString(); // Venta en Combo // BE.princombo = princombo.Checked; // BE.cantcombo = Convert.ToInt32(canticombo.Text.ToString()); // BE.preccombo = Convert.ToDecimal(preccombo.Text.ToString()); // //try //{ // BE.fechcancel = Convert.ToDateTime("01/01/1900"); //} //catch //{ // BE.fechcancel = Convert.ToDateTime("01/01/1900"); //} BE.tipdid = string.Empty; //BE.statborrado = string.Empty; //BE.clientetipo = string.Empty; //BE.modofactu = string.Empty; //BE.tipodocmanejaserie = tipodocmanejaserie; BE.ncaja = _cajanume.ToString(); BE.perianio = fechdoc.Value.Year.ToString(); BE.perimes = fechdoc.Value.Month.ToString().PadLeft(2, '0'); BE.status = "0"; BE.usuar = VariablesPublicas.Usuar; // Agregando Datos de Cabecera if (TablaTarjetas.Rows.Count > 0) { //BE.Tarjetaid = Convert.ToInt32(TablaTarjetas.Rows[0]["tarjetaid"].ToString()); //BE.Tarjnumoper = TablaTarjetas.Rows[0]["tarjetanume"].ToString(); BE.tarjimporte = Convert.ToDecimal(importtarj.Text); } if (txtefectivo.Text.Length > 0) { BE.efectivo = Convert.ToDecimal(txtefectivo.Text); } else { BE.efectivo = 0; } #endregion /*****************************************************/ #region Movimientos - Detalle var item = 0; foreach (DataRow fila in Tabladetallemov.Rows) { Detalle = new tb_ad_movimientos.Item(); item++; Detalle.fechdoc = Convert.ToDateTime(fechdoc.Text); Detalle.tipoperacionid = "01"; Detalle.ctacte = ctacte.Text.Trim().ToUpper(); Detalle.direcnume = direcnume.Trim().ToUpper(); Detalle.itemref = fila["itemref"].ToString(); Detalle.productid = fila["productid"].ToString(); Detalle.productname = fila["productname"].ToString(); Detalle.ubicacion = fila["ubicacion"].ToString(); Detalle.unmed = fila["unmed"].ToString(); Detalle.cantidad = Convert.ToDecimal(fila["cantidad"].ToString()); Detalle.valor = Convert.ToDecimal(fila["valor"].ToString()); Detalle.importe = Convert.ToDecimal(fila["importe"].ToString()); Detalle.precioanterior = Convert.ToDecimal(fila["precioanterior"].ToString()); Detalle.precunit = Convert.ToDecimal(fila["precunit"].ToString()); Detalle.importfac = Convert.ToDecimal(fila["importfac"].ToString()); Detalle.totimpto = Convert.ToDecimal(fila["totimpto"].ToString()); Detalle.almacaccionid = almacaccionid; Detalle.statcostopromed = statcostopromed.Trim(); Detalle.tasaigv = igv; Detalle.status = "0"; Detalle.usuar = VariablesPublicas.Usuar; if (fila["productid"].ToString().Trim().Length == 13 && Convert.ToDecimal(fila["cantidad"]) > 0 && Convert.ToDecimal(fila["importfac"]) > 0) { ListaItems.Add(Detalle); } else { if (Convert.ToBoolean(fila["nostock"]) == true) { ListaItems.Add(Detalle); } else { MessageBox.Show("Documento DETALLE EN FORMATO INCORRECTO !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } } if (ListaItems.Count == 0) { MessageBox.Show("DOCUMENTO SIN DETALLE Y/O DETALLE INCORRECTO !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } #endregion BE.ListaItems = ListaItems; #region Detalle - Tarjetas foreach (DataRow fila in TablaTarjetas.Rows) { Detalle2 = new tb_ad_movimientos.Tarjetas(); Detalle2.tarjetaid = Convert.ToInt32(fila["tarjetaid"].ToString()); Detalle2.tarjnumoper = fila["tarjetanume"].ToString(); Detalle2.moneda = moneda.SelectedValue.ToString(); Detalle2.tcamb = Convert.ToDecimal(tcamb.Text); Detalle2.tarjimporte = Convert.ToDecimal(fila["tarjetaimpo"].ToString()); Detalle2.status = "0"; Detalle2.usuar = VariablesPublicas.Usuar.ToString(); if (Convert.ToInt32(fila["tarjetaimpo"]) > 0) { ListaTarjetas.Add(Detalle2); } else { MessageBox.Show("Documento DETALLE TARJETAS EN FORMATO INCORRECTO ...!!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } BE.ListaTarjetas = ListaTarjetas; #endregion if (BL.Update(EmpresaID, BE)) { SEGURIDAD_LOG("M"); NIVEL_FORMS(); MessageBox.Show("Datos Modificados Correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information); form_bloqueado(false); Blanquear(); tipodoc.Enabled = false; btn_nuevo.Enabled = true; btn_imprimir.Enabled = true; btnImprimirNoval.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_salir.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ObtenemosCab() { if (tipguia.Text.Trim().Length > 0) { var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); var dt = new DataTable(); BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipguia.Text.ToString(); BE.serdoc = serguia.Text.Trim(); BE.numdoc = numguia.Text; dt = BL.GetOne(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { dt.Rows[0]["numdoc"].ToString().Trim(); fechguia.Value = Convert.ToDateTime(dt.Rows[0]["fechdoc"]); ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim(); nmruc.Text = dt.Rows[0]["nmruc"].ToString().Trim(); ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim(); var BL2 = new clienteBL(); var BE2 = new tb_cliente(); var dt2 = new DataTable(); BE2.ctacte = ctacte.Text; dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; direc.Text = dt2.Rows[0]["direc"].ToString().Trim(); moneda.SelectedValue = dt.Rows[0]["moneda"].ToString().Trim(); } } }
public DataSet Sunat141_RegVentas(string empresaid, tb_ad_movimientos BE) { return tablaDA.Sunat141_RegVentas(empresaid, BE); }
public bool Update(string empresaid, tb_ad_movimientos BE) { return tablaDA.Update(empresaid, BE); }
public bool Insert(string empresaid, tb_ad_movimientos BE) { return tablaDA.Insert(empresaid, BE); }
public DataSet GetReportDetalle(string empresaid, tb_ad_movimientos BE) { return tablaDA.GetReportDetalle(empresaid, BE); }
public DataSet GetOne2(string empresaid, tb_ad_movimientos BE) { return tablaDA.GetOne2(empresaid, BE); }
private void Delete() { try { if (ctacte.Text.Trim().Length == 0) { MessageBox.Show("Ingrese Proveedor/Cliente !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (Tabladetallemov.Rows.Count == 0) { MessageBox.Show("Documento no tiene Items !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (numdoc.Text.Trim().Length == 10) { var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); //BE.dominioid = dominio; BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipodoc.SelectedValue.ToString(); BE.serdoc = serdoc.Text.Trim(); BE.numdoc = numdoc.Text.Trim(); BE.status = "9"; BE.usuar = VariablesPublicas.Usuar; if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); NIVEL_FORMS(); MessageBox.Show("Datos eliminados correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar_documento(); form_bloqueado(false); tipodoc.Enabled = false; numdoc.Enabled = false; btn_nuevo.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_salir.Enabled = true; } } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataSet GetReport(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbAdMovimientos_PRINTDOC", 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("@convalor", SqlDbType.Char, 1).Value = BE.Convalor; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private void form_cargar_datos_referencia(String posicion) { try { ControlName(); limpiar_documento_referencia(); var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); var dt = new DataTable(); BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipfac.Text.ToString().Trim(); if (serfac.Text.Trim().Length > 0) { BE.serdoc = serfac.Text.Trim().PadLeft(4, '0'); BE.numdoc = numfac.Text.Trim().PadLeft(10, '0'); } else { if (posicion.Trim().Length > 0) { MessageBox.Show("Seleccionar el Tipo de Documento de Referencia !!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; } if (numfac.Text.Trim().Length > 0) { BE.numdoc = numfac.Text.Trim().PadLeft(10, '0'); } BE.posicion = posicion.Trim(); dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["status"].ToString().Trim() == "9") { MessageBox.Show("Documento de Referencia ANULADO!!...verifique", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); dt.Clear(); return; } //ssModo = "EDIT"; serfac.Text = dt.Rows[0]["serdoc"].ToString().Trim(); numfac.Text = dt.Rows[0]["numdoc"].ToString().Trim(); //fechfac.Checked = true; fechfac.Text = dt.Rows[0]["fechdoc"].ToString().Trim(); recep_name.Text = dt.Rows[0]["recep_name"].ToString().Trim(); recep_dni.Text = dt.Rows[0]["recep_dni"].ToString().Trim(); recep_fecha.Text = dt.Rows[0]["recep_fecha"].ToString().Trim(); tipimptoid = dt.Rows[0]["tipimptoid"].ToString().Trim(); direcnume = dt.Rows[0]["direcnume"].ToString().Trim(); incprec = dt.Rows[0]["incprec"].ToString().Trim(); if (incprec.ToString() == "N") { cbo_incprec.SelectedIndex = 1; } else { cbo_incprec.SelectedIndex = 0; } moneda.SelectedValue = dt.Rows[0]["moneda"].ToString().Trim(); tcamb.Text = dt.Rows[0]["tcamb"].ToString().Trim(); if (dt.Rows[0]["tipimptoid"].ToString().Trim().Length > 0) { tipimptotasa.SelectedValue = dt.Rows[0]["tipimptoid"].ToString().Trim(); } else { tipimptotasa.SelectedIndex = 0; } ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim(); nmruc.Text = dt.Rows[0]["nmruc"].ToString().Trim(); ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim(); direc.Text = dt.Rows[0]["direc"].ToString().Trim(); vendperid.Text = dt.Rows[0]["vendorid"].ToString().Trim(); vendpername.Text = dt.Rows[0]["vendorname"].ToString().Trim(); //if (dt.Rows[0]["serfac"].ToString().Trim().Length > 0 && dt.Rows[0]["numfac"].ToString().Trim().Length > 0) //{ // tipfac.Text = dt.Rows[0]["tipfac"].ToString().Trim(); // serfac.Text = dt.Rows[0]["serfac"].ToString().Trim(); // numfac.Text = dt.Rows[0]["numfac"].ToString().Trim(); // fechfac.Format = DateTimePickerFormat.Short; // fechfac.Text = dt.Rows[0]["fechfac"].ToString().Trim(); //} //else //{ // tipfac.SelectedIndex = 0; //} //if (dt.Rows[0]["serguia"].ToString().Trim().Length > 0 && dt.Rows[0]["numguia"].ToString().Trim().Length > 0) //{ // serguia.Text = dt.Rows[0]["serguia"].ToString().Trim(); // numguia.Text = dt.Rows[0]["numguia"].ToString().Trim(); // fechguia.Format = DateTimePickerFormat.Short; // fechguia.Text = dt.Rows[0]["fechguia"].ToString().Trim(); //} //if (dt.Rows[0]["sernotac"].ToString().Trim().Length > 0 && dt.Rows[0]["numnotac"].ToString().Trim().Length > 0) //{ // sernotac.Text = dt.Rows[0]["sernotac"].ToString().Trim(); // numnotac.Text = dt.Rows[0]["numnotac"].ToString().Trim(); // fechnotac.Format = DateTimePickerFormat.Short; // fechnotac.Text = dt.Rows[0]["fechnotac"].ToString().Trim(); //} tip_operacion = "05"; //dt.Rows[0]["tipoperacionid"].ToString().Trim(); itemsT.Text = dt.Rows[0]["items"].ToString().Trim(); totpzas.Text = dt.Rows[0]["totpzas"].ToString().Trim(); bruto.Text = dt.Rows[0]["bruto"].ToString().Trim(); totdscto1.Text = dt.Rows[0]["totdscto1"].ToString().Trim(); valventa.Text = dt.Rows[0]["valventa"].ToString().Trim(); totimpto.Text = dt.Rows[0]["totimpto"].ToString().Trim(); totimporte.Text = dt.Rows[0]["totimporte"].ToString().Trim(); glosa.Text = dt.Rows[0]["glosa"].ToString().Trim(); // Venta en Combo princombo.Checked = Convert.ToBoolean(dt.Rows[0]["princombo"].ToString() == "True" ? 1 : 0); canticombo.Value = Convert.ToInt32(dt.Rows[0]["cantcombo"].ToString() == "" ? "0" : dt.Rows[0]["cantcombo"].ToString()) == 0 ? 1 : Convert.ToInt32(dt.Rows[0]["cantcombo"].ToString() == "" ? "0" : dt.Rows[0]["cantcombo"].ToString()); preccombo.Text = Convert.ToDecimal(dt.Rows[0]["preccombo"].ToString() == "" ? "0" : dt.Rows[0]["preccombo"].ToString()).ToString("###,##0.00"); // importtarj.Text = dt.Rows[0]["tarjimporte1"].ToString().Trim(); txtefectivo.Text = dt.Rows[0]["efectivo"].ToString().Trim(); if (dt.Rows[0]["tarjetaid"].ToString() != "") { _xtarjetaid = Convert.ToInt32(dt.Rows[0]["tarjetaid"].ToString()); } if (dt.Rows[0]["tarjnumoper"].ToString() != "") { _xtarjnumoper = dt.Rows[0]["tarjnumoper"].ToString().Trim(); } data_Tabladetallemovmov_referencia(); //data_TablaTarjetas(); //if (dt.Rows[0]["status"].ToString().Trim() != "9") //{ // btn_editar.Enabled = true; // btn_eliminar.Enabled = true; // btn_imprimir.Enabled = true; // btnImprimirNoval.Enabled = true; // btn_primero.Enabled = true; // btn_anterior.Enabled = true; // btn_siguiente.Enabled = true; // btn_ultimo.Enabled = true; // btn_salir.Enabled = true; // griddetallemov.Focus(); // griddetallemov.Rows[0].Selected = false; // pdtimagen.Visible = false; // princombo.Enabled = false; // canticombo.Enabled = false; //} //else //{ // ssModo = "ANULADO"; // pdtimagen.Visible = true; // btn_editar.Enabled = false; // btn_eliminar.Enabled = false; // btn_imprimir.Enabled = true; // btnImprimirNoval.Enabled = true; // btn_primero.Enabled = true; // btn_anterior.Enabled = true; // btn_siguiente.Enabled = true; // btn_ultimo.Enabled = true; // btn_salir.Enabled = true; // princombo.Enabled = false; // canticombo.Enabled = false; //} } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataSet GetReportDetalle(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbAdMovimientos_SEARCH_DetalleVentas", 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("@fechdocini", SqlDbType.DateTime).Value = BE.fechdocini; //cmd.Parameters.Add("@fechdocfin", SqlDbType.DateTime).Value = BE.fechdocfin; //cmd.Parameters.Add("@numdocini", SqlDbType.Char, 10).Value = BE.xnumdoc1; //cmd.Parameters.Add("@numdocfin", SqlDbType.Char, 10).Value = BE.xnumdoc2; 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); } } } }
private void Tabla_DetGuia() { Decimal xxprecventa = 0, xxcostoultimo = 0, xxstock = 0, xxcostopromed = 0; griddetallemov.AutoGenerateColumns = false; var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); var dt = new DataTable(); BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipguia.Text.ToString(); BE.serdoc = serguia.Text.Trim(); BE.numdoc = numguia.Text; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow fila in dt.Rows) { var BL2 = new tb_ad_local_stockBL(); var BE2 = new tb_ad_local_stock(); var dt2 = new DataTable(); BE2.moduloid = modulo; BE2.local = local; BE2.productid = fila["productid"].ToString(); dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; if (dt2.Rows.Count > 0) { if (almacaccionid.Trim() == "20" || almacaccionid.Trim() == "21") { lbl_valor.Text = "Cost.Prom"; xxprecventa = Convert.ToDecimal(dt2.Rows[0]["precventa"]); xxcostopromed = Convert.ToDecimal(dt2.Rows[0]["costopromed"]); } else { if (almacaccionid.Trim() == "10" || almacaccionid.Trim() == "11") { lbl_valor.Text = "Cost.Ultm"; xxcostoultimo = Convert.ToDecimal(dt2.Rows[0]["costoultimo"]); } } xxstock = Convert.ToDecimal(dt2.Rows[0]["stock"]); if (xxstock == 0) { xxstock = Convert.ToDecimal(dt2.Rows[0]["stockini"]); } } row = Tabladetallemov.NewRow(); row["itemref"] = fila["itemref"].ToString(); row["items"] = fila["items"].ToString(); row["productid"] = fila["productid"].ToString().Trim(); row["productname"] = fila["productname"].ToString().Trim(); var cantidad = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4); row["stock"] = xxstock; row["precventa"] = xxprecventa; row["costoultimo"] = xxcostoultimo; row["costopromed"] = xxcostopromed; row["cantidad"] = cantidad; row["cantidad_old"] = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4); row["precunit"] = Math.Round(Convert.ToDecimal(Convert.ToDecimal(fila["precunit"]).ToString("###,###,##0.000000")), 6); var precunit = Math.Round(Convert.ToDecimal(Convert.ToDecimal(fila["precunit"]).ToString("###,###,##0.000000")), 6); Decimal importe; importe = cantidad * precunit; row["importfac"] = importe; row["valor"] = Math.Round(Convert.ToDecimal(fila["valor"]), 6); row["importe"] = Math.Round(Convert.ToDecimal(fila["importe"]), 6); row["totimpto"] = Math.Round(Math.Round(Convert.ToDecimal(fila["importe"]), 6) * (Convert.ToDecimal(18) / 100), 6); row["almacaccionid"] = almacaccionid.Trim(); Tabladetallemov.Rows.Add(row); griddetallemov.DataSource = Tabladetallemov; } _RecalculoGrid(); } else { return; } }
public bool Insert_old(string empresaid, tb_ad_movimientos BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { SqlTransaction tr = default(SqlTransaction); Boolean TransaExito = false; using (SqlCommand cmd = new SqlCommand("gspTbAdMovimientoscab_INSERT", 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("@status", SqlDbType.Char, 1).Value = BE.status; cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid; cmd.Parameters.Add("@tipoperacionid", SqlDbType.Char, 2).Value = BE.tipoperacionid; cmd.Parameters.Add("@ctacteaccionid", SqlDbType.Char, 2).Value = BE.ctacteaccionid; cmd.Parameters.Add("@fechdoc", SqlDbType.DateTime).Value = BE.fechdoc; cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte; cmd.Parameters.Add("@ctactename", SqlDbType.VarChar, 70).Value = BE.ctactename; cmd.Parameters.Add("@direcnume", SqlDbType.Char, 6).Value = BE.direcnume; cmd.Parameters.Add("@direcname", SqlDbType.VarChar, 25).Value = BE.direcname; cmd.Parameters.Add("@direcdeta", SqlDbType.VarChar, 70).Value = BE.direcdeta; cmd.Parameters.Add("@tipdid", SqlDbType.Char, 1).Value = BE.tipdid; cmd.Parameters.Add("@nmruc", SqlDbType.Char, 11).Value = BE.nmruc; 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("@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("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid; cmd.Parameters.Add("@cencosid", SqlDbType.Char, 5).Value = BE.cencosid; cmd.Parameters.Add("@condpago", SqlDbType.Char, 4).Value = BE.condpago; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; cmd.Parameters.Add("@incprec", SqlDbType.Char, 1).Value = BE.incprec; cmd.Parameters.Add("@totimpto", SqlDbType.Decimal).Value = BE.totimpto; cmd.Parameters.Add("@valventa", SqlDbType.Decimal).Value = BE.valventa; cmd.Parameters.Add("@totimporte", SqlDbType.Decimal).Value = BE.totimporte; cmd.Parameters.Add("@tcamb", SqlDbType.Decimal).Value = BE.tcamb; cmd.Parameters.Add("@glosa", SqlDbType.VarChar, 300).Value = BE.glosa; cmd.Parameters.Add("@totpzas", SqlDbType.Decimal).Value = BE.totpzas; cmd.Parameters.Add("@moneda", SqlDbType.Char).Value = BE.moneda; cmd.Parameters.Add("@transpid", SqlDbType.Char, 5).Value = BE.transpid; cmd.Parameters.Add("@transpname", SqlDbType.VarChar, 40).Value = BE.transpname; cmd.Parameters.Add("@motivotrasladoid", SqlDbType.Char, 2).Value = BE.motivotrasladoid; cmd.Parameters.Add("@mottrasladointid", SqlDbType.Char, 2).Value = BE.mottrasladointid; cmd.Parameters.Add("@items", SqlDbType.Decimal).Value = BE.items; 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; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; using (SqlCommand cmd2 = new SqlCommand("gspTbAdMovimientosdet_INSERT_xml", cnx)) { cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd2.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd2.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc; cmd2.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd2.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd2.Parameters.Add("@XML", SqlDbType.Xml).Value = BE.GetItemXML(); try { cnx.Open(); tr = cnx.BeginTransaction(IsolationLevel.Serializable); cmd.Transaction = tr; if (cmd.ExecuteNonQuery() > 0) { cmd2.Transaction = tr; if (cmd2.ExecuteNonQuery() > 0) { TransaExito = true; } } if (TransaExito == true) { tr.Commit(); return true; } else { tr.Rollback(); return false; } } catch (Exception ex) { tr.Rollback(); throw new Exception(ex.Message); } } } } }
private void ValidaDocref() { if (tipfac.SelectedIndex != -1) { var BL = new tb_ad_movimientosBL(); var BE = new tb_ad_movimientos(); var dt = new DataTable(); BE.moduloid = modulo; BE.local = local; BE.tipodoc = tipfac.Text.ToString(); BE.serdoc = serfac.Text.Trim(); BE.numdoc = numfac.Text; dt = BL.GetOne(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { dt.Rows[0]["numdoc"].ToString().Trim(); fechfac.Value = Convert.ToDateTime(dt.Rows[0]["fechdoc"]); ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim(); nmruc.Text = dt.Rows[0]["nmruc"].ToString().Trim(); ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim(); direc.Text = dt.Rows[0]["direc"].ToString().Trim(); moneda.SelectedValue = dt.Rows[0]["moneda"].ToString().Trim(); } } }
public DataSet GetAll_datosdetalle(string empresaid, tb_ad_movimientos BE) { return tablaDA.GetAll_datosdetalle(empresaid, BE); }