Exemple #1
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         Task.Factory.StartNew(() =>
         {
             using (SqlDbContext db = new SqlDbContext())
             {
                 QueryList = db.Database.SqlQuery <Engine>("SELECT id ,fadongjixinghao_d FROM [Web_ssp].[dbo].[Web_gonggao] where DATALENGTH(fadongjixinghao_d) > 1 and title not like '%摩托车%' and title not like '%电动%'").ToList();
                 //var fadongji = db.Database.SqlQuery<fadongji>("select EngineName,MaxHorsepower from ").ToList();
                 for (int i = 12165; i < QueryList.Count; i++)
                 {
                     string[] fdjxh = Regex.Split(QueryList[i].fadongjixinghao_d, "<br />", RegexOptions.IgnoreCase);
                     string updata  = string.Empty;
                     if (fdjxh.Length > 1)
                     {
                         for (int q = 0; q < fdjxh.Length; q++)
                         {
                             if (q == fdjxh.Length - 1)
                             {
                                 updata += db.Database.SqlQuery <string>("select MaxHorsepower from Web_engine where EngineName='" + fdjxh[q] + "'").SingleOrDefault();
                             }
                             else
                             {
                                 updata += db.Database.SqlQuery <string>("select MaxHorsepower from Web_engine where EngineName='" + fdjxh[q] + "'").SingleOrDefault() + "<br />";
                             }
                         }
                     }
                     else
                     {
                         updata = db.Database.SqlQuery <string>("select MaxHorsepower from Web_engine where EngineName='" + fdjxh[0] + "'").SingleOrDefault();
                     }
                     if (string.IsNullOrEmpty(updata))
                     {
                         updata = "";
                     }
                     string ret = updata.Replace("马力", "");
                     db.Database.ExecuteSqlCommand("update Web_gonggao set mali_d='" + ret + "' where id='" + QueryList[i].Id + "'");
                 }
                 //for (int i = 0; i < QueryList.Count; i++)
                 //{
                 //    string[] fdjxh = Regex.Split(QueryList[i].fadongjixinghao_d, "<br />", RegexOptions.IgnoreCase);
                 //    strList.AddRange(fdjxh);
                 //}
                 //List<string> listString = new List<string>();
                 //foreach (string eachString in strList)
                 //{
                 //    if (!listString.Contains(eachString))
                 //        listString.Add(eachString);
                 //}
                 //var count = db.Database.SqlQuery<string>("SELECT EngineName FROM Web_engine").ToList();
                 //foreach (string thisString in count)
                 //{
                 //    if (listString.Contains(thisString) || listString.Contains(thisString.Trim()))
                 //        listString.Remove(thisString);
                 //}
                 //int jishu = 0;
                 //foreach (string thisString in listString)
                 //{
                 //    //Adddata(thisString);
                 //    jishu++;
                 //    this.textBox1.Text = jishu.ToString();
                 //    Thread.Sleep(3000);
                 //}
             }
             MessageBox.Show("添加完成");
         });
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemple #2
0
        private void Adddata(string engine)
        {
            string url     = "http://www.hc39.com/desktops/checkEngine.php?key=";
            string gethtml = HttpGet(url + engine, "text/html;charset=utf-8");
            var    tbody   = gethtml.Split(new string[] { "</tbody>" }, StringSplitOptions.RemoveEmptyEntries);

            if (tbody.Length > 2)
            {
                string name = string.Empty, pingpai = string.Empty, xilie = string.Empty, changshang = string.Empty, qgshu = string.Empty,
                       rnzlei = string.Empty, qgpfxshi = string.Empty, pailiang = string.Empty, pfbzhun = string.Empty, zdscglv = string.Empty,
                       edzshu = string.Empty, zdmli = string.Empty, zdnju = string.Empty, zdnjzshu = string.Empty,
                       spfwei = string.Empty, jqxshi = string.Empty, fdjxshi = string.Empty, qfuhe = string.Empty, fdjjzhong = string.Empty,
                       ysbi = string.Empty, yimiwai = string.Empty, gjXxc = string.Empty, mgqmshu = string.Empty, dhxsu = string.Empty;
                foreach (var kk in tbody[0].Split(new string[] { "</tr>" }, StringSplitOptions.RemoveEmptyEntries))
                {
                    var splist = kk.Split(new string[] { "</td>" }, StringSplitOptions.RemoveEmptyEntries);
                    for (int i = 0; i < splist.Length; i++)
                    {
                        if (splist[i].Contains(@"<td rowspan=""6"" style=""width:360px;""><img src="""))
                        {
                            Regex  regImg = new Regex(@"<img\b[^<>]*?\bsrc[\s\t\r\n]*=[\s\t\r\n]*[""']?[\s\t\r\n]*(?<imgUrl>[^\s\t\r\n""'<>]*)[^<>]*?/?[\s\t\r\n]*>", RegexOptions.IgnoreCase);
                            string imgsrc = string.Empty;
                            // 搜索匹配的字符串
                            MatchCollection matches = regImg.Matches(splist[i]);
                            foreach (Match match in matches)
                            {
                                imgsrc = match.Groups["imgUrl"].Value;
                            }

                            DownloadPicture(imgsrc, 60000);
                            break;
                        }
                    }
                }
                foreach (var x in tbody[1].Split(new string[] { "</tr>" }, StringSplitOptions.RemoveEmptyEntries))
                {
                    var list = x.Split(new string[] { "</td>" }, StringSplitOptions.RemoveEmptyEntries);
                    if (list.Length == 1)
                    {
                        continue;
                    }
                    for (int i = 0; i < list.Length; i++)
                    {
                        if (list[i].Contains("发动机:"))
                        {
                            name = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("系列:"))
                        {
                            xilie = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("汽缸数:"))
                        {
                            qgshu = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("排列形式:"))
                        {
                            qgpfxshi = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("排放标准:"))
                        {
                            pfbzhun = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("额定转速:"))
                        {
                            edzshu = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("最大扭矩:"))
                        {
                            zdnju = list[i + 1].Replace("<td>", "");
                        }

                        else if (list[i].Contains("品牌:"))
                        {
                            pingpai = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("厂商:"))
                        {
                            changshang = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("燃料种类:"))
                        {
                            rnzlei = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("排量:"))
                        {
                            pailiang = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("最大输出功率:"))
                        {
                            zdscglv = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("最大马力:"))
                        {
                            zdmli = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("最大扭矩转速:"))
                        {
                            zdnjzshu = list[i + 1].Replace("<td>", "");
                        }
                        //-----------------------------------------
                        else if (list[i].Contains("适配范围:"))
                        {
                            spfwei = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("进气形式:"))
                        {
                            jqxshi = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("发动机形式:"))
                        {
                            fdjxshi = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("全负荷:"))
                        {
                            qfuhe = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("发动机净重:"))
                        {
                            fdjjzhong = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("压缩比:"))
                        {
                            ysbi = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("一米外噪音:"))
                        {
                            yimiwai = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("缸径x行程:"))
                        {
                            gjXxc = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("每缸气门数:"))
                        {
                            mgqmshu = list[i + 1].Replace("<td>", "");
                        }
                        else if (list[i].Contains("点火次序:"))
                        {
                            dhxsu = list[i + 1].Replace("<td>", "");
                        }
                    }
                }
                try
                {
                    using (SqlDbContext insertdb = new SqlDbContext())
                    {
                        string sql = "insert into [Web_ssp].[dbo].[Web_engine](EngineName,EngineSeries,CylindersNum," +
                                     "CylindersArrange,EmissionStandard,Rpm,MaxTorque,EngineBrand,EngineVendor,FuelCategory,Displacement," +
                                     "MaxPower,MaxHorsepower,MaxTorqueSpeed,AdaptiveRange,IntakeForm,EngineForm,FullLoad,EngineSuttle,CompressionRatio," +
                                     "OneMeterOutside,CylinderXStroke,ValvesPerCylinder,FiringOrder,EnginePic) " +
                                     "values('" + name + "','" + xilie + "','" + qgshu + "','" + qgpfxshi + "','" + pfbzhun + "','" + edzshu + "','" + "" + zdnju + "','"
                                     + pingpai + "','" + changshang + "','" + rnzlei + "','" + pailiang + "','" + zdscglv + "','" + zdmli + "','" + zdnjzshu + "','" + spfwei + "','"
                                     + jqxshi + "','" + fdjxshi + "','" + qfuhe + "','" + fdjjzhong + "','" + ysbi + "','" + yimiwai + "','" + gjXxc + "','" + mgqmshu + "','" + dhxsu + "','" + PicName + "')";
                        insertdb.Database.ExecuteSqlCommand(sql);
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }