the second example is attached
[TestMethod()]
public void BankaUlkeListeleTest()
{
var filter = new PredicateExpression();
var sorter = new SortExpression();
using (DataTable dt = BankaListeleTransaction.BankaUlkeListele(filter, sorter))
{
Assert.IsTrue(dt.AsEnumerable().Any(p => string.IsNullOrWhiteSpace(p["UlkeAd"].ToString())));
Assert.IsTrue(dt.AsEnumerable().Any(p => !string.IsNullOrWhiteSpace(p["UlkeAd"].ToString())));
}
}
public static DataTable BankaUlkeListele(IPredicateExpression filter, SortExpression bankaSortEx)
{
TypedListBuilder tlb = new TypedListBuilder();
tlb.addRelations(RelationHelper.CreateCustomRelation(LokasyonFields.Id, BankaFields.UlkeId, "LokasyonEntity", "BankaEntity"), JoinHint.Left);
tlb.addFields(BankaFields.Id, "Id");
tlb.addFields(BankaFields.Kod, "Kod");
tlb.addFields(BankaFields.Ad, "Ad");
tlb.addFields(BankaFields.AktifMi, "AktifMi");
tlb.addFields(BankaFields.SikKullanilanMi, "SikKullanilanMi");
tlb.addFields(LokasyonFields.Ad, "UlkeAd");
tlb.addFields(BankaFields.AlternatifBankasiOlacakMi, "AlternatifBankasiOlacakMi");
return tlb.Fill(filter, true, bankaSortEx);
}
public static IEntityRelation CreateCustomRelation(IEntityField PkField, IEntityField FkField, string PkSideEntity, string FkSideEntity)
{
IEntityRelation customRelation = new EntityRelation(SD.LLBLGen.Pro.ORMSupportClasses.RelationType.ManyToOne);
customRelation.StartEntityIsPkSide = false;
customRelation.AddEntityFieldPair(PkField, FkField);
customRelation.InheritanceInfoPkSideEntity = ModelInfoProviderSingleton.GetInstance().GetInheritanceInfo(PkSideEntity, false);
customRelation.InheritanceInfoFkSideEntity = ModelInfoProviderSingleton.GetInstance().GetInheritanceInfo(FkSideEntity, true);
return customRelation;
}
Attachments
Filename |
File size |
Added on |
Approval |
llblgenrightJoin.PNG
|
125,431 |
02-May-2019 09:26.35 |
Approved |