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