/// <summary> /// 根据商品ID得到商品名称 /// </summary> /// <param name="id"></param> /// <returns></returns> protected string GetProductName(string id) { try { ShowShop.BLL.Product.ProductInfo bll = new ShowShop.BLL.Product.ProductInfo(); ShowShop.Model.Product.ProductInfo model = bll.GetModel(Convert.ToInt32(id)); return "<a href=\"../../ProductContent.aspx?ID=" + id + "\" title=\"查看该商品\" target=\"_blank\">" + model.ProductName + "</a>"; } catch { return "查询相关商品出错"; } }
protected string ProductName(string ProductId) { string reStr = string.Empty; string str = ""; if (!string.IsNullOrEmpty(ProductId)) { ShowShop.BLL.Product.ProductInfo dll = new ShowShop.BLL.Product.ProductInfo(); ShowShop.Model.Product.ProductInfo model = dll.GetModel(Convert.ToInt32(ProductId)); if (model != null) { str = model.ProductName; } } return str; }
protected void BindList(int ProductId) { ShowShop.BLL.Product.ProductInfo bll = new ShowShop.BLL.Product.ProductInfo(); ShowShop.Model.Product.ProductInfo modle = bll.GetModel(ProductId); if (modle != null) { // if (!string.IsNullOrEmpty(modle.pro_Specialspecifications)) { Regex productSpe = new Regex(@"s_spacebar"); // string[] specifiactionVa = productSpe.Split(modle.pro_Specialspecifications); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); //第一步先添加表头 table.AddHeadCol("5%", "序号"); table.AddHeadCol("75%", "规格值"); table.AddHeadCol("20%", "操作"); table.AddRow(); //添加表的内容 //if (!string.IsNullOrEmpty(specifiactionVa[1])) //{ // this.Spec.Text = specifiactionVa[0]; // int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex"); // if (curpage < 0) // { // curpage = 1; // } // int count = 0; // string[] spval = specifiactionVa[1].Replace("\r\n",",").Split(','); // for (int i = 0; i < spval.Length; i++) // { // count++; // string No = (15 * (curpage - 1) + count).ToString(); // table.AddCol(No); // table.AddCol(spval[i]); // table.AddCol(string.Format("<a href=product_specialspecification.aspx?productId={0}&id={1}&val={2}&spec={3}>编辑</a>", ProductId, i, spval[i], specifiactionVa[0])); // table.AddRow(); // } //} string view = table.GetTable(); this.Literal1.Text = view; } } }
/// <summary> /// 列表 /// </summary> /// <returns></returns> protected void GetList(string PutoutType) { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo(); ChangeHope.DataBase.DataByPage dataPage = data.GetList("[order by] ProductID desc", 20, ""); //第一步先添加表头 table.AddHeadCol("5%", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" />选择"); table.AddHeadCol("10%", "商品编号"); table.AddHeadCol("18%", "商品名称"); table.AddHeadCol("15%", "所属分类"); table.AddHeadCol("10%", "品牌"); table.AddHeadCol("14%", "创建时间"); table.AddHeadCol("8%", "上架状态"); table.AddHeadCol("20%", "操作"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { while (dataPage.DataReader.Read()) { string pic_url = sp.DummyPaht + dataPage.DataReader["Thumbnail"].ToString(); table.AddCol("<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["ProductID"].ToString() + "\" />"); table.AddCol(dataPage.DataReader["ProductNo"].ToString()); table.AddCol("<span style='cursor:hand' onMouseOut=\"hiddenPic();\" onMouseMove=\"showPic('" + pic_url + "');\">" + dataPage.DataReader["ProductName"].ToString() + "(" + dataPage.DataReader["ProductAttachName"].ToString() + ")</span>"); table.AddCol(ProductClassName(dataPage.DataReader["cid"].ToString())); table.AddCol(dataPage.DataReader["BrandID"].ToString()); table.AddCol(dataPage.DataReader["CreateTime"].ToString()); table.AddCol(dataPage.DataReader["IsShelves"].ToString() == "1" ? "上架" : "未上架"); table.AddCol(string.Format("<a href=product_info_edit.aspx?productNo={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a> <a href=product_info_edit.aspx?productNo={0}>属性添加</a> <a href='../../product/productcontent.aspx?q_productid={0}' target='_blank'>SKU添加</a>", dataPage.DataReader["ProductID"].ToString(), dataPage.DataReader["cid"].ToString(), PutoutType)); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.Literal1.Text = view; }
/// <summary> /// 列表 /// </summary> /// <returns></returns> protected void GetList() { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo(); ChangeHope.DataBase.DataByPage dataPage = data.GetList(); //第一步先添加表头 table.AddHeadCol("10%","序号"); table.AddHeadCol("20%","货号"); table.AddHeadCol("65%", "商品名称"); table.AddHeadCol("10%", "库存"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex"); if (curpage < 0) { curpage = 1; } int count = 0; while (dataPage.DataReader.Read()) { count++; string No = (15 * (curpage - 1) + count).ToString(); table.AddCol(No + "<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["pro_ID"].ToString() + "\" />"); table.AddCol(dataPage.DataReader["pro_NO"].ToString()); table.AddCol("" + dataPage.DataReader["pro_Name"].ToString() + ""); table.AddCol(string.Format("{0}{1}", dataPage.DataReader["pro_Stock"].ToString(), dataPage.DataReader["pro_Unit"].ToString())); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.Literal1.Text = view; }
private void HandleOrder(int id) { ShowShop.BLL.Order.Orders ordersbll = new ShowShop.BLL.Order.Orders(); ShowShop.Model.Order.Orders ordersModel = ordersbll.GetModel(id); if (ordersModel != null) { ShowShop.BLL.Order.OrderProduct orderProductbll = new ShowShop.BLL.Order.OrderProduct(); DataTable orderProductDT = orderProductbll.GetListOrderProduct(id.ToString()); ShowShop.BLL.Member.MemberAccount memberaccountbll = new ShowShop.BLL.Member.MemberAccount(); ShowShop.Model.Member.MemberAccount memberaccounModel = memberaccountbll.GetModel(ordersModel.UserId); // ShowShop.BLL.Product.ProductSpecification spebll = new ShowShop.BLL.Product.ProductSpecification(); decimal DonateIntegral = 0; if (orderProductDT.Rows.Count > 0) { ShowShop.BLL.Product.ProductInfo productinfoBll = new ShowShop.BLL.Product.ProductInfo(); for (int i = 0; i < orderProductDT.Rows.Count; i++) { ShowShop.Model.Product.ProductInfo productInfoModel = productinfoBll.GetModel(Convert.ToInt32(orderProductDT.Rows[i]["ProId"].ToString())); if (productInfoModel != null) { // DonateIntegral += Convert.ToDecimal(productInfoModel.pro_DonateIntegral); // productinfoBll.Amend(productInfoModel.pro_ID, "pro_SaleNum", productInfoModel.pro_SaleNum + Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())); if (!string.IsNullOrEmpty(orderProductDT.Rows[i]["Specification"].ToString())) { // List<ShowShop.Model.Product.ProductSpecification> spcList = spebll.GetSpecification(" and ProductId=" + orderProductDT.Rows[i]["ProId"].ToString() + " and Specifications='" + orderProductDT.Rows[i]["Specification"].ToString() + "'"); // if (spcList.Count > 0) // { // spebll.Amend(spcList[0].Id, "ProductStock", Convert.ToInt32(spcList[0].ProductStock) - Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())); // } } else { //if (Convert.ToInt32(productInfoModel.pro_Stock) >= Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())) { // productinfoBll.Amend(productInfoModel.pro_ID, "pro_Stock", Convert.ToInt32(productInfoModel.pro_Stock) - Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())); } } } } //购买商品赠送积分 if (memberaccounModel != null) { if (DonateIntegral > 0) { if (memberaccountbll.Amend(memberaccounModel.UID, "Points", memberaccounModel.Points + DonateIntegral) > 0) { ShowShop.BLL.Member.Integral integralBll = new ShowShop.BLL.Member.Integral(); ShowShop.Model.Member.Integral integral = new ShowShop.Model.Member.Integral(); integral.Userid = memberaccounModel.UID; integral.OrderId = ordersModel.OrderId; integral.IntegralClass = 1; integral.IntegralNum = memberaccounModel.Points + DonateIntegral; integral.GainDate = Convert.ToDateTime(System.DateTime.Now); integral.NoteDate = Convert.ToDateTime(System.DateTime.Now); integral.NoteName = "系统"; integral.Remark = "购买商品后赠送的积分"; integral.IntegralStatus = 0; integral.Origin = "订单"; integralBll.Add(integral); } } } } } }
public static void FittingDisposal(string SparepartId, string FittingsProductId, string FittingsProductCount, out int FittingProductCount, out string fittingProductInfo, out double fittingTotalPrice,out double fittingProductWeight,out double fittingProductIntergal) { ShowShop.BLL.Product.ProductInfo productbll = new ShowShop.BLL.Product.ProductInfo(); ShowShop.BLL.Product.ProductSparepart spabll = new ShowShop.BLL.Product.ProductSparepart(); int favourableType = -1; double favourableLimit = 0; int productCount = 0; string fittingInfo = ""; double strfittingPrice = 0; double productWeight = 0; double productIntergal = 0; if (!string.IsNullOrEmpty(SparepartId.Trim()) && Convert.ToInt32(SparepartId) > 0) { ShowShop.Model.Product.ProductSparepart sparModel = spabll.GetModelID(Convert.ToInt32(SparepartId)); if (sparModel != null) { favourableLimit = Convert.ToDouble(sparModel.FavourableLimit.ToString()); favourableType = sparModel.FavourableType; } } if (!string.IsNullOrEmpty(FittingsProductId)) { string[] fittingProIdArr = FittingsProductId.Split(','); string[] fittingProCountArr = FittingsProductCount.Split(','); for (int c = 0; c < fittingProCountArr.Length; c++) { if (!string.IsNullOrEmpty(fittingProCountArr[c].Trim())) { productCount += Convert.ToInt32(fittingProCountArr[c]); } } for (int f = 0; f < fittingProIdArr.Length; f++) { if (!string.IsNullOrEmpty(fittingProIdArr[f].Trim())) { DataTable prodt = productbll.GetAppointField("pro_ID,pro_Name,pro_ShopPrice,pro_RatingDiscount,pro_Specifications,pro_Weight,pro_DonateIntegral", " and pro_ID=" + fittingProIdArr[f]); if (prodt.Rows.Count > 0) { productIntergal += Convert.ToDouble(prodt.Rows[0]["pro_DonateIntegral"].ToString()); productWeight += Convert.ToDouble(prodt.Rows[0]["pro_Weight"].ToString()); double price = Convert.ToDouble(prodt.Rows[0]["pro_ShopPrice"].ToString()); string memberPrice = prodt.Rows[0]["pro_RatingDiscount"].ToString(); if (!string.IsNullOrEmpty(prodt.Rows[0]["pro_Specifications"].ToString())) { //ShowShop.BLL.Product.ProductSpecification proSpe = new ShowShop.BLL.Product.ProductSpecification(); //List<ShowShop.Model.Product.ProductSpecification> proSpeList = proSpe.GetSpecification(Convert.ToInt32(prodt.Rows[0]["pro_ID"].ToString())); //if (proSpeList.Count > 0) //{ // price = Convert.ToDouble(proSpeList[0].SalePrice); // memberPrice = proSpeList[0].MemberPrice; //} } if (HttpContext.Current.Session["MemberID"] != null && !string.IsNullOrEmpty(memberPrice.Trim())) { price = ShowShop.Common.ProductInfo.DiscountedPrice(int.Parse(HttpContext.Current.Session["MemberID"].ToString()), price, memberPrice); } double fittingPrice = price; if (HttpContext.Current.Session["MemberID"] != null) { fittingPrice = DiscountedPrice(Convert.ToInt32(HttpContext.Current.Session["MemberID"].ToString()), fittingPrice, prodt.Rows[0]["pro_RatingDiscount"].ToString()); } if (!string.IsNullOrEmpty(fittingProCountArr[f].Trim())) { fittingPrice = fittingPrice * Convert.ToInt32(fittingProCountArr[f]); } if (favourableType == 0 && favourableLimit > 0) { fittingPrice = fittingPrice * favourableLimit; } else if (favourableType == 1 && favourableLimit > 0) { fittingPrice = fittingPrice - favourableLimit; } strfittingPrice += fittingPrice; fittingInfo += " + " + prodt.Rows[0]["pro_Name"].ToString() + " (" + fittingProCountArr[f] + ")"; } } } } fittingProductWeight = productWeight; FittingProductCount = productCount; fittingTotalPrice = strfittingPrice; fittingProductInfo = fittingInfo; fittingProductIntergal=productIntergal; }
private void del(string StrID) { ShowShop.BLL.Product.ProductInfo bll = new ShowShop.BLL.Product.ProductInfo(); ShowShop.BLL.Product.ProductAlbum pabll = new ShowShop.BLL.Product.ProductAlbum(); ShowShop.BLL.Product.ProductSparepart sbll = new ShowShop.BLL.Product.ProductSparepart(); DataTable dt = bll.GetPartData(StrID); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ChangeHope.Common.FileHelper fh = new ChangeHope.Common.FileHelper(); if (!dt.Rows[i]["pro_Original"].ToString().Contains("http://")) { fh.DeleteFile(Server.MapPath("~//" + dt.Rows[i]["pro_Original"].ToString())); } sbll.DeleteProductSparepart(Convert.ToInt32(dt.Rows[i]["pro_ID"].ToString())); } } bll.Delete(StrID); pabll.DelAll(StrID); Response.Write("ok"); }
/// <summary> /// 上传商品相册图 /// </summary> /// <param name="albumthumbnail"></param> /// <param name="ImagesThumbnailsWidth"></param> /// <param name="ImagesThumbnailsHeight"></param> /// <param name="WhetherWater"></param> /// <param name="ImageWatermarkTransparent"></param> /// <param name="TextWatermarkTransparent"></param> /// <param name="WatermarkPosition"></param> /// <param name="WatermarkImage"></param> /// <param name="WatermarkText"></param> /// <param name="TextOrImagesWatermark"></param> protected string Album(int ImagesThumbnailsWidth, int ImagesThumbnailsHeight, bool WhetherWater, int ImageWatermarkTransparent, int TextWatermarkTransparent, string WatermarkPosition, string WatermarkImage, string WatermarkText, string TextOrImagesWatermark, bool IsModfiy, int SignId) { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); string gomessage = ""; ShowShop.BLL.Product.ProductInfo bll = new ShowShop.BLL.Product.ProductInfo(); System.Web.HttpFileCollection files = System.Web.HttpContext.Current.Request.Files; ShowShop.BLL.Product.ProductAlbum pabll = new ShowShop.BLL.Product.ProductAlbum(); ShowShop.Model.Product.ProductAlbum pamodel = new ShowShop.Model.Product.ProductAlbum(); string[] rd = null; string des = ChangeHope.WebPage.PageRequest.GetFormString("description"); if (!string.IsNullOrEmpty(des)) { rd = des.Split(',');//获得图片描述的文本框字符串数组,为对应的图片的描述 } if (files.Count > 1)//说明图片大小和格式都没问题 { ShowShop.BLL.Product.ProductAlbum PGBLL = new ShowShop.BLL.Product.ProductAlbum(); ShowShop.Model.Product.ProductAlbum PGModel = new ShowShop.Model.Product.ProductAlbum(); int autouFile=files.Count; ChangeHope.Common.UploadProcesedImages wm = new ChangeHope.Common.UploadProcesedImages(); ChangeHope.Common.UploadFile uf = new ChangeHope.Common.UploadFile(); string AlbumThumbnailSave = "/yxuploadfile/product/albumthumbnail"; string AlbumOriginalSave = "/yxuploadfile/product/albumoriginal"; string AlbumThumbnail = string.Empty; string AlbumOriginal = string.Empty; string Message = string.Empty; uf.ExtensionLim = ".gif,.jpg,.jpeg,.bmp"; uf.FileLengthLim = sp.ImageSize; for (int i = 1; i < files.Count; i++) { uf.MyFile = files[i]; uf.SavePath = AlbumOriginalSave; if (uf.HTMLUpLoad()) { if (uf.HaveLoad) { AlbumOriginal = uf.FilePath; //原图缩略图 wm.SourceImagePath = AlbumOriginal; wm.ThumbnailImagePath = AlbumOriginalSave; wm.ThumbnailImageWidth = ImagesThumbnailsWidth; wm.ThumbnailImageHeight = ImagesThumbnailsHeight; if (wm.ToThumbnailImage()) { AlbumThumbnail = wm.FilePath; } else { gomessage += "<br>" + wm.Message; } } else { gomessage += "<br>" + uf.Message; } if (WhetherWater) { //原图水印 if (!string.IsNullOrEmpty(AlbumOriginal)) { wm.SourceImagePath = AlbumOriginal; wm.ImageDeaphaneity = float.Parse(ImageWatermarkTransparent.ToString()); wm.Diaphaneity = TextWatermarkTransparent; switch (WatermarkPosition) { case "1": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.LeftTop; break; case "2": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.LeftBottom; break; case "3": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.RightTop; break; case "4": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.RightBottom; break; case "5": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.CenterTop; break; case "9": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.Center; break; case "7": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.CenterBottom; break; } if (TextOrImagesWatermark == "0") { //图片水印 if (!string.IsNullOrEmpty(WatermarkImage)) { wm.WaterMarkImagePath = WatermarkImage; } else { gomessage += "<br>" + "操作失败,上传图片水印失败,请确认系统设置水印图片是否存在。"; } } else { //文字水印 if (!string.IsNullOrEmpty(WatermarkText)) { wm.WaterMarkText = WatermarkText; } else { gomessage += "<br>" + "操作失败,上传图片水印失败,请确认系统设置水印文字是否存在。"; } } wm.SaveWaterMarkImagePath = AlbumOriginalSave; if (wm.ToWaterMark()) { AlbumOriginal = wm.FilePath; } else { gomessage += "<br>" + "操作失败," + wm.Message + ""; } } //原图缩略图水印 if (!string.IsNullOrEmpty(AlbumThumbnail)) { wm.SourceImagePath = AlbumThumbnail; wm.ImageDeaphaneity = float.Parse(ImageWatermarkTransparent.ToString()); wm.Diaphaneity = TextWatermarkTransparent; switch (WatermarkPosition) { case "1": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.LeftTop; break; case "2": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.LeftBottom; break; case "3": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.RightTop; break; case "4": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.RightBottom; break; case "5": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.CenterTop; break; case "9": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.Center; break; case "7": wm.WaterMarkAlign = ChangeHope.Common.ImageAlign.CenterBottom; break; } if (TextOrImagesWatermark == "0") { //图片水印 if (!string.IsNullOrEmpty(WatermarkImage)) { wm.WaterMarkImagePath = WatermarkImage; } else { gomessage += "<br>" + "操作失败,上传图片水印失败,请确认系统设置水印图片是否存在。"; } } else { //文字水印 if (!string.IsNullOrEmpty(WatermarkText)) { wm.WaterMarkText = WatermarkText; } else { gomessage += "<br>" + "操作失败,上传图片水印失败,请确认系统设置水印文字是否存在。"; } } wm.SaveWaterMarkImagePath = AlbumThumbnailSave; if (wm.ToWaterMark()) { AlbumThumbnail = wm.FilePath; } else { gomessage += "<br>" + "操作失败," + wm.Message + ""; } } } } pamodel.Productid = 0; pamodel.OriginalAddress = AlbumOriginal; pamodel.ThumbnailAddress = AlbumThumbnail; pamodel.IsSpecialspecificationsSign = 1; pamodel.SpecificaticationSignId = SignId; pamodel.Description = ""; if (AlbumThumbnail != string.Empty) { pabll.Add(pamodel); } } } return gomessage; }
private string GetProductNameById(int id,int commentTypeId) { string reStr = string.Empty; if (commentTypeId == 1) { ShowShop.BLL.Product.ProductInfo productBll = new ShowShop.BLL.Product.ProductInfo(); ShowShop.Model.Product.ProductInfo info = productBll.GetModel(id); if (info != null) { reStr="<span style='color:red;'>(商品)</span>"+ChangeHope.Common.StringHelper.SubStringAndAppend(info.ProductName.ToString(), 15, "..."); } } else if (commentTypeId == 2) { // ShowShop.BLL.Shop.Shop shopbll = new ShowShop.BLL.Shop.Shop(); // ShowShop.Model.Shop.Shop shopmode = shopbll.GetModelById(id); //if (shopmode != null) //{ // reStr = "<span style='color:red;'>(店铺)</span>" + ChangeHope.Common.StringHelper.SubStringAndAppend(shopmode.Shopname, 15, "...");; //} } return reStr; }
protected void Button2_Click(object sender, EventArgs e) { string orderId = this.hfOrderId.Value.Trim(); if (string.IsNullOrEmpty(this.hfid.Value)) { ChangeHope.WebPage.BasePage.PageError("请选择商品.", "order_modify.aspx?OrderId=" + orderId, ""); } ShowShop.Model.Order.OrderProduct model = new ShowShop.Model.Order.OrderProduct(); ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct(); ShowShop.BLL.Order.Orders ordbll = new ShowShop.BLL.Order.Orders(); ShowShop.BLL.Product.ProductInfo bllProductInfo = new ShowShop.BLL.Product.ProductInfo(); string[] idStr = this.hfid.Value.Split(','); string productId = idStr[0]; string specificationId = idStr.Length > 1 ? idStr[1] : ""; string specificationVa = ""; decimal spePrice = 0; //if (!string.IsNullOrEmpty(specificationId.Trim())) //{ // ShowShop.BLL.Product.ProductSpecification proSpe = new ShowShop.BLL.Product.ProductSpecification(); // ShowShop.Model.Product.ProductSpecification proModel = proSpe.GetModelID(Convert.ToInt32(specificationId)); //if (proModel != null) //{ // specificationVa = proModel.Specifications; // spePrice = Convert.ToDecimal(proModel.SalePrice); //} // } ChangeHope.DataBase.DataByPage db = bll.GetListByPage(" and ProId=" + productId + " and OrderId=" + orderId + " and Specification='" + specificationVa + "'"); ShowShop.Model.Order.Orders ordModel = ordbll.GetModel(this.blOrderNo.Text.Trim()); if (db.DataReader == null) { ShowShop.Model.Product.ProductInfo modelProductInfo = bllProductInfo.GetModel(Convert.ToInt32(productId)); if (modelProductInfo != null) { model.AddTime = System.DateTime.Now; model.OrderId =Convert.ToInt32(orderId); model.ProId = Convert.ToInt32(modelProductInfo.ProductID); model.ProClass = modelProductInfo.ClassID.ToString(); model.ProImg = modelProductInfo.Thumbnail; model.ProName = modelProductInfo.ProductName; model.ProNum = 1; model.ProOtherPara = ""; model.ProPrice = spePrice; model.Specification = specificationVa; model.FittingsId = 0; model.FittingsProductCount = ""; model.FittingsProductId = ""; model.FittingsProductPrice = ""; bll.Add(model); if (ordModel != null) { ordbll.Amend(ordModel.Id, "TotalPrice",Convert.ToDecimal(ordModel.TotalPrice)+Convert.ToDecimal(spePrice)); ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) + Convert.ToDecimal(spePrice)); } } } else { if(db.DataReader.Read()) { bll.Amend(Convert.ToInt32(db.DataReader["Id"].ToString()), "ProNum", Convert.ToInt32(db.DataReader["ProNum"].ToString()) + 1); if (ordModel != null) { ordbll.Amend(ordModel.Id, "TotalPrice", Convert.ToDecimal(ordModel.TotalPrice) + Convert.ToDecimal(db.DataReader["ProPrice"].ToString())); ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) + Convert.ToDecimal(db.DataReader["ProPrice"].ToString())); } } } DataTable ordProductdt = bll.GetListOrderProduct(orderId); if (ordProductdt.Rows.Count > 0) { } ChangeHope.WebPage.BasePage.PageRight("向" + this.blOrderNo.Text + "添加商品成功.", "order_modify.aspx?OrderId="+orderId, ""); }
private void GetSparepartProductInfo(string strProductId,int sparepartId) { StringBuilder shtml = new StringBuilder(); ShowShop.BLL.Product.ProductInfo bll = new ShowShop.BLL.Product.ProductInfo(); DataTable dt = bll.DTGetListWhere(" and pro_ID in (" + strProductId + ")"); shtml.Append("<table widht='100%'>"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { shtml.Append("<tr style='height:22px'>"); shtml.Append("<td><a href=\"javascript:delSparepartProductId(" + dt.Rows[i]["pro_ID"].ToString() + "," + sparepartId + ")\">删除</a></td>"); shtml.Append("<td width=\"40%\"><span title='" + dt.Rows[i]["pro_Name"].ToString() + "'>" + ChangeHope.Common.StringHelper.SubString(dt.Rows[i]["pro_Name"].ToString(), 20) + "</span></td>"); shtml.Append("<td width=\"50%\"><span title=\"" + dt.Rows[i]["pro_Synopsis"].ToString() + "\">" + ChangeHope.Common.StringHelper.SubString(dt.Rows[i]["pro_Synopsis"].ToString(), 30) + "</span></td>"); shtml.Append("</tr>"); } } shtml.Append("</table>"); Response.Write(shtml.ToString()); }