private void init() { string filename = config["TaskConfig"][name()].ToString(); subConfig = JObject.Parse(File.ReadAllText(filename)); // DB连接信息 string startNetType = subConfig["netType"].ToString(); var connInfo = subConfig["connList"].Children().Where(p => p["netType"].ToString() == startNetType).First(); remoteDbConnInfo = getDbConnInfo(connInfo, true); localDbConnInfo = getDbConnInfo(connInfo, false); // 合约与集合关系 JArray collList = (JArray)config["collList"]; collDict = collList.SelectMany(p => { string contractColl = Convert.ToString(p["contractColl"]); return(p["contractHash"].Select(pItem => { JObject pItemNew = (JObject)pItem; pItemNew.Add("contractColl", contractColl); return pItemNew; }).ToList()); }).ToDictionary(itemKey => Convert.ToString(itemKey["name"]), itemVal => itemVal); // 高度记录表对应关系 JObject recordMap = (JObject)subConfig["heightMap"]; remoteColl = recordMap["remoteColl"].ToString(); localColl = recordMap["localColl"].ToString(); }
public override void initConfig(JObject config) { string filename = config["TaskConfig"][name()].ToString(); JObject subConfig = JObject.Parse(File.ReadAllText(filename)); if (subConfig["taskNet"].ToString() != networkType()) { throw new Exception("NotFindConfig"); } structDict = ((JArray)subConfig["taskList"]).Where(p => p["netType"].ToString() == networkType()).ToDictionary( k => getKey(k["contractHash"].ToString(), k["notifyDisplayName"].ToString()), v => (JArray)v["notifyStructure"]); notifyCounterColl = subConfig["notifyCounterColl"].ToString(); notifyColl = subConfig["notifyColl"].ToString(); contractCounterColl = subConfig["contractCounterColl"].ToString(); batchSize = int.Parse(subConfig["batchSize"].ToString()); batchInterval = int.Parse(subConfig["batchInterval"].ToString()); assetColl = subConfig["assetColl"].ToString(); assetids = ((JArray)subConfig["assetids"]).Select(p => p.ToString()).ToArray(); // db info localConn = Config.localDbConnInfo; remoteConn = Config.blockDbConnInfo; blockConn = Config.blockDbConnInfo; // initAssetPricision(); initSuccFlag = true; }
private void updateData(DbConnInfo conn, string coll, JObject Jdata, string Jcondition) { updateData(conn, coll, new JObject() { { "$set", Jdata } }.ToString(), Jcondition); }
public override void initConfig(JObject config) { rConn = Config.remoteDbConnInfo; lConn = Config.localDbConnInfo; initIndex(); }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); daoConn = Config.daoDbConnInfo; }
public override void initConfig(JObject config) { /// 个人可用代币 = 预留已解锁的 + onBuy - onSell - onVote(投票) + onVote(正常结束/取消/终止) /// 个人锁定代币 = 预留未解锁的 + onVote(投票) /// 个人代币余额 = 可用 + 锁定 daoConn = Config.daoDbConnInfo; }
public override void initConfig(JObject config) { nelApiUrl = Config.nelApiUrl; remoteConn = Config.analyDbConnInfo; localConn = Config.localDbConnInfo; blockConn = Config.blockDbConnInfo; hasInitSuccess = true; }
private int getLocalContractStorageHeight(DbConnInfo conn, string coll, string filter) { JArray res = getData(conn, coll, filter); if (res == null || res.Count == 0) { return(0); } return(int.Parse(Convert.ToString(res[0]["lastBlockindex"]))); }
public async Task <IActionResult> CreateDBConn(DbConnInfo dbConnInfo) { CommonResult result = new CommonResult(); DBConnResult dBConnResult = new DBConnResult(); if (dbConnInfo != null) { if (string.IsNullOrEmpty(dbConnInfo.DbName)) { dbConnInfo.DbName = "master"; } else if (string.IsNullOrEmpty(dbConnInfo.DbAddress)) { result.ErrMsg = "访问地址不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbUserName)) { result.ErrMsg = "访问用户不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbPassword)) { result.ErrMsg = "访问密码不能为空"; } if (string.IsNullOrEmpty(dbConnInfo.DbPort.ToString())) { if (dbConnInfo.DbType == "SqlServer") { dbConnInfo.DbPort = 1433; } else if (dbConnInfo.DbType == "MySql") { dbConnInfo.DbPort = 3306; } } if (dbConnInfo.DbType == "SqlServer") { dBConnResult.ConnStr = string.Format("Server={0},{1};Database={2};User id={3}; password={4};MultipleActiveResultSets=True;", dbConnInfo.DbAddress, dbConnInfo.DbPort, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword); } else if (dbConnInfo.DbType == "MySql") { dBConnResult.ConnStr = string.Format("server={0};database={1};uid={2}; pwd={3};port={4};Allow User Variables=True;", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword, dbConnInfo.DbPort); } YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now; yuebonCacheHelper.Add("CodeGeneratorDbConn", dBConnResult.ConnStr, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbType", dbConnInfo.DbType, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbName", dbConnInfo.DbName, expiresSliding, false); DbExtractor dbExtractor = new DbExtractor(); List <DataBaseInfo> listTable = dbExtractor.GetAllDataBases(); result.ResData = listTable; result.Success = true; result.ErrCode = ErrCode.successCode; } return(ToJsonContent(result)); }
public override void initConfig(JObject config) { rConn = Config.remoteDbConnInfo; lConn = Config.localDbConnInfo; //addPrefix(); initIndex(); // 追赶线程 System.Threading.Tasks.Task.Run(SyncTask); }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; //remoteRecord = cfg["remoteRecordCol"].ToString(); //remoteState = cfg["remoteStateCol"].ToString(); batchInterval = int.Parse(cfg["batchInterval"].ToString()); remoteConn = Config.notifyDbConnInfo; localConn = Config.notifyDbConnInfo; initSuccFlag = true; }
public override void initConfig(JObject config) { lConn = Config.daoDbConnInfo; netType = Config.getNetType(); // if (netType == "testnet") { votingPeriod = 120 * 5; // tmp notingPeriod = 120 * 5; } initIndex(); }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; dexNotifyCollectStateCol = cfg["dexNotifyCollectStateCol"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); // initEmailConfig(cfg["email"]); localConn = Config.localDbConnInfo; initSuccFlag = true; }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; cgasRefundCol = cfg["cgasRefundCol"].ToString(); cgasRefundCounterCol = cfg["cgasRefundCounterCol"].ToString(); cgasUtxoCol = cfg["cgasUtxoCol"].ToString(); cgasUtxoCounterCol = cfg["cgasUtxoCounterCol"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); // localConn = Config.localDbConnInfo; remoteConn = Config.notifyDbConnInfo; hasInitSuccess = true; }
private void initConfig() { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name()).ToArray()[0]["taskInfo"]; auctionStateColl = cfg["auctionStateColl"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); root = cfg["root"].ToString(); timeSetter = TimeConst.getTimeSetter(root); // db info localDbConnInfo = Config.localDbConnInfo; blockDbConnInfo = Config.blockDbConnInfo; // initSuccFlag = true; }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; remoteConnRecordCol = cfg["remoteConnRecordCol"].ToString(); remoteConnStateCol = cfg["remoteConnStateCol"].ToString(); dexBalanceRecordCol = cfg["dexBalanceRecordCol"].ToString(); dexBalanceStateCol = cfg["dexBalanceStateCol"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); // localConn = Config.localDbConnInfo; remoteConn = Config.remoteDbConnInfo; blockConn = Config.blockDbConnInfo; initSuccFlag = true; }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; contractRecordCol = cfg["contractRecordCol"].ToString(); cgasBalanceRecordCol = cfg["cgasBalanceRecordCol"].ToString(); cgasBalanceStateCol = cfg["cgasBalanceStateCol"].ToString(); registerHashArr = ((JArray)cfg["registerHashArr"]).Select(p => p.ToString()).ToArray(); cgasHash = cfg["cgasHash"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); registerAddrDict = toAddress(registerHashArr); registerAddrArr = registerAddrDict.Keys.ToArray(); sgasFilter = new JObject() { { "$or", merge(new string[] { "to", "from" }, registerAddrArr) } }; localConn = Config.localDbConnInfo; remoteConn = Config.notifyDbConnInfo; initSuccFlag = true; }
public override void initConfig(JObject config) { JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); emailRegisterUrl = cfg["verifyModule"]["registerUrl"].ToString(); emailResetPswdUrl = cfg["verifyModule"]["resetPswdUrl"].ToString(); emailChangeMailUrl = cfg["verifyModule"]["changeEmailUrl"].ToString(); emailInviteUserUrl = cfg["verifyModule"]["inviteUserUrl"].ToString(); emailRegisterBody = cfg["verifyModule"]["registerBody"].ToString(); emailResetPswdBody = cfg["verifyModule"]["resetPswdBody"].ToString(); emailChangeMailBody = cfg["verifyModule"]["changeEmailBody"].ToString(); emailInviteUserBody = cfg["verifyModule"]["inviteUserBody"].ToString(); eh = new EmailHelper { config = Config.emailInfo }; daoConn = Config.daoDbConnInfo; }
public override void initConfig(JObject config) { //JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name()).ToArray()[0]["taskInfo"]; JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; auctionRecordColl = cfg["auctionRecordColl"].ToString(); auctionStateColl = cfg["auctionStateColl"].ToString(); notifyRecordColl = cfg["notifyRecordColl"].ToString(); notifyDomainSellColl = cfg["notifyDomainSellColl"].ToString(); notifyDomainCenterColl = cfg["notifyDomainCenterColl"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); bonusAddress = cfg["bonusAddress"].ToString(); // db info localDbConnInfo = Config.localDbConnInfo; remoteDbConnInfo = Config.notifyDbConnInfo; blockDbConnInfo = Config.blockDbConnInfo; initSuccFlag = true; }
public async Task <IActionResult> ConnStrEncrypt([FromQuery] DbConnInfo dbConnInfo) { CommonResult result = new CommonResult(); DBConnResult dBConnResult = new DBConnResult(); if (dbConnInfo != null) { if (string.IsNullOrEmpty(dbConnInfo.DbName)) { result.ErrMsg = "数据库名称不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbAddress)) { result.ErrMsg = "访问地址不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbUserName)) { result.ErrMsg = "访问用户不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbPassword)) { result.ErrMsg = "访问密码不能为空"; } if (dbConnInfo.DbType == "SqlServer") { dBConnResult.ConnStr = string.Format("Server={0};Database={1};User id={2}; password={3};MultipleActiveResultSets=True;", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword); dBConnResult.EncryptConnStr = DEncrypt.Encrypt(dBConnResult.ConnStr); result.Success = true; result.ErrCode = ErrCode.successCode; } else if (dbConnInfo.DbType == "MySql") { dBConnResult.ConnStr = string.Format("server={0};database={1};uid={2}; pwd={3};", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword); dBConnResult.EncryptConnStr = DEncrypt.Encrypt(dBConnResult.ConnStr); result.Success = true; result.ErrCode = ErrCode.successCode; } result.ResData = dBConnResult; } return(ToJsonContent(result)); }
public override void initConfig(JObject config) { //JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name()).ToArray()[0]["taskInfo"]; JToken cfg = config["TaskList"].Where(p => p["taskName"].ToString() == name() && p["taskNet"].ToString() == networkType()).ToArray()[0]["taskInfo"]; notifyRecordColl = cfg["notifyRecordColl"].ToString(); domainCenterCol = cfg["domainCenterCol"].ToString(); domainResolverCol = cfg["domainResolverCol"].ToString(); domainFixedSellingCol = cfg["domainFixedSellingCol"].ToString(); domainCreditCol = cfg["domainCreditCol"].ToString(); domainRecord = cfg["domainRecord"].ToString(); domainOwnerCol = cfg["domainOwnerCol"].ToString(); nnsSellingAddr = cfg["nnsSellingAddr"].ToString(); dexContractHash = cfg["dexContractHash"].ToString(); dexSellingAddr = cfg["dexSellingAddr"].ToString(); batchSize = int.Parse(cfg["batchSize"].ToString()); batchInterval = int.Parse(cfg["batchInterval"].ToString()); // db info localConn = Config.localDbConnInfo; remoteConn = Config.notifyDbConnInfo; blockConn = Config.blockDbConnInfo; initSuccFlag = true; }
private JArray getDataWithField(DbConnInfo db, string coll, string fieldBson, string findBson) { return(mh.GetDataWithField(db.connStr, db.connDB, coll, fieldBson, findBson)); }
private JArray getData(DbConnInfo conn, string coll, string filter = "{}") { return(mh.GetData(conn.connStr, conn.connDB, coll, filter)); }
public override void initConfig(JObject config) { lConn = Config.daoDbConnInfo; }
private void PutData(DbConnInfo conn, string coll, JArray Jdata) { mh.PutData(conn.connStr, conn.connDB, coll, Jdata); }
public override void initConfig(JObject config) { daoConn = Config.localDbConnInfo; // initIndex(); }
private void UpdateData(DbConnInfo conn, string coll, string Jdata, string Jcondition) { mh.UpdateData(conn.connStr, conn.connDB, coll, Jdata, Jcondition); }
private void replaceData(DbConnInfo db, string coll, string data, string condition) { mh.ReplaceData(db.connStr, db.connDB, coll, data, condition); }
private void ReplaceData(DbConnInfo conn, string coll, JObject Jdata, JObject Jcondition) { mh.ReplaceData(conn.connStr, conn.connDB, coll, Jdata, Jcondition); }
private long getDataCount(DbConnInfo db, string coll, string filter) { return(mh.GetDataCount(db.connStr, db.connDB, coll, filter)); }