public void Insert()
{
var client = new RestClient();
var request = new RestRequest(fundcode_url);
var response = client.Get(request);
var content = response.Content;
content = content.Replace("var r = ", "").Replace(";", "").Replace("\"", "");
content = content.Substring(2, content.Length - 3);
var arr1 = content.Split("],[");
if (dapperHelper.Get <FundCode>(@"SELECT * FROM fund_code") == null)
{
foreach (var item in arr1)
{
var arr2 = item.Split(',');
var fundCode = new FundCode
{
Code = arr2[0],
PinYin = arr2[1],
Name = arr2[2],
Type = arr2[3],
Extend1 = arr2[4]
};
dapperHelper.Insert(fundCode);
}
dapperHelper.CloseDbConnection();
}
}
/// <summary>
/// Initializes a new instance of the <see cref = "Fund"/> class.
/// </summary>
/// <param name = "fundcode" >
/// The fundcode.
/// </param>
public Fund(FundCode fundcode)
{
Record = new DataBuilder(Source, GetArgs(fundcode))?.GetRecord();
ID = new Key(Record, PrimaryKey.FundId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Title = new Element(Record, Field.Title);
TreasurySymbol = new Element(Record, Field.TreasurySymbol);
Data = Record?.ToDictionary();
}
