Question

我在银星米克斯·米洛佩斯上是新的,我正在建立一个项目,在该项目中,我把数据输入数据。

我的数据库结构如下:

tblAuthorizationVarification (AuthorizationVarificationid, AuthorizationRequestid, number)
tblAuthorizationRequest (AuthorizationRequestid, name)
t VarificationDetails (DetailId, 批准Requestid, 数额)

我想在所有授权中显示总金额。

下面是我的代码,载于Model。页: 1 Varification:

PagedCollectionView _AuthorizationVarificationList;

public PagedCollectionView AuthorizationVarificationList
{
  get { return _AuthorizationVarificationList; }
  set 
  {
     _AuthorizationVarificationList = value;
     OnPropertyChanged("AuthorizationVarificationList"); }
  }

  private void GetVarifications()
  {
    IsBusy = true;
    LoadOperation<AuthorizationVerification> loadOp = 
                          objContext.Load(objContext.GetCreditNotesQuery());

    loadOp.Completed += (sender, e) =>
    {
       IEnumerable<AuthorizationVerification> op = 
               ((LoadOperation<AuthorizationVerification>)sender).Entities;
       PagedCollectionView view = new PagedCollectionView(op);
       this.AuthorizationVarificationList = view;
       cnt = cnt - 1;
       if (cnt <= 0)
         IsBusy = false;
    };
  }

授权隔离清单在Gridview中具有约束力,如同样。

<sdk:DataGrid x:Name="grdCreditNotes" 
    ItemsSource="{Binding Path=AuthorizationVarificationList}" 
    SelectedItem="{Binding Path=SelectedCreditNote, Mode=TwoWay}" 
    AutoGenerateColumns="False" IsReadOnly="True" Grid.Row="2" 
    VerticalAlignment="Stretch" Margin="0,0,0,0">

    <sdk:DataGrid.Columns>
      <sdk:DataGridTextColumn Header="Credit No" 
         Binding="{Binding Path=AuthorizationVerificationId}" Width="200"/>

      <sdk:DataGridTextColumn Header="Amount" 
         Binding="{Binding Path=AuthorizationRequest.Amount}" MinWidth="100" 
         Width="*"/>

    </sdk:DataGrid.Columns>    
</sdk:DataGrid>

在电网领域,我能做些什么来显示特别授权的数量?

Answer 1

正如我前面已经建议的那样,你可以为收集项目设定一个观点模式,并按需要加以分类。

public class VerificationViewModel
{
    public int AuthorizationVerificationId { get; set; }

    public double Amount { get; set; }
}

之后,使用“LINQ”结构,将收集和回收物品分类:

loadOp.Completed += (sender, e) =>
{
   IEnumerable<AuthorizationVerification> op = 
           ((LoadOperation<AuthorizationVerification>)sender).Entities;

   var models = op.GroupBy(item => item.AuthorizationVerificationId)
                  .Select(g => new VerificationViewModel
                                { 
                                    AuthorizationVerificationId = g.Key, 
                                    Amount = g.Sum(gi => gi.Amount) 
                                })
                  .ToList();

   PagedCollectionView view = new PagedCollectionView(models);
   // Everything else is the same
}

//Also change the type of the property which is bound to SelectedItem
public VerificationViewModel SelectedCreditNote { get; set; }

并改变第二栏的约束性道路:

<sdk:DataGrid.Columns>
  <sdk:DataGridTextColumn Header="Credit No" 
     Binding="{Binding Path=AuthorizationVerificationId}" Width="200"/>

  <sdk:DataGridTextColumn Header="Amount" 
     Binding="{Binding Path=Amount}" MinWidth="100" Width="*"/>

</sdk:DataGrid.Columns>

该法典应计算每伊德的数额。如果你想要其他聚合物,你可以改变林克的盘问。

Answer 2

如果我正确理解的话,你是在总结之后? 如果是,请查到以下链接:http://leeontech.wordpress.com 201002/01/summary-row-in-datagrid/。您可能需要在“观点”后面塑造你的模型目标(在此情况下,显示模型(DTOs)与“观点”很少见良好做法)。

友情链接