Exemple #1
0
        public RegionalModel getRegional()
        {
            RegionalModel hasil = new RegionalModel();
            IEnumerable <RegionalData> result = null;

            using (IDbConnection connection = Extension.GetConnection(1))
            {
                try
                {
                    string sql = @"select * from VW_REGIONAL_POCC ";
                    result = connection.Query <RegionalData>(sql, new
                    {
                        KD_REGIONAL = ""
                    });


                    hasil.count   = result.Count();
                    hasil.data    = result.ToList();
                    hasil.message = "Succes";
                    hasil.status  = "S";
                }
                catch (Exception e)
                {
                    // result = null;
                    hasil.count   = 0;
                    hasil.message = e.Message;
                    hasil.status  = "E";
                }
            }
            return(hasil);
        }
Exemple #2
0
 /// <summary>
 /// 创建SQL命令
 /// </summary>
 /// <param name="regional"></param>
 public void CreateSQLCommand(RegionalModel regional)
 {
     if (regional != null)
     {
         string sql = $"INSERT INTO RegionalData (RegionalDataOID,ID,Name,ParentOID) VALUES('{regional.RegionalDataOID}','{regional.ID}','{regional.Name}','{regional.ParentOID}')";
         log.Information(sql);
         collection.Add(new Command(sql, regional));
         dbContext.ExecuteSql(sql, regional);
     }
 }
Exemple #3
0
        public IActionResult getRegional()
        {
            MasRegionalDL dal = new MasRegionalDL();



            // MasRegionalController hasil = new MasRegionalController();



            RegionalModel result = dal.getRegional();

            //    hasil.message = "Success";
            //  hasil.status = "S";
            //   hasil.count = result.Cast<Object>().Count();
            //  hasil.data = result.ToList();



            return(Ok(result));
        }
Exemple #4
0
 public override void Execute(IJobExecutionContext context)
 {
     try
     {
         //需要寻找的class
         string[] NeedClass = new string[] { ".provincetr", ".citytr", ".countytr", ".towntr", ".villagetr" };
         Crawler  crawler   = new Crawler();
         crawler.wait    = 2000;
         crawler.Timeout = 10000;
         //crawler.Cookie = "__utmz=207252561.1566065018.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); AD_RS_COOKIE=20082856; __utma=207252561.1090452968.1566065018.1566892516.1566911665.4; __utmc=207252561; __utmt=1; wzws_reurl=L3Rqc2ovdGpiei90anlxaGRtaGN4aGZkbS8yMDE4LzEzLmh0bWw=; __utmb=207252561.2.10.1566911665; wzws_cid=71a25ce145fef3ef24abcd820a9cb0a7362be1e734c83a66d1489e6dd05749fe7d46940c76eda51782a874be4358594674e0ffc98ea6cd85dbd9af045cc53d1d2f71135cff0df7fdf0e26a219f19ffc6";
         crawler.ThreadNum = 5;
         crawler.DoSomeThing((n, que) =>
         {
             Qfun q = HtmlParser.Query(n);
             if (q != null)
             {
                 for (int i = 0; i < NeedClass.Length; i++)
                 {
                     var Class = q(NeedClass[i]);
                     foreach (var items in Class)
                     {
                         var td = q(items).find("td");
                         if (td.length == 2 || td.length == 1)
                         {
                             var a = q(td).find("a");
                             if (a.length > 0)
                             {
                                 RegionalModel regional   = new RegionalModel();
                                 regional.RegionalDataOID = Guid.NewGuid();
                                 regional.ID        = a[0].textContent;
                                 regional.Name      = a[1].textContent;
                                 regional.ParentOID = Guid.Parse(que.pairs.FirstOrDefault(f => f.Key == "ParentOID").Value);
                                 string Url         = a[0].getAttribute("href");
                                 if (Url.IndexOf('/') > -1)
                                 {
                                     Url = Url.Substring(3, Url.Length - 5);
                                 }
                                 else
                                 {
                                     Url = Url.Substring(3, Url.Length - 8);
                                 }
                                 Url = UrlDecoding.Decoding(Url);
                                 crawler.EnQueue(CreateQueue(Url, regional.RegionalDataOID.ToString()));
                                 CreateSQLCommand(regional);
                             }
                             else
                             {
                                 RegionalModel regional   = new RegionalModel();
                                 regional.RegionalDataOID = Guid.NewGuid();
                                 regional.ID        = td[0].textContent;
                                 regional.Name      = td[1].textContent;
                                 regional.ParentOID = Guid.Parse(que.pairs.FirstOrDefault(f => f.Key == "ParentOID").Value);
                                 CreateSQLCommand(regional);
                             }
                         }
                         else if (td.length == 3)
                         {
                             RegionalModel regional   = new RegionalModel();
                             regional.RegionalDataOID = Guid.NewGuid();
                             regional.ID        = td[0].textContent;
                             regional.Name      = td[2].textContent;
                             regional.ParentOID = Guid.Parse(que.pairs.FirstOrDefault(f => f.Key == "ParentOID").Value);
                             CreateSQLCommand(regional);
                         }
                         else
                         {
                             foreach (var item in td)
                             {
                                 var a = q(item).find("a");
                                 foreach (var href in a)
                                 {
                                     RegionalModel regional   = new RegionalModel();
                                     regional.RegionalDataOID = Guid.NewGuid();
                                     regional.Name            = href.textContent;
                                     regional.ParentOID       = Guid.Parse(que.pairs.FirstOrDefault(f => f.Key == "ParentOID").Value);
                                     string Url  = href.getAttribute("href");
                                     regional.ID = Url.Substring(0, Url.Length - 5);
                                     crawler.EnQueue(CreateQueue(Url, regional.RegionalDataOID.ToString()));
                                     CreateSQLCommand(regional);
                                 }
                             }
                         }
                     }
                 }
             }
         }, () => { InsertIntoMSDB(); crawler.Done(); });
         crawler.EnQueue(BeginTask());
         crawler.RunCrawler();
         base.NextTime(context);
     }
     catch (Exception ex)
     {
         log.Error(ex, $"{this.TaskName}同步出错");
     }
 }