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