public static void Analysis(string content, string date)
{
if ((content.Contains("尾号") || content.Contains("信用卡")) && content.Contains("消费人民币"))
{
string shortNumber = null;
if (content.Contains("民生银行"))
{
shortNumber = content.Substring(content.IndexOf("信用卡") + 3, 4);
}
else
{
shortNumber = content.Substring(content.IndexOf("尾号") + 2, 4);
}
//Console.WriteLine("尾号：{0}", weihao);
string xiaofei = content.Substring(content.IndexOf("消费人民币") + 5);
decimal cost = isnumeric(xiaofei);
string bank = BankName(content);
if (bank != "")
{
//Console.WriteLine("消费金额：{0}", cost);
//Console.WriteLine("银行:{0}", type(content));
var model = new Bill()
{
AddTime = TimeHelper.ConvertStringToDateTime(date),
CostDate = date,
ShortNumber = shortNumber,
BankType = bank,
Money = cost,
Content = content
};
var b = billDAL.Add(model);
if (smsCount <= 10 && b)
{
MessageList.BillList.Insert(0, model);
smsCount++;
}
}
}
else
{
// Console.WriteLine("短信消息没有包含的关键字");
}
}
private void RunTransTimeCommand()
{
MessageBox.Show(TimeHelper.ConvertStringToDateTime("1519893203000").ToString("yyyy-MM-dd"));
}
static void Main(string[] args)
{
Console.WriteLine("Start collect CryptoCurrency market history hour data......");
Console.WriteLine("Please input exchange name:");
string exchangename = Console.ReadLine();
Console.WriteLine("Please input from symbol to collect:");
string fromsymbol = Console.ReadLine().ToUpper();
Console.WriteLine("Please input to symbol to collect:");
string tosymbol = Console.ReadLine().ToUpper();
//Console.WriteLine("Please input to time(gmttimestamp) to collect:");
int maxcount = 167;//每周采集一次
int totalmax = 20000;
int insertnum = 0;
double totime = TimeHelper.GetTimeStamp(DateTime.Now);
string url = @"https://min-api.cryptocompare.com/data/histohour?fsym=" + fromsymbol.ToUpper() + "&tsym=" + tosymbol.ToUpper() + "&limit=" + maxcount.ToString() + "&e=" + exchangename + "&toTs=" + totime.ToString();
//check sql data table
string sqltablename = "His2Hour_" + exchangename + "_" + fromsymbol + tosymbol + "_RAW";
if (CheckDataTableName(sqltablename))
{
//
Console.WriteLine(sqltablename + " exist.start collect......");
}
else
{
Console.WriteLine(sqltablename + " dose not exist.create new table......");
CreatDataTable(sqltablename);
}
bool flag = true;
HttpResult hr = new HttpResult();
HttpHelper hh = new HttpHelper();
HttpItem hi = new HttpItem();
while (flag)
{
try
{
hi.URL = url;
hr = hh.GetHtml(hi);
string rawjson = hr.Html;
JObject jo = JObject.Parse(rawjson);
string response = jo["Response"].ToString();
if (response == "Success")
{
JArray jlist = JArray.Parse(jo["Data"].ToString()); //JArray解析这个JObject的字符串
for (int i = 0; i < jlist.Count; ++i) //遍历JArray
{
JObject tempo = JObject.Parse(jlist[i].ToString());
string sql = "insert into " + sqltablename + " values('" + TimeHelper.ConvertStringToDateTime(tempo["time"].ToString()) + "'," + tempo["close"].ToString() + "," + tempo["high"].ToString() + "," + tempo["open"].ToString() + "," + tempo["low"].ToString() + "," + tempo["volumefrom"].ToString() + "," + tempo["volumeto"].ToString() + ")";
try
{
Console.WriteLine("ts:" + TimeHelper.ConvertStringToDateTime(tempo["time"].ToString()) + "',close:" + tempo["close"].ToString() + ",high:" + tempo["high"].ToString() + ",open:" + tempo["open"].ToString() + ",low:" + tempo["low"].ToString() + ",vf:" + tempo["volumefrom"].ToString() + ",vt:" + tempo["volumeto"].ToString());
SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), System.Data.CommandType.Text, sql);
insertnum++;
if (insertnum >= totalmax)
{
flag = false;
}
}
catch (Exception err)
{
Console.WriteLine(err.Message);
}
}
url = @"https://min-api.cryptocompare.com/data/histohour?fsym=" + fromsymbol.ToUpper() + "&tsym=" + tosymbol.ToUpper() + "&limit=" + maxcount.ToString() + "&e=" + exchangename + "&toTs=" + jo["TimeFrom"].ToString();
}
else
{
Console.WriteLine(rawjson);
}
}
catch
{
}
}
Console.WriteLine("20000 datas collected press any key to exit......");
Console.ReadKey();
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
return(TimeHelper.ConvertStringToDateTime(value.ToString()).ToString());
}
public override Widget build(BuildContext context)
{
var inputController = new TextEditingController();
return(new Column(
children: new List <Widget>()
{
new Padding(
padding: EdgeInsets.only(top: 20)
),
new StoreConnector <TodoListState, object>(
converter: (state => null),
builder: ((buildContext, _, dispatcher) =>
{
return new Flex(
direction: Axis.horizontal,
children: new List <Widget>()
{
new Expanded(
flex: 6,
child: new TextField(
controller: inputController,
decoration: new InputDecoration(hintText: "请输入待办事项"),
onSubmitted: (value =>
{
TodoModel item = new TodoModel(value,
long.Parse(TimeHelper.GetTimeStamp(DateTime.Now)),
false);
Actions.AddAction action = new Actions.AddAction(item);
dispatcher.dispatch(action);
inputController.clear();
}),
onChanged: (value => mCurrentInptu = value)
)
),
new Expanded(
flex: 1,
child: new IconButton(icon: new Icon(Icons.add),
onPressed: (() =>
{
TodoModel item = new TodoModel(mCurrentInptu,
long.Parse(TimeHelper.GetTimeStamp(DateTime.Now)),
false);
Actions.AddAction action = new Actions.AddAction(item);
dispatcher.dispatch(action);
mCurrentInptu = string.Empty;
inputController.clear();
})
)
)
}
);
})
),
new Expanded(
child: new StoreConnector <TodoListState, List <TodoModel> >(
converter: (state =>
{
var showState = state.showState;
var list = state.todoList;
switch (showState)
{
case ShowState.All:
return list;
case ShowState.Finished:
return list.Where((mo => mo.isFinish)).ToList();
case ShowState.UnFinished:
return list.Where((mo => (!mo.isFinish))).ToList();
default:
return list;
}
}),
builder: ((buildContext, model, dispatcher) =>
{
return ListView.seperated(
itemCount: model.Count,
itemBuilder: ((context1, index) =>
{
var item = model[index];
var iconColor = item.isFinish ? Colors.blue : Colors.grey;
return new ListTile(title: new Text(item.content),
subtitle: new Text(TimeHelper.ConvertStringToDateTime(item.timestamp.ToString())
.ToString()),
leading: new IconButton(icon: new Icon(Icons.check), iconSize: 20,
color: iconColor,
onPressed: (() =>
{
dispatcher.dispatch(new Actions.UpdateFinishAction(item));
})),
trailing: new IconButton(icon: new Icon(Icons.delete), iconSize: 20,
onPressed: (() => { dispatcher.dispatch(new Actions.DeleteAction(item)); }))
);
}),
separatorBuilder: ((context1, index) => { return new Divider(color: Colors.blue); })
);
})
)
)
},
mainAxisSize: MainAxisSize.min
));
}
public ActionResult SearchRoute()
{
OTSClient _oTSClient = OTSHelper.GetOTSClientRoute(_tableStoreModel);
PrimaryKey pk = new PrimaryKey();
pk.Add("d", new ColumnValue(Convert.ToInt64(Request.Form["d"])));
pk.Add("s", new ColumnValue(TimeHelper.ConvertDateTimeToInt(Convert.ToDateTime(Request.Form["s"]))));
GetRowRequest getRowRequest = new GetRowRequest("Route", pk);
GetRowResponse response = _oTSClient.GetRow(getRowRequest);
StringBuilder sbAttributeColumns = new StringBuilder();
foreach (var item in response.Attribute)
{
switch (item.Key)
{
case "e":
sbAttributeColumns.Append(item.Key + ":" + item.Value.IntegerValue + "【" + TimeHelper.ConvertStringToDateTime(item.Value.IntegerValue.ToString()).ToString("yyyy-MM-dd HH:mm:ss fff") + "】;");
break;
case "r":
byte[] lbyte = item.Value.BinaryValue;
Dictionary <string, int> dictionary = ByteIntHelper.GetRouteByByte(lbyte);
foreach (var dic in dictionary)
{
sbAttributeColumns.Append(dic.Key + ":" + dic.Value + "； ");
}
break;
case "ds":
byte[] ds = item.Value.BinaryValue;
Dictionary <string, int> dsDic = ByteIntHelper.GetDurationstatsByByte(ds);
foreach (var dic in dsDic)
{
sbAttributeColumns.Append(dic.Key + ":" + dic.Value + "； ");
}
break;
case "es":
byte[] es = item.Value.BinaryValue;
Dictionary <string, int> esDic = ByteIntHelper.GetEventStatsByByte(es);
foreach (var dic in esDic)
{
sbAttributeColumns.Append(dic.Key + ":" + dic.Value + "； ");
}
break;
}
}
ViewData["pk"] = "设备：" + Request.Form["d"] + " 开始时间：" + Request.Form["s"];
ViewData["att"] = sbAttributeColumns.ToString();
return(View("Search", ViewBag));
}
public ActionResult SearchEvent()
{
OTSClient _oTSClient = OTSHelper.GetOTSClientEvent(_tableStoreModel);
PrimaryKey pk = new PrimaryKey();
pk.Add("d", new ColumnValue(Convert.ToInt64(Request.Form["d"])));
pk.Add("et", new ColumnValue(TimeHelper.ConvertDateTimeToInt(Convert.ToDateTime(Request.Form["et"]))));
pk.Add("ei", new ColumnValue(ByteIntHelper.intToBytes2(Convert.ToInt64(Request.Form["ei"]), 1)));
GetRowRequest getRowRequest = new GetRowRequest("E_100000000", pk);
GetRowResponse response = _oTSClient.GetRow(getRowRequest);
StringBuilder sbAttributeColumns = new StringBuilder();
foreach (var item in response.Attribute)
{
switch (item.Key)
{
case "ep":
//事件参数字段暂不做处理
//byte[] ep = item.Value.BinaryValue;
break;
case "t":
sbAttributeColumns.Append(item.Key + ":" + item.Value.IntegerValue + "【" + TimeHelper.ConvertStringToDateTime(item.Value.IntegerValue.ToString()).ToString("yyyy-MM-dd HH:mm:ss fff") + "】；");
break;
case "l":
byte[] lbyte = item.Value.BinaryValue;
Dictionary <string, int> dictionary = ByteIntHelper.GetLocationByByte(lbyte);
foreach (var dic in dictionary)
{
sbAttributeColumns.Append(dic.Key + ":" + dic.Value + "； ");
}
break;
}
}
ViewData["pk"] = "设备：" + Request.Form["d"] + " 事件时间：" + Request.Form["et"] + " 事件ID：" + Request.Form["ei"];
ViewData["att"] = sbAttributeColumns.ToString();
return(View("Search", ViewBag));
}