static void Main()
{
s_GMBD = new GMBD();
s_GMBD.BD.SurChangementEtatConnexion += BD_SurChangementEtatConnexion;
if (!s_GMBD.Initialiser())
{
MessageBox.Show("Erreur d'accès à la base de données !", "EICE_WARGAME", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
return;
}
else
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
/*
* foreach (Stuff Stuff in s_GMBD.EnumererStuff(null, null, null, PDSGBD.MyDB.CreerCodeSql("ORDER BY st_name ASC")))
* {
* System.Diagnostics.Debug.WriteLine(string.Format("Stuff {0}", Stuff.Name));
*
* foreach (StuffFeature StuffFeature in Stuff.Features)
* {
* System.Diagnostics.Debug.WriteLine(string.Format("* Caractéristique: {0}, Valeur: {1} ", StuffFeature.Feature.Name, StuffFeature.Value));
* }
* }*/
Application.Run(new Form_Principal());
}
}
private void PageImpressionCarteUnite_Load(object sender, EventArgs e)
{
string Query = string.Format(@"SELECT army.ar_name, subunity.su_name, figurine.fi_id, charact.ch_name, rank.ra_name, stuff.st_name, stuff_char_rank.scr_cost, subunity.su_id FROM army
JOIN army_unity ON army_unity.aru_army_id = army.ar_id
JOIN army_unity_figurine ON army_unity_figurine.auf_fk_army_unity_id = army_unity.aru_id
JOIN char_rank ON army_unity_figurine.auf_fk_rank_id = char_rank.cr_id
JOIN figurine ON army_unity_figurine.auf_fk_figurine_id = figurine.fi_id
JOIN figurine_stuff ON fs_fk_figurine_id = fi_id
JOIN stuff on stuff.st_id = figurine_stuff.fs_fk_stuff_id
JOIn stuff_char_rank ON stuff_char_rank.scr_fk_stuff_id = stuff.st_id
JOIN rank ON rank.ra_id = char_rank.cr_fk_ra_id
JOIN charact ON figurine.fi_fk_character_id = charact.ch_id
JOIN subunity ON char_rank.cr_sub_id = subunity.su_id
JOIN user ON user.u_id = army.ar_fk_user_id GROUP BY fs_id");
//Ici est la bonne clause, mais, comme Army ne va pas jusque là . . . WHERE user.u_id = {0} AND ar_id = {0}", Utilisateur.Id, Army.Id);
MySqlCommand Command = new MySqlCommand(Query);
DataTable DTC = new DataTable();
a_db = new GMBD();
MySqlConnection Connexion = new MySqlConnection(a_db.Param());
Command.Connection = Connexion;
Connexion.Open();
DTC.Load(Command.ExecuteReader());
Connexion.Close();
int lastEntry = -1;
int lastEntrySub = -1;
for (int i = 0; i < DTC.Rows.Count; i++)
{
int test = int.Parse(DTC.Rows[i][2].ToString());
string NomSousUnite = DTC.Rows[i][1].ToString();
string NomFIgurine = DTC.Rows[i][3].ToString();
string NomRank = DTC.Rows[i][4].ToString();
string NomEquipement = DTC.Rows[i][5].ToString();
string Cost = DTC.Rows[i][6].ToString();
int testsub = int.Parse(DTC.Rows[i][7].ToString());
if (test == lastEntry)
{
tableLayoutPanel1.Controls.Add(new Label()
{
Text = "", Dock = DockStyle.Fill
}, 0, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomRank, Dock = DockStyle.Fill
}, 2, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomEquipement, Dock = DockStyle.Fill
}, 3, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = Cost, Dock = DockStyle.Fill
}, 4, i + 1);
lastEntry = test;
lastEntrySub = testsub;
}
else if (testsub == lastEntrySub)
{
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomFIgurine, Dock = DockStyle.Fill
}, 0, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomRank, Dock = DockStyle.Fill
}, 2, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomEquipement, Dock = DockStyle.Fill
}, 3, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = Cost, Dock = DockStyle.Fill
}, 4, i + 1);
lastEntry = test;
lastEntrySub = testsub;
}
else
{
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomSousUnite, Dock = DockStyle.Fill
}, 0, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomFIgurine, Dock = DockStyle.Fill
}, 1, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomRank, Dock = DockStyle.Fill
}, 2, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = NomEquipement, Dock = DockStyle.Fill
}, 3, i + 1);
tableLayoutPanel1.Controls.Add(new Label()
{
Text = Cost, Dock = DockStyle.Fill
}, 4, i + 1);
lastEntry = test;
lastEntrySub = testsub;
}
}
}
