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");
}
}
