private void button1_Click(object sender, EventArgs e)
{
String designM = lite.stripString(artDesign.Text);
if (designM == "" || artFamille.Text == "")
{
MessageBox.Show("Tous les champs doivent etre remplis", "champ invalide", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
long refFamille = long.Parse(listeFamille.Rows[artFamille.SelectedIndex][0].ToString());
int choixsuivi = int.Parse(typesuivi.Rows[suivistock.SelectedIndex][0].ToString());
String designArt = lite.stripString(artDesign.Text);
String date = DateTime.Now.Date.ToString("yyyy-MM-dd");
String request = @"INSERT INTO F_MATERIEL (MA_DESIGN,MA_DATE,FA_CODE,MA_SUIVISTOCK)
VALUES('{0}','{1}',{2},{3})
";
request = String.Format(request, designArt.ToUpper(), date, refFamille, choixsuivi);
SQLiteCommand cmd = new SQLiteCommand(request, lite.getConnector());
cmd.ExecuteNonQuery();
artDesign.Text = "";
artFamille.SelectedIndex = 0;
//MessageBox.Show(designArt + " " + refFamille, "champ a enregistrer", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
public void updatefamille()
{
String design = lite.stripString(designfam.Text.ToUpper());
String request = @"UPDATE F_FAMILLE SET FA_INTITULE = '{0}', FA_CODE='{1}' WHERE FA_CODE = '{2}'";
request = string.Format(request, design, lite.stripString(fa_code), lite.stripString(fa_code));
using (SQLiteCommand cmd = new SQLiteCommand(request, lite.getConnector()))
{
cmd.ExecuteNonQuery();
}
}
public void updateMat()
{
String design = matdesign.Text.ToUpper();
int famId = int.Parse(listeFamille.Rows[famille.SelectedIndex][0].ToString());
int suivstock = int.Parse(typesuivi.Rows[suivistock.SelectedIndex][0].ToString());
String codefam = listeFamille.Rows[famille.SelectedIndex][2].ToString();
//MessageBox.Show(famId + ' ' + design + ' ' + codefam);
String request = @"UPDATE F_MATERIEL SET MA_DESIGN = '{0}', FA_CODE='{1}',MA_SUIVISTOCK = {3} WHERE MA_NO = {2}";
request = string.Format(request, lite.stripString(design), lite.stripString(codefam), matId, suivstock);
using (SQLiteCommand cmd = new SQLiteCommand(request, lite.getConnector()))
{
cmd.ExecuteNonQuery();
}
}
private void validerFamille_Click(object sender, EventArgs e)
{
if (familleRef.Text == "" || familleDesign.Text == "")
{
MessageBox.Show("Tous les champs sont obligatoires", "champ invalide", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (lite.familleExists(familleRef.Text.ToUpper()))
{
MessageBox.Show("Cette reference existe deja", "reference invalide", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
lite.createFamille(lite.stripString(familleRef.Text.ToUpper()), lite.stripString(familleDesign.Text.ToUpper()));
familleRef.Text = "";
familleDesign.Text = "";
ActiveControl = familleRef;
}
public void ligneMouvInsertion(Double mo_qte, int mo_type, String mo_date, String mo_piece, String mo_motif, int ma_no, int de_no)
{
mo_motif = lite.stripString(mo_motif);
String request = @"
INSERT INTO F_LIGNEMOUVEMENT (MO_QTE,MO_DATE,MO_TYPE,MO_PIECE,MO_MOTIF,MA_NO,DE_NO)
VALUES({0},'{1}',{2},'{3}','{4}',{5},{6})
";
request = String.Format(request, mo_qte, mo_date, mo_type, mo_piece, mo_motif, ma_no, de_no);
using (SQLiteCommand cmd = new SQLiteCommand(request, lite.getConnector()))
{
cmd.ExecuteNonQuery();
}
}
public void recherche(String motif)
{
listeMateriauxDatagrid.Rows.Clear();
SQLiteConnection conn = lite.getConnector();
String request = @"SELECT * FROM F_MATERIEL WHERE MA_DESIGN LIKE '%{0}%'";
request = String.Format(request, lite.stripString(motif));
String[] rows;
using (SQLiteCommand cmd = new SQLiteCommand(request, conn))
{
using (SQLiteDataReader sd = cmd.ExecuteReader())
{
while (sd.Read())
{
Double[] result = getMaterielStock(sd.GetInt64(0));
rows = new string[5];
rows[0] = sd.GetInt64(0).ToString();
rows[1] = sd.GetString(1);
if (result[0] > 0)
{
rows[2] = result[0].ToString();
}
if (result[1] > 0)
{
rows[3] = result[1].ToString();
}
if (result[2] > 0)
{
rows[4] = result[2].ToString();
}
listeMateriauxDatagrid.Rows.Add(rows);
}
}
}
if (listeMateriauxDatagrid.SelectedRows.Count > 0)
{
listeMateriauxDatagrid.SelectedRows[0].Selected = false;
}
}