protected override void OnCreate (Bundle savedInstanceState) { base.OnCreate (savedInstanceState); SetContentView (Resource.Layout.ListeLivraisons); type = Intent.GetStringExtra ("TYPE"); if (type == "RAM") { tyS = "RAM"; tyM = "C"; } else { tyS = "LIV"; tyM = "L"; } //declaration des clicks btns Button btngrpAll = FindViewById<Button> (Resource.Id.btn_all); Button btngrp1 = FindViewById<Button> (Resource.Id.btn_1); Button btngrp2 = FindViewById<Button> (Resource.Id.btn_2); Button btngrp3 = FindViewById<Button> (Resource.Id.btn_3); Button btngrp4 = FindViewById<Button> (Resource.Id.btn_4); LinearLayout btnsearch = FindViewById<LinearLayout> (Resource.Id.btn_search); Button btntrait = FindViewById<Button> (Resource.Id.btn_traite); //FONTS btngrpAll.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal); btngrp1.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal); btngrp2.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal); btngrp3.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal); btngrp4.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal); btntrait.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal); if (type == "RAM") { btntrait.Text = "Ramasses"; } else { btntrait.Text = "Livraisons"; } btngrpAll.Click += delegate { btngrpAll_Click(); }; btngrp1.Click += delegate { btngrp1_Click(); }; btngrp2.Click += delegate { btngrp2_Click(); }; btngrp3.Click += delegate { btngrp3_Click(); }; btnsearch.Click += delegate { btnsearch_Click(); }; btntrait.Click += delegate { btntrait_Click(); }; //Mise dans un Array des Groupage string dbPath = System.IO.Path.Combine(System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal), "ormDMS.db3"); var db = new SQLiteConnection(dbPath); var grp = db.Query<TablePositions> ("SELECT * FROM TablePositions WHERE StatutLivraison = ? AND typeMission= ? AND typeSegment= ? AND Userandsoft = ? OR StatutLivraison = ? AND typeMission= ? AND typeSegment= ? AND Userandsoft = ? GROUP BY groupage",1,tyM,tyS,Data.userAndsoft,2,tyM,tyS,Data.userAndsoft); int i = 1; int countGrp = 0; foreach (var item in grp){ Arraygrp[i] = item.groupage; i++; countGrp++; } switch (countGrp) { case 0: //btn all big size btngrpAll.SetWidth (5000); //afficher pas de tournée au milieu et sur le btnall btngrpAll.Text = "Aucune position"; break; case 1: //btn all avec le num de grp btngrpAll.SetWidth (5000); btngrpAll.Text = Arraygrp[1]; break; case 2: //afficher le btn 1 et 2 btngrp1.Visibility = ViewStates.Visible; btngrp1.Text = Arraygrp[1]; btngrp2.Visibility = ViewStates.Visible; btngrp2.Text = Arraygrp[2]; break; case 3: //afficher le btn 1,2 et 3 btngrp1.Visibility = ViewStates.Visible; btngrp1.Text = Arraygrp[1]; btngrp2.Visibility = ViewStates.Visible; btngrp2.Text = Arraygrp[2]; btngrp3.Visibility = ViewStates.Visible; btngrp3.Text = Arraygrp[3]; break; case 4: //afficher le btn 1,2,3 et 4 btngrp1.Visibility = ViewStates.Visible; btngrp1.Text = Arraygrp[1]; btngrp2.Visibility = ViewStates.Visible; btngrp2.Text = Arraygrp[2]; btngrp3.Visibility = ViewStates.Visible; btngrp3.Text = Arraygrp[3]; btngrp4.Visibility = ViewStates.Visible; btngrp4.Text = Arraygrp[4]; break; default: //btn all big size btngrpAll.SetWidth (5000); //afficher pas de tournée au milieu et sur le btnall btngrpAll.Text = "Aucune position"; break; } //LISTVIEW bodyListView = FindViewById<ListView> (Resource.Id.bodylist); bodyItems = new List<TablePositions> (); bodyListView.ItemClick += MListView_ItemClick; bodyListView.ItemLongClick += MListView_ItemLongClick; adapter = new ListViewAdapterMenu (this, bodyItems); bodyListView.Adapter = adapter; //bodyListView.ItemClick += MListView_ItemClick; initListView ("SELECT * FROM TablePositions WHERE StatutLivraison = '1' AND typeMission='"+tyM+"' AND typeSegment='"+tyS+"' AND Userandsoft='"+Data.userAndsoft+"' OR StatutLivraison = '2' AND typeMission='"+tyM+"' AND typeSegment='"+tyS+"' AND Userandsoft='"+Data.userAndsoft+"' ORDER BY Ordremission DESC"); }
protected override void OnResume() { base.OnResume(); //Mise dans un Array des Groupage string dbPath = System.IO.Path.Combine(System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal), "ormDMS.db3"); var db = new SQLiteConnection(dbPath); var grp = db.Query<TablePositions> ("SELECT * FROM TablePositions WHERE StatutLivraison = ? AND typeMission= ? AND typeSegment= ? AND Userandsoft = ? GROUP BY groupage",0,tyM,tyS,Data.userAndsoft); int i = 1; int countGrp = 0; foreach (var item in grp){ Arraygrp[i] = item.groupage; i++; countGrp++; } switch (countGrp) { case 0: //btn all big size btngrpAll.SetWidth (5000); //afficher pas de tournée au milieu et sur le btnall btngrpAll.Text = "Aucune position"; break; case 1: //btn all avec le num de grp btngrpAll.SetWidth (5000); btngrpAll.Text = Arraygrp[1]; break; case 2: //afficher le btn 1 et 2 btngrp1.Visibility = ViewStates.Visible; btngrp1.Text = Arraygrp[1]; btngrp2.Visibility = ViewStates.Visible; btngrp2.Text = Arraygrp[2]; break; case 3: //afficher le btn 1,2 et 3 btngrp1.Visibility = ViewStates.Visible; btngrp1.Text = Arraygrp[1]; btngrp2.Visibility = ViewStates.Visible; btngrp2.Text = Arraygrp[2]; btngrp3.Visibility = ViewStates.Visible; btngrp3.Text = Arraygrp[3]; break; case 4: //afficher le btn 1,2,3 et 4 btngrp1.Visibility = ViewStates.Visible; btngrp1.Text = Arraygrp[1]; btngrp2.Visibility = ViewStates.Visible; btngrp2.Text = Arraygrp[2]; btngrp3.Visibility = ViewStates.Visible; btngrp3.Text = Arraygrp[3]; btngrp4.Visibility = ViewStates.Visible; btngrp4.Text = Arraygrp[4]; break; default: //btn all big size btngrpAll.SetWidth (5000); //afficher pas de tournée au milieu et sur le btnall btngrpAll.Text = "Aucune position"; break; } //LISTVIEW bodyListView = FindViewById<ListView> (Resource.Id.bodylist); bodyItems = new List<TablePositions> (); bodyListView.ItemClick += MListView_ItemClick; bodyListView.ItemLongClick += MListView_ItemLongClick; adapter = new ListViewAdapterMenu (this, bodyItems); bodyListView.Adapter = adapter; initListView ("SELECT * FROM TablePositions WHERE StatutLivraison = '0' AND typeMission= '"+tyM+"' AND typeSegment= '"+tyS+"' AND Userandsoft = '"+Data.userAndsoft+"'"); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate (savedInstanceState); SetContentView (Resource.Layout.Menu); iniView (); Button ajout = FindViewById<Button> (Resource.Id.ajouttournee); //TEST //editText = FindViewById<EditText>(Resource.Id.passwordfield); bodyListView = FindViewById<ListView> (Resource.Id.bodylist); bodyItems = new List<TablePosition> (); adapter = new ListViewAdapterMenu (this, bodyItems); bodyListView.Adapter = adapter; initListView ("SELECT * FROM TablePosition"); ajout.Click += delegate { Dialog dialog = new Dialog (this); dialog.Window.RequestFeature (WindowFeatures.NoTitle); dialog.Window.SetBackgroundDrawableResource (Resource.Drawable.bktransbox); dialog.SetContentView (Resource.Layout.Boxajout); Button cree = dialog.FindViewById<Button> (Resource.Id.btn_cree); EditText codeeditText = dialog.FindViewById<EditText> (Resource.Id.codetournee); cree.Click += delegate { ShowProgress (progress => AndHUD.Shared.Show (this, "Création... " + progress + "%", progress, MaskType.Clear)); Thread thread = new Thread (() => CreateVoyage (codeeditText.Text)); thread.Start (); while (thread.IsAlive) { iniView (); } dialog.Dismiss (); }; cree.LongClick += delegate { DBRepository dbr = new DBRepository (); dbr.DropTableStatut (); initListView("SELECT * FROM TablePosition"); iniView (); }; dialog.SetCancelable (true); dialog.Show (); }; //SIMULATION D'insert Button btntest = FindViewById<Button> (Resource.Id.nomtournee); btntest.Click += delegate { ShowProgressInsert (progress => AndHUD.Shared.Show (this, "Insertion ... " + progress + "%", progress, MaskType.Clear)); Thread threadinsert = new Thread (() => GetPosData ("1406026994")); threadinsert.Start (); //GetPosData (stringbuilder.ToString()); }; }