public int Add(ProductInfo model) { using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertProduct")) { cmd.SetParameterValue("@id", model.Id); cmd.SetParameterValue("@title", model.Title); cmd.SetParameterValue("@cid", model.CategoryId); cmd.SetParameterValue("@price", model.Price); cmd.SetParameterValue("@desc", model.Desc); cmd.SetParameterValue("@content", model.Content); cmd.SetParameterValue("@isonline", model.IsOnline); cmd.SetParameterValue("@bigpicture", model.BigPicture); cmd.SetParameterValue("@smallpicture", model.SmallPicture); cmd.SetParameterValue("@mediumpicture", model.MediumPicture); cmd.SetParameterValue("@specifications", model.Specifications); cmd.SetParameterValue("@afterservice", model.AfterService); cmd.SetParameterValue("@UserId", model.UserId); cmd.SetParameterValue("@InDate", model.InDate); cmd.SetParameterValue("@FileUrl", model.FileUrl); cmd.SetParameterValue("@Keywords", model.Keywords); cmd.SetParameterValue("@MetaDesc", model.MetaDesc); cmd.SetParameterValue("@DisplayOrder", model.DisplayOrder); return cmd.ExecuteNonQuery(); } }
public object UpdateProduct() { var model = new ProductInfo(); model.Id = Convert.ToInt32(HttpContext.Current.Request.Params["ProductId"]); model.Title = (string)HttpContext.Current.Request.Params["title"]; model.CategoryId = Convert.ToInt32(HttpContext.Current.Request.Params["productCategory"]); //model.Price = Convert.ToDouble(HttpContext.Current.Request.Params["price"]); model.Content = (string)HttpContext.Current.Request.Params["Content"]; model.Desc = (string)HttpContext.Current.Request.Params["Desc"];//产品简介 //model.IsOnline = HttpContext.Current.Request.Params["isonline"]; model.BigPicture = HttpContext.Current.Request.Params["bigpicture"]; model.SmallPicture = HttpContext.Current.Request.Params["smallpicture"]; model.MediumPicture = (string)HttpContext.Current.Request.Params["mediumpicture"]; model.Specifications = (string)HttpContext.Current.Request.Params["specifications"]; model.AfterService = (string)HttpContext.Current.Request.Params["afterservice"]; model.InDate = DateTime.Now; model.FileUrl = HttpContext.Current.Request.Params["filedown"]; model.Keywords = HttpContext.Current.Request.Params["Keywords"]; model.MetaDesc = HttpContext.Current.Request.Params["Description"]; IProductService productService = new ProductService(); return productService.Update(model) > 0; }
public void HtmlAgilityPack_Demo01() { var list = new List<string>(); list.Add("2"); list.Add("3"); list.Add("4"); list.Add("5"); list.Add("7"); list.Add("8"); list.Add("9"); list.Add("10"); list.Add("11"); list.Add("12"); list.Add("13"); list.Add("14"); list.Add("15"); list.Add("16"); list.Add("17"); list.Add("18"); list.Add("19"); list.Add("20"); list.Add("21"); list.Add("22"); list.Add("23"); list.Add("24"); list.Add("25"); list.Add("26"); list.Add("27"); list.Add("28"); list.Add("29"); list.Add("31"); foreach (string s in list) { var webGet = new HtmlWeb(); HttpClient httpClient1 = new HttpClient("http://www.yihui-lighting.com/productshow.asp?id="+s); HtmlAgilityPack.HtmlDocument htmlDocument1 = new HtmlAgilityPack.HtmlDocument(); htmlDocument1.LoadHtml(httpClient1.Request()); var document = htmlDocument1; var data = document.DocumentNode.SelectNodes("//*[@id=\"mitte2\"]"); StringBuilder sb = new StringBuilder(); int i = 0; foreach (HtmlNode htmlNode in data) { var images = document.DocumentNode.SelectNodes("//img"); if (images != null && images.Count > 0) { int j = 0; foreach (HtmlNode imageNode in images) { j++; WebClient webClient = new WebClient(); var dir = "images\\content"; string filepath = "z:\\upload\\" + dir; if (!Directory.Exists(filepath)) { Directory.CreateDirectory("z:\\upload\\" + dir); } if (imageNode.Attributes["src"].Value != null) { try { string url = "http://www.yihui-lighting.com/UpProduct"; downloadfile(url + "//" + imageNode.Attributes["src"].Value.Substring(imageNode.Attributes["src"].Value.LastIndexOf('/') + 1), imageNode.Attributes["src"].Value.Substring(imageNode.Attributes["src"].Value.LastIndexOf('/') + 1)); } catch { } } } } if (!string.IsNullOrEmpty(htmlNode.InnerText)) { // var titleNode = document.DocumentNode.SelectSingleNode( "/html/body/div/div[3]/div[3]/div[2]/div/h2/font"); var title = titleNode.InnerText??""; var body = htmlNode.InnerHtml.Replace("UpProduct/", "upload/images/content/")??""; var model = new ProductInfo(); model.Title = title; model.CategoryId = 2; model.Content = body; model.InDate = DateTime.Now; model.DisplayOrder = OrderGenerator.NewOrder(); IProductService productService = new ProductService(); try { productService.Add(model); } catch { } } } } }
public ProductInfo GetProductById(int id) { ProductInfo model = new ProductInfo(); model.Category = new ProductCategoryInfo(); using (DataCommand cmd = DataCommandManager.GetDataCommand("GetProductById")) { cmd.SetParameterValue("@id", id); using (IDataReader dr = cmd.ExecuteDataReader()) { while (dr.Read()) { if (!Convert.IsDBNull(dr["id"])) { model.Id = Convert.ToInt32(dr["id"]); } if (!Convert.IsDBNull(dr["title"])) { model.Title = dr["title"].ToString(); } if (!Convert.IsDBNull(dr["cid"])) { model.CategoryId = (int)dr["cid"]; model.Category.Id = Convert.ToInt32(dr["cid"]); } if (!Convert.IsDBNull(dr["price"])) { model.Price = (double)dr["Price"]; } if (!Convert.IsDBNull(dr["desc"])) { model.Desc = dr["desc"].ToString(); } if (!Convert.IsDBNull(dr["content"])) { model.Content = dr["content"].ToString(); } if (!Convert.IsDBNull(dr["isonline"])) { model.IsOnline = (bool)dr["IsOnline"]; } if (!Convert.IsDBNull(dr["bigpicture"])) { model.BigPicture = dr["BigPicture"].ToString(); } if (!Convert.IsDBNull(dr["smallpicture"])) { model.SmallPicture = dr["SmallPicture"].ToString(); } if (!Convert.IsDBNull(dr["mediumpicture"])) { model.MediumPicture = dr["MediumPicture"].ToString(); } if (!Convert.IsDBNull(dr["specifications"])) { model.Specifications = dr["Specifications"].ToString(); } if (!Convert.IsDBNull(dr["afterService"])) { model.AfterService = dr["afterService"].ToString(); } if(!Convert.IsDBNull(dr["CategoryName"])) { model.CategoryName = dr["CategoryName"].ToString(); } if(!Convert.IsDBNull(dr["InDate"])) { model.InDate = Convert.ToDateTime(dr["Indate"]); } if (!Convert.IsDBNull(dr["FileUrl"])) { model.FileUrl = dr["FileUrl"].ToString(); } if (!Convert.IsDBNull(dr["IsFocusPicture"])) { model.IsFocusPicture = Convert.ToBoolean(dr["IsFocusPicture"]); } if (!Convert.IsDBNull(dr["Keywords"])) { model.Keywords = dr["Keywords"].ToString(); } if (!Convert.IsDBNull(dr["MetaDesc"])) { model.MetaDesc = dr["MetaDesc"].ToString(); } if(!Convert.IsDBNull(dr["DataStatus"])) { model.Category.DataStatus = Convert.ToInt32(dr["DataStatus"]); } } } } return model; }
private ProductInfo GetModelFromDataReader(IDataReader dr) { var model = new ProductInfo(); model.Category=new ProductCategoryInfo(); if (!Convert.IsDBNull(dr["Id"])) { model.Id = (int)dr["Id"]; } if (!Convert.IsDBNull(dr["Title"])) { model.Title = (string)dr["Title"]; } if (!Convert.IsDBNull(dr["CategoryName"])) { model.CategoryName = Convert.ToString(dr["CategoryName"]); } if (!Convert.IsDBNull(dr["CId"])) { model.CategoryId = (int)dr["CId"]; } if (!Convert.IsDBNull(dr["Price"])) { model.Price = (double)dr["Price"]; } if (!Convert.IsDBNull(dr["Desc"])) { model.Desc = (string)dr["Desc"]; } if (!Convert.IsDBNull(dr["content"])) { model.Content = dr["content"].ToString(); } if (!Convert.IsDBNull(dr["IsOnline"])) { model.IsOnline = (bool)dr["IsOnline"]; } if (!Convert.IsDBNull(dr["BigPicture"])) { model.BigPicture = (string)dr["BigPicture"]; } if (!Convert.IsDBNull(dr["SmallPicture"])) { model.SmallPicture = (string)dr["SmallPicture"]; } if (!Convert.IsDBNull(dr["MediumPicture"])) { model.MediumPicture = (string)dr["MediumPicture"]; } if (!Convert.IsDBNull(dr["Specifications"])) { model.Specifications = (string)dr["Specifications"]; } if (!Convert.IsDBNull(dr["AfterService"])) { model.AfterService = (string)dr["AfterService"]; } if (!Convert.IsDBNull(dr["InDate"])) { model.InDate = Convert.ToDateTime(dr["Indate"]); } if (!Convert.IsDBNull(dr["FileUrl"])) { model.FileUrl = dr["FileUrl"].ToString(); } if (!Convert.IsDBNull(dr["IsFocusPicture"])) { model.IsFocusPicture = Convert.ToBoolean(dr["IsFocusPicture"]); } if (!Convert.IsDBNull(dr["Keywords"])) { model.Keywords = dr["Keywords"].ToString(); } if (!Convert.IsDBNull(dr["MetaDesc"])) { model.MetaDesc = dr["MetaDesc"].ToString(); } if (!Convert.IsDBNull(dr["DataStatus"])) { model.Category.DataStatus = Convert.ToInt32(dr["DataStatus"]); } if (!Convert.IsDBNull(dr["DisplayOrder"])) { model.DisplayOrder = Convert.ToInt64(dr["DisplayOrder"]); } return model; }