public void AddFormReimburseDelivery(int FormReimburseSKUDetailID, string DeliveryNo, decimal DeliveryQuantity, DateTime DeliveryDate, string Remark) { FormDS.FormReimburseDeliveryDataTable table = new FormDS.FormReimburseDeliveryDataTable(); FormDS.FormReimburseDeliveryRow rowDetail = table.NewFormReimburseDeliveryRow(); rowDetail.FormReimburseSKUDetailID = FormReimburseSKUDetailID; rowDetail.DeliveryNo = DeliveryNo; rowDetail.DeliveryQuantity = DeliveryQuantity; rowDetail.DeliveryDate = DeliveryDate; FormDS.FormReimburseSKUDetailRow skuDetailRow = this.TAFormReimburseSKUDetail.GetDataByID(rowDetail.FormReimburseSKUDetailID)[0]; ERS.SKURow sku = new MasterDataBLL().GetSKUById(skuDetailRow.SKUID); rowDetail.DeliveryAmount = skuDetailRow.UnitPrice * DeliveryQuantity; rowDetail.DeliveryCost = sku.CostPrice * DeliveryQuantity; rowDetail.Remark = Remark; table.AddFormReimburseDeliveryRow(rowDetail); this.TAFormReimburseDelivery.Update(table); }
public void UpdateFormReimburseDelivery(int FormReimburseDeliveryID, string DeliveryNo, decimal DeliveryQuantity, DateTime DeliveryDate, string Remark) { FormDS.FormReimburseDeliveryRow rowDetail = this.TAFormReimburseDelivery.GetDataByID(FormReimburseDeliveryID)[0]; if (rowDetail == null) { return; } rowDetail.DeliveryNo = DeliveryNo; rowDetail.DeliveryQuantity = DeliveryQuantity; rowDetail.DeliveryDate = DeliveryDate; FormDS.FormReimburseSKUDetailRow skuDetailRow = this.TAFormReimburseSKUDetail.GetDataByID(rowDetail.FormReimburseSKUDetailID)[0]; ERS.SKURow sku = new MasterDataBLL().GetSKUById(skuDetailRow.SKUID); rowDetail.DeliveryAmount = skuDetailRow.UnitPrice * DeliveryQuantity; rowDetail.DeliveryCost = sku.CostPrice * DeliveryQuantity; rowDetail.Remark = Remark; this.TAFormReimburseDelivery.Update(rowDetail); }
protected void gvDelivery_RowDataBound(object sender, GridViewRowEventArgs e) { // 对数据列进行赋值 if (e.Row.RowType == DataControlRowType.DataRow) { DataRowView drvDetail = (DataRowView)e.Row.DataItem; FormDS.FormReimburseDeliveryRow row = (FormDS.FormReimburseDeliveryRow)drvDetail.Row; DeliveryQuantityTotal = decimal.Round((DeliveryQuantityTotal + row.DeliveryQuantity), 2); DeliveryFeeTotal = decimal.Round((DeliveryFeeTotal + row.DeliveryAmount), 2); } if (e.Row.RowType == DataControlRowType.Footer) { Label lblTotalDeliveryQuantity = (Label)e.Row.FindControl("lblTotalDeliveryQuantity"); Label lblTotalDeliveryAmount = (Label)e.Row.FindControl("lblTotalDeliveryAmount"); lblTotalDeliveryQuantity.Text = DeliveryQuantityTotal.ToString("N"); lblTotalDeliveryAmount.Text = DeliveryFeeTotal.ToString("N"); } }