protected void EgvDeliverItem_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DeliverItemInfo dataItem = e.Row.DataItem as DeliverItemInfo; e.Row.Cells[1].Text = (dataItem.DeliverDirection == 1) ? "发货" : "<span style='color:#F00'>退货</span>"; e.Row.Cells[6].Text = dataItem.Received ? "<span style='color:#F00'><strong>√</strong></span>" : ""; Literal literal = (Literal)e.Row.FindControl("LitExpressCompony"); if (dataItem.CourierId > 0) { literal.Text = this.GetExpressCompony(dataItem.CourierId); } if ((dataItem.DeliverDirection == 1) && !dataItem.Received) { e.Row.Cells[8].Enabled = true; } else { e.Row.Cells[8].Text = ""; } Literal literal2 = (Literal)e.Row.FindControl("LitExpressNumber"); literal2.Text = dataItem.ExpressNumber; Literal literal3 = (Literal)e.Row.FindControl("LitExpressState"); CourierInfo courier = Courier.GetCourier(dataItem.CourierId); if (!string.IsNullOrEmpty(courier.SearchUrl)) { literal3.Text = "<a href=" + courier.SearchUrl.Replace("{$ExpressNumber}", dataItem.ExpressNumber) + " Target=\"_Blank\">查看</a>"; } } }
public bool Add(DeliverItemInfo deliverItemInfo) { try { return(DBHelper.ExecuteNonQueryProc("PR_Shop_DeliverItem_Add", GetDeliverParms(deliverItemInfo)) > 0); } catch { return(false); } }
private static DeliverItemInfo DetailDeliverItemFromrdr(NullableDataReader rdr) { DeliverItemInfo info = DeliverItemFromrdr(rdr); info.ClientId = rdr.GetInt32("ClientID"); info.ClientName = rdr.GetString("ClientName"); info.ContacterName = rdr.GetString("ContacterName"); info.UserName = rdr.GetString("UserName"); info.OrderNum = rdr.GetString("OrderNum"); info.CourierId = rdr.GetInt32("CourierId"); return(info); }
private static Parameters GetDeliverParms(DeliverItemInfo deliverItemInfo) { Parameters parameters = new Parameters(); parameters.AddInParameter("@OrderID", DbType.Int32, deliverItemInfo.OrderId); parameters.AddInParameter("@DeliverDate", DbType.DateTime, deliverItemInfo.DeliverDate); parameters.AddInParameter("@DeliverDirection", DbType.Int32, deliverItemInfo.DeliverDirection); parameters.AddInParameter("@HandlerName", DbType.String, deliverItemInfo.HandlerName); parameters.AddInParameter("@CourierId", DbType.Int32, deliverItemInfo.CourierId); parameters.AddInParameter("@ExpressNumber", DbType.String, deliverItemInfo.ExpressNumber); parameters.AddInParameter("@Inputer", DbType.String, deliverItemInfo.Inputer); parameters.AddInParameter("@Remark", DbType.String, deliverItemInfo.Remark); parameters.AddInParameter("@Memo", DbType.String, deliverItemInfo.Memo); return(parameters); }
private static DeliverItemInfo DeliverItemFromrdr(NullableDataReader rdr) { DeliverItemInfo info = new DeliverItemInfo(); info.DeliverId = rdr.GetInt32("DeliverID"); info.OrderId = rdr.GetInt32("OrderID"); info.DeliverDate = rdr.GetDateTime("DeliverDate"); info.DeliverDirection = rdr.GetInt32("DeliverDirection"); info.HandlerName = rdr.GetString("HandlerName"); info.CourierId = rdr.GetInt32("CourierId"); info.ExpressNumber = rdr.GetString("ExpressNumber"); info.Inputer = rdr.GetString("Inputer"); info.Remark = rdr.GetString("Remark"); info.Received = rdr.GetBoolean("Received"); info.Memo = rdr.GetString("Memo"); return(info); }
public DeliverItemInfo GetDeliverItemByOrderId(int orderId) { Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("OrderId", DbType.Int32, orderId); using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Shop_DeliverItem_GetByOrderId", cmdParams)) { if (reader.Read()) { DeliverItemInfo info = new DeliverItemInfo(); info.UserName = reader.GetString("UserName"); info.OrderNum = reader.GetString("OrderNum"); info.ClientName = reader.GetString("ClientName"); info.MoneyTotal = reader.GetDecimal("MoneyTotal"); info.MoneyReceipt = reader.GetDecimal("MoneyReceipt"); info.DeliverTypeName = reader.GetString("DeliverTypeName"); info.ContacterName = reader.GetString("ContacterName"); info.Email = reader.GetString("Email"); return(info); } return(new DeliverItemInfo(true)); } }
public static bool Add(DeliverItemInfo deliverItemInfo) { bool flag = false; IList <OrderItemInfo> infoListByOrderId = OrderItem.GetInfoListByOrderId(deliverItemInfo.OrderId); DeliverStatus preparative = DeliverStatus.Preparative; int num = 0; IList <StockItemInfo> infoList = new List <StockItemInfo>(); bool flag2 = true; foreach (OrderItemInfo info in infoListByOrderId) { bool flag3 = false; if (Product.CharacterIsExists(info.ProductCharacter, ProductCharacter.Practicality)) { flag3 = true; } else if ((deliverItemInfo.DeliverDirection != 1) && Product.CharacterIsExists(info.ProductCharacter, ProductCharacter.Card)) { flag3 = true; } if (flag3) { if (flag2) { num = StockManage.GetMaxId() + 1; flag2 = false; } int amount = info.Amount; if (deliverItemInfo.DeliverDirection == 1) { amount = -amount; Product.AddBuyTimes(info.ProductId, info.TableName); } if (string.IsNullOrEmpty(info.TableName)) { Present.AddStocks(info.ProductId, amount); } else { Product.AddStocks(info.ProductId, amount, info.Property); } StockItemInfo item = new StockItemInfo(); item.Amount = Math.Abs(amount); item.ItemId = StockItem.GetMaxId() + 1; item.Price = info.TruePrice; item.ProductId = info.ProductId; item.TableName = info.TableName; item.Property = info.Property; item.ProductName = info.ProductName; item.ProductNum = ""; item.StockId = num; item.Unit = info.Unit; infoList.Add(item); Product.AddOrderNum(info.ProductId, info.TableName, info.Property, amount); } } if (!flag2) { StockInfo stockInfo = new StockInfo(); stockInfo.Inputer = deliverItemInfo.HandlerName; stockInfo.InputTime = deliverItemInfo.DeliverDate; stockInfo.Remark = "退货"; stockInfo.StockId = num; if (deliverItemInfo.DeliverDirection == 1) { stockInfo.StockNum = StockItem.GetShipmentNum(); stockInfo.StockType = StockType.Shipment; stockInfo.Remark = "订单" + deliverItemInfo.OrderNum + "发货"; preparative = DeliverStatus.Consignment; } else { stockInfo.StockNum = StockItem.GetInStockNum(); stockInfo.StockType = StockType.InStock; stockInfo.Remark = "订单" + deliverItemInfo.OrderNum + "退货"; } if (StockManage.Add(stockInfo)) { StockItem.Add(infoList, stockInfo.StockId); } } if (Order.UpdateDeliverStatus(deliverItemInfo.OrderId, preparative)) { flag = dal.Add(deliverItemInfo); } return(flag); }