static void Main()
{
OraTest ot = new OraTest();
ot.Connect();
ot.Close();
}
static void Main()
{
Example OraTest = new OraTest();
OraTest.Connect();
OraTest.Close();
}
private void button1_Click_1(object sender, EventArgs e)
{
OraTest ora = new OraTest();
var bonbons_type = ora.GetBonbons_type();
var conditionnement = ora.GetConditionnements();
var textures = ora.GetTextures();
var couleur = ora.GetCouleur();
var variante = ora.GetVariante();
var pays = ora.GetPays();
var bonbons = ora.GetBonbons();
int i = 0;
Random rad = new Random();
Random rand = new Random();
//int total = dico.Select(x => x.Value).Sum();
double nbLign = (double)numericUpDown2.Value;
double sigma_nb_command = 10;
double mu_nb_command = nbLign;
double sigma_bonbon = 100;
int mu_bonbon = bonbons.Count() / 2;
double sigma_pays = 1;
double mu_pays = pays.Count() / 2;
while (i++ < numericUpDown1.Value)
{
double randGauss = RandomExtensions.NextGaussian(rand, mu_nb_command, sigma_nb_command);
double randGaussPays = RandomExtensions.NextGaussian(rand, mu_pays, sigma_pays);
string sql = $"INSERT INTO COMMANDES VALUES (0, {Math.Round(randGaussPays)})";
ora.InsertCommandes(sql);
int j = 0;
//chaque ligne dans la commande
while (j++ < randGauss)
{
double random = RandomExtensions.NextGaussian(rad, mu_bonbon, sigma_bonbon);
string sqlLigne = $"INSERT INTO COMMANDES_LIGNES VALUES (0,{Math.Round(random)},COMMANDES_SEQ.CURRVAL)";
ora.InsertCommandes(sqlLigne);
}
}
}
private void button6_Click(object sender, EventArgs e)
{
OraTest ora = new OraTest();
ora.GetNbFabricationOpti();
}
private void button5_Click(object sender, EventArgs e)
{
OraTest ora = new OraTest();
ora.GetNbVarienteOpti();
}
private void button4_Click(object sender, EventArgs e)
{
OraTest ora = new OraTest();
ora.GetNbPickingForEachCommand();
}
private void button3_Click(object sender, EventArgs e)
{
OraTest ora = new OraTest();
ora.GetNbFabricationForEachCommand();
}
private void button2_Click(object sender, EventArgs e)
{
OraTest ora = new OraTest();
ora.GetNbVarienteForEachCommand();
}
private void button7_Click(object sender, EventArgs e)
{
OraTest ora = new OraTest();
ora.GetNbPickingOpti();
}
static void Main(string[] args)
{
OraTest ot = new OraTest();
ot.Connect();
}
public void Get()
{
OraTest testCon = new OraTest();
testCon.Connect();
}