void FisYazdir(bool Disigner, string pkSatislar, string SatisFisTipi, string fkSatisFisiSecimi) { System.Data.DataSet ds = new DataSet("Test"); DataTable FisDetay = DB.GetData(@"exec sp_SatisDetay " + pkSatislar + ",1"); FisDetay.TableName = "FisDetay"; ds.Tables.Add(FisDetay); DataTable Fis = DB.GetData(@"exec sp_Satislar " + pkSatislar); if (Fis.Rows.Count == 0) { MessageBox.Show("Satış Bulunamadı"); return; } string fkFirma = Fis.Rows[0]["fkFirma"].ToString(); Fis.TableName = "Fis"; ds.Tables.Add(Fis); //şirket bilgileri DataTable Sirket = DB.GetData(@"select top 1 * from Sirketler with(nolock)"); Sirket.TableName = "Sirket"; ds.Tables.Add(Sirket); //Bakiye bilgileri DataTable Bakiye = DB.GetData(@"select Tutar as OncekiBakiye,Borc, OdemeSekli from KasaHareket with(nolock) where fkSatislar=" + pkSatislar); Bakiye.TableName = "Bakiye"; ds.Tables.Add(Bakiye); //Firma bilgileri //DataTable Musteri = DB.GetData("select *,dbo.fon_MusteriBakiyesi(pkFirma) as Bakiye from Firmalar with(nolock) where pkFirma=" + fkFirma); DataTable Musteri = DB.GetData("select * from VM_Musteriler where pkFirma=" + fkFirma); Musteri.TableName = "Musteri"; ds.Tables.Add(Musteri); string exedizini = Path.GetDirectoryName(Application.ExecutablePath); string RaporDosyasi = exedizini + "\\Raporlar\\" + SatisFisTipi + ".repx"; //string RaporDosyasi = exedizini + "\\Raporlar\\MusteriSatis.repx"; //XtraReport rapor = new XtraReport(); xrCariHareket rapor = new xrCariHareket(); //rapor.AfterPrint //rapor.Disposed //rapor.EndUpdate //rapor.IsDisposed //rapor.IsSingleChild //rapor.SaveComponents //rapor.SaveComponents += new //EventHandler<SaveComponentsEventArgs>(report_SaveComponents); rapor.DataSource = ds; if (File.Exists(RaporDosyasi)) { rapor.LoadLayout(RaporDosyasi); } else { MemoryStream ms = RaporUtil.GetMemStr(fkSatisFisiSecimi, pkSatislar); if (ms == null) { MessageBox.Show("Dosya Bulunamadı"); } else { rapor.LoadLayout(ms); } } rapor.Name = SatisFisTipi; rapor.Report.Name = SatisFisTipi; if (Disigner) { /* * // Create a Design Tool and assign the report to it. * ReportDesignTool designTool = new ReportDesignTool(rapor); * designTool.Report.DrawGrid = true; * // Access the Designer form's properties. * designTool.DesignForm.SetWindowVisibility(DesignDockPanelType.FieldList | * DesignDockPanelType.PropertyGrid, false); * * //designTool.DesignForm.OpenReport() * //rapor.DesignerLoaded += report_DesignerLoaded; * designTool.ShowDesignerDialog(); */ rapor.ShowDesignerDialog(); string filePath = @"XtraReport1.repx"; rapor.SaveLayout(filePath); FileStream fStream = new FileStream(filePath, FileMode.Open, FileAccess.Read); long sayac = fStream.Length; BinaryReader bReader = new BinaryReader(fStream); byte[] byteResim = bReader.ReadBytes((int)sayac); string sql = ""; ArrayList alist = new ArrayList(); alist.Add(new SqlParameter("@pkSatisFisiSecimi", fkSatisFisiSecimi)); alist.Add(new SqlParameter("@rapor_dosya", byteResim)); sql = @"update SatisFisiSecimi set rapor_dosya=@rapor_dosya,guncelleme_tarihi=getdate() where pkSatisFisiSecimi=@pkSatisFisiSecimi"; string sonuc = DB.ExecuteSQL(sql, alist); } else { rapor.ShowPreview(); } }