public Materiaux()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
loadMateriaux();
}
public Form1()
{
InitializeComponent();
lite = new DatabaseLite();
lite.initDatabase();
//connection();
connectedUser();
//init objects
fa = null;
ma = null;
de = null;
ehs = null;
shs = null;
risque = null;
spm = null;
ds = null;
//position
X = this.Top;
Y = this.Left;
menuStrip1.BackColor = Color.Black;
menuStrip1.ForeColor = Color.White;
decimalSeprerator = new CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = decimalSeprerator;
}
public CreerDocumentEntree(int piece = 0)
{
InitializeComponent();
decimalSeprerator = new CultureInfo("us-US");
Thread.CurrentThread.CurrentCulture = decimalSeprerator;
lite = new DatabaseLite();
lite.creatConnection();
listeMateriaux = new DataTable();
listeDepots = new DataTable();
listeMateriaux.Columns.Add("reference", typeof(Int64));
listeMateriaux.Columns.Add("designation", typeof(String));
listeDepots.Columns.Add("reference", typeof(Int64));
listeDepots.Columns.Add("designation", typeof(String));
materiel.DataSource = listeMateriaux;
materiel.DisplayMember = "designation";
materiel.ValueMember = "reference";
depotCombo.DataSource = listeDepots;
depotCombo.DisplayMember = "designation";
depotCombo.ValueMember = "reference";
this.typePiece = piece;
initField();
//materiel.SelectedIndex = -1;
changeTitle();
}
public ModifierMateriel(long matid)
{
matId = matid;
InitializeComponent();
index = -1;
lite = new DatabaseLite();
lite.creatConnection();
typesuivi = new DataTable();
typesuivi.Columns.Add("reference", typeof(int));
typesuivi.Columns.Add("designation", typeof(String));
suivistock.DataSource = typesuivi;
suivistock.DisplayMember = "designation";
suivistock.ValueMember = "reference";
listeFamille = new DataTable();
listeFamille.Columns.Add("reference", typeof(Int64));
listeFamille.Columns.Add("designation", typeof(String));
listeFamille.Columns.Add("code", typeof(String));
initFamille();
famille.DataSource = listeFamille;
famille.DisplayMember = "designation";
famille.ValueMember = "reference";
if (index != -1)
{
famille.SelectedIndex = index;
}
matref.Text = matId.ToString();
}
public Depots()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
fetchAllDepots();
}
public EntreeHS()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
decimalSeprerator = new CultureInfo("us-US");
Thread.CurrentThread.CurrentCulture = decimalSeprerator;
traitement = new traitementHS();
listMateriaux = new DataTable();
listMateriaux.Columns.Add("reference", typeof(Int64));
listMateriaux.Columns.Add("designation", typeof(String));
listMateriaux.Rows.Add(-1, "");
provenancehs = new DataTable();
provenancehs.Columns.Add("reference", typeof(int));
provenancehs.Columns.Add("designation", typeof(String));
initProvenance();
loadMateriaux();
materiel.DataSource = listMateriaux;
materiel.DisplayMember = "designation";
materiel.ValueMember = "reference";
}
public Familles()
{
InitializeComponent();
loaded = 0;
lite = new DatabaseLite();
lite.creatConnection();
loadFamille();
}
public GestionRisques()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
choixRupture = 1;
getMateriaux();
}
public DocumentsStocks()
{
InitializeComponent();
decimalSeprerator = new CultureInfo("us-US");
Thread.CurrentThread.CurrentCulture = decimalSeprerator;
lite = new DatabaseLite();
lite.creatConnection();
dateDebutFiltre = DateTime.Now.AddYears(-1).Date.ToString("yyyy-MM-dd");
dateFinFiltre = DateTime.Now.AddYears(1).Date.ToString("yyyy-MM-dd");
choixDocument = 0;
formLoaded = 0;
getAllDocuments();
}
public ModifierFamille(String code, String design)
{
fa_code = code;
fa_design = design;
InitializeComponent();
codefam.Text = code;
designfam.Text = design;
lite = new DatabaseLite();
lite.creatConnection();
Text = "FAMILLE: " + fa_design;
}
public StatsParMateriaux()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
listeMateriaux = new DataTable();
listeMateriaux.Columns.Add("reference", typeof(Int64));
listeMateriaux.Columns.Add("designation", typeof(String));
loadDataTable();
materiauxListCombo.DataSource = listeMateriaux;
materiauxListCombo.DisplayMember = "designation";
materiauxListCombo.ValueMember = "reference";
}
public ModifierDepot(int refdepot, String intitudepot, String adrd)
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
refDepot = refdepot;
intitu = intitudepot;
adrdepot = adrd;
intitule.Text = intitu;
adr.Text = adrd;
Text = "DEPOT: " + intitu;
}
public CreerMateriaux()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
listeFamille = new DataTable();
listeFamille.Columns.Add("reference", typeof(int));
listeFamille.Columns.Add("designation", typeof(String));
listeFamille.Rows.Add(-1, "");
initFamille();
artFamille.DataSource = listeFamille;
artFamille.DisplayMember = "designation";
artFamille.ValueMember = "reference";
typesuivi = new DataTable();
typesuivi.Columns.Add("reference", typeof(int));
typesuivi.Columns.Add("designation", typeof(String));
typesuivi.Rows.Add(1, "Entree/Sortie");
typesuivi.Rows.Add(2, "Sortie Uniquement");
suivistock.DataSource = typesuivi;
suivistock.DisplayMember = "designation";
suivistock.ValueMember = "reference";
}
public CreerFamilles()
{
InitializeComponent();
lite = new DatabaseLite();
lite.creatConnection();
}
public traitementHS()
{
mo_type = 0;
lite = new DatabaseLite();
lite.creatConnection();
}
