public bool HK6IssuseStart(List <string> list)
{
var db = new DbProvider();
//// db.Init("Default");
try
{
db.Init("MySql.Default", true);
list = (from items in list orderby items select items).ToList();
DateTime oneDate = DateTime.Parse(list[0]);
string Year = oneDate.Year + "";
string atcNo = "";
int index = 73;
var timelist = db.CreateQuery <blast_lhc_time>().ToList();;
foreach (var item in list)
{
if (index > 142)
{
Console.WriteLine(item);
}
if (DateTime.Parse(item).Year != oneDate.Year)
{
index = 1;
Year = DateTime.Parse(item).Year + "";
oneDate = DateTime.Parse(item);
}
atcNo = index + "";
atcNo = Year + "" + index;
//if (index < 10)
//{
// atcNo = Year + "00" + index;
//}
//if (index >= 10 && index < 100)
//{
// atcNo = Year + "0" + index;
//}
//if (index > 100)
//{
// atcNo = Year + "" + index;
//}
DateTime actionTime = DateTime.Parse(item);
var one = timelist.Where(b => b.actionTime == actionTime).FirstOrDefault();
if (one == null)
{
blast_lhc_time b = new blast_lhc_time()
{
// actionDate = item,
typeid = 1,
actionNo = int.Parse(atcNo),
actionTime = DateTime.Parse(item),
stopTime = DateTime.Parse(DateTime.Parse(item).ToShortDateString()).AddHours(21).AddMinutes(30)
};
db.GetDal <blast_lhc_time>().Add(b);
}
else
{
//db.GetDal<blast_lhc_time>().Update(b => new blast_lhc_time
//{
// actionNo = int.Parse(atcNo)
//}, b => b.actionTime == actionTime);
}
index++;
}
}
catch (Exception)
{
throw;
}
finally
{
db.Dispose();
}
return(true);
}
public static List <blast_lhc_time> BJPKOpenWinNum(string code = "bjhk6")
{
string jsonstr = GetWinNum(code);
List <blast_lhc_time> list = new List <blast_lhc_time>();
try
{
if (jsonstr == "404")
{
return(list);
}
var djson = JsonHelper.Decode(jsonstr);
string temp = "";
string expect = "";
foreach (var item in djson)
{
try
{
if (item.Name == "data")
{
Console.WriteLine("");
var data = item.Value;
foreach (var item1 in data)
{
// DateTime.Now.ToShortDateString
temp = DateTime.Parse(item1.opentime.Value + "").ToShortDateString();
expect = item1.expect.Value;
int exp = int.Parse(expect);
if (exp < 2000)
{
exp = int.Parse(DateTime.Parse(temp).Year + "" + exp);
}
blast_lhc_time bdata = new blast_lhc_time()
{
actionNo = exp,
actionTime = DateTime.Parse(temp),
stopTime = DateTime.Parse(temp).AddHours(21).AddMonths(30),
winNum = (item1.opencode.Value + "").Replace("+", "|"),
typeid = 1
};
list.Add(bdata);
//"[\r\n 0,\r\n 0\r\n]"
// issue: 134
//nanairo: 0
//preDrawCode: "25,34,3,30,13,8,32"
//preDrawDate: "2018-11-24"
//seventhBigSmall: 0
//seventhCompositeBig: 1
//seventhCompositeDouble: 0
//seventhMantissaBig: 1
//seventhSingleDouble: 1
//sumTotal: 145
//totalBigSmall: 1
//totalSingleDouble: 0
Console.WriteLine("");
}
}
}
catch (Exception ex)
{
continue;
}
}
}
catch (Exception)
{
throw;
}
Console.WriteLine(string.Join(Environment.NewLine, list));
return(list);
}
private blast_data GetWinData(blast_lhc_time btime)
{
int issueNo = int.Parse(btime.actionNo + "");
if (issueNo < 2000)
{
issueNo = int.Parse(btime.actionTime.Year + "" + issueNo);
}
var query = DB.CreateQuery <blast_data>();
blast_data data = new blast_data();
int year = int.Parse((issueNo + "").Substring(0, 4));
int iNo = int.Parse((issueNo + "").Substring(4));
if (iNo - 1 <= 0)
{
string date = (year - 1) + "-12-01";
string ete = (year) + "-01-01";
DateTime sdate = DateTime.Parse(date);
DateTime edate = DateTime.Parse(ete);
//上一年的期号
data = (from b in query
where b.kjtime > sdate && b.kjtime < edate
orderby b.kjtime descending
select b).FirstOrDefault();
if (data == null)
{
blast_lhc_time datatime = (from b in DB.CreateQuery <blast_lhc_time>()
where b.actionTime > sdate && b.actionTime < edate
orderby b.actionTime descending
select b).FirstOrDefault();
data = new blast_data()
{
issueNo = datatime.actionNo, kjdata = "", typeid = 1, kjnumber = "", kjtime = datatime.actionTime
};
}
}
else
{
int nissueNo = (issueNo - 1);
data = query.Where(b => b.issueNo == nissueNo).FirstOrDefault();
if (data == null)
{
blast_lhc_time datatime = DB.CreateQuery <blast_lhc_time>().Where(b => b.actionNo == nissueNo).FirstOrDefault();
data = new blast_data()
{
issueNo = datatime.actionNo, kjdata = "", typeid = 1, kjnumber = "", kjtime = datatime.actionTime
};
}
}
string str = data.kjdata + "";
if (str.Contains(",") && !str.Contains(","))
{
int index = str.LastIndexOf(',');
string temp = str.Substring(0, index);
string temp1 = str.Substring(index);
data.kjdata = temp + "+" + temp1.Replace(",", "");
}
return(data);
}