Exemple #1
0
 private void ParseProduct(ref Entities.CrawlerProduct.RabbitMQ.MsProduct product, Row row)
 {
     product.Product_Id = Convert.ToInt64(row.GetValue(typeof(object), "product_id"));
     product.Name       = row.GetValue(typeof(object), "name").ToString();
     product.Note       = row.GetValue(typeof(object), "note").ToString();
     product.Price      = Convert.ToInt64(row.GetValue(typeof(object), "price"));
     product.DateSearch = Convert.ToInt64(row.GetValue(typeof(object), "date_search"));
     if (product.DateSearch > 0)
     {
         string str       = product.DateSearch.ToString();
         string strYear   = str.Substring(0, 2);
         string strMonth  = str.Substring(2, 2);
         string strDay    = str.Substring(4, 2);
         string strHour   = str.Substring(6, 2);
         string strMinute = str.Substring(8, 2);
         str = strMonth + "/" + strDay + "/" + "20" + strYear + " " + strHour + ":" + strMinute;
         DateTime date = Convert.ToDateTime(str);
         product.Date = date;
     }
     else
     {
         product.Date = null;
     }
     product.Classification = row.GetValue(typeof(object), "classification").ToString();
     product.Url            = QT.Entities.Common.Obj2String(row.GetValue(typeof(object), "url"));
     product.Is_Black_Link  = QT.Entities.Common.Obj2Bool(row.GetValue(typeof(object), "is_black_list"));
 }
Exemple #2
0
        public List <QT.Entities.CrawlerProduct.RabbitMQ.MsProduct> GetDetailSession(string session)
        {
            List <QT.Entities.CrawlerProduct.RabbitMQ.MsProduct> lst = new List <Entities.CrawlerProduct.RabbitMQ.MsProduct>();
            string            query  = string.Format(this.querySelectBySession, session);
            RowSet            rowSet = _session.Execute(query);
            IEnumerable <Row> rows   = rowSet.GetRows();

            foreach (Row row in rows)
            {
                QT.Entities.CrawlerProduct.RabbitMQ.MsProduct product = new Entities.CrawlerProduct.RabbitMQ.MsProduct();
                ParseProduct(ref product, row);
                lst.Add(product);
            }
            return(lst);
        }