public rptCariExtresiStokDetayli(int CariID, DateTime baslangic, DateTime bitis) { InitializeComponent(); NetSatisContext context = new NetSatisContext(); CariDAL cariDal = new CariDAL(); var cariEntity = cariDal.GetByFilter(context, c => c.Id == CariID); ObjectDataSource cariEkstreDataSource = new ObjectDataSource { DataSource = cariDal.CariFisAyrintiStok(context, CariID, baslangic, bitis) }; List <GenelToplam> cariBakiyeDataSource = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID, baslangic, bitis); List <GenelToplam> cariBakiyeDataSourceDev = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID); List <GenelToplam> cariBakiyeDurum = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID); this.DataSource = cariEkstreDataSource; lblCariKodu.DataBindings.Add("Text", cariEntity, "CariKodu"); lblCariAdı.DataBindings.Add("Text", cariEntity, "CariAdi"); Adres.DataBindings.Add("Text", cariEntity, "Adres"); lblIl.DataBindings.Add("Text", cariEntity, "Il"); lblIlce.DataBindings.Add("Text", cariEntity, "Ilce"); colDipIndirim.DataBindings.Add("Text", this.DataSource, "DipIndirim"); colIndirim.DataBindings.Add("Text", this.DataSource, "IndirimTutari"); colBirim.DataBindings.Add("Text", this.DataSource, "Birim"); colUrunAdi.DataBindings.Add("Text", this.DataSource, "UrunAdi"); //colFisTuru.DataBindings.Add("Text", this.DataSource, "IslemTuru"); //colTarih.DataBindings.Add("Text", this.DataSource, "IslemTarihi", "{0:dd.MM.yyyy}"); //colVadeTarihi.DataBindings.Add("Text", this.DataSource, "VadeTarihi", "{0:dd.MM.yyyy}"); coltutar.DataBindings.Add("Text", this.DataSource, "SatirTutari", "{0:C2}"); colBirimFiyat.DataBindings.Add("Text", this.DataSource, "BirimFiyat", "{0:C2}"); colMiktar.DataBindings.Add("Text", this.DataSource, "Miktar", "{0:N2}"); colAlacak.DataBindings.Add("Text", cariBakiyeDataSource[0], "Bilgi"); colAlacakTutar.DataBindings.Add("Text", cariBakiyeDataSource[0], "Tutar", "{0:C2}"); colBorc.DataBindings.Add("Text", cariBakiyeDataSource[1], "Bilgi"); colBorcTutar.DataBindings.Add("Text", cariBakiyeDataSource[1], "Tutar", "{0:C2}"); colBakiye.DataBindings.Add("Text", cariBakiyeDataSource[2], "Bilgi"); colBakiyeTutar.DataBindings.Add("Text", cariBakiyeDataSource[2], "Tutar", "{0:C2}"); lblBaslangic.Text = baslangic.ToShortDateString(); lblBitis.Text = bitis.ToShortDateString(); CalculatedField calcTutar = new CalculatedField(); this.CalculatedFields.Add(calcTutar); calcTutar.Name = "TopTutar"; calcTutar.Expression = "[SatirTutari]"; XRSummary sumToplamTutar = new XRSummary(); sumToplamTutar.Func = SummaryFunc.Sum; sumToplamTutar.Running = SummaryRunning.Group; sumToplamTutar.FormatString = "{0:C2}"; CalculatedField calcBorcAlacak = new CalculatedField(); this.CalculatedFields.Add(calcBorcAlacak); calcBorcAlacak.Name = "SonDurum"; calcBorcAlacak.Expression = "Iif([colSonDurum] > 0, '(Alacaklı)', '(Borçlu)')"; lblToplamTutar.DataBindings.Add("Text", null, "TopTutar"); lblToplamTutar.Summary = sumToplamTutar; }
public rptCariExtresiStok(int CariID, DateTime baslangic, DateTime bitis) { InitializeComponent(); NetSatisContext context = new NetSatisContext(); CariDAL cariDal = new CariDAL(); var cariEntity = cariDal.GetByFilter(context, c => c.Id == CariID); ObjectDataSource cariEkstreDataSource = new ObjectDataSource { DataSource = cariDal.CariFisAyrintiStok(context, CariID, baslangic, bitis) }; List <GenelToplam> cariBakiyeDataSource = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID, baslangic, bitis); List <GenelToplam> cariBakiyeDataSourceDev = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID); List <GenelToplam> cariBakiyeDurum = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID); cariBakiyeDataSourceDev[0].Tutar = cariBakiyeDataSourceDev[0].Tutar - cariBakiyeDataSource[0].Tutar; cariBakiyeDataSourceDev[1].Tutar = cariBakiyeDataSourceDev[1].Tutar - cariBakiyeDataSource[1].Tutar; cariBakiyeDataSourceDev[2].Tutar = cariBakiyeDataSourceDev[0].Tutar - cariBakiyeDataSourceDev[1].Tutar; cariBakiyeDurum[2].Tutar = cariBakiyeDataSource[2].Tutar + cariBakiyeDataSourceDev[2].Tutar; this.DataSource = cariEkstreDataSource; lblCariKodu.DataBindings.Add("Text", cariEntity, "CariKodu"); lblCariAdı.DataBindings.Add("Text", cariEntity, "CariAdi"); Adres.DataBindings.Add("Text", cariEntity, "Adres"); lblIl.DataBindings.Add("Text", cariEntity, "Il"); lblIlce.DataBindings.Add("Text", cariEntity, "Ilce"); //colFisKodu.DataBindings.Add("Text", this.DataSource, "FisKodu"); colFisTuru.DataBindings.Add("Text", this.DataSource, "IslemTuru"); colBirim.DataBindings.Add("Text", this.DataSource, "Birim"); colUrunAdi.DataBindings.Add("Text", this.DataSource, "UrunAdi"); colAciklama.DataBindings.Add("Text", this.DataSource, "Aciklama"); //colBelgeNo.DataBindings.Add("Text", this.DataSource, "BelgeNo"); colTarih.DataBindings.Add("Text", this.DataSource, "IslemTarihi", "{0:dd.MM.yyyy}"); //colVadeTarihi.DataBindings.Add("Text", this.DataSource, "VadeTarihi", "{0:dd.MM.yyyy}"); coltutar.DataBindings.Add("Text", this.DataSource, "SatirTutari", "{0:C2}"); colFistutari.DataBindings.Add("Text", this.DataSource, "FisTutari", "{0:C2}"); colBirimFiyat.DataBindings.Add("Text", this.DataSource, "BirimFiyat", "{0:C2}"); colMiktar.DataBindings.Add("Text", this.DataSource, "Miktar", "{0:N2}"); colBorsa.DataBindings.Add("Text", this.DataSource, "BorsaToplam", "{0:C2}"); colZirai.DataBindings.Add("Text", this.DataSource, "ZiraiToplam", "{0:C2}"); colBagkur.DataBindings.Add("Text", this.DataSource, "BagkurToplam", "{0:C2}"); lblBaslangic.Text = baslangic.ToShortDateString(); lblBitis.Text = bitis.ToShortDateString(); CalculatedField calcBorcAlacak = new CalculatedField(); this.CalculatedFields.Add(calcBorcAlacak); calcBorcAlacak.Name = "SonDurum"; calcBorcAlacak.Expression = "Iif([colSonDurum] > 0, '(Alacaklı)', '(Borçlu)')"; colDevAlacakTutar.DataBindings.Add("Text", cariBakiyeDataSourceDev[0], "Tutar", "{0:C2}"); colAlacakTutar.DataBindings.Add("Text", cariBakiyeDataSource[0], "Tutar", "{0:C2}"); colDevBorcTutar.DataBindings.Add("Text", cariBakiyeDataSourceDev[1], "Tutar", "{0:C2}"); colBorcTutar.DataBindings.Add("Text", cariBakiyeDataSource[1], "Tutar", "{0:C2}"); colDevBakiye.DataBindings.Add("Text", cariBakiyeDataSourceDev[2], "Tutar", "{0:C2}"); colBakiyeTutar.DataBindings.Add("Text", cariBakiyeDataSource[2], "Tutar", "{0:C2}"); colSonDurum.DataBindings.Add("Text", cariBakiyeDurum[2], "Tutar", "{0:C2}"); lblDurum.DataBindings.Add("Text", null, "SonDurum"); }