private void timer2_Tick(object sender, EventArgs e)
{
using (SqlEntities db = new SqlEntities())
{
var LotteryList = db.tb_Lottery.AsNoTracking().Where(t => t.State == 0).ToList();
}
}
/// <summary>
/// 获取子节点
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <glxxModel> getGlxxChildren(int id)
{
List <glxxModel> list = new List <glxxModel>();
using (SqlEntities db = new SqlEntities())
{
string sql = string.Format(@"select ID AS id,[级别ID] as levelid ,[名称] as name, [上级ID] as parentid, [级别描述] as description from [管理信息] where [上级ID] ={0}", id);
IEnumerable <glxxModel> queryable = db.Database.SqlQuery <glxxModel>(sql);
list = queryable.ToList();
}
return(list);
}
/// <summary>
/// 获取设备信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <sbxxModel> getSbxxList(int id)
{
List <sbxxModel> list = new List <sbxxModel>();
using (SqlEntities db = new SqlEntities())
{
string sql = string.Format(@"select ID id,[名称] name , [用户站类型] usertype , [用户站参数] userparameter ,[管理ID] managementid,[通讯设备ID] communicationid,[传输设备ID] transmission,[数据采集方式] collectionmethod,
[是否启用] isenabled,[衍生相关量] relatedquantity,[显示量] displayvolume from [设备信息] where [管理ID] ={0}", id);
IEnumerable <sbxxModel> queryable = db.Database.SqlQuery <sbxxModel>(sql);
list = queryable.ToList();
}
return(list);
}
void IDataSchemaAssignment.SetDataSchemaAndSeal(DataSchema dataSchema)
{
if (DataSchema != null)
{
throw new System.InvalidOperationException("DataSchema is sealed.");
}
DataSchema = dataSchema;
foreach (var dataSchemaAssignment in SqlEntities.OfType <IDataSchemaAssignment>())
{
dataSchemaAssignment.SetDataSchemaAndSeal(dataSchema);
}
}
/// <summary>
/// 获取水位信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public lsjlModel getOldRecordingList(int id)
{
string year = DateTime.Now.Year.ToString();
string oldid = id.ToString().PadLeft(6, '0');
string bm = "历史记录_" + oldid + "_" + year;
using (SqlEntities db = new SqlEntities())
{
string sql = string.Format(@"select [记录时间] recordingtime, [上报水位] waterlevel from [{0}] ORDER BY [记录时间] desc", bm);
lsjlModel model = db.Database.SqlQuery <lsjlModel>(sql).FirstOrDefault();
return(model);
}
}
private void timer1_Tick(object sender, EventArgs e)
{
List <tb_Lottery> LotteryList;
List <string> RedisUpdateID = new List <string>(); //需要重新更新开奖结果的RedisID
using (SqlEntities db = new SqlEntities())
{
LotteryList = db.tb_Lottery.AsNoTracking().Where(t => t.State == 0).ToList();
}
//Parallel.ForEach(LotteryList, item =>
// {
// });
foreach (var item in LotteryList)
{
var url = string.Empty;
if (item.IsUrl == 0)
{
url = item.Url1;
}
else
{
url = item.Url2;
}
if (url.IndexOf("kaijiang.500.com") != -1)
{
url += DateTime.Now.ToString("yyyyMMdd") + ".xml";
}
IReptile LotteryReptile;
if (url.IndexOf("dandan28") != -1)
{
LotteryReptile = new DanDanReptile();
}
else
{
LotteryReptile = new Reptile();
}
LotteryReptile.OnStart += (s, ea) =>
{
//LogEx.l("开始抓取：" + url);
};
LotteryReptile.OnError += (s, ea) =>
{
ea.Exception.l("");
};
LotteryReptile.OnComplete += (s, ea) =>
{
try
{
NewLotteryInfo en;
if (ea.Uri.AbsoluteUri.IndexOf("www-cp77.com") != -1)
{
en = Algorithm.SSC_cp77(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("www.lotto-8.com") != -1)
{
en = Algorithm.XGLHC_lotto8(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("www.dandan28.com") != -1)
{
en = Algorithm.PCDD_dandan28(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("baidu.lecai.com/lottery/ajax_latestdrawn.php") != -1)
{
en = Algorithm.SSC_baidu(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("baidu.lecai.com/lottery/ajax_current_with_latest_drawn.php") != -1)
{
en = Algorithm.K3_baidu(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("kaijiang.500.com") != -1)
{
en = Algorithm.ssc_500(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("www.mingpaoracing.com") != -1)
{
en = Algorithm.XGLHC_mingpaoracing(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("www.xjflcp.com") != -1)
{
en = Algorithm.SSC_xjflcp(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("shishicai.cjcp.com.cn/tianjin") != -1)
{
en = Algorithm.SSC_shishicai(ea.PageSource);
}
//else if (ea.Uri.AbsoluteUri.IndexOf("www.pk10.com") != -1)
//{
// en = Algorithm.SSC_pk10(ea.PageSource);
//}
else if (ea.Uri.AbsoluteUri.IndexOf("kuai3.cjcp.com.cn") != -1)
{
en = Algorithm.SSC_kuai3(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("zs.cailele.com") != -1)
{
en = Algorithm.SSC_zs(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("kaijiang.aicai.com") != -1)
{
en = Algorithm.SSC_kaijiang(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("kj.cjcp.com.cn") != -1)
{
en = Algorithm.SSC_kj(ea.PageSource);
}
else if (ea.Uri.AbsoluteUri.IndexOf("shishicai.cjcp.com.cn/heilongjiang") != -1)
{
en = Algorithm.SSC_shishicaihei(ea.PageSource);
}
else
{
en = new NewLotteryInfo();
}
bool isAdd = true;
using (SqlEntities db = new SqlEntities())
{
var LastNo = db.tb_LotteryNumber.AsNoTracking().Where(t => t.LotteryID == item.ID).OrderByDescending(t => t.AddTime).FirstOrDefault();
if (LastNo != null)
{
//if (item.ID == 1)
// en.No = (Convert.ToInt64(LastNo) + 1).ToString();
if (LastNo.No == en.No)
{
isAdd = false;
}
else if (LastNo.Numbers == en.Numbers)
{
isAdd = false;
}
}
if (isAdd)
{
tb_LotteryNumber ln = new tb_LotteryNumber();
ln.AddTime = DateTime.Now;
ln.LotteryID = item.ID;
ln.No = en.No;
ln.Numbers = en.Numbers;
ln.OpenTime = en.OpenTime;
db.tb_LotteryNumber.Add(ln);
db.SaveChanges();
//sb.AppendFormat("INSERT INTO [tb_LotteryNumber] ([LotteryID] ,[No],[Numbers],[AddTime],[OpenTime])");
//sb.AppendFormat("VALUES ({0} ,'{1}','{2}','{3}','{4}');", item.ID, en.No, en.Numbers, DateTime.Now, en.OpenTime);
// RedisUpdateID.Add("ApiLotteryNumber:" + item.ID);
ReturnRedis.RemoveKey("ApiLotteryNumber:" + item.ID);
LogEx.l("抓取完成 url：" + url);
}
}
}
catch (Exception)
{
}
};
if (!string.IsNullOrWhiteSpace(url))
{
LotteryReptile.Start(new Uri(url));
}
}
}
