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