/// <summary> /// 新增一星走势数据 /// </summary> /// <param name="type"></param> /// <param name="tendencys"></param> public static void SaveTendency1(Tendency1Enum type, List <TendencyModel> tendencys) { string tableName = getTendency1Table(type); using (SQLiteConnection conn = CreateConnection()) { conn.Open(); SQLiteTransaction trans = conn.BeginTransaction(); string sqlCount = string.Format("SELECT count(1) FROM {0} where Ymd = @Ymd and Sno=@Sno", tableName); try { string sql = null; for (int i = 0; i < tendencys.Count; i++) { TendencyModel lm = tendencys[i]; int count = conn.Query <int>(sqlCount, lm).FirstOrDefault(); if (count == 0) { ///新增 sql = string.Format("insert into {0}(Ymd ," + @"Sno ," + @"Lottery ," + @"Big ," + @"Small ," + @"Odd ," + @"Pair ," + @"Dtime )" + @" VALUES (" + @"@Ymd ," + @"@Sno ," + @"@Lottery ," + @"@Big ," + @"@Small ," + @"@Odd ," + @"@Pair ," + @"@Dtime " + @")", tableName); } else { ///修改 sql = string.Format("Update {0} set Big =@Big ," + "Small =@Small ," + "Odd =@Odd ," + "Pair =@Pair " + "where Ymd = @Ymd and Sno=@Sno ", tableName); } conn.Execute(sql, lm, trans); } trans.Commit(); } catch (Exception) { trans.Rollback(); } } }
/// <summary> /// 取某一位的,奇、偶、大、小、012路走势 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <returns></returns> public JsonResult PostRoadTrendecy(int type, string date, int num) { date = date.Replace("-", ""); Tendency1Enum tendency1Enum = (Tendency1Enum)type; var list = XscpMysqlBLL.QueryTendency1(tendency1Enum, date, num); return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 取某一位的,奇、偶、大、小、012路 最大走势 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <param name="num"></param> /// <returns></returns> public JsonResult PostMaxRoadTrendecy(int type, string date) { date = date.Replace("-", ""); Tendency1Enum tendency1Enum = (Tendency1Enum)type; TendencyModel tm = XscpMysqlBLL.QueryMaxTendency1(tendency1Enum, date); tm.Sno = "最大"; return(Json(tm, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查找指定期号 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <param name="sno"></param> /// <returns></returns> public static Tendency2Model QueryTendency1(Tendency1Enum type, string date, string sno) { string tableName = getTendency1Table(type); using (SQLiteConnection conn = CreateConnection()) { string sql = string.Format("select * from {0} where Ymd = '{1}' and sno='{2}'", tableName, date, sno); return(conn.Query <Tendency2Model>(sql).FirstOrDefault()); } }
/// <summary> /// 查找一星走势 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <param name="topNum"></param> /// <returns></returns> public static List <TendencyModel> QueryTendency1(Tendency1Enum type, string date, int topNum) { string tableName = getTendency1Table(type); using (SQLiteConnection conn = CreateConnection()) { string sql = string.Format("select * from {0} where Ymd = '{1}' order by Sno desc limit 0,{2}", tableName, date, topNum); return(conn.Query <TendencyModel>(sql).ToList()); } }
private void SaveTendency1(Tendency1Enum type, List <string> lt_date) { lt_date.ForEach(date => { var lottery = XscpSqlliteBLL.QueryTendency1(type, date, 1380); lottery = lottery.OrderBy(l => l.Sno).ToList(); MysqlHelper.SaveTendency1(type, lottery); Console.WriteLine("完成一星:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "【" + date + "】"); }); }
/// <summary> /// 新增一星走势数据 /// </summary> /// <param name="type"></param> /// <param name="tendencys"></param> public static void SaveTendency1(Tendency1Enum type, List <LotteryModel> ltData) { int index = (int)type; LotteryModel minData = ltData[ltData.Count - 1]; //上一期趋势 TendencyModel preTendency1 = null; //本次上一次开奖趋势,除非最后一期 int prePperiod = int.Parse(minData.Sno) - 1; if (prePperiod > 0) { preTendency1 = SQLiteHelper.QueryTendency1(type, minData.Ymd, prePperiod.ToString().PadLeft(4, '0')); } AnalyzeTendency At = new AnalyzeTendency(); List <TendencyModel> ltTendency = new List <TendencyModel>(); for (int i = ltData.Count - 1; i >= 0; i--) { LotteryModel lm = ltData[i]; TendencyModel tm = new TendencyModel(); tm.Ymd = lm.Ymd; tm.Lottery = lm.Lottery; tm.Sno = lm.Sno; tm.Big = At.BigNum(lm, preTendency1, index); //大大 tm.Small = At.SmallNum(lm, preTendency1, index); //小小 tm.Odd = At.OddPairNum(lm, preTendency1, index, 1); //奇奇 tm.Pair = At.OddPairNum(lm, preTendency1, index, 0); //偶偶 tm.Dtime = lm.Dtime; ltTendency.Add(tm); prePperiod = int.Parse(lm.Sno); if (prePperiod == 1380) { preTendency1 = null; } else { preTendency1 = tm; } } SQLiteHelper.SaveTendency1(type, ltTendency); }
/// <summary> /// 获取一星指定日期最大走势 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <returns></returns> public static TendencyModel QueryMaxTendency1(Tendency1Enum type, string date) { string tableName = getTendency1Table(type); using (SQLiteConnection conn = CreateConnection()) { string sql = string.Format("select max(Big) Big, " + "max(Small) Small, " + "max(Odd) Odd, " + "max(Pair) Pair " + "from {0} where Ymd = '{1}'", tableName, date); return(conn.Query <TendencyModel>(sql).FirstOrDefault()); } }
/// <summary> /// 获取二星走势表名 /// </summary> /// <param name="type"></param> /// <returns></returns> private static string getTendency1Table(Tendency1Enum type) { return("TendencyDigit" + (int)type + "_" + DateTime.Now.Year); }
/// <summary> /// 获取一星指定日期最大走势 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <returns></returns> public static TendencyModel QueryMaxTendency1(Tendency1Enum type, string date) { return(SQLiteHelper.QueryMaxTendency1(type, date)); }
/// <summary> /// 查找一星走势 /// </summary> /// <param name="type"></param> /// <param name="date"></param> /// <param name="topNum"></param> /// <returns></returns> public static List <TendencyModel> QueryTendency1(Tendency1Enum type, string date, int topNum) { return(SQLiteHelper.QueryTendency1(type, date, topNum)); }