private void button1_Click(object sender, EventArgs e)
{
List <stock> stocks = new List <stock>();
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if (item.Cells["changed"].Value == null)
{
continue;
}
string changed = item.Cells["changed"].Value.ToString();
if (changed != "1")
{
continue;
}
var temp = item.DataBoundItem as stock;
if (temp == null)
{
continue;
}
if (temp.id == 0)
{
if (!string.IsNullOrEmpty(temp.code) && !string.IsNullOrEmpty(temp.name))
{
var result = stockDb.stockInfos.SingleOrDefault(t => t.code == temp.code || t.name == temp.code);
temp.area = result.area;
stockDb.stock.Add(temp);
}
}
else
{
var Obj = stockDb.stock.Find(temp.id);
Obj.count = temp.count;
Obj.name = temp.name;
Obj.code = temp.code;
Obj.type = temp.type;
Obj.salePrice = temp.salePrice;
Obj.buyPrice = temp.buyPrice;
Obj.buyDate = temp.buyDate;
Obj.planEarnMoney = temp.planEarnMoney;
Obj.lowBuyPrice = temp.lowBuyPrice;
stocks.Add(Obj);
}
}
stockDb.SaveChanges();
BindGridView();
toolStripStatusLabel1.Text = "操作成功！";
}
private void button3_Click(object sender, EventArgs e)
{
using (StockInfoEntities stockDb = new StockInfoEntities())
{
//同步昨日净值
foreach (DataGridViewRow item in dataGridView1.Rows)
{
var stock = (stock)item.DataBoundItem;
var stockInfo = stockDb.stock.Find(stock.id);
stockInfo.PrevEarnMoney = Convert.ToDecimal(item.Cells["earnMoney"].Value);
}
stockDb.SaveChanges();
}
MessageBox.Show("操作成功!");
}
private async Task BindGridViewAsync()
{
using (StockInfoEntities stockDb = new StockInfoEntities())
{
var Data = stockDb.stock.Where(t => t.type == "持有").ToList();
MyStock = (from item in Data
select new stockExtend()
{
id = item.id,
code = item.code,
buyPrice = item.buyPrice,
area = item.area,
count = item.count,
curPrice = 0,
name = item.name,
salePrice = item.salePrice,
type = item.type,
planEarnMoney = item.planEarnMoney,
PrevEarnMoney = item.PrevEarnMoney,
isShort = item.isShort
}
).ToList();
stockBindingSource.DataSource = Data;
foreach (var item in MyStock)
{
var dict = await RequestHelper.GetStockMAInfoAsync(item.area.ToUpper() + item.code);
var tempStockInfo = stockDb.stock.Find(item.id);
tempStockInfo.MAInfos = "MA4:" + dict["MA4"].ToString() + ";";
item.DictMaInfos = dict;
stockDb.SaveChanges();
}
}
}
