// public string anio { get; set; } public bool checkAll(string con) { MessageViewModel mv = new MessageViewModel(); //string con = @"Server=LAYER-PC\TTEST; Database=SAFC_ECB; User Id=profit; Password = profit"; string sql = @"SELECT top(1) Ase_cNummov , Ase_nVoucher FROM CNC_ASIENTO_VOUCHER WHERE Emp_cCodigo = '003' AND Pan_cAnio = '" + Anio + "' AND Per_cPeriodo = '" + Periodo + "' AND Lib_cTipoLibro = '" + Libro + "' AND Ase_cGlosa = '" + Glosa + "'" + " ORDER BY Ase_nVoucher desc"; try { Conexion cn = new Conexion(con); SqlDataReader reader = cn.consulta3(sql); if (reader.HasRows) { while (reader.Read()) { mv.Message = "Ya existe un Asiento \n" + "Nro. Voucher: " + reader.GetSqlValue(1).ToString() + "\n" + " Descripcion: " + Glosa; mv.Caption = "Titulo"; mv.mensajeria(); } return(true); } else { return(false); } } catch (Exception e) { mv.Message = mv.ToStringAllExceptionDetails(e); mv.Caption = "Error sql"; mv.mensajeria(); return(true); } }
public ObservableCollection <mVentas> agregarData(string data, string con, int codTienda, object sender) { MessageViewModel mv = new MessageViewModel(); // DataGrid dgv1 = dgVenta as DataGrid; ComboBox cb = sender as ComboBox; string fechaDia = cb.SelectedValue.ToString(); decimal total = 0; string tienda; string buscarTienda; if (codTienda == 1) { tienda = "B001"; buscarTienda = "01"; } else if (codTienda == 2) { tienda = "B002"; buscarTienda = "02"; } else if (codTienda == 3) { tienda = "B003"; buscarTienda = "05"; } else { tienda = "B004"; buscarTienda = "05"; } string sql; try { Conexion cn = new Conexion(con); sql = @"SELECT A.NUMFACTURA AS NUMERO,0 AS total,0 as totiva,0 as totreq, 0 as baseimponibre FROM FACTURASVENTA AS A where a.FECHAENTRADA = '" + fechaDia + "' and a.NUMSERIE = '" + tienda + "' and a.TOTALNETO = 0 "; sql = sql + @" union SELECT numero,total,totiva,totreq,baseimponible from FACTURASVENTA b right outer join FACTURASVENTATOT a on a.NUMERO = b.NUMFACTURA and a.SERIE = b.NUMSERIE where b.FECHAENTRADA = '" + fechaDia + "' and a.SERIE = '" + tienda + "' order by NUMERO"; SqlDataReader reader = cn.consulta3(sql); if (reader.HasRows) { while (reader.Read()) { venta.Add(new mVentas("12121", buscarTienda, (reader.GetInt32(0)).ToString(), Convert.ToDecimal(reader.GetValue(1)), 0) { cuenta = "12121", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = Convert.ToDecimal(reader.GetValue(1)), haber = 0 }); venta.Add(new mVentas("40111", buscarTienda, (reader.GetInt32(0)).ToString(), 0, Convert.ToDecimal(reader.GetValue(2))) { cuenta = "40111", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = 0, haber = Convert.ToDecimal(reader.GetValue(2)) }); venta.Add(new mVentas("40997", buscarTienda, (reader.GetInt32(0)).ToString(), 0, Convert.ToDecimal(reader.GetValue(3))) { cuenta = "40997", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = 0, haber = Convert.ToDecimal(reader.GetValue(3)) }); venta.Add(new mVentas("40111", buscarTienda, (reader.GetInt32(0)).ToString(), 0, Convert.ToDecimal(reader.GetValue(4))) { cuenta = "70111", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = 0, haber = Convert.ToDecimal(reader.GetValue(4)) }); } total = venta.Sum(x => x.cuenta == "12121" ? x.debe : 0); } } catch (Exception e) { mv.Message = mv.ToStringAllExceptionDetails(e); mv.Caption = "Error sql"; mv.mensajeria(); } return(venta); }