public Miners GetMinerById(long id)
{
MinersDac dac = new MinersDac();
return(dac.SelectById(id));
}
/// <summary>
/// 矿工注册
/// </summary>
/// <param name="address"></param>
/// <param name="account"></param>
/// <param name="sn"></param>
/// <returns></returns>
public Miners RegisterMiner(string address, string account, string sn)
{
MinersDac dac = new MinersDac();
Miners miner = new Miners();
//验证address是否合法
//try
//{
// bool isValid = AccountIdHelper.AddressVerify(address);
// if (!isValid)
// {
// throw new ApiCustomException(MiningPoolErrorCode.Miners.ADDRESS_IS_INVALID, "address is invalid");
// }
//}
//catch
//{
// throw new ApiCustomException(MiningPoolErrorCode.Miners.ADDRESS_IS_INVALID, "address is invalid");
//}
//先判断SN和Account的合法性
string url = MiningPoolSetting.POS_URL + "Api/Account/CheckAccount";
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("MerchantId", account);
dic.Add("SN", sn);
string response = ApiHelper.PostApi(url, dic);
Dictionary <string, string> returnDic = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, string> >(response);
if (string.IsNullOrEmpty(returnDic["Data"]))
{
throw new ApiCustomException(Int32.Parse(returnDic["Code"]), returnDic["Message"]);
}
/* 四种情况
* 1、地址、SN、Account都不存在直接插入
* 2、地址不存在，SN、Account存在，修改存在数据状态，插入数据
* 3、地址存在，SN、Account不存在,抛出地址被占用
* 4、地址存在，SN、Account存在，Status为1，将Status为0的设置为1，将Status为1的设置为0
* 5、地址存在、SN、Account存在，Status为0， 直接返回这条记录
* 6、地址存在，SN和Account不匹配，会更新
*/
//自旋锁 SpinLock
bool lockTaken = false;
try
{
//申请获取锁
spin.Enter(ref lockTaken);
if (dac.IsAddressExisted(address.Trim()))
{
//地址存在，
Miners existMiner = dac.GetMinerByAddress(address.Trim());
//先判断地址的状态
if (existMiner.Status == 0)
{
//判断绑定的SN与传入的是否匹配
if (existMiner.SN == sn)
{
dac.UpdateStatus(existMiner.Id, 0, account, sn, Framework.Time.EpochTime);
return(dac.SelectById(existMiner.Id));
}
else
{
//判断旧的的是否匹配
Dictionary <string, string> oldDic = new Dictionary <string, string>();
oldDic.Add("MerchantId", existMiner.Account);
oldDic.Add("SN", existMiner.SN);
string oldResponse = ApiHelper.PostApi(url, oldDic);
Dictionary <string, string> returnOldDic = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, string> >(oldResponse);
if (string.IsNullOrEmpty(returnOldDic["Data"]))
{
//更新Miners表
dac.UpdateStatus(existMiner.Id, 0, account, sn, Framework.Time.EpochTime);
return(dac.SelectById(existMiner.Id));
}
else
{
throw new ApiCustomException(MiningPoolErrorCode.Miners.SN_IS_NOT_MATCH_BIND_ADDRESS_SN, $"{existMiner.SN}");
}
}
}
else
{
dac.UpdateStatus(existMiner.Id, 0, account, sn, Framework.Time.EpochTime);
return(dac.SelectById(existMiner.Id));
}
}
else
{
//地址不存在
//判断数据库中是否存在SN，如果存在SN，先修改address和SN的状态
if (returnDic["Data"] == "true")
{
if (dac.IsSNExisted(sn))
{
dac.UpdateStatus(1, sn);
}
}
else
{
throw new ApiCustomException(int.Parse(returnDic["Code"]), returnDic["Message"]);
}
miner.Address = address;
miner.LastLoginTime = Framework.Time.EpochTime;
miner.Account = account;
miner.SN = sn;
miner.Status = 0;
miner.Timstamp = Framework.Time.EpochTime;
miner.Type = 0;
dac.Insert(miner);
}
}
//catch(Exception ex)
//{
// Console.WriteLine(ex.ToString());
//}
finally
{
//工作完毕，或者发生异常时，检测一下当前线程是否占有锁，如果咱有了锁释放它
//以避免出现死锁的情况
if (lockTaken)
{
spin.Exit();
}
}
return(miner);
}
