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