/// <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;
}
}
}
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);
}
}
}
}
}
}
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, "");
}