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();
}
