/* * Function: GetFlightsByTime * Description: Gets all the flight in DB that are active during `relative_to` time. */ public IEnumerable <Flight> GetFlightsByTime(MyDateTime relativeTo) { var flights = new List <Flight> { }; // Connection Opened // _conn.Open(); var cmd = _conn.CreateCommand(); cmd.CommandText = @"SELECT * FROM flights WHERE takeoff_unix <= " + relativeTo.unix + " AND landing_unix >= " + relativeTo.unix + " AND is_external = 0"; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { // Logic seems problematic - passing reader and connection to Flight var flight = new Flight(reader, _conn, relativeTo); flights.Add(flight); } } // Connection Closed // _conn.Close(); return(flights); }
public MinerTradeHistoryRecordControl() { InitializeComponent(); this.datagrid.ItemsSource = App.TradeHistoryVMObject.ListMinerBuyRecords; this.dpStartCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now.AddDays(-7)); this.dpEndCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now); }
private string getCalculatedInvocieNumber(int freeNum) { //Last one or 2 digit + Prefix + Number string Num = ""; //year, 9, 10,11.. Num += MyDateTime.GetYearNumber(); //Prefix, string prefix = ""; switch (_invType) { case (int)NInvoiceType.Regular: prefix = SalesCenterConstants.PrefixInvoice; break; case (int)NInvoiceType.Proforma: prefix = SalesCenterConstants.PrefixProformaInvoice; break; } Num += prefix; Num += (freeNum + SalesCenterConstants.BEGIN_INVOICE_NUMBER).ToString("D4"); return(Num); }
protected ArchivesDetails GetArchivesFromReader(IDataReader iDataReader) { return(new ArchivesDetails((int)iDataReader["Id"], (byte)iDataReader["BigType"], (byte)iDataReader["SmallType"] , (double)iDataReader["Amount"], (double)iDataReader["Price"], (double)iDataReader["PaidMoney"], (double)iDataReader["StayingPrice"] , (double)iDataReader["Profit"], MyDateTime.Parse(iDataReader["AddedDate1"].ToString()) , MyDateTime.Parse(iDataReader["AddedDate2"].ToString()), MyDateTime.Parse(iDataReader["AddedDate"].ToString()), iDataReader["Details"].ToString())); }
public void SetRecordPay() { this.ParentObject.IsPay = true; this.ParentObject.PayTime = MyDateTime.FromDateTime(DateTime.Now); NotifyPropertyChange("IsPay"); NotifyPropertyChange("PayTime"); }
public AlipayHistoryRecordControl() { InitializeComponent(); this.datagrid.ItemsSource = App.TradeHistoryVMObject.ListAllAlipayRecords; this.dpStartPayTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now.AddDays(-7)); this.dpEndPayTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now); }
public override string IsValidated() { var b = true; string validationResult = ""; //Installation Address var msc = new MySalesJobMasterListCustomer(BaseValue.JobID); msc.SetInstallTo(); if (msc.CustomerID == 0) { validationResult += "No Installation Company Selected " + System.Environment.NewLine; b = false; } else { var mc = new MyCustomer(msc.CustomerID); if (MyConvert.ConvertToString(mc.Value.ADDR_1).Length < 5) { validationResult += "No Installation Address " + System.Environment.NewLine; b = false; } } //Document Attached var requiredDocuemntTypes = new int[] { 200 }; for (int i = 0; i < requiredDocuemntTypes.Length; i++) { var docTypeID = requiredDocuemntTypes[i]; var docAttached = _db.PermitDocuments.Where(x => x.BaseAppID == BaseValue.BaseAppID & x.DocType == docTypeID).ToList(); if (!docAttached.Any()) { var docType = _db.PermitDocumentTypes.Find(docTypeID); validationResult += "Document Required: " + docType.TypeName + System.Environment.NewLine; b = false; } } //Leadtime if (BaseValue.Deadline <= DateTime.Today) { validationResult += "Lead time is 5 business days " + System.Environment.NewLine; b = false; } else { var endDate = Convert.ToDateTime(BaseValue.Deadline); if (MyDateTime.GetDiffHoursOfWeekday(DateTime.Today, endDate) < 24 * NLeadTime) { validationResult += "Lead time is 5 business days " + System.Environment.NewLine; b = false; } } return(b ? "ok" : validationResult); }
public GoldCoinRechargeHistoryRecordControl() { InitializeComponent(); this.dgRecords.ItemsSource = App.TradeHistoryVMObject.ListGoldCoinRechargeRecords; this.dpStartCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now.AddDays(-7)); this.dpEndCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now); }
/* * Function: GetExternalFlightsByTime * Description: This method sends an async request to the external servers, and asks for * the relevant flights for `relative_to`. */ public async Task <IEnumerable <Flight> > GetExternalFlightsByTime(MyDateTime relativeTo) { var flights = new List <Flight> { }; var servers = _queryManager.GetAllServers(); foreach (var server in servers) { try { // Send the request and try to get the Flights list var url = server.url + "/api/Flights?relative_to=" + relativeTo.iso; string ext = await _httpClient.GetStringAsync(url); var severFlights = JsonConvert.DeserializeObject <IEnumerable <Flight> >(ext); flights.AddRange(severFlights); } catch (Exception e) { var err = @"Problem occurred while fetching data from server " + server.url + " (" + e.Message + ")"; Console.WriteLine(err); } } // Set all flight as external foreach (var flight in flights) { flight.isExternal = true; } return(flights); }
public BaseDetails(int id, string name, string details, MyDateTime addeddate) { this.ID = id; this.Details = details; this.AddedDate = addeddate; this.Name = name; }
public HandleExceptionAlipayRecordWindow(AlipayRechargeRecordUIModel alipayRecord) { InitializeComponent(); _alipayRecord = alipayRecord; try { this.txtAlipayOrderNumber.Text = alipayRecord.alipay_trade_no; this.txtBuyerEmail.Text = alipayRecord.buyer_email; this.txtBuyerEmail.IsReadOnly = true; this.txtBuyerUserName.Text = alipayRecord.user_name; this.txtBuyerUserName.IsReadOnly = true; this.txtOrderNumber.Text = alipayRecord.out_trade_no; this.txtOrderNumber.IsReadOnly = true; this.txtOrderType.Text = alipayRecord.TradeTypeText; this.numTotalFee.Value = (double)alipayRecord.total_fee; this.numTotalFee.IsReadOnly = true; //this.numValueRMB.Value = (double)alipayRecord.value_rmb; this.mydpPayTime.ValueTime = MyDateTime.FromDateTime(alipayRecord.pay_time); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
public int PayAward(string adminUserName, string playerUserName, int recordID) { RouletteWinnerRecord record = _finishedRouletteWinnerRecord.FirstOrDefault(r => r.RecordID == recordID); if (record == null) { return(OperResult.RESULTCODE_GAME_WINAWARDRECORD_NOT_EXIST); } if (record.UserName != playerUserName) { return(OperResult.RESULTCODE_GAME_WINAWARDRECORD_NOT_EXIST); } record.IsPay = true; record.PayTime = MyDateTime.FromDateTime(DateTime.Now); //save To DB DBProvider.GameRouletteDBProvider.SetWinnerRecordPay(record); //notify player LogHelper.Instance.AddInfoLog("管理员[" + adminUserName + "],确认支付了玩家[" + playerUserName + "]的幸运转盘大奖," + record.AwardItem.AwardName); string playerToken = ClientManager.GetToken(playerUserName); if (!string.IsNullOrEmpty(playerToken)) { if (RouletteWinRealAwardPaySucceedNotify != null) { RouletteWinRealAwardPaySucceedNotify(playerToken, record); } } _finishedRouletteWinnerRecord.Remove(record); return(OperResult.RESULTCODE_TRUE); }
/// <summary> /// 领取奖励 /// </summary> /// <param name="userName"></param> /// <param name="recordID"></param> /// <param name="info1"></param> /// <param name="info2"></param> public int TakeAward(string userName, int recordID, string info1, string info2) { RouletteWinnerRecord record = _finishedRouletteWinnerRecord.FirstOrDefault(r => r.RecordID == recordID); if (record == null) { return(OperResult.RESULTCODE_GAME_WINAWARDRECORD_NOT_EXIST); } if (record.UserName != userName) { return(OperResult.RESULTCODE_GAME_WINAWARDRECORD_NOT_EXIST); } record.IsGot = true; record.GotTime = MyDateTime.FromDateTime(DateTime.Now); record.GotInfo1 = info1; record.GotInfo2 = info2; //Save to DB DBProvider.GameRouletteDBProvider.SetWinnerRecordGot(record); //Notify Administrator LogHelper.Instance.AddInfoLog("玩家[" + userName + "],领取了幸运转盘大奖," + record.AwardItem.AwardName); return(OperResult.RESULTCODE_TRUE); }
static void Main(string[] args) { MyDateTime test = new MyDateTime(2000); Console.WriteLine(test); MyDateTime test1 = new MyDateTime(); Console.WriteLine(test1); int result; MyDateTime act = new MyDateTime(); MyDateTime date = new MyDateTime(29, 2, 2001); MyDateTime date2 = new MyDateTime(1, 2, 2000); act.Chrono(ref date, ref date2); Console.WriteLine(date.ToString()); Console.WriteLine(date2.ToString()); act.Calculated(date, date2, out result); Console.WriteLine(result); //Person person = new Person("pasha", "ruchkov", DateTime.Parse("2.2.2000")); //Magazine magazine = new Magazine("IMYA",DateTime.Parse("1.2.2000"), 1 ); //magazine.AddArticle(new [] {new Article(person, "name", 2), }); //magazine.AddArticle(new [] {new Article(person, "name1", 3), }); //magazine.AddArticle(new [] {new Article(person, "name2", 5), }); //Console.WriteLine(magazine.ToString()); Console.ReadKey(); }
protected ClientDealDetails GetClientDealFromReader(IDataReader iDataReader) { return(new ClientDealDetails( (int)iDataReader["Id"], (int)iDataReader["TypeId"], (int)iDataReader["ClientId"] , (double)iDataReader["Amount"], (double)iDataReader["Price"], (double)iDataReader["PaidMoney"], iDataReader["Details"].ToString(), MyDateTime.Parse(iDataReader["AddedDate"].ToString()), (TheUnito)Enum.Parse(typeof(TheUnito), iDataReader["TheUnit"].ToString()), (double)iDataReader["BusinessPrice"], iDataReader["ClientName"].ToString(), iDataReader["TypeName"].ToString())); }
public StoneSellTradeHistoryRecordControl() { InitializeComponent(); this.dgRecords.ItemsSource = App.StoneOrderVMObject.ListMySellStoneHistoryOrders; this.dpStartCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now.AddDays(-7)); this.dpEndCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now); }
public void AsyncGetUserRemoteHandleServiceRecords(string playerUserName, MyDateTime beginCreateTime, MyDateTime endCreateTime, int pageItemCount, int pageIndex) { if (GlobalData.Client.IsConnected) { App.BusyToken.ShowBusyWindow("正在查询数据..."); GlobalData.Client.GetUserRemoteHandleServiceRecords(playerUserName, beginCreateTime, endCreateTime, pageItemCount, pageIndex); } }
public static int InsertCompany(int id, string name, string details) { MyDateTime xx = new MyDateTime(DateTime.Now); CompanyDetails tb1 = new CompanyDetails(id, name, details, xx, 0); int x = myRealProvider.InsertCompany(tb1); return(x); }
public void AsyncGetMyselfAwardRecord(int RouletteAwardItemID, MyDateTime BeginWinTime, MyDateTime EndWinTime, int IsGot, int IsPay, int pageItemCount, int pageIndex) { if (GlobalData.Client.IsEnable) { App.BusyToken.ShowBusyWindow("正在加载数据..."); GlobalData.Client.GetAllWinAwardRecords(GlobalData.CurrentUser.UserName, RouletteAwardItemID, BeginWinTime, EndWinTime, IsGot, IsPay, pageItemCount, pageIndex, GlobalData.CurrentUser.UserName); } }
public DelegateBuyStoneHistoryRecordControl() { InitializeComponent(); this.dgRecords.ItemsSource = App.StackStoneVMObject.AllFinishedBuyOrders; this.dpStartCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now.AddDays(-7)); this.dpEndCreateTime.ValueTime = MyDateTime.FromDateTime(DateTime.Now); }
public void AsyncGetBuyMinerFinishedRecordList(string playerUserName, MyDateTime beginCreateTime, MyDateTime endCreateTime, int pageItemCount, int pageIndex) { if (GlobalData.Client != null) { App.BusyToken.ShowBusyWindow("正在查询矿工购买记录..."); ListMinerBuyRecords.Clear(); GlobalData.Client.GetBuyMinerFinishedRecordList(playerUserName, beginCreateTime, endCreateTime, pageItemCount, pageIndex); } }
public void AsyncGetWithdrawRMBRecordList(int state, string playerUserName, MyDateTime beginCreateTime, MyDateTime endCreateTime, string adminUserName, MyDateTime beginPayTime, MyDateTime endPayTime, int pageItemCount, int pageIndex) { if (GlobalData.Client != null) { App.BusyToken.ShowBusyWindow("正在查找数据..."); ListHistoryWithdrawRecords.Clear(); GlobalData.Client.GetWithdrawRMBRecordList(state, playerUserName, beginCreateTime, endCreateTime, adminUserName, beginPayTime, endPayTime, pageItemCount, pageIndex); } }
protected BusinesDealDetails GetBusinesDealFromReader(IDataReader iDataReader) { return(new BusinesDealDetails( (int)iDataReader["Id"], (int)iDataReader["TypeId"], (int)iDataReader["ManId"] , (double)iDataReader["Amount"], (double)iDataReader["BusinessPrice"], (double)iDataReader["ClientPrice"], (double)iDataReader["PaidMoney"], iDataReader["Details"].ToString(), MyDateTime.Parse(iDataReader["AddedDate"].ToString()), iDataReader["ManName"].ToString(), iDataReader["TypeName"].ToString())); }
public Store(int id, int typeid, double amount, MyDateTime addedDatecompany, MyDateTime addedDateclient, string typename) { this.ID = id; this.TypeId = typeid; this.Amount = amount; this.AddedDateClient = addedDateclient; this.AddedDateCompany = addedDatecompany; this.TypeName = typename; }
protected TypeDetails GetTypeFromReader(IDataReader iDataReader) { return(new TypeDetails( (int)iDataReader["Id"], iDataReader["TypeName"].ToString(), (double)iDataReader["BusinessPrice"], (double)iDataReader["ClientPrice"], (double)iDataReader["BusinessClientPrice"], MyDateTime.Parse(iDataReader["AddedDate"].ToString()), iDataReader["AllCompanyId"].ToString(), (TheUnito)Enum.Parse(typeof(TheUnito), iDataReader["TheUnit"].ToString()), iDataReader["BaraCode"].ToString())); }
protected ClientDetails GetClientFromReader(IDataReader iDataReader) { return(new ClientDetails( (int)iDataReader["Id"], iDataReader["ClientName"].ToString(), iDataReader["Details"].ToString(), MyDateTime.Parse(iDataReader["AddedDate"].ToString()), (double)iDataReader["Balance"] )); }
protected LastClientsAccountDetails GetLastClientAccountFromReader(IDataReader iDataReader) { return(new LastClientsAccountDetails( (int)iDataReader["Id"], (int)iDataReader["ClientId"], (double)iDataReader["Can"], (double)iDataReader["Numbero"], (double)iDataReader["Sar"], MyDateTime.Parse(iDataReader["AddedDate"].ToString()))); }
public static int InsertType(int id, string name, double businessprice, double clientprice, double businessclientprice, TheUnito theUnit, string baracode) { MyDateTime xx = new MyDateTime(DateTime.Now); TypeDetails tb1 = new TypeDetails(id, name, businessprice, clientprice, businessclientprice, xx, "", theUnit, baracode); int x = myRealProvider.InsertType(tb1); return(x); }
public WipTaskSchedule(int contentID, DateTime targetDate) { _targetDate = MyDateTime.GetDateOfMinusBusinessDays(targetDate, -1); var dbml = new ProjectModelDbEntities(); _task = dbml.tblWipTasks.First(x => x.ContentID == contentID); _scheduleStartDate = DateTime.Today; }
private void Search() { string playerUserName = this.txtPlayerUserName.Text.Trim(); MyDateTime beginCreateTime = this.dpStartCreateTime.ValueTime; MyDateTime endCreateTime = this.dpEndCreateTime.ValueTime; int pageIndex = (int)this.numPageIndex.Value; App.MineTradeVMObject.AsyncGetBuyMineFinishedRecordList(playerUserName, beginCreateTime, endCreateTime, GlobalData.PageItemsCount, pageIndex); }
public int CompareTo(MyDateTime aDateTime) { ////#if UNITY_FLASH if (timestamp < aDateTime.timestamp) { return -1; } else if (timestamp == aDateTime.timestamp) { return 0; } else { return 1; } //#else //#endif }
public HomeIndexFilter() { DateMin = new MyDateTime(); DateMax = new MyDateTime(); }
private bool DateIsValid(MyDateTime date){ return date.IsValid && date.DateTime.HasValue; }