public async Task <DaneMMElem> Pobierztwrkod(int twrnumer) { DaneMMElem daneMMElem = new DaneMMElem(); try { var Webquery = $@"cdn.PC_WykonajSelect N'Select Twr_Gidnumer, Twr_Kod, Twr_Nazwa, Twr_Katalog Twr_Symbol, cast(twc_wartosc as decimal(5,2))Cena , cast(sum(TwZ_Ilosc) as int)Ilosc, case when len(twr_kod) > 5 and len(twr_url)> 5 then replace(twr_url, substring(twr_url, 1, len(twr_url) - len(twr_kod) - 4), substring(twr_url, 1, len(twr_url) - len(twr_kod) - 4) + ''Miniatury/'') else twr_kod end as Url ,Twr_Ean Ean from cdn.TwrKarty join cdn.TwrCeny on Twr_GIDNumer = TwC_TwrNumer and TwC_TwrLp = 2 left join cdn.TwrZasoby on Twr_GIDNumer = TwZ_TwrNumer where Twr_Gidnumer={twrnumer} group by Twr_Gidnumer,twr_kod, twr_nazwa, Twr_Katalog,twc_wartosc, twr_url,twr_ean'" ; var dane = await App.TodoManager.PobierzDaneZWeb <DaneMMElem>(Webquery); if (dane.Count > 0) { daneMMElem = dane[0]; } } catch (Exception ex) { Debug.WriteLine(ex); } return(daneMMElem); }
public async Task <bool> DeleteFromSkanAndPolozenie(int TrnGidnumer, int twrnumer) { DaneMMElem daneMMElem = new DaneMMElem(); try { var Webquery = $@"cdn.PC_WykonajSelect N' delete from [CDN].[PC_MsInwentory] where MsI_TrnNumer = {TrnGidnumer} and MsI_TwrNumer={twrnumer} if @@ROWCOUNT>0 select MsI_TwrNumer=1'"; var dane = await App.TodoManager.PobierzDaneZWeb <DaneMMElem>(Webquery); if (dane.Count > 0) { daneMMElem = dane[0]; return(true); } } catch (Exception ex) { Debug.WriteLine(ex); } return(false); }
//public RaportLista_AddTwrKod(DaneMMElem mmka) //edycja //{ // this.Title = "Dodaj MM"; // _MMElement = mmka; // NavigationPage.SetHasNavigationBar(this, false); // StackLayout stackLayout = new StackLayout(); // StackLayout stackLayout_gl = new StackLayout(); // StackLayout stack_naglowek = new StackLayout(); // Label lbl_naglowek = new Label(); // lbl_naglowek.HorizontalOptions = LayoutOptions.CenterAndExpand; // lbl_naglowek.VerticalOptions = LayoutOptions.Start; // lbl_naglowek.Text = "Szczegóły pozycji"; // lbl_naglowek.FontSize = 20; // lbl_naglowek.TextColor = Color.Bisque; // lbl_naglowek.BackgroundColor = Color.DarkCyan; // stack_naglowek.HorizontalOptions = LayoutOptions.FillAndExpand; // stack_naglowek.VerticalOptions = LayoutOptions.Start; // stack_naglowek.BackgroundColor = Color.DarkCyan; // stack_naglowek.Children.Add(lbl_naglowek); // stackLayout_gl.Children.Add(stack_naglowek); // img_foto = new Image(); // img_foto.Source = mmka.Url.Replace("Miniatury/", ""); // var tapGestureRecognizer = new TapGestureRecognizer(); // tapGestureRecognizer.Tapped += (s, e) => // { // Launcher.OpenAsync(mmka.Url.Replace("Miniatury/", "")); // }; // img_foto.GestureRecognizers.Add(tapGestureRecognizer); // stackLayout.Children.Add(img_foto); // //_gidnumer = mmka.gi; // lbl_stan = new Label(); // lbl_stan.HorizontalOptions = LayoutOptions.Center; // lbl_stan.Text = "Ilość : " + mmka.Ilosc + " szt"; // stackLayout.Children.Add(lbl_stan); // lbl_twrkod = new Label(); // lbl_twrkod.HorizontalOptions = LayoutOptions.Center; // lbl_twrkod.Text = "Kod towaru : " + mmka.Twr_Kod; // lbl_ean = new Label(); // lbl_ean.HorizontalOptions = LayoutOptions.Center; // lbl_ean.Text = "Ean : " + mmka.Ean; // entry_kodean = new Entry() // { // HorizontalOptions = LayoutOptions.Center, // Text = "Ean : " + mmka.Ean, // }; // //lbl_symbol = new Label(); // //lbl_symbol.HorizontalOptions = LayoutOptions.Center; // //lbl_symbol.Text = "Symbol : " + mmka.symbol; // lbl_nazwa = new Label(); // lbl_nazwa.HorizontalOptions = LayoutOptions.Center; // lbl_nazwa.Text = "Nazwa : " + mmka.Twr_Nazwa; // lbl_cena = new Label(); // lbl_cena.HorizontalOptions = LayoutOptions.Center; // lbl_cena.Text = "Cena : " + mmka.Cena + " Zł"; // Button open_url = new Button(); // open_url.Text = "Otwórz zdjęcie"; // open_url.CornerRadius = 15; // open_url.Clicked += Open_url_Clicked; // //open_url.BackgroundColor = Color.FromHex("#3CB371"); // //open_url.VerticalOptions = LayoutOptions.EndAndExpand; // //open_url.Margin = new Thickness(15, 0, 15, 5); // stackLayout.Children.Add(lbl_twrkod); // stackLayout.Children.Add(lbl_nazwa); // //stackLayout.Children.Add(lbl_ean); // stackLayout.Children.Add(entry_kodean); // //stackLayout.Children.Add(lbl_symbol); // stackLayout.Children.Add(lbl_cena); // stackLayout.VerticalOptions = LayoutOptions.Center; // stackLayout.Padding = new Thickness(15, 0, 15, 0); // stackLayout.Spacing = 8; // stackLayout_gl.Children.Add(stackLayout); // //stackLayout_gl.Children.Add(open_url); // Content = stackLayout_gl; // // GetDataFromTwrKod(mmka.twrkod); // //entry_ilosc.Focus(); //} public RaportLista_AddTwrKod(DaneMMElem akcje) //edycja { this.Title = "Dodaj MM"; NavigationPage.SetHasNavigationBar(this, false); StackLayout stackLayout = new StackLayout(); StackLayout stackLayout_gl = new StackLayout(); StackLayout stack_naglowek = new StackLayout(); Label lbl_naglowek = new Label(); lbl_naglowek.HorizontalOptions = LayoutOptions.CenterAndExpand; lbl_naglowek.VerticalOptions = LayoutOptions.Start; lbl_naglowek.Text = "Szczegóły pozycji"; lbl_naglowek.FontSize = 20; lbl_naglowek.TextColor = Color.Bisque; lbl_naglowek.BackgroundColor = Color.DarkCyan; stack_naglowek.HorizontalOptions = LayoutOptions.FillAndExpand; stack_naglowek.VerticalOptions = LayoutOptions.Start; stack_naglowek.BackgroundColor = Color.DarkCyan; stack_naglowek.Children.Add(lbl_naglowek); stackLayout_gl.Children.Add(stack_naglowek); img_foto = new Image(); img_foto.Source = akcje.Url.Replace("Miniatury/", ""); var tapGestureRecognizer = new TapGestureRecognizer(); tapGestureRecognizer.Tapped += (s, e) => { Launcher.OpenAsync(akcje.Url.Replace("Miniatury/", "")); }; img_foto.GestureRecognizers.Add(tapGestureRecognizer); stackLayout.Children.Add(img_foto); //_gidnumer = mmka.gi; lbl_stan = new Label(); lbl_stan.HorizontalOptions = LayoutOptions.Center; lbl_stan.Text = "Stan : " + akcje.Ilosc + " szt"; lbl_stan.FontAttributes = FontAttributes.Bold; stackLayout.Children.Add(lbl_stan); lbl_twrkod = new Label(); lbl_twrkod.HorizontalOptions = LayoutOptions.Center; lbl_twrkod.Text = "Kod towaru : " + akcje.Twr_Kod; lbl_ean = new Label(); lbl_ean.HorizontalOptions = LayoutOptions.Center; lbl_ean.Text = akcje.Ean; entry_kodean = new Entry() { HorizontalOptions = LayoutOptions.Center, Keyboard = Keyboard.Numeric, Text = akcje.Ilosc_Skan == 0 ? "" : akcje.Ilosc_Skan.ToString(), WidthRequest = 60, IsEnabled = false }; //lbl_symbol = new Label(); //lbl_symbol.HorizontalOptions = LayoutOptions.Center; //lbl_symbol.Text = "Symbol : " + akcje.TwrSymbol; lbl_nazwa = new Label(); lbl_nazwa.HorizontalOptions = LayoutOptions.Center; lbl_nazwa.Text = "Nazwa : " + akcje.Twr_Nazwa; lbl_cena = new Label(); lbl_cena.HorizontalOptions = LayoutOptions.Center; lbl_cena.Text = "Cena : " + akcje.Cena + " Zł"; Button open_url = new Button(); open_url.Text = "Zacznij skanowanie"; open_url.CornerRadius = 15; //open_url.Clicked += Open_url_Clicked; overlay = new ZXingDefaultOverlay { TopText = $"Skanowany : {akcje.Twr_Kod}", BottomText = $"Zeskanowanych szt : {ile}", AutomationId = "zxingDefaultOverlay", }; var torch = new Switch { }; torch.Toggled += delegate { scanPage.ToggleTorch(); }; overlay.Children.Add(torch); open_url.Clicked += async delegate { scanPage = new ZXingScannerPage( new ZXing.Mobile.MobileBarcodeScanningOptions { DelayBetweenContinuousScans = 3000 }, overlay); scanPage.DefaultOverlayShowFlashButton = true; scanPage.OnScanResult += (result) => Device.BeginInvokeOnMainThread(() => { skanean = result.Text; if (skanean == lbl_ean.Text) { ile += 1; overlay.BottomText = $"Zeskanowanych szt : {ile}"; DisplayAlert(null, $"Zeskanowanych szt : {ile}", "OK"); entry_kodean.Text = ile.ToString(); } else { DisplayAlert(null, "Probujesz zeskanować inny model..", "OK"); } }); await Navigation.PushModalAsync(scanPage); }; //open_url.BackgroundColor = Color.FromHex("#3CB371"); open_url.VerticalOptions = LayoutOptions.EndAndExpand; //open_url.Margin = new Thickness(15, 0, 15, 5); stackLayout.Children.Add(lbl_twrkod); stackLayout.Children.Add(lbl_nazwa); stackLayout.Children.Add(lbl_ean); stackLayout.Children.Add(entry_kodean); stackLayout.Children.Add(lbl_symbol); stackLayout.Children.Add(lbl_cena); stackLayout.VerticalOptions = LayoutOptions.Center; stackLayout.Padding = new Thickness(15, 0, 15, 0); stackLayout.Spacing = 8; stackLayout_gl.Children.Add(stackLayout); stackLayout_gl.Children.Add(open_url); Content = stackLayout_gl; // GetDataFromTwrKod(mmka.twrkod); //entry_ilosc.Focus(); }