private void ListartFrm_Load(object sender, EventArgs e) { L_ITEMS.Text = _controlador.TotItems; DGV.DataSource = _controlador.Source; DGV.Refresh(); printDialog1.Document = printDocument1; }
private void AdministradorFrm_Load(object sender, EventArgs e) { DTP_DESDE.Value = _controlador.FechaDesde; DTP_HASTA.Value = _controlador.FechaHasta; TB_CADENA_BUS_PROV.Text = _controlador.Proveedor; CB_SUCURSAL.DataSource = _controlador.SucursalSource; CB_SUCURSAL.SelectedIndex = -1; CB_TIPO_DOC.DataSource = _controlador.TipoDocSource; CB_TIPO_DOC.SelectedIndex = -1; L_TITULO.Text = _controlador.Titulo; switch (_controlador.TipoAdministrador) { case enumerados.EnumTipoAdministrador.AdmDocumentos: InicializarGrid_1(); break; } Actualizar(); DGV.DataSource = _controlador.ItemsSource; DGV.Refresh(); DGV.Columns[0].Frozen = true; DGV.Columns[1].Frozen = true; DGV.Columns[2].Frozen = true; DGV.Columns[3].Frozen = true; }
protected void RecuperarInformacion(string id) { //Consulta para obtener información del becario string sql = "SELECT CONCAT(I.apellidos, ', ', I.nombres) AS[Becario], N.nombre AS[Nivel], C.nombre AS[Carrera]," + " U.nombre AS[Universidad], P.nombre AS[Programa]," + " B.fechaInicio AS[InicioBeca], B.fechaFin AS[FinBeca] FROM Becario B" + " INNER JOIN ProgramaBecas P ON B.idPrograma = P.idPrograma" + " INNER JOIN Universidad U ON B.idUniversidad = U.idUniversidad" + " INNER JOIN Carrera C ON B.idCarrera = C.idCarrera" + " INNER JOIN NivelEducativo N ON B.idNivelEducativo = N.idNivelEducativo" + " INNER JOIN InformacionPersonal I ON B.idInformacion = I.idInformacion" + " WHERE B.idBecario = '" + id + "'"; SqlDataReader reader = DBConnection.GetData(sql); reader.Read(); nombreB.InnerHtml = "Nombre: " + reader["Becario"]; nivelB.InnerHtml = "Nivel Educativo: " + reader["Nivel"]; carreraB.InnerHtml = "Carrera: " + reader["Carrera"]; universidadB.InnerHtml = "Universidad: " + reader["Universidad"]; programaB.InnerHtml = "Programa de Beca: " + reader["Programa"]; fechaInicioB.InnerHtml = "Inicio de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["InicioBeca"]); fechaFinB.InnerHtml = "Fin de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["FinBeca"]); reader.Close(); //Obtenemos información y la asociamos al datagridview SqlDataSource1.SelectCommand = "SELECT TI.nombre AS[TipoIncidente], TI.descripcion AS[descripcion], BI.idBitacora, BI.fechaAplicacion, BI.descripcion AS[detalles] FROM BitacoraIncidentes BI" + " INNER JOIN TipoIncidente TI ON BI.idTipoIncidente = TI.idTipoIncidente" + " WHERE BI.idBecario = '" + id + "'"; DGV.DataBind(); }
private void frmTradeBook_Load(object sender, EventArgs e) { //if (Settings.Default.Window_LocationTBook != null) //{ // this.Location = Settings.Default.Window_LocationTBook; //} //// Set window size //if (Settings.Default.WindowS_izeTBook != null) //{ // this.Size = Settings.Default.WindowS_izeTBook; //} var AbbA = frmTradeBook.LoadFormLocationAndSize(this); this.Location = new Point(AbbA[0], AbbA[1]); this.Size = new Size(AbbA[2], AbbA[3]); this.FormClosing += new FormClosingEventHandler(SaveFormLocationAndSize); load_data(); Type controlType = DGV.GetType(); PropertyInfo pi = controlType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic); pi.SetValue(DGV, true, null); // DGV.Columns["LOGTIME"].SortMode = DataGridViewColumnSortMode.NotSortable; profile_load(); }
private void fEditarAsiento_EditarOk(object sender, int e) { var it = (OOB.Contable.Asiento.Ficha)bs.Current; var r01 = Globals.MyData.Asiento_GetById(e); if (r01.Result == OOB.Resultado.EnumResult.isError) { Helpers.Msg.Error(r01.Mensaje); return; } it.Id = r01.Entidad.Id; it.Comprobante = r01.Entidad.Comprobante; it.Detalle = r01.Entidad.Detalle; it.FechaEmision = r01.Entidad.FechaEmision; it.TipoAsiento = r01.Entidad.TipoAsiento; it.EstaAnulado = r01.Entidad.EstaAnulado; it.EstaProcesado = r01.Entidad.EstaProcesado; it.AutoGenerado = r01.Entidad.AutoGenerado; it.Importe = r01.Entidad.Importe; it.TipoDocumento = r01.Entidad.TipoDocumento; if (it.EstaProcesado == false) { L_PENDIENTE.Visible = true; } else { L_PENDIENTE.Visible = false; } DGV.Refresh(); }
private void RemisionFrm_Load(object sender, EventArgs e) { L_ITEMS.Text = _controlador.ItemEncontrados; L_PROVEEDOR.Text = _controlador.Proveedor; DGV.DataSource = _controlador.Source; DGV.Refresh(); }
private void DGV_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e) { try{ if (DGV.InvokeRequired) { DGV.Invoke(new On_DataPaintdDelegate(DGV_RowPrePaint), sender, e); return; } if (DGV.Rows[e.RowIndex].Cells["Buy_SellIndicator"].Value.ToString() == "BUY") { // DGV.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red; DGV.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Blue; } else { // DGV.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Blue; DGV.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Red; } } catch (Exception ex) { MessageBox.Show("Trade Book - Funtion Name- toolStripButton1_Click " + ex.Message); } }
private void btnComprar_Click(object sender, EventArgs e) { DGV objDGV = new DGV(); Imprimir objImprimir = new Imprimir(); bool filaSeleccionada = objDGV.ValidarFilaSeleccionada(dgvProductos); if (filaSeleccionada) { VentaDTO datosProducto = objDGV.ObtenerDatosSeleccionadosDGV(dgvProductos); AñadirVenta(datosProducto); string cMensaje = "Compra realizada con éxito"; objImprimir.ImprimirMensaje(cMensaje); } else { string cMensaje = "Por favor seleccione una fila"; objImprimir.ImprimirMensaje(cMensaje); } dgvProductos.ClearSelection(); dgvVentas.ClearSelection(); }
private void ImportarDoc() { _controlador.ImportarDoc(); ActualizarDatosTotales(); DGV.Refresh(); IniciarBusqueda(); }
public void ShowRoom() { string RoomStuts = ""; if (cmbStuts.SelectedIndex == 0) { RoomStuts = "0"; } else if (cmbStuts.SelectedIndex == 1) { RoomStuts = "1"; } else if (cmbStuts.SelectedIndex == 2) { RoomStuts = "2"; } else if (cmbStuts.SelectedIndex == 3) { RoomStuts = "3"; } SQL.str = "Select * from ViewCheckRoom where RoomStatus='" + RoomStuts + "'"; SQL.RunQuery(SQL.str); DGV.DataSource = SQL.ds.Tables[0]; DGV.Refresh(); }
private void DGV_DragOver(object sender, DragEventArgs e) { var pt = DGV.PointToClient(new Point(e.X, e.Y)); var ht = DGV.HitTest(pt.X, pt.Y); if ((0 <= ht.RowIndex) && (e.Data.GetData(typeof(DownloadRow)) is DownloadRow row) && (row.GetVisibleIndex() != ht.RowIndex)) { e.Effect = e.AllowedEffect; if (_DragOver_RowIndex != ht.RowIndex) { _DragOver_RowIndex = ht.RowIndex; DGV.Invalidate(); } ScrollIfNeed(in pt); return; } e.Effect = DragDropEffects.None; if (_DragOver_RowIndex.HasValue) { _DragOver_RowIndex = null; DGV.Invalidate(); } ScrollIfNeed(in pt); }
private void moveDown() { if (DGV.RowCount > 0) { if (DGV.SelectedRows.Count > 0) { int rowCount = DGV.Rows.Count; int index = DGV.SelectedCells[0].OwningRow.Index; if (index == (rowCount - 2)) // include the header row { return; } DataGridViewRowCollection rows = DGV.Rows; // remove the next row and add it in front of the selected row. DataGridViewRow row = rows[index]; DataGridViewRow prevRow = rows[index + 1]; String rowDate = row.Cells[5].Value.ToString(); String prevRowDate = prevRow.Cells[5].Value.ToString(); row.Cells[5].Value = prevRowDate; prevRow.Cells[5].Value = rowDate; DataGridViewRow nextRow = rows[index + 1]; rows.Remove(nextRow); nextRow.Frozen = false; rows.Insert(index, nextRow); DGV.ClearSelection(); DGV.Rows[index + 1].Selected = true; } else if (DGV.SelectedCells.Count == 1 && DGV.CurrentCell.RowIndex != DGV.Rows.Count - 2) { DGV.CurrentCell = DGV.Rows[DGV.CurrentCell.RowIndex + 1].Cells[DGV.CurrentCell.ColumnIndex]; } } }
private void LoadSchool() { try { SQLConn.ConnOpen(); SQLConn.sqL = "Select id, address,phone,fax,email,website from school where id='" + cmbSchool.SelectedValue + "'"; SQLConn.cmd = new NpgsqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { cmbSchool.SelectedValue = SQLConn.dr["id"].ToString(); txtAddress.Text = SQLConn.dr["id"].ToString(); txtPhone.Text = SQLConn.dr["phone"].ToString(); cmbEmail.Text = SQLConn.dr["email"].ToString(); txtWeb.Text = SQLConn.dr["website"].ToString(); DGV.Focus(); } else { ResetAll(); } } catch (NpgsqlException ex) { MessageBox.Show(ex.ToString()); } }
private string PrepareXMLString() { string strXMLString = ""; int SrlNo = 1; decimal Amount = 0; strXMLString = "<NewDataSet>"; foreach (GridViewRow DGV in dgvBill.Rows) { if (DGV.RowType == DataControlRowType.DataRow) { TextBox txtAmount = (TextBox)DGV.FindControl("txtAmount"); Amount = (txtAmount.Text.Trim().Length > 0) ? Convert.ToDecimal(txtAmount.Text.Trim()) : 0; if (Amount > 0) { strXMLString += "<TrnDebitNoteDetail"; strXMLString += " SrlNo = \"" + SrlNo.ToString() + "\""; strXMLString += " PurchaseBillId_FK = \"" + dgvBill.DataKeys[DGV.RowIndex].Value.ToString() + "\""; strXMLString += " Amount = \"" + Amount + "\""; strXMLString += " />"; SrlNo += 1; } } } strXMLString += "</NewDataSet>"; return(strXMLString); }
private void DGV_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { DGV.ClearSelection(); } }
private string PrepareXMLString() { string strXMLString = ""; int SrlNo = 1; string ByTo = "PAYMENT"; decimal DRAmount = 0; strXMLString = "<NewDataSet>"; foreach (GridViewRow DGV in dgvFeesHead.Rows) { if (DGV.RowType == DataControlRowType.DataRow) { TextBox txtAmount = (TextBox)DGV.FindControl("txtAmount"); decimal Amount = (txtAmount.Text.Trim().Length > 0) ? Convert.ToDecimal(txtAmount.Text.Trim()) : 0; if (Amount > 0) { strXMLString += "<TrnCashBankVoucherDetail"; strXMLString += " SrlNo = \"" + SrlNo.ToString() + "\""; strXMLString += " ByTo = \"" + ByTo + "\""; strXMLString += " LedgerID = \"" + dgvFeesHead.DataKeys[DGV.RowIndex].Values["AssestLedgerID_FK"].ToString() + "\""; strXMLString += " DRAmount = \"" + DRAmount + "\""; strXMLString += " CRAmount = \"" + Amount + "\""; strXMLString += " />"; SrlNo += 1; } } } strXMLString += "</NewDataSet>"; return(strXMLString); }
private void fEditar_AsientoDetalleOk(object sender, List <Detalle> e) { var ficha = (OOB.Contable.Asiento.Generar.Ficha)bs.Current; var ln = new List <OOB.Contable.Asiento.Generar.FichaDetalle>(); int nr = 1; foreach (var it in e) { var nit = new OOB.Contable.Asiento.Generar.FichaDetalle() { IdCta = it.Cta.Id, CodigoCta = it.Codigo, DescripcionCta = it.Descripcion, Naturaleza = it.Cta.Naturaleza, MontoDebe = it.Debe, MontoHaber = it.Haber, Renglon = nr, Signo = ficha.Signo, }; ln.Add(nit); } ficha.IsOk = true; ficha.Detalles = ln; DGV.Refresh(); Limpiar_AsientoDetalles(); ActualizarTotales(); }
private void RecuperarInformacion(string id) { SqlDataSource1.SelectCommand = "SELECT D.idDesembolso, D.fecha, D.monto, TD.nombre FROM Desembolso D " + " INNER JOIN TipoDesembolso TD ON D.idTipoDesembolso = TD.idTipoDesembolso INNER JOIN Ciclo C ON D.idCiclo = C.idCiclo" + " WHERE C.idBecario = '" + id + "' ORDER BY fecha DESC "; DGV.DataBind(); }
void DGV_CurrentCellDirtyStateChanged(object sender, EventArgs e) { if (DGV.CurrentCell is DataGridViewCheckBoxCell && DGV.IsCurrentCellDirty) { DGV.CommitEdit(DataGridViewDataErrorContexts.Commit); } }
private void moveUp() { if (DGV.RowCount > 0) { if (DGV.SelectedRows.Count > 0) { int rowCount = DGV.Rows.Count; int index = DGV.SelectedCells[0].OwningRow.Index; if (index == 0) { return; } DataGridViewRowCollection rows = DGV.Rows; // remove the previous row and add it behind the selected row. DataGridViewRow row = rows[index]; DataGridViewRow prevRow = rows[index - 1]; String rowDate = row.Cells[5].Value.ToString(); String prevRowDate = prevRow.Cells[5].Value.ToString(); row.Cells[5].Value = prevRowDate; prevRow.Cells[5].Value = rowDate; rows.Remove(prevRow); prevRow.Frozen = false; rows.Insert(index, prevRow); DGV.ClearSelection(); DGV.Rows[index - 1].Selected = true; } else if (DGV.SelectedCells.Count == 1 && DGV.CurrentCell.RowIndex != 0) { DGV.CurrentCell = DGV.Rows[DGV.CurrentCell.RowIndex - 1].Cells[DGV.CurrentCell.ColumnIndex]; } } }
private void AjusteNivelFrm_Load(object sender, EventArgs e) { Inicializar(); DGV.DataSource = _controlador.Lista; DGV.Refresh(); L_ITEMS.Text = _controlador.Items; }
public void ShowBooking() { SQL.str = "Select * from ViewRommCheckIn where where BookingStatus='1' and BookingID='" + txtBookingID.Text + "'"; SQL.RunQuery(SQL.str); DGV.DataSource = SQL.ds.Tables[0]; DGV.Refresh(); }
private void txt_Search_KeyDown(object sender, KeyEventArgs e) { // Enter if (e.KeyCode == Keys.Enter) { e.Handled = true; if (DGV.CurrentCell == null) { return; } btn_OK_Click(null, null); } // UP if (e.KeyCode == Keys.Up) { e.Handled = true; DGV.Focus(); } // Dowen else if (e.KeyCode == Keys.Down) { e.Handled = true; DGV.Focus(); SendKeys.Send("{DOWN}"); } }
private void DGV_MouseClick(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Right) { int mousCol = DGV.HitTest(e.X, e.Y).ColumnIndex; int mousRow = DGV.HitTest(e.X, e.Y).RowIndex; if (mousCol == 5 && DGV.SelectedCells.Count == 1 && DGV.SelectedCells[0].ColumnIndex == 5 && DGV.SelectedCells[0].RowIndex == mousRow) { DateMenu.Show(Cursor.Position); MouseX = e.X; MouseY = e.Y; MouseRow = DGV.HitTest(e.X, e.Y).RowIndex; } if (mousCol == -1 && DGV.SelectedRows.Count == 1 && DGV.SelectedRows[0].Index == mousRow) { menu.Show(Cursor.Position); MouseX = e.X; MouseY = e.Y; MouseRow = DGV.HitTest(e.X, e.Y).RowIndex; DGV.Rows[MouseRow].Selected = true; } if (mousCol == 0 && DGV.SelectedCells.Count == 1 && DGV.SelectedCells[0].ColumnIndex == 0 && DGV.SelectedCells[0].RowIndex == mousRow) { NameMenu.Show(Cursor.Position); MouseX = e.X; MouseY = e.Y; MouseRow = DGV.HitTest(e.X, e.Y).RowIndex; } } }
private void RecuperarInformacion(string id) { //Consulta para obtener información del becario string sql = "SELECT CONCAT(I.apellidos, ', ', I.nombres) AS[Becario], N.nombre AS[Nivel], C.nombre AS[Carrera]," + " U.nombre AS[Universidad], P.nombre AS[Programa]," + " B.fechaInicio AS[InicioBeca], B.fechaFin AS[FinBeca] FROM Becario B" + " INNER JOIN ProgramaBecas P ON B.idPrograma = P.idPrograma" + " INNER JOIN Universidad U ON B.idUniversidad = U.idUniversidad" + " INNER JOIN Carrera C ON B.idCarrera = C.idCarrera" + " INNER JOIN NivelEducativo N ON B.idNivelEducativo = N.idNivelEducativo" + " INNER JOIN InformacionPersonal I ON B.idInformacion = I.idInformacion" + " WHERE B.idBecario = '" + id + "'"; SqlDataReader reader = DBConnection.GetData(sql); reader.Read(); nombreB.InnerHtml = "Nombre: " + reader["Becario"]; nivelB.InnerHtml = "Nivel Educativo: " + reader["Nivel"]; carreraB.InnerHtml = "Carrera: " + reader["Carrera"]; universidadB.InnerHtml = "Universidad: " + reader["Universidad"]; programaB.InnerHtml = "Programa de Beca: " + reader["Programa"]; fechaInicioB.InnerHtml = "Inicio de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["InicioBeca"]); fechaFinB.InnerHtml = "Fin de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["FinBeca"]); reader.Close(); //Obtenemos información y la ponemos en datagridview SqlDataSource1.SelectCommand = "SELECT anio AS[Anio], idCiclo AS [idCiclo], nCiclo AS [nCiclo], evidenciaNotas AS [Aprobado]" + " FROM Ciclo WHERE idBecario = '" + id + "'; "; DGV.DataBind(); }
private void PrecioMayorFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Focus(); DGV.Refresh(); L_PRODUCTO.Text = _controlador.Producto; }
private void BuscarFrm_Load(object sender, EventArgs e) { TB_CADENA.Text = ""; DGV.DataSource = _controlador.Source; DGV.Refresh(); L_ITEMS.Text = _controlador.Items; }
private void DGV_MouseMove(object sender, MouseEventArgs e) { if (e.Button != MouseButtons.Left) { return; } var row = GetSelectedDownloadRow(); if (row == null) { return; } var ht = DGV.HitTest(e.X, e.Y); if ((ht.RowIndex < 0) || (ht.ColumnIndex < 0)) { return; } if (_DGV_MouseDown_HitTestInfo.Type != DataGridViewHitTestType.Cell) { return; } const int MOVE_DELTA = 5; if (Math.Abs(_DGV_MouseDown_ButtonLeft_Location.X - e.X) < MOVE_DELTA && Math.Abs(_DGV_MouseDown_ButtonLeft_Location.Y - e.Y) < MOVE_DELTA) { return; } //-----------------------------------------------------// _DragOver_RowIndex = null; DGV.AllowDrop = true; DGV.DragOver += DGV_DragOver; DGV.DragDrop += DGV_DragDrop; DGV.CellPainting += DGV_DragDrop_CellPainting; try { var dragDropEffect = DGV.DoDragDrop(row, DragDropEffects.Move); if (dragDropEffect == DragDropEffects.Move) { SelectDownloadRow(row); } else { DGV.Invalidate(); } } finally { DGV.DragOver -= DGV_DragOver; DGV.DragDrop -= DGV_DragDrop; DGV.CellPainting -= DGV_DragDrop_CellPainting; DGV.AllowDrop = false; } }
private void FiltrarBusqueda() { BT_BUSCAR.Enabled = false; _controlador.FiltrarBusqueda(); BT_BUSCAR.Enabled = true; ActualizarBusqueda(); DGV.Focus(); }
private void ListaFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Columns[3].Visible = _controlador.IsCantidadVisible; DGV.Columns[4].Visible = _controlador.IsPrecioVisible; DGV.Focus(); DGV.Refresh(); }