protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//登录判断
Base_Users userExt = new Base_Users();
userExt = FacadeManage.aidePlatformManagerFacade.GetUserInfoFromCache();
if (userExt == null || userExt.UserID <= 0 || (userExt.UserID != ApplicationConfig.SUPER_ADMINISTRATOR_ID && userExt.RoleID <= 0))
{
Response.Redirect("/Login.aspx?errtype=overtime");
return;
}
userExt = FacadeManage.aidePlatformManagerFacade.GetUserByUserID(userExt.UserID);
userName = userExt.Username;
preLogonDate = userExt.PreLogintime.ToString();
preLogonip = userExt.LastLoginIP;
preLogonTimes = userExt.LoginTimes;
preLogonAddress = IPQuery.GetAddressWithIP(preLogonip);
if (userExt.UserID == ApplicationConfig.SUPER_ADMINISTRATOR_ID || userExt.RoleID == 1)
{
roleName = "超级管理员";
}
else
{
roleName = FacadeManage.aidePlatformManagerFacade.GetRolenameByRoleID(userExt.RoleID);
}
}
}
public KOTsendPage()
{
InitializeComponent();
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
//this.BackgroundImage = "background.png";
this.Title = "COMPLETE ORDER";
}
private void BindData()
{
if (IntParam <= 0)
{
return;
}
//获取信息
AccountsInfo model = FacadeManage.aideAccountsFacade.GetAccountInfoByUserID(IntParam);
if (model == null)
{
MessageBox("用户信息不存在");
return;
}
CtrlHelper.SetText(ltGameID, model.GameID.ToString());
CtrlHelper.SetText(ltAccounts, model.Accounts.Trim());
CtrlHelper.SetText(ltUserModel, model.UserMedal.ToString("N0"));
CtrlHelper.SetText(ltLove, model.LoveLiness.ToString("N0"));
UserCurrencyInfo uci = FacadeManage.aideTreasureFacade.GetUserCurrencyInfo(IntParam);
if (uci != null)
{
ltCurrency.Text = uci.Currency.ToString("N0");
}
//游戏币信息
GameScoreInfo scoreInfo = FacadeManage.aideTreasureFacade.GetGameScoreInfoByUserID(IntParam);
if (scoreInfo == null)
{
return;
}
CtrlHelper.SetText(ltScore, scoreInfo.Score.ToString("N0"));
CtrlHelper.SetText(ltInsureScore, scoreInfo.InsureScore.ToString("N0"));
CtrlHelper.SetText(ltWinCount, scoreInfo.WinCount.ToString());
CtrlHelper.SetText(ltLostCount, scoreInfo.LostCount.ToString());
CtrlHelper.SetText(ltDrawCount, scoreInfo.DrawCount.ToString());
CtrlHelper.SetText(ltFleeCount, scoreInfo.FleeCount.ToString());
CtrlHelper.SetText(ltRevenue, scoreInfo.Revenue.ToString("N0"));
//登录房间、注册信息
CtrlHelper.SetText(ltGameLogonTimes, scoreInfo.AllLogonTimes.ToString());
CtrlHelper.SetText(ltLastLogonDate, scoreInfo.AllLogonTimes == 0 ? "从未登陆房间" : scoreInfo.LastLogonDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(ltLogonSpacingTime, scoreInfo.AllLogonTimes == 0 ? "" : Fetch.GetTimeSpan(Convert.ToDateTime(scoreInfo.LastLogonDate), DateTime.Now) + " 前");
CtrlHelper.SetText(ltLastLogonIP, scoreInfo.LastLogonIP.ToString());
CtrlHelper.SetText(ltLogonIPInfo, IPQuery.GetAddressWithIP(scoreInfo.LastLogonIP.ToString()));
CtrlHelper.SetText(ltLastLogonMachine, scoreInfo.LastLogonMachine.ToString());
CtrlHelper.SetText(ltRegisterDate, scoreInfo.RegisterDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(ltRegisterIP, scoreInfo.RegisterIP.ToString());
CtrlHelper.SetText(ltRegIPInfo, IPQuery.GetAddressWithIP(scoreInfo.RegisterIP.ToString()));
CtrlHelper.SetText(ltRegisterMachine, scoreInfo.RegisterMachine.ToString());
CtrlHelper.SetText(ltOnLineTimeCount, scoreInfo.OnLineTimeCount.ToString());
CtrlHelper.SetText(ltPlayTimeCount, scoreInfo.PlayTimeCount.ToString());
}
private void BindData()
{
if (IntParam <= 0)
{
return;
}
//获取信息
AccountsInfo model = FacadeManage.aideAccountsFacade.GetAccountInfoByUserID(IntParam);
if (model == null)
{
MessageBox("用户信息不存在");
return;
}
CtrlHelper.SetText(ltGameID, model.GameID.ToString());
CtrlHelper.SetText(ltAccounts, model.Accounts.Trim());
int kindID = int.Parse(ddlGame.SelectedValue);
if (kindID <= 0)
{
return;
}
//积分信息
//GameScoreFacade aideGameScoreFacade = new GameScoreFacade( aidePlatformFacade.GetConn( kindID ) );
//Game.Entity.GameScore.GameScoreInfo scoreInfo = aideGameScoreFacade.GetGameScoreInfoByUserId( IntParam );
GameScoreInfo scoreInfo = new TreasureFacade(kindID).GetGameScoreInfoByUserID(IntParam);
if (scoreInfo == null)
{
return;
}
CtrlHelper.SetText(ltScore, scoreInfo.Score.ToString("N0"));
CtrlHelper.SetText(ltWinCount, scoreInfo.WinCount.ToString());
CtrlHelper.SetText(ltLostCount, scoreInfo.LostCount.ToString());
CtrlHelper.SetText(ltDrawCount, scoreInfo.DrawCount.ToString());
CtrlHelper.SetText(ltFleeCount, scoreInfo.FleeCount.ToString());
//登录房间、注册信息
CtrlHelper.SetText(ltGameLogonTimes, scoreInfo.AllLogonTimes.ToString() + "次");
CtrlHelper.SetText(ltLastLogonDate, scoreInfo.LastLogonDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(ltLogonSpacingTime, Fetch.GetTimeSpan(Convert.ToDateTime(scoreInfo.LastLogonDate), DateTime.Now) + "前");
CtrlHelper.SetText(ltLastLogonIP, scoreInfo.LastLogonIP.ToString());
CtrlHelper.SetText(ltLogonIPInfo, IPQuery.GetAddressWithIP(scoreInfo.LastLogonIP.ToString()));
CtrlHelper.SetText(ltLastLogonMachine, scoreInfo.LastLogonMachine.ToString());
CtrlHelper.SetText(ltRegisterDate, scoreInfo.RegisterDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(ltRegisterIP, scoreInfo.RegisterIP.ToString());
CtrlHelper.SetText(ltRegIPInfo, IPQuery.GetAddressWithIP(scoreInfo.RegisterIP.ToString()));
CtrlHelper.SetText(ltRegisterMachine, scoreInfo.RegisterMachine.ToString());
CtrlHelper.SetText(ltOnLineTimeCount, scoreInfo.OnLineTimeCount.ToString());
CtrlHelper.SetText(ltPlayTimeCount, scoreInfo.PlayTimeCount.ToString());
}
public SelectMode()
{
InitializeComponent();
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
//this.BackgroundImage = "background.png";
this.Title = "SELECT MODE";
// resul = numb;
if (CrossConnectivity.Current.IsConnected)
{
try
{
// GetJSON();
// BindingContext = new JsonStuwardModel();
// var device = Hardware.Default.DeviceId;
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
public static string GetAddressWithIP(string IP)
{
string text = "";
try
{
return(IPQuery.GetAddressWithIP(IP));
}
catch (Exception)
{
return("");
}
}
public FoodTabPage(string categoryName, IList <ResturentItems> foodList)
{
InitializeComponent();
// ImageService.Instance.Initialize();
//this.BackgroundImage = "background.png";
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//TicketQuery y = new TicketQuery();
//SQLiteConnection d;
//d = DependencyService.Get<ISQLite>().GetConnection();
//d.Table<TicketNumber>();
//var tikcount = d.ExecuteScalar<string>("SELECT max(TicketNum) FROM TicketNumber");
//DisplayAlert("tiket numb", tikcount, "OK");
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
// createEventsList();
Title = categoryName;
mealsListView.ItemsSource = foodList;
NavigationPage.SetHasBackButton(this, false);
//_foodList= ListViewCachingStrategy.RetainElement;
_foodList = foodList;
// mealsListView.ItemsSource = UpdateDetails;
}
public static string GetAddressWithIP(string IP)
{
string result = "";
try
{
result = IPQuery.GetAddressWithIP(IP);
}
catch (System.Exception)
{
result = "";
}
return(result);
}
private void KQDetailDataBind()
{
if (id <= 0)
{
return;
}
//获取站点信息
ReturnKQDetailInfo kQDetailInfo = FacadeManage.aideTreasureFacade.GetKQDetailInfo(id);
if (kQDetailInfo == null)
{
ShowError("信息不存在");
return;
}
CtrlHelper.SetText(litOrderID, "<a class='l' href='javascript:void(0)' onclick=\"javascript:openWindowOwn('OnLineOrderInfo.aspx?OrderID=" + kQDetailInfo.OrderID + "','online_" + kQDetailInfo.OrderID + "',600,465)\">" + kQDetailInfo.OrderID + "</a>");
CtrlHelper.SetText(litOrderTime, kQDetailInfo.OrderTime.ToString("yyyy-MM-dd HH:ss:mm"));
CtrlHelper.SetText(litOrderAmount, kQDetailInfo.OrderAmount.ToString("N"));
CtrlHelper.SetText(litPayAmount, kQDetailInfo.PayAmount.ToString("N"));
CtrlHelper.SetText(litFee, kQDetailInfo.Fee.ToString("f3"));
CtrlHelper.SetText(litRevenue, (kQDetailInfo.PayAmount - kQDetailInfo.Fee).ToString("f3"));
if (kQDetailInfo.PayResult == "10")
{
CtrlHelper.SetText(litPayResult, "<span class='lan'>成功</span>");
}
else
{
CtrlHelper.SetText(litPayResult, "<span class='hong'>失败</span>");
}
CtrlHelper.SetText(litDealID, kQDetailInfo.DealID);
CtrlHelper.SetText(litDealTime, kQDetailInfo.DealTime.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(litBankDealID, kQDetailInfo.BankDealID);
CtrlHelper.SetText(litPayType, billPayType.GetBillPayType(kQDetailInfo.PayType.Trim()));
CtrlHelper.SetText(litBankID, billBanks.GetBillBanksByCode(kQDetailInfo.BankID.Trim()));
CtrlHelper.SetText(litErrCode, kQDetailInfo.ErrCode);
CtrlHelper.SetText(litVersion, kQDetailInfo.Version);
CtrlHelper.SetText(litLanguage, "中文");
CtrlHelper.SetText(litExt1, kQDetailInfo.Ext1 + " " + IPQuery.GetAddressWithIP(kQDetailInfo.Ext1));
CtrlHelper.SetText(litExt2, kQDetailInfo.Ext2);
CtrlHelper.SetText(litSignType, "与提交订单时的签名类型保持一致");
CtrlHelper.SetText(litSignMsg, kQDetailInfo.SignMsg);
}
private void GameUserDataBind()
{
//验证数据
if (id <= 0)
{
return;
}
//获取用户信息
Base_Users user = aidePlatformManagerFacade.GetUserByUserID(id);
if (user == null)
{
MessageBox("用户信息不存在");
return;
}
CtrlHelper.SetText(lblAccounts, user.Username);
CtrlHelper.SetText(lblRoleID, GetRoleName(user.RoleID));
CtrlHelper.SetText(hdfOldLogonPass, user.Password);
CtrlHelper.SetText(lblLoginTimes, user.LoginTimes.ToString());
CtrlHelper.SetText(lblLastLogonIP, IPQuery.GetAddressWithIP(user.LastLoginIP));
CtrlHelper.SetText(lblLastLogonDate, user.LastLogintime.ToString());
}
private void OnLineOrderDataBind()
{
if (orderID == "")
{
return;
}
//获取站点信息
OnLineOrder onLineOrderInfo = aideTreasureFacade.GetOnLineOrderInfo(orderID);
if (onLineOrderInfo == null)
{
ShowError("信息不存在");
return;
}
CtrlHelper.SetText(litOrderID, onLineOrderInfo.OrderID.Trim());
CtrlHelper.SetText(litApplyDate, onLineOrderInfo.ApplyDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(litAccounts, onLineOrderInfo.Accounts.Trim());
CtrlHelper.SetText(litOrderAmount, onLineOrderInfo.OrderAmount.ToString("N"));
CtrlHelper.SetText(litPayAmount, onLineOrderInfo.PayAmount.ToString("N"));
CtrlHelper.SetText(litPresentScore, onLineOrderInfo.CardGold.ToString());
if (onLineOrderInfo.OrderStatus == 0)
{
CtrlHelper.SetText(litOrderStatus, "<span class='hong'>未付款</span>");
}
else if (onLineOrderInfo.OrderStatus == 1)
{
CtrlHelper.SetText(litOrderStatus, "<span class='lan'>已付款待处理</span>");
}
else
{
CtrlHelper.SetText(litOrderStatus, "<span class='lan'>成功</span>");
}
CtrlHelper.SetText(litIPAddress, onLineOrderInfo.IPAddress.Trim() + " " + IPQuery.GetAddressWithIP(onLineOrderInfo.IPAddress.Trim()));
CtrlHelper.SetText(litOperUserID, onLineOrderInfo.OperUserID.ToString());
}
public JsonDetailsPage(long id, ResturentItems item, String name, string code, String description, decimal price, bool isservicecharge, bool isaddonapplicable, decimal costprice)
{
//var yourImageSource = new ResturentItemToImageSourceConverter().Convert(item, typeof(ImageSource), null, System.Globalization.CultureInfo.CurrentCulture);
//ProductImage.Source = yourImageSource as ImageSource;
//BindingContext = this;
//Item = item;
InitializeComponent();
var yourImageSource = new ResturentItemToImageSourceConverter().Convert(item, typeof(ImageSource), null, System.Globalization.CultureInfo.CurrentCulture);
ProductImage.Source = yourImageSource as ImageSource;
// this.BackgroundImage = "background.png";
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
this.Title = "Product Details"; // CachedImageRenderer.Init();
thiTable = JsonTable.tablenew;
// picker.TextColor = Color.White;
// GridDetails.BindingContext = SelectedContact;
ItemID.Text = Convert.ToString(id);
itId = id;
//Image.Source = ImageSource.FromStream(() => new MemoryStream(image));
// ImageSource.FromStream(() => new MemoryStream());
// this.Item = item;
Name.Text = name;
codedetails.Text = code;
Description.Text = description;
Price.Text = Convert.ToString(price);
isservicechargeinfo.Text = Convert.ToString(isservicecharge);
isaddonapplicableinfo.Text = Convert.ToString(isaddonapplicable);
CostPriceDetail.Text = Convert.ToString(costprice);
// ResturentItems = Convert.ToString(Item);
// Image.Text = image;
// CustomCachedImage.Source= ImageSource.FromStream(() => new MemoryStream(image));
// CustomStreamImageSource.FromResource = ImageSource.FromStream(() => new MemoryStream(image));
// DisplayAlert("Addon Not applicable", "Not Available", "OK");
// Image.Source =ImageService.Instance.LoadCompiledResource(nameOfResource).Into(_imageView);
// pimage = image;
pprice = price;
//addonitemdetail = isaddonapplicable;
//long freeMemory = Java.Lang.Runtime.GetRuntime().FreeMemory();
//DisplayAlert("freemomory", Convert.ToString(freeMemory), "OK");
//DisplayAlert("end 1","end 1","ok");
//Widget widget = new Widget()
//widget.Name = "test"
//widget.Price = 1;
//HttpClient client = new HttpClient();
//client.BaseAddress = new Uri("http://localhost:44268/api/test");
//client.SendAsync(new HttpRequestMessage<Widget>(widget)).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode());
var images = new List <String>
{
"https://www.gourmetguide.co.uk/shop/wp-content/uploads/2016/06/Resturant-Food-400x200.jpg",
"http://beranisehat.com/wp-content/uploads/2015/06/Healthy-Breakfast-Food-Ideas-400x200.jpg",
"http://empireoftheincasrestaurant.com/wp-content/uploads/2016/05/Papa-a-la-huaicaina-3-400x200.jpg"
};
//var names = new List<String>
//{
// "Sam","Pan","Jam"
//};
MainCarouselView.ItemsSource = images;
if (isaddonapplicable == true)
{
DisplayAlert("Addon applicable", Convert.ToString(isaddonapplicable), "OK");
}
else
{
DisplayAlert("Addon Not applicable", "Not Available", "OK");
}
// titlesimi.Text = "this is text";
// GetSimilerJSON();
// GC.Collect(1);
//mGridGallery.ItemClick -= OnItemClicked;
//mGridGallery.ItemClick += OnItemClicked;
// testJason();
Device.StartTimer(TimeSpan.FromSeconds(3), (Func <bool>)(() =>
{
MainCarouselView.Position = (MainCarouselView.Position + 1) % images.Count;
return(true);
}));
}
public void Addr_btn_Clicked(object sender, EventArgs e)
{
if (CrossConnectivity.Current.IsConnected)
{
try
{
Navigation.PopModalAsync(true);
//FoodTabPage.imagedeta = null;
//GC.Collect();
//TableQuery p = new TableQuery();
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//s.Table<TempTbl>();
//var count = s.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl");
TicketQuery y = new TicketQuery();
SQLiteConnection d;
d = DependencyService.Get <ISQLite>().GetConnection();
d.Table <TicketNumber>();
var tikcount = d.ExecuteScalar <string>("SELECT max(TicketNum) FROM TicketNumber");
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1");
// DisplayAlert("tick", tikcount, "ok");
// ticketnow.Text = tikcount;
IPQuery IPR = new IPQuery();
SQLiteConnection IPK;
IPK = DependencyService.Get <ISQLite>().GetConnection();
IPK.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var TerminalNo = IPK.ExecuteScalar <string>("SELECT Terminal FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
var OrderCounterNu = IPK.ExecuteScalar <string>("SELECT Counter FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
// long itmID = Convert.tolo ItemID.Text;
decimal qty = Convert.ToDecimal(Qty.Text);
decimal total = Convert.ToDecimal(Price.Text);
decimal Total = (qty * total);
int BatchNo = Convert.ToInt16(Batch.Text);
long LocationDetail = OnlineLoginPage.LocationDetail;
//Total =+Total;
// tablenow.Text = count;
if (StuwardSelect.StuwardNme == null)
{
UsorSt = "GUEST";
StuwardSelect.StuwardIDn = 19834000000000;
}
else
{
UsorSt = StuwardSelect.StuwardNme;
StuwardSelect.StuwardIDn = StuwardSelect.StuwardIDn;
}
//if (StuwardSelect.StuwardIDn == null)
//{
// UsortStNum = 10834000000000;
//}
//else
//{
// UsorSt = StuwardSelect.StuwardNme;
//}
//var client = RestService.HttpClient;
var client = new HttpClient();
var postData = new List <KeyValuePair <string, string> >();
string name = OnlineLoginPage.UserName;
long UserIDn = OnlineLoginPage.UserID;
// string uid = OnlineLoginPage.us
int fromApp = 1;
int NoRadyKOT = 0;
var deviceID = TestProject.Data.Hardware.Default.DeviceId;
// var device = Resolver.Resolve<IDevice>();
// var table = s.Table<CartRecord>();
// foreach (var item in table)
if (BatchNo < 1)
{
DisplayAlert("Wrong entry", "Invalid", "OK");
}
else
{
postData.Add(new KeyValuePair <string, string>("Language", Convert.ToString(1))); //Language
postData.Add(new KeyValuePair <string, string>("Company", Convert.ToString(1))); //Company
postData.Add(new KeyValuePair <string, string>("Branch", Convert.ToString(1))); //Branch
postData.Add(new KeyValuePair <string, string>("Location", Convert.ToString(LocationDetail))); //Location
postData.Add(new KeyValuePair <string, string>("ItemID", Convert.ToString(itId))); //ItemID
postData.Add(new KeyValuePair <string, string>("ItemCode", codedetails.Text)); //ItemCode
postData.Add(new KeyValuePair <string, string>("Name", Name.Text));
postData.Add(new KeyValuePair <string, string>("CostPrice", CostPriceDetail.Text)); //CostPrice
postData.Add(new KeyValuePair <string, string>("Price", Price.Text));
postData.Add(new KeyValuePair <string, string>("Quantity", Qty.Text));
postData.Add(new KeyValuePair <string, string>("Transaction", Convert.ToString(1))); //Transaction ????
postData.Add(new KeyValuePair <string, string>("Reciptno", Convert.ToString(1))); //Reciptno ??????
postData.Add(new KeyValuePair <string, string>("UserID", Convert.ToString(UserIDn))); //UserID
postData.Add(new KeyValuePair <string, string>("UserName", name)); //UserName
postData.Add(new KeyValuePair <string, string>("Unit", Convert.ToString(0))); //Unit////////////////////was 1 ?????
postData.Add(new KeyValuePair <string, string>("Terminal", Convert.ToString(TerminalNo))); //Terminal
postData.Add(new KeyValuePair <string, string>("IsServiceChargeOnItem", isservicechargeinfo.Text)); ///////
postData.Add(new KeyValuePair <string, string>("TransID", Convert.ToString(1))); //TransctionTYP/////////chamge from 1 ?????
postData.Add(new KeyValuePair <string, string>("SaleTypeId", Convert.ToString(1))); // ????????????????????????????
postData.Add(new KeyValuePair <string, string>("UnitOfMeasureId", Convert.ToString(0))); //// not ????????????????????????????
postData.Add(new KeyValuePair <string, string>("BatchNumber", Convert.ToString(BatchNo))); //BatchNumber
postData.Add(new KeyValuePair <string, string>("ExpiryDate", Convert.ToString(null)));
postData.Add(new KeyValuePair <string, string>("TaxOne", Convert.ToString(0))); //TaxOne ??????????????????
postData.Add(new KeyValuePair <string, string>("TaxTwo", Convert.ToString(0))); //TaxTwo ??????????????????
postData.Add(new KeyValuePair <string, string>("TaxThree", Convert.ToString(0))); //TaxThree ?????????????????
postData.Add(new KeyValuePair <string, string>("TaxFour", Convert.ToString(0))); //TaxFour ?????????????????
postData.Add(new KeyValuePair <string, string>("TaxFive", Convert.ToString(0))); //TaxFive ????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentOne", Convert.ToString(0.00))); //TaxpersentOne ????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentTwo", Convert.ToString(0.00))); //TaxpersentTwo ?????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentThree", Convert.ToString(0.00))); //TaxpersentThree ?????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentFour", Convert.ToString(0))); //TaxpersentFour ????????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentFive", Convert.ToString(0))); //TaxpersentFive ???????????????????
postData.Add(new KeyValuePair <string, string>("CustomerID", Convert.ToString(1))); //CustomerID bigint//// ???????????
postData.Add(new KeyValuePair <string, string>("Customer", "Sam")); //CustomerName varchar/////////////// ????????????????
postData.Add(new KeyValuePair <string, string>("CustomerType", Convert.ToString(0))); //CustomerTyp int/////////// ??????????????
postData.Add(new KeyValuePair <string, string>("LoyaltyType", Convert.ToString(0))); //LoyaltyType int/////////////**************???????????
postData.Add(new KeyValuePair <string, string>("IsPromotion", Convert.ToString(0))); //Ispromotion bit/////// ???????????????????
postData.Add(new KeyValuePair <string, string>("FixedDiscount", Convert.ToString(0.00))); /// not ????????????????
postData.Add(new KeyValuePair <string, string>("FixedDiscountPercentage", Convert.ToString(0.00))); //// not ?????????????????
postData.Add(new KeyValuePair <string, string>("PromotionID", Convert.ToString(0))); //IspromotionID bigint////////----was 1 ?????????????
postData.Add(new KeyValuePair <string, string>("OrderCounter", Convert.ToString(3))); //OrderCounter///////////////////changes req/////////////////////////default need to be 1////????????????
postData.Add(new KeyValuePair <string, string>("Ticket", Convert.ToString(thiTable)));
postData.Add(new KeyValuePair <string, string>("KotBotCounterId", Convert.ToString(0))); ///??????????????????
postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount.Replace("\r\n", "")));
postData.Add(new KeyValuePair <string, string>("OrderNum", Convert.ToString(3))); //OrderNum ///???????????????
postData.Add(new KeyValuePair <string, string>("IsNew", Convert.ToString(1))); ///////????????????????????
postData.Add(new KeyValuePair <string, string>("StuwardID", Convert.ToString(StuwardSelect.StuwardIDn))); //StuwardID
postData.Add(new KeyValuePair <string, string>("StuwardName", UsorSt)); // StuwardSelect.StuwardNme));//StuwardName
postData.Add(new KeyValuePair <string, string>("CurrentRowNo", Convert.ToString(0))); // not ????????????????????????????
postData.Add(new KeyValuePair <string, string>("IsAddonApplicable", Convert.ToString(0))); ////IsAddOnApplicable ?????????????????????????????????
postData.Add(new KeyValuePair <string, string>("IsAddonItem", Convert.ToString(0))); //////???????????????????????????????
postData.Add(new KeyValuePair <string, string>("IsRetailItem", Convert.ToString(0))); ///////////////?????????????????????
postData.Add(new KeyValuePair <string, string>("BasedAddOnItemId", Convert.ToString(0))); //////????????????????????????
postData.Add(new KeyValuePair <string, string>("IsStaffDiscount", Convert.ToString(0))); ///IsStaffDiscount /////////????????????????
postData.Add(new KeyValuePair <string, string>("IsGuideCommission", Convert.ToString(0))); ///IsStaffDiscount ///////////////?????????????????????
postData.Add(new KeyValuePair <string, string>("IsTakeAway", Convert.ToString(0))); ///IsStaffDiscount /////////////????????
postData.Add(new KeyValuePair <string, string>("PPno", "")); //PPnumber varchar(30)////////??????????????????????
postData.Add(new KeyValuePair <string, string>("BPno", "")); //BPnumber varchar(30)///////////???????????????????????
postData.Add(new KeyValuePair <string, string>("FLNo", "")); //BPnumber varchar(30)///////////FLNo???????????????????????
postData.Add(new KeyValuePair <string, string>("IsReadyToKot", Convert.ToString(NoRadyKOT)));
postData.Add(new KeyValuePair <string, string>("IsFromApp", Convert.ToString(fromApp))); //fromApp
var content = new FormUrlEncodedContent(postData);
// var response = client.PostAsync("http://192.168.43.226/cartorderInsertNew.php", content);// correct one 1
// var response = client.PostAsync("http://192.168.43.226/CartOrderInsert.php", content);
// var response = client.PostAsync("http://192.168.43.226/InsertSPNewCart.php", content); // test for SP in php
// var response = client.PostAsync("http://192.168.43.226/cartorderInsertNewSP.php", content); // correct two sp test//////////////////
var response = client.PostAsync(RestService.ipupdate + "cartorderInsertNewSP.php", content); // correct two sp test//////////////////
// http://192.168.43.226/cartorderInsertNewSP.php
Navigation.PushAsync(new OnlineCart(Total));
}
// Image.Source = null;
// Xamarin.Forms.Application.Current.MainPage.Navigation.RemovePage(FoodTabbedPage);
// Navigation.PopAsync().ConfigureAwait(false);
//var MyAppsFirstPage = new contentpage();
//Application.Current.MainPage = new NavigationPage(MyAppsFirstPage);
//Application.Current.MainPage.Navigation.PushAsync(FoodTabbedPage);
//Navigation.PopAsync();
// Navigation.RemovePage(FoodTabbedPage);
///////----- end of modification --------------------------
////Device.BeginInvokeOnMainThread(async () => await Navigation.PopModalAsync());
//if (BatchNo < 1)
//{
// DisplayAlert("Wrong entry", "Invalid", "OK");
//}
//else
//{
// Navigation.PushAsync(new OnlineCart(Total));
//}
GC.Collect(1);
// await _navigation.PushAsync(new Page2(argument_goes_here));
//for (int PageIndex = Navigation.NavigationStack.Count; PageIndex >= 2; PageIndex--)
//{
// Navigation.RemovePage(Navigation.NavigationStack[PageIndex]);
//}
//string name = OnlineLoginPage.UserName;
// FoodTabPage.imagedeta= null;
// clearImag.
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
private void BindData( )
{
if (IntParam <= 0)
{
return;
}
//获取信息
AccountsInfo model = aideAccountsFacade.GetAccountInfoByUserID(IntParam);
if (model == null)
{
MessageBox("用户信息不存在");
return;
}
//CtrlHelper.SetText( ltUserID, model.UserID.ToString( ) );
CtrlHelper.SetText(ltGameID, model.GameID.ToString( ));
CtrlHelper.SetText(ltRegAccounts, model.RegAccounts.Trim( ));
CtrlHelper.SetText(txtAccount, model.Accounts.Trim( ));
CtrlHelper.SetText(txtNickName, model.NickName.Trim( ));
CtrlHelper.SetText(litCompellation, model.Compellation);
//CtrlHelper.SetText(litUserMedal, model.UserMedal.ToString());
CtrlHelper.SetText(txtUnderWrite, model.UnderWrite.Trim( ));
CtrlHelper.SetCheckBoxValue(ckbNullity, model.Nullity);
CtrlHelper.SetCheckBoxValue(ckbStunDown, model.StunDown);
CtrlHelper.SetText(txtExperience, model.Experience.ToString( ).Trim( ));
CtrlHelper.SetText(txtPresent, model.Present.ToString( ).Trim( ));
CtrlHelper.SetText(txtLoveLiness, model.LoveLiness.ToString( ).Trim( ));
CtrlHelper.SetText(ltProtectID, model.ProtectID > 0 ? "<span style=\"font-weight: bold;\">已申请</span> <a href=\"javascript:openWindow('AccountsProtectInfo.aspx?param=" + model.ProtectID + "',580,320)\" class=\"l1\">点击查看</a>" : "未申请");
CtrlHelper.SetText(ltMemberInfo, GetMemberName(model.MemberOrder) + (model.MemberOrder == 0 ? "" : " 到期时间：" + model.MemberSwitchDate.ToString("yyyy-MM-dd mm:HH:ss")));
if (model.MemberOrder != 0)
{
plMemberList.Visible = true;
}
strFaceID = model.FaceID.ToString( );
ddlGender.SelectedValue = model.Gender.ToString( );
rdoMoorMachine.SelectedValue = model.MoorMachine.ToString( );
//用户权限
int intUserRight = model.UserRight;
if (ckbUserRight.Items.Count > 0)
{
foreach (ListItem item in ckbUserRight.Items)
{
item.Selected = int.Parse(item.Value) == (intUserRight & int.Parse(item.Value));
}
}
//玩家身份
ddlMasterOrder.SelectedValue = model.MasterOrder.ToString( ).Trim( );
//用户管理权限
int intMasterRight = model.MasterRight;
if (ckbMasterRight.Items.Count > 0)
{
foreach (ListItem item in ckbMasterRight.Items)
{
item.Selected = int.Parse(item.Value) == (intMasterRight & int.Parse(item.Value));
}
}
//机器人
CtrlHelper.SetCheckBoxValue(chkIsAndroid, model.IsAndroid);
//登录、注册信息
CtrlHelper.SetText(ltWebLogonTimes, model.WebLogonTimes.ToString( ));
CtrlHelper.SetText(ltGameLogonTimes, model.GameLogonTimes.ToString( ));
CtrlHelper.SetText(ltLastLogonDate, model.LastLogonDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(ltLogonSpacingTime, Fetch.GetTimeSpan(Convert.ToDateTime(model.LastLogonDate), DateTime.Now));
CtrlHelper.SetText(ltLastLogonIP, model.LastLogonIP.ToString( ));
CtrlHelper.SetText(ltLogonIPInfo, IPQuery.GetAddressWithIP(model.LastLogonIP.ToString( )));
CtrlHelper.SetText(ltLastLogonMachine, model.LastLogonMachine.ToString( ));
CtrlHelper.SetText(ltRegisterDate, model.RegisterDate.ToString("yyyy-MM-dd HH:mm:ss"));
CtrlHelper.SetText(ltRegisterIP, model.RegisterIP.ToString( ));
CtrlHelper.SetText(ltRegIPInfo, IPQuery.GetAddressWithIP(model.RegisterIP.ToString( )));
CtrlHelper.SetText(ltRegisterMachine, model.RegisterMachine.ToString( ));
CtrlHelper.SetText(ltOnLineTimeCount, Fetch.ConverTimeToDHMS(model.OnLineTimeCount));
CtrlHelper.SetText(ltPlayTimeCount, Fetch.ConverTimeToDHMS(model.PlayTimeCount));
//密保卡信息
//PasswordCard pc = new PasswordCard( );
if (model.PasswordID != 0)
{
LiteralPasswordCard.Text = "<span style=\"font-weight: bold;\">已绑定</span>";
spanPasswordCard.Visible = true;
}
}
public MainVedioPage(int flgtab)
{
InitializeComponent();
NavigationPage.SetHasBackButton(this, false);
tabresult = flgtab;
//SlidePosition = 0;
//SlidePositionTemp = 0;
//this.BackgroundColor = Color.Black;
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "bone")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "btwo")
{
this.BackgroundImage = "backgroundnew.png";
}
else
{
this.BackgroundImage = "backnewtwo.png";
}
// stat = detail;
var queue = CrossMediaManager.Current.MediaQueue;
TableQuery y = new TableQuery();
SQLiteConnection K;
K = DependencyService.Get <ISQLite>().GetConnection();
K.Table <TempTbl>();
var NowTable = K.ExecuteScalar <string>("SELECT TblNumbe FROM TempTbl ORDER BY Id DESC LIMIT 1");
tikettable = NowTable;
//CrossMediaManager.Current.Play(VedioUrl, MediaFileType.Video);
//CrossMediaManager.Current.PlaybackController.PlayPreviousOrSeekToStart();
//CrossMediaManager.Current.PlaybackController.Play();
//this.volumeLabel.Text = "Volume (0-" + CrossMediaManager.Current.VolumeManager.MaxVolume + ")";
////Initialize Volume settings to match interface
//int.TryParse(this.volumeEntry.Text, out var vol);
//CrossMediaManager.Current.VolumeManager.CurrentVolume = vol;
//CrossMediaManager.Current.VolumeManager.Muted = false;
//CrossMediaManager.Current.PlayingChanged += (sender, e) =>
//{
// Device.BeginInvokeOnMainThread(() =>
// {
// ProgressBar.Progress = e.Progress;
// Duration.Text = "" + e.Duration.TotalSeconds + " seconds";
// });
//};
//var images = new List<String>
//{
// //"https://www.gourmetguide.co.uk/shop/wp-content/uploads/2016/06/Resturant-Food-400x200.jpg",
// //"http://beranisehat.com/wp-content/uploads/2015/06/Healthy-Breakfast-Food-Ideas-400x200.jpg",
// //"http://empireoftheincasrestaurant.com/wp-content/uploads/2016/05/Papa-a-la-huaicaina-3-400x200.jpg"
// "http://www.nefful.com.hk/wp-content/uploads/revslider/food-carousel/food5-768x576.jpg",
// "http://www.nefful.com.hk/wp-content/uploads/revslider/food-carousel/food4-768x576.jpg",
// "http://www.nefful.com.hk/wp-content/uploads/revslider/food-carousel/muesli-768x576.jpg",
// "http://www.nefful.com.hk/wp-content/uploads/revslider/food-carousel/food3-768x576.jpg",
// "http://www.nefful.com.hk/wp-content/uploads/revslider/food-carousel/food2-768x576.jpg",
// "http://www.nefful.com.hk/wp-content/uploads/revslider/food-carousel/food1-768x576.jpg"
//};
// Getslidetimer();
//mainCarosel.ItemsSource = images;
////MainCarouselViewone.ItemsSource = images;
//Device.StartTimer(TimeSpan.FromSeconds(5), (Func<bool>)(() =>
//{
//// public static int SlidePosition = 0;
// // SlidePositionTemp = 0;
// if (SlidePosition < images.Count)
// {
// if (SlidePositionTemp != 0 && SlidePositionTemp == SlidePosition)
// { SlidePosition--; SlidePositionTemp--; }
// else { SlidePosition++; }
// if (SlidePosition == images.Count)
// {
// //SlidePosition= 0;
// SlidePosition= images.Count- 1;
// SlidePositionTemp = SlidePosition;
// }
// }
// mainCarosel.Position = SlidePosition;
// // mainCarosel.Position = (mainCarosel.Position + 1) % images.Count;
// return _isTimerStart;
//}));
var names = new List <String>
{
"BEST DEALS AND PROMOTIONS AT T-LOUNGE CUSTOMERS ONLY ON THIS SESSION", "ENJOY THE FUNTASTIC PROMOTIONS ONLY IN T-LOUNGE ARCADE", "EXITING PROMOTIONS ONLY FOR LOYALITY CUSTOMERS"
};
//mainCarosel.ItemSelected += (sender, args) =>
//{
// DisplayAlert("yes","yes","OK");
// //var zoo = args.SelectedItem as Zoo;
// //if (zoo == null)
// // return;
// //Title = zoo.Name;
//};
//return new DataTemplate(() =>
//{
// Image v = images.Count;
// TapGestureRecognizer imageTap = new TapGestureRecognizer();
// imageTap.Tapped += (sender, e) =>
// {
// Navigation.PushAsync(new FoodTabbedPage());
// };
// v.GestureRecognizers.Add(imageTap);
// Count++;
// return v;
//});
//wordheading.ItemsSource = names;
//Device.StartTimer(TimeSpan.FromSeconds(3), (Func<bool>)(() =>
//{
// wordheading.Position = (wordheading.Position + 1) % names.Count;
// return true;
//}));
}
public Login()
{
InitializeComponent();
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
//this.BackgroundImage = "background.png";
this.Title = "Login";
var username = new Entry {
Placeholder = "Username", PlaceholderColor = Color.Gray, TextColor = Color.White, BackgroundColor = Color.Black, Opacity = 0.7
};
var password = new Entry {
IsPassword = true, Placeholder = "Password", PlaceholderColor = Color.Gray, TextColor = Color.White, BackgroundColor = Color.Black, Opacity = 0.7
};
var login = new Button {
Text = "Login"
};
var lbl_signup = new Label {
Text = "Not a Member? Click the button and sign up now!", TextColor = Color.White
};
var signup = new Button {
Text = "Sign up"
};
signup.Clicked += (object sender, EventArgs e) =>
{
Navigation.PushAsync(new SignUp());
};
login.Clicked += (object sender, EventArgs e) =>
{
CustomersDB _CustomerDB = new CustomersDB();
CustomerQuery _CustomerQuery = new CustomerQuery();
CustomersDB c = _CustomerQuery.GetCustName(username.Text);
if (c != null)
{
if (password.Text == c.Password)
{
// DisplayAlert("Alert", "login succesful", "OK");
//Navigation.PushAsync(new PayNow());
Navigation.PushAsync(new IPaccessPage());
}
else
{
DisplayAlert("Alert", "login failed", "OK");
}
}
// DisplayAlert("Alert", "ID: " + c.Id + " UserName: "******" Password: "******"OK");
};
//var btnStack = new StackLayout
//{
// Orientation = StackOrientation.Horizontal,
// HorizontalOptions = LayoutOptions.FillAndExpand,
// Children = {
// login, signup
// }
//};
Content = new StackLayout
{
VerticalOptions = LayoutOptions.Center,
HorizontalOptions = LayoutOptions.Center,
Children = { username, password, login, lbl_signup, signup }
};
}
public IPaccessPage()
{
// bone = "background.png";
// btwo = "backgroundnew.png";
InitializeComponent();
//bone = "background.png";
//themeName.Title = "select";
themeName.Items.Add("Style1");
themeName.Items.Add("Style2");
themeName.Items.Add("Style3");
//themeName.Items.Add("Style4");
// btwo = "backgroundnew.png";
// this.BackgroundImage = "backnewtwo.png";
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
// splashscreen.gif
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
//this.BackgroundImage = "backgroundSmoke.gif";
}
//else if (saveback == "Style4")
//{
// // this.BackgroundImage = "backnewtwo.png";
// this.BackgroundImage = "backgroundSmoke.gif";
//}
// this.BackgroundImage = saveback;
// this.BackgroundImage = bone;
//}
//else if(backnow == btwo)
//{
// this.BackgroundImage = "backgroundnew.png";
//}
//this.BackgroundImage = backnow;
DisplayAlert("Background massage", backnow, "OK");
this.Title = "IP SETUP";
IPQuery IPR = new IPQuery();
SQLiteConnection IPK;
IPK = DependencyService.Get <ISQLite>().GetConnection();
IPK.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var ipdiso = IPK.ExecuteScalar <string>("SELECT IPnumb FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
// var backnow = IPK.ExecuteScalar<string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
// DisplayAlert("Existing IP", ipdiso, "OK");
ipaddressWIFItwo = ipdiso;
//if (backnow == bone)
//{
// this.BackgroundImage = "background.png";
//}
//else if (backnow == btwo)
//{
// this.BackgroundImage = "backgroundnew.png";
//}
//else
//{
// this.BackgroundColor = Color.White;
// DisplayAlert("No background", "No background", "OK");
//}
// isOnline();
// ipaddressWIFItwo = "http://172.16.101.236/";
//WifiManager wifiManager = (WifiManager)context.GetSystemService(Service.WifiService);
//int ip = wifiManager.ConnectionInfo.IpAddress;
}
//protected override void OnAppearing()
//{
// base.OnAppearing();
// themeName.Title = "hello";
// //your code here;
//}
public void savebuton(object sender, EventArgs e)
{
bone = "background.png";
btwo = "backgroundnew.png";
// DependencyService.Get<ISaveAndLoad>().SaveText("temp.txt", input.Text);
// themetyp = themenum.Text;
ipaddressWIFI = input.Text;
Terminal = inputTerminal.Text;
ipaddressWIFItwo = "http://" + ipaddressWIFI + "/";
// DisplayAlert("text", ipaddressWIFItwo, "OK");
IPaddressDB IPA = new IPaddressDB();
SQLiteConnection s;
s = DependencyService.Get <ISQLite>().GetConnection();
s.Table <IPaddressDB>();
IPA.IPnumb = ipaddressWIFItwo;
IPA.Terminal = Terminal;
IPA.Counter = CounterNum;
IPA.backgrund = pickername;
// IPA.backgrund = themetyp;
IPQuery c = new IPQuery();
c.InsertDetails(IPA);
IPQuery IPRI = new IPQuery();
SQLiteConnection IPKI;
IPKI = DependencyService.Get <ISQLite>().GetConnection();
IPKI.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPKI.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
if (pickername == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (pickername == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (pickername == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
//else
//{
// this.BackgroundImage = "backnewtwo.png";
// DisplayAlert("Default Background", "Default Background", "OK");
//}
//if (themenum.Text == "bone")
//{
// this.BackgroundImage = "background.png";
//}
//else if (themenum.Text == "btwo")
//{
// this.BackgroundImage = "backgroundnew.png";
//}
//else
//{
// this.BackgroundImage = "backnewtwo.png";
// DisplayAlert("Default Background", "Default Background", "OK");
//}
// DisplayAlert("NEW IP", ipaddressWIFItwo, "OK");
}
public OnlineLoginPage()
{
InitializeComponent();
Init();
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
// this.BackgroundImage = "backgroundnew.png";
this.Title = "Login";
NavigationPage.SetHasBackButton(this, false);
// GetIPAddress();
// Task<bool> IsRemoteReachable(string host, int port = 80, int msTimeout = 5000);
// string ipaddress = DependencyService.Get<IIPAddressManager>().GetIPAddress();
// DisplayAlert("Net", ipaddress,"OK");
// DisplayAlert("Net", IPaccessPage.ipaddressWIFItwo, "OK");
IPQuery IPR = new IPQuery();
SQLiteConnection IPK;
IPK = DependencyService.Get <ISQLite>().GetConnection();
IPK.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var ipdiso = IPK.ExecuteScalar <string>("SELECT IPnumb FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
// DisplayAlert("Existing IP", ipdiso, "OK");
ipinfotop.Text = "EXISTING IP ADDRESS OF THE SYSTEM IS :" + ipdiso;
//var saveButton = new Button { Text = "Save" };
//saveButton.Clicked += (sender, e) => {
// DependencyService.Get<ISaveAndLoad>().SaveText("temp.txt", input.Text);
//};
//var loadButton = new Button { Text = "Load" };
//loadButton.Clicked += (sender, e) => {
// output.Text = DependencyService.Get<ISaveAndLoad>().LoadText("temp.txt");
//};
//Java.Util.IEnumeration networkInterfaces = NetworkInterface.NetworkInterfaces;
//while (networkInterfaces.HasMoreElements)
//{
// Java.Net.NetworkInterface netInterface =
// (Java.Net.NetworkInterface)networkInterfaces.NextElement();
// DisplayAlert("network", netInterface.ToString(), "OK");
// // Console.WriteLine(netInterface.ToString());
//}
try
{
int newnumber = 1;
ToolbarItem cartItem = new ToolbarItem();
cartItem.Order = ToolbarItemOrder.Primary;
cartItem.Text = "IP SETUP";
// cartItem.Icon = "orderNewThree.png";
//cartItem.Command = new Command(() => Navigation.PushAsync(new IPaccessPage()));
cartItem.Command = new Command(() => Navigation.PushAsync(new Login()));
ToolbarItems.Add(cartItem);
//SQLiteConnection m;
//m = DependencyService.Get<ISQLite>().GetConnection();
//TempTbl mit = new TempTbl();
//m.Table<TempTbl>();
//m.DeleteAll<TempTbl>();
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
public JsonTable(int numb)
{
//InitializeComponent();
InitializeComponent();
// this.BackgroundImage = "background.png";
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
this.Title = "Tables";
resul = numb;
// DisplayAlert("identity", Convert.ToString(resul), "ok");
if (CrossConnectivity.Current.IsConnected)
{
try
{
GetJSON();
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
// GetUsedTable();
// Higlight();
//if (Newtab == Usetab)
//{
// DisplayAlert("ocupied tables are", Convert.ToString(Usetab), "OK");
//// Button btn = new Button();
//// btn.BackgroundColor = Color.FromHex("#22ac38");
//}
BindingContext = new JsonTableClass();
//int resul = numb;
//DisplayAlert("identity", Convert.ToString(resul),"ok");
// CrossConnectivity.Current.ConnectivityChanged += Current_ConnectivityChanged;
// decimal toti = 0;
// ToolbarItem cartItem = new ToolbarItem();
//// cartItem.Text = "My Cart";
// cartItem.Order = ToolbarItemOrder.Primary;
// cartItem.Icon = "ShoppingCart9.png";
// cartItem.Command = new Command(() => Navigation.PushAsync(new OnlineCart(toti)));
// ToolbarItems.Add(cartItem);
//StuwaQuery n = new StuwaQuery();
//SQLiteConnection k;
//k = DependencyService.Get<ISQLite>().GetConnection();
//k.Table<StuwardTbl>();
//var cou = k.ExecuteScalar<string>("SELECT max(StuwaName) FROM StuwardTbl");
//var stid = k.ExecuteScalar<int>("SELECT max(StuwaID) FROM StuwardTbl");
//DisplayAlert("Stuwa Name", cou,Convert.ToString(stid), "OK");
}
/// <summary>
/// 根据IP的地理位置
/// </summary>
/// <param name="IP">IP</param>
/// <returns></returns>
protected string GetAddressWithIP(string IP)
{
return(IPQuery.GetAddressWithIP(IP));
}
//public Command DeleteCommand { get; }
public OnlineCart(decimal totalnew)
{
InitializeComponent();
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
//this.BackgroundImage = "background.png";
NavigationPage.SetHasBackButton(this, true);
this.Title = "MENU";
GC.Collect(1);
if (CrossConnectivity.Current.IsConnected)
{
try
{
if (totalnew > 0)
{
// DisplayAlert("one", "1", "OK");
foodback.IsVisible = false;
}
else
{
// DisplayAlert("two", "2", "OK");
foodback.IsVisible = true;
}
try
{
int newnumber = 2;
ToolbarItem cartItem = new ToolbarItem();
cartItem.Order = ToolbarItemOrder.Primary;
cartItem.Text = "START NEW ORDER";
// cartItem.Icon = "orderNewThree.png";
cartItem.Command = new Command(() => Navigation.PushAsync(new JsonTable(newnumber)));
ToolbarItems.Add(cartItem);
//SQLiteConnection m;
//m = DependencyService.Get<ISQLite>().GetConnection();
//TempTbl mit = new TempTbl();
//m.Table<TempTbl>();
//m.DeleteAll<TempTbl>();
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
try
{
// int newnumber = 2;
ToolbarItem RefreshPage = new ToolbarItem();
RefreshPage.Order = ToolbarItemOrder.Primary;
RefreshPage.Text = "REFRESH";
// cartItem.Icon = "orderNewThree.png";
//decimal tot;
RefreshPage.Command = new Command(() => Navigation.PushAsync(new OnlineCart(totalnew)));
ToolbarItems.Add(RefreshPage);
//SQLiteConnection m;
//m = DependencyService.Get<ISQLite>().GetConnection();
//TempTbl mit = new TempTbl();
//m.Table<TempTbl>();
//m.DeleteAll<TempTbl>();
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
// this.ToolbartItems.Add(new ToolbarItem { Text = "BTN 1", Icon = "myicon.png" });
//CrossConnectivity.Current.ConnectivityChanged += Current_ConnectivityChanged;
//var items = new List<JsonCartone>();
//cartone.ItemsSource = items;
//decimal tot;
TotalTbl tbr = new TotalTbl();
SQLiteConnection s;
s = DependencyService.Get <ISQLite>().GetConnection();
s.Table <TotalTbl>();
// tbr.ItmID = id;
tbr.ItmTotal = totalnew;
//tbr.TblName = Convert.ToString(data.ID);
TotalQuery c = new TotalQuery();
c.InsertDetails(tbr);
// this.total = totalnav;
// decimal tot ;
// tot =+ totalnew ;
// total.Text = c.GetTotal() + "";
// decimal tax = 15;
total.Text = c.GetTotal() + "";
decimal tota = Convert.ToDecimal(total.Text);
// gandtot.Text = Convert.ToString(tota + tax);
// ItemInfo.Text += Convert.ToString(id);
// cartone.SelectedItem += ItemInfo.Text;
cartone.ItemsSource = update_Item;
// DisplayAlert("item IDs", ItemInfo.Text, "OK");
// cartone.IsPullToRefreshEnabled = true;
GetJSON();
//long freeMemory = Java.Lang.Runtime.GetRuntime().FreeMemory();
//DisplayAlert("freemomory", Convert.ToString(freeMemory), "OK");
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
