private double TotalPrice(string orderId)
{
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
DataTable dt = bll.GetListOrderProduct(orderId);
double totalPrice = 0;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
totalPrice += Convert.ToDouble(dt.Rows[i]["ProPrice"].ToString()) * Convert.ToDouble(dt.Rows[i]["ProNum"].ToString());
}
}
return totalPrice;
}
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 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);
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (ChangeHope.WebPage.PageRequest.GetFormString("Option") != string.Empty)
{
string types = Request["Option"].Trim();
string id = ChangeHope.WebPage.PageRequest.GetFormString("Id");
if (types == "ModifyPrice")
{
string price = ChangeHope.WebPage.PageRequest.GetFormString("Price");
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
ShowShop.Model.Order.OrderProduct orderProductModel = bll.GetModel(Convert.ToInt32(id));
if (orderProductModel != null)
{
ShowShop.BLL.Order.Orders ordbll = new ShowShop.BLL.Order.Orders();
ShowShop.Model.Order.Orders ordModel = ordbll.GetModel(Convert.ToInt32(orderProductModel.OrderId));
if (ordModel != null)
{
if (Convert.ToDecimal(orderProductModel.ProPrice) > Convert.ToDecimal(price))
{
decimal productPrice = Convert.ToDecimal(orderProductModel.ProPrice) - Convert.ToDecimal(price);
ordbll.Amend(ordModel.Id, "TotalPrice", Convert.ToDecimal(ordModel.TotalPrice) - (Convert.ToDecimal(orderProductModel.ProNum) * Convert.ToDecimal(productPrice)));
ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) - (Convert.ToDecimal(orderProductModel.ProNum) * Convert.ToDecimal(productPrice)));
}
else
{
decimal productPrice = Convert.ToDecimal(price) - Convert.ToDecimal(orderProductModel.ProPrice);
ordbll.Amend(ordModel.Id, "TotalPrice", Convert.ToDecimal(ordModel.TotalPrice) + (Convert.ToDecimal(orderProductModel.ProNum) * Convert.ToDecimal(productPrice)));
ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) + (Convert.ToDecimal(orderProductModel.ProNum) * Convert.ToDecimal(productPrice)));
}
if (bll.Amend(Convert.ToInt32(id), "ProPrice", price) != 1)
{
Response.Write("ok");
}
}
}
}
else if (types == "ModifyCount")
{
string Count = ChangeHope.WebPage.PageRequest.GetFormString("Count");
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
ShowShop.Model.Order.OrderProduct orderProductModel = bll.GetModel(Convert.ToInt32(id));
if (orderProductModel != null)
{
ShowShop.BLL.Order.Orders ordbll = new ShowShop.BLL.Order.Orders();
ShowShop.Model.Order.Orders ordModel = ordbll.GetModel(Convert.ToInt32(orderProductModel.OrderId));
if (ordModel != null)
{
if (Convert.ToInt32(orderProductModel.ProNum) > Convert.ToInt32(Count))
{
int productCount = Convert.ToInt32(orderProductModel.ProNum) - Convert.ToInt32(Count);
ordbll.Amend(ordModel.Id, "TotalPrice", Convert.ToDecimal(ordModel.TotalPrice) - (Convert.ToDecimal(orderProductModel.ProPrice) * Convert.ToDecimal(productCount)));
ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) - (Convert.ToDecimal(orderProductModel.ProPrice) * Convert.ToDecimal(productCount)));
}
else
{
int productCount = Convert.ToInt32(Count) - Convert.ToInt32(orderProductModel.ProNum);
ordbll.Amend(ordModel.Id, "TotalPrice", Convert.ToDecimal(ordModel.TotalPrice) + (Convert.ToDecimal(orderProductModel.ProPrice) * Convert.ToDecimal(productCount)));
ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) + (Convert.ToDecimal(orderProductModel.ProPrice) * Convert.ToDecimal(productCount)));
}
if (bll.Amend(Convert.ToInt32(id), "ProNum", Count) != 1)
{
Response.Write("ok");
}
}
}
}
else if (types == "DelProduct")
{
string OrderID = ChangeHope.WebPage.PageRequest.GetFormString("OrderID");
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
DataTable dt = bll.GetListOrderProduct(OrderID.Trim());
if (dt.Rows.Count > 1)
{
ShowShop.Model.Order.OrderProduct orderProductModel = bll.GetModel(Convert.ToInt32(id));
if (orderProductModel != null)
{
ShowShop.BLL.Order.Orders ordbll = new ShowShop.BLL.Order.Orders();
ShowShop.Model.Order.Orders ordModel = ordbll.GetModel(Convert.ToInt32(OrderID));
if (ordModel != null)
{
ordbll.Amend(ordModel.Id, "TotalPrice", Convert.ToDecimal(ordModel.TotalPrice) - (Convert.ToDecimal(orderProductModel.ProPrice)*Convert.ToDecimal(orderProductModel.ProNum)));
ordbll.Amend(ordModel.Id, "FactPrice", Convert.ToDecimal(ordModel.FactPrice) - (Convert.ToDecimal(orderProductModel.ProPrice) * Convert.ToDecimal(orderProductModel.ProNum)));
bll.Delete(Convert.ToInt32(id));
}
}
}
else
{
Response.Write("删除失败,该订单删除后没有商品列表!");
}
}
Response.End();
}
int orderId = ChangeHope.WebPage.PageRequest.GetQueryInt("OrderId");
if (!IsPostBack)
{
this.DeliverBind();
this.OrderInfo(orderId);
this.OrdersProduct(orderId);
}
}
