/// <summary>
/// 通过地址编号获取地址信息
/// </summary>
/// <param name="addr_id">地址编号</param>
/// <returns></returns>
public ReceiveAddress getReceiveAddress(int addr_id)
{
ReceiveAddress recAddr = new ReceiveAddress();
SqlConnection conn = DBConn.getConn();
string sql = "select * from tb_receiverAddress where addr_id=" + addr_id;
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
//一个会员可能多个收件人地址信息
if (dt.Rows.Count > 0)
{
recAddr.Addr_id = Convert.ToInt32(dt.Rows[0][0].ToString());
recAddr.Name = dt.Rows[0][1].ToString();
recAddr.Receiver_name = dt.Rows[0][2].ToString();
recAddr.Country = dt.Rows[0][3].ToString();
recAddr.Province = dt.Rows[0][4].ToString();
recAddr.City = dt.Rows[0][5].ToString();
recAddr.Area = dt.Rows[0][6].ToString();
recAddr.Street_info = dt.Rows[0][7].ToString();
recAddr.Company_name = dt.Rows[0][8].ToString();
recAddr.Postcode = dt.Rows[0][9].ToString();
recAddr.E_mail = dt.Rows[0][10].ToString();
recAddr.Phone = dt.Rows[0][11].ToString();
recAddr.Is_default = dt.Rows[0][12].ToString();
recAddr.Time = Convert.ToDateTime(dt.Rows[0][13].ToString());
}
return(recAddr);
}
/// <summary>
/// 向数据库中添加收件人地址
/// </summary>
/// <param name="receiver">收件人地址对象</param>
/// <returns>添加成功返回true，否则返回false</returns>
public bool addReceiverAddress(ReceiveAddress receive)
{
bool flag = false;
SqlConnection conn = DBConn.getConn();
string sql_insert = "insert into tb_receiverAddress values('" + receive.Name + "','" + receive.Receiver_name + "','" + receive.Country + "','" +
receive.Province + "','" + receive.City + "','" + receive.Area + "','" + receive.Street_info + "','" + receive.Company_name + "','" +
receive.Postcode + "','" + receive.Phone + "','" + receive.E_mail + "','" + receive.Is_default + "','" + receive.Time + "')";
conn.Open();
if (receive.Is_default == "1")
{
string sql_update = "update tb_receiverAddress set is_default='0' where name='" + receive.Name + "'";
//跟新默认地址
SqlCommand cmd1 = new SqlCommand(sql_update, conn);
cmd1.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand(sql_insert, conn);
if (cmd.ExecuteNonQuery() > 0)
{
flag = true;
}
conn.Close();
return(flag);
}
/// <summary>
/// 修改收件人地址信息
/// </summary>
/// <param name="receiver">收件人地址对象</param>
/// <returns>修改成功返回true ， 否则返回false</returns>
public bool updateReceiveAddress(int addr_id, ReceiveAddress receive)
{
bool flag = false;
SqlConnection conn = DBConn.getConn();
string sql = "update tb_receiverAddress set receiver_name='" + receive.Receiver_name + "',country='" + receive.Country + "',province='" + receive.Province
+ "',city='" + receive.City + "',area='" + receive.Area + "',street_info='" + receive.Street_info + "',company_name='" + receive.Company_name
+ "',postcode='" + receive.Postcode + "',phone='" + receive.Phone + "',e_mail='" + receive.E_mail + "',is_default='" + receive.Is_default + "',last_use_time='" + receive.Time + "' where addr_id=" + addr_id;
conn.Open();
if (receive.Is_default == "1")
{
string sql_update = "update tb_receiverAddress set is_default='0' where name='" + receive.Name + "'";
//跟新默认地址
SqlCommand cmd1 = new SqlCommand(sql_update, conn);
cmd1.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand(sql, conn);
if (cmd.ExecuteNonQuery() > 0)
{
flag = true;
}
conn.Close();
return(flag);
}
public string ToJsonHex()
{
var s = "['{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}']";
return(string.Format(s, Nonce.ToHex(),
GasPrice.ToHex(), GasLimit.ToHex(), ReceiveAddress.ToHex(), Value.ToHex(), ToHex(Data),
Signature.V.ToHex(),
Signature.R.ToHex(),
Signature.S.ToHex()));
}
public static void TestGenerateReceiveAddress()
{
Console.Write("Testing GetReceiveAddress w/ Valid Key: ");
ReceiveAddress addr = API.GenerateReceiveAddress(GOOD_KEY);
ASSERT(addr.IsValid, addr);
Console.Write("Testing GetReceiveAddress w/ Invalid Key: ");
addr = API.GetReceiveAddress(BAD_KEY);
ASSERT(!addr.IsValid, addr);
}
public string ToJsonHex()
{
var data =
$"['{Nonce.ToHex()}','{GasPrice.ToHex()}','{GasLimit.ToHex()}','{ReceiveAddress.ToHex()}','{Value.ToHex()}','{ToHex(Data)}','{ChainId.ToHex()}','{RHash.ToHex()}','{SHash.ToHex()}'";
if (Signature != null)
{
data = data + $", '{Signature.V.ToHex()}', '{Signature.R.ToHex()}', '{Signature.S.ToHex()}'";
}
return(data + "]");
}
/// <summary>
/// 通过收件地址编号获得收件地址信息
/// </summary>
/// <param name="addr_id">收件地址编号</param>
/// <returns></returns>
public string getAddressInfo(int addr_id)
{
string address = "";
ReceiveAddress receive = getReceiveAddress(addr_id);
address = receive.Country + receive.Province + receive.City + receive.Area + receive.Street_info + receive.Company_name;
address += receive.Postcode + "," + receive.Phone + "(" + receive.Receiver_name + "收)";
return(address);
}
static void Main(string[] args)
{
bool b = true;
while (b)
{
Console.WriteLine("开始处理数据");
DateTime pubDate = ParseHelper.ToDatetime(ConfigurationManager.AppSettings["StartTime"]);
ReceiveAddress ra = new ReceiveAddress();
var kk = ra.GetNoReceiveAddress(pubDate);
if (kk.Rows.Count == 0)
{
Console.WriteLine("没有需要处理的数据");
break;
}
else
{
Console.WriteLine("取到" + kk.Rows.Count + "条数据");
StringBuilder upStringBuilder = new StringBuilder();
int noaddres = 0;
for (int i = 0; i < kk.Rows.Count; i++)
{
DataRow dr = kk.Rows[i];
Console.WriteLine("订单Id：" + dr[0].ToString() + " 经度：" + dr[1].ToString() + " 纬度：" + dr[2].ToString());
string addres = ra.GetAddress(dr[1].ToString(), dr[2].ToString());
Console.WriteLine("订单Id：" + dr[0].ToString() + " 地址：" + addres);
if (!string.IsNullOrWhiteSpace(addres) && !addres.StartsWith("0"))
{
Console.WriteLine("更新地址" + "订单Id：" + dr[0].ToString());
ra.CreateAddressSql(ParseHelper.ToInt(dr[0]), addres);
}
else
{
Console.WriteLine("无地址不需要更新");
noaddres++;
}
}
if (noaddres == kk.Rows.Count)
{
Console.WriteLine("剩余数据无法获取地址");
b = false;
}
}
}
Console.WriteLine("完成所有");
Console.Read();
}
/// <summary>
/// 通过会员名 name 获取该会员填写过的所有收件人地址
/// </summary>
/// <param name="name">通过会员名来查找数据库中的表</param>
/// <returns>ArrayList对象 里面放置的是 ReceiverAddress类型对象</returns>
public ArrayList getReceiveAddr(string name)
{
ArrayList arr = new ArrayList();
SqlConnection conn = DBConn.getConn();
string sql = "select * from tb_receiverAddress where name='" + name + "'";
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
//一个会员可能多个收件人地址信息
for (int i = 0; i < dt.Rows.Count; i++)
{
ReceiveAddress recAddr = new ReceiveAddress();
recAddr.Addr_id = Convert.ToInt32(dt.Rows[i][0].ToString());
recAddr.Name = dt.Rows[i][1].ToString();
recAddr.Receiver_name = dt.Rows[i][2].ToString();
recAddr.Country = dt.Rows[i][3].ToString();
recAddr.Province = dt.Rows[i][4].ToString();
recAddr.City = dt.Rows[i][5].ToString();
recAddr.Area = dt.Rows[i][6].ToString();
recAddr.Street_info = dt.Rows[i][7].ToString();
recAddr.Company_name = dt.Rows[i][8].ToString();
recAddr.Postcode = dt.Rows[i][9].ToString();
recAddr.E_mail = dt.Rows[i][10].ToString();
recAddr.Phone = dt.Rows[i][11].ToString();
recAddr.Is_default = dt.Rows[i][12].ToString();
recAddr.Time = Convert.ToDateTime(dt.Rows[i][13].ToString());
arr.Add(recAddr);
}
return(arr);
}
public string ToJsonHex()
{
var data =
"['" + Nonce.ToHex() + "','" + GasPrice.ToHex() + "','" + GasLimit.ToHex() + "','" + ReceiveAddress.ToHex() + "','" + Value.ToHex() + "','" + ToHex(Data) + "','" + ChainId.ToHex() + "','" + RHash.ToHex() + "','" + SHash.ToHex() + "'";
if (Signature != null)
{
data = data + ", '" + Signature.V.ToHex() + "', '" + Signature.R.ToHex() + "', '" + Signature.S.ToHex() + "'";
}
return(data + "]");
}
public static void TestConductTransactions(
APIKey key1,
APIKey key2
)
{
Console.Write("Testing SendMoney w/ Valid Key: ");
ReceiveAddress addr1 = API.GetReceiveAddress(key1);
ReceiveAddress addr2 = API.GetReceiveAddress(key2);
SendMoneyTransaction sendMoney = new SendMoneyTransaction()
{
ToAddr = addr1.Address,
Amount = new Amount()
{
AmountValue = 0.01m, Currency = "BTC"
},
Notes = "Testing send_money"
};
Transaction sendMoneyTransaction = API.SendMoney(
sendMoney,
key2
);
ASSERT(sendMoneyTransaction.IsValid, sendMoneyTransaction);
if (!sendMoneyTransaction.IsValid)
{
return;
}
User user1 = API.GetUser(key1);
if (!user1.IsValid)
{
return;
}
Console.Write("Testing RequestMoney w/ Valid Key: ");
RequestMoneyTransaction requestMoney = new RequestMoneyTransaction()
{
FromAddr = user1.Email,
Amount = new Amount()
{
AmountValue = 0.01m, Currency = "BTC"
},
Notes = "Testing request_money"
};
Transaction requestMoneyTransaction = API.RequestMoney(
requestMoney,
key2
);
ASSERT(requestMoneyTransaction.IsValid, requestMoneyTransaction);
if (!requestMoneyTransaction.IsValid)
{
return;
}
Console.Write("Testing CancelRequest w/ Valid Key: ");
CoinbaseResponse response = API.CancelRequest(requestMoneyTransaction.ID, key1);
ASSERT(response.IsValid, response);
requestMoneyTransaction = API.RequestMoney(
requestMoney,
key2
);
if (!requestMoneyTransaction.IsValid)
{
return;
}
response = API.ResendRequest(requestMoneyTransaction.ID, key2);
Console.Write("Testing ResendRequest w/ Valid Key: ");
ASSERT(response.IsValid, response);
Console.Write("Testing CompleteRequest w/ Valid Key: ");
response = API.CompleteRequest(requestMoneyTransaction.ID, key1);
ASSERT(response.IsValid, response);
}
