using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using gregn6Lib;
|
//using AxgrproLib;
|
using System.Data;
|
|
namespace BLL
|
{
|
class ReportCls
|
{
|
//public static string spName = string.Empty;
|
//public static object[] parameterValues;
|
//public static string ExecuteStr = string.Empty;
|
//public static bool IsDate = false;
|
//public static DateTime FirstDate = DateTime.Today;
|
//public static DateTime LastDate = DateTime.Today;
|
|
private string _spName = string.Empty;
|
private object[] _parameterValues;
|
private bool _IsDate = false;
|
private DateTime _FirstDate = DateTime.Today;
|
private DateTime _LastDate = DateTime.Today;
|
private DataTable _Dt;
|
|
public DataTable Dt
|
{
|
get { return _Dt; }
|
set { _Dt = value; }
|
}
|
|
public String spName
|
{
|
get { return _spName; }
|
set { _spName = value; }
|
}
|
|
public object[] parameterValues
|
{
|
get { return _parameterValues; }
|
set { _parameterValues = value; }
|
}
|
|
public bool IsDate
|
{
|
get { return _IsDate; }
|
set { _IsDate = value; }
|
}
|
|
public DateTime FirstDate
|
{
|
get { return _FirstDate; }
|
set { _FirstDate = value; }
|
}
|
|
public DateTime LastDate
|
{
|
get { return _LastDate; }
|
set { _LastDate = value; }
|
}
|
|
private GridppReport Report = new GridppReport();
|
|
public void LoadReport(String sFileName)
|
{
|
Report.LoadFromFile(sFileName+ ".grf");
|
Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
|
Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecord);
|
}
|
|
//public void LoadReport(AxGRDisplayViewer sGR, String sFileName)
|
//{
|
|
// //Report.LoadFromFile(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + (@"Report\") + sFileName + ".grf");
|
// Report.LoadFromFile(sFileName);
|
// Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
|
// Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
|
// sGR.Report = Report;
|
// sGR.Start();
|
//}
|
|
public void ReportBeforePostRecord()
|
{
|
if (_IsDate == true)
|
{
|
Report.FieldByName("FirstDate").AsDateTime = _FirstDate;
|
Report.FieldByName("LastDate").AsDateTime = _LastDate;
|
}
|
}
|
|
public void ReportFetchRecord()
|
{
|
//SqlDataReader Dr = SqlHelper.ExecuteReader(Configs.GetConnectionString(), CommandType.Text, ExecuteStr);
|
// Dr = SqlHelper.ExecuteReader(Configs.GetConnectionString(), _spName, _parameterValues);
|
//GridppReportCls.Utility.FillRecordToReport(Report, Dr);
|
//Dr.Close();
|
//Dr.Dispose();
|
}
|
|
public void ReportFetchRecordByDataTable()
|
{
|
|
Utility.FillRecordToReport(Report, Dt);
|
Dt.Dispose();
|
}
|
|
public void ReportPreview()
|
{
|
Report.PrintPreview(true);
|
}
|
|
public void ReportPrint()
|
{
|
Report.Print(true);
|
}
|
|
public void ReportExport()
|
{
|
Report.ExportDirect(GRExportType.gretXLS, Report.Title, false, true);
|
}
|
}
|
}
|
