private void Rank_SurChangementSelection(object sencder, EventArgs e) { StuffCharactRank SCR = new StuffCharactRank(); SCR = Program.GMBD.EnumererStuffCharactRank(new MyDB.CodeSql("DISTINCT stuff_char_rank.scr_id, stuff_char_rank.scr_fk_stuff_id, stuff_char_rank.scr_fk_char_rank_id, stuff_char_rank.scr_cost, stuff_char_rank.scr_min, stuff_char_rank.scr_max"), new MyDB.CodeSql(@"JOIN char_rank ON char_rank.cr_id = stuff_char_rank.scr_fk_char_rank_id JOIN rank ON char_rank.cr_fk_ra_id = rank.ra_id And rank.ra_id = {0} JOIN figurine ON figurine.fi_fk_character_id = {1} AND figurine.fi_fk_user_id = {2}", z_listeDeroulanteRank.RankSelectionnee.Id, z_listeDeroulanteChar.CharactSelectionnee.Id, Utilisateur.Id), new MyDB.CodeSql("WHERE stuff_char_rank.scr_fk_stuff_id = {0} AND char_rank.cr_fk_ch_id = {1}", z_listeDeroulanteStuff.StuffSelectionnee.Id, z_listeDeroulanteChar.CharactSelectionnee.Id), null).FirstOrDefault(); z_textBox.Text = SCR.Cout.ToString(); }
private void buttonAjouterEquipable_Click(object sender, EventArgs e) { if ((m_Stuff != null) && (z_listeDeroulanteCharRank.CharactSelectionnee != null)) { StuffCharactRank StChRa = new StuffCharactRank(); StChRa.CharactRank = z_listeDeroulanteCharRank.CharactSelectionnee; StChRa.Stuff = m_Stuff; StChRa.Cout = Convert.ToInt32(z_numericUpDownCout.Value); StChRa.Min = Convert.ToInt32(z_numericUpDownMinimum.Value); StChRa.Max = Convert.ToInt32(z_numericUpDownMaximum.Value); StChRa.Enregistrer(Program.GMBD.BD, StChRa); m_StuffCharactRankEquipables.Add(StChRa); z_fichePersonnageEquipement1.Caractere = m_StuffCharactRankEquipables; } }
public IEnumerable <StuffCharactRank> EnumererStuffCharactRank(MyDB.CodeSql ValeurSouhaitee, MyDB.CodeSql ClauseJoin, MyDB.CodeSql ClauseWhere, MyDB.CodeSql ClauseOrderBy) { if (ClauseWhere == null) { ClauseWhere = MyDB.CodeSql.Vide; } if (ClauseOrderBy == null) { ClauseOrderBy = MyDB.CodeSql.Vide; } if (ClauseJoin == null) { ClauseJoin = MyDB.CodeSql.Vide; } if (ValeurSouhaitee == null) { ValeurSouhaitee = new MyDB.CodeSql("*"); } return(StuffCharactRank.Enumerer(m_BD, m_BD.Enumerer("SELECT {0} FROM {1} {2} {3} {4}", ValeurSouhaitee, c_NomTable_StuffCharactRank, ClauseJoin, ClauseWhere, ClauseOrderBy))); }
/// <summary> /// Met à jour la listview des sous factions et y insére les elements /// </summary> /// <typeparam name="T"></typeparam> /// <param name="Entites"></param> /// <returns></returns> private bool MettreAJourListe <T>(IEnumerable <T> Entites) where T : class, IEntiteMySQL { bool EstCaractere = typeof(T).Equals(typeof(StuffCharactRank)); if (!EstCaractere) { return(false); } listViewCaractere.Items.Clear(); if (Entites == null) { return(false); } if (EstCaractere && (listViewCaractere.Columns.Count != 2)) { listViewCaractere.Columns.Clear(); listViewCaractere.Columns.Add(new ColumnHeader() { Name = "Caracteres", Text = "Caractères", TextAlign = HorizontalAlignment.Center, }); listViewCaractere.Columns.Add(new ColumnHeader() { Name = "Rank", Text = "Rank", TextAlign = HorizontalAlignment.Center, }); listViewCaractere.Columns.Add(new ColumnHeader() { Name = "Cout", Text = "Coût", TextAlign = HorizontalAlignment.Center, }); } foreach (T Entite in Entites) { StuffCharactRank Caractere = Entite as StuffCharactRank; if (EstCaractere) { ListViewItem NouvelElement = new ListViewItem() { Tag = Entite, Text = Caractere.CharactRank.Caractere.Name, }; NouvelElement.SubItems.Add(Caractere.CharactRank.Rank.Name); NouvelElement.SubItems.Add(Caractere.Cout.ToString()); listViewCaractere.Items.Add(NouvelElement); } } listViewCaractere.Visible = false; foreach (ColumnHeader Colonne in listViewCaractere.Columns) { Colonne.AutoResize(ColumnHeaderAutoResizeStyle.HeaderSize); } listViewCaractere.Visible = true; listViewCaractere_SelectedIndexChanged(listViewCaractere, EventArgs.Empty); return(true); }