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