示例#1
0
 public List<BuyerInfo> GetBuyerInforList(QueryObject<BuyerInfo> query)
 {
     string sql = "SELECT Id, Type, CompanyName, CompanyInfo, Category, Mail,BuyerName, ContactInfo, Url, UrlTitle, Status FROM BuyerInfo";
     if (query.IsPager)
     {
         query.RecordCount = dbHelper.GetItemCount(sql, null);
         sql = sql + " order by Id asc limit " + query.Start + ", " + query.PageSize;
     }
     DataTable dt = dbHelper.ExecuteDataTable(sql, null);
     List<BuyerInfo> list = new List<BuyerInfo>();
     foreach (DataRow row in dt.Rows)
     {
         BuyerInfo kw = new BuyerInfo();
         kw.Id = Convert.ToInt32(row["Id"]);
         kw.Type = (string)row["Type"];
         kw.CompanyName = (string)row["CompanyName"];
         kw.CompanyInfo = (string)row["CompanyInfo"];
         kw.Category = (string)row["Category"];
         kw.Mail = (string)row["Mail"];
         kw.BuyerName = (string)row["BuyerName"];
         kw.ContactInfo = (string)row["ContactInfo"];
         kw.Url = (string)row["Url"];
         kw.UrlTitle = (string)row["UrlTitle"];
         kw.Status = Convert.ToInt32(row["Status"]);
         list.Add(kw);
     }
     return list;
 }
示例#2
0
        public void Insert(BuyerInfo item)
        {
            if (item.Emails.Count == 0)
            {
                return;
            }
            string InsSql = @"Insert into BuyerInfo(Type, CompanyName, CompanyInfo, Category, Mail,BuyerName, ContactInfo, Url, UrlTitle) "
                            + "values(@Type, @CompanyName, @CompanyInfo, @Category, @Mail, @BuyerName, @ContactInfo, @Url, @UrlTitle)";

            foreach (string mail in item.Emails)
            {
                if (ExistEmail(mail))
                {
                    continue;
                }
                SQLiteParameter[] parameter = new SQLiteParameter[]
                {
                    new SQLiteParameter("@Type",item.Type),
                    new SQLiteParameter("@CompanyName",item.CompanyName),
                    new SQLiteParameter("@CompanyInfo",item.CompanyInfo),
                    new SQLiteParameter("@Category",string.IsNullOrEmpty(item.Category)?"-":item.Category),
                    new SQLiteParameter("@Mail", mail),
                    new SQLiteParameter("@BuyerName",item.BuyerName),
                    new SQLiteParameter("@ContactInfo",item.ContactInfo),
                    new SQLiteParameter("@Url",item.Url),
                    new SQLiteParameter("@UrlTitle",item.UrlTitle)
                };
                dbHelper.ExecuteNonQuery(InsSql, parameter);
            }
        }
        public BuyerInfo GetBuyerInfo(string url, HtmlDocument document)
        {
            BuyerInfo buyerInfo = new BuyerInfo();
            buyerInfo.Url = url;
            buyerInfo.UrlTitle = HtmlUtils.GetHtmlNodeText(document.DocumentNode.SelectSingleNode("/html/head/title"));
            if (url.IndexOf("/company/") > 0)
            {
                if (url.StartsWith("http://buyer.waimaoba.com"))
                {
                    buyerInfo.Type = "Buyer";
                    HtmlNodeCollection fieldsetNodes = document.DocumentNode.SelectNodes("//fieldset[@class='fieldgroup group-information']/table/tbody/tr/td[2]/div");
                    if (fieldsetNodes !=null && fieldsetNodes.Count > 1)
                    {
                        string companyInfo = HtmlUtils.GetHtmlNodeText(fieldsetNodes[0]);
                        HtmlUtils.Log("companyInfo==========================================\r\n" + companyInfo);
                        buyerInfo.CompanyInfo = companyInfo;

                        HtmlNode node1 = fieldsetNodes[0].SelectSingleNode("div[2]");//公司
                        string companyName = HtmlUtils.GetHtmlNodeText(node1);
                        HtmlUtils.Log("companyName==========================================\r\n" + companyName);
                        buyerInfo.CompanyName = companyName;

                        string contactInfo = HtmlUtils.GetHtmlNodeText(fieldsetNodes[1]);//ContactInfo
                        HtmlUtils.Log("contactInfo==========================================\r\n" + contactInfo);
                        buyerInfo.ContactInfo = contactInfo;

                        buyerInfo.Emails = HtmlUtils.getEmails(contactInfo);//Emails
                        Regex r = new Regex(@"Contact Person \(联系人\):(.*?)\n");
                        GroupCollection gc = r.Match(contactInfo).Groups;
                        if (gc != null && gc.Count > 1)
                        {
                            string person = gc[1].Value.Trim();
                            HtmlUtils.Log("person==========================================\r\n" + person);
                            buyerInfo.BuyerName = person;
                        }
                        if (string.IsNullOrEmpty(buyerInfo.BuyerName))
                        {
                            r = new Regex(@"Contact Person:(.*?)\n");
                            gc = r.Match(contactInfo).Groups;
                            if (gc != null && gc.Count > 1)
                            {
                                string person = gc[1].Value.Trim();
                                HtmlUtils.Log("person==========================================\r\n" + person);
                                buyerInfo.BuyerName = person;
                            }
                        }
                    }
                    HtmlNode categoryNode = document.DocumentNode.SelectSingleNode("//fieldset[@class='fieldgroup group-industry']/table/tbody/tr/td/div/div[2]");
                    string categoryInfo = HtmlUtils.GetHtmlNodeText(categoryNode);
                    buyerInfo.Category = categoryInfo;
                }
                else
                {
                    buyerInfo.Type = "Company";
                    HtmlNodeCollection fieldsetNodes = document.DocumentNode.SelectNodes("//fieldset[@class='fieldgroup group-information']/table/tbody/tr/td[2]");
                    if (fieldsetNodes != null && fieldsetNodes.Count > 1)
                    {
                        string companyInfo = HtmlUtils.GetHtmlNodeText(fieldsetNodes[0]);
                        HtmlUtils.Log("companyInfo==========================================\r\n" + companyInfo);
                        buyerInfo.CompanyInfo = companyInfo;

                        HtmlNode node1 = fieldsetNodes[0].SelectSingleNode("div/div[2]");//公司
                        string companyName = HtmlUtils.GetHtmlNodeText(node1);
                        HtmlUtils.Log("companyName==========================================\r\n" + companyName);
                        buyerInfo.CompanyName = companyName;

                        node1 = fieldsetNodes[1].SelectSingleNode("div/div[2]");//Contact Method
                        string contactInfo = HtmlUtils.GetHtmlNodeText(node1);
                        HtmlUtils.Log("contactInfo==========================================\r\n" + contactInfo);
                        buyerInfo.ContactInfo = contactInfo;

                        Regex r = new Regex(@"Contact Person:(.*?)\n");
                        GroupCollection gc = r.Match(contactInfo).Groups;
                        if (gc != null && gc.Count > 1)
                        {
                            string person = gc[1].Value.Trim();
                            HtmlUtils.Log("person==========================================\r\n" + person);
                            buyerInfo.BuyerName = person;
                        }
                        buyerInfo.Emails = HtmlUtils.getEmails(contactInfo);
                    }
                    HtmlNode categoryNode = document.DocumentNode.SelectSingleNode("//fieldset[@class='fieldgroup group-industry']/table/tbody/tr/td/div/div/div[2]");
                    string categoryInfo = HtmlUtils.GetHtmlNodeText(categoryNode);
                    buyerInfo.Category = categoryInfo;
                }
            }

            if (url.IndexOf("/inquiry/") > 0 || url.IndexOf("/content/") > 0 )
            {
                buyerInfo.Type = "Inquiry";
                HtmlNodeCollection fieldsetNodes = document.DocumentNode.SelectNodes("//fieldset[@class='fieldgroup group-information']/table/tbody/tr/td[2]");
                if (fieldsetNodes != null && fieldsetNodes.Count > 1)
                {
                    string companyInfo = HtmlUtils.GetHtmlNodeText(fieldsetNodes[0]);
                    HtmlUtils.Log("companyInfo==========================================\r\n" + companyInfo);
                    buyerInfo.CompanyInfo = companyInfo;

                    HtmlNode node1 = fieldsetNodes[1].SelectSingleNode("div/div[2]");//Contact Method
                    string contactInfo = HtmlUtils.GetHtmlNodeText(node1);
                    HtmlUtils.Log("contactInfo==========================================\r\n" + contactInfo);
                    buyerInfo.ContactInfo = contactInfo;

                    Regex r = new Regex(@"Contact Person:(.*?)\n");
                    GroupCollection gc = r.Match(contactInfo).Groups;
                    if (gc != null && gc.Count > 1)
                    {
                        string person = gc[1].Value.Trim();
                        HtmlUtils.Log("person==========================================\r\n" + person);
                        buyerInfo.BuyerName = person;
                    }
                    r = new Regex(@"Company:(.*?)\n");
                    gc = r.Match(contactInfo).Groups;
                    if (gc != null && gc.Count > 1)
                    {
                        string company = gc[1].Value.Trim();
                        HtmlUtils.Log("Company:==========================================\r\n" + company);
                        buyerInfo.CompanyName = company;
                    }
                    if (string.IsNullOrEmpty(buyerInfo.CompanyName))
                    {
                        r = new Regex(@"Co:(.*?)\n");
                        gc = r.Match(contactInfo).Groups;
                        if (gc != null && gc.Count > 1)
                        {
                            string company = gc[1].Value.Trim();
                            HtmlUtils.Log("Company:==========================================\r\n" + company);
                            buyerInfo.CompanyName = company;
                        }
                    }
                    buyerInfo.Emails = HtmlUtils.getEmails(contactInfo);
                }
                HtmlNode categoryNode = document.DocumentNode.SelectSingleNode("//fieldset[@class='fieldgroup group-industry']/table/tbody/tr/td/div/div[2]");
                string categoryInfo = HtmlUtils.GetHtmlNodeText(categoryNode);
                buyerInfo.Category = categoryInfo;

            }
            return buyerInfo;
        }