public void ConsultaDatosInsumos() { Clases.clsUtilidades ut = new Clases.clsUtilidades(); ds = pd.ConsultasCombos("paConsultas", "1"); if (TipoConsulta_ == "Insumos") { dgvMaestros.DataSource = ds.Tables[0]; ut.FormatearGrid(dgvMaestros, "Precio", "C"); } else if (TipoConsulta_ == "Clientes") { gbppal.Text = "Clientes"; dgvMaestros.DataSource = ds.Tables[1]; dgvMaestros.Columns["Id"].Visible = false; } else if (TipoConsulta_ == "Compañias") { gbppal.Text = "Compañias"; dgvMaestros.DataSource = ds.Tables[2]; dgvMaestros.Columns["IdCompañia"].Visible = false; dgvMaestros.Columns["Logo"].Visible = false; } ut.AlinearContenidoColumna(dgvMaestros); dgvMaestros.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; }
private void CargarCombos() { try { ds = pd.ConsultasCombos("paConsultas", "0"); //string[] s = ds.Tables[1].Rows.OfType<DataRow>().Select(k => k[2].ToString()).ToArray(); cbbResolucion.DataSource = ds.Tables[0]; cbbResolucion.ValueMember = "NumeroResolucion"; this.cbbResolucion.AutoCompleteCustomSource.AddRange(ds.Tables[0].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray()); this.cbbResolucion.AutoCompleteMode = AutoCompleteMode.Suggest; this.cbbResolucion.AutoCompleteSource = AutoCompleteSource.CustomSource; //this.cbbCliente.AutoCompleteCustomSource.AddRange(ds.Tables[1].Rows.OfType<DataRow>().Select(k => k[2].ToString()).ToArray()); //autocompleta combox //this.cbbCliente.AutoCompleteMode = AutoCompleteMode.SuggestAppend; //this.cbbCliente.AutoCompleteSource = AutoCompleteSource.ListItems; //DataView dtv = new DataView(ds.Tables[1]); //dtv.Sort = "RazonSocial ASC"; //DataTable dt = dtv.ToTable(); cbbCliente.DataSource = ds.Tables[1]; cbbCliente.DisplayMember = "RazonSocial"; cbbCliente.ValueMember = "IdCliente"; cbbCliente.Text = "Seleccione un cliente"; //listBox1.DataSource = dt; //listBox1.DisplayMember = "RazonSocial"; //listBox1.ValueMember = "Nit"; txtNumFac.Text = ds.Tables[2].Rows[0]["NumFac"].ToString(); dgvInsumos.DataSource = ds.Tables[3]; dgvInsumos.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; //dgvInsumos.Columns["Precio"].DefaultCellStyle.FormatProvider= System.Globalization.CultureInfo.GetCultureInfo("en-us"); //dgvInsumos.Columns["Precio"].DefaultCellStyle.Format =string.Format( "C"); Utilidades.FormatearGrid(dgvInsumos, "Precio", "C"); Utilidades.AlinearContenidoColumna(dgvInsumos); //DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn(); //BindingSource bs1 = new BindingSource(); //bs1.DataSource = ds.Tables[6]; //cmb.DataPropertyName = "NombreUM"; //cmb.HeaderText = "UnidadMedida"; //cmb.Width = 120; //cmb.DataSource = bs1; //cmb.ValueMember = "NombreUM"; //cmb.DisplayMember = "NombreUM"; //dgvInsumos.Columns.Insert(2, cmb); dgvInsumosFacturar.DataSource = ds.Tables[4]; cbbCompania.DataSource = ds.Tables[5]; cbbCompania.DisplayMember = "RazonSocial"; cbbCompania.ValueMember = "IdCompañia"; cbbSede.DataSource = null; //dgvInsumosFacturar.Columns.Add("CodigoInsumo", "CodigoInsumo"); //dgvInsumosFacturar.Columns.Add("Descripcion", "Descripcion"); //dgvInsumosFacturar.Columns.Add("Iva", "Iva"); //dgvInsumosFacturar.Columns.Add("Cantidad", "Cantidad"); //dgvInsumosFacturar.Columns.Add("VlrUnitario", "VlrUnitario"); //dgvInsumosFacturar.Columns.Add("VlrIva", "VlrIva"); //dgvInsumosFacturar.Columns.Add("VlrBruto", "VlrBruto"); //dgvInsumosFacturar.Columns.Add("VlrTotal", "VlrTotal"); txtDescuento.Text = "0"; rtxComentarios.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }