private void BindOrderInfo(PurchaseOrderInfo order)
{
litAddress.Text = order.ShippingRegion + order.Address;
litCellPhone.Text = order.CellPhone;
litTelPhone.Text = order.TelPhone;
litZipCode.Text = order.ZipCode;
litOrderId.Text = order.OrderId;
litOrderDate.Text = order.PurchaseDate.ToString();
litRemark.Text = order.Remark;
litShipperMode.Text = order.RealModeName;
litShippNo.Text = order.ShipOrderNumber;
litSkipTo.Text = order.ShipTo;
switch (order.PurchaseStatus)
{
case OrderStatus.WaitBuyerPay:
litOrderStatus.Text = "等待付款";
break;
case OrderStatus.BuyerAlreadyPaid:
litOrderStatus.Text = "已付款等待发货";
break;
case OrderStatus.SellerAlreadySent:
litOrderStatus.Text = "已发货";
break;
case OrderStatus.Closed:
litOrderStatus.Text = "已关闭";
break;
case OrderStatus.Finished:
litOrderStatus.Text = "已完成";
break;
}
}
private void BindOrderInfo(PurchaseOrderInfo order)
{
litAddress.Text = order.ShippingRegion + order.Address;
litCellPhone.Text = order.CellPhone;
litTelPhone.Text = order.TelPhone;
litZipCode.Text = order.ZipCode;
litOrderId.Text = order.OrderId;
litOrderDate.Text = order.PurchaseDate.ToString();
litRemark.Text = order.Remark;
litShipperMode.Text = order.RealModeName;
litShippNo.Text = order.ShipOrderNumber;
litSkipTo.Text = order.ShipTo;
string str = string.Empty;
if (order.PurchaseOrderOptions.Count > 0)
{
IList<PurchaseOrderOptionInfo> purchaseOrderOptions = order.PurchaseOrderOptions;
str = str + "（";
foreach (PurchaseOrderOptionInfo info in purchaseOrderOptions)
{
string str2 = str;
str = str2 + info.ListDescription + "：" + info.ItemDescription + "；" + info.CustomerTitle + "：" + info.CustomerDescription;
}
str = str + "）";
litOptionDes.Text = str;
}
switch (order.PurchaseStatus)
{
case OrderStatus.WaitBuyerPay:
litOrderStatus.Text = "等待付款";
break;
case OrderStatus.BuyerAlreadyPaid:
litOrderStatus.Text = "已付款等待发货";
break;
case OrderStatus.SellerAlreadySent:
litOrderStatus.Text = "已发货";
break;
case OrderStatus.Closed:
litOrderStatus.Text = "已关闭";
break;
case OrderStatus.Finished:
litOrderStatus.Text = "已完成";
break;
}
litOptionMoney.Money = order.GetOptionPrice();
litShippMoney.Money = order.AdjustedFreight;
litTotalMoney.Money = order.OrderTotal;
litDiscountMoney.Money = order.AdjustedDiscount;
decimal num = 0M;
foreach (PurchaseOrderItemInfo info2 in order.PurchaseOrderItems)
{
num += info2.ItemListPrice * info2.Quantity;
}
litItemsMoney.Money = num;
}
private void BindOrderItems(PurchaseOrderInfo order)
{
grdOrderItems.DataSource = order.PurchaseOrderItems;
grdOrderItems.DataBind();
if (order.PurchaseOrderGifts.Count > 0)
{
grdOrderGifts.DataSource = order.PurchaseOrderGifts;
grdOrderGifts.DataBind();
}
else
{
grdOrderGifts.Visible = false;
}
}
private void BindCharges(PurchaseOrderInfo purchaseOrder)
{
lblModeName.Text = purchaseOrder.ModeName;
litFreight.Text = Globals.FormatMoney(purchaseOrder.AdjustedFreight);
litOptionPrice.Text = Globals.FormatMoney(purchaseOrder.GetOptionPrice());
litDiscount.Text = Globals.FormatMoney(purchaseOrder.AdjustedDiscount);
litTotalPrice.Text = Globals.FormatMoney(purchaseOrder.GetPurchaseTotal());
string str = string.Empty;
if (purchaseOrder.PurchaseOrderOptions.Count > 0)
{
foreach (PurchaseOrderOptionInfo info in purchaseOrder.PurchaseOrderOptions)
{
string str2 = str;
str = str2 + info.ListDescription + "：" + info.ItemDescription + "；" + info.CustomerTitle + "：" + info.CustomerDescription;
}
}
if (!string.IsNullOrEmpty(str))
{
litOderItem.Text = "（" + str + "）";
}
}
protected void Page_Load(object sender, EventArgs e)
{
btnConfirmPay.Click += new EventHandler(btnConfirmPay_Click);
btnBack.Click += new EventHandler(btnBack_Click);
btnBack1.Click += new EventHandler(btnBack_Click);
imgBtnBack.Click += new System.Web.UI.ImageClickEventHandler(btnBack_Click);
if (string.IsNullOrEmpty(base.Request.QueryString["PurchaseOrderId"]))
{
base.GotoResourceNotFound();
}
else
{
purchaseOrderId = base.Request.QueryString["PurchaseOrderId"];
purchaseOrder = SubsiteSalesHelper.GetPurchaseOrder(purchaseOrderId);
if (!base.IsPostBack)
{
if (purchaseOrder == null)
{
base.GotoResourceNotFound();
}
else
{
if (purchaseOrder.IsManualPurchaseOrder)
{
litorder.Visible = false;
litOrderId.Visible = false;
}
else
{
litOrderId.Text = purchaseOrder.OrderId;
}
litPurchaseOrderId.Text = purchaseOrder.PurchaseOrderId;
lblPurchaseDate.Time = purchaseOrder.PurchaseDate;
lblTotalPrice.Money = purchaseOrder.GetPurchaseTotal();
AccountSummaryInfo myAccountSummary = SubsiteStoreHelper.GetMyAccountSummary();
lblUseableBalance.Money = myAccountSummary.UseableBalance;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.Request.QueryString["PurchaseOrderId"] == null)
{
base.GotoResourceNotFound();
}
else
{
purchaseOrderId = Page.Request.QueryString["PurchaseOrderId"];
purchaseOrder = SubsiteSalesHelper.GetPurchaseOrder(purchaseOrderId);
btnSearch.Click += new EventHandler(btnSearch_Click);
btnClear.Click += new EventHandler(btnClear_Click);
dlstGifts.ItemCommand += new DataListCommandEventHandler(dlstGifts_ItemCommand);
dlstOrderGifts.DeleteCommand += new DataListCommandEventHandler(dlstOrderGifts_DeleteCommand);
btnReturn.Click += new EventHandler(btnReturn_Click);
if (!base.IsPostBack)
{
if (purchaseOrder == null)
{
base.GotoResourceNotFound();
}
else if (purchaseOrder.PurchaseStatus != OrderStatus.WaitBuyerPay)
{
base.GotoResourceNotFound();
}
else
{
if (purchaseOrder.PurchaseOrderGifts.Count > 0)
{
litPageTitle.Text = "编辑采购单礼品";
}
BindGifts();
BindOrderGifts();
}
}
}
}
protected override void OnInit(EventArgs e)
{
if (string.IsNullOrEmpty(Page.Request.QueryString["PurchaseOrderId"]))
{
base.GotoResourceNotFound();
}
else
{
purchaseOrderId = Page.Request.QueryString["PurchaseOrderId"];
purchaseOrder = SubsiteSalesHelper.GetPurchaseOrder(purchaseOrderId);
if (purchaseOrder == null)
{
base.GotoResourceNotFound();
}
else if (purchaseOrder.PurchaseStatus != pagePurchaseStatus)
{
Redirect();
}
else
{
base.OnInit(e);
}
}
}
public static bool ClosePurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
bool flag = SalesProvider.Instance().ClosePurchaseOrder(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "关闭了编号为\"{0}\"的采购单", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
PurchaseOrderInfo ConvertOrderToPurchaseOrder(OrderInfo order)
{
if (order == null)
{
return null;
}
StringBuilder builder = new StringBuilder();
string query = "";
foreach (LineItemInfo info in order.LineItems.Values)
{
builder.AppendFormat("'" + info.SkuId + "',", new object[0]);
}
if (builder.Length > 0)
{
builder = builder.Remove(builder.Length - 1, 1);
query = string.Format("SELECT S.SkuId, S.CostPrice, p.ProductName FROM Hishop_Products P JOIN Hishop_SKUs S ON P.ProductId = S.ProductId WHERE S.SkuId IN({0});", builder);
}
if (order.Gifts.Count > 0)
{
StringBuilder builder2 = new StringBuilder();
foreach (OrderGiftInfo info2 in order.Gifts)
{
builder2.AppendFormat(info2.GiftId.ToString() + ",", new object[0]);
}
builder2.Remove(builder2.Length - 1, 1);
query = query + string.Format(" SELECT GiftId, CostPrice FROM Hishop_Gifts WHERE GiftId IN({0});", builder2.ToString());
}
DbCommand sqlStringCommand = database.GetSqlStringCommand(query);
Dictionary<string, PurchaseOrderItemInfo> dictionary = new Dictionary<string, PurchaseOrderItemInfo>();
Dictionary<int, decimal> dictionary2 = new Dictionary<int, decimal>();
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
if (order.LineItems.Values.Count > 0)
{
while (reader.Read())
{
PurchaseOrderItemInfo info3 = new PurchaseOrderItemInfo();
if (reader["CostPrice"] != DBNull.Value)
{
info3.ItemCostPrice = (decimal)reader["CostPrice"];
}
info3.ItemHomeSiteDescription = (string)reader["ProductName"];
dictionary.Add((string)reader["SkuId"], info3);
}
}
if (order.Gifts.Count > 0)
{
if (order.LineItems.Count > 0)
{
reader.NextResult();
}
while (reader.Read())
{
dictionary2.Add((int)reader["GiftId"], (DBNull.Value == reader["CostPrice"]) ? 0M : Convert.ToDecimal(reader["CostPrice"]));
}
}
}
IUser user = Users.GetUser(HiContext.Current.SiteSettings.UserId.Value, false);
if ((user == null) || (user.UserRole != UserRole.Distributor))
{
return null;
}
Distributor distributor = user as Distributor;
PurchaseOrderInfo info4 = new PurchaseOrderInfo();
info4.PurchaseOrderId = "PO" + order.OrderId;
info4.OrderId = order.OrderId;
info4.Remark = order.Remark;
info4.PurchaseStatus = OrderStatus.WaitBuyerPay;
info4.DistributorId = distributor.UserId;
info4.Distributorname = distributor.Username;
info4.DistributorEmail = distributor.Email;
info4.DistributorRealName = distributor.RealName;
info4.DistributorQQ = distributor.QQ;
info4.DistributorWangwang = distributor.Wangwang;
info4.DistributorMSN = distributor.MSN;
info4.ShippingRegion = order.ShippingRegion;
info4.Address = order.Address;
info4.ZipCode = order.ZipCode;
info4.ShipTo = order.ShipTo;
info4.TelPhone = order.TelPhone;
info4.CellPhone = order.CellPhone;
info4.ShippingModeId = order.ShippingModeId;
info4.ModeName = order.ModeName;
info4.RegionId = order.RegionId;
info4.Freight = order.Freight;
info4.AdjustedFreight = order.Freight;
info4.ShipOrderNumber = order.ShipOrderNumber;
info4.Weight = order.Weight;
info4.RefundStatus = RefundStatus.None;
info4.OrderTotal = order.GetTotal();
info4.ExpressCompanyName = order.ExpressCompanyName;
info4.ExpressCompanyAbb = order.ExpressCompanyAbb;
foreach (LineItemInfo info5 in order.LineItems.Values)
{
PurchaseOrderItemInfo item = new PurchaseOrderItemInfo();
item.PurchaseOrderId = info4.PurchaseOrderId;
item.SkuId = info5.SkuId;
item.ProductId = info5.ProductId;
item.SKU = info5.SKU;
item.Quantity = info5.ShipmentQuantity;
foreach (KeyValuePair<string, PurchaseOrderItemInfo> pair in dictionary)
{
if (pair.Key == info5.SkuId)
{
item.ItemCostPrice = pair.Value.ItemCostPrice;
item.ItemHomeSiteDescription = pair.Value.ItemHomeSiteDescription;
}
}
item.ItemPurchasePrice = info5.ItemCostPrice;
item.ItemListPrice = info5.ItemListPrice;
item.ItemDescription = info5.ItemDescription;
item.SKUContent = info5.SKUContent;
item.ThumbnailsUrl = info5.ThumbnailsUrl;
item.ItemWeight = info5.ItemWeight;
if (string.IsNullOrEmpty(item.ItemHomeSiteDescription))
{
item.ItemHomeSiteDescription = item.ItemDescription;
}
info4.PurchaseOrderItems.Add(item);
}
foreach (OrderGiftInfo info7 in order.Gifts)
{
PurchaseOrderGiftInfo info8 = new PurchaseOrderGiftInfo();
info8.PurchaseOrderId = info4.PurchaseOrderId;
foreach (KeyValuePair<int, decimal> pair2 in dictionary2)
{
if (pair2.Key == info7.GiftId)
{
info8.CostPrice = pair2.Value;
}
}
info8.PurchasePrice = info7.CostPrice;
info8.GiftId = info7.GiftId;
info8.GiftName = info7.GiftName;
info8.Quantity = info7.Quantity;
info8.ThumbnailsUrl = info7.ThumbnailsUrl;
info4.PurchaseOrderGifts.Add(info8);
}
foreach (OrderOptionInfo info9 in order.OrderOptions)
{
PurchaseOrderOptionInfo info10 = new PurchaseOrderOptionInfo();
info10.PurchaseOrderId = info4.PurchaseOrderId;
info10.LookupListId = info9.LookupListId;
info10.LookupItemId = info9.LookupItemId;
info10.ListDescription = info9.ListDescription;
info10.ItemDescription = info9.ItemDescription;
info10.AdjustedPrice = info9.AdjustedPrice;
info10.CustomerTitle = info9.CustomerTitle;
info10.CustomerDescription = info9.CustomerDescription;
info4.PurchaseOrderOptions.Add(info10);
}
return info4;
}
public override bool ConfirmPayPurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET PurchaseStatus=@PurchaseStatus WHERE PurchaseOrderId = @PurchaseOrderId ");
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
database.AddInParameter(sqlStringCommand, "CloseReason", DbType.String, purchaseOrder.CloseReason);
database.AddInParameter(sqlStringCommand, "PurchaseStatus", DbType.Int32, 2);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
public static bool UpdatePurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
return SalesProvider.Instance().UpdatePurchaseOrder(purchaseOrder);
}
public static bool SavePurchaseOrderShippingAddress(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
if (purchaseOrder.CheckAction(PurchaseOrderActions.MASTER_MODIFY_DELIVER_ADDRESS))
{
bool flag = SalesProvider.Instance().SavePurchaseOrderShippingAddress(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "修改了编号为\"{0}\"的采购单的收货地址", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
return false;
}
public static bool RefundPurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.PurchaseorderRefund);
bool flag = SalesProvider.Instance().RefundPurchaseOrder(purchaseOrder);
if (flag)
{
if (purchaseOrder.PurchaseStatus == OrderStatus.Closed)
{
SalesProvider.Instance().UpdateRefundSubmitPurchaseOrderStock(purchaseOrder);
}
Users.ClearUserCache(Users.GetUser(purchaseOrder.DistributorId));
EventLogs.WriteOperationLog(Privilege.PurchaseorderRefund, string.Format(CultureInfo.InvariantCulture, "对编号为\"{0}\"的采购单退款", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
private PurchaseOrderInfo GetPurchaseOrder(Trade trade)
{
PurchaseOrderInfo info = new PurchaseOrderInfo();
info.PurchaseOrderId = "MPO" + trade.Tid.ToString();
info.TaobaoOrderId = trade.Tid.ToString();
info.ShipTo = trade.ReceiverName;
info.ShippingRegion = trade.ReceiverState + trade.ReceiverCity + trade.ReceiverDistrict;
info.RegionId = RegionHelper.GetRegionIdByName(trade.ReceiverState, trade.ReceiverCity, trade.ReceiverDistrict);
info.Address = trade.ReceiverAddress;
info.TelPhone = trade.ReceiverPhone;
info.ZipCode = trade.ReceiverZip;
info.CellPhone = trade.ReceiverMobile;
info.ShippingModeId = shippingMode.ModeId;
info.ModeName = shippingMode.Name;
info.RealShippingModeId = shippingMode.ModeId;
info.RealModeName = shippingMode.Name;
info.AdjustedDiscount = 0M;
info.OrderTotal = decimal.Parse(trade.Payment);
int totalWeight = 0;
foreach (Order order in trade.Orders)
{
DataTable skuContent = SubSiteProducthelper.GetSkuContent(order.NumIid, order.OuterSkuId);
if ((skuContent != null) && (skuContent.Rows.Count > 0))
{
PurchaseOrderItemInfo item = new PurchaseOrderItemInfo();
foreach (DataRow row in skuContent.Rows)
{
if (!(string.IsNullOrEmpty(row["AttributeName"].ToString()) || string.IsNullOrEmpty(row["ValueStr"].ToString())))
{
object sKUContent = item.SKUContent;
item.SKUContent = string.Concat(new object[] { sKUContent, row["AttributeName"], ":", row["ValueStr"], "; " });
}
}
item.PurchaseOrderId = info.PurchaseOrderId;
item.SkuId = (string)skuContent.Rows[0]["SkuId"];
item.ProductId = (int)skuContent.Rows[0]["ProductId"];
if (skuContent.Rows[0]["SKU"] != DBNull.Value)
{
item.SKU = (string)skuContent.Rows[0]["SKU"];
}
if (skuContent.Rows[0]["Weight"] != DBNull.Value)
{
item.ItemWeight = (int)skuContent.Rows[0]["Weight"];
}
item.ItemPurchasePrice = (decimal)skuContent.Rows[0]["PurchasePrice"];
item.Quantity = int.Parse(order.Num.ToString());
item.ItemListPrice = (decimal)skuContent.Rows[0]["SalePrice"];
if (skuContent.Rows[0]["CostPrice"] != DBNull.Value)
{
item.ItemCostPrice = (decimal)skuContent.Rows[0]["CostPrice"];
}
item.ItemDescription = (string)skuContent.Rows[0]["ProductName"];
item.ItemHomeSiteDescription = (string)skuContent.Rows[0]["ProductName"];
if (skuContent.Rows[0]["ThumbnailUrl40"] != DBNull.Value)
{
item.ThumbnailsUrl = (string)skuContent.Rows[0]["ThumbnailUrl40"];
}
totalWeight += item.ItemWeight * item.Quantity;
info.PurchaseOrderItems.Add(item);
}
}
if (info.PurchaseOrderItems.Count <= 0)
{
return null;
}
info.Weight = totalWeight;
info.AdjustedFreight = SubsiteSalesHelper.CalcFreight(info.RegionId, totalWeight, shippingMode);
info.Freight = info.AdjustedFreight;
info.PurchaseStatus = OrderStatus.WaitBuyerPay;
info.RefundStatus = RefundStatus.None;
info.DistributorId = distributor.UserId;
info.Distributorname = distributor.Username;
info.DistributorEmail = distributor.Email;
info.DistributorRealName = distributor.RealName;
info.DistributorQQ = distributor.QQ;
info.DistributorWangwang = distributor.Wangwang;
info.DistributorMSN = distributor.MSN;
return info;
}
public override void UpdateRefundSubmitPurchaseOrderStock(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("Update Hishop_SKUs Set Stock = Stock + (SELECT SUM(oi.Quantity) FROM Hishop_PurchaseOrderItems oi Where oi.SkuId =Hishop_SKUs.SkuId AND PurchaseOrderId =@PurchaseOrderId) WHERE Hishop_SKUs.SkuId IN (Select SkuId FROM Hishop_PurchaseOrderItems Where PurchaseOrderId =@PurchaseOrderId)");
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
database.ExecuteNonQuery(sqlStringCommand);
}
public override bool UpdatePurchaseOrderShippingMode(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET ShippingModeId=@ShippingModeId ,ModeName=@ModeName WHERE PurchaseOrderId = @PurchaseOrderId");
database.AddInParameter(sqlStringCommand, "ShippingModeId", DbType.Int32, purchaseOrder.ShippingModeId);
database.AddInParameter(sqlStringCommand, "ModeName", DbType.String, purchaseOrder.ModeName);
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
public override bool ConfirmPurchaseOrderFinish(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET PurchaseStatus = @PurchaseStatus, FinishDate=@FinishDate WHERE PurchaseOrderId = @PurchaseOrderId");
database.AddInParameter(sqlStringCommand, "PurchaseStatus", DbType.Int32, 5);
database.AddInParameter(sqlStringCommand, "FinishDate", DbType.DateTime, DateTime.Now);
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
return (database.ExecuteNonQuery(sqlStringCommand) >= 1);
}
public override bool UpdatePurchaseOrderAmount(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET PurchaseTotal=@PurchaseTotal, PurchaseProfit=@PurchaseProfit, AdjustedDiscount=@AdjustedDiscount WHERE PurchaseOrderId=@PurchaseOrderId");
database.AddInParameter(sqlStringCommand, "PurchaseTotal", DbType.Currency, purchaseOrder.GetPurchaseTotal());
database.AddInParameter(sqlStringCommand, "PurchaseProfit", DbType.Currency, purchaseOrder.GetPurchaseProfit());
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
database.AddInParameter(sqlStringCommand, "AdjustedDiscount", DbType.Currency, purchaseOrder.AdjustedDiscount);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
public override bool UpdatePurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET Weight=@Weight,PurchaseProfit=@PurchaseProfit,PurchaseTotal=@PurchaseTotal,AdjustedFreight=@AdjustedFreight WHERE PurchaseOrderId=@PurchaseOrderId");
database.AddInParameter(sqlStringCommand, "Weight", DbType.Int32, purchaseOrder.Weight);
database.AddInParameter(sqlStringCommand, "PurchaseProfit", DbType.Decimal, purchaseOrder.GetPurchaseProfit());
database.AddInParameter(sqlStringCommand, "PurchaseTotal", DbType.Decimal, purchaseOrder.GetPurchaseTotal());
database.AddInParameter(sqlStringCommand, "AdjustedFreight", DbType.Decimal, purchaseOrder.AdjustedFreight);
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
return (database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public static bool ConfirmPayPurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
bool flag = SalesProvider.Instance().ConfirmPayPurchaseOrder(purchaseOrder);
if (flag)
{
SalesProvider.Instance().UpdateProductStock(purchaseOrder.PurchaseOrderId);
SalesProvider.Instance().UpdateDistributorAccount(purchaseOrder.GetPurchaseTotal(), purchaseOrder.DistributorId);
Users.ClearUserCache(Users.GetUser(purchaseOrder.DistributorId));
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "对编号为\"{0}\"的采购单线下收款", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
public static bool ConfirmPurchaseOrderFinish(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
if (purchaseOrder.CheckAction(PurchaseOrderActions.MASTER_FINISH_TRADE))
{
bool flag = SalesProvider.Instance().ConfirmPurchaseOrderFinish(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "完成编号为\"{0}\"的采购单", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
return false;
}
public override PurchaseOrderInfo GetPurchaseOrder(string purchaseOrderId)
{
PurchaseOrderInfo info = new PurchaseOrderInfo();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_PurchaseOrders Where PurchaseOrderId = @PurchaseOrderId");
this.database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrderId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (!reader.Read())
{
return info;
}
info.PurchaseOrderId = (string) reader["PurchaseOrderId"];
if (DBNull.Value != reader["ExpressCompanyAbb"])
{
info.ExpressCompanyAbb = (string) reader["ExpressCompanyAbb"];
}
if (DBNull.Value != reader["ExpressCompanyName"])
{
info.ExpressCompanyName = (string) reader["ExpressCompanyName"];
}
if (DBNull.Value != reader["ShipOrderNumber"])
{
info.ShipOrderNumber = (string) reader["ShipOrderNumber"];
}
if (DBNull.Value != reader["PurchaseStatus"])
{
info.PurchaseStatus = (OrderStatus) reader["PurchaseStatus"];
}
}
return info;
}
public static bool SavePurchaseOrderRemark(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.PurchaseorderMark);
bool flag = SalesProvider.Instance().SavePurchaseOrderRemark(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.PurchaseorderMark, string.Format(CultureInfo.InvariantCulture, "对编号为\"{0}\"的采购单备注", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ValidateCreateOrder())
{
string str = "";
PurchaseOrderInfo purchaseOrderInfo = new PurchaseOrderInfo();
Distributor user = Users.GetUser(HiContext.Current.User.UserId) as Distributor;
purchaseOrderInfo.PurchaseOrderId = GeneratePurchaseOrderId();
int totalWeight = 0;
for (int i = 0; i < rpTaobaoOrder.Items.Count; i++)
{
CheckBox box = (CheckBox)rpTaobaoOrder.Items[i].FindControl("chkTbOrder");
if (box.Checked)
{
str = str + tbOrders[i].orderId + ",";
Repeater repeater = (Repeater)rpTaobaoOrder.Items[i].FindControl("reOrderItems");
IList<tbOrderItem> items = tbOrders[i].items;
for (int j = 0; j < repeater.Items.Count; j++)
{
if (items[j].localSkuId.Trim() == "")
{
string msg = string.Format("在授权给分销商的商品中没有找到淘宝商品：{0}！请重新查找", items[j].title);
ShowMsg(msg, false);
return;
}
string localSkuId = items[j].localSkuId;
TextBox box2 = (TextBox)repeater.Items[j].FindControl("productNumber");
int num4 = Convert.ToInt32(box2.Text);
bool flag = false;
foreach (PurchaseOrderItemInfo info2 in purchaseOrderInfo.PurchaseOrderItems)
{
if (info2.SKU == localSkuId)
{
flag = true;
info2.Quantity += num4;
totalWeight += info2.ItemWeight * num4;
}
}
if (!flag)
{
DataTable skuContentBySku = SubSiteProducthelper.GetSkuContentBySku(localSkuId);
PurchaseOrderItemInfo item = new PurchaseOrderItemInfo();
if (num4 > ((int)skuContentBySku.Rows[0]["Stock"]))
{
ShowMsg("商品库存不够", false);
return;
}
foreach (DataRow row in skuContentBySku.Rows)
{
if (!(string.IsNullOrEmpty(row["AttributeName"].ToString()) || string.IsNullOrEmpty(row["ValueStr"].ToString())))
{
object sKUContent = item.SKUContent;
item.SKUContent = string.Concat(new object[] { sKUContent, row["AttributeName"], ":", row["ValueStr"], "; " });
}
}
item.PurchaseOrderId = purchaseOrderInfo.PurchaseOrderId;
item.SkuId = localSkuId;
item.ProductId = (int)skuContentBySku.Rows[0]["ProductId"];
if (skuContentBySku.Rows[0]["SKU"] != DBNull.Value)
{
item.SKU = (string)skuContentBySku.Rows[0]["SKU"];
}
if (skuContentBySku.Rows[0]["Weight"] != DBNull.Value)
{
item.ItemWeight = (int)skuContentBySku.Rows[0]["Weight"];
}
item.ItemPurchasePrice = (decimal)skuContentBySku.Rows[0]["PurchasePrice"];
item.Quantity = num4;
item.ItemListPrice = (decimal)skuContentBySku.Rows[0]["SalePrice"];
if (skuContentBySku.Rows[0]["CostPrice"] != DBNull.Value)
{
item.ItemCostPrice = (decimal)skuContentBySku.Rows[0]["CostPrice"];
}
item.ItemDescription = (string)skuContentBySku.Rows[0]["ProductName"];
item.ItemHomeSiteDescription = (string)skuContentBySku.Rows[0]["ProductName"];
if (skuContentBySku.Rows[0]["ThumbnailUrl40"] != DBNull.Value)
{
item.ThumbnailsUrl = (string)skuContentBySku.Rows[0]["ThumbnailUrl40"];
}
totalWeight += item.ItemWeight * num4;
purchaseOrderInfo.PurchaseOrderItems.Add(item);
}
}
}
}
if (str == "")
{
ShowMsg("至少选择一个淘宝订单！！", false);
}
else
{
ShippingModeInfo shippingMode = SubsiteSalesHelper.GetShippingMode(radioShippingMode.SelectedValue.Value, true);
purchaseOrderInfo.ShipTo = txtShipTo.Text.Trim();
if (rsddlRegion.GetSelectedRegionId().HasValue)
{
purchaseOrderInfo.RegionId = rsddlRegion.GetSelectedRegionId().Value;
}
purchaseOrderInfo.Address = txtAddress.Text.Trim();
purchaseOrderInfo.TelPhone = txtTel.Text.Trim();
purchaseOrderInfo.ZipCode = txtZipcode.Text.Trim();
purchaseOrderInfo.CellPhone = txtMobile.Text.Trim();
purchaseOrderInfo.OrderId = null;
purchaseOrderInfo.RealShippingModeId = radioShippingMode.SelectedValue.Value;
purchaseOrderInfo.RealModeName = shippingMode.Name;
purchaseOrderInfo.ShippingModeId = radioShippingMode.SelectedValue.Value;
purchaseOrderInfo.ModeName = shippingMode.Name;
purchaseOrderInfo.AdjustedFreight = SubsiteSalesHelper.CalcFreight(purchaseOrderInfo.RegionId, totalWeight, shippingMode);
purchaseOrderInfo.Freight = purchaseOrderInfo.AdjustedFreight;
purchaseOrderInfo.ShippingRegion = rsddlRegion.SelectedRegions;
purchaseOrderInfo.PurchaseStatus = OrderStatus.WaitBuyerPay;
purchaseOrderInfo.DistributorId = user.UserId;
purchaseOrderInfo.Distributorname = user.Username;
purchaseOrderInfo.DistributorEmail = user.Email;
purchaseOrderInfo.DistributorRealName = user.RealName;
purchaseOrderInfo.DistributorQQ = user.QQ;
purchaseOrderInfo.DistributorWangwang = user.Wangwang;
purchaseOrderInfo.DistributorMSN = user.MSN;
purchaseOrderInfo.RefundStatus = RefundStatus.None;
purchaseOrderInfo.Weight = totalWeight;
purchaseOrderInfo.Remark = null;
purchaseOrderInfo.TaobaoOrderId = str;
if (purchaseOrderInfo.PurchaseOrderItems.Count == 0)
{
ShowMsg("您暂时未选择您要添加的商品", false);
}
else if (SubsiteSalesHelper.CreatePurchaseOrder(purchaseOrderInfo))
{
SubsiteSalesHelper.ClearPurchaseShoppingCart();
ResponseCookies();
base.Response.Redirect(Globals.ApplicationPath + "/Shopadmin/purchaseOrder/Pay.aspx?PurchaseOrderId=" + purchaseOrderInfo.PurchaseOrderId);
}
else
{
ShowMsg("提交采购单失败", false);
}
}
}
}
public static bool SendPurchaseOrderGoods(PurchaseOrderInfo purchaseOrder)
{
Globals.EntityCoding(purchaseOrder, true);
ManagerHelper.CheckPrivilege(Privilege.PurchaseorderSendGood);
if (purchaseOrder.CheckAction(PurchaseOrderActions.MASTER_SEND_GOODS))
{
bool flag = SalesProvider.Instance().SendPurchaseOrderGoods(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.PurchaseorderSendGood, string.Format(CultureInfo.InvariantCulture, "对编号为\"{0}\"的采购单发货", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
return false;
}
public override bool SavePurchaseOrderShippingAddress(PurchaseOrderInfo purchaseOrder)
{
if (purchaseOrder == null)
{
return false;
}
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET RegionId = @RegionId, ShippingRegion = @ShippingRegion, Address = @Address, ZipCode = @ZipCode,ShipTo = @ShipTo, TelPhone = @TelPhone, CellPhone = @CellPhone WHERE PurchaseOrderId = @PurchaseOrderId");
database.AddInParameter(sqlStringCommand, "RegionId", DbType.String, purchaseOrder.RegionId);
database.AddInParameter(sqlStringCommand, "ShippingRegion", DbType.String, purchaseOrder.ShippingRegion);
database.AddInParameter(sqlStringCommand, "Address", DbType.String, purchaseOrder.Address);
database.AddInParameter(sqlStringCommand, "ZipCode", DbType.String, purchaseOrder.ZipCode);
database.AddInParameter(sqlStringCommand, "ShipTo", DbType.String, purchaseOrder.ShipTo);
database.AddInParameter(sqlStringCommand, "TelPhone", DbType.String, purchaseOrder.TelPhone);
database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, purchaseOrder.CellPhone);
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
public static bool UpdatePurchaseOrderShippingMode(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
if (purchaseOrder.CheckAction(PurchaseOrderActions.MASTER__MODIFY_SHIPPING_MODE))
{
bool flag = SalesProvider.Instance().UpdatePurchaseOrderShippingMode(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "修改了编号为\"{0}\"的采购单的配送方式", new object[] { purchaseOrder.PurchaseOrderId }));
}
return flag;
}
return false;
}
public static PurchaseOrderInfo PopulatePurchaseOrder(IDataReader reader)
{
if (reader == null)
{
return null;
}
PurchaseOrderInfo info = new PurchaseOrderInfo();
info.PurchaseOrderId = (string) reader["PurchaseOrderId"];
if (DBNull.Value != reader["OrderId"])
{
info.OrderId = (string) reader["OrderId"];
}
if (DBNull.Value != reader["ManagerMark"])
{
info.ManagerMark = new OrderMark?((OrderMark) reader["ManagerMark"]);
}
if (DBNull.Value != reader["Remark"])
{
info.Remark = (string) reader["Remark"];
}
if (DBNull.Value != reader["ManagerRemark"])
{
info.ManagerRemark = (string) reader["ManagerRemark"];
}
if (DBNull.Value != reader["AdjustedDiscount"])
{
info.AdjustedDiscount = (decimal) reader["AdjustedDiscount"];
}
if (DBNull.Value != reader["PurchaseStatus"])
{
info.PurchaseStatus = (OrderStatus) reader["PurchaseStatus"];
}
if (DBNull.Value != reader["CloseReason"])
{
info.CloseReason = (string) reader["CloseReason"];
}
info.PurchaseDate = (DateTime) reader["PurchaseDate"];
if (DBNull.Value != reader["PayDate"])
{
info.PayDate = (DateTime) reader["PayDate"];
}
if (DBNull.Value != reader["ShippingDate"])
{
info.ShippingDate = (DateTime) reader["ShippingDate"];
}
if (DBNull.Value != reader["FinishDate"])
{
info.FinishDate = (DateTime) reader["FinishDate"];
}
info.DistributorId = (int) reader["DistributorId"];
info.Distributorname = (string) reader["Distributorname"];
if (DBNull.Value != reader["DistributorEmail"])
{
info.DistributorEmail = (string) reader["DistributorEmail"];
}
if (DBNull.Value != reader["DistributorRealName"])
{
info.DistributorRealName = (string) reader["DistributorRealName"];
}
if (DBNull.Value != reader["DistributorQQ"])
{
info.DistributorQQ = (string) reader["DistributorQQ"];
}
if (DBNull.Value != reader["DistributorWangwang"])
{
info.DistributorWangwang = (string) reader["DistributorWangwang"];
}
if (DBNull.Value != reader["DistributorMSN"])
{
info.DistributorMSN = (string) reader["DistributorMSN"];
}
if (DBNull.Value != reader["ShippingRegion"])
{
info.ShippingRegion = (string) reader["ShippingRegion"];
}
if (DBNull.Value != reader["Address"])
{
info.Address = (string) reader["Address"];
}
if (DBNull.Value != reader["ZipCode"])
{
info.ZipCode = (string) reader["ZipCode"];
}
if (DBNull.Value != reader["ShipTo"])
{
info.ShipTo = (string) reader["ShipTo"];
}
if (DBNull.Value != reader["TelPhone"])
{
info.TelPhone = (string) reader["TelPhone"];
}
if (DBNull.Value != reader["CellPhone"])
{
info.CellPhone = (string) reader["CellPhone"];
}
if (DBNull.Value != reader["ShippingModeId"])
{
info.ShippingModeId = (int) reader["ShippingModeId"];
}
if (DBNull.Value != reader["ModeName"])
{
info.ModeName = (string) reader["ModeName"];
}
if (DBNull.Value != reader["RealShippingModeId"])
{
info.RealShippingModeId = (int) reader["RealShippingModeId"];
}
if (DBNull.Value != reader["RealModeName"])
{
info.RealModeName = (string) reader["RealModeName"];
}
if (DBNull.Value != reader["RegionId"])
{
info.RegionId = (int) reader["RegionId"];
}
if (DBNull.Value != reader["Freight"])
{
info.Freight = (decimal) reader["Freight"];
}
if (DBNull.Value != reader["AdjustedFreight"])
{
info.AdjustedFreight = (decimal) reader["AdjustedFreight"];
}
if (DBNull.Value != reader["ShipOrderNumber"])
{
info.ShipOrderNumber = (string) reader["ShipOrderNumber"];
}
if (DBNull.Value != reader["Weight"])
{
info.Weight = (int) reader["Weight"];
}
if (DBNull.Value != reader["RefundStatus"])
{
info.RefundStatus = (RefundStatus) reader["RefundStatus"];
}
if (DBNull.Value != reader["RefundAmount"])
{
info.RefundAmount = (decimal) reader["RefundAmount"];
}
if (DBNull.Value != reader["RefundRemark"])
{
info.RefundRemark = (string) reader["RefundRemark"];
}
if (DBNull.Value != reader["OrderTotal"])
{
info.OrderTotal = (decimal) reader["OrderTotal"];
}
if (DBNull.Value != reader["ExpressCompanyName"])
{
info.ExpressCompanyName = (string) reader["ExpressCompanyName"];
}
if (DBNull.Value != reader["ExpressCompanyAbb"])
{
info.ExpressCompanyAbb = (string) reader["ExpressCompanyAbb"];
}
return info;
}
private PurchaseOrderInfo GetPurchaseOrderInfo()
{
PurchaseOrderInfo info = new PurchaseOrderInfo();
Distributor user = Users.GetUser(HiContext.Current.User.UserId) as Distributor;
string orderId = GeneratePurchaseOrderId();
info.PurchaseOrderId = orderId;
IList<PurchaseShoppingCartItemInfo> purchaseShoppingCartItemInfos = SubsiteSalesHelper.GetPurchaseShoppingCartItemInfos();
int totalWeight = 0;
if (purchaseShoppingCartItemInfos.Count >= 1)
{
PurchaseOrderItemInfo item = null;
foreach (PurchaseShoppingCartItemInfo info2 in purchaseShoppingCartItemInfos)
{
item = new PurchaseOrderItemInfo();
item.PurchaseOrderId = orderId;
item.SkuId = info2.SkuId;
item.ThumbnailsUrl = info2.ThumbnailsUrl;
item.SKUContent = info2.SKUContent;
item.SKU = info2.SKU;
item.Quantity = info2.Quantity;
item.ProductId = info2.ProductId;
item.ItemWeight = info2.ItemWeight;
item.ItemCostPrice = info2.CostPrice;
item.ItemPurchasePrice = info2.ItemPurchasePrice;
item.ItemListPrice = info2.ItemListPrice;
item.ItemDescription = info2.ItemDescription;
item.ItemHomeSiteDescription = info2.ItemDescription;
totalWeight += info2.ItemWeight * info2.Quantity;
info.PurchaseOrderItems.Add(item);
}
ShippingModeInfo shippingMode = SubsiteSalesHelper.GetShippingMode(radioShippingMode.SelectedValue.Value, true);
info.ShipTo = txtShipTo.Text.Trim();
if (rsddlRegion.GetSelectedRegionId().HasValue)
{
info.RegionId = rsddlRegion.GetSelectedRegionId().Value;
}
info.Address = Globals.HtmlEncode(txtAddress.Value.Trim());
info.TelPhone = txtTel.Text.Trim();
info.ZipCode = txtZipcode.Text.Trim();
info.CellPhone = txtMobile.Text.Trim();
info.OrderId = null;
info.RealShippingModeId = radioShippingMode.SelectedValue.Value;
info.RealModeName = shippingMode.Name;
info.ShippingModeId = radioShippingMode.SelectedValue.Value;
info.ModeName = shippingMode.Name;
info.AdjustedFreight = SubsiteSalesHelper.CalcFreight(info.RegionId, totalWeight, shippingMode);
info.Freight = info.AdjustedFreight;
info.ShippingRegion = rsddlRegion.SelectedRegions;
info.Remark = Globals.HtmlEncode(txtRemark.Text.Trim());
info.PurchaseStatus = OrderStatus.WaitBuyerPay;
info.DistributorId = user.UserId;
info.Distributorname = user.Username;
info.DistributorEmail = user.Email;
info.DistributorRealName = user.RealName;
info.DistributorQQ = user.QQ;
info.DistributorWangwang = user.Wangwang;
info.DistributorMSN = user.MSN;
info.RefundStatus = RefundStatus.None;
info.Weight = totalWeight;
info.ExpressCompanyAbb = shippingMode.ExpressCompanyAbb;
info.ExpressCompanyName = shippingMode.ExpressCompanyName;
}
return info;
}
public override bool SendPurchaseOrderGoods(PurchaseOrderInfo purchaseOrder)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_PurchaseOrders SET ShipOrderNumber = @ShipOrderNumber, RealShippingModeId = @RealShippingModeId, RealModeName = @RealModeName, PurchaseStatus = @PurchaseStatus,ShippingDate=@ShippingDate, ExpressCompanyName = @ExpressCompanyName , ExpressCompanyAbb = @ExpressCompanyAbb WHERE PurchaseOrderId = @PurchaseOrderId");
database.AddInParameter(sqlStringCommand, "ShipOrderNumber", DbType.String, purchaseOrder.ShipOrderNumber);
database.AddInParameter(sqlStringCommand, "RealShippingModeId", DbType.Int32, purchaseOrder.RealShippingModeId);
database.AddInParameter(sqlStringCommand, "RealModeName", DbType.String, purchaseOrder.RealModeName);
database.AddInParameter(sqlStringCommand, "PurchaseStatus", DbType.Int32, 3);
database.AddInParameter(sqlStringCommand, "ShippingDate", DbType.DateTime, DateTime.Now);
database.AddInParameter(sqlStringCommand, "ExpressCompanyName", DbType.String, purchaseOrder.ExpressCompanyName);
database.AddInParameter(sqlStringCommand, "ExpressCompanyAbb", DbType.String, purchaseOrder.ExpressCompanyAbb);
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, purchaseOrder.PurchaseOrderId);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
