public bool ReloadBlance()
{
var depth = client.GetUserInfo();
var tables = new List <BalanceTable>();
var account = new AccountDao().Select()
.Find(a => a.Default > 0 || a.Platform.ID == platform.ID);
string uid = account.UID;
var balances = depth["balances"] as JObject;
var reserved = depth["reserved"] as JObject;
foreach (var item in balances)
{
BalanceTable balance = new BalanceTable()
{
UID = uid,
Coin = item.Key,
Platform = this.platform,
Amount = double.Parse(item.Value.ToString())
};
if (reserved[item.Key].HasValues)
{
balance.Amount += double.Parse(reserved[item.Key].ToString());
}
tables.Add(balance);
}
var dao = new BalanceDao();
dao.InsertOrUpdate(tables);
return(true);
}
/// <summary>
/// BalanceTable
/// </summary>
/// <param name="BalanceTable">BalanceTable实体对象</param>
/// <returns>状态代码</returns>
public int Delete(BalanceTable obj)
{
try
{
string sql = "delete from Balance where id=@ID";
using (SQLiteCommand cmd = new SQLiteCommand(sql))
{
cmd.Parameters.AddWithValue("@ID", obj.ID);
return(SQLiteHelper.SQLiteHelper.ExecuteNonQuery(conStr, cmd));
}
}
catch (Exception ex)
{
throw new Exception("调用BalanceTable 时，访问Delete时出错", ex);
}
}
/// <summary>
/// BalanceTable
/// </summary>
/// <param name="BalanceTable">BalanceTable实体对象</param>
public void Insert(BalanceTable obj)
{
try
{
string sql = "insert into Balance(UID,PlatformID, Coin, Amount,CreateTime,LastChangeTime) values(@UID,@PlatformID,@Coin, @Amount,datetime('now', 'localtime'),datetime('now', 'localtime'))";
using (SQLiteCommand cmd = new SQLiteCommand(sql))
{
cmd.Parameters.AddWithValue("@UID", obj.UID);
cmd.Parameters.AddWithValue("@PlatformID", obj.Platform.ID);
cmd.Parameters.AddWithValue("@Coin", obj.Coin);
cmd.Parameters.AddWithValue("@Amount", obj.Amount);
SQLiteHelper.SQLiteHelper.ExecuteNonQuery(conStr, cmd);
}
}
catch (Exception ex)
{
throw new Exception("调用BalanceTable时，访问Insert时出错", ex);
}
}
public bool ReloadBlance()
{
var account = new AccountDao().Select()
.Find(a => a.Default > 0 || a.Platform.ID == platform.ID);
string uid = account.UID;
var depth = client.GetBalance();
var balances = new List <BalanceTable>();
var res = depth["result"] as JsonObject;
foreach (var item in res)
{
string coin = item.Name.Replace("XBT", "BTC");
if (coin.StartsWith("X"))
{
coin = coin.Substring(1);
}
if (coin.StartsWith("Z"))
{
coin = coin.Substring(1);
}
BalanceTable balance = new BalanceTable()
{
UID = uid,
Coin = coin,
Platform = this.platform,
Amount = double.Parse(item.Value.ToString())
};
balances.Add(balance);
}
var dao = new BalanceDao();
dao.InsertOrUpdate(balances);
return(true);
}
/// <summary>
/// 修改BalanceTable
/// </summary>
/// <param name="BalanceTable">BalanceTable实体对象</param>
/// <returns>状态代码</returns>
public int Update(BalanceTable obj)
{
try
{
string sql = "UPDATE Balance set UID=@UID,PlatformID=@PlatformID, Coin=@Coin, Amount=@Amount,LastChangeTime=datetime('now', 'localtime') where id=@ID";
using (SQLiteCommand cmd = new SQLiteCommand(sql))
{
cmd.Parameters.AddWithValue("@ID", obj.ID);
cmd.Parameters.AddWithValue("@UID", obj.UID);
cmd.Parameters.AddWithValue("@PlatformID", obj.Platform.ID);
cmd.Parameters.AddWithValue("@Coin", obj.Coin);
cmd.Parameters.AddWithValue("@Amount", obj.Amount);
return(SQLiteHelper.SQLiteHelper.ExecuteNonQuery(conStr, cmd));
}
}
catch (Exception ex)
{
throw new Exception("调用BalanceTable时，访问Update时出错", ex);
}
}
void ReleaseDesignerOutlets()
{
if (ActionsColumn != null)
{
ActionsColumn.Dispose();
ActionsColumn = null;
}
if (AmountColumn != null)
{
AmountColumn.Dispose();
AmountColumn = null;
}
if (AmountForm != null)
{
AmountForm.Dispose();
AmountForm = null;
}
if (BalanceTable != null)
{
BalanceTable.Dispose();
BalanceTable = null;
}
if (DateColumn != null)
{
DateColumn.Dispose();
DateColumn = null;
}
if (DateForm != null)
{
DateForm.Dispose();
DateForm = null;
}
if (DescColumn != null)
{
DescColumn.Dispose();
DescColumn = null;
}
if (DescForm != null)
{
DescForm.Dispose();
DescForm = null;
}
if (InitialLabel != null)
{
InitialLabel.Dispose();
InitialLabel = null;
}
if (TotalLabel != null)
{
TotalLabel.Dispose();
TotalLabel = null;
}
}
public void ReloadTable()
{
BalanceTable.ReloadData();
PopulateTable();
}
