public void AddFundStatus(FundStatus model)
{
FundStatus.Add(model);
string sql = "INSERT INTO FundStatus (Id,Date,YesterdayBalance,CustomerRights,Remittance,MatterDeposit,ClosedProfit,Margin,Commission,FreeMargin,TodayBalance,VentureFactor,FloatingProfit,AdditionalMargin,SettlementType,AccountId) "
+ "VALUES(@Id,@Date,@YesterdayBalance,@CustomerRights,@Remittance,@MatterDeposit,@ClosedProfit,@Margin,@Commission,@FreeMargin,@TodayBalance,@VentureFactor,@FloatingProfit,@AdditionalMargin,@SettlementType,@AccountId)";
SQLiteCommand cmd = new SQLiteCommand(sql);
cmd.Parameters.AddWithValue("@AccountId", model.AccountId.ToString());
cmd.Parameters.AddWithValue("@AdditionalMargin", model.AdditionalMargin);
cmd.Parameters.AddWithValue("@ClosedProfit", model.ClosedProfit);
cmd.Parameters.AddWithValue("@Commission", model.Commission);
cmd.Parameters.AddWithValue("@CustomerRights", model.CustomerRights);
cmd.Parameters.AddWithValue("@Date", model.Date);
cmd.Parameters.AddWithValue("@FloatingProfit", model.FloatingProfit);
cmd.Parameters.AddWithValue("@FreeMargin", model.FreeMargin);
cmd.Parameters.AddWithValue("@Id", model.Id.ToString());
cmd.Parameters.AddWithValue("@Margin", model.Margin);
cmd.Parameters.AddWithValue("@MatterDeposit", model.MatterDeposit);
cmd.Parameters.AddWithValue("@Remittance", model.Remittance);
cmd.Parameters.AddWithValue("@SettlementType", model.SettlementType);
cmd.Parameters.AddWithValue("@TodayBalance", model.TodayBalance);
cmd.Parameters.AddWithValue("@VentureFactor", model.VentureFactor);
cmd.Parameters.AddWithValue("@YesterdayBalance", model.YesterdayBalance);
cmds.Add(cmd);
}
public List <FundStatus> GetFundStatus()
{
List <FundStatus> result = new List <FundStatus>();
SQLiteConnection conn = null;
try
{
conn = new SQLiteConnection(connectionStr);
conn.Open();
string sql = string.Format("SELECT * FROM FundStatus");
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
FundStatus model = new FundStatus();
model.Id = Guid.Parse(reader.GetString(0));
model.Date = reader.GetDateTime(1);
model.YesterdayBalance = reader.GetDecimal(2);
model.CustomerRights = reader.GetDecimal(3);
model.Remittance = reader.GetDecimal(4);
model.MatterDeposit = reader.GetDecimal(5);
model.ClosedProfit = reader.GetDecimal(6);
model.Margin = reader.GetDecimal(7);
model.Commission = reader.GetDecimal(8);
model.FreeMargin = reader.GetDecimal(9);
model.TodayBalance = reader.GetDecimal(10);
model.VentureFactor = reader.GetDouble(11);
model.FloatingProfit = reader.GetDecimal(12);
model.AdditionalMargin = reader.GetDecimal(13);
model.SettlementType = (SettlementType)reader.GetInt32(14);
model.AccountId = Guid.Parse(reader.GetString(15));
result.Add(model);
}
conn.Close();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(result);
}
public void Dispose()
{
if (Commoditys != null)
{
Commoditys.Clear();
}
if (Users != null)
{
Users.Clear();
}
if (Accounts != null)
{
Accounts.Clear();
}
if (ClosedTradeDetails != null)
{
ClosedTradeDetails.Clear();
}
if (CommoditySummarizations != null)
{
CommoditySummarizations.Clear();
}
if (FundStatus != null)
{
FundStatus.Clear();
}
if (Parameters != null)
{
Parameters.Clear();
}
if (PositionDetails != null)
{
PositionDetails.Clear();
}
if (Positions != null)
{
Positions.Clear();
}
if (Remittances != null)
{
Remittances.Clear();
}
if (Stocks != null)
{
Stocks.Clear();
}
if (TradeDetails != null)
{
TradeDetails.Clear();
}
if (Trades != null)
{
Trades.Clear();
}
Commoditys = null;
Users = null;
Accounts = null;
ClosedTradeDetails = null;
CommoditySummarizations = null;
FundStatus = null;
Parameters = null;
PositionDetails = null;
Positions = null;
Remittances = null;
Stocks = null;
TradeDetails = null;
Trades = null;
}
public void Delete(DateTime dateTime, Guid accountId, params Type[] types)
{
foreach (var type in types)
{
SQLiteCommand cmd = null;
if (type == typeof(Commodity))
{
continue;
}
else if (type == typeof(User))
{
continue;
}
else if (type == typeof(Account))
{
continue;
}
else if (type == typeof(ClosedTradeDetail))
{
string sql = "DELETE FROM ClosedTradeDetail WHERE AccountId=@AccountId AND ActualDate>=@Date";
cmd = new SQLiteCommand(sql);
ClosedTradeDetails.RemoveAll(m => m.AccountId == accountId && m.ActualDate >= dateTime.Date);
}
else if (type == typeof(CommoditySummarization))
{
string sql = "DELETE FROM CommoditySummarization WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
CommoditySummarizations.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(FundStatus))
{
string sql = "DELETE FROM FundStatus WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
FundStatus.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(Parameter))
{
continue;
}
else if (type == typeof(PositionDetail))
{
string sql = "DELETE FROM PositionDetail WHERE AccountId=@AccountId AND DateForPosition>=@Date";
cmd = new SQLiteCommand(sql);
PositionDetails.RemoveAll(m => m.AccountId == accountId && m.DateForPosition >= dateTime.Date);
}
else if (type == typeof(Position))
{
string sql = "DELETE FROM Position WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Positions.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(Remittance))
{
string sql = "DELETE FROM Remittance WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Remittances.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(Stock))
{
string sql = "DELETE FROM Stock WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Stocks.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(TradeDetail))
{
string sql = "DELETE FROM TradeDetail WHERE AccountId=@AccountId AND ActualTime>=@Date";
cmd = new SQLiteCommand(sql);
TradeDetails.RemoveAll(m => m.AccountId == accountId && m.ActualTime >= dateTime.Date);
}
else if (type == typeof(Trade))
{
string sql = "DELETE FROM Trade WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Trades.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else
{
continue;
}
cmd.Parameters.AddWithValue("@AccountId", accountId.ToString());
cmd.Parameters.AddWithValue("@Date", dateTime.Date);
cmds.Add(cmd);
}
}
