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