void expButton_MouseDown(object sender, MouseEventArgs e)
{
report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass);
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.Filter = "Crystal Report (*.rpt)|*.rpt|Adobe Acrobat (*.pdf)|*.pdf|Microsoft Excel (*.xls)|*.xls|Microsoft Word (*.doc)|*.doc|Rich Text Format (*.rtf)|*.rtf";
saveDialog.Title = "Экспорт рапорта";
saveDialog.ShowDialog();
if (saveDialog.FileName != "")
{
switch (saveDialog.FilterIndex)
{
case 1:
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.CrystalReport, @saveDialog.FileName);
break;
case 2:
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @saveDialog.FileName);
break;
case 3:
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, @saveDialog.FileName);
break;
case 4:
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, @saveDialog.FileName);
break;
case 5:
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.RichText, @saveDialog.FileName);
break;
default:
break;
}
}
}
private CrystalDecisions.CrystalReports.Engine.ReportClass getCrystalReport()
{
CrystalDecisions.CrystalReports.Engine.ReportClass reportObject = null;
if (chkPhotoInvoice.Checked)
{
reportObject = new InvoiceWithPicture();
}
else
{
reportObject = new InvoiceWithoutPicture();
}
customerName = "Manish Madhopuria";
customerAddress = "46,M.A.K.Azad Road, Howrah -711101";
CrystalDecisions.CrystalReports.Engine.TextObject txtObject;
txtObject = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.ReportDefinition.ReportObjects["txtName"];
txtObject.Text = customerName;
txtObject = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.ReportDefinition.ReportObjects["txtAddress"];
txtObject.Text = customerAddress;
// reportObject.SetParameterValue("txtName", customerName);
// reportObject.SetParameterValue("txtAddress", customerAddress);
// CrystalDecisions.CrystalReports.Engine.TextObject txtCustomerName = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.Section1.ReportObjects["txtName"];
// CrystalDecisions.CrystalReports.Engine.TextObject txtCustomerAddress = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.Section1.ReportObjects["txtAddress"];
// txtCustomerName.Text = customerName;
// txtCustomerAddress.Text = customerAddress;
// CrystalDecisions.CrystalReports.Engine.TextObject txtInvoiceType = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.Section1.ReportObjects["txtInvoiceType"];
return(reportObject);
}
public bool ShowReport(string[] reportTitle, string[] reportData, DataTable dataTbl,
CrystalDecisions.CrystalReports.Engine.ReportClass myReport)
{
try
{
//==============================
// Make report
//==============================
if (this.ExportOutput != Export.ExportFormat.None)
{
this.ExportData(dataTbl, this.ExportOutput);
}
else
{
myReport.SetDataSource(dataTbl);
reportViewer.SetReportPara(myReport.ParameterFields, reportTitle, "reportTitle");
reportViewer.SetReportPara(myReport.ParameterFields, reportData, "reportData");
reportViewer.ShowReport(myReport);
myReport.Dispose();
}
}
catch (Exception er)
{
common.errorHandler.lastErrorMessage = er.Message.ToString();
return(false);
}
return(true);
}
// This method will allow you may easily set report datasource based on your current SqlServerConnetion
public static void SetSqlConnection(CrystalDecisions.CrystalReports.Engine.ReportClass MyReport, SqlConnection MySqlConnection)
{
// You may even test SqlConnection before using it.
SqlConnectionStringBuilder SqlConnectionStringBuilder = new SqlConnectionStringBuilder(MySqlConnection.ConnectionString);
string ServerName = SqlConnectionStringBuilder.DataSource;
string DatabaseName = SqlConnectionStringBuilder.InitialCatalog;
Boolean IntegratedSecurity = SqlConnectionStringBuilder.IntegratedSecurity;
string UserID = SqlConnectionStringBuilder.UserID;
string Password = SqlConnectionStringBuilder.Password;
// Of course, you may add extra settings here :D
// On Crystal Reports, connection must be set individually for each table defined on the report document
foreach (CrystalDecisions.CrystalReports.Engine.Table Table in MyReport.Database.Tables)
{
CrystalDecisions.Shared.TableLogOnInfo TableLogOnInfo = Table.LogOnInfo;
TableLogOnInfo.ConnectionInfo.ServerName = ServerName;
TableLogOnInfo.ConnectionInfo.DatabaseName = DatabaseName;
TableLogOnInfo.ConnectionInfo.IntegratedSecurity = IntegratedSecurity;
if (IntegratedSecurity != true)
{
TableLogOnInfo.ConnectionInfo.UserID = UserID;
TableLogOnInfo.ConnectionInfo.Password = Password;
}
Table.ApplyLogOnInfo(TableLogOnInfo);
}
}
public PrintPreview(CrystalDecisions.CrystalReports.Engine.ReportClass EmpAccRpt)
{
InitializeComponent();
this.crystalReportViewer1.ReportSource = EmpAccRpt;
crystalReportViewer1.Zoom(75);
// crystalReportViewer1.
}
public InvoiceReportForm(int invID, int patID, DateTime startRange, DateTime endRange)
{
InitializeComponent();
report = new InvoiceReport();
InvoiceViewModelBindingSource.DataSource = Database.InvoiceViewModel.GetInvoices(invID);
report.SetDataSource(InvoiceViewModelBindingSource);
crystalReportViewer1.ReportSource = report;
}
public static void setSX3InvoiceParams(string hoaDonID, CrystalDecisions.CrystalReports.Engine.ReportClass hd)
{
hd.SetDataSource(DataTier.fillHoaDon(hoaDonID));
hd.SetParameterValue("ngayBatDau", ngayBatDau);
hd.SetParameterValue("ngayKetThuc", ngayKetThuc);
hd.SetParameterValue("giaDien1", giaDien);
hd.SetParameterValue("giaDien2", giaDienSX3_2);
hd.SetParameterValue("ngayKyHD", "Ngày " + ngayKy + "/" + thangKy + "/" + namKy);
hd.SetParameterValue("ngayKyHD2", "Ngày " + ngayKy + " tháng " + thangKy + " năm " + namKy);
hd.SetParameterValue("tongTienBangChu", docChu);
}
private void button1_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ContratoEmpreteiro1;
CrystalDecisions.Shared.ParameterField parm;
parm = report.ParameterFields["Contrato"];
parm.CurrentValues.Clear();
parm.CurrentValues.AddValue(TxtBoxContrato.Text);
report.SetDatabaseLogon("scoop", "scoop", @"PMC0091SRVSIPA1", "scoop");
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
private void Report_Viewer_Load(object sender, EventArgs e)
{
function.settheme(this);
if (module_Rpt.rpt_name.CompareTo("FRM_ITEMMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_ItemMaster");
doc = new RptItemMaster();
doc.Database.Tables["Tbl_ItemMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
else
{
}
}
private void printInvoice(int svno)
{
InvoicePrinting invoicePrinting = new InvoicePrinting();
DataSet ds = new DataSet();
invoicePrinting.prepareDataSetForInvoiceReport(ds, svno);
CrystalDecisions.CrystalReports.Engine.ReportClass report = getCrystalReport();
report.SetDataSource(ds);
CrystalDecisions.CrystalReports.Engine.TextObject txtInvoiceType;
txtInvoiceType = (CrystalDecisions.CrystalReports.Engine.TextObject)report.ReportDefinition.ReportObjects["txtInvoiceType"];
txtInvoiceType.Text = "Original";
report.PrintToPrinter(1, false, 0, 0);
txtInvoiceType.Text = "Duplicate";
report.PrintToPrinter(1, false, 0, 0);
}
public ActionResult PrintAssemssment()
{
try
{
var cm = new Common();
var A = cm.GetAssessment();
var Ad = cm.GetAssessDetail();
var At = cm.GetAssessType();
var S = cm.GetStudent();
var query = from _A in A
from _Ad in Ad
from _At in At
where _A.ass_id == _Ad.ass_id && _A.ass_type_id == _At.asstype_id.ToString() && _Ad.ass_no == _At.ass_no
select new { _At.question, _Ad.answer };
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("question");
dt.Columns.Add("answer");
foreach (var aa in query)
{
dr = dt.NewRow();
dr["question"] = aa.question;
dr["answer"] = aa.answer;
dt.Rows.Add(dr);
}
if (dt.Rows.Count > 0)
{
using (CrystalDecisions.CrystalReports.Engine.ReportClass rptH = new CrystalDecisions.CrystalReports.Engine.ReportClass())
{
string path = HttpContext.Server.MapPath("~/App_Data/reportPdf.rpt");
rptH.FileName = path;
rptH.Load();
rptH.SetDataSource(dt);
// rptH.SetParameterValue("isAdmin", (user.Role.RoleName == RoleName.Admintstrator ? "T" : "F"));
System.IO.Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
rptH.Close();
return(File(stream, "application/pdf"));
}
}
return(new EmptyResult());
}
catch (Exception ex)
{
return(new EmptyResult());
}
}
private void getRepoData(ref CrystalDecisions.CrystalReports.Engine.ReportClass repo, int l)
{
if (repo != null)
{
//repo.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)GetPagerSizeId("京东");//设置打印纸张
string delivery_id = "JDVA01661244585";
string packagecount = l.ToString();
string weight = "5";
string source_sort_center_name = "北京通州分拣中心";
string source_cross_code = "10";
string source_tabletrolley_code = "160-呼市";
string target_sort_center_name = "呼和浩特分拨中心";
string target_tabletrolley_code = "A10-9";
string receive_address = "内蒙古呼和浩特市土默特左旗经济技术开发区金川区宽城小区";
string receive_name = "朱银岭";
string receive_mobile = "15335557302";
string sender_address = "内蒙古呼和浩特市和林格尔县企业总部南300米云谷水岸小区东侧";
string sender_name = "小致";
string sender_mobile = "18301192819";
string order_id = "B20200117155332304748390";
string road = "8";
string site_name = "*呼市金川宽城营业部";
repo.DataDefinition.FormulaFields["bgydh"].Text = "'" + delivery_id + "-" + l.ToString() + "-" + packagecount + "-'"; //包裹运单号(运单号 -包裹序号 -包裹总数 -)
repo.DataDefinition.FormulaFields["bgzl"].Text = "'" + weight + "'"; //包裹重量
repo.DataDefinition.FormulaFields["sourcetSortCenterName"].Text = "'" + source_sort_center_name + "'"; //始发分拣中心名称
repo.DataDefinition.FormulaFields["originalCrossCode"].Text = "'" + source_cross_code + "'"; //始发道口号
repo.DataDefinition.FormulaFields["originalTabletrolleyCode"].Text = "'" + source_tabletrolley_code + "'"; //始发车笼号
repo.DataDefinition.FormulaFields["targetSortCenterName"].Text = "'" + target_sort_center_name + "'"; //目的地分拣中心名称
repo.DataDefinition.FormulaFields["destinationCrossCode"].Text = "'" + target_tabletrolley_code + "'"; //目的道口号
repo.DataDefinition.FormulaFields["destinationTabletrolleyCode"].Text = "'" + target_tabletrolley_code + "'"; //目的车笼号
repo.DataDefinition.FormulaFields["sjxx"].Text = "'" + receive_address + " " + receive_name + " " + receive_mobile + "'"; //客户信息【黑体 9 号】：包含收件方姓名、电话、地址
repo.DataDefinition.FormulaFields["ysje"].Text = "'0.00'";
repo.DataDefinition.FormulaFields["ydh"].Text = "'" + delivery_id + "'"; //运单号
repo.DataDefinition.FormulaFields["khxx"].Text = "'" + receive_name + " " + receive_mobile + "'"; //收件客户名称、电话
repo.DataDefinition.FormulaFields["remark"].Text = "''"; //备注 青岛啤酒（Tsingtao）黑啤 /n 500ml * 12听 / 箱 整箱装 包
repo.DataDefinition.FormulaFields["jfkhxx"].Text = "'" + sender_address + " " + sender_name + " " + sender_mobile + "'"; //寄方客户信息
repo.DataDefinition.FormulaFields["sjid"].Text = "'202001151924001'"; //商家ID
repo.DataDefinition.FormulaFields["bsjddh"].Text = "'" + order_id + "'"; //商家订单号
repo.DataDefinition.FormulaFields["startCity"].Text = "'" + source_sort_center_name + "'"; //始发城市
repo.DataDefinition.FormulaFields["rode"].Text = "'" + road + "'"; //路区
repo.DataDefinition.FormulaFields["bgxl"].Text = "'" + l.ToString() + "/" + packagecount + "'"; //包裹序列
repo.DataDefinition.FormulaFields["siteName"].Text = "'" + site_name + "'"; //站点名称
repo.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait; //纵向打印
}
}
private void frmShowReport_Load(object sender, EventArgs e)
{
if (objReportSource == null)
{
objReportSource = new crpVuoto();
this.WindowState = FormWindowState.Minimized;
bIsToHide = true;
timer1.Enabled = true;
}
else
{
crViewer.ReportSource = null;
crViewer.Show();
crViewer.ReportSource = objReportSource;
crViewer.Refresh();
crViewer.Show();
}
}
private void GerarButton_Click(object sender, EventArgs e)
{
if (!checkBox1.Checked)
{
CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ServicoMedicao1;
CrystalDecisions.Shared.ParameterField parm;
parm = report.ParameterFields["DataInicial"];
parm.CurrentValues.Clear();
parm.CurrentValues.AddValue(DataInicialDTP.Value.Date.ToShortDateString());
parm = report.ParameterFields["DataFinal"];
parm.CurrentValues.AddValue(DataFinalDTP.Value.Date.ToShortDateString());
report.SetDatabaseLogon("scoop", "scoop", @"pmc0091srvsipa1", "scoop");
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
else
{
CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ServicoMedicaoTOP1;
report.SetDatabaseLogon("scoop", "scoop", @"pmc0091srvsipa1", "scoop");
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
}
private void CrystalReportPrint()
{
try
{
CrystalDecisions.CrystalReports.Engine.ReportClass repo = (CrystalDecisions.CrystalReports.Engine.ReportClass)Assembly.Load("CrystalReportDemo").CreateInstance("CrystalReportDemo.rpt.CrystalReport1");
if (repo != null)
{
for (int i = 0; i < 4; i++)
{
getRepoData(ref repo, i);
//repo.PrintToPrinter(1, false, 0, 0);//打印
//预览
FrmPrint frmPrint = new FrmPrint();
frmPrint.rpst = repo;
frmPrint.ShowDialog(this);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void button1_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportClass report = this.RelatorioMedicao1;
this.RelatorioMedicao1.RecordSelectionFormula = "";
if (DotacaoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula = DotacaoFiltro;
if (TipoObraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + TipoObraFiltro;
if (BairroFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro;
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
else
{
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
}
else
{
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
else
{
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
}
}
else
{
if (BairroFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro;
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
else
{
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
}
}
}
else
{
if (TipoObraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += TipoObraFiltro;
if (BairroFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro;
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
else
{
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
}
else
{
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
else
{
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
}
}
else
{
if (BairroFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += BairroFiltro;
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
else
{
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";;
}
}
}
else
{
if (EmpreteiraFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += EmpreteiraFiltro;
if (PeriodoFiltro != null)
{
this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";
}
}
else
{
if (!PeriodoChkBox.Checked)
{
this.RelatorioMedicao1.RecordSelectionFormula = "{Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";
}
}
}
}
}
this.RelatorioMedicao1.Refresh();
CrystalDecisions.Shared.ParameterField parm;
parm = report.ParameterFields["Filtro"];
parm.CurrentValues.Clear();
parm.CurrentValues.AddValue(DotacaoFiltro == ""?"":"Dotação Orçamentaria" + " " + TipoObraFiltro == ""?"":"Tipo Orçamento" + " " + BairroFiltro == ""?"":"Bairro" + " " + EmpreteiraFiltro == ""?"":"Empreteira" + " " + PeriodoFiltro == ""?"":"Periodo ");
report.SetDatabaseLogon("scoop", "scoop", @"PMC0091SRVSIPA1", "scoop", true);
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
public void setReportSource(CrystalDecisions.CrystalReports.Engine.ReportClass Reporte)
{
this.crvReportes.ReportSource = Reporte;
}
public FrmReportes(CrystalDecisions.CrystalReports.Engine.ReportClass Reporte)
{
InitializeComponent();
this.crvReportes.ReportSource = Reporte;
}
public Form_crystal_report(CrystalDecisions.CrystalReports.Engine.ReportClass rpt_class)
{
InitializeComponent();
crystalReportViewer1.ReportSource = rpt_class;
}
void searchButton_MouseDown(object sender, MouseEventArgs e)
{
report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass);
CodeHelper.UI.MessageDialog<TextBox> mesDialog = new MessageDialog<TextBox>("Поиск", "Слово или фраза в документе:", "");
switch (mesDialog.ShowDialog())
{
case DialogResult.OK:
while (SearchForText(mesDialog[0].Text))
mesDialog.ShowDialog();
MessageBox.Show("Поиск в документе окончен", "Результаты поиска");
break;
default: break;
}
}
private void Report_Viewer_Load(object sender, EventArgs e)
{
function.settheme(this);
//--------*********>>>>>>>>>>>>>>>>> Binding a Report Master Form <<<<<<<<<<<<<<<*********--------
if (module_Rpt.rpt_name.CompareTo("FRM_EMPLOYEEMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_EmployeeMaster");
doc = new RptEmployeeMaster();
doc.Database.Tables["Tbl_EmployeeMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_ITEMMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_ItemMaster");
doc = new RptItemMaster();
doc.Database.Tables["Tbl_ItemMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_CUSTOMERMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_CustomerMaster");
doc = new RptCustomerMaster();
doc.Database.Tables["Tbl_CustomerMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_TRANSPORTATION_MASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_TransportationMaster");
doc = new RptTransportationMaster();
doc.Database.Tables["Tbl_TransportationMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_EXPENCESMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_ExpencesMaster");
doc = new RptExpencesMaster();
doc.Database.Tables["Tbl_ExpencesMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_ROWMATERIAL") == 0)
{
DataSet ds = bl_obj.blFill("SP_RowHedar");
doc = new RptRowMaterial();
doc.Database.Tables["Tbl_RowHedar"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_SUPPLIERMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_SupplierMaster");
doc = new RptSupplierMaster();
doc.Database.Tables["Tbl_SupplierMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_TRANSPORTATION_MASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_TransportationMaster");
doc = new RptTransportationMaster();
doc.Database.Tables["Tbl_TransportationMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_SUBEXPENCESMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_SubExpencesMaster");
doc = new RptSubExpencesMaster();
doc.Database.Tables["Tbl_SubExpencesMaster"].SetDataSource(ds.Tables[0]);
//doc.Database.Tables["Tbl_ExpencesMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_MEASUREMENTMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_MeasurementMaster");
doc = new RptMeasurmentMaster();
doc.Database.Tables["Tbl_Measurment"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
//--------*********>>>>>>>>>>>>>>>>> Binding a Report Transaction <<<<<<<<<<<<<<<*********--------
if (module_Rpt.rpt_name.CompareTo("RptSalesInvoice") == 0)
{
doc = new RptSalesInvoice();
doc.Database.Tables["Tbl_Sales_Invoice"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptPendingInvoice") == 0)
{
doc = new RptPendingInvoice();
doc.Database.Tables["Tbl_PendingInvoice"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptPendingInvoiceCustomerwise") == 0)
{
doc = new RptPendingInvoiceCustomerwise();
doc.Database.Tables["Tbl_PendingInvoiceCustomerwise"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptScrapwise") == 0)
{
doc = new RptScrapwise();
doc.Database.Tables["Tbl_Scrapwise"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptDayBook") == 0)
{
doc = new rptDayBookNew();
doc.Database.Tables["DayBookNew"].SetDataSource(dataSet1.Tables[0]);
//doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]);
//doc.ParameterFields.Add("OpeningBal");
//doc.SetParameterValue("OpeningBal",dataSet1.Tables[1].Rows[0][0].ToString());
//doc.SetParameterValue("Date", dataSet1.Tables[1].Rows[0][1].ToString());
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptCashBook") == 0)
{
DataSet ds = new DataSet();
paraname.Clear();
paravalue.Clear();
paraname.Add("@From_Date");
paraname.Add("@flag");
paravalue.Add(_fromdate.ToString("yyyy-MM-dd"));
paravalue.Add("OP");
ds = bl_obj.blFill_para_name(paraname, paravalue, "SP_Report");
doc = new rptCashBook();
doc.Database.Tables["CashBookNew"].SetDataSource(dataSet1.Tables[0]);
//doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]);
//doc.ParameterFields.Add("OpeningBal");
doc.SetParameterValue("OpeningBal", ds.Tables[0].Rows[0][0].ToString());
doc.SetParameterValue("Date", _fromdate);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptSales") == 0)
{
doc = new RptSales();
doc.Database.Tables["Tbl_Sales"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptPurchase") == 0)
{
doc = new RptPurchase();
doc.Database.Tables["Tbl_Purchase"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptGeneralLedger") == 0)
{
doc = new RptGeneralLedger();
doc.Database.Tables["Tbl_GeneralLedger"].SetDataSource(dataSet1.Tables[0]);
doc.SetParameterValue("OpeningBal", dataSet1.Tables[1].Rows[0][0].ToString());
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptTrialBalance") == 0)
{
doc = new RptTrialBalance();
doc.Database.Tables["Tbl_TrialBalance"].SetDataSource(dataSet1.Tables[0]);
//doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]);
//doc.ParameterFields.Add("OpeningBal");
doc.SetParameterValue("OpeningBal", dataSet1.Tables[1].Rows[0][0].ToString());
doc.SetParameterValue("Date", dataSet1.Tables[1].Rows[0][1].ToString());
doc.SetParameterValue("ToDate", dataSet1.Tables[1].Rows[0][2].ToString());
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptRoot") == 0)
{
doc = new RptRoot();
doc.Database.Tables["Tbl_Root"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptFinishedGoods") == 0)
{
doc = new rptFinishedGoods();
doc.Database.Tables["Tbl_FinishedGoods"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptRowMaterialStock") == 0)
{
doc = new rptRowMaterialStock();
doc.Database.Tables["Tbl_RowMaterialStock"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptProductionReport") == 0)
{
doc = new rptProductionReport();
doc.Database.Tables["Tbl_ProductionReport"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
//if (module_Rpt.rpt_name.CompareTo("RptTax") == 0)
//{
// doc = new RptTax();
// doc.Database.Tables["Tbl_Tax"].SetDataSource(dataSet1.Tables[0]);
// crystalReportViewer1.ReportSource = doc;
//}
if (module_Rpt.rpt_name.CompareTo("rptCustomerLedgerNew") == 0)
{
doc = new rptCustomerLedgerNew();
doc.Database.Tables["Tbl_Customer_Ledger_New"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptDateWiseAllCustTotal") == 0)
{
doc = new rptDateWiseAllCustTotal();
doc.Database.Tables["AllCustDateWiseTotal"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
//if (module_Rpt.rpt_name.CompareTo("RptDateWiseAllCustomer") == 0)
//{
// doc = new RptDateWiseAllCustomer();
// doc.Database.Tables["AllCustDateWiseTotal"].SetDataSource(dataSet1.Tables[0]);
// crystalReportViewer1.ReportSource = doc;
//}
if (module_Rpt.rpt_name.CompareTo("rptDebitCreditTransaction") == 0)
{
doc = new rptDebitCreditTransaction();
doc.Database.Tables["Tbl_DebitCreditTransaction"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptGSTTax") == 0)
{
doc = new RptGSTTax();
doc.Database.Tables["Tbl_Tax"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RPTGSTR") == 0)
{
doc = new RPTGSTR();
doc.Database.Tables["Tbl_GSTR"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
else
{
}
}
void SetZoom(object sender, EventArgs e)
{
report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass);
CodeHelper.UI.MessageDialog<NumericUpDown> mesDialog = new MessageDialog<NumericUpDown>("Масштаб", "Масштаб (25-400%):", "");
mesDialog[0].Minimum = 25;
mesDialog[0].Maximum = 400;
switch (mesDialog.ShowDialog())
{
case DialogResult.OK:
Zoom((int)mesDialog[0].Value);
break;
default: break;
}
}
/// <summary>
/// Select report from the list.
/// </summary>
public static CrystalDecisions.CrystalReports.Engine.ReportClass SelectReport(int subModuleId)
{
CrystalDecisions.CrystalReports.Engine.ReportClass currentReport = new CrystalDecisions.CrystalReports.Engine.ReportClass();
switch (subModuleId)
{
#region ECB report
case 10: //ECB_DetailReport
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_DetailReport();
break;
}
case 11: //ECB_CallDetailReport report
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_CallDetailReport();
break;
}
case 30: //ECB Audit Edtail report
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_AuditDetail();
break;
}
case 31: //ECB_VendalDetail
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_VendalDetail();
break;
}
#endregion
#region MET report
case 13: //Consolidate revenue report
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.MET_Hourly_Data_Report();
break;
}
case 15: //Consolidate revenue report
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.MET_Daily_Data_Report();
break;
}
#endregion
#region ATCC report
case 25:
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_DetailReport();
break;
}
case 26:
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_TransactionDetailReport();
break;
}
case 27:
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_MonthlyTrafficCount();
break;
}
case 28:
{
currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_HourlyTrafficCount();
break;
}
#endregion
#region vMS
#endregion
#region CCTV
#endregion
default:
break;
}
return(currentReport);
}
public Imprimir(CrystalDecisions.CrystalReports.Engine.ReportClass r)
{
InitializeComponent();
this.crystalReportViewer1.ReportSource = r;
}
void goToPageButton_MouseDown(object sender, MouseEventArgs e)
{
report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass);
CodeHelper.UI.MessageDialog<NumericUpDown> mesDialog = new MessageDialog<NumericUpDown>("Переход на страницу", "Перейти на сраницу №:", "");
mesDialog[0].Minimum = 1;
switch (mesDialog.ShowDialog())
{
case DialogResult.OK:
ShowNthPage((int)mesDialog[0].Value);
break;
default: break;
}
}
public bool Export(CrystalDecisions.CrystalReports.Engine.ReportClass report, string path, TypeBC type)
{
if (report == null)
{
return(false);
}
switch (type)
{
case TypeBC.WordForWindows:
{
int index = path.LastIndexOf('.');
if (index > 0)
{
if (path.Substring(index + 1).ToLower().Equals("doc"))
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path);
}
else if (index == path.Length - 1)
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path + "doc");
}
else
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path + ".doc");
}
}
else
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path + ".doc");
}
break;
}
case TypeBC.Excel:
{
int index = path.LastIndexOf('.');
if (index > 0)
{
if (path.Substring(index + 1).ToLower().Equals("xls"))
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path);
}
else if (index == path.Length - 1)
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path + "xls");
}
else
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path + ".xls");
}
}
else
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path + ".xls");
}
break;
}
case TypeBC.PortableDocFormat:
{
int index = path.LastIndexOf('.');
if (index > 0)
{
if (path.Substring(index + 1).ToLower().Equals("pdf"))
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path);
}
else if (index == path.Length - 1)
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path + "pdf");
}
else
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path + ".pdf");
}
}
else
{
report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path + ".pdf");
}
break;
}
}
return(true);
}
