protected void btnpdf_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("ListadoArticulos1.rpt");
myReportDocument.Load(strRuta);
DataTable dt = objListado.ListarTodos();
myReportDocument.SetDataSource(dt);
myReportDocument.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "Listado");
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
reportDocument.Load(_crystalReportFilePath);
reportDocument.SetDataSource(_reportSourceTable); // C:\VisualStudio2008_SVN\MyPlayground\MyPlayground\FieldLabel1.rpt
crystalReportViewer1.ReportSource = reportDocument;
}
protected void btnImpression_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpth = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpth.Load(Server.MapPath("~/Report/rptPersonne.rpt"));
rpth.SetDataSource(GetTablePersonne());
rpth.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, "Liste Personne");
}
private void Fprint_Load(object sender, EventArgs e)
{
fMenu xf = new fMenu();
this.Left = xf.Left + 167;
this.Top = xf.Top + 75;
this.Width = Screen.PrimaryScreen.Bounds.Width - xf.panel1.Width - 160;
this.Height = Screen.PrimaryScreen.Bounds.Height - xf.Top - 170;
reportDocument1.FileName = Program.lAppPath + "\\pr.rpt";
tbl = reportDocument1.Database.Tables["Tmp"];
list = reportDocument1;
sql = " select * from Tmp ";
tb = Program.ExecSelect(sql);
if (tb.Rows.Count == 0)
{
MessageBox.Show("没有符合该条件的记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
crystalReportViewer1.Visible = false;
}
else
{
tbl.SetDataSource(tb);
list.Refresh();
crystalReportViewer1.Visible = true;
}
errinf = Program.SqlCmd("delete from Tmp");
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
reportDocument.Load(_crystalReportFilePath);
reportDocument.SetDataSource(_reportSourceTable); // C:\VisualStudio2008_SVN\MyPlayground\MyPlayground\FieldLabel1.rpt
crystalReportViewer1.ReportSource = reportDocument;
}
public ActionResult ExportData_IU(ApplicationHeaderInfo pInfo, App_Detail_PLD01_HDCN_Info pDetail,
List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo)
{
try
{
string language = AppsCommon.GetCurrentLang();
// Fill export_header
string fileName_docx = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_VI_" + TradeMarkAppCode.AppCode_TM_4C2_PLD_01_HDCN + ".docx");
AppsCommon.Prepare_Data_Export_D01(ref pDetail, pInfo, pAppDocumentInfo, pFeeFixInfo);
List <App_Detail_PLD01_HDCN_Info> _lst = new List <App_Detail_PLD01_HDCN_Info>();
_lst.Add(pDetail);
DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_PLD01_HDCN_Info>(_lst, false);
_ds_all.Tables[0].TableName = "Table_4c2";
CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string _tempfile = "TM_PLD01_HDCN.rpt";
string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm");
string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_VN_" + _datetimenow + ".pdf");
if (language == Language.LangVI)
{
fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_VN_" + _datetimenow + ".pdf");
SessionData.CurrentUser.FilePreview = "/Content/Export/" + "D01_VN_" + _datetimenow + ".pdf";
}
else
{
_tempfile = "TM_PLD01_HDCN_EN.rpt"; // tiếng anh
fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_EN_" + _datetimenow + ".pdf");
SessionData.CurrentUser.FilePreview = "/Content/Export/" + "D01_EN_" + _datetimenow + ".pdf";
}
oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile));
//oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), "TM_PLD01_HDCN.rpt"));
if (_ds_all != null)
{
oRpt.SetDataSource(_ds_all);
}
oRpt.Refresh();
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
System.IO.Stream oStream = oRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq
return(Json(new { success = 0 }));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { success = 0 }));
}
}
public void ReportConvert(CrystalDecisions.CrystalReports.Engine.ReportDocument argObjectReport, string[] argDatafiles)
{
try
{
int icnt = 0;
{
BsfGlobal.GetDBString();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
string ardata;
ardata = Convert.ToString(argDatafiles[0]);
ConInfo.ConnectionInfo.UserID = BsfGlobal.g_sUserId;
ConInfo.ConnectionInfo.Password = "******";
ConInfo.ConnectionInfo.ServerName = BsfGlobal.g_sServerName;
for (; icnt <= argObjectReport.Database.Tables.Count - 1; icnt++)
{
ConInfo.ConnectionInfo.DatabaseName = argDatafiles[icnt];
argObjectReport.Database.Tables[icnt].ApplyLogOnInfo(ConInfo);
}
}
}
catch
{
//Interaction.MsgBox("Error: " + Except.Message);
}
}
private void LoadCrptListToComboBox(string sFileName)
{
try
{
Assembly asm = Assembly.LoadFrom(sFileName);
cboASM.Items.Clear();
foreach (Type type in asm.GetTypes())
{
//if (typeof(type) == typeof(CrystalDecisions.CrystalReports.Engine.ReportDocument))
// cboASM.Items.Add(type.Name, type.FullName);
try
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt =
(CrystalDecisions.CrystalReports.Engine.ReportDocument)Activator.CreateInstance(type);
cboASM.Items.Add(type.Name, type.FullName);
}
catch (Exception)
{
}
}
}
catch (Exception)
{
}
}
private void ImprimirListadoDeProveedores()
{
try
{
ProveedorEN oRegistroEN = new ProveedorEN();
ProveedorLN oRegistroLN = new ProveedorLN();
oRegistroEN = (ProveedorEN)this.Entidad;
if (oRegistroLN.ListadoParaReportes(oRegistroEN, Program.oDatosDeConexion))
{
RPT = new rptListadoDeProveedores();
AgregarTablaEmpresaADataSet();
RPT.SetDataSource(AgregarTablaADataSet(oRegistroLN.TraerDatos(), "ListadoProveedores"));
LlenarParametros(new string[, ] {
{ "NombreDelSistema", Program.NombreVersionSistema }, { "TituloDelReporte", oRegistroEN.TituloDelReporte }, { "SubTituloDeReporte", oRegistroEN.SubTituloDelReporte }, { "AplicarBorde", this.AplicarBorder.ToString() }
});
this.Text = "Listado de Reportes";
crvVista.ReportSource = RPT;
}
else
{
this.Cursor = Cursors.Default;
MessageBox.Show(oRegistroLN.Error, "Listado de Reportes", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
oRegistroLN = null;
this.Entidad = null;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void btnImprimmer_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpth = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpth.Load(Server.MapPath("~/Report/rptAgence.rpt"));
rpth.SetDataSource(GetTableAgence());
rpth.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, String.Format("Liste_Agence_{0}", DateTime.Now));
}
private void btnImprimir_Click(object sender, EventArgs e)
{
try
{
ser = AdmSerie.MuestraSerie(factur.CodSerie, frmLogin.iCodAlmacen);
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rd.Load("CRNotaDebito.rpt");
CRNotaDebito rpt = new CRNotaDebito();
rd.SetDataSource(ds.ReportNotaDebitoCompra(Convert.ToInt32(CodNotaS), frmLogin.iCodAlmacen));
CrystalDecisions.CrystalReports.Engine.PrintOptions rptoption = rd.PrintOptions;
rptoption.PrinterName = ser.NombreImpresora;
rptoption.PaperSize = (CrystalDecisions.Shared.PaperSize)ext.GetIDPaperSize(ser.NombreImpresora, ser.PaperSize);
rptoption.ApplyPageMargins(new CrystalDecisions.Shared.PageMargins(1100, 1850, 200, 1300));
//CrystalDecisions.Shared.PageMargins margenes = rd.PrintOptions.PageMargins;
rd.PrintToPrinter(1, false, 1, 1);
rd.Close();
rd.Dispose();
//CRNotaDebito rpt = new CRNotaDebito();
//frmRptNotaCredito frm = new frmRptNotaCredito();
//CrystalDecisions.CrystalReports.Engine.PrintOptions rptoption = rpt.PrintOptions;
//rptoption.PrinterName = ser.NombreImpresora;//Convert.ToString(System.Drawing.Printing.PrinterSettings.InstalledPrinters[3]);
//rptoption.PaperSize = (CrystalDecisions.Shared.PaperSize)ext.GetIDPaperSize(ser.NombreImpresora, ser.PaperSize);
//rpt.SetDataSource(ds.ReportNotaDebitoCompra(Convert.ToInt32(CodNotaS), frmLogin.iCodAlmacen).Tables[0]);
//frm.crvNotaCredito.ReportSource = rpt;
//frm.Show();
}
catch (Exception ex)
{
MessageBox.Show("Se encontro el siguiente problema " + ex.Message, "Nota de Credito", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected void PotrosnjaKalkulacije_KalkulacijeSelected(string ids)
{
DataTable potrosnja = _kalkulacijaBL.GetPotrosnja(ids);
Reports.reportDataSet rds = new Reports.reportDataSet();
DataRow newRow;
foreach (DataRow row in potrosnja.Rows)
{
newRow = rds.Tables["KalkulacijePotrosnja"].NewRow();
newRow["KalkulacijaID"] = row["kalkulacija_id"];
newRow["KalkulacijaNaziv"] = row["kalkulacija_naziv"];
newRow["SmesaNaziv"] = row["smesa_naziv"];
newRow["Dnevno"] = row["dnevno"];
newRow["Mesecno"] = row["mesecno"];
newRow["Godisnje"] = row["godisnje"];
rds.Tables["KalkulacijePotrosnja"].Rows.Add(newRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rd.Load("Reports/KalkulacijePotrosnja.rpt");
rd.SetDataSource(rds);
frmPrint objfrmPrint = new frmPrint();
objfrmPrint.crystalReportViewer1.ReportSource = rd;
objfrmPrint.Show();
}
private void btnViewReport_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = Connection.GetDataSet("SELECT tbl_session.sessioncode, tbl_session.sessionname, tbl_student.studentno, tbl_student.scholarno,'Mr/Miss. '+ tbl_student.name as name , 'Mr. '+ tbl_student.father as father, " +
" 'Mrs. '+ tbl_student.mother as mother, tbl_student.dob, tbl_student.C_address, tbl_student.m_tongue, tbl_student.casttype, tbl_student.bloodgroup,tbl_student.Height,tbl_student.Width,tbl_student.VisionL,tbl_student.VisionR,tbl_student.Teeth ,tbl_student.OHygiene,tbl_student.House,CASE WHEN tbl_student.CGPA IS NULL or tbl_student.CGPA='' THEN '..........' ELSE tbl_student.CGPA END as CGPA,CASE WHEN tbl_student.OGrade IS NULL or tbl_student.OGrade='' THEN '..........' ELSE tbl_student.OGrade END as OGrade, tbl_classstudent.stdtype,tbl_student.studentimage, " +
" tbl_student.marr_status AS Gender, tbl_student.studentphoto, tbl_student.phone, tbl_student.bldgroup AS Medium, tbl_tehsil.tehsil, tbl_district.district, " +
" tbl_district.statename, tbl_classmaster.classname, tbl_section.sectionname, tbl_classmaster.classname +' '+tbl_section.sectionname AS Class, " +
" tbl_sankay.sankayname AS Stream, ISNULL(tbl_StudentAttendance.Lectures, 0) AS [Total Lecture], ISNULL(tbl_StudentAttendance.PresentDays, 0) AS [Total Present], ISNULL(tbl_StudentAttendance.Per , 0) AS [Per] " +
" FROM tbl_section INNER JOIN " +
" tbl_sankay INNER JOIN " +
" tbl_classstudent ON tbl_sankay.sankaycode = tbl_classstudent.Stream INNER JOIN " +
" tbl_classmaster ON tbl_classstudent.classno = tbl_classmaster.classcode INNER JOIN " +
" tbl_student ON tbl_classstudent.studentno = tbl_student.studentno INNER JOIN " +
" tbl_session ON tbl_classstudent.sessioncode = tbl_session.sessioncode ON tbl_section.sectioncode = tbl_classstudent.Section INNER JOIN " +
" tbl_tehsil ON tbl_student.tehcode = tbl_tehsil.tehcode INNER JOIN " +
" tbl_district ON tbl_student.distcode = tbl_district.distcode Left join tbl_StudentAttendance on tbl_student .studentno = tbl_StudentAttendance .StudentNo " +
" WHERE (tbl_section.sectioncode = '" + cmbScetion.SelectedValue + "') AND (tbl_classstudent.ClassNo ='" + cmbClass.SelectedValue + "') " +
" AND (tbl_session.sessioncode = '" + cmbSession.SelectedValue + "') and tbl_classstudent.stdtype<>'Ex-Student' Order By tbl_student.name ;" +
" SELECT schoolname,schooladdress,schoolcity,schoolphone,affiliate_by,principal,registrationno,logoimage FROM tbl_school ");
ds.WriteXmlSchema(@"" + Connection.GetAccessPathId() + @"Barcodes\a\rptCBSEMarksFrontDetail.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument s = null;
rptCCEReportFormat3 s3 = new rptCCEReportFormat3();
s3.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
s3.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA3;
ShowAllReports cr = new ShowAllReports();
if (cmbClass.Text.Trim().Equals("IX") || cmbClass.Text.Trim().Equals("X"))
{
s = new rptCCEMarkFrontEnd();
s.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
s.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLegal;
s.SetDataSource(ds);
cr.crystalReportViewer1.ReportSource = s;
}
else if (cmbClass.Text.Trim().Equals("I") || cmbClass.Text.Trim().Equals("II") || cmbClass.Text.Trim().Equals("III") || cmbClass.Text.Trim().Equals("IV") ||
cmbClass.Text.Trim().Equals("V") || cmbClass.Text.Trim().Equals("VI") || cmbClass.Text.Trim().Equals("VII") || cmbClass.Text.Trim().Equals("VIII"))
{
s = new rptCCEReportFormat2();
s.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
s.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA3;
s.SetDataSource(ds);
s.SetParameterValue("Class", Connection.GetNextClass(cmbClass.Text.Trim()));
cr.crystalReportViewer1.ReportSource = s;
}
else
{
s3.SetDataSource(ds);
s3.SetParameterValue("Class", Connection.GetNextClass(cmbClass.Text.Trim()));
cr.crystalReportViewer1.ReportSource = s3;
}
cr.crystalReportViewer1.Zoom(54);
cr.Show();
}
private void printaFactura(string nomdocumento)
{
try
{
Herramientas herramientas = new Herramientas();
var informe = herramientas.GetResourcesPath3();
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rd.Load(informe + "\\" + nomdocumento + ".pdf");
CrystalDecisions.CrystalReports.Engine.PrintOptions rptoption = rd.PrintOptions;
rptoption.PrinterName = "\\\\192.168.1.35\\EPSON LX-350 ESC/P";
rptoption.PaperSize = (CrystalDecisions.Shared.PaperSize)GetIDPaperSize("\\\\192.168.1.35\\EPSON LX-350 ESC/P", "A4");//(CrystalDecisions.Shared.PaperSize)ext.GetIDPaperSize(Convert.ToString(System.Drawing.Printing.PrinterSettings.InstalledPrinters[3]), "documentoFioviza");
rd.PrintToPrinter(1, false, 1, 1);
rd.Close();
rd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Se encontro el siguiente problema" + ex.Message, "Venta", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected void Kalkulacije_KalkulacijeSelected(string ids)
{
DataTable potrosnja = _sirovinaBL.GetPotrosnjaUPeriodu(ids);
Reports.reportDataSet rds = new Reports.reportDataSet();
DataRow newRow = rds.Tables["PotrosnjaKabastihSirovinaUPeriodu"].NewRow();
foreach (DataRow row in potrosnja.Rows)
{
newRow = rds.Tables["PotrosnjaKabastihSirovinaUPeriodu"].NewRow();
newRow["NazivKalkulacije"] = row["kalkulacija_naziv"];
newRow["NazivSirovine"] = row["sirovina_naziv"];
newRow["Kolicina"] = row["kolicina"];
newRow["MesecnaPotrosnja"] = row["mesecno"];
newRow["GodisnjaPotrosnja"] = row["godisnje"];
rds.Tables["PotrosnjaKabastihSirovinaUPeriodu"].Rows.Add(newRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
if (_reportID == 1)
{
rd.Load("Reports/PotrosnjaKabastihSirovinaUPeriodu.rpt");
}
else if (_reportID == 2)
{
rd.Load("Reports/PotrosnjaKabastihSirovina.rpt");
}
rd.SetDataSource(rds);
frmPrint objfrmPrint = new frmPrint();
objfrmPrint.crystalReportViewer1.ReportSource = rd;
objfrmPrint.Show();
}
private void mnuUserRegister_Click(object sender, EventArgs e)
{
try
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptUserRegister.rpt"))
{
//dtblUser.TableName = "UserRegister";
//dtblUser.WriteXmlSchema(@"D:\Project_Info\Report\UserRegister.xsd");
DataView DVReport;
DVReport = dtblUser.DefaultView;
DVReport.RowFilter = StrFilter;
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptUserRegister.rpt");
CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "User Register", true, true, true, true, false, true, true, false, false, false, true);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "User Register - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("User - Register", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
public ActionResult Descargar()
{
if (Request.Cookies[cookie_name] != null)
{
if (funcion.valid_cookie(Request.Cookies[cookie_name].Value))
{
CrystalDecisions.CrystalReports.Engine.ReportDocument reporte = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
reporte.Load(Server.MapPath("~/Reports/Reporte.rpt"));
reporte.SetDatabaseLogon("admin", "123456", "SINDECIDIR-PC", "sistemaV2");
reporte.Refresh();
try
{
Stream stream = reporte.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "Sistema_Reporte.pdf"));
}
catch
{
throw;
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public void Login(CrystalDecisions.CrystalReports.Engine.ReportDocument report)
{
string serverName = ConfigurationManager.AppSettings["ServerName"];
string databasename = ConfigurationManager.AppSettings["DbName"];
string userId = ConfigurationManager.AppSettings["UserID"];
string passWord = ConfigurationManager.AppSettings["Password"];
//Set Database Logon to main report
foreach (CrystalDecisions.Shared.IConnectionInfo connection in report.DataSourceConnections)
{
if (connection.ServerName == serverName)
{
connection.SetLogon(userId, passWord);
}
}
//Set Database Logon to subreport
foreach (CrystalDecisions.CrystalReports.Engine.ReportDocument subreport in report.Subreports)
{
foreach (CrystalDecisions.Shared.IConnectionInfo connection in subreport.DataSourceConnections)
{
if (connection.ServerName == serverName)
{
connection.SetLogon(userId, passWord);
}
}
}
}
private void FormMARKETING_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1)
{
txtCARI.Focus();
}
else if (e.KeyCode == Keys.F2)
{
ADD();
}
else if (e.KeyCode == Keys.F3)
{
EDIT();
}
else if (e.KeyCode == Keys.F4)
{
DELETE();
}
else if (e.KeyCode == Keys.F5)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORT.FormViewerMARKETING frm = new REPORT.FormViewerMARKETING(dataPrint);
frm.ShowDialog();
}
else if (e.KeyCode == Keys.Escape)
{
Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
rptCtrl = new ReporteController();
homeCtrl = new HomeController();
vehiculoCtrl = new VehiculoController();
Documento = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
personaCtrl = new PersonaController();
seguimientoCtrl = new SeguimientoController();
if (!IsPostBack)
{
//if (!SitePrincipal.IsIntruso())
//{
init();
cargarVehiculo();
CargarFechas();
FristParametres();
CargarParameters();
//btnBuscar.Attributes["onclick"] = "javascript:gfProceso()";
//this.btnExportar.Attributes.Add("OnClick", "javascript:return fnAceptar();");
//RegistrarScript();
//}
//else
//{
// Response.Redirect("~/Account/Login");
//}
}
//Menu1.Items[0].Selected = true;
}
protected void btnReporte_Click(object sender, EventArgs e)
{
PedidoDAO objPedidoDAO = new PedidoDAO();
ParametroDAO objParametroDAO = new ParametroDAO();
ParametroDTO objParametroDTO = objParametroDAO.ListarPorClave(1);
dsReportes dsReporte = new dsReportes();
List<PedidoDTO> Lista = objPedidoDAO.ListarReporte(AppUtilidad.stringToDateTime(this.txtFechaInicial.Text, "DD/MM/YYYY"),
AppUtilidad.stringToDateTime(this.txtFechaFinal.Text, "DD/MM/YYYY"),
Convert.ToInt32(this.ddlSede.SelectedValue),
Convert.ToInt32(this.ddlProyecto.SelectedValue));
this.lblMensaje.Text = "";
if (Lista.Count > 0)
{
dsReportes.ParametroRow drParametroRow = dsReporte.Parametro.NewParametroRow();
drParametroRow.id_reporte = 1;
drParametroRow.titulo1 = "REPORTE DE SOLICITUDES DE PEDIDOS DE COMPRA";
drParametroRow.titulo2 = "Desde " + this.txtFechaInicial.Text + " al " + this.txtFechaFinal.Text;
drParametroRow.empresa = objParametroDTO.RazonSocial;
dsReporte.Parametro.AddParametroRow(drParametroRow);
foreach (PedidoDTO reg in Lista)
{
dsReportes.PedidoRow drPedidoRow = dsReporte.Pedido.NewPedidoRow();
drPedidoRow.id_reporte = 1;
drPedidoRow.id_pedido = reg.IdPedido;
drPedidoRow.fecha = reg.FechaPedido.ToString("dd/MM/yyyy");
drPedidoRow.descripcion = reg.Descripcion;
drPedidoRow.sede = reg.NombreSede;
drPedidoRow.proyecto = reg.NombreProyecto;
drPedidoRow.estado_aprobacion = reg.NombreEstado;
drPedidoRow.estado_control = reg.NombreEstadoControl;
drPedidoRow.solicitante = reg.NombreSolicitante;
drPedidoRow.orden_compra = reg.OrdenCompra;
drPedidoRow.tipo_pedido = reg.NombreTipoPedido;
dsReporte.Pedido.AddPedidoRow(drPedidoRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("rptPedido.rpt");
myReportDocument.Load(strRuta);
myReportDocument.SetDataSource(dsReporte);
Session.Add("ReporteCrystal", myReportDocument);
Session.Add("FormatoReporte", "PDF");
string strRutaWeb = Request.ApplicationPath;
Response.Write("<script language='javascript'>window.open('ReportePedido.aspx" + "','ventana','scrollbars=1,resizable=1,width=800,height=600,left=20,top=0');</script>");
}
else
{
this.lblMensaje.Text = "Noy registros con los parametros indicados";
}
}
protected void TroskoviKalkulacije_KalkulacijeSelected(string ids)
{
DataTable troskovi = _kalkulacijaBL.GetTroskovi(ids);
Reports.reportDataSet rds = new Reports.reportDataSet();
DataRow newRow;
foreach (DataRow row in troskovi.Rows)
{
newRow = rds.Tables["KalkulacijeTroskovi"].NewRow();
newRow["KalkulacijaID"] = row["kalkulacija_id"];
newRow["KalkulacijaNaziv"] = row["kalkulacija_naziv"];
newRow["SmesaNaziv"] = row["smesa_naziv"];
newRow["SirovinaNaziv"] = row["sirovina_naziv"];
newRow["Kolicina"] = row["kolicina"];
newRow["JmID"] = row["jm_id"];
newRow["JmNaziv"] = row["jm_naziv"];
newRow["SirovinaCena"] = row["sirovina_cena"];
newRow["Ukupno"] = row["ukupno"];
rds.Tables["KalkulacijeTroskovi"].Rows.Add(newRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rd.Load("Reports/KalkulacijeTroskovi.rpt");
rd.SetDataSource(rds);
frmPrint objfrmPrint = new frmPrint();
objfrmPrint.crystalReportViewer1.ReportSource = rd;
objfrmPrint.Show();
}
private void PrintPreView()
{
var cmd = contxt.Database.Connection.CreateCommand();
//System.Data.Common.DataAdapter da = new System.Data.Common.DataAdapter();
string spName = "";
//var DataReport;
if (partner.id == 0)
{
spName = "PartnerLedger " + dtMonth.Value.Month + ", -1";
//DataReport = contxt.Database.SqlQuery(spName,dtMonth.Value.Month, -1).ToList()
}
else
{
spName = "PartnerLedger " + dtMonth.Value.Month + ", " + contxt.SupplierMasters.FirstOrDefault(o => o.AddressBookId == partner.id);
}
cmd.CommandText = spName;
//cmd.ExecuteReader();
contxt.Database.Connection.Open();
report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(ReportName);
report.SetDataSource((IDataReader)cmd.ExecuteReader());
report.SetParameterValue("MonthName", String.Format("{0:MMM-yyyy}", dtMonth.Value));
crv.ParameterFieldInfo = new CrystalDecisions.Shared.ParameterFields();
foreach (CrystalDecisions.Shared.ParameterField fld in report.ParameterFields)
{
crv.ParameterFieldInfo.Add(fld);
}
crv.ReportSource = report;
}
private void btnPrint_Click(object sender, EventArgs e)
{
Reports.reportDataSet rds = new Reports.reportDataSet();
DataRow newRow = rds.Tables["Kalkulacija"].NewRow();
newRow["NazivSmese"] = _smesaNaziv;
newRow["UkupnoKabaste"] = lblTotalKabaste1.Text;
newRow["UkupnoKupovne"] = lblTotalKupovne1.Text;
newRow["UkupnoAmk"] = lblTotalAmk1.Text;
newRow["Ukupno"] = lblTotal1.Text;
newRow["NazivKalkulacije"] = _kalkulacijaNaziv;
rds.Tables["Kalkulacija"].Rows.Add(newRow);
foreach (DataRow row in _sirovinaCenaDT[0].Rows)
{
newRow = rds.Tables["KalkulacijaSirovina"].NewRow();
newRow["naziv"] = row["Naziv"];
newRow["kolicina"] = row["KolicinaKorigovano"].ToString() != string.Empty ? row["KolicinaKorigovano"] : row["Kolicina"];
newRow["cena"] = row["Cena"];
newRow["ukupno"] = row["Ukupno"];
newRow["jmNaziv"] = row["Jm"];
newRow["tipSirovineCode"] = int.Parse(row["TipSirovineID"].ToString()) == 1 ? "Kabaste" : "Kupovne";
newRow["udeo"] = decimal.Parse(row["Ukupno"].ToString()) / decimal.Parse(lblTotal1.Text) * 100;
rds.Tables["KalkulacijaSirovina"].Rows.Add(newRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rd.Load("Reports/KalkulacijaTroskovi.rpt");
rd.SetDataSource(rds);
frmPrint objfrmPrint = new frmPrint();
objfrmPrint.crystalReportViewer1.ReportSource = rd;
objfrmPrint.Show();
}
public void ShowReport(CrystalDecisions.Windows.Forms.CrystalReportViewer obj, string sql, string repname)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument objReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
try
{
objReport.Load(repname);
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objReport.Database.Tables)
{
ConInfo = tbCurrent.LogOnInfo;
ConInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["ReportProvider"];
ConInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
ConInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
ConInfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["Database Name"];
tbCurrent.ApplyLogOnInfo(ConInfo);
}
DataSet objds = Select(sql);
objReport.SetDataSource(objds.Tables[0]);
obj.ReportSource = objReport;
}
catch
{
//return null;
}
finally
{
}
}
private void PRO007RViewRC_Load(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument drPrint = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
DataRow oRow = dtPrint.Rows[0];
String sFile = ConfigurationManager.AppSettings["pathpdfRecibos"] + "RC-" + oRow["DOCV_Serie"] + "-" + oRow["DOCV_Numero"] + ".pdf";
try
{
drPrint.FileName = System.IO.Directory.GetCurrentDirectory() + "\\Reportes\\" + RptFile;
drPrint.SetDataSource(dtPrint);
for (int p = 0; p <= aParams.Count - 1; p++)
{
drPrint.SetParameterValue(p, aParams[p]);
}
if (!File.Exists(sFile))
{
drPrint.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, sFile);
SendMessage(sFile, oRow);
}
CrystalReportViewer.ReportSource = drPrint;
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ReportConvert(CrystalDecisions.CrystalReports.Engine.ReportDocument argObjectReport, string[] argDatafiles)
{
try
{
int icnt = 0;
{
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
string ardata = Convert.ToString(argDatafiles[0]);
ConInfo.ConnectionInfo.UserID = BsfGlobal.g_sUserId;
ConInfo.ConnectionInfo.Password = BsfGlobal.g_sPassWord;
ConInfo.ConnectionInfo.ServerName = BsfGlobal.g_sServerName;
for (; icnt <= argObjectReport.Database.Tables.Count - 1; icnt++)
{
if (icnt < argDatafiles.Length)
{
ConInfo.ConnectionInfo.DatabaseName = argDatafiles[icnt];
}
argObjectReport.Database.Tables[icnt].ApplyLogOnInfo(ConInfo);
}
}
}
catch (Exception ex)
{
//Interaction.MsgBox("Error: " + Except.Message);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void frmDoctorUsingMedicineReport_Load(object sender, System.EventArgs e)
{
this.strAppPatch = Application.StartupPath + "\\";
((clsCtl_DoctorUsingMedicineReport)this.objController).m_mthLoadDepartment();
objReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
objReportDocument.Load(this.strAppPatch + "Report\\cptDoctorUsingMedicineReport.rpt");
}
private void GenerarCodigoBarras(string code)
{
if (code != null)
{
Reportes.Code39 c39 = new Reportes.Code39();
MemoryStream ms = new MemoryStream();
c39.FontFamilyName = "Free 3 of 9";
c39.FontFileName = Server.MapPath("FREE3OF9.TTF");
c39.FontSize = 30;
c39.ShowCodeString = true;
System.Drawing.Bitmap objBitmap = c39.GenerateBarcode(code);
objBitmap.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
codigobarrasRpt = facturaRpt.OpenSubreport("CodigoBarra.rpt");
CrearTabla();
DataRow dr = this.dsImages.Tables["images"].NewRow();
dr["path"] = "ninguno";
dr["image"] = ms.ToArray();
this.dsImages.Tables["images"].Rows.Add(dr);
codigobarrasRpt.SetDataSource(this.dsImages);
}
}
public static void PrintReportA8(string IDBienNhan, string reportPath, string PrinterName, string CamThem, string ThayGiayCho)
{
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.GiaoDich GD = camdochieuduongEntity.GiaoDiches.Find(IDBienNhan);
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc =
new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(reportPath);
rptDoc.SetParameterValue("P_IDBienNhan", GD.IDBienNhan);
rptDoc.SetParameterValue("P_ThayGiayCho", ThayGiayCho);
rptDoc.SetParameterValue("P_KhachHang", "Tên: " + GD.KhachHang);
rptDoc.SetParameterValue("P_DienThoai", "SĐT: " + GD.DienThoai);
rptDoc.SetParameterValue("P_TienCam", "Tiền Cầm: " + String.Format("{0:n0}", GD.TienCam) + " Đ");
rptDoc.SetParameterValue("P_CamThem", CamThem);
var MoTa = "Mô Tả: " + GD.MoTa;
if (GD.TruHotCon != "")
{
MoTa = MoTa + "(Còn: " + GD.TruHotCon + ")";
}
rptDoc.SetParameterValue("P_MoTa", MoTa);
rptDoc.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
//PaperSize xCustomSize = new PaperSize("Custom", 6, 8);
//xCustomSize.PaperName = PaperKind.Custom;
//PrintDocument.DefaultPageSettings.PaperSize = xCustomSize;
//rptDoc.PrintOptions.PaperSize = ;
rptDoc.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
rptDoc.PrintOptions.PrinterName = PrinterName;
rptDoc.PrintToPrinter(1, false, 1, 1);
}
public void ViewReport(CrystalDecisions.Windows.Forms.CrystalReportViewer CrViewer, string Reportname, string rsSelectionformula, string paraname1, string paraname2, string paraname3, string paraname4, string paraname5, string paraname6, string paraname7, string paravalue1, string paravalue2, string paravalue3, string paravalue4, string paravalue5, string paravalue6, string paravalue7, int SendToPrinter, Form frm)
{
rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string REPORTSPATH = Application.StartupPath + ConfigurationManager.AppSettings["ShareFolder"];
rpt.Load((REPORTSPATH + ("\\" + Reportname)));
rpt.SetParameterValue(paraname1, paravalue1);
rpt.SetParameterValue(paraname2, paravalue2);
rpt.SetParameterValue(paraname3, paravalue3);
rpt.SetParameterValue(paraname4, paravalue4);
rpt.SetParameterValue(paraname5, paravalue5);
rpt.SetParameterValue(paraname6, paravalue6);
rpt.SetParameterValue(paraname7, paravalue7);
// CrystalDecisions.CrystalReports.Engine.Table tdCurr;
foreach (CrystalDecisions.CrystalReports.Engine.Table tdCurr in rpt.Database.Tables)
{
rptTLInfo = new CrystalDecisions.Shared.TableLogOnInfo();
rptTLInfo = tdCurr.LogOnInfo;
// With...
//SERVERNAME.Password = "******";
//dataBaseName.ServerName = "SA";
rptTLInfo.ConnectionInfo.DatabaseName = "IMS";
tdCurr.ApplyLogOnInfo(rptTLInfo);
}
rpt.SetDatabaseLogon("", "", ".", "IMS");
rpt.SummaryInfo.ReportAuthor = RptAuthor;
if ((rsSelectionformula != ""))
{
rpt.RecordSelectionFormula = rsSelectionformula;
}
if ((SendToPrinter == 1))
{
try
{
rpt.PrintToPrinter(1, true, 1, 1);
}
catch (Exception ex)
{
// MsgBox(ex.Message);
}
}
else
{
//if (((Para1 == null)
// == false)) {
// CrViewer.ParameterFieldInfo = parameters;
//}
CrViewer.ReportSource = rpt;
CrViewer.Refresh();
if ((frm.Tag != "ALL BILL REPORT"))
{
// frm.Show();
// SHOW_PLEASE_WAIT(false);
}
}
}
public void GetReport()
{
try
{
string sReportHeading = "";
string sAmtInWords = "";
string sReportcomment = "";
string sReportInFile = "";
string strSQL = "";
sReportHeading = "";
if (SessionUserData.AppInfo.TempStrVariable_1 == "IGST")
{
sReportInFile = "GST_I_Invoice.rpt";
}
else
{
sReportInFile = "GST_SU_Invoice.rpt";
}
strSQL = " AAA_M_USP_Print_Invoice " + SessionUserData.Company.CompanyID +
"," + SessionUserData.Company.BranchID +
"," + SessionUserData.Company.YearID +
"," + SessionUserData.AppInfo.TempIntVariable_1;
DataTable myDS = new DataTable();
myDS = MaheshAF18.Application.MEF.DA_GetDataTable(strSQL);
if (File.Exists(Server.MapPath(myDS.Rows[0]["BL_Logo_Url"].ToString())))
{
FileStream stream = new FileStream(Server.MapPath(myDS.Rows[0]["BL_Logo_Url"].ToString()), FileMode.Open, FileAccess.Read);
byte[] ImgData = new byte[stream.Length];
stream.Read(ImgData, 0, Convert.ToInt32(stream.Length));
stream.Close();
myDS.Rows[0]["BL_Logo_Img"] = ImgData;
}
decimal vatTotalAmt = Convert.ToDecimal(0 + myDS.Rows[0]["SINV_HDR_Total_Gross_Amt"].ToString());
sAmtInWords = MaheshAF18.Utility.NoToWord.AmtInWord_INR(vatTotalAmt);
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument = default(CrystalDecisions.CrystalReports.Engine.ReportDocument);
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(Server.MapPath("..\\Rpt\\") + sReportInFile + "");
myReportDocument.Database.Tables[0].SetDataSource(myDS);
//myReportDocument.SetParameterValue("pRepHeading", sReportHeading);
myReportDocument.SetParameterValue("AmtInWords ", sAmtInWords);
myReportDocument.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "Invoice");
//Session["reportDataSource"] = myReportDocument;
//CrystalReportViewer1.DisplayGroupTree = false;
//CrystalReportViewer1.ReportSource = myReportDocument;
//CrystalReportViewer1.DataBind();
}
catch (Exception ex)
{
DisplayCustomMessageSummary(ex.Message);
}
}
protected void Page_Init(object sender, System.EventArgs e)
{
try
{
string sPath = HttpContext.Current.Request.MapPath("~/Report\\");
//表示一个报表，并且包含定义、格式化、加载、导出和打印该报表的属性和方法。
CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.ParameterDiscreteValue discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
CrystalDecisions.Shared.ParameterValues paraValues = new CrystalDecisions.Shared.ParameterValues();
//加载你事先做好的Crystal Report报表文件
Report.Load(sPath + Request.QueryString["ReportName"], CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy);
string sData = PublicApi.fnGetConStr("MNDT").Replace(";", ",");
// 設定報表內SQL Server資料庫的登入資訊
CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table table in Report.Database.Tables)
{
logonInfo = table.LogOnInfo;
var _with1 = logonInfo.ConnectionInfo;
_with1.ServerName = fnGetData(sData, "Data Source");
_with1.DatabaseName = fnGetData(sData, "Initial Catalog");
_with1.UserID = fnGetData(sData, "User ID");
_with1.Password = fnGetData(sData, "Password");
table.ApplyLogOnInfo(logonInfo);
}
Report.SetDataSource(Session["PrintDT"]);
//Session["PrintDT"] = null;
if (Report.ParameterFields["列印人員"] != null)
{
Report.SetParameterValue("列印人員", Session["sId"]);
}
if (Report.ParameterFields["進貨稅額"] != null)
{
string sSql =
" SELECT [parameter] " +
" FROM [mndtkind_details] " +
" WHERE [kind_id] = 'TAX' " +
" AND [code_id] = 'IN' ";
Report.SetParameterValue("進貨稅額", PublicApi.fnGetValue(sSql, "MNDT"));
}
CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX; //列印顯示列印選項，但只有IE會出現這功能
//Report.PrintToPrinter(1, true, 0, 0); // 直接列印
CrystalReportViewer1.ReportSource = Report;
//CrystalReportViewer1.HasExportButton = false; //將匯出的功能False掉
//CrystalReportViewer1.HasPrintButton = false;
//CrystalReportViewer1.HasToggleGroupTreeButton = false; //將樹狀結構的按鈕False掉
//CrystalReportViewer1.DisplayGroupTree = false; //將樹狀結構狀態False掉
}
catch (Exception e1)
{
//Functions.fnMessageBox(e1.ToString(), this);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath(@"~/Sample.rpt"));
report.SetParameterValue("start", bdpStart.SelectedDate.ToString("dd/MM/yyyy"));
report.SetParameterValue("End", bdpEnd.SelectedDate.ToString("dd/MM/yyyy"));
CrystalReportViewer1.ReportSource = report;
}
private void btnImprimir_Click(object sender, EventArgs e)
{
//MessageBox.Show("Error al generar el reporte", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Caja caja = new Caja((int)cbxCaja.SelectedValue);
string logo = string.Empty;
if (!caja.IsNull())
logo = Application.StartupPath + "\\Imagenes\\Logotipos\\" + caja.Sucursal.Datos.Logo;
caja = null;
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpt.Load("Reportes\\CorteCaja.rpt");
rpt.Subreports[0].SetDataSource((DataTable)dgvCheques.DataSource);
rpt.SetDataSource((DataTable)dgvTransacciones.DataSource);
rpt.SetParameterValue("Caja", cbxCaja.Text);
rpt.SetParameterValue("PesosR", tbxPesos.Value);
rpt.SetParameterValue("PesosS", tbxCantidad.Value);
rpt.SetParameterValue("DolaresR", tbxDolares.Value);
rpt.SetParameterValue("DolaresS", tbxCantidad2.Value);
rpt.SetParameterValue("PB1000",tbxPB1000.Text);
rpt.SetParameterValue("PB500", tbxPB500.Text);
rpt.SetParameterValue("PB200", tbxPB200.Text);
rpt.SetParameterValue("PB100", tbxPB100.Text);
rpt.SetParameterValue("PB50", tbxPB50.Text);
rpt.SetParameterValue("PB20", tbxPB20.Text);
rpt.SetParameterValue("PM100", tbxPM100.Text);
rpt.SetParameterValue("PM20", tbxPM20.Text);
rpt.SetParameterValue("PM10", tbxPM10.Text);
rpt.SetParameterValue("PM5", tbxPM5.Text);
rpt.SetParameterValue("PM2", tbxPM2.Text);
rpt.SetParameterValue("PM1", tbxPM1.Text);
rpt.SetParameterValue("PM50C", tbxPC50.Text);
rpt.SetParameterValue("PM20C", tbxPC20.Text);
rpt.SetParameterValue("PM10C", tbxPC10.Text);
rpt.SetParameterValue("PM5C", tbxPC5.Text);
rpt.SetParameterValue("DB100", tbxDB100.Text);
rpt.SetParameterValue("DB50", tbxDB50.Text);
rpt.SetParameterValue("DB20", tbxDB20.Text);
rpt.SetParameterValue("DB10", tbxDB10.Text);
rpt.SetParameterValue("DB5", tbxDB5.Text);
rpt.SetParameterValue("DB1", tbxDB1.Text);
rpt.SetParameterValue("DM1", tbxDM1.Text);
rpt.SetParameterValue("DM50", tbxDC50.Text);
rpt.SetParameterValue("DM25", tbxDC25.Text);
rpt.SetParameterValue("DM10", tbxDC10.Text);
rpt.SetParameterValue("DM5", tbxDC5.Text);
rpt.SetParameterValue("DM1C", tbxDC1.Text);
rpt.SetParameterValue("Logo", logo);
frmReporte frm = new frmReporte(rpt);
frm.ShowDialog();
rpt.Dispose();
rpt = null;
frm.Dispose();
frm = null;
}
protected void Page_Load(object sender, EventArgs e)
{
string strFormatoReporte = "PDF"; //PDF, XLS, DOC
if (Session["FormatoReporte"] != null) strFormatoReporte = Session["FormatoReporte"].ToString();
MemoryStream stream = new MemoryStream();
myReportDocument = (CrystalDecisions.CrystalReports.Engine.ReportDocument)Session["ReporteCrystal"];
switch (strFormatoReporte)
{
case "PDF":
stream = (MemoryStream)myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.ContentType = "application/pdf";
break;
case "XLS":
stream = (MemoryStream)myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
Response.ContentType = "application/vnd.ms-excel";
break;
case "DOC":
stream = (MemoryStream)myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.WordForWindows);
Response.ContentType = "application/doc";
break;
default:
stream = (MemoryStream)myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.ContentType = "application/pdf";
break;
}
myReportDocument.Close();
myReportDocument.Dispose();
//Escribir PDF
Response.Clear();
Response.Buffer = true;
//Response.ContentType = "application/pdf";
Response.BinaryWrite(stream.ToArray());
Response.End();
stream.Flush();
stream.Close();
stream.Dispose();
//Cerrar Ventana
//string lstScript = "<script language='JavaScript'>window.close(); </script>";
//this.ClientScript.RegisterStartupScript(this.GetType(), "s", lstScript);
}
private void BindReport(string reportName)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath(Constz.HomeFolder + "Reports/" + reportName + ".rpt");
rpt.Load(reportPath);
CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo();
logonInfo = rpt.Database.Tables[0].LogOnInfo;
logonInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["DB_SERVER"].ToString().Trim();
logonInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["DB_USER"].ToString().Trim();
logonInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["DB_PASSWORD"].ToString();
rpt.Database.Tables[0].ApplyLogOnInfo(logonInfo);
CrystalDecisions.Shared.ParameterValues curValue = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue paraValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
for (int i = 0; i < Request.QueryString.Count; ++i)
{
string field = Request["paramfield" + (i + 1).ToString()];
string value = Request["paramvalue" + (i + 1).ToString()];
if (field != null && value != null)
{
paraValue.Value = value;
curValue = rpt.ParameterFields[field].CurrentValues;
curValue.Add(paraValue);
rpt.ParameterFields[field].CurrentValues = curValue;
}
else
break;
}
//paraValue.Value = reportKey;
//curValue = rpt.ParameterFields["LOID"].CurrentValues;
//curValue.Add(paraValue);
//rpt.ParameterFields["LOID"].CurrentValues = curValue;
rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
if (Request["landscape"] != null)
{
if (Request["landscape"] == "1") rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
}
Page.Cache["rpt"] = rpt;
ctlReportViewer.ReportSource = Page.Cache["rpt"];
//ctlReportViewer.DataBind();
}
private void btnImprimir_Click(object sender, EventArgs e)
{
Caja caja = new Caja((int)cbxCaja.SelectedValue);
string logo = string.Empty;
if (!caja.IsNull())
logo = Application.StartupPath + "\\Imagenes\\Logotipos\\" + caja.Sucursal.Datos.Logo;
caja = null;
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpt.Load("Reportes\\Inventarios.rpt");
rpt.SetDataSource(((DataView)dgvTransacciones.DataSource).Table);
rpt.SetParameterValue("Sucursal", cbxSucursal.Text);
rpt.SetParameterValue("Caja", cbxCaja.Text);
rpt.SetParameterValue("Usuario", cbxUsuarios.Text);
rpt.SetParameterValue("Tipo", cbxTipos.Text);
rpt.SetParameterValue("FechaIni", dtpFechaIni.Text);
rpt.SetParameterValue("FechaFin", dtpFechaFin.Text);
rpt.SetParameterValue("Logo", logo);
frmReporte frm = new frmReporte(rpt);
frm.ShowDialog();
rpt.Dispose();
rpt = null;
frm.Dispose();
frm = null;
}
protected void btnDepachar_Click(object sender, EventArgs e)
{
try
{
GuiaRemisionDTO objGuiaRemisionDTO = new GuiaRemisionDTO();
DespachoDTO objDespachoDTO = new DespachoDTO();
UsuarioDTO objUsuarioDTO = objUsuarioDAO.ListarPorLogin(HttpContext.Current.User.Identity.Name);
objDespachoDTO = objDespachoDAO.ListarPorClave(Convert.ToInt32(this.txtIdDespacho.Text));
if (this.lblIdGuiaRemision.Text == "")
{
//---------------------------------------------
objGuiaRemisionDTO.IdPuntoPartida = Convert.ToInt32(this.ddlPuntoPartida.SelectedValue);
objGuiaRemisionDTO.IdPuntoLlegada = Convert.ToInt32(this.ddlPuntoLlegada.SelectedValue);
objGuiaRemisionDTO.FechaEmision = AppUtilidad.stringToDateTime(this.txtFechaEmision.Text, "DD/MM/YYYY");
objGuiaRemisionDTO.FechaInicioTraslado = AppUtilidad.stringToDateTime(this.txtFechaTraslado.Text, "DD/MM/YYYY");
objGuiaRemisionDTO.RazonSocialDestinatario = this.txtDestinatario.Text;
objGuiaRemisionDTO.RucDestinatario = this.txtRucDestinatario.Text;
objGuiaRemisionDTO.RazonSocialTransportista = this.txtTransportista.Text;
objGuiaRemisionDTO.RucTransportista = this.txtRucTransportista.Text;
objGuiaRemisionDTO.Marca = this.txtMarca.Text;
objGuiaRemisionDTO.Placa = this.txtPlaca.Text;
objGuiaRemisionDTO.Certificado = this.txtCetificado.Text;
objGuiaRemisionDTO.Licencia = this.txtLicencia.Text;
objGuiaRemisionDTO.NumeroComprobantePago = this.txtComprobante.Text;
objGuiaRemisionDTO.Serie = this.txtSerie.Text.PadRight(3, '0');
objGuiaRemisionDTO.Numero = this.txtNumero.Text.PadLeft(6, '0');
objGuiaRemisionDTO.IdUsuarioCreacion = objUsuarioDTO.IdUsuario;
objGuiaRemisionDTO.FechaCreacion = DateTime.Now;
int IdGuiaRemision = objGuiaRemisionDAO.Agregar(objGuiaRemisionDTO);
this.lblIdGuiaRemision.Text = IdGuiaRemision.ToString();
//---------------------------------------------
objDespachoDTO.IdGuiaRemision = IdGuiaRemision;
objDespachoDTO.IdUsuarioModificacion = objUsuarioDTO.IdUsuario;
objDespachoDTO.FechaCreacion = DateTime.Now;
objDespachoDAO.Actualizar(objDespachoDTO);
//---------------------------------------------
objGuiaRemisionDTO = objGuiaRemisionDAO.ListarPorClave(IdGuiaRemision);
SedeDTO objSedeDTO1 = objSedeDAO.ListarPorClave(objGuiaRemisionDTO.IdPuntoPartida);
SedeDTO objSedeDTO2 = objSedeDAO.ListarPorClave(objGuiaRemisionDTO.IdPuntoLlegada);
dsReportes dsReporte = new dsReportes();
dsReportes.GuiaRemisionRow drFilaGuiaRemision = dsReporte.GuiaRemision.NewGuiaRemisionRow();
drFilaGuiaRemision.id_guia_remision = IdGuiaRemision;
drFilaGuiaRemision.punto_partida = objSedeDTO1.Direccion;
drFilaGuiaRemision.punto_llegada = objSedeDTO2.Direccion;
drFilaGuiaRemision.fecha_emision = objGuiaRemisionDTO.FechaEmision.ToString("dd/MM/yyyy");
drFilaGuiaRemision.fecha_inicio_traslado = objGuiaRemisionDTO.FechaInicioTraslado.ToString("dd/MM/yyyy");
drFilaGuiaRemision.destinatario = objGuiaRemisionDTO.RazonSocialDestinatario;
drFilaGuiaRemision.ruc_destinatario = objGuiaRemisionDTO.RucDestinatario;
drFilaGuiaRemision.transportista = objGuiaRemisionDTO.RazonSocialTransportista;
drFilaGuiaRemision.ruc_transportista = objGuiaRemisionDTO.RazonSocialTransportista;
drFilaGuiaRemision.marca = objGuiaRemisionDTO.Marca;
drFilaGuiaRemision.placa = objGuiaRemisionDTO.Placa;
drFilaGuiaRemision.certificado = objGuiaRemisionDTO.Certificado;
drFilaGuiaRemision.licencia = objGuiaRemisionDTO.Licencia;
drFilaGuiaRemision.comprobante = objGuiaRemisionDTO.NumeroComprobantePago;
drFilaGuiaRemision.numero = objGuiaRemisionDTO.Serie + "-" + objGuiaRemisionDTO.Numero;
dsReporte.GuiaRemision.AddGuiaRemisionRow(drFilaGuiaRemision);
List<DespachoLineaDTO> ListaDespachoLinea = objDespachoLineaDAO.ListarPorDespacho(Convert.ToInt32(this.txtIdDespacho.Text));
foreach (DespachoLineaDTO item in ListaDespachoLinea)
{
ArticuloDTO objArticuloDTO = objArticuloDAO.ListarPorClave(item.IdArticulo);
dsReportes.GuiaRemisionDetalleRow drFilaGuiaRemisionDetalle = dsReporte.GuiaRemisionDetalle.NewGuiaRemisionDetalleRow();
drFilaGuiaRemisionDetalle.id_guia_remision = IdGuiaRemision;
drFilaGuiaRemisionDetalle.item = item.NumeroLinea;
drFilaGuiaRemisionDetalle.cantidad = item.CantidadDespacho; // Convert.ToDecimal("12.33");
drFilaGuiaRemisionDetalle.codigo = objArticuloDTO.CodigoArticulo;
drFilaGuiaRemisionDetalle.descripcion = objArticuloDTO.Descripcion;
drFilaGuiaRemisionDetalle.precio = item.PrecioUnitario; // Convert.ToDecimal("2004.23000");
dsReporte.GuiaRemisionDetalle.AddGuiaRemisionDetalleRow(drFilaGuiaRemisionDetalle);
}
//---------------------------------------------
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("rptGuiaRemision.rpt");
myReportDocument.Load(strRuta);
myReportDocument.SetDataSource(dsReporte);
Session.Add("ReporteCrystal", myReportDocument);
Session.Add("FormatoReporte", "PDF");
string strRutaWeb = Request.ApplicationPath;
Response.Write("<script language='javascript'>window.open('frmVisorReporte.aspx" + "','ventana','scrollbars=1,resizable=1,width=800,height=600,left=20,top=0');</script>");
}
else
{
objGuiaRemisionDTO = objGuiaRemisionDAO.ListarPorClave(Convert.ToInt32(this.lblIdGuiaRemision.Text));
objGuiaRemisionDTO.IdPuntoPartida = Convert.ToInt32(this.ddlPuntoPartida.SelectedValue);
objGuiaRemisionDTO.IdPuntoLlegada = Convert.ToInt32(this.ddlPuntoLlegada.SelectedValue);
objGuiaRemisionDTO.FechaEmision = AppUtilidad.stringToDateTime(this.txtFechaEmision.Text, "DD/MM/YYYY");
objGuiaRemisionDTO.FechaInicioTraslado = AppUtilidad.stringToDateTime(this.txtFechaTraslado.Text, "DD/MM/YYYY");
objGuiaRemisionDTO.RazonSocialDestinatario = this.txtDestinatario.Text;
objGuiaRemisionDTO.RucDestinatario = this.txtRucDestinatario.Text;
objGuiaRemisionDTO.RazonSocialTransportista = this.txtTransportista.Text;
objGuiaRemisionDTO.RucTransportista = this.txtRucTransportista.Text;
objGuiaRemisionDTO.Marca = this.txtMarca.Text;
objGuiaRemisionDTO.Placa = this.txtPlaca.Text;
objGuiaRemisionDTO.Certificado = this.txtCetificado.Text;
objGuiaRemisionDTO.Licencia = this.txtLicencia.Text;
objGuiaRemisionDTO.NumeroComprobantePago = this.txtComprobante.Text;
objGuiaRemisionDTO.Serie = this.txtSerie.Text.PadRight(3, '0');
objGuiaRemisionDTO.Numero = this.txtNumero.Text.PadLeft(6, '0');
objGuiaRemisionDTO.IdUsuarioModificacion = objUsuarioDTO.IdUsuario;
objGuiaRemisionDTO.FechaModificacion = DateTime.Now;
objGuiaRemisionDAO.Actualizar(objGuiaRemisionDTO);
//--------------------------------
SedeDTO objSedeDTO1 = objSedeDAO.ListarPorClave(objGuiaRemisionDTO.IdPuntoPartida);
SedeDTO objSedeDTO2 = objSedeDAO.ListarPorClave(objGuiaRemisionDTO.IdPuntoLlegada);
dsReportes dsReporte = new dsReportes();
dsReportes.GuiaRemisionRow drFilaGuiaRemision = dsReporte.GuiaRemision.NewGuiaRemisionRow();
drFilaGuiaRemision.id_guia_remision = Convert.ToInt32(this.lblIdGuiaRemision.Text);
drFilaGuiaRemision.punto_partida = objSedeDTO1.Direccion;
drFilaGuiaRemision.punto_llegada = objSedeDTO2.Direccion;
drFilaGuiaRemision.fecha_emision = objGuiaRemisionDTO.FechaEmision.ToString("dd/MM/yyyy");
drFilaGuiaRemision.fecha_inicio_traslado = objGuiaRemisionDTO.FechaInicioTraslado.ToString("dd/MM/yyyy");
drFilaGuiaRemision.destinatario = objGuiaRemisionDTO.RazonSocialDestinatario;
drFilaGuiaRemision.ruc_destinatario = objGuiaRemisionDTO.RucDestinatario;
drFilaGuiaRemision.transportista = objGuiaRemisionDTO.RazonSocialTransportista;
drFilaGuiaRemision.ruc_transportista = objGuiaRemisionDTO.RazonSocialTransportista;
drFilaGuiaRemision.marca = objGuiaRemisionDTO.Marca;
drFilaGuiaRemision.placa = objGuiaRemisionDTO.Placa;
drFilaGuiaRemision.certificado = objGuiaRemisionDTO.Certificado;
drFilaGuiaRemision.licencia = objGuiaRemisionDTO.Licencia;
drFilaGuiaRemision.comprobante = objGuiaRemisionDTO.NumeroComprobantePago;
drFilaGuiaRemision.numero = objGuiaRemisionDTO.Serie + "-" + objGuiaRemisionDTO.Numero;
dsReporte.GuiaRemision.AddGuiaRemisionRow(drFilaGuiaRemision);
List<DespachoLineaDTO> ListaDespachoLinea = objDespachoLineaDAO.ListarPorDespacho(Convert.ToInt32(this.txtIdDespacho.Text));
foreach (DespachoLineaDTO item in ListaDespachoLinea)
{
ArticuloDTO objArticuloDTO = objArticuloDAO.ListarPorClave(item.IdArticulo);
dsReportes.GuiaRemisionDetalleRow drFilaGuiaRemisionDetalle = dsReporte.GuiaRemisionDetalle.NewGuiaRemisionDetalleRow();
drFilaGuiaRemisionDetalle.id_guia_remision = Convert.ToInt32(this.lblIdGuiaRemision.Text);
drFilaGuiaRemisionDetalle.item = item.NumeroLinea;
drFilaGuiaRemisionDetalle.cantidad = item.CantidadDespacho; // Convert.ToDecimal("12.33");
drFilaGuiaRemisionDetalle.codigo = objArticuloDTO.CodigoArticulo;
drFilaGuiaRemisionDetalle.descripcion = objArticuloDTO.Descripcion;
drFilaGuiaRemisionDetalle.precio = item.PrecioUnitario; // Convert.ToDecimal("2004.23000");
dsReporte.GuiaRemisionDetalle.AddGuiaRemisionDetalleRow(drFilaGuiaRemisionDetalle);
}
//---------------------------------------------
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("rptGuiaRemision.rpt");
myReportDocument.Load(strRuta);
myReportDocument.SetDataSource(dsReporte);
Session.Add("ReporteCrystal", myReportDocument);
Session.Add("FormatoReporte", "PDF");
string strRutaWeb = Request.ApplicationPath;
Response.Write("<script language='javascript'>window.open('frmVisorReporte.aspx" + "','ventana','scrollbars=1,resizable=1,width=800,height=600,left=20,top=0');</script>");
}
}
catch (Exception ex)
{
this.lblMensaje.Text = ex.ToString();
}
}
static string _scanPath; //Repertoire de recherche
#endregion Fields
#region Methods
static void Main(string[] args)
{
try
{
#region validation
//Parametre sur la ligne de commande est obligatoire
if (args.Length < 2)
{
throw new ArgumentException(Resource1.ERR_ARG);
}
if (!Directory.Exists(args[0]))
{
throw new System.IO.DirectoryNotFoundException(Resource1.ERR_NO_SOURCE_PATH);
}
if (!Directory.Exists(args[1]))
{
throw new System.IO.DirectoryNotFoundException(Resource1.ERR_NO_DEST_PATH);
}
#endregion
_scanPath = args[0];
_ouputReportFile = args[1] + ((args[1].EndsWith("\\")) ? "" : "\\") + "report.csv";
//Filtre pour les fichier rpt dans le répertoire et les sous-répertoires
string[] filePaths = Directory.GetFiles(_scanPath, "*.rpt", SearchOption.AllDirectories);
// Delete the file if it exists.
if (File.Exists(_ouputReportFile))
{
File.Delete(_ouputReportFile);
}
//Creation du fichier de rapport
using (TextWriter tw = new StreamWriter(_ouputReportFile))
{
tw.WriteLine("Create on : " + DateTime.Now);
tw.WriteLine("FileName;Version");
using (CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument())
{
//pour chaque fichier trouvé on lit la version du rapport et on l'inscrit dans le fichier
foreach (string file in filePaths)
{
//CrystalDecisions.Shared.ExportOptions t;
//t.ExportFormatType = (CrystalDecisions.Shared.ExportFormatType)34;
rpt.Load(file);
int majVer = rpt.ReportClientDocument.MajorVersion;
int minVer = rpt.ReportClientDocument.MinorVersion;
tw.WriteLine(file + ';' + majVer + '.' + minVer); //inscription au fichier
rpt.Close();
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("");
Console.WriteLine("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!");
Console.WriteLine("ERREUR : " + ex.Message);
Console.WriteLine("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!");
Console.WriteLine("");
}
}
protected void InicializaPagina()
{
int IdOrdenCompra;
string id = Request.QueryString["id"].ToString();
IdOrdenCompra = Convert.ToInt32(id);
OrdenCompraDTO objOrdenCompraDTO = objOrdenCompraDAO.ListarPorClave(IdOrdenCompra);
ProveedorDTO objProveedorDTO = objProveedorDAO.ListarPorClave(objOrdenCompraDTO.IdProveedor);
List<OrdenCompraLineaDTO> objOrdenCompraLinea = objOrdenCompraLineaDAO.Listar(IdOrdenCompra);
ParametroDTO objParametroDTO = objParametroDAO.ListarPorClave(1);
FormaPagoDTO objFormaPagoDTO = objFormaPagoDAO.ListarPorClave(objOrdenCompraDTO.IdFormaPago);
MonedaDTO objMonedaDTO = objMonedaDAO.ListarPorClave(objOrdenCompraDTO.CodMoneda);
CotizacionDTO objCotizacionDTO = objCotizacionDAO.ListarPorClave(objOrdenCompraDTO.IdCotizacion);
PedidoDTO objPedidoDTO = objPedidoDAO.ListarPorClave(objCotizacionDTO.IdPedido);
UsuarioDTO objUsuarioDTO = objUsuarioDAO.ListarPorClave(objPedidoDTO.IdSolicitante);
List<PedidoPresupuestoDTO> ListaPedidoPresupuestoDTO = objPedidoPresupuestoDAO.Listar(objPedidoDTO.IdPedido);
dsReportes dsReporte = new dsReportes();
dsReportes.ParametroRow drParametroRow = dsReporte.Parametro.NewParametroRow();
drParametroRow.id_reporte = 1;
drParametroRow.empresa = objParametroDTO.RazonSocial;
if (objOrdenCompraDTO.IdTipoOrdenCompra == 1)
drParametroRow.titulo1 = "ORDEN DE COMPRA N° " + objOrdenCompraDTO.IdOrdenCompra.ToString();
else
if (objOrdenCompraDTO.IdTipoOrdenCompra == 2)
drParametroRow.titulo1 = "ORDEN DE SERVICIO N° " + objOrdenCompraDTO.IdOrdenCompra.ToString();
else
drParametroRow.titulo1 = "ORDEN N° " + objOrdenCompraDTO.IdOrdenCompra.ToString();
dsReporte.Parametro.AddParametroRow(drParametroRow);
//MONTO DE IGV
IgvDTO objIGVDTO = objIGVDAO.ListarIGVVigente(objOrdenCompraDTO.FechaOrdenCompra);
dsReportes.OrdenCompraRow drOrdenCompraRow = dsReporte.OrdenCompra.NewOrdenCompraRow();
drOrdenCompraRow.IdReporte = 1;
drOrdenCompraRow.IdOrdenCompra = objOrdenCompraDTO.IdOrdenCompra;
if (objProveedorDTO != null)
{
drOrdenCompraRow.RazonSocial = objProveedorDTO.RazonSocial;
drOrdenCompraRow.Ruc = objProveedorDTO.Ruc;
drOrdenCompraRow.Direccion = objProveedorDTO.Direccion;
drOrdenCompraRow.Contacto = objProveedorDTO.Contacto;
}
drOrdenCompraRow.Fecha = objOrdenCompraDTO.FechaOrdenCompra.ToString("dd/MM/yyyy");
drOrdenCompraRow.Cotizacion = "Estimación N° " + objOrdenCompraDTO.IdCotizacion.ToString();
if (objMonedaDTO!=null)
drOrdenCompraRow.Moneda = objMonedaDTO.Simbolo;
drOrdenCompraRow.Subtotal = objOrdenCompraDTO.ImporteOrdenCompra;
if (objOrdenCompraDTO.FechaEntrega.Year!=1)
drOrdenCompraRow.FechaEntrega = objOrdenCompraDTO.FechaEntrega.ToString("dd/MM/yyyy");
if (objFormaPagoDTO!=null)
drOrdenCompraRow.FormaPago = objFormaPagoDTO.NombreFormaPago;
if (objParametroDTO != null)
{
drOrdenCompraRow.FacturarNombre = objParametroDTO.RazonSocial;
drOrdenCompraRow.FacturarRuc = objParametroDTO.Ruc;
drOrdenCompraRow.Direccion = objParametroDTO.Direccion;
}
drOrdenCompraRow.Proyecto = objOrdenCompraDTO.NombreProyecto;
string codigos = "";
if (ListaPedidoPresupuestoDTO.Count > 0)
{
foreach (PedidoPresupuestoDTO item in ListaPedidoPresupuestoDTO)
{
codigos = codigos + " " + item.CodigoPresupuesto;
}
}
drOrdenCompraRow.Descripcion = "Solicitado por " + objUsuarioDTO.NombreUsuario + " - Código: " + codigos;
if (objOrdenCompraDTO.FlagIGV == "1")
{
drOrdenCompraRow.IGV = drOrdenCompraRow.Subtotal * (objIGVDTO.Igv / 100);
drOrdenCompraRow.Total = drOrdenCompraRow.Subtotal + drOrdenCompraRow.IGV;
drOrdenCompraRow.PorcentajeIGV = objIGVDTO.Igv.ToString() + "%";
}
else
{
drOrdenCompraRow.IGV = 0;
drOrdenCompraRow.Total = drOrdenCompraRow.Subtotal + drOrdenCompraRow.IGV;
drOrdenCompraRow.PorcentajeIGV = "0%";
}
/*
if (objOrdenCompraDTO.IdTipoOrdenCompra == 2)
{
drOrdenCompraRow.IGV = 0;
drOrdenCompraRow.Total = drOrdenCompraRow.Subtotal + drOrdenCompraRow.IGV;
drOrdenCompraRow.PorcentajeIGV = "0%";
}
else
{
drOrdenCompraRow.IGV = drOrdenCompraRow.Subtotal * (objIGVDTO.Igv / 100);
drOrdenCompraRow.Total = drOrdenCompraRow.Subtotal + drOrdenCompraRow.IGV;
drOrdenCompraRow.PorcentajeIGV = objIGVDTO.Igv.ToString() + "%";
}
*/
drOrdenCompraRow.TotalLetras = "SON: " + AppUtilidad.numberToText(drOrdenCompraRow.Total.ToString()) + " " + objMonedaDTO.NombreMoneda;
dsReporte.OrdenCompra.AddOrdenCompraRow(drOrdenCompraRow);
foreach (OrdenCompraLineaDTO linea in objOrdenCompraLinea)
{
InvUnidadMedidaDTO objInvUnidadMedidaDTO = objInvUnidadMedidaDAO.ListarPorClave(linea.IdUnidadMedida);
dsReportes.OrdenCompraLineasRow drOrdenCompraLineasRow = dsReporte.OrdenCompraLineas.NewOrdenCompraLineasRow();
drOrdenCompraLineasRow.IdReporte = 1;
drOrdenCompraLineasRow.IdOrdenCompra = objOrdenCompraDTO.IdOrdenCompra;
drOrdenCompraLineasRow.Linea = linea.NumeroLinea;
drOrdenCompraLineasRow.Cantidad = linea.Cantidad;
if (objInvUnidadMedidaDTO != null)
drOrdenCompraLineasRow.UnidadMedida = objInvUnidadMedidaDTO.NombreCorto;
drOrdenCompraLineasRow.DescripcionLinea = linea.DescripcionLinea;
drOrdenCompraLineasRow.PrecioUnitario = linea.Precio;
drOrdenCompraLineasRow.Importe = linea.Importe;
dsReporte.OrdenCompraLineas.AddOrdenCompraLineasRow(drOrdenCompraLineasRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("rptOrdenCompra.rpt");
myReportDocument.Load(strRuta);
myReportDocument.SetDataSource(dsReporte);
Session.Add("ReporteCrystal", myReportDocument);
Session.Add("FormatoReporte", "PDF");
MemoryStream stream = new MemoryStream();
stream = (MemoryStream)myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.ContentType = "application/pdf";
myReportDocument.Close();
myReportDocument.Dispose();
Response.Clear();
Response.Buffer = true;
Response.BinaryWrite(stream.ToArray());
Response.End();
stream.Flush();
stream.Close();
stream.Dispose();
}
/// <summary>
///
/// </summary>
/// <param name="PickNo">揀貨單號</param>
/// <param name="s_FileName">Excel報表的檔名</param>
/// <param name="s_rptFilePath">rpt檔的路徑</param>
/// <param name="reportFormatType">檔案型態</param>
/// <param name="ReportOrderOption">排序類型 "item":品項 "locate":儲位 </param>
private void LoadCrystalReport(string PickNo, string s_FileName, string s_rptFilePath, string reportFormatType, string ReportOrderOption)
{
try
{
IVMModel.MaintainPickData BCO = new IVMModel.MaintainPickData(ConntionDB);
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath(s_rptFilePath));
ParameterList.Clear();
ParameterList.Add(PickNo);
if (s_rptFilePath != "./REPORT/IVM15/CRIVM15R03.rpt")
{
DataTable dtResult = new DataTable();
string ProgName = "";
if (s_rptFilePath == "./REPORT/IVM15/CRIVM15R01.rpt")
{
dtResult = BCO.GetPrintRpt01(ParameterList);
ProgName = "IVM15R01";
}
else
{
dtResult = BCO.GetPrintRpt02(ParameterList);
ProgName = "IVM15R02";
}
DataView dv = new DataView(dtResult);
switch (ReportOrderOption)
{
case "item":
dv.Sort = "item";
break;
case "locate":
dv.Sort = "BLocate_No";
break;
default:
dv.Sort = "item";
break;
}
report.SetDataSource(dv.ToTable());
report.SetParameterValue("paraProg", ProgName);
report.SetParameterValue("paraUserID", Session["UID"].ToString());
report.SetParameterValue("paraPickNo", PickNo);
report.SetParameterValue("paraSource", this.MenuIVM15.SelectedItem.Text);
report.SetParameterValue("paraAccDate", "");
report.SetParameterValue("paraReturnNo", "");
report.SetParameterValue("paraRemoveNo", "");
report.SetParameterValue("paraBLocate", "");
report.SetParameterValue("paraELocate", "");
report.SetParameterValue("paraVendor", "");
}
else
{
DataTable dtResult = new DataTable();
dtResult = BCO.GetPrintRpt03(ParameterList);
report.SetDataSource(dtResult);
report.SetParameterValue("paraProg", "IVM15R03");
report.SetParameterValue("paraUserID", Session["UID"].ToString());
//report.SetParameterValue("paraKind", "");
}
switch (reportFormatType)
{
case "EXCEL":
System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytesXLS = new byte[streamXLS.Length];
streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
streamXLS.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel";
Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length);
Response.Flush();
Response.Close();
break;
case "PDF":
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
break;
default:
break;
}
report.Close();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
// show報表
private void ShowReport(DataSet ds)
{
try
{
string strFileName = "";
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath("./REPORT/MKT05/CRMKT05R01.rpt"));
strFileName = HttpUtility.UrlEncode("採購卡.PDF", System.Text.Encoding.UTF8);
report.SetDataSource(ds);
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + strFileName);//pdf檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
UpdatePanel_ErrMsg.Update();
}
}
private void btnBARCODE_Click(object sender, EventArgs e)
{
BarcodeLib.Barcode barcode = new BarcodeLib.Barcode();
Image image = barcode.Encode(BarcodeLib.TYPE.CODE128, "0380003562162", Color.Black, Color.White, 300, 150);
showBarcode.BackgroundImage = barcode.Encode(BarcodeLib.TYPE.CODE128, "0380003562162", Color.Black, Color.White, 300, 50);
byte[] test = barcode.Encoded_Image_Stream;
//string test = barcode.EncodedValue;
dataPrint.Rows.Add(c.NORESI, txtSFROM.Text, txtSTO.Text, txtWEIGHT.Text, txtPCS.Text,
c.NAMACUSTOMER, txtALAMATPENGIRIM.Text, txtPHONEPENGIRIM.Text, txtPENERIMA.Text, txtALAMAT.Text,
txtPHONEPENERIMA.Text, lblLAYANAN.Text, txtRATEKIRIM.Text, lblJENISKIRIMAN.Text,
txtCHARGEINSURANCE.Text, txtCHARGEPPN.Text, txtGRANDTOTAL.Text, txtKETERANGANISI.Text, txtINSTRUKSIKHUSUS.Text, txtPDIM.Text, txtLDIM.Text, txtTDIM.Text, txtHPPENGIRIM.Text, txtCHARGEPACKING.Text, test, barcode.EncodedValue, alamatPerusahaan, telpPerusahaan, faxPerusahaan, c.TGLTERIMA, c.TGLESTIMASI);
TopMost = false;
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.EXPRESS.FormRESIEXPRESS frm = new REPORTS.EXPRESS.FormRESIEXPRESS(dataPrint);
frm.WindowState = FormWindowState.Normal;
frm.BringToFront();
frm.ShowDialog();
}
//Crystal Report 直接輸出 PDF 檔
private void ExportReport(DataTable dt, ReportType RType)
{
string strFileName = string.Empty;
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath("./REPORT/PUR052R01.rpt"));
report.SetDataSource(dt);
//CrystalReport Parameter 參數設定
string Program_ID = string.Empty;
string LoginUser = string.Empty;
string LoginName = string.Empty;
string YearMonth = string.Empty;
Program_ID = this.PageCode + "R01";
LoginUser = Session["UID"].ToString();
LoginName = Get_LoginName();
report.SetParameterValue("par_Program_ID", Program_ID);
report.SetParameterValue("par_LoginUser", LoginUser);
report.SetParameterValue("par_LoginName", LoginName);
strFileName = "在途單";
report.SetParameterValue("par_1", txtONWAY_NO.Text);
report.SetParameterValue("par_2", txtONWAY_DATE.Text);
report.SetParameterValue("par_3", SLP_VendorBase1.TextBox_Code.Text + " " + SLP_VendorBase1.TextBox_Name.Text);
//檔案匯出
if (RType == ReportType.PDF)
{
ExportPDF(strFileName, report);
}
else
{
ExportExcel(strFileName, report);
}
}
private void btnImprimir_Click(object sender, EventArgs e)
{
Caja caja = new Caja(Globales.IdCaja);
string logo=string.Empty;
if (!caja.IsNull())
logo = Application.StartupPath + "\\Imagenes\\Logotipos\\" + caja.Sucursal.Datos.Logo;
caja = null;
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpt.Load("Reportes\\Historial.rpt");
rpt.SetDataSource((DataTable)this.dgvPrestamos.DataSource);
rpt.SetParameterValue("NoPrestamo", cbxPrestamo.SelectedValue.ToString());
rpt.SetParameterValue("Cliente", cbxCliente.Text);
rpt.SetParameterValue("Capital", tbxCapital.Value);
rpt.SetParameterValue("PagoMinimo", tbxPago.Value);
rpt.SetParameterValue("FechaCorte", dtpFecha.Value);
rpt.SetParameterValue("Estatus", cbxEstatus.Text);
rpt.SetParameterValue("Logo", logo);
frmReporte frm = new frmReporte(rpt);
frm.ShowDialog();
rpt.Dispose();
rpt = null;
frm.Dispose();
frm = null;
}
protected void Page_Init(object sender, EventArgs e)
{
try
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/Iva_Ventas.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "Iva_Ventas.xsd", true);
oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
bool HayME = false;
string reportPath = "";
if (Session["monedasExtranjeras"] != null)
{
HayME = (bool)Session["monedasExtranjeras"];
}
if (!HayME)
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaVentasCR.rpt");
}
else
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaVentasMECR.rpt");
}
oRpt.Load(reportPath);
Entidades.IvaVentas ivaVentas = new Entidades.IvaVentas();
if (Session["ivaVentas"] != null)
{
ivaVentas = (Entidades.IvaVentas)Session["ivaVentas"];
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(ivaVentas.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, ivaVentas);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
oRpt.SetDataSource(ds);
}
else
{
Response.Redirect("~/Facturacion/Electronica/Reportes/IvaVentasFiltros.aspx", true);
}
string formatoRptExportar = "";
if (Session["formatoRptExportar"] != null)
{
formatoRptExportar = (string)Session["formatoRptExportar"];
}
if (Session["mostrarFechaYHora"] != null)
{
if ((bool)Session["mostrarFechaYHora"] == false)
{
oRpt.DataDefinition.FormulaFields["MostrarFechaYHora"].Text = "'N'";
}
}
oRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
oRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
oRpt.DataDefinition.FormulaFields["RazSoc"].Text = "'" + ((Entidades.Sesion)Session["Sesion"]).Cuit.RazonSocial + "'";
if (formatoRptExportar == "")
{
CrystalReportViewer1.GroupTreeStyle.ShowLines = false;
CrystalReportViewer1.HasToggleGroupTreeButton = false;
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CrystalReportViewer1.ReportSource = oRpt;
CrystalReportViewer1.HasPrintButton = true;
}
else
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(ivaVentas.Cuit);
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaVentas.PeriodoDsd).ToString("yyyyMMdd"));
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaVentas.PeriodoHst).ToString("yyyyMMdd"));
if (formatoRptExportar == "PDF")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
if (formatoRptExportar == "Excel")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.ExcelFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreateExcelFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, Server.MapPath("~/TempExcel/") + sb.ToString() + ".xls");
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment; filename=" + sb.ToString() + ".xls" + ";");
response.TransmitFile(Server.MapPath("~/TempExcel/" + sb.ToString() + ".xls"));
response.Flush();
response.End();
}
}
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
WebForms.Excepciones.Redireccionar(ex, "~/NotificacionDeExcepcion.aspx");
}
}
void CETAK()
{
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORT.FormViewerPENERIMA frm = new REPORT.FormViewerPENERIMA(dataPrint);
frm.ShowDialog();
}
/// <summary>
/// 利用 CrystalReport 列印報表
/// </summary>
/// <param name="s_FileName">報表的檔名</param>
/// <param name="s_rptFilePath">rpt檔的路徑</param>
/// <param name="dt_Source">要列印的資料</param>
/// <param name="reportFormatType">檔案型態</param>
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source1, DataTable dt_Source2, string reportFormatType)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(s_rptFilePath);
report.SetDataSource(dt_Source2);
string par_Vendor = string.Empty;
string par_VendorName = string.Empty;
string par_PurDate = string.Empty;
string par_PurchaseNo = string.Empty;
string par_FAX = string.Empty;
string par_TEL = string.Empty;
string par_BusinessContact = string.Empty;
double par_Tax = 0;
par_Vendor = dt_Source1.Rows[0]["VENDOR"].ToString();
par_VendorName = dt_Source1.Rows[0]["VENDOR_NAME"].ToString();
par_PurDate = dt_Source1.Rows[0]["PURCHSE_DATE"].ToString();
par_PurchaseNo = dt_Source1.Rows[0]["PURCHASE_NO"].ToString();
par_FAX = dt_Source1.Rows[0]["INV_FAX_AREA"].ToString() + "-" + dt_Source1.Rows[0]["INV_FAX"].ToString();
par_TEL = dt_Source1.Rows[0]["INV_TEL_AREA"].ToString() + "-" + dt_Source1.Rows[0]["INV_TEL"].ToString();
par_BusinessContact = dt_Source1.Rows[0]["BUSINESS_CONTACT"].ToString();
if (dt_Source2.Rows.Count == 0)
par_Tax = 0;
else
par_Tax = double.Parse(dt_Source2.Rows[0]["TAXRATE"].ToString());
#region 組合查詢條件至ArrayList
report.SetParameterValue("par_Vendor", par_Vendor);
report.SetParameterValue("par_VendorName", par_VendorName);
if (par_PurDate.Trim() != "")
{
report.SetParameterValue("par_PurDate", GetValueSetParameter(par_PurDate, "date"));
}
else
{
report.SetParameterValue("par_PurDate", "");
}
report.SetParameterValue("par_PurchaseNo", par_PurchaseNo);
report.SetParameterValue("par_FAX", par_FAX);
report.SetParameterValue("par_TEL", par_TEL);
report.SetParameterValue("par_BusinessContact", par_BusinessContact);
report.SetParameterValue("par_Tax", par_Tax);
#endregion
#region 判斷輸出檔案型態
switch (reportFormatType)
{
case "PDF":
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
report.Close();
break;
default:
break;
}
#endregion
}
private void btnTAMBAH_Click(object sender, EventArgs e)
{
#region CEK BY RICEK
if (string.IsNullOrEmpty(txtSFROM.Text))
{
MessageBox.Show("ISI KOTA ASAL", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtSFROM.Focus();
return;
}
if (string.IsNullOrEmpty(txtSTO.Text))
{
MessageBox.Show("ISI KOTA TUJUAN", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtSTO.Focus();
return;
}
if (string.IsNullOrEmpty(txtSWIGHT.Text))
{
MessageBox.Show("ISI BERAT / KG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtSWIGHT.Focus();
return;
}
if (string.IsNullOrEmpty(txtNAMACUSTOMER.Text))
{
MessageBox.Show("ISI NAMA CUSTOMER", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtNAMACUSTOMER.Focus();
return;
}
if (string.IsNullOrEmpty(txtPENERIMA.Text))
{
MessageBox.Show("ISI NAMA PENERIMA", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPENERIMA.Focus();
return;
}
if (string.IsNullOrEmpty(txtKETERANGANISI.Text))
{
MessageBox.Show("ISI KETERANGAN ISI BARANG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPENERIMA.Focus();
return;
}
if (txtSWIGHT.Text == "0")
{
MessageBox.Show("Mohon Lengkapi Transaksi", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtGRANDTOTAL.Focus();
return;
}
if (txtBAYAR.Text == "0")
{
MessageBox.Show("Mohon Lakukan Pembayaran", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtBAYAR.Focus();
return;
}
decimal checkGrandtotal, checkBayar = 0;
checkGrandtotal = Convert.ToDecimal(txtGRANDTOTAL.Text);
checkBayar = Convert.ToDecimal(txtBAYAR.Text);
if (checkBayar < checkGrandtotal)
{
MessageBox.Show("Mohon Lakukan Pelunasan Pembayaran", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtBAYAR.Focus();
return;
}
#endregion
c.NORESI = txtNORESI.Text;
c.TGLTERIMA = dtTGLMANIFEST.Value.ToString("yyyy-MM-dd");
c.TGLESTIMASI = dtETD.Value.ToString("yyyy-MM-dd");
c.JUMLAH = Convert.ToInt32(txtPCS.Text);
c.BERAT = float.Parse(txtWEIGHT.Text);
c.DIM_P = float.Parse(txtPDIM.Text);
c.DIM_L = float.Parse(txtLDIM.Text);
c.DIM_T = float.Parse(txtTDIM.Text);
c.RATE_KIRIM = float.Parse(txtRATEKIRIM.Text);
c.CHARGE_KIRIM = float.Parse(txtTOTALCHARGEKIRIM.Text);
c.PPNPERCENT = float.Parse(txtPPNPercent.Text);
c.PPN = float.Parse(txtCHARGEPPN.Text);
c.CHARGE_PACKING = float.Parse(txtCHARGEPACKING.Text);
c.OTHER_CHARGE = 0;
c.DISCPERCENT = float.Parse(txtDISKONPERCENT.Text);
c.DISC = float.Parse(txtDISKON.Text);
c.INCURANCEPERCENT = float.Parse(cboINSURANCE.Text);
c.INCURANCE = float.Parse(txtCHARGEINSURANCE.Text);
c.NBARANGINSURANCE = float.Parse(txtNOMINALBARANG.Text);
// TGLPENGIRIMAN,TGLPENGAMBILAN informasi ini di bongkar muat
c.TOTAL = float.Parse(txtGRANDTOTAL.Text);
c.BAYAR = float.Parse(txtBAYAR.Text);
c.SISA = float.Parse(txtKEMBALI.Text);
c.VOID = 0; // Belum disediakan untuk void
c.STATUS = 1; // SAAT pengisian awal default MANIFESTED
c.KETERANGANISI = txtKETERANGANISI.Text;
c.INSTRUKSIKHUSUS = txtINSTRUKSIKHUSUS.Text;
if (Type == 0)
{
// b.INSERT(c);
this.frm.LOAD_DATA();
}
else
{
b.UPDATE(c);
this.frm.LOAD_DATA();
}
Close();
//this.Hide();
//this.MinimumSize();
// disini isi data table printer
// BarcodeLib.Barcode b = new BarcodeLib.Barcode(BarcodeLib.TYPE.UPCA,
//"038000356216", Color.Black, Color.White, 300, 150);
dataPrint.Rows.Add(c.NORESI, txtSFROM.Text, txtSTO.Text, txtWEIGHT.Text, txtPCS.Text,
txtNAMACUSTOMER.Text, txtALAMATPENGIRIM.Text, txtPHONEPENGIRIM.Text, txtPENERIMA.Text, txtALAMAT.Text,
txtPHONEPENERIMA.Text, lblLAYANAN.Text, txtRATEKIRIM.Text, lblJENISKIRIMAN.Text,
txtCHARGEINSURANCE.Text, txtCHARGEPPN.Text, txtGRANDTOTAL.Text, txtKETERANGANISI.Text, txtINSTRUKSIKHUSUS.Text, txtPDIM.Text, txtLDIM.Text, txtTDIM.Text, txtHPPENGIRIM.Text, txtCHARGEPACKING.Text, 038000356216, namaPerusahaan, alamatPerusahaan, telpPerusahaan, faxPerusahaan, c.TGLTERIMA,c.TGLESTIMASI);
TopMost = false;
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.EXPRESS.FormRESIEXPRESS frm = new REPORTS.EXPRESS.FormRESIEXPRESS(dataPrint);
frm.WindowState = FormWindowState.Normal;
frm.BringToFront();
frm.ShowDialog();
}
private void btnCetak_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtKODEINVOICE.Text))
{
MessageBox.Show("KODE INVOICE KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKODEINVOICE.Focus();
return;
}
if (string.IsNullOrEmpty(txtKODECUSTOMER.Text))
{
MessageBox.Show("KODE CUSTOMER KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKODECUSTOMER.Focus();
return;
}
if (string.IsNullOrEmpty(txtNAMACUSTOMER.Text))
{
MessageBox.Show("NAMA CUSTOMER KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtNAMACUSTOMER.Focus();
return;
}
if (dgvSTTINV.SelectedCells.Count > 0)
{
if (string.IsNullOrEmpty(txtKET.Text))
{
MessageBox.Show("MOHON ISI KETERANGAN", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKET.Focus();
return;
}
c.TGLINVOICE = dtINVOICEDATE.Value.ToString("yyyy-MM-dd");
c.KODEINVOICE = txtKODEINVOICE.Text;
c.KODECUSTOMER = txtKODECUSTOMER.Text;
c.KETERANGAN = txtKET.Text;
DataTable dt = b.SEARCH_NOINVOICE(txtKODEINVOICE.Text);
if (dt.Rows.Count > 0)
{
MessageBox.Show("NO INVOICE TELAH DIBUAT, SILAHKAN CETAK INVOICE", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
b.INSERT(c);
DataTable dtUPDATE = b.SEARCH_NOINVOICE(txtKODEINVOICE.Text);
if (dtUPDATE.Rows.Count > 0)
{
for (int i = 0; i < dtUPDATE.Rows.Count; i++)
{
IDINVOICE = int.Parse(dtUPDATE.Rows[i]["ID"].ToString());
}
}
for (int count = 0; count < dgvSTTINV.Rows.Count; count++)
{
string check = dgvSTTINV.Rows[count].Cells[0].Value.ToString();
if (check == "True")
{
string noconnote = dgvSTTINV.Rows[count].Cells[2].Value.ToString();
bb.UPDATESETINVOICE(IDINVOICE, noconnote);
}
}
cc.KODEIVOICE = txtKODEINVOICE.Text;
LOAD_DETAIL();
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.INVOICE.FormINVOICE frm = new REPORTS.INVOICE.FormINVOICE(dtPRINT);
frm.ShowDialog();
// print
lblMESSAGE.Text = "SILAHKAN LAKUKAN PENCARIAN PERIODE DAN NAMA CUSTOMER YANG AKAN DIBUATKAN INVOICE";
CLEAR();
}
else
{
MessageBox.Show("TIDAK ADA STT YANG AKANG DI CETAK INVOICE", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
btnCARI.Focus();
}
}
/// <summary>
/// 利用 CrystalReport 列印 Excel 報表
/// </summary>
/// <param name="s_FileName">Excel報表的檔名</param>
/// <param name="s_rptFilePath">rpt檔的路徑</param>
/// <param name="dt_Source">要列印的資料</param>
/// /// <param name="reportFormatType">檔案型態</param>
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataSet dt_Source, string reportFormatType)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(s_rptFilePath);
report.SetDataSource(dt_Source);
#region 前置檢查與參數過濾
string par_ProgramID = string.Empty;
string par_LoginUser = string.Empty;
string sTemp;
par_ProgramID = this.PageCode;
par_LoginUser = Session["UID"].ToString();
#endregion
#region 組合查詢條件至Report ArrayList
report.SetParameterValue("ProgramName", par_ProgramID);
report.SetParameterValue("UserName", par_LoginUser); //"／"
report.SetParameterValue("AcceptDate", this.SLP_Accept_Range.RangeStartTextBox.Text + " － " + this.SLP_Accept_Range.RangeEndTextBox.Text);
if (this.SLP_VENDER_BEGIN.Text == string.Empty && this.SLP_VENDER_END.Text == string.Empty)
sTemp = string.Empty;
else if (this.SLP_VENDER_BEGIN.Text == string.Empty)
sTemp = " " + " － " + this.SLP_VENDER_END.Text + "" + this.SLP_VENDER_END.Name;
else if (this.SLP_VENDER_END.Text == string.Empty)
sTemp = this.SLP_VENDER_BEGIN.Text + "" + this.SLP_VENDER_BEGIN.Name + " － ";
else
sTemp = this.SLP_VENDER_BEGIN.Text + "" + this.SLP_VENDER_BEGIN.Name + " － "
+ this.SLP_VENDER_END.Text + "" + this.SLP_VENDER_END.Name;
report.SetParameterValue("Vendor", sTemp);
if (this.SLP_RootNoStart.Text == string.Empty && this.SLP_RootNoEnd.Text == string.Empty)
sTemp = string.Empty;
else if (this.SLP_RootNoStart.Text == string.Empty)
sTemp = " " + " － " + this.SLP_RootNoEnd.Text + "" + this.SLP_RootNoEnd.Name;
else if (this.SLP_RootNoEnd.Text == string.Empty)
sTemp = this.SLP_RootNoStart.Text + "" + this.SLP_RootNoStart.Name + " － ";
else
sTemp = this.SLP_RootNoStart.Text + "" + this.SLP_RootNoStart.Name + " － "
+ this.SLP_RootNoEnd.Text + "" + this.SLP_RootNoEnd.Name;
report.SetParameterValue("RootNo", sTemp);
if (this.SLP_PMA_BEGIN.Text == string.Empty && this.SLP_PMA_END.Text == string.Empty)
sTemp = string.Empty;
else if (this.SLP_PMA_BEGIN.Text == string.Empty)
sTemp = " " + " － " + this.SLP_PMA_END.Text + "" + this.SLP_PMA_END.Name;
else if (this.SLP_PMA_END.Text == string.Empty)
sTemp = this.SLP_PMA_BEGIN.Text + "" + this.SLP_PMA_BEGIN.Name + " － ";
else
sTemp = this.SLP_PMA_BEGIN.Text + "" + this.SLP_PMA_BEGIN.Name + " － "
+ this.SLP_PMA_END.Text + "" + this.SLP_PMA_END.Name;
report.SetParameterValue("PMA", sTemp);
if (this.SLP_CATEGORY_BEGIN.Text == string.Empty && this.SLP_CATEGORY_END.Text == string.Empty)
sTemp = string.Empty;
else if (this.SLP_CATEGORY_BEGIN.Text == string.Empty)
sTemp = " " + " － " + this.SLP_CATEGORY_END.Text + "" + this.SLP_CATEGORY_END.Name;
else if (this.SLP_CATEGORY_END.Text == string.Empty)
sTemp = this.SLP_CATEGORY_BEGIN.Text + "" + this.SLP_CATEGORY_BEGIN.Name + " － ";
else
sTemp = this.SLP_CATEGORY_BEGIN.Text + "" + this.SLP_CATEGORY_BEGIN.Name + " － "
+ this.SLP_CATEGORY_END.Text + "" + this.SLP_CATEGORY_END.Name;
report.SetParameterValue("CATEGORY", sTemp);
report.SetParameterValue("Item", this.SLP_SKU.Text);
report.SetParameterValue("Period", this.SLP_PERIOD.Text);
if (this.rdabNormal.Checked == true)
report.SetParameterValue("Type", this.rdabNormal.Text);
else if (this.rdNormal.Checked == true)
report.SetParameterValue("Type", this.rdNormal.Text);
#endregion
//判斷輸出檔案型態
switch (reportFormatType)
{
case "EXCEL":
System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytesXLS = new byte[streamXLS.Length];
streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
streamXLS.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel";
Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length);
Response.Flush();
Response.Close();
report.Close();
break;
case "PDF":
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
//Response.OutputStream.Write("AA", 0, 2);
Response.Flush();
Response.Close();
report.Close();
break;
default:
break;
}
}
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(s_rptFilePath);
report.SetDataSource(dt_Source);
//判斷輸出檔案型態
switch (reportFormatType)
{
case "EXCEL":
System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytesXLS = new byte[streamXLS.Length];
streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
streamXLS.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel";
Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length);
Response.Flush();
Response.Close();
break;
case "PDF":
string s_par_Program_ID = string.Empty;
string s_par_LoginUser = string.Empty;
s_par_Program_ID = this.PageCode;
s_par_LoginUser = Session["UID"].ToString();
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
break;
default:
break;
}
}
void CETAK()
{
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.INVOICE.FormSTT frm = new REPORTS.INVOICE.FormSTT(dataPrint);
frm.ShowDialog();
}
//Crystal Report 直接輸出 PDF 檔
private void ExportReport(DataTable dt)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath("../REPORT/IVM14/CRIVM14R01.rpt"));
report.SetDataSource(dt);
//CrystalReport Parameter 參數設定
string Program_ID = string.Empty;
string LoginUser = string.Empty;
string ChanTransNo = string.Empty;
Program_ID = this.PageCode.Substring(0, 5) + "R01";
LoginUser = Session["UID"].ToString();
ChanTransNo = Session["ForChanTransNo"].ToString();
report.SetParameterValue("par_Program_ID", this.PageCode);
report.SetParameterValue("par_LoginUser", LoginUser);
report.SetParameterValue("par_ChanTransNo", ChanTransNo);
//檔案匯出
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//Export File
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("轉入異常資料.PDF", System.Text.Encoding.UTF8));//匯出檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
}
/// <summary>
/// 利用 CrystalReport 列印 Excel 報表
/// </summary>
/// <param name="s_FileName">Excel報表的檔名</param>
/// <param name="s_rptFilePath">rpt檔的路徑</param>
/// <param name="dt_Source">要列印的資料</param>
/// /// <param name="reportFormatType">檔案型態</param>
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(s_rptFilePath);
report.SetDataSource(dt_Source);
string par_ProgramID = string.Empty;
string par_LoginUser = string.Empty;
#region 前置檢查與參數過濾
string par_AcceptDate = this.txtST_ACCEPT_DATE.Text;
string par_ChanName = this.ddlChanNo.SelectedItem.Text.Replace("(", " ") ;
par_ChanName = par_ChanName.Replace(")", "");
string par_StoreName = string.Empty;
if (this.ddlStore.SelectedIndex > 0 )
par_StoreName = this.ddlStore.SelectedItem.Text;
par_StoreName = par_StoreName.Replace("(", " ");
par_StoreName = par_StoreName.Replace(")", " ");
par_ProgramID = this.PageCode;
// par_LoginUser = "******";
par_LoginUser = Session["UID"].ToString();
#endregion
#region 組合查詢條件至ArrayList
ArrayList returnList = new ArrayList();
returnList.Clear();
report.SetParameterValue("AcceptDate", par_AcceptDate);
report.SetParameterValue("ProgramName", par_ProgramID);
report.SetParameterValue("UserName", par_LoginUser);
report.SetParameterValue("ChanName", par_ChanName);
report.SetParameterValue("StoreName", par_StoreName);
#endregion
//判斷輸出檔案型態
switch (reportFormatType)
{
case "EXCEL":
System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytesXLS = new byte[streamXLS.Length];
streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
streamXLS.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel";
Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length);
Response.Flush();
Response.Close();
report.Close();
break;
case "PDF":
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
report.Close();
break;
default:
break;
}
}
public static CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReportDocument(string documentName)
{
try
{
CrystalDecisions.CrystalReports.Engine.ReportDocument ret =
Feng.Utils.ReflectionHelper.CreateInstanceFromName(documentName) as CrystalDecisions.CrystalReports.Engine.ReportDocument;
if (ret != null)
return ret;
}
catch (Exception)
{
}
ResourceContent res = ResourceInfoHelper.ResolveResource(documentName, ResourceType.Report);
if (res != null)
{
switch (res.Type)
{
case ResourceContentType.File:
{
CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
reportDocument.Load(res.Content.ToString());
return reportDocument;
}
case ResourceContentType.Binary:
{
byte[] data = (byte[])res.Content;
string fileName = System.IO.Path.GetTempFileName();
using (System.IO.FileStream fs = new System.IO.FileStream(fileName, System.IO.FileMode.Create))
{
fs.Write(data, 0, data.Length);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
reportDocument.Load(fileName);
return reportDocument;
}
default:
throw new ArgumentException("Invalid Resource Content Type!");
}
}
else
{
throw new ArgumentException(string.Format("Can't find resouce of {0}!", documentName));
}
}
void CETAK()
{
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.TAGIHAN.FormTAGIHAN frm = new REPORTS.TAGIHAN.FormTAGIHAN(cryRpt, dataPrint);
frm.ShowDialog();
}
/// <summary>
/// 利用 CrystalReport 列印 Excel 報表
/// </summary>
/// <param name="s_FileName">Excel報表的檔名</param>
/// <param name="s_rptFilePath">rpt檔的路徑</param>
/// <param name="dt_Source">要列印的資料</param>
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source)
{
#region
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(s_rptFilePath);
report.SetDataSource(dt_Source);
System.IO.Stream stream = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytes = new byte[stream.Length];
stream.Read(bytes, 0, bytes.Length);
stream.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel;charset='utf-8'";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
Response.OutputStream.Write(bytes, 0, bytes.Length);
Response.Flush();
Response.Close();
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
//this takes request parameters only from the query string
string SalesOrderID = Request.QueryString["salesorderid"];
if (SalesOrderID == null)
{
//SalesOrderID = "QDEMOA0019C7"; //FOR Testing
}
if (SalesOrderID == null)
{
Response.Write("No Valid SalesOrderID provided");
}
else
{
try
{
Sage.Entity.Interfaces.ISalesOrder salesOrder = Sage.Platform.EntityFactory.GetById<Sage.Entity.Interfaces.ISalesOrder>(SalesOrderID);
string reportPath = Server.MapPath("CrystalReports\\PickingListDetail.rpt");
CrystalDecisions.CrystalReports.Engine.ReportDocument crReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
crReport.Load(reportPath);
crReport.RecordSelectionFormula = "{SALESORDER.SALESORDERID} = '" + salesOrder.Id.ToString() + "'";
//Retrieve connection string information
// get the DataService to get a connection string to the database
Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>();
string connectionString = datasvc.GetConnectionString();
System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();
builder.ConnectionString = connectionString;
string password = builder["Password"].ToString();
string username = builder["User ID"].ToString();
string dataSource = datasvc.Server;
string initialCatalog = datasvc.Alias;
//Define new connection for Crystal Report
CrystalDecisions.Shared.ConnectionInfo connectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
connectionInfo.DatabaseName = initialCatalog;
connectionInfo.UserID = username;
connectionInfo.Password = password;
connectionInfo.ServerName = dataSource;
// set report connection for main report
SetDBLogonForReport(connectionInfo, crReport);
// set report connection for any subreports
SetDBLogonForSubreports(connectionInfo, crReport);
//System.IO.MemoryStream ms = (System.IO.MemoryStream)crReport.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
//Response.BinaryWrite(ms.ToArray());
String filename = "exportedPDF/PickingList" + salesOrder.AlternateKeyPrefix + "-" + salesOrder.AlternateKeySuffix + ".pdf";
crReport.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath(filename));
//string popupScript = "<script language='javascript'>" + "window.open('C:/BiWeeklyReport.pdf'); <//script>";
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "popupOpener", "var popup=window.open('" + filename + "');popup.focus();", true);
//string jsScript = "window.close();";
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlertJS", jsScript, true);
//Page.ClientScript.RegisterOnSubmitStatement(typeof(Page), "closePage", "window.onunload = CloseWindow();");
Response.Redirect(filename);
}
catch (System.Threading.ThreadAbortException ex)
{
}
finally
{
//Response.End();
}
}
}
