/// <summary> /// 删除属性值 /// </summary> /// <param name="id"></param> /// <returns></returns> public string DelValue(string id) { //查看该属性值是否被使用 var ll = new Hi.BLL.BD_AttributeValues().GetModel(Convert.ToInt32(id)); if (ll != null) { string valueName = ll.AttrValue; var lll = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and attrsInfoName='" + Common.NoHTML(valueName) + "'", ""); if (lll.Count > 0) { return("ycz"); } } string str = string.Empty; if (id != "" && id != null) { Hi.Model.BD_AttributeValues model = new Hi.BLL.BD_AttributeValues().GetModel(Convert.ToInt32(id)); if (model != null) { model.ts = DateTime.Now; model.modifyuser = this.UserID; model.dr = 1; model.CompID = this.CompID; bool bol = new Hi.BLL.BD_AttributeValues().Update(model); return("cg"); } } return(str); }
/// <summary> /// 绑定产品信息 /// </summary> /// <param name="id"></param> public void Bind(int id)//, int goodsInfoId) { Hi.Model.BD_Goods model = new Hi.BLL.BD_Goods().GetModel(id); if (model != null && model.dr == 0 && model.IsEnabled == 1) { if (goodsInfoId == 0) { List <Hi.Model.BD_GoodsInfo> l = new Hi.BLL.BD_GoodsInfo().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and goodsid=" + id, ""); if (l.Count > 0) { this.lblCode.InnerText = l[0].BarCode.Trim(); //商品编号 this.lblInventory.InnerText = l[0].Inventory.ToString(); //商品库存. goodsInfoId = l[0].ID; } } else { Hi.Model.BD_GoodsInfo model2 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); if (model2 != null) { this.lblCode.InnerText = model2.BarCode.Trim(); //商品编号 this.lblInventory.InnerText = model2.Inventory.ToString(); //商品库存. } } Hi.Model.SYS_GType model3 = new Hi.BLL.SYS_GType().GetModel(model.CategoryID); if (model3 != null) { this.lblCategory.InnerText = model3.TypeName.Trim(); //分类 } GetZiDingYi(model); //自定义字段 // this.divTitle.InnerText = model.GoodsName.Trim();//biaot // this.divTitle.InnerHtml = model.GoodsName.Trim() + SelectGoods.ProType(zhek);//商品名称 string zhek = Cuxiao(goodsInfoId.ToString()); if (!Util.IsEmpty(zhek)) { this.divTitle.InnerHtml = model.GoodsName + SelectGoods.ProType(zhek);//商品名称 } else { this.divTitle.InnerHtml = model.GoodsName; } if (model.IsLS == 1) { this.isls.Visible = true; this.lbllsprice.InnerText = "¥" + model.LSPrice.ToString("0.00"); } else { this.isls.Visible = false; } this.divMemo.InnerHtml = model.Title.Trim(); //描述 this.lblHideInfo1.InnerText = model.HideInfo1; this.lblHideInfo2.InnerText = model.HideInfo2; //描述 this.lblUnit.InnerText = model.Unit.Trim(); //计量单位 // this.lblRecommend.InnerText = model.IsRecommended == 2 ? "推荐" : "否";//是否推荐 if (model.IsRecommended == 2) { this.lblShow.InnerText = "显示"; this.lblRecommend.InnerText = "推荐"; } else if (model.IsRecommended == 1) { this.lblShow.InnerText = "显示"; this.lblRecommend.InnerText = "不推荐"; } else { this.lblShow.InnerText = "不显示"; this.lblRecommend.InnerText = "不推荐"; } if (model.Details == "") { this.DivShow.InnerHtml = "<p style=\"padding-top: 20px; line-height: 40px; padding-left: 20px\">暂无数据</p>"; } else { this.DivShow.InnerHtml = model.Details; } if (!string.IsNullOrEmpty(model.Pic))//有图片 { LoginModel logUser = HttpContext.Current.Session["UserModel"] as LoginModel; string basePath = Common.GetWebConfigKey("OssImgPath") + "company/" + ((logUser != null) ? logUser.CompID.ToString() : "") + "/"; string surfix = "?x-oss-process=style/resize400"; this.imgPic.Src = basePath + model.Pic + surfix; this.imgPic2.Src = basePath + model.Pic + surfix; this.imgPic.Attributes.Add("jqimg", basePath + model.Pic); this.imgPic2.Attributes.Add("bimg", basePath + model.Pic); } else { this.imgPic.Src = "../../images/havenopicmax.gif"; //无图片 this.imgPic2.Src = "../../images/havenopicmax.gif"; //无图片 this.imgPic2.Attributes.Add("bimg", "../../images/havenopicmax.gif"); this.imgPic.Attributes.Add("jqimg", "../../images/havenopicmax.gif"); } } else { JScript.AlertMethod(this, "商品不存在或者已经被删除", JScript.IconOption.错误, "function(){location.href='GoodsInfoList.aspx';}"); return; } string html = string.Empty; List <Hi.Model.BD_GoodsAttrs> ll = new Hi.BLL.BD_GoodsAttrs().GetList("", "isnull(dr,0)=0 and compId=" + this.CompID + " and goodsId=" + id.ToString(), ""); if (ll.Count > 0) { int xy = 0; foreach (Hi.Model.BD_GoodsAttrs item in ll) { List <Hi.Model.BD_GoodsAttrsInfo> lll = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", "isnull(dr,0)=0 and compId=" + this.CompID + " and attrsId=" + item.ID, ""); if (lll.Count > 0) { html += "<div class=\"li\"><i class=\"bt2\" tip=\"" + item.AttrsName + "\">" + item.AttrsName + ":</i><div class=\"fun\" style=\"display: inline;\">"; int count = 1; foreach (Hi.Model.BD_GoodsAttrsInfo item2 in lll) { //Hi.Model.BD_GoodsInfo model4 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); //if (xy == 0) //{ // html += "<a href=\"javascript:;\" class=\"" + (model4.Value1 == item2.AttrsInfoName.Trim() ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; //} //else if (xy == 1) //{ // html += "<a href=\"javascript:;\" class=\"" + (model4.Value2 == item2.AttrsInfoName.Trim() ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; //} //else if (xy == 2) //{ // html += "<a href=\"javascript:;\" class=\"" + (model4.Value3 == item2.AttrsInfoName.Trim() ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; //} if (count == 1) { html += "<a href=\"javascript:;\" class=\"hover\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; } else { html += "<a href=\"javascript:;\" class=\"\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; } count++; } html += "</div></div>"; } xy++; } } litAttrVaue.Text = html; }
/// <summary> /// 获取某一分类产品信息,兼容了无属性的值,分类传-1 /// </summary> /// <param name="JSon"></param> /// <returns></returns> public BD_GoodsCategory.ResultProductList GetProductsList(string JSon) { try { #region JSon取值 string userID = string.Empty; string disID = string.Empty; string categoryID = string.Empty; //分类ID string criticalProductID = string.Empty; //当前列表最临界点产品ID:初始-1 string getType = string.Empty; //方向 string rows = string.Empty; string sortType = string.Empty; string sort = string.Empty; JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["ResellerID"].ToString() != "" && JInfo["CriticalProductID"].ToString() != "" && JInfo["GetType"].ToString() != "" && JInfo["Rows"].ToString() != "" && JInfo["SortType"].ToString() != "" && JInfo["Sort"].ToString() != "") { userID = JInfo["UserID"].ToString(); disID = JInfo["ResellerID"].ToString(); categoryID = JInfo["ClassifyID"].ToString(); criticalProductID = JInfo["CriticalProductID"].ToString(); getType = JInfo["GetType"].ToString(); rows = JInfo["Rows"].ToString(); sortType = JInfo["SortType"].ToString(); sort = JInfo["Sort"].ToString(); } else { return(new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "参数异常" }); } Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(userID), out user, 0, int.Parse(disID == "" ? "0" : disID))) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "参数异常" } } ; #endregion #region 模拟分页 string strsql = string.Empty; //搜索sql Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(int.Parse(disID)); if (dis == null || dis.dr == 1 || dis.IsEnabled == 0) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "未找到经销商" } } ; const string tabName = " [dbo].[BD_Goods]"; //表名 sortType = sortType == "2" ? "SalePrice" : "ID"; //价格排序 string strWhere = string.Empty; switch (categoryID) { case "-2": //促销列表 { List <Hi.Model.BD_Promotion> promotionList = new Hi.BLL.BD_Promotion().GetList("", " compID='" + dis.CompID + "' and ProStartTime<='" + DateTime.Now + "' and ProEndTime >='" + DateTime.Now + "' and IsEnabled=1", ""); List <Hi.Model.BD_PromotionDetail> detailList = new List <BD_PromotionDetail>(); if (promotionList != null && promotionList.Count > 0) { detailList = new Hi.BLL.BD_PromotionDetail().GetList("", " ProID in(" + string.Join(",", promotionList.Select(p => p.ID)) + ")", ""); } if (promotionList == null) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "今天无促销" } } ; if (detailList == null) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "今天无促销" } } ; var ienum = detailList.Select(p => p.GoodsID); if (ienum.Count() > 0) { strWhere += " and ID in ( " + string.Join(",", ienum) + ")"; } } break; case "-3": //收藏列表 { List <Hi.Model.BD_DisCollect> collects = new Hi.BLL.BD_DisCollect().GetList("", "disID='" + disID + "' and dr=0", ""); if (collects != null) { strWhere += " and ID not in ( -1 "; strWhere = collects.Aggregate(strWhere, (current, goods) => current + ("," + goods.GoodsID)) + ")"; } } break; default: if (categoryID != "-1") //全部 { strWhere += " and CategoryID in (" + Common.AllCategory(int.Parse(categoryID)) + ")"; } break; } //商品可售区域判断 List <Common.GoodsID> list = Common.DisEnAreaGoodsID(disID, dis.CompID.ToString()); if (list != null) { strWhere += " and ID not in ( -1 "; strWhere = list.Aggregate(strWhere, (current, goods) => current + ("," + goods.goodsID)) + ")"; } strWhere += " and ISNULL(dr,0)=0 and isoffline=1 and IsEnabled = 1 and compid=" + dis.CompID; strsql = new Common().PageSqlString(criticalProductID, "ID", tabName, sortType, sort, strWhere, getType, rows); #endregion List <Hi.Model.BD_DisCollect> Colist = Common.GetDataSource <BD_DisCollect>("", " and disID='" + disID + "' and compID='" + dis.CompID + "' and IsEnabled =1"); List <Hi.Model.BD_GoodsInfo> infoAllList = new Hi.BLL.BD_GoodsInfo().GetList("", " CompID='" + dis.CompID + "' and ISNULL(dr,0)=0 and IsEnabled=1 and isoffline=1", ""); #region 赋值 int CategoryID = 0; List <BD_GoodsCategory.Product> ProductList = new List <BD_GoodsCategory.Product>(); DataTable dsList = SqlHelper.Query(SqlHelper.LocalSqlServer, strsql).Tables[0]; if (dsList != null) { if (dsList.Rows.Count == 0) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "未找到数据" } } ; foreach (DataRow row in dsList.Rows) { string SKUName = string.Empty; BD_GoodsCategory.Product product = new BD_GoodsCategory.Product(); product.ProductID = row["ID"].ToString(); //商品ID product.ProductName = row["GoodsName"].ToString(); SKUName += product.ProductName; product.SalePrice = decimal.Parse(row["SalePrice"].ToString()).ToString("0.00"); product.IsSale = row["IsSale"].ToString(); List <Hi.Model.BD_DisCollect> alist = Colist != null && Colist.Count > 0 ? Colist.Where(p => p.GoodsID.ToString() == product.ProductID).ToList() : null; product.IsCollect = alist != null && alist.Count > 0 ? "1" : "0"; product.Title = row["Title"].ToString(); //product.Details = row["Details"].ToString(); product.Title = row["Title"].ToString(); product.Unit = row["Unit"].ToString(); product.ClassifyID = row["CategoryID"].ToString(); CategoryID = int.Parse(row["CategoryID"].ToString()); //类别ID List <BD_GoodsCategory.Pic> Pic = new List <BD_GoodsCategory.Pic>(); #region List<Pic> Pic if (row["Pic"].ToString() != "" && row["Pic"].ToString() != "X") { BD_GoodsCategory.Pic pic = new BD_GoodsCategory.Pic(); pic.ProductID = row["ID"].ToString(); pic.IsDeafult = "1"; pic.PicUrl = ConfigurationManager.AppSettings["ImgViewPath"].ToString().Trim() + "GoodsImg/" + row["Pic"].ToString(); Pic.Add(pic); } Pic.AddRange(GetPicList(row["ID"].ToString())); #endregion product.ProductPicUrlList = Pic; List <BD_GoodsCategory.SKU> SKUList = new List <BD_GoodsCategory.SKU>(); string strID = "0"; #region 通过 商品ID和属性值ID关联表,找到属性值 List <Hi.Model.BD_GoodsInfo> goodsInfoList = infoAllList != null && infoAllList.Count > 0 ? infoAllList.Where(p => p.GoodsID.ToString() == row["ID"].ToString()).ToList() : null; foreach (Hi.Model.BD_GoodsInfo goodsInfo in goodsInfoList) { if (!Common.IsOffline(goodsInfo.ID)) { continue; } BD_GoodsCategory.SKU SKU = new BD_GoodsCategory.SKU(); //SKUID是GoodsInfoID,SKUName是GoodsName+各种属性值 SKU.SKUID = goodsInfo.ID.ToString(); SKU.ProductID = goodsInfo.GoodsID.ToString(); SKU.BarCode = goodsInfo.BarCode; //SKUName = GoodsName + ValueInfo SKU.SKUName = SKUName + " " + goodsInfo.ValueInfo; SKU.ValueInfo = goodsInfo.ValueInfo; SKU.SalePrice = goodsInfo.SalePrice.ToString("0.00"); int ProID = 0; //暂时未用到 促销ID SKU.IsPro = "0"; //默认不是促销价 decimal price = Common.GetProPrice(goodsInfo.GoodsID.ToString(), goodsInfo.ID.ToString(), goodsInfo.CompID.ToString(), out ProID); if (price == 0) { List <Hi.Model.BD_GoodsPrice> goodsPrice = new Hi.BLL.BD_GoodsPrice().GetList("", " GoodsInfoID='" + goodsInfo.ID + "' and ISNULL(dr,0)=0 and compid='" + goodsInfo.CompID + "' and IsEnabled=1", ""); SKU.TinkerPrice = goodsPrice.Count != 0 ? goodsPrice[0].TinkerPrice.ToString("0.00") : goodsInfo.TinkerPrice.ToString("0.00"); } else { SKU.IsPro = "1"; //是促销价 SKU.ProInfo = GetProInfo(ProID, goodsInfo.ID); SKU.TinkerPrice = price.ToString("0.00"); } List <BD_GoodsCategory.ProductAttValueID> ProductAttValueIDList = new List <BD_GoodsCategory.ProductAttValueID>(); List <Hi.Model.BD_GoodsAttrsInfo> attrList = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", " GoodsID='" + goodsInfo.GoodsID + "' and ISNULL(dr,0)=0", ""); if (attrList == null) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "未找到商品属性名字" } } ; List <Hi.Model.BD_GoodsAttrs> attrValList = new Hi.BLL.BD_GoodsAttrs().GetList("*", " CompID ='" + dis.CompID + "'", ""); foreach (Hi.Model.BD_GoodsAttrsInfo attribute in attrList) { strID += "," + attribute.AttrsID; string[] args = new[] { goodsInfo.ValueInfo }; string[] items = args[0].Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); foreach (string item in items) { string[] strs = item.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries); if (strs[1] == attribute.AttrsInfoName) { BD_GoodsCategory.ProductAttValueID productAttValueID = new BD_GoodsCategory.ProductAttValueID() { ProductAttributeValueID = attribute.ID.ToString()// }; ProductAttValueIDList.Add(productAttValueID); } } } SKU.ProductAttValueIDList = ProductAttValueIDList; SKUList.Add(SKU); } #endregion product.SKUList = SKUList; List <BD_GoodsCategory.ProductAttribute> ProductAttributeList = new List <BD_GoodsCategory.ProductAttribute>(); #region 通过商品类别ID和属性ID关联表,找到属性ID List <Hi.Model.BD_GoodsAttrs> val = new Hi.BLL.BD_GoodsAttrs().GetList("", " ID in (" + strID + ") and CompID='" + dis.CompID + "' and ISNULL(dr,0)=0", ""); if (val == null) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "未找到商品属性" } } ; foreach (Hi.Model.BD_GoodsAttrs goodsAttr in val) { BD_GoodsCategory.ProductAttribute proAttr = new BD_GoodsCategory.ProductAttribute(); proAttr.ProductID = row["ID"].ToString(); proAttr.ProductAttributeID = goodsAttr.ID.ToString(); //属性ID proAttr.ProductAttributeName = goodsAttr.AttrsName; //属性名称 List <BD_GoodsCategory.ProductAttValue> ProductAttValueList = new List <BD_GoodsCategory.ProductAttValue>(); List <Hi.Model.BD_GoodsAttrsInfo> attrList = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", " AttrsID='" + goodsAttr.ID + "' and CompID='" + dis.CompID + "' and ISNULL(dr,0)=0" + " and AttrsID in (" + strID + ")", "ID"); //todo:商品属性表修改咨询商品结构 if (attrList == null) { return new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "未找到商品属性名字" } } ; foreach (Hi.Model.BD_GoodsAttrsInfo attribute in attrList) { BD_GoodsCategory.ProductAttValue productAttValue = new BD_GoodsCategory.ProductAttValue(); productAttValue.ProductID = row["ID"].ToString(); productAttValue.ProductAttributeID = goodsAttr.ID.ToString(); productAttValue.ProductAttValueID = attribute.ID.ToString(); productAttValue.ProductAttValueName = attribute.AttrsInfoName; ProductAttValueList.Add(productAttValue); } proAttr.ProductAttValueList = ProductAttValueList; ProductAttributeList.Add(proAttr); } #endregion product.ProductAttributeList = ProductAttributeList; ProductList.Add(product); } } #endregion return(new BD_GoodsCategory.ResultProductList() { Result = "T", Description = "获取成功", ClassifyID = categoryID, ProductList = ProductList }); } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetResellerProductList :" + JSon); return(new BD_GoodsCategory.ResultProductList() { Result = "F", Description = "异常" }); } }
/// <summary> /// 商品信息绑定 /// </summary> public void Bind() { LoginModel logmodel = HttpContext.Current.Session["UserModel"] as LoginModel; Hi.Model.BD_Goods model = new Hi.BLL.BD_Goods().GetModel(goodsId); if (model != null) { GetZiDingYi(model); mKeyword.Content = string.IsNullOrWhiteSpace(model.Title) ? model.GoodsName : model.Title; string zhek = Cuxiao(); if (!Util.IsEmpty(zhek)) { this.lblGoodsName.InnerHtml = model.GoodsName + SelectGoods.ProType(zhek); //商品名称 tiele_name = model.GoodsName; //前台title显示 if (hidGoodsInfoId.Value != null && hidGoodsInfoId.Value != "") { Hi.Model.BD_GoodsInfo godosInfomodel = new Hi.BLL.BD_GoodsInfo().GetModel(Convert.ToInt32(hidGoodsInfoId.Value)); //add by hgh 未登录,原价不可见 //if (logmodel != null) //{ if (Request["Comid"].ToString() == model.CompID.ToString()) { this.YuanPrice.InnerHtml = "<s><i>原价:</i><b class=\"red\" id=\"B1\">" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(godosInfomodel.TinkerPrice).ToString())).ToString("#,##0.00") + "</b></s>"; } else { string sysNameWhere = string.Format(" CompID={0} and Name='是否店铺开放价格'", Request["Comid"].ToInt(0)); List <Hi.Model.SYS_SysName> Sysl = new Hi.BLL.SYS_SysName().GetList("", sysNameWhere, ""); if (Sysl.Count > 0) { if (Sysl[0].Value == "1") { this.YuanPrice.InnerHtml = "<s><i>原价:</i><b class=\"red\" id=\"B1\">" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(godosInfomodel.TinkerPrice).ToString())).ToString("#,##0.00") + "</b></s>"; } } } //} } } else { this.lblGoodsName.InnerHtml = model.GoodsName; tiele_name = model.GoodsName;//前台title显示 this.YuanPrice.InnerHtml = ""; } this.lblunit.InnerText = model.Unit; this.lblGoodsTitle.InnerText = model.Title;//商品卖点 hideInfo1 = model.HideInfo1; hideInfo2 = model.HideInfo2; if (!Util.IsEmpty(model.Details.Trim())) { this.lblGoodsDetali.InnerHtml = model.Details.Replace("<pre>", "<p>").Replace("</pre>", "</p>");//商品描述 } if (!Util.IsEmpty(model.registeredCertificate.Trim())) { string url = Common.GetWebConfigKey("OssImgPath") + "UploadFile/" + model.registeredCertificate; this.lblGoodsDetali1.InnerHtml = "<img width=\"600\" src=\"" + url + "\"/>"; } //this.lblPrice.InnerText = "¥" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(model.SalePrice.ToString()).ToString())).ToString("#,##0.00"); ;//商品价格 if (model != null && !string.IsNullOrEmpty(model.Pic)) { this.imgPic.Src = Common.GetPicURL(model.Pic, "resize400", compId.ToString()); this.imgPic.Attributes.Add("jqimg", Common.GetPicURL(model.Pic, "", compId.ToString())); } else { imgPic.Src = "../images/Goods400x400.jpg";//无图片 imgPic.Attributes.Add("jqimg", "../images/Goods400x400.jpg"); } string html = string.Empty; List <Hi.Model.BD_GoodsAttrs> ll = new Hi.BLL.BD_GoodsAttrs().GetList("", "isnull(dr,0)=0 and compId=" + compId + " and goodsId=" + goodsId.ToString(), ""); if (ll.Count > 0) { foreach (Hi.Model.BD_GoodsAttrs item in ll) { int xy = 0; List <Hi.Model.BD_GoodsAttrsInfo> lll = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", "isnull(dr,0)=0 and compId=" + compId + " and attrsId=" + item.ID, ""); if (lll.Count > 0) { //add by hgh if (item.AttrsName.Length > 4) { item.AttrsName = item.AttrsName.Substring(0, 4); } html += "<div class=\"li\"><div class=\"t\" tip=\"" + item.AttrsName + "\">" + item.AttrsName + ":</div><div class=\"n\">"; foreach (Hi.Model.BD_GoodsAttrsInfo item2 in lll) { if (goodsInfoId == 0) { html += "<a href=\"javascript:;\" class=\"" + (xy == 0 ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "<i class=\"xz-icon\"></i></a>"; } else { Hi.Model.BD_GoodsInfo model2 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); if (model2 != null) { html += "<a href=\"javascript:;\" class=\"" + (model2.Value1 == item2.AttrsInfoName || model2.Value2 == item2.AttrsInfoName || model2.Value3 == item2.AttrsInfoName ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "<i class=\"xz-icon\"></i></a>"; } } xy++; } html += "</div></div>"; } } } litAttrVaue.InnerHtml = html; if (logmodel != null) { List <Hi.Model.BD_DisCollect> llll = new Hi.BLL.BD_DisCollect().GetList("", "isnull(dr,0)=0 and comPid=" + model.CompID + " and goodsId=" + goodsId + " and disId=" + logmodel.DisID, ""); if (llll.Count > 0) { ClientScript.RegisterStartupScript(this.GetType(), "showsc", "<script>$(function(){$(\".btn .keep\").html('<i class=\"sc-icon\" style=\"background-position:0 -73px;\"></i>取消收藏\');})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "showsc", "<script>$(function(){$(\".btn .keep\").html('<i class=\"sc-icon\" ></i>加入收藏\');})</script>"); } } } }
/// <summary> /// 绑定产品信息 /// </summary> /// <param name="id"></param> public void Bind(int id, int goodsInfoId, int compId) { Hi.Model.BD_Goods model = new Hi.BLL.BD_Goods().GetModel(id); if (model != null && model.dr == 0 && model.IsEnabled == 1) { Hi.Model.BD_GoodsInfo model2 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); if (model2 != null) { this.lblCode.InnerText = model2.BarCode.Trim(); //商品编号 this.lblInventory.InnerText = model2.Inventory.ToString(); //库存 } Hi.Model.BD_GoodsCategory model3 = new Hi.BLL.BD_GoodsCategory().GetModel(model.CategoryID); if (model3 != null) { this.lblCategory.InnerText = model3.CategoryName.Trim(); //分类 } GetZiDingYi(model); //自定义字段 this.divTitle.InnerText = model.GoodsName.Trim(); //biaot this.divMemo.InnerHtml = model.Title.Trim(); //描述 this.lblHideInfo1.InnerText = model.HideInfo1; this.lblHideInfo2.InnerText = model.HideInfo2; //描述 this.lblUnit.InnerText = model.Unit.Trim(); //计量单位 if (model.Details == "") { this.DivShow.InnerHtml = "<p style=\"padding-top: 20px; line-height: 40px; padding-left: 20px\">暂无数据</p>"; } else { this.DivShow.InnerHtml = model.Details; } if (!string.IsNullOrEmpty(model.Pic))//有图片 { this.imgPic.Src = Common.GetPicURL(model.Pic, "resize400"); this.imgPic.Attributes.Add("jqimg", Common.GetPicURL(model.Pic)); this.imgPic2.Src = Common.GetPicURL(model.Pic, "resize400"); this.imgPic2.Attributes.Add("bimg", Common.GetPicURL(model.Pic)); } else { this.imgPic.Src = "../../images/havenopicmax.gif"; //无图片 this.imgPic2.Src = "../../images/havenopicmax.gif"; //无图片 this.imgPic2.Attributes.Add("bimg", "../../images/havenopicmax.gif"); this.imgPic.Attributes.Add("jqimg", "../../images/havenopicmax.gif"); } //add by hgh 设置商品是否首页显示 this.labText.Text = model.IsFirstShow == true ? "是" : "否"; } else { JScript.AlertMsg(this, "商品不存在或者已经被删除", "GoodsInfoList.aspx"); return; } string html = string.Empty; List <Hi.Model.BD_GoodsAttrs> ll = new Hi.BLL.BD_GoodsAttrs().GetList("", "isnull(dr,0)=0 and compId=" + compId + " and goodsId=" + id.ToString(), ""); if (ll.Count > 0) { int xy = 0; foreach (Hi.Model.BD_GoodsAttrs item in ll) { List <Hi.Model.BD_GoodsAttrsInfo> lll = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", "isnull(dr,0)=0 and compId=" + compId + " and attrsId=" + item.ID, ""); if (lll.Count > 0) { html += "<div class=\"li\"><i class=\"bt2\" tip=\"" + item.AttrsName + "\">" + item.AttrsName + ":</i><div class=\"fun\">"; foreach (Hi.Model.BD_GoodsAttrsInfo item2 in lll) { Hi.Model.BD_GoodsInfo model4 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); if (xy == 0) { html += "<a href=\"javascript:;\" class=\"" + (model4.Value1 == item2.AttrsInfoName.Trim() ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; } else if (xy == 1) { html += "<a href=\"javascript:;\" class=\"" + (model4.Value2 == item2.AttrsInfoName.Trim() ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; } else if (xy == 2) { html += "<a href=\"javascript:;\" class=\"" + (model4.Value3 == item2.AttrsInfoName.Trim() ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "</a>"; } } html += "</div></div>"; } xy++; } } litAttrVaue.Text = html; }
//public void Download_Click(object sender, EventArgs e) //{ // LinkButton bt = sender as LinkButton; // string fileName = bt.Attributes["fileName"]; // string filePath = Server.MapPath("../UploadFile/") + fileName; // if (File.Exists(filePath)) // { // FileInfo file = new FileInfo(filePath); // Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); //解决中文乱码 // Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name.Substring(0, file.Name.LastIndexOf("_")) + Path.GetExtension(file.Name))); //解决中文文件名乱码 // Response.AddHeader("Content-length", file.Length.ToString()); // Response.ContentType = "appliction/octet-stream"; // Response.WriteFile(file.FullName); // Response.Flush(); // Response.End(); // } // else // { // JScript.AlertMsgOne(this, "附件不存在!", JScript.IconOption.错误); // } //} /// <summary> /// 附件绑定 /// </summary> //public void DataBindLink() //{ // string goodsId = Request.QueryString["goodsId"]; // if (!string.IsNullOrWhiteSpace(goodsId)) // { // //string gid = Common.DesDecrypt(Request["goodsId"], Common.EncryptKey); // Hi.Model.BD_Goods model = new Hi.BLL.BD_Goods().GetModel(Convert.ToInt32(goodsId)); // if (model != null && model.CompID == this.CompID) // { // if (!string.IsNullOrEmpty(model.registeredCertificate)) // { // LinkButton linkFile = new LinkButton(); // linkFile.Click += new EventHandler(Download_Click); // if (model.registeredCertificate.LastIndexOf("_") != -1) // { // string text = model.registeredCertificate.Substring(0, model.registeredCertificate.LastIndexOf("_")) + Path.GetExtension(model.registeredCertificate); // if (text.Length < 15) // linkFile.Text = text; // else // { // linkFile.Text = text.Substring(0, 15) + "..."; // } // linkFile.Attributes.Add("title", text); // } // else // { // string text = model.registeredCertificate.Substring(0, model.registeredCertificate.LastIndexOf("-")) + Path.GetExtension(model.registeredCertificate); // if (text.Length < 15) // linkFile.Text = text; // else // { // linkFile.Text = text.Substring(0, 15) + "..."; // } // linkFile.Attributes.Add("title", text); // } // linkFile.Style.Add("text-decoration", "underline"); // linkFile.Attributes.Add("fileName", model.registeredCertificate); // HtmlGenericControl div = new HtmlGenericControl("div"); // div.Controls.Add(linkFile); // UpFileText2.Controls.Add(div); // } // } // } //} /// <summary> /// 商品信息绑定 /// </summary> public void Bind() { Hi.Model.BD_Goods model = new Hi.BLL.BD_Goods().GetModel(goodsId); if (model != null) { GetZiDingYi(model); string zhek = Cuxiao(); if (!Util.IsEmpty(zhek)) { this.lblGoodsName.InnerHtml = model.GoodsName + SelectGoods.ProType(zhek); //商品名称 tiele_name = model.GoodsName; //前台title显示 Hi.Model.BD_GoodsInfo godosInfomodel = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); if (this.CompID.ToString() == model.CompID.ToString()) { this.YuanPrice.InnerHtml = "<s><i>原价:</i><b class=\"red\" id=\"B1\">¥" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(godosInfomodel.TinkerPrice).ToString())).ToString("#,##0.00") + "</b></s>"; } } else { this.lblGoodsName.InnerHtml = model.GoodsName; tiele_name = model.GoodsName;//前台title显示 this.YuanPrice.InnerHtml = ""; } this.lblunit.InnerText = model.Unit; this.lblGoodsTitle.InnerText = model.Title;//商品卖点 hideInfo1 = model.HideInfo1; hideInfo2 = model.HideInfo2; if (!Util.IsEmpty(model.Details.Trim())) { this.lblGoodsDetali.InnerHtml = model.Details;//商品描述 } if (!Util.IsEmpty(model.registeredCertificate.Trim())) { string url = Common.GetWebConfigKey("OssImgPath") + "/UploadFile/" + model.registeredCertificate; this.lblGoodsDetali1.InnerHtml = "<img width=\"600\" src=\"" + url + "\"/>"; } if (model != null && !string.IsNullOrEmpty(model.Pic)) { this.imgPic.Src = Common.GetPicURL(model.Pic, "resize400"); this.imgPic.Attributes.Add("jqimg", Common.GetPicURL(model.Pic)); } //this.lblPrice.InnerText = "¥" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(model.SalePrice.ToString()).ToString())).ToString("#,##0.00"); ;//商品价格 string html = string.Empty; List <Hi.Model.BD_GoodsAttrs> ll = new Hi.BLL.BD_GoodsAttrs().GetList("", "isnull(dr,0)=0 and compId=" + compID + " and goodsId=" + goodsId.ToString(), ""); if (ll.Count > 0) { foreach (Hi.Model.BD_GoodsAttrs item in ll) { int xy = 0; List <Hi.Model.BD_GoodsAttrsInfo> lll = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", "isnull(dr,0)=0 and compId=" + compID + " and attrsId=" + item.ID, ""); if (lll.Count > 0) { html += "<div class=\"li\"><div class=\"t\" tip=\"" + item.AttrsName + "\">" + item.AttrsName + ":</div><div class=\"n\">"; foreach (Hi.Model.BD_GoodsAttrsInfo item2 in lll) { if (goodsInfoId == 0) { html += "<a href=\"javascript:;\" class=\"" + (xy == 0 ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "<i class=\"xz-icon\"></i></a>"; } else { Hi.Model.BD_GoodsInfo model2 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsInfoId); if (model2 != null) { html += "<a href=\"javascript:;\" class=\"" + (model2.Value1 == item2.AttrsInfoName || model2.Value2 == item2.AttrsInfoName || model2.Value3 == item2.AttrsInfoName ? "hover" : "") + "\" tip=\"" + item2.AttrsInfoName + "\">" + item2.AttrsInfoName + "<i class=\"xz-icon\"></i></a>"; } } xy++; } html += "</div></div>"; } } } litAttrVaue.InnerHtml = html; List <Hi.Model.BD_DisCollect> llll = new Hi.BLL.BD_DisCollect().GetList("", "isnull(dr,0)=0 and comPid=" + model.CompID + " and goodsId=" + goodsId + " and disId=" + this.DisID, ""); if (llll.Count > 0) { ClientScript.RegisterStartupScript(this.GetType(), "showsc", "<script>$(function(){$(\".btns .keep\").html('<i class=\"sc-icon\" style=\"background-position:0 -73px;\"></i>取消收藏\');})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "showsc", "<script>$(function(){$(\".btns .keep\").html('<i class=\"sc-icon\" ></i>加入收藏\');})</script>"); } } }
/// <summary> /// 删除GOods以及goodsinfo表 /// </summary> /// <param name="Tran"></param> private void DelGoods() { SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction(); try { foreach (RepeaterItem row in this.rptGoodsInfo.Items) { CheckBox cb = row.FindControl("CB_SelItem") as CheckBox; if (cb != null && cb.Checked) { HiddenField fld = row.FindControl("HF_Id") as HiddenField; HiddenField fld2 = row.FindControl("HF_GoodsId") as HiddenField; if (fld != null && fld2 != null) { int goodsId = Convert.ToInt32(fld2.Value); int goodsinfoId = Convert.ToInt32(fld.Value); Hi.Model.BD_GoodsInfo model2 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsinfoId, Tran); if (model2 != null) { model2.ts = DateTime.Now; model2.modifyuser = this.UserID; model2.dr = 1; model2.CompID = this.CompID; bool bol = new Hi.BLL.BD_GoodsInfo().Update(model2, Tran); } List <Hi.Model.BD_GoodsInfo> ll = new Hi.BLL.BD_GoodsInfo().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and goodsId=" + goodsId, "", Tran); if (ll.Count == 0) { Hi.Model.BD_Goods model = new Hi.BLL.BD_Goods().GetModel(goodsId, Tran); if (model != null) { model.ts = DateTime.Now; model.modifyuser = this.UserID; model.dr = 1; model.CompID = this.CompID; bool bol = new Hi.BLL.BD_Goods().Update(model, Tran); } List <Hi.Model.BD_GoodsAttrs> lll = new Hi.BLL.BD_GoodsAttrs().GetList("", "isnull(dr,0)=0 and goodsid=" + goodsId + " and compid=" + this.CompID, "", Tran); if (lll.Count > 0) { foreach (Hi.Model.BD_GoodsAttrs item in lll) { Hi.Model.BD_GoodsAttrs attsmodel = new Hi.BLL.BD_GoodsAttrs().GetModel(item.ID); if (attsmodel != null) { attsmodel.ts = DateTime.Now; attsmodel.modifyuser = this.UserID; attsmodel.dr = 1; attsmodel.CompID = this.CompID; bool bol = new Hi.BLL.BD_GoodsAttrs().Update(attsmodel, Tran); } List <Hi.Model.BD_GoodsAttrsInfo> llll = new Hi.BLL.BD_GoodsAttrsInfo().GetList("", "isnull(dr,0)=0 and goodsid=" + goodsId + " and compid=" + this.CompID + " and attrsid=" + item.ID, "", Tran); if (llll.Count > 0) { foreach (Hi.Model.BD_GoodsAttrsInfo item2 in llll) { Hi.Model.BD_GoodsAttrsInfo attsinfomodel = new Hi.BLL.BD_GoodsAttrsInfo().GetModel(item2.ID); if (attsmodel != null) { attsinfomodel.ts = DateTime.Now; attsinfomodel.modifyuser = this.UserID; attsinfomodel.dr = 1; attsinfomodel.CompID = this.CompID; bool bol = new Hi.BLL.BD_GoodsAttrsInfo().Update(attsinfomodel, Tran); } } } } } } } } } Tran.Commit(); } catch (Exception) { if (Tran != null) { if (Tran.Connection != null) { Tran.Rollback(); } } } finally { DBUtility.SqlHelper.ConnectionClose(); } }