/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
ShowShop.BLL.Order.Orders orderBll = new ShowShop.BLL.Order.Orders();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListByPage();
//第一步先添加表头
table.AddHeadCol("", "订单号");
table.AddHeadCol("", "用户账号");
table.AddHeadCol("", "收货人");
table.AddHeadCol("", "商品名称");
table.AddHeadCol("", "实际价格");
table.AddHeadCol("", "下单时间");
table.AddHeadCol("", "状态");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
ShowShop.Model.Order.Orders orderModel = orderBll.GetModel(Convert.ToInt32(dataPage.DataReader["OrderId"].ToString()));
if (orderModel != null)
{
table.AddCol(orderModel.OrderId);
table.AddCol(orderModel.UserId);
table.AddCol(orderModel.ConsigneeName);
table.AddCol(dataPage.DataReader["ProName"].ToString());
table.AddCol(dataPage.DataReader["ProPrice"].ToString());
table.AddCol(orderModel.OrderDate.ToString());
table.AddCol(this.ShowStatu(orderModel.OrderStatus));
table.AddRow();
}
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
private void OrdersProduct(int orderId)
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListByPage(" and OrderId=" + orderId);
table.AddHeadCol("50%", "商品名称");
table.AddHeadCol("", "单价");
table.AddHeadCol("", "数量");
table.AddHeadCol("", "小计(单位：元)");
table.AddRow();
double ProductTotalPrice = 0;
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
string fittingsProductId = dataPage.DataReader["FittingsProductId"].ToString();
string fittingsId = dataPage.DataReader["FittingsId"].ToString();
string fittingsProductCount = dataPage.DataReader["FittingsProductCount"].ToString();
string fittingProductInfo = "";
double fittingTotalPrice = 0;
if (!string.IsNullOrEmpty(fittingsProductId.Trim()) && !string.IsNullOrEmpty(fittingsId.Trim()) && Convert.ToInt32(fittingsId) > 0)
{
//配件
int fittingProductCount = 0;
double fittingProductWeight = 0;
double fittingProductIntergal = 0;
ShowShop.Common.ProductInfo.FittingDisposal(fittingsId, fittingsProductId, fittingsProductCount, out fittingProductCount, out fittingProductInfo, out fittingTotalPrice, out fittingProductWeight, out fittingProductIntergal);
}
string specificationValue = dataPage.DataReader["Specification"].ToString();
string specVa = "";
if (specificationValue != "")
{
specVa = " " + specificationValue + "";
}
table.AddCol("<a href='../../product/productcontent.aspx?q_productid=" + dataPage.DataReader["ProId"].ToString() + "' target='_blank'>" + dataPage.DataReader["ProName"].ToString() + specVa + fittingProductInfo + "</a>");
table.AddCol(Convert.ToDouble(dataPage.DataReader["ProPrice"].ToString()).ToString("f2"));
table.AddCol(dataPage.DataReader["ProNum"].ToString());
table.AddCol((Convert.ToDouble(dataPage.DataReader["ProPrice"].ToString()) * Convert.ToDouble(dataPage.DataReader["ProNum"].ToString()) + fittingTotalPrice).ToString("f2"));
table.AddRow();
ProductTotalPrice += Convert.ToDouble(dataPage.DataReader["ProPrice"].ToString()) * Convert.ToDouble(dataPage.DataReader["ProNum"].ToString()) + fittingTotalPrice ;
}
table.AddCol("4", "<strong>本页金额合计：" + ProductTotalPrice.ToString("f2") + "</strong>");
table.AddRow();
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
this.litData.Text = view;
}
else
{
this.litData.Text = "没有找到该订单的商品信息";
}
}
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, "");
}
