/// <summary> /// 获得数据列表 /// </summary> public List <Chenduo.Model.Hishop_Products> DataTableToList(DataTable dt) { List <Chenduo.Model.Hishop_Products> modelList = new List <Chenduo.Model.Hishop_Products>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Chenduo.Model.Hishop_Products model; for (int n = 0; n < rowsCount; n++) { model = new Chenduo.Model.Hishop_Products(); if (dt.Rows[n]["ProductId"].ToString() != "") { model.ProductId = int.Parse(dt.Rows[n]["ProductId"].ToString()); } model.wid = dt.Rows[n]["wid"].ToString(); if (dt.Rows[n]["CategoryId"].ToString() != "") { model.CategoryId = int.Parse(dt.Rows[n]["CategoryId"].ToString()); } if (dt.Rows[n]["TypeId"].ToString() != "") { model.TypeId = int.Parse(dt.Rows[n]["TypeId"].ToString()); } model.ProductName = dt.Rows[n]["ProductName"].ToString(); model.ProductCode = dt.Rows[n]["ProductCode"].ToString(); model.ShortDescription = dt.Rows[n]["ShortDescription"].ToString(); model.Unit = dt.Rows[n]["Unit"].ToString(); model.Description = dt.Rows[n]["Description"].ToString(); if (dt.Rows[n]["SaleStatus"].ToString() != "") { model.SaleStatus = int.Parse(dt.Rows[n]["SaleStatus"].ToString()); } if (dt.Rows[n]["AddedDate"].ToString() != "") { model.AddedDate = DateTime.Parse(dt.Rows[n]["AddedDate"].ToString()); } if (dt.Rows[n]["VistiCounts"].ToString() != "") { model.VistiCounts = int.Parse(dt.Rows[n]["VistiCounts"].ToString()); } if (dt.Rows[n]["SalePrice"].ToString() != "") { model.SalePrice = decimal.Parse(dt.Rows[n]["SalePrice"].ToString()); } model.SkuId = dt.Rows[n]["SkuId"].ToString(); if (dt.Rows[n]["Stock"].ToString() != "") { model.Stock = int.Parse(dt.Rows[n]["Stock"].ToString()); } if (dt.Rows[n]["Weight"].ToString() != "") { model.Weight = decimal.Parse(dt.Rows[n]["Weight"].ToString()); } if (dt.Rows[n]["IsMakeTaobao"].ToString() != "") { model.IsMakeTaobao = int.Parse(dt.Rows[n]["IsMakeTaobao"].ToString()); } if (dt.Rows[n]["SaleCounts"].ToString() != "") { model.SaleCounts = int.Parse(dt.Rows[n]["SaleCounts"].ToString()); } if (dt.Rows[n]["ShowSaleCounts"].ToString() != "") { model.ShowSaleCounts = int.Parse(dt.Rows[n]["ShowSaleCounts"].ToString()); } if (dt.Rows[n]["DisplaySequence"].ToString() != "") { model.DisplaySequence = int.Parse(dt.Rows[n]["DisplaySequence"].ToString()); } /* * model.ImageUrl1 = SFUtils.getWebSite() + dt.Rows[n]["ImageUrl1"].ToString(); * model.ImageUrl2 = SFUtils.getWebSite() + dt.Rows[n]["ImageUrl2"].ToString(); * model.ImageUrl3 = SFUtils.getWebSite() + dt.Rows[n]["ImageUrl3"].ToString(); * model.ImageUrl4 = SFUtils.getWebSite() + dt.Rows[n]["ImageUrl4"].ToString(); * model.ImageUrl5 = SFUtils.getWebSite() + dt.Rows[n]["ImageUrl5"].ToString(); * model.ThumbnailUrl40 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl40"].ToString(); * model.ThumbnailUrl60 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl60"].ToString(); * model.ThumbnailUrl100 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl100"].ToString(); * model.ThumbnailUrl160 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl160"].ToString(); * model.ThumbnailUrl180 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl180"].ToString(); * model.ThumbnailUrl220 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl220"].ToString(); * model.ThumbnailUrl310 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl310"].ToString(); * model.ThumbnailUrl410 = SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl410"].ToString(); */ model.ImageUrl1 = dt.Rows[n]["ImageUrl1"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ImageUrl1"].ToString() : ""; model.ImageUrl2 = dt.Rows[n]["ImageUrl2"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ImageUrl2"].ToString() : ""; model.ImageUrl3 = dt.Rows[n]["ImageUrl3"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ImageUrl3"].ToString() : ""; model.ImageUrl4 = dt.Rows[n]["ImageUrl4"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ImageUrl4"].ToString() : ""; model.ImageUrl5 = dt.Rows[n]["ImageUrl5"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ImageUrl5"].ToString() : ""; model.ThumbnailUrl40 = dt.Rows[n]["ThumbnailUrl40"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl40"].ToString() : ""; model.ThumbnailUrl60 = dt.Rows[n]["ThumbnailUrl60"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl60"].ToString() : ""; model.ThumbnailUrl100 = dt.Rows[n]["ThumbnailUrl100"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl100"].ToString() : ""; model.ThumbnailUrl160 = dt.Rows[n]["ThumbnailUrl160"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl160"].ToString() : ""; model.ThumbnailUrl180 = dt.Rows[n]["ThumbnailUrl180"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl180"].ToString() : ""; model.ThumbnailUrl220 = dt.Rows[n]["ThumbnailUrl220"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl220"].ToString() : ""; model.ThumbnailUrl310 = dt.Rows[n]["ThumbnailUrl310"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl310"].ToString() : ""; model.ThumbnailUrl410 = dt.Rows[n]["ThumbnailUrl410"].ToString() != "" ? SFUtils.getWebSite() + dt.Rows[n]["ThumbnailUrl410"].ToString() : ""; if (dt.Rows[n]["MarketPrice"].ToString() != "") { model.MarketPrice = decimal.Parse(dt.Rows[n]["MarketPrice"].ToString()); } if (dt.Rows[n]["BrandId"].ToString() != "") { model.BrandId = int.Parse(dt.Rows[n]["BrandId"].ToString()); } model.MainCategoryPath = dt.Rows[n]["MainCategoryPath"].ToString(); model.ExtendCategoryPath = dt.Rows[n]["ExtendCategoryPath"].ToString(); if (dt.Rows[n]["HasSKU"].ToString() != "") { if ((dt.Rows[n]["HasSKU"].ToString() == "1") || (dt.Rows[n]["HasSKU"].ToString().ToLower() == "true")) { model.HasSKU = true; } else { model.HasSKU = false; } } if (dt.Rows[n]["IsfreeShipping"].ToString() != "") { if ((dt.Rows[n]["IsfreeShipping"].ToString() == "1") || (dt.Rows[n]["IsfreeShipping"].ToString().ToLower() == "true")) { model.IsfreeShipping = true; } else { model.IsfreeShipping = false; } } //model.TaobaoProductId=dt.Rows[n]["TaobaoProductId"].ToString(); model.Source = dt.Rows[n]["Source"].ToString(); if (dt.Rows[n]["MinShowPrice"].ToString() != "") { model.MinShowPrice = decimal.Parse(dt.Rows[n]["MinShowPrice"].ToString()); } if (dt.Rows[n]["MaxShowPrice"].ToString() != "") { model.MaxShowPrice = decimal.Parse(dt.Rows[n]["MaxShowPrice"].ToString()); } if (dt.Rows[n]["FreightTemplateId"].ToString() != "") { model.FreightTemplateId = int.Parse(dt.Rows[n]["FreightTemplateId"].ToString()); } if (dt.Rows[n]["FirstCommission"].ToString() != "") { model.FirstCommission = decimal.Parse(dt.Rows[n]["FirstCommission"].ToString()); } if (dt.Rows[n]["SecondCommission"].ToString() != "") { model.SecondCommission = decimal.Parse(dt.Rows[n]["SecondCommission"].ToString()); } if (dt.Rows[n]["ThirdCommission"].ToString() != "") { model.ThirdCommission = decimal.Parse(dt.Rows[n]["ThirdCommission"].ToString()); } if (dt.Rows[n]["IsSetCommission"].ToString() != "") { if ((dt.Rows[n]["IsSetCommission"].ToString() == "1") || (dt.Rows[n]["IsSetCommission"].ToString().ToLower() == "true")) { model.IsSetCommission = true; } else { model.IsSetCommission = false; } } if (dt.Rows[n]["CubicMeter"].ToString() != "") { model.CubicMeter = decimal.Parse(dt.Rows[n]["CubicMeter"].ToString()); } if (dt.Rows[n]["FreightWeight"].ToString() != "") { model.FreightWeight = decimal.Parse(dt.Rows[n]["FreightWeight"].ToString()); } model.ProductShortName = dt.Rows[n]["ProductShortName"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Chenduo.Model.Hishop_Products model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Chenduo.Model.Hishop_Products model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Chenduo.Model.Hishop_Products model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Hishop_Products("); strSql.Append("wid,CategoryId,TypeId,ProductName,ProductCode,ShortDescription,Unit,Description,SaleStatus,AddedDate,VistiCounts,SaleCounts,ShowSaleCounts,DisplaySequence,ImageUrl1,ImageUrl2,ImageUrl3,ImageUrl4,ImageUrl5,ThumbnailUrl40,ThumbnailUrl60,ThumbnailUrl100,ThumbnailUrl160,ThumbnailUrl180,ThumbnailUrl220,ThumbnailUrl310,ThumbnailUrl410,MarketPrice,BrandId,MainCategoryPath,ExtendCategoryPath,HasSKU,IsfreeShipping,TaobaoProductId,Source,MinShowPrice,MaxShowPrice,FreightTemplateId,FirstCommission,SecondCommission,ThirdCommission,IsSetCommission,CubicMeter,FreightWeight,ProductShortName)"); strSql.Append(" values ("); strSql.Append("@wid,@CategoryId,@TypeId,@ProductName,@ProductCode,@ShortDescription,@Unit,@Description,@SaleStatus,@AddedDate,@VistiCounts,@SaleCounts,@ShowSaleCounts,@DisplaySequence,@ImageUrl1,@ImageUrl2,@ImageUrl3,@ImageUrl4,@ImageUrl5,@ThumbnailUrl40,@ThumbnailUrl60,@ThumbnailUrl100,@ThumbnailUrl160,@ThumbnailUrl180,@ThumbnailUrl220,@ThumbnailUrl310,@ThumbnailUrl410,@MarketPrice,@BrandId,@MainCategoryPath,@ExtendCategoryPath,@HasSKU,@IsfreeShipping,@TaobaoProductId,@Source,@MinShowPrice,@MaxShowPrice,@FreightTemplateId,@FirstCommission,@SecondCommission,@ThirdCommission,@IsSetCommission,@CubicMeter,@FreightWeight,@ProductShortName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@wid", SqlDbType.NVarChar, 50), new SqlParameter("@CategoryId", SqlDbType.Int, 4), new SqlParameter("@TypeId", SqlDbType.Int, 4), new SqlParameter("@ProductName", SqlDbType.NVarChar, 200), new SqlParameter("@ProductCode", SqlDbType.NVarChar, 50), new SqlParameter("@ShortDescription", SqlDbType.NVarChar, 2000), new SqlParameter("@Unit", SqlDbType.NVarChar, 50), new SqlParameter("@Description", SqlDbType.NText), new SqlParameter("@SaleStatus", SqlDbType.Int, 4), new SqlParameter("@AddedDate", SqlDbType.DateTime), new SqlParameter("@VistiCounts", SqlDbType.Int, 4), new SqlParameter("@SaleCounts", SqlDbType.Int, 4), new SqlParameter("@ShowSaleCounts", SqlDbType.Int, 4), new SqlParameter("@DisplaySequence", SqlDbType.Int, 4), new SqlParameter("@ImageUrl1", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl2", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl3", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl4", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl5", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl40", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl60", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl100", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl160", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl180", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl220", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl310", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl410", SqlDbType.NVarChar, 255), new SqlParameter("@MarketPrice", SqlDbType.Money, 8), new SqlParameter("@BrandId", SqlDbType.Int, 4), new SqlParameter("@MainCategoryPath", SqlDbType.NVarChar, 256), new SqlParameter("@ExtendCategoryPath", SqlDbType.NVarChar, 256), new SqlParameter("@HasSKU", SqlDbType.Bit, 1), new SqlParameter("@IsfreeShipping", SqlDbType.Bit, 1), new SqlParameter("@TaobaoProductId", SqlDbType.BigInt, 8), new SqlParameter("@Source", SqlDbType.VarChar, 1), new SqlParameter("@MinShowPrice", SqlDbType.Money, 8), new SqlParameter("@MaxShowPrice", SqlDbType.Money, 8), new SqlParameter("@FreightTemplateId", SqlDbType.Int, 4), new SqlParameter("@FirstCommission", SqlDbType.Decimal, 9), new SqlParameter("@SecondCommission", SqlDbType.Decimal, 9), new SqlParameter("@ThirdCommission", SqlDbType.Decimal, 9), new SqlParameter("@IsSetCommission", SqlDbType.Bit, 1), new SqlParameter("@CubicMeter", SqlDbType.Decimal, 9), new SqlParameter("@FreightWeight", SqlDbType.Decimal, 9), new SqlParameter("@ProductShortName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.wid; parameters[1].Value = model.CategoryId; parameters[2].Value = model.TypeId; parameters[3].Value = model.ProductName; parameters[4].Value = model.ProductCode; parameters[5].Value = model.ShortDescription; parameters[6].Value = model.Unit; parameters[7].Value = model.Description; parameters[8].Value = model.SaleStatus; parameters[9].Value = model.AddedDate; parameters[10].Value = model.VistiCounts; parameters[11].Value = model.SaleCounts; parameters[12].Value = model.ShowSaleCounts; parameters[13].Value = model.DisplaySequence; parameters[14].Value = model.ImageUrl1; parameters[15].Value = model.ImageUrl2; parameters[16].Value = model.ImageUrl3; parameters[17].Value = model.ImageUrl4; parameters[18].Value = model.ImageUrl5; parameters[19].Value = model.ThumbnailUrl40; parameters[20].Value = model.ThumbnailUrl60; parameters[21].Value = model.ThumbnailUrl100; parameters[22].Value = model.ThumbnailUrl160; parameters[23].Value = model.ThumbnailUrl180; parameters[24].Value = model.ThumbnailUrl220; parameters[25].Value = model.ThumbnailUrl310; parameters[26].Value = model.ThumbnailUrl410; parameters[27].Value = model.MarketPrice; parameters[28].Value = model.BrandId; parameters[29].Value = model.MainCategoryPath; parameters[30].Value = model.ExtendCategoryPath; parameters[31].Value = model.HasSKU; parameters[32].Value = model.IsfreeShipping; parameters[33].Value = model.TaobaoProductId; parameters[34].Value = model.Source; parameters[35].Value = model.MinShowPrice; parameters[36].Value = model.MaxShowPrice; parameters[37].Value = model.FreightTemplateId; parameters[38].Value = model.FirstCommission; parameters[39].Value = model.SecondCommission; parameters[40].Value = model.ThirdCommission; parameters[41].Value = model.IsSetCommission; parameters[42].Value = model.CubicMeter; parameters[43].Value = model.FreightWeight; parameters[44].Value = model.ProductShortName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Chenduo.Model.Hishop_Products GetModel(int ProductId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ProductId,wid,CategoryId,TypeId,ProductName,ProductCode,ShortDescription,Unit,Description,SaleStatus,AddedDate,VistiCounts,SaleCounts,ShowSaleCounts,DisplaySequence,ImageUrl1,ImageUrl2,ImageUrl3,ImageUrl4,ImageUrl5,ThumbnailUrl40,ThumbnailUrl60,ThumbnailUrl100,ThumbnailUrl160,ThumbnailUrl180,ThumbnailUrl220,ThumbnailUrl310,ThumbnailUrl410,MarketPrice,BrandId,MainCategoryPath,ExtendCategoryPath,HasSKU,IsfreeShipping,TaobaoProductId,Source,MinShowPrice,MaxShowPrice,FreightTemplateId,FirstCommission,SecondCommission,ThirdCommission,IsSetCommission,CubicMeter,FreightWeight,ProductShortName,SalePrice,SkuId,Stock,Weight,IsMakeTaobao from vw_Hishop_BrowseProductList "); strSql.Append(" where ProductId=@ProductId"); SqlParameter[] parameters = { new SqlParameter("@ProductId", SqlDbType.Int, 4) }; parameters[0].Value = ProductId; Chenduo.Model.Hishop_Products model = new Chenduo.Model.Hishop_Products(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ProductId"].ToString() != "") { model.ProductId = int.Parse(ds.Tables[0].Rows[0]["ProductId"].ToString()); } model.wid = ds.Tables[0].Rows[0]["wid"].ToString(); if (ds.Tables[0].Rows[0]["CategoryId"].ToString() != "") { model.CategoryId = int.Parse(ds.Tables[0].Rows[0]["CategoryId"].ToString()); } if (ds.Tables[0].Rows[0]["TypeId"].ToString() != "") { model.TypeId = int.Parse(ds.Tables[0].Rows[0]["TypeId"].ToString()); } model.ProductName = ds.Tables[0].Rows[0]["ProductName"].ToString(); model.ProductCode = ds.Tables[0].Rows[0]["ProductCode"].ToString(); model.ShortDescription = ds.Tables[0].Rows[0]["ShortDescription"].ToString(); model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString(); model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); if (ds.Tables[0].Rows[0]["SaleStatus"].ToString() != "") { model.SaleStatus = int.Parse(ds.Tables[0].Rows[0]["SaleStatus"].ToString()); } if (ds.Tables[0].Rows[0]["AddedDate"].ToString() != "") { model.AddedDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddedDate"].ToString()); } if (ds.Tables[0].Rows[0]["VistiCounts"].ToString() != "") { model.VistiCounts = int.Parse(ds.Tables[0].Rows[0]["VistiCounts"].ToString()); } if (ds.Tables[0].Rows[0]["SalePrice"].ToString() != "") { model.SalePrice = decimal.Parse(ds.Tables[0].Rows[0]["SalePrice"].ToString()); } model.SkuId = ds.Tables[0].Rows[0]["SkuId"].ToString(); if (ds.Tables[0].Rows[0]["Stock"].ToString() != "") { model.Stock = int.Parse(ds.Tables[0].Rows[0]["Stock"].ToString()); } if (ds.Tables[0].Rows[0]["Weight"].ToString() != "") { model.Weight = decimal.Parse(ds.Tables[0].Rows[0]["Weight"].ToString()); } if (ds.Tables[0].Rows[0]["IsMakeTaobao"].ToString() != "") { model.IsMakeTaobao = int.Parse(ds.Tables[0].Rows[0]["IsMakeTaobao"].ToString()); } if (ds.Tables[0].Rows[0]["SaleCounts"].ToString() != "") { model.SaleCounts = int.Parse(ds.Tables[0].Rows[0]["SaleCounts"].ToString()); } if (ds.Tables[0].Rows[0]["ShowSaleCounts"].ToString() != "") { model.ShowSaleCounts = int.Parse(ds.Tables[0].Rows[0]["ShowSaleCounts"].ToString()); } if (ds.Tables[0].Rows[0]["DisplaySequence"].ToString() != "") { model.DisplaySequence = int.Parse(ds.Tables[0].Rows[0]["DisplaySequence"].ToString()); } model.ImageUrl1 = ds.Tables[0].Rows[0]["ImageUrl1"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ImageUrl1"].ToString(): ""; model.ImageUrl2 = ds.Tables[0].Rows[0]["ImageUrl2"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ImageUrl2"].ToString():""; model.ImageUrl3 = ds.Tables[0].Rows[0]["ImageUrl3"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ImageUrl3"].ToString():""; model.ImageUrl4 = ds.Tables[0].Rows[0]["ImageUrl4"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ImageUrl4"].ToString():""; model.ImageUrl5 = ds.Tables[0].Rows[0]["ImageUrl5"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ImageUrl5"].ToString():""; model.ThumbnailUrl40 = ds.Tables[0].Rows[0]["ThumbnailUrl40"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl40"].ToString():""; model.ThumbnailUrl60 = ds.Tables[0].Rows[0]["ThumbnailUrl60"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl60"].ToString():""; model.ThumbnailUrl100 = ds.Tables[0].Rows[0]["ThumbnailUrl100"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl100"].ToString():""; model.ThumbnailUrl160 = ds.Tables[0].Rows[0]["ThumbnailUrl160"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl160"].ToString():""; model.ThumbnailUrl180 = ds.Tables[0].Rows[0]["ThumbnailUrl180"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl180"].ToString():""; model.ThumbnailUrl220 = ds.Tables[0].Rows[0]["ThumbnailUrl220"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl220"].ToString():""; model.ThumbnailUrl310 = ds.Tables[0].Rows[0]["ThumbnailUrl310"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl310"].ToString():""; model.ThumbnailUrl410 = ds.Tables[0].Rows[0]["ThumbnailUrl410"].ToString() != ""? SFUtils.getWebSite() + ds.Tables[0].Rows[0]["ThumbnailUrl410"].ToString():""; if (ds.Tables[0].Rows[0]["MarketPrice"].ToString() != "") { model.MarketPrice = decimal.Parse(ds.Tables[0].Rows[0]["MarketPrice"].ToString()); } if (ds.Tables[0].Rows[0]["BrandId"].ToString() != "") { model.BrandId = int.Parse(ds.Tables[0].Rows[0]["BrandId"].ToString()); } model.MainCategoryPath = ds.Tables[0].Rows[0]["MainCategoryPath"].ToString(); model.ExtendCategoryPath = ds.Tables[0].Rows[0]["ExtendCategoryPath"].ToString(); if (ds.Tables[0].Rows[0]["HasSKU"].ToString() != "") { if ((ds.Tables[0].Rows[0]["HasSKU"].ToString() == "1") || (ds.Tables[0].Rows[0]["HasSKU"].ToString().ToLower() == "true")) { model.HasSKU = true; } else { model.HasSKU = false; } } if (ds.Tables[0].Rows[0]["IsfreeShipping"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsfreeShipping"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsfreeShipping"].ToString().ToLower() == "true")) { model.IsfreeShipping = true; } else { model.IsfreeShipping = false; } } if (ds.Tables[0].Rows[0]["TaobaoProductId"].ToString() != "") { model.TaobaoProductId = long.Parse(ds.Tables[0].Rows[0]["TaobaoProductId"].ToString()); } model.Source = ds.Tables[0].Rows[0]["Source"].ToString(); if (ds.Tables[0].Rows[0]["MinShowPrice"].ToString() != "") { model.MinShowPrice = decimal.Parse(ds.Tables[0].Rows[0]["MinShowPrice"].ToString()); } if (ds.Tables[0].Rows[0]["MaxShowPrice"].ToString() != "") { model.MaxShowPrice = decimal.Parse(ds.Tables[0].Rows[0]["MaxShowPrice"].ToString()); } if (ds.Tables[0].Rows[0]["FreightTemplateId"].ToString() != "") { model.FreightTemplateId = int.Parse(ds.Tables[0].Rows[0]["FreightTemplateId"].ToString()); } if (ds.Tables[0].Rows[0]["FirstCommission"].ToString() != "") { model.FirstCommission = decimal.Parse(ds.Tables[0].Rows[0]["FirstCommission"].ToString()); } if (ds.Tables[0].Rows[0]["SecondCommission"].ToString() != "") { model.SecondCommission = decimal.Parse(ds.Tables[0].Rows[0]["SecondCommission"].ToString()); } if (ds.Tables[0].Rows[0]["ThirdCommission"].ToString() != "") { model.ThirdCommission = decimal.Parse(ds.Tables[0].Rows[0]["ThirdCommission"].ToString()); } if (ds.Tables[0].Rows[0]["IsSetCommission"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsSetCommission"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSetCommission"].ToString().ToLower() == "true")) { model.IsSetCommission = true; } else { model.IsSetCommission = false; } } if (ds.Tables[0].Rows[0]["CubicMeter"].ToString() != "") { model.CubicMeter = decimal.Parse(ds.Tables[0].Rows[0]["CubicMeter"].ToString()); } if (ds.Tables[0].Rows[0]["FreightWeight"].ToString() != "") { model.FreightWeight = decimal.Parse(ds.Tables[0].Rows[0]["FreightWeight"].ToString()); } model.ProductShortName = ds.Tables[0].Rows[0]["ProductShortName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Chenduo.Model.Hishop_Products model) { string website = SFUtils.getWebSite(); model.ImageUrl1 = model.ImageUrl1 != "" ? model.ImageUrl1.Replace(website, "") : ""; model.ImageUrl2 = model.ImageUrl2 != "" ? model.ImageUrl2.Replace(website, "") : ""; model.ImageUrl3 = model.ImageUrl3 != "" ? model.ImageUrl3.Replace(website, "") : ""; model.ImageUrl4 = model.ImageUrl1 != "" ? model.ImageUrl4.Replace(website, "") : ""; model.ImageUrl5 = model.ImageUrl1 != "" ? model.ImageUrl5.Replace(website, "") : ""; model.ThumbnailUrl40 = model.ThumbnailUrl40 != "" ? model.ThumbnailUrl40.Replace(website, "") : ""; model.ThumbnailUrl60 = model.ThumbnailUrl60 != "" ? model.ThumbnailUrl60.Replace(website, "") : ""; model.ThumbnailUrl100 = model.ThumbnailUrl100 != "" ? model.ThumbnailUrl100.Replace(website, "") : ""; model.ThumbnailUrl160 = model.ThumbnailUrl160 != "" ? model.ThumbnailUrl160.Replace(website, "") : ""; model.ThumbnailUrl180 = model.ThumbnailUrl180 != "" ? model.ThumbnailUrl180.Replace(website, "") : ""; model.ThumbnailUrl220 = model.ThumbnailUrl220 != "" ? model.ThumbnailUrl220.Replace(website, "") : ""; model.ThumbnailUrl310 = model.ThumbnailUrl310 != "" ? model.ThumbnailUrl310.Replace(website, "") : ""; model.ThumbnailUrl410 = model.ThumbnailUrl410 != "" ? model.ThumbnailUrl410.Replace(website, "") : ""; StringBuilder strSql = new StringBuilder(); strSql.Append("update Hishop_Products set "); strSql.Append("wid=@wid,"); strSql.Append("CategoryId=@CategoryId,"); strSql.Append("TypeId=@TypeId,"); strSql.Append("ProductName=@ProductName,"); strSql.Append("ProductCode=@ProductCode,"); strSql.Append("ShortDescription=@ShortDescription,"); strSql.Append("Unit=@Unit,"); strSql.Append("Description=@Description,"); strSql.Append("SaleStatus=@SaleStatus,"); strSql.Append("AddedDate=@AddedDate,"); strSql.Append("VistiCounts=@VistiCounts,"); strSql.Append("SaleCounts=@SaleCounts,"); strSql.Append("ShowSaleCounts=@ShowSaleCounts,"); strSql.Append("DisplaySequence=@DisplaySequence,"); strSql.Append("ImageUrl1=@ImageUrl1,"); strSql.Append("ImageUrl2=@ImageUrl2,"); strSql.Append("ImageUrl3=@ImageUrl3,"); strSql.Append("ImageUrl4=@ImageUrl4,"); strSql.Append("ImageUrl5=@ImageUrl5,"); strSql.Append("ThumbnailUrl40=@ThumbnailUrl40,"); strSql.Append("ThumbnailUrl60=@ThumbnailUrl60,"); strSql.Append("ThumbnailUrl100=@ThumbnailUrl100,"); strSql.Append("ThumbnailUrl160=@ThumbnailUrl160,"); strSql.Append("ThumbnailUrl180=@ThumbnailUrl180,"); strSql.Append("ThumbnailUrl220=@ThumbnailUrl220,"); strSql.Append("ThumbnailUrl310=@ThumbnailUrl310,"); strSql.Append("ThumbnailUrl410=@ThumbnailUrl410,"); strSql.Append("MarketPrice=@MarketPrice,"); strSql.Append("BrandId=@BrandId,"); strSql.Append("MainCategoryPath=@MainCategoryPath,"); strSql.Append("ExtendCategoryPath=@ExtendCategoryPath,"); strSql.Append("HasSKU=@HasSKU,"); strSql.Append("IsfreeShipping=@IsfreeShipping,"); strSql.Append("TaobaoProductId=@TaobaoProductId,"); strSql.Append("Source=@Source,"); strSql.Append("MinShowPrice=@MinShowPrice,"); strSql.Append("MaxShowPrice=@MaxShowPrice,"); strSql.Append("FreightTemplateId=@FreightTemplateId,"); strSql.Append("FirstCommission=@FirstCommission,"); strSql.Append("SecondCommission=@SecondCommission,"); strSql.Append("ThirdCommission=@ThirdCommission,"); strSql.Append("IsSetCommission=@IsSetCommission,"); strSql.Append("CubicMeter=@CubicMeter,"); strSql.Append("FreightWeight=@FreightWeight,"); strSql.Append("ProductShortName=@ProductShortName"); strSql.Append(" where ProductId=@ProductId"); SqlParameter[] parameters = { new SqlParameter("@ProductId", SqlDbType.Int, 4), new SqlParameter("@wid", SqlDbType.NVarChar, 50), new SqlParameter("@CategoryId", SqlDbType.Int, 4), new SqlParameter("@TypeId", SqlDbType.Int, 4), new SqlParameter("@ProductName", SqlDbType.NVarChar, 200), new SqlParameter("@ProductCode", SqlDbType.NVarChar, 50), new SqlParameter("@ShortDescription", SqlDbType.NVarChar, 2000), new SqlParameter("@Unit", SqlDbType.NVarChar, 50), new SqlParameter("@Description", SqlDbType.NText), new SqlParameter("@SaleStatus", SqlDbType.Int, 4), new SqlParameter("@AddedDate", SqlDbType.DateTime), new SqlParameter("@VistiCounts", SqlDbType.Int, 4), new SqlParameter("@SaleCounts", SqlDbType.Int, 4), new SqlParameter("@ShowSaleCounts", SqlDbType.Int, 4), new SqlParameter("@DisplaySequence", SqlDbType.Int, 4), new SqlParameter("@ImageUrl1", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl2", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl3", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl4", SqlDbType.NVarChar, 255), new SqlParameter("@ImageUrl5", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl40", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl60", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl100", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl160", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl180", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl220", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl310", SqlDbType.NVarChar, 255), new SqlParameter("@ThumbnailUrl410", SqlDbType.NVarChar, 255), new SqlParameter("@MarketPrice", SqlDbType.Money, 8), new SqlParameter("@BrandId", SqlDbType.Int, 4), new SqlParameter("@MainCategoryPath", SqlDbType.NVarChar, 256), new SqlParameter("@ExtendCategoryPath", SqlDbType.NVarChar, 256), new SqlParameter("@HasSKU", SqlDbType.Bit, 1), new SqlParameter("@IsfreeShipping", SqlDbType.Bit, 1), new SqlParameter("@TaobaoProductId", SqlDbType.BigInt, 8), new SqlParameter("@Source", SqlDbType.VarChar, 1), new SqlParameter("@MinShowPrice", SqlDbType.Money, 8), new SqlParameter("@MaxShowPrice", SqlDbType.Money, 8), new SqlParameter("@FreightTemplateId", SqlDbType.Int, 4), new SqlParameter("@FirstCommission", SqlDbType.Decimal, 9), new SqlParameter("@SecondCommission", SqlDbType.Decimal, 9), new SqlParameter("@ThirdCommission", SqlDbType.Decimal, 9), new SqlParameter("@IsSetCommission", SqlDbType.Bit, 1), new SqlParameter("@CubicMeter", SqlDbType.Decimal, 9), new SqlParameter("@FreightWeight", SqlDbType.Decimal, 9), new SqlParameter("@ProductShortName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ProductId; parameters[1].Value = model.wid; parameters[2].Value = model.CategoryId; parameters[3].Value = model.TypeId; parameters[4].Value = model.ProductName; parameters[5].Value = model.ProductCode; parameters[6].Value = model.ShortDescription; parameters[7].Value = model.Unit; parameters[8].Value = model.Description; parameters[9].Value = model.SaleStatus; parameters[10].Value = model.AddedDate; parameters[11].Value = model.VistiCounts; parameters[12].Value = model.SaleCounts; parameters[13].Value = model.ShowSaleCounts; parameters[14].Value = model.DisplaySequence; parameters[15].Value = model.ImageUrl1; parameters[16].Value = model.ImageUrl2; parameters[17].Value = model.ImageUrl3; parameters[18].Value = model.ImageUrl4; parameters[19].Value = model.ImageUrl5; parameters[20].Value = model.ThumbnailUrl40; parameters[21].Value = model.ThumbnailUrl60; parameters[22].Value = model.ThumbnailUrl100; parameters[23].Value = model.ThumbnailUrl160; parameters[24].Value = model.ThumbnailUrl180; parameters[25].Value = model.ThumbnailUrl220; parameters[26].Value = model.ThumbnailUrl310; parameters[27].Value = model.ThumbnailUrl410; parameters[28].Value = model.MarketPrice; parameters[29].Value = model.BrandId; parameters[30].Value = model.MainCategoryPath; parameters[31].Value = model.ExtendCategoryPath; parameters[32].Value = model.HasSKU; parameters[33].Value = model.IsfreeShipping; parameters[34].Value = model.TaobaoProductId; parameters[35].Value = model.Source; parameters[36].Value = model.MinShowPrice; parameters[37].Value = model.MaxShowPrice; parameters[38].Value = model.FreightTemplateId; parameters[39].Value = model.FirstCommission; parameters[40].Value = model.SecondCommission; parameters[41].Value = model.ThirdCommission; parameters[42].Value = model.IsSetCommission; parameters[43].Value = model.CubicMeter; parameters[44].Value = model.FreightWeight; parameters[45].Value = model.ProductShortName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }