private IList <KeyValuePair <XRTable, List <XRTable> > > FindTables(DevExpress.XtraReports.UI.XtraReport xtraReport)
{
var result = new List <KeyValuePair <XRTable, List <XRTable> > >();
IEnumerable <XRTable> allTables = xtraReport.AllControls <XRTable>().Where(t => t.Visible);
foreach (var table in allTables)
{
var subResult = new List <XRTable>();
XRTableCellCollection dataCells = table.Rows[0].Cells;
bool match = true;
IEnumerable <XRTable> candidates = allTables.Where(t => t.Visible && t != table);
foreach (var candidate in candidates)
{
if (candidate.Rows[0].Cells.Count == dataCells.Count)
{
XRTableCellCollection cells = candidate.Rows[0].Cells;
for (int i = 0; i < cells.Count; i++)
{
match &= FloatComparer.Compare(dataCells[i].WidthF, candidate.Rows[0].Cells[i].WidthF, 5) == 0;
}
if (match)
{
subResult.Add(candidate);
}
}
}
result.Add(new KeyValuePair <XRTable, List <XRTable> >(table, subResult));
}
return(result);
}
public override void SetData(DevExpress.XtraReports.UI.XtraReport report, string url)
{
url += url.EndsWith(".repx") ? "" : ".repx";
using (var fileStream = File.OpenWrite(Path.Combine(workingDirectory, url))) {
report.SaveLayoutToXml(fileStream);
}
}
public override string SetNewData(DevExpress.XtraReports.UI.XtraReport report, string defaultUrl)
{
// Save a report to the storage under a new URL.
// The defaultUrl parameter contains the report display name specified by a user.
string reportname = report.ToString();
string language = "ar-EG";
string menuname = "OtherReports";
string icon = "7.png";
var orgReport = db.HReports.Where(r => r.ReportName == reportname && r.OrgReportId == null).Select(r => new { Id = r.Id, Icon = r.Icon, MenuName = r.MenuName, Language = r.Language }).FirstOrDefault();
if (orgReport != null)
{ // get info from original report
menuname = orgReport.MenuName;
icon = orgReport.Icon;
language = orgReport.Language;
}
else
{ // read info from sessions
if (HttpContext.Current.Session["Language"] != null)
{
language = HttpContext.Current.Session["Language"].ToString();
}
if (HttpContext.Current.Session["Icon"] != null)
{
icon = HttpContext.Current.Session["Icon"].ToString();
}
if (HttpContext.Current.Session["MenuName"] != null)
{
menuname = HttpContext.Current.Session["MenuName"].ToString();
}
//int menuId = 0;
//if (HttpContext.Current.Session["MenuId"] != null) int.TryParse(HttpContext.Current.Session["MenuId"].ToString(), out menuId);
//if (menuId > 0) menuname = db.Menus.Where(m => m.Id == menuId).Select(m => m.Name).FirstOrDefault();
}
var hreport = new HReport
{
CreatedTime = DateTime.Now,
CreatedUser = HttpContext.Current.User.Identity.Name,
MenuName = menuname,
OrgReportId = (orgReport == null ? (int?)null : orgReport.Id),
Icon = icon,
ReportName = reportname,
ReportTitle = defaultUrl,
Language = language
};
using (MemoryStream ms = new MemoryStream())
{
report.SaveLayoutToXml(ms);
hreport.ReportData = ms.GetBuffer();
}
db.HReports.Add(hreport);
db.SaveChanges();
return(hreport.Id.ToString());
}
void RaporOnizleme(bool Disigner)
{
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
string pkSatislar = dr["pkSatislar"].ToString();
string exedizini = Path.GetDirectoryName(Application.ExecutablePath);
string RaporDosyasi = "Rapor.repx";
//xrBarkod Barkod = new xrBarkod();
DevExpress.XtraReports.UI.XtraReport Barkod = new DevExpress.XtraReports.UI.XtraReport();
string sql = @"SELECT sk.pkStokKarti,sk.StokKod,sk.Stokadi,sd.Adet,sd.SatisFiyati,sd.iskontotutar,sd.iskontoyuzde,sd.Tarih FROM Satislar s
inner join SatisDetay sd on sd.fkSatislar=s.pkSatislar
inner join StokKarti sk on sk.pkStokKarti=sd.fkStokKarti
where s.pkSatislar =" + pkSatislar;
Barkod.DataSource = DB.GetData(sql);
RaporDosyasi = exedizini + "\\Raporlar\\satisfisia4.repx";
//rapor.DataSource = gCPerHareketleri.DataSource;
//rapor.CreateDocument();
Barkod.LoadLayout(RaporDosyasi);
//rapor.FindControl("xlKasaAdi", true).Text = lueKasa.Text + " " + ilkdate.DateTime.ToString("dd.MM.yyyy") +
// "-" + sondate.DateTime.ToString("dd.MM.yyyy");
if (Disigner)
{
Barkod.ShowDesignerDialog();
}
else
{
Barkod.ShowRibbonPreview();
}
}
private void JMRAP07_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
//첫 페이지의 서브 리포트 출력
JMRAP07_00 detailCondo = xrSubreport6.ReportSource as JMRAP07_00;
JMRAP07_01 detailTotal = xrSubreport1.ReportSource as JMRAP07_01;
JMRAP07_02 detailWp1 = xrSubreport2.ReportSource as JMRAP07_02;
JMRAP07_03 detailWp2 = xrSubreport3.ReportSource as JMRAP07_03;
JMRAP07_04 detailWp3 = xrSubreport4.ReportSource as JMRAP07_04;
JMRAP07_05 detailOther = xrSubreport5.ReportSource as JMRAP07_05;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detailCondo.DataSource = rptTmp.DataSource;
detailCondo.DataMember = "dtCondo";
detailTotal.DataSource = rptTmp.DataSource;
detailTotal.DataMember = "dtTotal";
detailWp1.DataSource = rptTmp.DataSource;
detailWp1.DataMember = "dtWp1";
detailWp2.DataSource = rptTmp.DataSource;
detailWp2.DataMember = "dtWp2";
detailWp3.DataSource = rptTmp.DataSource;
detailWp3.DataMember = "dtWp3";
detailOther.DataSource = rptTmp.DataSource;
detailOther.DataMember = "dtOther";
}
private void JMRAP02_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
JMRAP02_01 detail1 = xrSubreport1.ReportSource as JMRAP02_01;
JMRAP02_02 detail2 = xrSubreport2.ReportSource as JMRAP02_02;
JMRAP02_03 detail3 = xrSubreport3.ReportSource as JMRAP02_03;
JMRAP02_04 detail4 = xrSubreport4.ReportSource as JMRAP02_04;
JMRAP02_05 detail5 = xrSubreport5.ReportSource as JMRAP02_05;
//if (detail1 == null || detail2 == null) return;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detail1.DataSource = rptTmp.DataSource;
detail1.DataMember = "dtDeposit";
detail2.DataSource = rptTmp.DataSource;
detail2.DataMember = "dtSale";
detail3.DataSource = rptTmp.DataSource;
detail3.DataMember = "dtCancel";
detail4.DataSource = rptTmp.DataSource;
detail4.DataMember = "dtBalance";
detail5.DataSource = rptTmp.DataSource;
detail5.DataMember = "dtCreditCardCancel";
}
private void editPrint()
{
string path;
DevExpress.XtraReports.UI.XtraReport rptTmp = null;
if (Config.GetValue("DuongDanBaoCao") != null)
{
path = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + "billPOS.repx";
}
else
{
path = Application.StartupPath + "\\Reports\\" + Config.GetValue("Package").ToString() + "\\" + "billPOS.repx";
}
if (System.IO.File.Exists(path))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(path, true);
}
else
{
rptTmp = new DevExpress.XtraReports.UI.XtraReport();
}
if (rptTmp != null)
{
rptTmp.DataSource = _cban.tb;
XRDesignFormEx designForm = new XRDesignFormEx();
designForm.OpenReport(rptTmp);
if (System.IO.File.Exists(path))
{
designForm.FileName = path;
}
designForm.KeyPreview = true;
designForm.Show();
}
}
private void SetVariables(DevExpress.XtraReports.UI.XtraReport rptTmp)
{
foreach (DictionaryEntry de in Config.Variables)
{
string key = de.Key.ToString();
if (key.Contains("@"))
{
key = key.Remove(0, 1);
}
XRControl xrc = rptTmp.FindControl(key, true);
if (xrc != null)
{
string value = de.Value.ToString();
try
{
if (value.Contains("/"))
{
xrc.Text = DateTime.Parse(value).ToShortDateString();
}
else
{
xrc.Text = value;
}
}
catch
{
xrc.Text = value;
}
xrc = null;
}
}
}
protected new void Page_Load(object sender, EventArgs e)
{
//header info
int vpm = Request.QueryString["vpm"].ToInt32(0);
int modelId = Request.QueryString["model"].ToInt32(0);
int rictype = Request.QueryString["rictype"].ToInt32(0);
int ricId = Request.QueryString["id"].ToInt32(0);
using (AppDb ctx = new AppDb())
{
if (ricId > 0)
{
ric = ctx.RICs.Where(x => x.Id == ricId).FirstOrDefault();
}
else
{
ric = ctx.RICs.Where(x => x.CatalogModelId == modelId && x.RICTypeId == rictype && x.PackingMonth == vpm.ToString()).FirstOrDefault();
}
}
if (ric == null)
{
var panel1 = new System.Web.UI.WebControls.Panel();
panel1.CssClass = "mainContent";
panel1.Controls.Clear();
panel1.Controls.Add(new LiteralControl(string.Format("<h2 class='grid-header'>Invalid Model/Variant/PackingMonth for RIC</h2>")));
masterPage.MainContent.Controls.Add(panel1);
masterPage.PageTitle.Controls.Add(new LiteralControl("Record Implementation Control"));
return;
}
byte[] reportb = ReportRepository.GetReportBinary("Ric");
if (reportb != null)
{
using (var stream = new MemoryStream(reportb))
{
XtraReport report = XtraReport.FromStream(stream, true);
report.Parameters["parameter1"].Value = ric.Id;
report.Parameters["parameter1"].Visible = false;
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
}
else
{
string filePath = HttpContext.Current.ApplicationInstance.Server.MapPath("~/App_Data/rptRic.repx");
DevExpress.XtraReports.UI.XtraReport report = DevExpress.XtraReports.UI.XtraReport.FromFile(filePath, true);
report.Parameters["parameter1"].Value = ric.Id;
report.Parameters["parameter1"].Visible = false;
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
}
private void JDRAP01_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
JMRAP03_01 detail1 = xrSubreport1.ReportSource as JMRAP03_01;
JMRAP03_02 detail2 = xrSubreport2.ReportSource as JMRAP03_02;
JMRAP03_03 detail3 = xrSubreport3.ReportSource as JMRAP03_03;
JMRAP03_04 detail4 = xrSubreport4.ReportSource as JMRAP03_04;
JMRAP03_05 detail5 = xrSubreport5.ReportSource as JMRAP03_05;
JMRAP03_06 detail6 = xrSubreport6.ReportSource as JMRAP03_06;
JMRAP03_08 detail8 = xrSubreport8.ReportSource as JMRAP03_08;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detail1.DataSource = rptTmp.DataSource;
detail1.DataMember = "dt1";
detail2.DataSource = rptTmp.DataSource;
detail2.DataMember = "dt2";
detail3.DataSource = rptTmp.DataSource;
detail3.DataMember = "dt3";
detail4.DataSource = rptTmp.DataSource;
detail4.DataMember = "dt4";
detail5.DataSource = rptTmp.DataSource;
detail5.DataMember = "dt5";
detail6.DataSource = rptTmp.DataSource;
detail6.DataMember = "dt6";
detail8.DataSource = rptTmp.DataSource;
detail8.DataMember = "dt8";
}
private void simpleButtonPreview_Click(object sender, EventArgs e)
{
// if (Int32.Parse(_data.DrTable["RpType"].ToString()) == 2)
// gridViewReport.ActiveFilterString = "InBaoCao = 1";
DevExpress.XtraReports.UI.XtraReport rptTmp = null;
string reportFile, title;
if (lcisysFormReport.Visibility == DevExpress.XtraLayout.Utils.LayoutVisibility.Always)
{
DataTable dtFormReport = lookUpEditsysFormReport.Properties.DataSource as DataTable;
DataRow dr = dtFormReport.Rows[lookUpEditsysFormReport.ItemIndex];
reportFile = checkEditNgoaiTe.Checked ? dr["ReportFile2"].ToString() : dr["ReportFile"].ToString();
title = checkEditNgoaiTe.Checked ? dr["ReportName2"].ToString() : dr["ReportName"].ToString();
}
else
{
reportFile = checkEditNgoaiTe.Checked ? _data.DrTable["ReportFile2"].ToString() : _data.DrTable["ReportFile"].ToString();
title = checkEditNgoaiTe.Checked ? _data.DrTable["ReportName2"].ToString() : _data.DrTable["ReportName"].ToString();
}
string path = "";
if (Config.GetValue("DuongDanBaoCao") != null)
{
path = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + reportFile + ".repx";
}
else
{
path = Application.StartupPath + "\\Reports\\" + Config.GetValue("Package").ToString() + "\\" + reportFile + ".repx";
}
if (System.IO.File.Exists(path))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(path, true);
rptTmp.DataSource = gridViewReport.DataSource;
if (Int32.Parse(_data.DrTable["RpType"].ToString()) == 2)
{
(rptTmp.DataSource as DataView).RowFilter = "InBaoCao = 1";
}
XRControl xrcTitle = rptTmp.FindControl("title", true);
if (xrcTitle != null)
{
xrcTitle.Text = title;
}
SetVariables(rptTmp);
rptTmp.ScriptReferences = new string[] { Application.StartupPath + "\\CDTLib.dll" };
rptTmp.ShowPreviewDialog();
}
else
{
ShowDefaultReport(this.gridControlReport, false);
}
//gridControlReport.ShowPrintPreview();
if (Int32.Parse(_data.DrTable["RpType"].ToString()) == 2)
{
gridViewReport.ActiveFilterString = "";
}
}
private void frmGe_sis_reporte_Disenador_Load(object sender, EventArgs e)
{
try
{
string Rpt = "";
string asambly = "";
string nombreAsambly = "";
if (InfoReporte != null)
{
if (InfoReporte.CodReporte != null)
{
Rpt = InfoReporte.Class_NomReporte;
asambly = InfoReporte.nom_Asembly;
nombreAsambly = asambly + ".dll";
Ensamblado = Assembly.LoadFrom(nombreAsambly);
Object ObjFrm;
Type tipo = Ensamblado.GetType(asambly + "." + Rpt);
if (tipo == null)
{
MessageBox.Show("No se encontró el Reporte Emsamblado:" + asambly + " Reporte:" + Rpt, param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ObjFrm = Activator.CreateInstance(tipo);
DevExpress.XtraReports.UI.XtraReport Reporte_Para_diseño = (DevExpress.XtraReports.UI.XtraReport)ObjFrm;
if (Reporte_Para_diseño != null)
{
if (InfoReporte.Disenio_reporte != null)
{
File.WriteAllBytes(RootReporte, InfoReporte.Disenio_reporte);
}
commandBarItem31.PerformClick();
if (InfoReporte.Disenio_reporte != null)
{
Reporte_Para_diseño.LoadLayout(RootReporte);
}
xrDesignDockManager1.XRDesignPanel.OpenReport(Reporte_Para_diseño);
}
}
}
}
commandBarItem31.Enabled = false;
commandBarItem32.Enabled = false;
}
catch (Exception ex)
{
string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name;
NameMetodo = NameMetodo + " - " + ex.ToString();
Log_Error_bus.Log_Error(NameMetodo + " - " + ex.ToString());
MessageBox.Show(NameMetodo + " " + param.Get_Mensaje_sys(enum_Mensajes_sys.Error_comunicarse_con_sistemas)
, param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Printing(object tb, XtraReport _rptTmp)
{
db = tb;
rptTmp = _rptTmp;
PrintingSystemBase ps = rptTmp.PrintingSystem;
ps.StartPrint += Ps_StartPrint;
}
private void simplePrint_Click(object sender, EventArgs e)
{
if (Config.GetValue("isDemo").ToString() == "1")
{
return;
}
DevExpress.XtraReports.UI.XtraReport rptTmp = null;
string reportFile, title;
if (lcisysFormReport.Visibility == DevExpress.XtraLayout.Utils.LayoutVisibility.Always)
{
DataTable dtFormReport = lookUpEditsysFormReport.Properties.DataSource as DataTable;
DataRow dr = dtFormReport.Rows[lookUpEditsysFormReport.ItemIndex];
reportFile = checkEditNgoaiTe.Checked ? dr["ReportFile2"].ToString() : dr["ReportFile"].ToString();
title = checkEditNgoaiTe.Checked ? dr["ReportName2"].ToString() : dr["ReportName"].ToString();
}
else
{
reportFile = checkEditNgoaiTe.Checked ? _data.DrTable["ReportFile2"].ToString() : _data.DrTable["ReportFile"].ToString();
title = checkEditNgoaiTe.Checked ? _data.DrTable["ReportName2"].ToString() : _data.DrTable["ReportName"].ToString();
}
string path = "";
if (Config.GetValue("DuongDanBaoCao") != null)
{
path = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + reportFile + ".repx";
}
else
{
path = Application.StartupPath + "\\Reports\\" + Config.GetValue("Package").ToString() + "\\" + reportFile + ".repx";
}
if (System.IO.File.Exists(path))
{
//rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(path, true);
//rptTmp.DataSource = gridViewReport.DataSource;
//if (Int32.Parse(_data.DrTable["RpType"].ToString()) == 2)
// (rptTmp.DataSource as DataView).RowFilter = "InBaoCao = 1";
//XRControl xrcTitle = rptTmp.FindControl("title", true);
//if (xrcTitle != null)
// xrcTitle.Text = title;
//SetVariables(rptTmp);
//rptTmp.ScriptReferences = new string[] { Application.StartupPath + "\\CDTLib.dll" };
////rptTmp.Print("\\\\vytc\\Canon LBP2900");
//rptTmp.Print(Config.GetValue("PrinterName").ToString());
CDTControl.Printing re = new CDTControl.Printing(gridViewReport.DataSource, path);
re.Print();
}
else
{
rptTmp.Print(Config.GetValue("PrinterName").ToString());
}
if (Int32.Parse(_data.DrTable["RpType"].ToString()) == 2)
{
gridViewReport.ActiveFilterString = "";
}
}
private void JIRAS02_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
JIRAP02_01 detail1 = xrSubreport1.ReportSource as JIRAP02_01;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detail1.DataSource = rptTmp.DataSource;
detail1.DataMember = "dt2";
}
private void JMRAP08_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
JMRAP08_01 subJMRAP08_01 = xrSubreport1.ReportSource as JMRAP08_01;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
subJMRAP08_01.DataSource = rptTmp.DataSource;
subJMRAP08_01.DataMember = "dtUpjang";
}
private void EditReport(DataTable tb)
{
if (tb == null)
{
return;
}
DataTable dataPrint = tb;
DevExpress.XtraReports.UI.XtraReport rptTmp = null;
string path;
if (Config.GetValue("DuongDanBaoCao") != null)
{
path = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + fileReport + ".repx";
}
else
{
path = Application.StartupPath + "\\Reports\\" + Config.GetValue("Package").ToString() + "\\" + fileReport + ".repx";
}
string pathTmp;
if (Config.GetValue("DuongDanBaoCao") != null)
{
pathTmp = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + fileReport + ".repx";
}
else
{
pathTmp = Application.StartupPath + "\\" + Config.GetValue("Package").ToString() + "\\Reports\\template.repx";
}
if (System.IO.File.Exists(path))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(path, true);
}
else if (System.IO.File.Exists(pathTmp))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(pathTmp, true);
}
else
{
rptTmp = new DevExpress.XtraReports.UI.XtraReport();
}
if (rptTmp != null)
{
rptTmp.DataSource = dataPrint;
XRDesignFormEx designForm = new XRDesignFormEx();
designForm.OpenReport(rptTmp);
if (System.IO.File.Exists(path))
{
designForm.FileName = path;
}
designForm.KeyPreview = true;
designForm.KeyDown += new KeyEventHandler(designForm_KeyDown);
designForm.Show();
}
}
/// <summary>
/// Prepares the report.
/// </summary>
/// <param name="stvReport">The STV report.</param>
private static void PrepareTheReport(DevExpress.XtraReports.UI.XtraReport stvReport)
{
if (BLL.Settings.UseCustomSizedPaperForPrinting)
{
stvReport.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter;
stvReport.PaperKind = System.Drawing.Printing.PaperKind.Custom;
stvReport.PageHeight = Convert.ToInt32(BLL.Settings.PaperHeight);
stvReport.PageWidth = Convert.ToInt32(BLL.Settings.PaperWidth);
}
}
private void FARAP04_3_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
//FARAP04_01 detail1 = xrSubreport1.ReportSource as FARAP04_01;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
//detail1.DataSource = rptTmp.DataSource;
//detail1.DataMember = "dt";
}
private void simpleButtonSuaMau_Click(object sender, EventArgs e)
{
DataTable dtReport = _data.GetDataForPrint(_arrIndex[0]);
if (dtReport == null)
{
return;
}
DevExpress.XtraReports.UI.XtraReport rptTmp = null;
string path;
if (Config.GetValue("DuongDanBaoCao") != null)
{
path = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + _reportFile + ".repx";
}
else
{
path = Application.StartupPath + "\\Reports\\" + Config.GetValue("Package").ToString() + "\\" + _reportFile + ".repx";
}
string pathTmp;
if (Config.GetValue("DuongDanBaoCao") != null)
{
pathTmp = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + _reportFile + ".repx";
}
else
{
pathTmp = Application.StartupPath + "\\" + Config.GetValue("Package").ToString() + "\\Reports\\template.repx";
}
if (System.IO.File.Exists(path))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(path, true);
}
else if (System.IO.File.Exists(pathTmp))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(pathTmp, true);
}
else
{
rptTmp = new DevExpress.XtraReports.UI.XtraReport();
}
if (rptTmp != null)
{
rptTmp.DataSource = dtReport;
XRDesignFormEx designForm = new XRDesignFormEx();
designForm.OpenReport(rptTmp);
if (System.IO.File.Exists(path))
{
designForm.FileName = path;
}
designForm.KeyPreview = true;
designForm.KeyDown += new KeyEventHandler(designForm_KeyDown);
designForm.Show();
}
}
private void ApplyNewWidthToReportCells(DevExpress.XtraReports.UI.XtraReport xtraReport)
{
IList <KeyValuePair <XRTable, List <XRTable> > > tables = FindTables(xtraReport);
foreach (var table in tables)
{
float totalWidth = 0;
foreach (XRTableCell dc in table.Key.Rows[0].Cells)
{
float newWidth = cellColumnWidthCollection[dc];
foreach (var otherTable in table.Value)
{
newWidth = Math.Max(newWidth, cellColumnWidthCollection[otherTable.Rows[0].Cells[dc.Index]]);
}
newWidth += AdditionalCellWidth;
totalWidth += newWidth;
}
table.Key.WidthF = totalWidth;
foreach (var otherTable in table.Value)
{
otherTable.WidthF = totalWidth;
}
table.Key.BeginInit();
foreach (var otherTable in table.Value)
{
otherTable.BeginInit();
}
foreach (XRTableCell dc in table.Key.Rows[0].Cells)
{
float newWidth = cellColumnWidthCollection[dc];
foreach (var otherTable in table.Value)
{
newWidth = Math.Max(newWidth, cellColumnWidthCollection[otherTable.Rows[0].Cells[dc.Index]]);
}
newWidth += AdditionalCellWidth;
dc.WidthF = newWidth;
foreach (var otherTable in table.Value)
{
otherTable.Rows[0].Cells[dc.Index].WidthF = newWidth;
}
}
table.Key.EndInit();
foreach (var otherTable in table.Value)
{
otherTable.EndInit();
}
}
}
private void PrepareGRVPrintout(DevExpress.XtraReports.UI.XtraReport printout)
{
BLL.ReportPrintout rpt = new ReportPrintout();
if (rpt.IsReportSizeCustom("GOODS_RECEIPT_VOUCHER"))
{
printout.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter;
printout.PaperKind = System.Drawing.Printing.PaperKind.Custom;
printout.PageHeight = rpt.HeightInMM / 10; //Convert.ToInt32(BLL.Settings.PaperHeightCredit);
printout.PageWidth = rpt.WidthInMM / 10; //Convert.ToInt32(BLL.Settings.PaperWidthCredit);
}
}
public ActionResult EmailReport()
{
DevExpress.XtraReports.UI.XtraReport currentReport = (DevExpress.XtraReports.UI.XtraReport)Session["currentReport"];
IIrmaServiceDataModel emailDataModel = IrmaServiceSystem.GetServiceModel(IrmaConstants.IrmaPobModels.Emails);
PobEmailModel emailModel = emailDataModel.GetItem(string.Format("Name=\"PobSummaryReport\""), "Name");
char[] sep = { ';' };
string[] recipients = (emailModel != null && emailModel.Recipients != null) ? emailModel.Recipients.Split(sep) : null;
IServiceDataModel pobDataModel = ServiceSystem.GetServiceModel(EnscoConstants.EntityModel.User);
try
{
using (SmtpClient client = new SmtpClient("smtp.ensco.ws"))
{
MemoryStream memStream = new MemoryStream();
currentReport.ExportToPdf(memStream);
memStream.Seek(0, System.IO.SeekOrigin.Begin);
Attachment att = new Attachment(memStream, "PobSummayReport.pdf", "application/pdf");
MailMessage message = new MailMessage();
message.Attachments.Add(att);
message.From = new MailAddress("*****@*****.**");
message.Subject = emailModel.Subject;
// Get recepients
foreach (string id in recipients)
{
UserModel user = pobDataModel.GetItem(string.Format("Id={0}", id), "Id");
if (user != null && user.Email != null)
{
message.To.Add(new MailAddress(user.Email));
}
}
// This line can be used to embed HTML into the email itself
// MailMessage message = currentReport.ExportToMail("*****@*****.**", emailModel.Recipients, emailModel.Subject);
// Get correct credentials for irma profile
client.Credentials = new System.Net.NetworkCredential("Ensco\\023627", "");
client.Send(message);
memStream.Close();
memStream.Flush();
}
}
catch (Exception ex)
{
}
return(View("ShowReportPartial", currentReport));
}
private void Print()
{
string path;
DevExpress.XtraReports.UI.XtraReport rptTmp = null;
if (Config.GetValue("DuongDanBaoCao") != null)
{
path = Config.GetValue("DuongDanBaoCao").ToString() + "\\" + Config.GetValue("Package").ToString() + "\\" + "billPOS.repx";
}
else
{
path = Application.StartupPath + "\\Reports\\" + Config.GetValue("Package").ToString() + "\\" + "billPOS.repx";
}
if (System.IO.File.Exists(path))
{
rptTmp = DevExpress.XtraReports.UI.XtraReport.FromFile(path, true);
}
else
{
rptTmp = new DevExpress.XtraReports.UI.XtraReport();
}
if (rptTmp != null)
{
rptTmp.DataSource = _cban.tb;
rptTmp.ScriptReferences = new string[] { Application.StartupPath + "\\CDTLib.dll" };
SetVariables(rptTmp);
DevExpress.XtraReports.UI.XRControl xrcTongTien = rptTmp.FindControl("TongTien", true);
if (xrcTongTien != null)
{
xrcTongTien.Text = double.Parse(_cban.tTien.ToString()).ToString("### ### ### ###");
}
//DevExpress.XtraReports.UI.XRControl xrcDatt = rptTmp.FindControl("DaTT", true);
//if (xrcDatt != null)
// xrcDatt.Text = double.Parse(cDaTT.EditValue.ToString()).ToString("### ### ### ###");
//DevExpress.XtraReports.UI.XRControl xrcConlai = rptTmp.FindControl("Conlai", true);
//if (xrcConlai != null)
// xrcConlai.Text = double.Parse(cConlai.EditValue.ToString()).ToString("### ### ### ###");
DevExpress.XtraReports.UI.XRControl xrcID = rptTmp.FindControl("ID", true);
if (xrcID != null)
{
xrcID.Text = _cban.id;
}
//DevExpress.XtraReports.UI.XRControl xrbID = rptTmp.FindControl("BCID", true);
//if (xrbID != null)
// xrbID.Text = txtCode.Text;
////rptTmp.Print();
rptTmp.Print();
}
}
private void CDRAP02_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
CDRAP02_01 detail1 = xrSubreport1.ReportSource as CDRAP02_01;
CDRAP02_02 detail2 = xrSubreport2.ReportSource as CDRAP02_02;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detail1.DataSource = rptTmp.DataSource;
detail1.DataMember = "dt";
detail2.DataSource = rptTmp.DataSource;
detail2.DataMember = "dtDetailAll";
}
static string GetReportPath(DevExpress.XtraReports.UI.XtraReport fReport, string ext)
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
string repName = fReport.Name;
if (repName.Length == 0)
{
repName = fReport.GetType().Name;
}
string dirName = Path.GetDirectoryName(asm.Location);
return(Path.Combine(dirName, repName + "." + ext));
}
private void JMRAP23_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
JMRAP23_01 detail1 = xrSubreport1.ReportSource as JMRAP23_01;
JMRAP23_02 detail2 = xrSubreport2.ReportSource as JMRAP23_02;
//if (detail1 == null || detail2 == null) return;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detail1.DataSource = rptTmp.DataSource;
detail1.DataMember = "dt";
detail2.DataSource = rptTmp.DataSource;
detail2.DataMember = "dt2";
}
private void ucGe_Menu_event_btnImpRep_Click(object sender, EventArgs e)
{
try
{
string nombre_dll = "";
string Nom_asambly = "";
string NombreReporte = "";
string RutaPantalla = "";
//Nom_asambly = txt_asembly.Text.Trim();
//NombreReporte = txt_class_rpt.Text.Trim();
nombre_dll = Nom_asambly + ".dll";
//cargando la dll
Ensamblado = Assembly.LoadFrom(nombre_dll);
// Load the object
string nAsambly2; //= txt_asembly.Text;
Object ObjFrm;
Type tipo = Ensamblado.GetType(Nom_asambly + "." + NombreReporte);
AssemblyName assemName = Ensamblado.GetName();
Version ver = assemName.Version;
//
RutaPantalla = Nom_asambly + "." + NombreReporte;
if (tipo == null)
{
MessageBox.Show("No se encontró el Reporte Emsamblado:" + Nom_asambly + " Reporte:" + NombreReporte, param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ObjFrm = Activator.CreateInstance(tipo);
DevExpress.XtraReports.UI.XtraReport reporte1 = (DevExpress.XtraReports.UI.XtraReport)ObjFrm;
reporte1.ShowPreviewDialog();
}
}
catch (Exception ex)
{
string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name;
NameMetodo = NameMetodo + " - " + ex.ToString();
Log_Error_bus.Log_Error(NameMetodo + " - " + ex.ToString());
MessageBox.Show(NameMetodo + " " + param.Get_Mensaje_sys(enum_Mensajes_sys.Error_comunicarse_con_sistemas)
, param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DevExpress.XtraReports.UI.XtraReport CreateReportWithAutoCellWidth(DevExpress.XtraReports.UI.XtraReport xtraReport)
{
// I need this for a later excel-export to simulate endless paper (all report pages on one sheet)
xtraReport.PaperKind = PaperKind.Custom;
xtraReport.ReportUnit = ReportUnit.Pixels;
xtraReport.PageWidth = 3000;
xtraReport.RollPaper = true;
cellColumnWidthCollection = new Dictionary <XRControl, float>();
xtraReport.CreateDocument();
FillColumnCellWidthCollection(xtraReport);
ApplyNewWidthToReportCells(xtraReport);
xtraReport.CreateDocument();
return(xtraReport);
}
private void DEAAP05_01_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
//첫 페이지의 서브 리포트 출력
DEAAP05_01_11 detail1 = xrSubreport1.ReportSource as DEAAP05_01_11;
DEAAP05_01_12 detail2 = xrSubreport2.ReportSource as DEAAP05_01_12;
//if (detail1 == null || detail2 == null) return;
DevExpress.XtraReports.UI.XtraReport rptTmp = (DevExpress.XtraReports.UI.XtraReport)sender;
detail1.DataSource = rptTmp.DataSource;
detail1.DataMember = "dtMae";
detail2.DataSource = rptTmp.DataSource;
detail2.DataMember = "dtOth";
}
public DevExpress.XtraReports.UI.XtraReport GetReportStamp(string tenDV)
{
DevExpress.XtraReports.UI.XtraReport xr = new DevExpress.XtraReports.UI.XtraReport();
xr.ReportUnit = ReportUnit.HundredthsOfAnInch;
xr.PaperKind = System.Drawing.Printing.PaperKind.Custom;
xr.PageWidth = this.widthStamp;
xr.PageHeight = this.heightStamp + 1;
xr.PageSize = new Size(this.widthStamp, this.heightStamp);
xr.Margins = new System.Drawing.Printing.Margins(0, 0, 0, 0);
DevExpress.XtraReports.UI.DetailBand Detail = new DevExpress.XtraReports.UI.DetailBand();
DevExpress.XtraReports.UI.XRTable xrTable = new DevExpress.XtraReports.UI.XRTable();
DevExpress.XtraReports.UI.XRTableRow row = new DevExpress.XtraReports.UI.XRTableRow();
DevExpress.XtraReports.UI.XRTableCell cell;
Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { xrTable });
xrTable.Location = new Point(0, 0);
xrTable.Size = new System.Drawing.Size(this.widthStamp, this.heightStamp);
xrTable.Rows.Add(row);
xrTable.Borders = DevExpress.XtraPrinting.BorderSide.None;
xrTable.BorderWidth = 0;
row.Location = new Point(0, 0);
row.Size = new Size(this.widthStamp, this.heightStamp);
row.Borders = DevExpress.XtraPrinting.BorderSide.None;
cell = GetCellStampEx(0, 0, tenDV);
cell.Location = new Point(0, 0);
cell.Size = new Size(this.widthStamp, this.heightStamp);
row.Cells.Add(cell);
cell.Borders = DevExpress.XtraPrinting.BorderSide.None;
xr.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { Detail });
return xr;
}
