public IEnumerable <StatusRespondBean> Get() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 0, StatusMessage = "Zxtj开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port mysqlConnCls = Config.MysqlConnCLS; ClsPmzb(); ClsJrht(); ClsRmht(); srb.StatusCode = 1; srb.StatusMessage = "Zxtj已完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> GetAll(string day) { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 1, StatusMessage = "CleanKeyController开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port list = new List <string>(); DateTime timeNow = System.DateTime.Now.AddDays(-20);//删除20天前的数据 string TradeDayNum = timeNow.ToString("yyyyMMdd"); if (!day.Equals("0")) { TradeDayNum = day;//不为0 就按前20天数据删除 } ///主力 Clean_zlcj(TradeDayNum); Clean_zlwt(TradeDayNum); Clean_zljmr(TradeDayNum); //每日个股成交、委托记录 Clean_cjjl(TradeDayNum); Clean_wtjl(TradeDayNum); //每日个股详情 Clean_ggxq(TradeDayNum); ///拖拉机单,闪电单,超级单每日统计记录 Clean_tljd(TradeDayNum); Clean_sdd(TradeDayNum); Clean_cjd(TradeDayNum); //level2 Clean_level2(TradeDayNum); srb.StatusCode = 1; srb.StatusMessage = JsonConvert.SerializeObject(list); } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> GetAll() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 1, StatusMessage = "GgxqController开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port ConnJy = Config.JySqlConn; DateTime timeNow = System.DateTime.Now; string redisTime = timeNow.ToString("yyyy-MM-dd HH:mm"); string TradeDayNum = timeNow.ToString("yyyyMMdd"); string TradeDayStr = timeNow.ToString("yyyy-MM-dd"); //当前日期 string TradeDayStrNow = TradeDayStr; //最近一个交易日 string sql_day = string.Format(@" select top 1 * from QT_TradingDayNew where SecuMarket=83 and TradingDate <= '{0}' and IfTradingDay=1 order by TradingDate desc", TradeDayStr); DataTable dt_day = SqlHelper.ExecuteQuery(sql_day, ConnJy); if (dt_day.Rows.Count > 0) { DateTime dtime = Convert.ToDateTime(dt_day.Rows[0]["TradingDate"]); TradeDayStrNow = dtime.ToString("yyyy-MM-dd"); TradeDayNum = dtime.ToString("yyyyMMdd"); } Ggxq_sdd(TradeDayNum, "sdd", "buy"); Ggxq_cjd(TradeDayNum, "cjd", "buy"); Ggxq_tljd(TradeDayNum, "tljd", "buy"); srb.StatusCode = 1; srb.StatusMessage = "GgxqController执行完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> GetAll() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 1, StatusMessage = "XgsgController开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port ConnJy = Config.JySqlConn; ConnDhzb = Config.OracleConnDhzb; dicJAarry = new Dictionary <string, object>(); dicJAarryKcb = new Dictionary <string, object>(); // Xgrl(); // Yfxdss(); // Shbx(); // Kcb_Jrxg(); // Kcb_IPO(); // Kcb_Srssbx(); redis.HashSet("ZXXgsg", dicJAarry); redis.HashSet("ZXXgsgKcb", dicJAarryKcb); srb.StatusCode = 1; srb.StatusMessage = JsonConvert.SerializeObject(dicJAarry); } catch (Exception ex) { // Loghelper.Error(this, ex.Message); srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> Get() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 0, StatusMessage = "gnan开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port ConnZT = Config.OracleConnZT; mysqlConnCls = Config.MysqlConnCLS; mysqlConnHej = Config.MysqlConnHej; ConnJy = Config.JySqlConn; Csgg(); Gnan(); SYlbt(); ClsTt(); Hej724(); ClsYw(); Jxcp(); srb.StatusCode = 1; srb.StatusMessage = "gnan完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> Get() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 0, StatusMessage = "sjtj开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port oracleConnDhzb = Config.OracleConnDhzb; Sjtj(); srb.StatusCode = 1; srb.StatusMessage = "sjtj完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> GetAll() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 1, StatusMessage = "Ggxq5dayController开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port ConnJy = Config.JySqlConn; DateTime timeNow = System.DateTime.Now; string redisTime = timeNow.ToString("yyyy-MM-dd HH:mm"); string TradeDayNum = timeNow.ToString("yyyyMMdd"); string TradeDayStr = timeNow.ToString("yyyy-MM-dd"); //当前日期 string TradeDayStrNow = TradeDayStr; //最近一个交易日 string sql_day = string.Format(@" select top 5 * from QT_TradingDayNew where SecuMarket=83 and TradingDate <= '{0}' and IfTradingDay=1 order by TradingDate desc", TradeDayStr); DataTable dt_day = SqlHelper.ExecuteQuery(sql_day, ConnJy); //深圳市场股票池 string sql_gpc = string.Format(@" select SecuCode from SecuMain where SecuMarket=90 and SecuCategory=1 and ListedState=1"); DataTable dt_gpc = SqlHelper.ExecuteQuery(sql_gpc, ConnJy); foreach (DataRow drgp in dt_gpc.Rows) { string secucode = drgp["SecuCode"].ToString(); //string secucode = "300148"; //StringBuilder sb = new StringBuilder(); List <day5> list = new List <day5>(); foreach (DataRow dr in dt_day.Rows) { DateTime dtime = Convert.ToDateTime(dr["TradingDate"]); TradeDayStrNow = dtime.ToString("yyyy-MM-dd"); TradeDayNum = dtime.ToString("yyyyMMdd"); //取指定tradeDay所有level2股票 Dictionary <RedisValue, RedisValue> dic_buy = redis.HashKey("level2_" + TradeDayNum + "_buy").ToDictionary(o => o.Name, p => p.Value); foreach (var item in dic_buy) { string type = item.Key; //string _val = item.Value; List <Bean> beanList = JsonConvert.DeserializeObject <List <Bean> >(item.Value); var secBean = beanList.Where(o => o.zqdm == secucode).ToList().FirstOrDefault(); if (secBean != null) { string side = "净流入"; if (secBean.cjje.StartsWith("-")) { side = "净流出"; } string typeStr = ""; switch (type) { case "tljd": typeStr = "拖拉机单"; break; case "sdd": typeStr = "闪电单"; break; case "cjd": typeStr = "超级单"; break; default: break; } day5 obj = new day5 { tradeday = TradeDayStrNow, zqdm = secucode, type = typeStr, side = side, jrcs = secBean.jrcs, cjje = secBean.cjje }; list.Add(obj); } } } if (list.Count > 0) { redis.StringSet("ggxq_5day_" + secucode, list, TimeSpan.FromSeconds(Convert.ToDouble(Config.RedisExpiry))); } } srb.StatusCode = 1; srb.StatusMessage = "Ggxq5dayController执行完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> GetAll() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 1, StatusMessage = "zltjController开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port ConnJy = Config.JySqlConn; string[] Day = new string[] { "周日", "周一", "周二", "周三", "周四", "周五", "周六" }; DateTime timeNow = System.DateTime.Now; string redisTime = timeNow.ToString("yyyy-MM-dd HH:mm"); string TradeDayNum = timeNow.ToString("yyyyMMdd"); string TradeDayStr = timeNow.ToString("yyyy-MM-dd"); //当前日期 string TradeDayStrNow = TradeDayStr; //最近一个交易日 string sql_day = string.Format(@" select top 5 * from QT_TradingDayNew where SecuMarket=83 and TradingDate <= '{0}' and IfTradingDay=1 order by TradingDate desc", TradeDayStr); DataTable dt_day = SqlHelper.ExecuteQuery(sql_day, ConnJy); if (dt_day.Rows.Count > 0) { JArray jsonArray = new JArray(); foreach (DataRow dr in dt_day.Rows) { DateTime dttime = Convert.ToDateTime(dr["TradingDate"]); string _week = Day[Convert.ToInt32(dttime.DayOfWeek.ToString("d"))].ToString(); var time = new { //tradedaystr = dttime.ToString("yyyy年MM月dd日"), tradedaynum = dttime.ToString("yyyyMMdd"), day = dttime.ToString("MM-dd"), week = timeNow.Day == dttime.Day ? "今天" : _week, redistime = redisTime }; jsonArray.Add(JToken.FromObject(time)); } //设置最近5个交易日日历 redis.StringSet("level2_tradeday", JsonConvert.SerializeObject(jsonArray)); DateTime dtime = Convert.ToDateTime(dt_day.Rows[0]["TradingDate"]); TradeDayStrNow = dtime.ToString("yyyy-MM-dd"); TradeDayNum = dtime.ToString("yyyyMMdd"); } //设置redis更新时间 redis.HashSet("level2_buy", "redistime", redisTime); redis.HashSet("level2_buy", "tradeday", TradeDayNum); Zxglb(TradeDayNum, "cjd", "buy", redisTime, timeNow); Zxglb(TradeDayNum, "sdd", "buy", redisTime, timeNow); Zxglb(TradeDayNum, "tljd", "buy", redisTime, timeNow); srb.StatusCode = 1; srb.StatusMessage = "ZltjController执行完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message; } yield return(srb); }
public IEnumerable <StatusRespondBean> GetAll() { StatusRespondBean srb = new StatusRespondBean() { StatusCode = 1, StatusMessage = "ZldxController开始执行" }; try { redis = new RedisHelper(0, Config.RedisConn);//包含DBNub,port ConnJy = Config.JySqlConn; DateTime timeNow = System.DateTime.Now; string redisTime = timeNow.ToString("yyyy-MM-dd HH:mm"); string TradeDayNum = timeNow.ToString("yyyyMMdd"); string lastTradeDayNum = TradeDayNum; string TradeDayStr = timeNow.ToString("yyyy-MM-dd"); //当前日期 string TradeDayStrNow = TradeDayStr; //最近一个交易日 string sql_day = string.Format(@" select top 2 * from QT_TradingDayNew where SecuMarket=83 and TradingDate <= '{0}' and IfTradingDay=1 order by TradingDate desc", TradeDayStr); DataTable dt_day = SqlHelper.ExecuteQuery(sql_day, ConnJy); if (dt_day.Rows.Count > 0) { DateTime dtime = Convert.ToDateTime(dt_day.Rows[0]["TradingDate"]); TradeDayStrNow = dtime.ToString("yyyy-MM-dd"); TradeDayNum = dtime.ToString("yyyyMMdd"); lastTradeDayNum = Convert.ToDateTime(dt_day.Rows[1]["TradingDate"]).ToString("yyyyMMdd");//上一个交易日 } //查找所有主力委托 List <Ggxq> List_zl = new List <Ggxq>(); Dictionary <RedisValue, RedisValue> dic_list = redis.HashKey("zlwt_" + TradeDayNum).ToDictionary(o => o.Name, p => p.Value); //查找最新交易日主力成交量 Dictionary <RedisValue, RedisValue> zlcjl_dicAll = redis.HashKey("zlcj_" + TradeDayNum).ToDictionary(o => o.Name, p => p.Value); //查找最新交易日主力净流入 Dictionary <RedisValue, RedisValue> zljmr_dicAll = redis.HashKey("zljmr_" + TradeDayNum).ToDictionary(o => o.Name, p => p.Value); //查找上一个交易日主力成交量 Dictionary <RedisValue, RedisValue> zlcjl_dicAll_last = redis.HashKey("zlcj_" + lastTradeDayNum).ToDictionary(o => o.Name, p => p.Value); //查找上一个交易日主力净流入 Dictionary <RedisValue, RedisValue> zljmr_dicAll_last = redis.HashKey("zljmr_" + lastTradeDayNum).ToDictionary(o => o.Name, p => p.Value); if (dic_list.Count > 0) { foreach (var item in dic_list) { __zqdm = item.Key; // string zqdm = "002604"; string zqdm = item.Key; //查找个股行情取总成交量 var gghq = redis.StringGet("gghq_" + zqdm); JObject oo = JObject.Parse(gghq); double cjl = Convert.ToDouble(oo["totalValueTrade"].ToString().Trim()); //查找主力成交量 double zlcjl = 0.0; Dictionary <RedisValue, RedisValue> zlcjl_dic = zlcjl_dicAll.Where(p => p.Key == zqdm).ToDictionary(o => o.Key, p => p.Value); if (zlcjl_dic.Count > 0) { foreach (var itm in zlcjl_dic) { zlcjl = Convert.ToDouble(itm.Value) / 100.0; } } double zlcjl_last = 0.0; Dictionary <RedisValue, RedisValue> zlcjl_dic_last = zlcjl_dicAll_last.Where(p => p.Key == zqdm).ToDictionary(o => o.Key, p => p.Value); if (zlcjl_dic_last.Count > 0) { foreach (var itm in zlcjl_dic_last) { zlcjl_last = Convert.ToDouble(itm.Value) / 100.0; } } //查找主力净流入 double zljmr = 0.0; Dictionary <RedisValue, RedisValue> zljmr_dic = zljmr_dicAll.Where(p => p.Key == zqdm).ToDictionary(o => o.Key, p => p.Value); if (zljmr_dic.Count > 0) { foreach (var itm in zljmr_dic) { zljmr = Convert.ToDouble(itm.Value); } } double zljmr_last = 0.0; Dictionary <RedisValue, RedisValue> zljmr_dic_last = zljmr_dicAll_last.Where(p => p.Key == zqdm).ToDictionary(o => o.Key, p => p.Value); if (zljmr_dic_last.Count > 0) { foreach (var itm in zljmr_dic_last) { zljmr_last = Convert.ToDouble(itm.Value); } } ///证券简称 string _zqjc = string.Empty; string sql = string.Format(@"select SecuAbbr from SecuMain a where a.SecuCode='{0}' and a.SecuMarket=90 and a.SecuCategory=1 ", zqdm); DataTable dt_name = SqlHelper.ExecuteQuery(sql, ConnJy); if (dt_name.Rows.Count > 0) { _zqjc = dt_name.Rows[0]["SecuAbbr"].ToString(); } //string __jmrbd = zljmr_last == 0.0 ? "--" : ConvertHelper.ConvertTo2XS100(zljmr / zljmr_last - 1) + "%"; //string __zcjbd = zlcjl_last == 0.0 ? "--" : ConvertHelper.ConvertTo2XS100(zlcjl / zlcjl_last - 1) + "%"; //double zcjzb = cjl == 0.0 ? cjl : ConvertHelper.ConvertTo4XDouble(zlcjl / cjl); var zl = new Ggxq() { zqdm = zqdm, zqjc = _zqjc, tradeday = TradeDayNum, jmr = zljmr, jmrbd = zljmr_last == 0.0 ? "--" : ConvertHelper.ConvertTo2XS100(zljmr / zljmr_last - 1) + "%", zcjbd = zlcjl_last == 0.0 ? "--" : ConvertHelper.ConvertTo2XS100(zlcjl / zlcjl_last - 1) + "%", zcjzb = cjl == 0.0 ? cjl : ConvertHelper.ConvertTo4XDouble(zlcjl / cjl), }; List_zl.Add(zl); } } var list_jmr = List_zl.OrderByDescending(p => p.jmr).Take(50); var ls_jmr = (from g in list_jmr.ToList() select new { g.zqdm, g.zqjc, jmr = ConvertHelper.ConvertToString(g.jmr / 1000000.0), g.jmrbd, }).ToList(); var list_cj = List_zl.OrderByDescending(p => p.zcjzb).Take(50); var ls_cj = (from g in list_cj.ToList() select new { g.zqdm, g.zqjc, zcjzb = ConvertHelper.ConvertTo2XS100(g.zcjzb) + "%", g.zcjbd, }).ToList(); redis.HashSet("zlzjdx", "jmr", ls_jmr); redis.HashSet("zlzjdx", "cjzb", ls_cj); redis.HashSet("zlzjdx", "redistime", redisTime); srb.StatusCode = 1; srb.StatusMessage = "ZldxController执行完成"; } catch (Exception ex) { srb.StatusCode = -1; srb.StatusMessage = ex.Message + ":" + __zqdm; } yield return(srb); }