//插入数据
public void Insert(HistoryStockHoldEntity HSHE)
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "insert into '" + user + "_HistoryStockHold' values(@id,@date,@number,@change,@money)";
cmd.Parameters.Add(new SQLiteParameter("id", HSHE.id));
cmd.Parameters.Add(new SQLiteParameter("date", Convert.ToDateTime(HSHE.date.ToString("yyyy-MM-dd"))));
cmd.Parameters.Add(new SQLiteParameter("number", HSHE.number));
cmd.Parameters.Add(new SQLiteParameter("change", HSHE.change));
cmd.Parameters.Add(new SQLiteParameter("money", HSHE.money));
cmd.ExecuteNonQuery();
}
//插入数据
public void Insert(HistoryStockHoldEntity HSHE)
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "insert into '" + user + "_HistoryStockHold' values(@id,@date,@number,@change,@money)";
cmd.Parameters.Add(new SQLiteParameter("id", HSHE.id));
cmd.Parameters.Add(new SQLiteParameter("date", Convert.ToDateTime(HSHE.date.ToString("yyyy-MM-dd"))));
cmd.Parameters.Add(new SQLiteParameter("number", HSHE.number));
cmd.Parameters.Add(new SQLiteParameter("change", HSHE.change));
cmd.Parameters.Add(new SQLiteParameter("money", HSHE.money));
cmd.ExecuteNonQuery();
}
//按类型转换
private StockHoldEntity DealList_Insert_StockHold(DealListEntity DLE)
{
if (DLE.deal >= dealid)
dealid = DLE.deal + 1;
StockHoldEntity SHE = new StockHoldEntity();
SHE.id = DLE.id;
SHE.name = DLE.name;
double c;
if (DLE.type == "买入")
{
SHE.hold = DLE.number;
c = -(DLE.number * DLE.money);
MoneyChangeNow(c);
}
else if (DLE.type == "卖出")
{
SHE.hold = -DLE.number;
c = DLE.number * DLE.money;
MoneyChangeNow(c);
}
else if (DLE.type == "补仓")
{
SHE.hold = DLE.number;
c = -(DLE.number * DLE.money);
MoneyChangeNow(c);
}
else if (DLE.type == "卖空")
{
SHE.hold = -DLE.number;
c = DLE.number * DLE.money;
MoneyChangeNow(c);
}
else
{
SHE.hold = DLE.number;
c = -(DLE.number * DLE.money);
MoneyChangeNow(c);
}
SHE.money = -c;
StockHoldEntity SHE_=new StockHoldEntity();
SHE_.id = SHE.id;
stockhold.Select(ref SHE_);
HistoryStockHoldEntity HSHE = new HistoryStockHoldEntity();
HSHE.id = SHE.id;
HSHE.number = SHE_.hold;
HSHE.date = DLE.date;
HSHE.change = SHE.hold;
HSHE.money = DLE.money;
historystockhold.Insert(HSHE);
if (SHE_.name != null)
{
SHE.hold = SHE.hold + SHE_.hold;
SHE.money = Convert.ToDouble(SHE.money) + Convert.ToDouble(SHE_.money);
stockhold.Update(SHE);
}
else
{
stockhold.Insert(SHE);
}
return SHE;
//StockHoldSet(SHE);
}