public void RefreshPageData(DateTime dt) { try { using (var db = new ManageDataset()) { var t = db.TraderDailyDS.Where(_ => _.Date == dt).ToList(); var m = db.MarketDailyDS.Where(_ => _.TradeDate == dt.Date).ToList(); var listNotMatchedMarket = new List <MarketDetailDaily>(); var result = EntityCompareHelper.GetCompareData(m, t, listNotMatchedMarket); this.Dispatcher.BeginInvoke(DispatcherPriority.Normal, new Action(() => { this.loading.HideLoading(); this.dgMarketMatched.ItemsSource = result.Keys; this.dgTradeMatched.ItemsSource = result.Values; this.dgNotMatchedMarket.ItemsSource = listNotMatchedMarket; this.dgMarket.ItemsSource = m; this.dgTrader.ItemsSource = t; })); } } catch (Exception ex) { CommonUtils.ShowMsg(ex.Message); } }
private void RefreshCompareData(DateTime startDate, DateTime endDate) { try { using (var db = new ManageDataset()) { //var edt = endDate.Date; var listCompareDailyOld = db.CompareDailyDS.Where(_ => _.DATE >= startDate && _.DATE <= endDate).ToList(); //var listCompareTraderOld = db.CompareTraderDS.Where(_ => _.StartDate == startDate && _.EndDate == edt).ToList(); var lstM = db.MarketDailyDS.Where(_ => _.TradeDate >= startDate && _.TradeDate <= endDate).ToList(); var lstT = db.TraderDailyDS.Where(_ => _.Date >= startDate && _.Date <= endDate).ToList(); var listCompareDaily = Entity.EntityCompareHelper.GetCompareDaily(lstM, lstT); db.CompareDailyDS.RemoveRange(listCompareDailyOld); db.CompareDailyDS.AddRange(listCompareDaily); //var listCompareTrader = EntityCompareHelper.GetCompareTrader(startDate, edt, listCompareDaily); //db.CompareTraderDS.RemoveRange(listCompareTraderOld); //db.CompareTraderDS.AddRange(listCompareTrader); db.SaveChanges(); } } catch (Exception ex) { CommonUtils.Log(ex.Message); } }
public void Init() { try { using (var db = new ManageDataset()) { var t = db.TraderDailyDS.Select(_ => _.Date).Distinct().ToList(); var m = db.MarketDailyDS.Select(_ => _.TradeDate).Distinct().ToList(); t.AddRange(m); t = t.Distinct().ToList(); this.cmbDate.ItemsSource = t.Select(_ => _.ToShortDateString()); } } catch (Exception) { //CommonUtils.ShowMsg("比较器初始化错误:" + ex.Message); } }
private void SetPageData(DateTime startDate, DateTime endDate) { try { List <CompareDaily> lstCompareDaily = null; List <CompareTrader> lstCompareTrader = null; using (var db = new ManageDataset()) { lstCompareDaily = db.CompareDailyDS.Where(_ => _.DATE >= startDate && _.DATE <= endDate).ToList(); lstCompareDaily = lstCompareDaily.OrderBy(_ => _.DATE).ThenBy(_ => _.TRADER).ThenBy(_ => _.Symbol2).ThenBy(_ => _.Seq).ToList(); lstCompareTrader = EntityCompareHelper.GetCompareTrader(startDate, endDate.Date, lstCompareDaily); CompareDailyList = lstCompareDaily; CompareTraderList = lstCompareTrader; } cbTrader.Items.Clear(); List <string> lstTrader = lstCompareTrader.Select(_ => _.Trader).Distinct().ToList(); lstTrader.ForEach(_ => this.cbTrader.Items.Add(new CheckBox() { Content = _, IsChecked = true })); lstCompareDaily.ForEach(_ => { _.FormatData(); }); lstCompareTrader.ForEach(_ => _.FormatData()); this.dgDailyDetail.ItemsSource = lstCompareDaily; this.dgTraderDetail.ItemsSource = lstCompareTrader; this.bdFilter.Visibility = Visibility.Visible; this.loading.HideLoading(); } catch (Exception ex) { this.loading.HideLoading(); CommonUtils.Log("在显示界面时出错了!", ex); CommonUtils.ShowMsg("出错了,请查看日志"); } }
public void Init() { try { using (var db = new ManageDataset()) { var t = db.TraderDailyDS.Select(_ => _.Date).Distinct().ToList(); var m = db.MarketDailyDS.Select(_ => _.TradeDate).Distinct().ToList(); var exceptDate = t.Except(m).ToList(); foreach (var item in exceptDate) { t.Remove(item); } this.cmbDate.ItemsSource = t.OrderByDescending(_ => _).Take(10).Select(_ => _.ToString("yyyy/MM/dd")); } } catch (Exception) { //CommonUtils.ShowMsg("比较器初始化错误:" + ex.Message); } }