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); } }