public void Save(MySqlConnection conn, JObject jObject)
{
Dictionary <string, string> selectWhere = new Dictionary <string, string>();
selectWhere.Add("addr", SpiderHelper.getString(jObject["address"].ToString()));
DataTable dt = MysqlConn.ExecuteDataSet(DataTableName, selectWhere).Tables[0];
if (dt.Rows.Count != 0)
{
Dictionary <string, string> dirs = new Dictionary <string, string>();
dirs.Add("lasttxid", jObject["txid"].ToString());
dirs.Add("txcount", (int.Parse(dt.Rows[0]["txcount"].ToString()) + 1) + "");
Dictionary <string, string> where = new Dictionary <string, string>();
where.Add("addr", dt.Rows[0]["addr"].ToString());
MysqlConn.Update(conn, DataTableName, dirs, where);
}
else
{
List <string> slist = new List <string>();
slist.Add(SpiderHelper.getString(jObject["address"].ToString()));
slist.Add(jObject["txid"].ToString());
slist.Add(jObject["txid"].ToString());
slist.Add("1");
MysqlConn.ExecuteDataInsert(conn, DataTableName, slist);
}
}
public void ChangeUTXO(MySqlConnection conn, string txid, string voutNum, uint blockHeight)
{
Dictionary <string, string> dirs = new Dictionary <string, string>();
dirs.Add("used", "1");
dirs.Add("useHeight", blockHeight.ToString());
Dictionary <string, string> where = new Dictionary <string, string>();
where.Add("txid", txid);
where.Add("n", voutNum);
MysqlConn.Update(conn, DataTableName, dirs, where);
//JObject result = JObject.Parse(File.ReadAllText(path, Encoding.UTF8));
//result["used"] = 1;
//result["useHeight"] = Helper.blockHeight;
//File.WriteAllText(path, result.ToString(), Encoding.UTF8);
}
public void Save(MySqlConnection conn, string chainHash, string height)
{
var dir = new Dictionary <string, string>();
dir.Add("chainhash", chainHash);
DataTable dt = MysqlConn.ExecuteDataSet(DataTableName, dir).Tables[0];
if (dt.Rows.Count == 0)
{
var list = new List <string>();
list.Add(chainHash);
list.Add(height);
MysqlConn.ExecuteDataInsert(conn, DataTableName, list);
}
else
{
var set = new Dictionary <string, string>();
set.Add("chainheight", height);
MysqlConn.Update(conn, DataTableName, set, dir);
}
}
