private void dismissStripButton_Click(object sender, EventArgs e) { AnketaUvolitForm tmpform = new AnketaUvolitForm(); tmpform.Owner = this; DialogResult dRes = tmpform.ShowDialog(this); if (dRes == DialogResult.OK) { List <DataRowView> persons = GetSelectedRows(); List <long> personIdList = new List <long>(); foreach (DataRowView rowItem in persons) { personIdList.Add((long)rowItem[PersonView.id]); } PersonOrg.SetStateToUvolit(personIdList, _org.idVal, tmpform.DismissDate, _connection); foreach (DataRowView rowItem in persons) { rowItem[PersonView.state] = (int)PersonView.PersonState.Uvolen; rowItem[PersonView.dismissDate] = tmpform.DismissDate; rowItem[Check] = false; rowItem.EndEdit(); } _personBS.MoveFirst(); } }
private void FirstClient_Click(object sender, EventArgs e) { bs.DataSource = null; dgvClientManagement.DataSource = null; bs.DataSource = clientTable; dgvClientManagement.DataSource = bs; bs.MoveFirst(); }
private void Enable_Binding() { txt_Num_Etu.DataBindings.Add("Text", bs, "Num_Etu"); txt_Nom_Etu.DataBindings.Add("Text", bs, "Nom_Etu"); txt_Prenom_Etu.DataBindings.Add("Text", bs, "Prenom_Etu"); dt_DateN_Etu.DataBindings.Add("Value", bs, "DateN_Etu"); bs.MoveFirst(); }
/**/ lblMontant.Text = frmAjoutTransac.FormatDuMontant(lblMontant.Text); lblMontant.Text += " €"; chkRecette.DataBindings.Clear(); chkRecette.DataBindings.Add("Checked", bs, "recetteON"); chkPercu.DataBindings.Clear(); chkPercu.DataBindings.Add("Checked", bs, "percuON"); lblType.Text = typeTranscation[(int)ds.Tables["_Transaction"].Rows[0][6]]; lblEnregistrement.Text = "Enregistrement " + 1 + " / " + bs.Count; bs.MoveFirst(); } else { MessageBox.Show("Il n'y a pas de transaction dans la base de donnée !"); } } /* Lance la liaison de donnée vers les personnes*/ private void CliquerSurLiaisonPersonne(object sender, EventArgs e) { // Changer le titre de la fenêtre, et changer le tab (a suppr ? si y'a plus de titre ?) lblTitre.Text = "Récapitulatif : Personnes"; lblTitre.Left = Width / 2 - lblTitre.Width / 2; tabControl1.SelectedTab = tabPersonne; btnPersonne.BackColor = Color.Red; btnPersonne.Font = new Font(btnPersonne.Font, FontStyle.Bold); btnTransaction.BackColor = Color.White; btnTransaction.Font = new Font(btnTransaction.Font, FontStyle.Regular); // Retirer les autres liaisons en cours lblId.DataBindings.Clear(); lblDate.DataBindings.Clear(); lblDescription.DataBindings.Clear(); lblMontant.DataBindings.Clear(); chkRecette.DataBindings.Clear(); chkPercu.DataBindings.Clear(); lblType.DataBindings.Clear(); if (premierPersonne) { premierPersonne = false; // Création de la source de donnée pour les personnes new OleDbDataAdapter(new CMD(@"SELECT * FROM Personne", frmMain.con)).Fill(ds, "_Personne"); // Activation des boutons de navigation _btnLL.Enabled = true; _btnL.Enabled = true; _btnR.Enabled = true; _btnRR.Enabled = true; } if (ds.Tables["_Personne"].Rows.Count != 0) { bs.DataSource = ds.Tables["_Personne"]; // Liaison de donnée lblIdPersonne.DataBindings.Clear(); lblIdPersonne.DataBindings.Add("Text", bs, "codePersonne"); lblNom.DataBindings.Clear(); lblNom.DataBindings.Add("Text", bs, "nomPersonne"); lblPrenom.DataBindings.Clear(); lblPrenom.DataBindings.Add("Text", bs, "pnPersonne"); lblTelephone.DataBindings.Clear(); lblTelephone.DataBindings.Add("Text", bs, "telMobile"); _lblEnregistrement.Text = "Enregistrement " + 1 + " / " + bs.Count; bs.MoveFirst(); } else { MessageBox.Show("Il n'y a pas de transaction dans la base de donnée !"); } }
public void remplir_liste() { dgv_liste_clt.AutoGenerateColumns = false; //_dt_liste_Fournisseur = CLIENT_APP_PARAM.GEST.P_FOURNISSEUR.SELECT_ALL_FOURNISSEURS(); _dt_liste_Fournisseur = CLIENT_APP_PARAM.gcws.SELECT_ALL_FOURNISSEURS(); _bs_fournisseur.DataSource = _dt_liste_Fournisseur; dgv_liste_clt.DataSource = _bs_fournisseur; _bs_fournisseur.MoveFirst(); }
private void btnNext_Click(object sender, EventArgs e) { if (listBox1.SelectedIndex == listBox1.Items.Count - 1) { bsCat.MoveFirst(); } else { bsCat.MoveNext(); } }
// ---------------------------------- // ---Déplacement du BindingSource--- // ---------------------------------- private void CliquerSurPremierTransaction(object sender, EventArgs e) { bs.MoveFirst(); lblType.Text = typeTransaction[(int)ds.Tables["_Transaction"].Rows[0][6]]; lblMontant.Text += !lblMontant.Text.Contains('€') ? " €" : ""; lblEnregistrement.Text = "Enregistrement " + (bs.Position + 1) + " / " + bs.Count; if (ds.Tables["_Beneficiaires"] != null) { ds.Tables["_Beneficiaires"].Clear(); } new OleDbDataAdapter(new CMD(@"SELECT p.codePersonne, p.nomPersonne, p.pnPersonne FROM Personne p, Beneficiaires b WHERE b.codePersonne = p.codePersonne AND b.codeTransaction = " + lblId.Text, con)).Fill(ds, "_Beneficiaires"); dataGridView1.DataSource = ds.Tables["_Beneficiaires"]; }
private void fPhieuGiaohang_Load(object sender, EventArgs e) { bs.DataSource = _data.ds; this.bs.CurrentChanged += new EventHandler(bs_CurrentChanged); this.bs.DataMember = _data.mt.TableName; this.gcMt.DataSource = bs; gcDt.DataSource = bs; gcDt.DataMember = _data.ds.Relations[0].RelationName; bs_CurrentChanged(bs, new EventArgs()); if (bs.Count > 0) { bs.MoveFirst(); } this.KeyDown += new KeyEventHandler(fPhieuGiaohang_KeyDown); }
private void toolStripButton1_Click(object sender, EventArgs e) { if (_bindingSource != null) { _bindingSource.MoveFirst(); } }
private void btnPrim_Click(object sender, EventArgs e) { // move o ponteiro de registros para a primeira posição da tabela virtual - memória bs_clientes.MoveFirst(); // atualiza os campos do formulário com o registro posicionado na memória igualar_text(); }
public void initializationInvestProject() { BindingSource bindingSource = new BindingSource(); InvestProjectDAO dao = new InvestProjectDAO(); bindingSource.Clear(); bindingSource.DataSource = dao.getAll(); dataGridInvestProject.DataSource = bindingSource; bindingSource.CurrentItemChanged += BindingSource_CurrentItemChanged; if ((ScrollIndex >= 0) && (dataGridInvestProject.Rows.Count > 0)) { dataGridInvestProject.FirstDisplayedScrollingRowIndex = ScrollIndex; } if (BookMarkInvestProject != 0) { dataGridInvestProject.Rows[BookMarkInvestProject].Selected = true; bindingSource.Position = BookMarkInvestProject; } else { if (bindingSource.Count > 0) { bindingSource.MoveNext(); bindingSource.MoveFirst(); } //dataGridInvestProject.Rows[1].Selected = true; } }
private void CHM_COMPTE_CREDIT_CLIENT_Shown(object sender, EventArgs e) { try { //CLIENT_APP_PARAM.GEST.P_COMPTE_CLIENT.actualiser_compte(CODE_CLIENT); if (CODE_CLIENT == null || CODE_CLIENT == string.Empty) { throw new Exception("Code client invalid!"); } CLIENT_APP_PARAM.gcws.actualiser_compte(CODE_CLIENT); //dt = CLIENT_APP_PARAM.GEST.P_COMPTE_CLIENT.LOAD_COMPTE_CLIENT(CODE_CLIENT); dt = CLIENT_APP_PARAM.gcws.LOAD_COMPTE_CLIENT(CODE_CLIENT); bs.DataSource = dt; bs.MoveFirst(); if (bs.Current != null) { DataRowView drv = (DataRowView)bs.Current; CODE_COMPTE = drv["CODE_COMPTE_CLIENT"].ToString(); NUM_COMPTE.Text = drv["NUM_COMPTE_CLIENT"].ToString(); CREDIT.Text = drv["TOTAl_CREDIT_CLT"].ToString(); PAYE.Text = drv["TOTAL_PAYE_CLT"].ToString(); } //dt_clt = CLIENT_APP_PARAM.GEST.P_CLIENT.LOAD_CLIENT(CODE_CLIENT); dt_clt = CLIENT_APP_PARAM.gcws.LOAD_CLIENT(CODE_CLIENT); bs_clt.DataSource = dt_clt; DataRowView dr = (DataRowView)bs_clt.Current; CLIENT.Text = dr["RS_CLIENT"].ToString(); } catch (Exception er) { MessageBox.Show(er.Message, this.Text); this.Close(); } }
private void btnSuppr_Click(object sender, EventArgs e) { try { var filteredData = Modele.MaConnexion.LigneFraisHorsForfait.ToList() .Where(x => x.id == (int.Parse(dgvAutresFrais.SelectedRows[0].Cells[0].Value.ToString()))); if (filteredData.Count() > 0) { BindingSource bsMaLigne = new BindingSource(); bsMaLigne.DataSource = filteredData; // application du filtre LigneFraisHorsForfait maLigne = new LigneFraisHorsForfait(); bsMaLigne.MoveFirst(); maLigne = (LigneFraisHorsForfait)bsMaLigne.Current; Modele.MaConnexion.LigneFraisHorsForfait.Remove(maLigne); Modele.MaConnexion.SaveChanges(); chargement(); MessageBox.Show("Ligne supprimé"); } else { MessageBox.Show("Aucune ligne sélectionnée"); } } catch { MessageBox.Show("Aucune ligne sélectionnée"); } }
private void btnSave_Click(object sender, EventArgs e) { //Set params DateTime dtStartDate = dtpStartDate.Value; DateTime dtExpiryDate = dtpExpiryDate.Value; string sPaymentMethod = txtPaymentMethod.Text; string sDepositPaid = ddlDepositPaid.Text; int iClientId = int.Parse(ddlClient.SelectedValue.ToString()); int iPropertyId = int.Parse(ddlProperty.SelectedValue.ToString()); try { int iNewLeaseNumber = InsertLease(dtStartDate, dtExpiryDate, sPaymentMethod, sDepositPaid, iClientId, iPropertyId); lblNumber.Text = iNewLeaseNumber.ToString(); } catch (Exception exc) { MessageBox.Show(exc.ToString()); } finally { conn.Close();//Just making 100% sure the connetion closes } //Set controls btnEditLease.Enabled = true; btnDelete.Enabled = true; bsLease.MoveFirst(); }
private void toolStripButton1_Click(object sender, EventArgs e) { // If you are not at the end of the list, move to the next item // in the BindingSource. while (true) { if (_customerBindingSource.Position + 1 < _customerBindingSource.Count) { DataRowView curr = (DataRowView)_customerBindingSource.Current; string str = curr[3].ToString(); if (str.IndexOf("'", 0, StringComparison.Ordinal) >= 0) { str = str.Remove(0, 1); // str = str.Remove(str.Length - 1); curr[3] = str; } _customerBindingSource.MoveNext(); } // Otherwise, move back to the first item. else { _customerBindingSource.MoveFirst(); break; } } // Force the form to repaint. this.Invalidate(); }
/* * afficherRes : void : met à jour les données affichées lorsque l'on clique sur un bouton * Entrée : * sender : object : bouton sur lequel l'utilisateur a appuyé * e : EventArgs : évènement (ex : click sur le bouton) * Sortie : * void */ private void afficherRes(object sender, EventArgs e) { //on récupère le bouton sur lequel l'utilisateur a appuyé Button b = (Button)sender; //selon le bouton on avance, recule, ou bien affichons la première/dernière transaction if (b == btnPremier) { transactionsBS.MoveFirst(); } else if (b == btnPrecedent) { transactionsBS.MovePrevious(); } else if (b == btnSuivant) { transactionsBS.MoveNext(); } else if (b == btnDernier) { transactionsBS.MoveLast(); } //on met à jour le numéro de transaction, ainsi que les personnes concernées lblPage.Text = string.Format(Program.settings.localize.Translate("page_{0}_of_{1}"), transactionsBS.Position + 1, transactionsBS.Count); updatePersonnes(); }
public fCheckOut(string MT62ID) { InitializeComponent(); _MT62ID = MT62ID; string sql = "select getdate()"; ngayht = _dbData.GetValue(sql); _data = new DataCheckOut(MT62ID); bs.DataSource = _data.ds; bs.DataMember = _data.ds.Tables[1].TableName; bs.CurrentChanged += new EventHandler(bs_CurrentChanged); gridControl1.DataSource = bs; bs.MoveFirst(); bs_CurrentChanged(bs, new EventArgs()); //Biding GetBinding(); GetData4Lookup(); repositoryItemGridLookUpEdit1.DataSource = _data.dmVT; repositoryItemGridLookUpEdit1.EditValueChanged += new EventHandler(repositoryItemGridLookUpEdit1_EditValueChanged); repositoryItemGridLookUpEdit2.DataSource = _data.dmDV; gridView2.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(gridView2_FocusedRowChanged); gridLookUpEdit1.EditValueChanged += new EventHandler(gridLookUpEdit1_EditValueChanged); gridView1.MouseUp += new MouseEventHandler(gridView1_MouseUp); }
private void cboMois_SelectedIndexChanged(object sender, EventArgs e) { try { var LQuery = Modele.MaConnexion.fichefrais.ToList() .Where(x => x.idVisiteur == cboMois.SelectedValue.ToString()); BindingSource bs = new BindingSource(); bs.DataSource = LQuery; bs.MoveFirst(); fichefrais ffrais = (fichefrais)bs.Current; LigneFraisHorsForfait lhf = (LigneFraisHorsForfait)bs.Current; cboMois.DataSource = ffrais.mois; // affiche dans la dgv les éléments forfaitisés bsMois.DataSource = LQuery; txtNbJustif.Text = ffrais.nbJustificatifs.ToString(); dgvFraisForfait.DataSource = bsMois; dgvFraisForfait.Columns[0].HeaderText = "libelle"; dgvFraisForfait.Columns[1].HeaderText = "montant"; dgvFraisForfait.Columns[2].Visible = false; //afiche dans la dgv les éléments hors forfaits dgvFraisHorsForfait.DataSource = bsMois; dgvFraisHorsForfait.Columns[0].HeaderText = lhf.libelle; dgvFraisHorsForfait.Columns[1].HeaderText = lhf.date.ToString(); dgvFraisHorsForfait.Columns[2].HeaderText = lhf.montant.ToString(); } catch { } }
private void btnFirst_Click(object sender, EventArgs e) { if (src != null) { src.MoveFirst(); setImage(); } }
private void btn_primeiro_Click_1(object sender, EventArgs e) { //ponteiro --> primeiro registro bs_disc.MoveFirst(); //iguala os dados igualar_text(); }
private void btnXoa_Click(object sender, EventArgs e) { if (m_objBindingSrc.Count > 0) { m_objBindingSrc.RemoveCurrent(); m_objBindingSrc.MoveFirst(); } }
/// <summary> /// 首记录 /// </summary> private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { bs.MoveFirst(); _brFrist.Enabled = false; _brPrv.Enabled = false; _brNext.Enabled = true; _brLast.Enabled = true; }
private void btnAjout_Click(object sender, EventArgs e) { // vérifier qu’une ligne est bien sélectionnée dans le dataGridView if (dataGV.SelectedRows.Count == 1) { // appel de la méthode du controleur en mode update et avec la valeur de l’IdPersonne en clé Controleur.crud_personne('c', ""); // mise à jour du dataGridView en affichage bindingSource1.MoveLast(); bindingSource1.MoveFirst(); dataGV.Refresh(); } else { MessageBox.Show("Sélectionner une ligne à modifier"); } }
private void BtnCancelar_Click(object sender, EventArgs e) { BtnNovo.Enabled = true; BtnExcluir.Enabled = true; dados.CancelEdit(); dados.RemoveCurrent(); dados.MoveFirst(); }
public CHM_FRM_NV_FACTURE(string code_bl, decimal CODE_MAG) { InitializeComponent(); _CODE_B_LIV = code_bl; bs_Detail_fc = new BindingSource(); bs_Detail_fc.DataSource = dS_MOUV1.LIGNE_FACTURE; gridControl1.DataSource = bs_Detail_fc; try { dt_ligne_facture = CLIENT_APP_PARAM.gcws.LOAD_SCHEMA_LG_BON_LIVRAISON(); bs_ligne_facture.DataSource = dt_ligne_facture; dataGridViewLG_B_LIV.AutoGenerateColumns = false; dataGridViewLG_B_LIV.DataSource = bs_ligne_facture; dt_b_liv_client = CLIENT_APP_PARAM.gcws.LOAD_B_LIV_FACTURE(_CODE_B_LIV); CODE_CLIENT = (decimal)dt_b_liv_client.Rows[0]["CODE_CLIENT"]; dt_client = CLIENT_APP_PARAM.gcws.LOAD_CLIENT(CODE_CLIENT.ToString()); bs_client.DataSource = dt_client; bs_client.MoveFirst(); DataRowView drv_clt = (DataRowView)bs_client.Current; REF_CLIENT.Text = drv_clt["REF_CLIENT"].ToString(); RS_CLIENT.Text = drv_clt["RS_CLIENT"].ToString(); TEL_CLIENT.Text = drv_clt["TEL_CLIENT"].ToString(); TIMBRE.Value = Convert.ToDecimal(CLIENT_APP_PARAM.gcws.GetParamValue("TIMBRE", 1).Replace(',', '.')); chargerPieceSansFactureClient(CODE_CLIENT); //chargerBonLivraisonClient(CODE_CLIENT); //foreach (Control c in p_Commandes_ENCOURS.Controls) //{ // if (c.Name == _CODE_B_LIV) // { // (c as CHM_SELECTION_CONTROL).selection_state.Checked = true; // break; // } //} foreach (DataRow dr in dS_MOUV1.V_PIECE_CLIENT_SANS_FACTURE.Rows) { if (dr["CODE_PIECE"].ToString() == _CODE_B_LIV) { dr["CHECKED"] = "True"; break; } } rb_periode_CheckedChanged(null, null); chM_CMP_VALIDATION1.button1.Click += new EventHandler(BTN_ENREGISTRER_Click); chM_CMP_VALIDATION1.button2.Click += new EventHandler(button2_Click); entete_Formulaire_21.btn_refresh.Visible = false; } catch (Exception er) { MessageBox.Show(er.Message); } }
private void btnPrimeiro_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!VerificarDados()) { return; } bndVeiculoGrid.MoveFirst(); Navegar(); }
public static void MoveFirst(DataTable table) { BindingSource bs = GetBindingSource(table); if (bs != null) { bs.MoveFirst(); } }
private void CHM_IDENTIFICATION_UTILISATEUR_Shown(object sender, EventArgs e) { try { LOGIN_USER.Focus(); //CLIENT_APP_PARAM.GEST = (CHM_GESTION_COMERCIALE.CHM_GESTION)Activator.GetObject(typeof(CHM_GESTION_COMERCIALE.CHM_GESTION), "tcp://" + CLIENT_APP_PARAM.serveur + ":" + CLIENT_APP_PARAM.port + "/" + CLIENT_APP_PARAM.instance); //CLIENT_APP_PARAM.connect(); //dt = CLIENT_APP_PARAM.GEST.P_UTILISATEUR.RECHERCHE_UTILISATEUR(LOGIN_USER.Text); dt = CLIENT_APP_PARAM.gcws.RECHERCHE_UTILISATEUR(LOGIN_USER.Text); bs.DataSource = dt; bs.MoveFirst(); } catch (Exception er) { MessageBox.Show(er.Message, "Connection error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDau_Click(object sender, EventArgs e) { bsBoMon.MoveFirst(); btnDau.Enabled = false; btnTruoc.Enabled = false; btnKe.Enabled = true; btnCuoi.Enabled = true; txtViTri.Text = (bsBoMon.Position + 1) + " / " + bsBoMon.Count; }
private void FirstRecord_Click(object sender, EventArgs e) { // Переход на первую запись bsProizvAvto.MoveFirst(); int curRecord = bsProizvAvto.Position; dataGridView1.CurrentCell.Selected = true; dataGridView1.CurrentCell = dataGridView1[0, curRecord]; }