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");
}
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));
}
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";
}
}
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);
}
}
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 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;
}
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 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 }));
}
}
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();
}
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();
}
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 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 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 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);
}
}
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 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);
}
}
private void bPreview_Click(object sender, EventArgs e)
{
GetAUditReport();
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load("LeafAnalysis2.rpt");
report.SetDataSource(auditReport);
crv.ReportSource = report;
crv.Refresh();
}
private static void ImprimirTicket(string Identificador)
{
string returnValue = null;
// Look for the name in the connectionStrings section.
ConnectionStringSettings settings =
ConfigurationManager.ConnectionStrings["ProfitContenedor.Properties.Settings.Profit_RGConnectionString"];
// If found, return the connection string.
if (settings != null)
{
returnValue = settings.ConnectionString;
}
//SqlConnection sqlConn = new SqlConnection("Server=172.16.1.4;uid=profit;password=profit;initial catalog=Profit_RG;");
SqlConnection sqlConn = new SqlConnection(returnValue);
SqlCommand comd;
comd = new SqlCommand();
comd.Connection = sqlConn;
comd.CommandType = CommandType.StoredProcedure;
comd.CommandText = "pRepTicket_Pedido";
comd.Parameters.Add("@Rowguid", SqlDbType.Char);
comd.Parameters[0].Value = Identificador;
SqlDataAdapter sqlAdapter = new SqlDataAdapter();
sqlAdapter.SelectCommand = comd;
DataSet ds = new DataSet();
sqlAdapter.Fill(ds, "pRepTicket_Pedido");
CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string Filename = @"\\172.16.1.4\Profit\Publicaciones\Profit Expansion\Reportes\RepTicketPedido.rpt";
oRpt.Load(Filename);
string NombreImpresora = "";//Donde guardare el nombre de la impresora por defecto
//Busco la impresora por defecto
for (int i = 0; i < PrinterSettings.InstalledPrinters.Count; i++)
{
PrinterSettings a = new PrinterSettings();
a.PrinterName = PrinterSettings.InstalledPrinters[i].ToString();
if (a.IsDefaultPrinter)
{
NombreImpresora = PrinterSettings.InstalledPrinters[i].ToString();
}
}
oRpt.SetDataSource(ds); //Asigno la fuente de datos a mi reporte.
oRpt.PrintOptions.PrinterName = NombreImpresora; //Asigno la impresora
oRpt.PrintToPrinter(1, false, 0, 0); //Imprimo 1 copias
}
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_Init(object sender, EventArgs e)
{
string SearchStr = string.Empty;
try
{
if (Session["CurrentSchoolYearId"] == null)
{
Response.Redirect("~/Login.aspx");
}
crdata.Report = rpt;
rpt1 = crdata.ReportDocument;
DataSet dsReport = new xmlClassWiseStudentAttendTime();
DataSet ds = new DataSet();
if (Session["FamilyTitle"] != null)
{
//rpt.FileName = Server.MapPath("rptFamilyChildListReport.rpt");
rpt.FileName = Server.MapPath("rptFamilyChildList1Report.rpt");
DayCareBAL.LedgerService proxy = new DayCareBAL.LedgerService();
SearchStr += Session["FamilyTitle"].ToString();
SearchStr = Session["FamilyTitle"].ToString().Replace("'00000000-0000-0000-0000-000000000000',", "");
//string[] str = SearchStr.Remove(SearchStr.Length - 1).Remove(0, 1).Replace("','", "$").Split('$');
//string strFinalSearhString = "";
//foreach (string s in str)
//{
// string s1 = "";
// s1 = s.Replace("'", "");
// s1 = "''" + s1 + "'',";
// strFinalSearhString += s1;
//}
//strFinalSearhString = strFinalSearhString.Remove(strFinalSearhString.Length - 1);
//strFinalSearhString = "'" + strFinalSearhString + "'";
CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text1"];
CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"];
footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString()));
titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper();
//ds = proxy.GetAccountReceiable(new Guid(Session["CurrentSchoolYearId"].ToString(), new Guid(Request.QueryString["StartDate"].ToString())));
ds = proxy.GetFamilyChildListReport(new Guid(Session["SchoolId"].ToString()), new Guid(Session["CurrentSchoolYearId"].ToString()), SearchStr);
dsReport.Tables["dtFamilyChildList"].Merge(ds.Tables[0]);
rpt1.SetDataSource(dsReport.Tables["dtFamilyChildList"]);
}
crp.DisplayGroupTree = false;
crp.ReportSource = rpt1;
crp.RefreshReport();
crp.DataBind();
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.Ledger, "rptFamilyChildListReport Page_Load", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath("~/Reports/RptMedico.rpt");
report.Load(reportPath);
report.SetDataSource(Session["ReportSource"]);
report.SetParameterValue("titulo", "General");
crViewer.ReportSource = report;
crViewer.DataBind();
}
/// <summary>
/// Print the error log
/// </summary>
public void m_Print()
{
try
{
DataSet dsErrLog = new DataSet();
DataTable dtbErrLog = new DataTable("element1");
CrystalDecisions.CrystalReports.Engine.ReportDocument rdtErrLog = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rdtErrLog.Load("Report\\crpErrorLog.rpt");
string columnName1, columnType1;
for (int i = 0; i < rdtErrLog.Database.Tables[0].Fields.Count; i++)
{
columnName1 = rdtErrLog.Database.Tables[0].Fields[i].Name.ToString();
columnType1 = rdtErrLog.Database.Tables[0].Fields[i].GetType().ToString();
dtbErrLog.Columns.Add(columnName1, rdtErrLog.Database.Tables[0].Fields[i].GetType());
}
// dtbErrLog.Columns.Add(rdt);
DataRow dtrNewRow;
//insert data**********************************************
for (int lines = 0; lines < m_objViewer.m_lsv.Items.Count; lines++)
{
dtrNewRow = dtbErrLog.NewRow();
for (int i = 0; i < 12; i++)
{
dtrNewRow[i] = m_objViewer.m_lsv.Items[lines].SubItems[i + 1].Text;
}
/* dtrNewRow[6] = m_objViewer.m_lsv.Items[lines].SubItems[7].Text
+ m_objViewer.m_lsv.Items[lines].SubItems[8].Text;
+ for (int i = 7; i < 12; i++)
+ dtrNewRow[i] = m_objViewer.m_lsv.Items[lines].SubItems[i+2].Text;
*/ for (int i = 12; i < 12 + 9; i++)
{
dtrNewRow[i] = "";
}
for (int i = 12 + 9; i < 12 + 18; i++)
{
dtrNewRow[i] = 0;
}
dtbErrLog.Rows.Add(dtrNewRow);
}
dsErrLog.Tables.Add(dtbErrLog);
rdtErrLog.SetDataSource(dsErrLog);
// CommonClassReport.clsReport ObjDemo = new CommonClassReport.clsReport();
m_objViewer.m_crvTemp.ReportSource = rdtErrLog;
m_objViewer.m_crvTemp.PrintReport();
}
catch
{
MessageBox.Show("打印故障！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static bool InitCryReport()
{
//// Application.StartupPath + "\\" + Guid.NewGuid() + ".rpt";
//jianqg 2014-4-15 发现经常不能删除 临时文件
//WorkStaticFun.ClearTempDir 删除临时文件
string templateFile = System.Environment.GetFolderPath(Environment.SpecialFolder.Templates) + "\\" + Guid.NewGuid() + ".rpt";
try
{
DataTable dt = new DataTable("temp");
dt.Columns.Add("Fields0");
Assembly assembly = Assembly.LoadFile(Application.StartupPath + "\\TrasenFrame.dll");
using (System.IO.Stream stream = assembly.GetManifestResourceStream("TrasenFrame.Forms.Temp.rpt"))
{
byte[] fileByte = new byte[(int)stream.Length];
stream.Read(fileByte, 0, (int)stream.Length);
using (System.IO.FileStream fs = new System.IO.FileStream(templateFile, System.IO.FileMode.Create))
{
fs.Write(fileByte, 0, fileByte.Length);
fs.Flush();
}
stream.Close();
}
//WriteFrameLocalLog(new string[] { "InitCryReport1" }, true);
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
//WriteFrameLocalLog(new string[] { "InitCryReport2" }, true);
rptDoc.FileName = templateFile;
//WriteFrameLocalLog(new string[] { "InitCryReport3" }, true);
rptDoc.SetDataSource(dt);
WriteFrameLocalLog(new string[] { "初始化水晶报表组件完成" }, true);
return(true);
}
catch (Exception error)
{
WriteFrameLocalLog(new string[] { "初始化水晶报表组件发生错误！", error.Message }, true);
return(false);
}
finally
{
if (System.IO.File.Exists(templateFile))
{
System.IO.File.Delete(templateFile);
}
initCryptEnd = true;
}
}
private void IncrustarLogo(string cuit, string PtoVta)
{
try
{
String path = Server.MapPath("~/ImagenesSubidas/");
string[] archivos = System.IO.Directory.GetFiles(path, cuit + "-" + PtoVta + ".*", System.IO.SearchOption.TopDirectoryOnly);
string imagenCUIT = "";
if (archivos.Length > 0)
{
imagenCUIT = "~/ImagenesSubidas/" + archivos[0].Replace(Server.MapPath("~/ImagenesSubidas/"), String.Empty);
}
else
{
archivos = System.IO.Directory.GetFiles(path, cuit + ".*", System.IO.SearchOption.TopDirectoryOnly);
imagenCUIT = "";
if (archivos.Length > 0)
{
imagenCUIT = "~/ImagenesSubidas/" + archivos[0].Replace(Server.MapPath("~/ImagenesSubidas/"), String.Empty);
}
}
if (imagenCUIT != "")
{
FileStream FilStr = new FileStream(Server.MapPath(imagenCUIT), FileMode.Open);
CrearTabla();
BinaryReader BinRed = new BinaryReader(FilStr);
DataRow dr = this.dsImages.Tables["images"].NewRow();
dr["path"] = Server.MapPath(imagenCUIT);
dr["image"] = BinRed.ReadBytes((int)BinRed.BaseStream.Length);
this.dsImages.Tables["images"].Rows.Add(dr);
FilStr.Close();
BinRed.Close();
imagenRpt = facturaRpt.OpenSubreport("Imagen.rpt");
imagenRpt.SetDataSource(this.dsImages);
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: Imagen OK");
}
}
catch (Exception ex)
{
string a = ex.Message.ToString().Replace("'", " ");
a = a.Replace("<", " ");
a = a.Replace(">", " ");
a = a.Replace("/", " ");
a = a.Replace(@"\", " ");
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: Imagen NOT OK " + a);
}
}
public static void AddReportParameters(CrystalDecisions.CrystalReports.Engine.ReportDocument rpt, DataTable dt, string ReportName, bool CompanyName, bool Address1, bool Address2, bool City, bool PinCode, bool phone, bool Department, bool State, bool Phone2, bool Fax, bool Email)
{
rpt.SetDataSource(dt);
if (ReportName != "")
{
rpt.SetParameterValue("pReportName", ReportName);
}
if (CompanyName == true)
{
rpt.SetParameterValue("pCompanyName", CurrentCompany.CompanyName);
}
if (Address1 == true)
{
rpt.SetParameterValue("pAddress1", CurrentCompany.Address1);
}
if (Address2 == true)
{
rpt.SetParameterValue("pAddress2", CurrentCompany.Address2);
}
if (City == true)
{
rpt.SetParameterValue("pCity", CurrentCompany.City);
}
if (State == true)
{
rpt.SetParameterValue("pState", "");
}
if (PinCode == true)
{
rpt.SetParameterValue("pPinCode", CurrentCompany.Pincode);
}
if (phone == true)
{
rpt.SetParameterValue("pPhone", CurrentCompany.Phone1);
}
if (Phone2 == true)
{
rpt.SetParameterValue("pPhone2", CurrentCompany.Phone2);
}
if (Fax == true)
{
rpt.SetParameterValue("pFax", CurrentCompany.Fax);
}
if (Email == true)
{
rpt.SetParameterValue("pEmail", CurrentCompany.Email);
}
}
private string generatefiles(DataSet ds, DataTable dt1, string fromdate, string todate, string FirstPath, DataTable mailsetting)
{
try
{
DataView dv = new DataView(ds.Tables[0]);
string strAttachFirst = string.Empty;
string strAttachSecond = string.Empty;
bool isSendData = false;
System.Collections.ArrayList objList = new ArrayList();
objList.Add(MailSetting(mailsetting));
CrystalDecisions.CrystalReports.Engine.ReportDocument crystalReport;
foreach (DataRow Row in dt1.Rows)
{
MailDetails objMails = new MailDetails();
dv.RowFilter = "SuperZoneID = " + Row["SuperZoneID"].ToString();
crystalReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
crystalReport.Load(Server.MapPath("../Report/MissingRecieptNo.rpt"));
crystalReport.SetDataSource(dv.ToTable());
crystalReport.SetParameterValue("FromDP", Convert.ToDateTime(fromdate));
crystalReport.SetParameterValue("TODp", Convert.ToDateTime(todate));
isSendData = dv.ToTable().Rows.Count > 0 ? true : false;
strAttachFirst = Server.MapPath(FirstPath + "MissingRecieptNo_" + Convert.ToDateTime(fromdate).ToString("dd-MMM-yyyy") + "_" + Convert.ToDateTime(todate).ToString("dd-MMM-yyyy") + "_" + Row["SuperZoneID"].ToString() + ".pdf");
crystalReport.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, strAttachFirst);
crystalReport.Close();
crystalReport.Dispose();
crystalReport = null;
objMails.Attachment = strAttachSecond != "" ? strAttachFirst + "," + strAttachSecond : strAttachFirst;
objMails.Name = Row["SuperZoneName"].ToString();
objMails.EmailId = Row["Email"].ToString();
string makesubject = "Missing Receipts from " + Convert.ToDateTime(fromdate).ToString("dd-MMM-yyyy") + " TO " + Convert.ToDateTime(todate).ToString("dd-MMM-yyyy");
objMails.Subject = makesubject;
objMails.Desc = makesubject;
if (isSendData)
{
objList.Add(objMails);
}
objMails = null;
}
return(JsonConvert.SerializeObject(objList));
}
catch (Exception ex)
{
throw;
}
}
protected void Page_Init(object sender, EventArgs e)
{
try
{
if (Session["CurrentSchoolYearId"] == null)
{
Response.Redirect("~/Login.aspx");
}
crdata.Report = rpt;
rpt1 = crdata.ReportDocument;
DataSet dsReport = new xmlClassWiseStudentAttendTime();
DataSet ds = new DataSet();
if (!string.IsNullOrEmpty(Request.QueryString["StartDate"]))
{
rpt.FileName = Server.MapPath("rptAccountReceivablesReport.rpt");
DayCareBAL.LedgerService proxy = new DayCareBAL.LedgerService();
CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text9"];
CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"];
footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString()));
titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper();
//ds = proxy.GetAccountReceiable(new Guid(Session["CurrentSchoolYearId"].ToString(), new Guid(Request.QueryString["StartDate"].ToString())));
ds = proxy.GetAccountReceiable(new Guid(Session["CurrentSchoolYearId"].ToString()), Convert.ToDateTime(Request.QueryString["StartDate"].ToString()), "AccountsReceivable");
dsReport.Tables["dtAccountReceiable_Credit"].Merge(ds.Tables[0]);
rpt1.SetDataSource(dsReport.Tables["dtAccountReceiable_Credit"]);
}
crp.DisplayGroupTree = false;
crp.ReportSource = rpt1;
crp.RefreshReport();
crp.DataBind();
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.Ledger, "rptAccountReciableReport Page_Load", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["dtPrint"] != null)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument report =
new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(System.IO.Path.Combine(Server.MapPath("~/Reports"), "crpTable.rpt"));
report.SetDataSource(Session["dtPrint"]);
CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX;
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CrystalReportViewer1.ReportSource = report;
lblMsg.Text = "";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
public frmInvoice(string txt)
{
InitializeComponent();
try
{
pro.strcon.Open();
string reportname = "Receipt";
pro.sqlselect = "SELECT * FROM tblproduct p , tbltransaction t,tblsummary s WHERE p.Barcode = t.Barcode AND t.InvoiceNo = s.InvoiceNo AND s.InvoiceNo ='" + txt + "'";
pro.cmd = new SqlCommand();
pro.cmd.Connection = pro.strcon;
pro.cmd.CommandText = pro.sqlselect;
pro.da = new SqlDataAdapter();
pro.da.SelectCommand = pro.cmd;
pro.dt = new DataTable();
pro.da.Fill(pro.dt);
CrystalDecisions.CrystalReports.Engine.ReportDocument reportdoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();;
string strReportPath = Application.StartupPath + "\\report\\" + reportname + ".rpt";
reportdoc.Load(strReportPath);
reportdoc.SetDataSource(pro.dt);
crystalReportViewer1.ReportSource = reportdoc;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
pro.da.Dispose();
pro.strcon.Close();
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (Session["CurrentSchoolYearId"] == null)
{
Response.Redirect("~/Login.aspx");
}
crdata.Report = rpt;
rpt1 = crdata.ReportDocument;
DataSet dsReport = new xmlClassWiseStudentAttendTime();
DataSet ds = new DataSet();
String strLastNameFrom = Convert.ToString(Request.QueryString["lastnamefrom"]);
String strLastNameTo = Convert.ToString(Request.QueryString["lastnameto"]);
// crp.AfterRender += this.crp_AfterRender;
rpt.FileName = Server.MapPath("rptStudentSchedule.rpt");
DayCareBAL.ClassRoomService proxy = new DayCareBAL.ClassRoomService();
CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text3"];
CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text1"];
CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"];
footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString()));
//CrystalDecisions.CrystalReports.Engine.TextObject titleText4 = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text4"];
//titleText4.Text = ViewState["title"].ToString();
titleText.Text = "Student Schedule";
titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper();
ds = proxy.GetStudentSchedule(new Guid(DayCarePL.Common.GUID_DEFAULT), new Guid(Session["CurrentSchoolYearId"].ToString()), strLastNameFrom, strLastNameTo);
dsReport.Tables["dtClassWiseStudent"].Merge(ds.Tables[0]);
rpt1.SetDataSource(dsReport.Tables["dtClassWiseStudent"]);
crp.DisplayGroupTree = false;
crp.ReportSource = rpt1;
crp.RefreshReport();
crp.DataBind();
}
private void btnPrintConsumptionReport_Click(object sender, EventArgs e)
{
Reports.reportDataSet rds = new Reports.reportDataSet();
DataRow newRowKalkulacijaPotrosnja = rds.Tables["KalkulacijaPotrosnja"].NewRow();
newRowKalkulacijaPotrosnja["CenaSmese"] = decimal.Parse(lblTotal1.Text);
newRowKalkulacijaPotrosnja["KalkulacijaNaziv"] = _kalkulacijaNaziv;
newRowKalkulacijaPotrosnja["SmesaNaziv"] = _smesaNaziv;
rds.Tables["KalkulacijaPotrosnja"].Rows.Add(newRowKalkulacijaPotrosnja);
foreach (DataGridViewRow row in dgvTroskovi.Rows)
{
DataRow newRow = rds.Tables["KalkulacijaPotrosnjaStavka"].NewRow();
newRow["KategorijaZivotinja"] = row.Cells["KategorijaZivotinjaNaziv"].Value;
newRow["BrojZivotinja"] = row.Cells["BrojZivotinja"].Value;
newRow["DnevnaPotrosnjaPoZivotinji"] = row.Cells["DnevnaPotrosnjaPoZivotinji"].Value;
newRow["DnevnaPotrosnjaKolicina"] = row.Cells["DnevnaPotrosnja"].Value;
newRow["DnevnaPotrosnjaIznos"] = decimal.Parse(row.Cells["DnevnaPotrosnja"].Value.ToString()) * decimal.Parse(lblTotal1.Text) / (decimal)100;
newRow["NedeljnaPotrosnjaKolicina"] = row.Cells["NedeljnaPotrosnja"].Value;
newRow["NedeljnaPotrosnjaIznos"] = decimal.Parse(row.Cells["NedeljnaPotrosnja"].Value.ToString()) * decimal.Parse(lblTotal1.Text) / (decimal)100;
//newRow["MesecnaPotrosnjaKolicina"] = decimal.Parse(row.Cells["NedeljnaPotrosnja"].Value.ToString()) * (decimal)4.5;
newRow["MesecnaPotrosnjaKolicina"] = decimal.Parse(row.Cells["DnevnaPotrosnja"].Value.ToString()) * 31;
//newRow["MesecnaPotrosnjaIznos"] = decimal.Parse(row.Cells["NedeljnaPotrosnja"].Value.ToString()) * (decimal)4.5 * decimal.Parse(lblTotal1.Text) / (decimal)100;
newRow["MesecnaPotrosnjaIznos"] = decimal.Parse(row.Cells["DnevnaPotrosnja"].Value.ToString()) * 31 * decimal.Parse(lblTotal1.Text) / (decimal)100;
//newRow["GodisnjaPotrosnjaKolicina"] = decimal.Parse(newRow["MesecnaPotrosnjaKolicina"].ToString()) * (decimal)12;
newRow["GodisnjaPotrosnjaKolicina"] = decimal.Parse(row.Cells["DnevnaPotrosnja"].Value.ToString()) * 365;
//newRow["GodisnjaPotrosnjaIznos"] = decimal.Parse(newRow["MesecnaPotrosnjaKolicina"].ToString()) * (decimal)12 * decimal.Parse(lblTotal1.Text) / (decimal)100;
newRow["GodisnjaPotrosnjaIznos"] = decimal.Parse(row.Cells["DnevnaPotrosnja"].Value.ToString()) * 365 * decimal.Parse(lblTotal1.Text) / (decimal)100;
rds.Tables["KalkulacijaPotrosnjaStavka"].Rows.Add(newRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rd.Load("Reports/KalkulacijaPotrosnja.rpt");
rd.SetDataSource(rds);
frmPrint objfrmPrint = new frmPrint();
objfrmPrint.crystalReportViewer1.ReportSource = rd;
objfrmPrint.Show();
}
private void m_mthSetData(cls3DItem[] arrItems)
{
if (arrItems == null)
{
return;
}
DataSet objSet = m_objCreateDS();
DataTable objDT = objSet.Tables["tbReport"];
for (int i = 0; i < arrItems.Length; i++)
{
DataRow objRow = objDT.NewRow();
arrItems[i].ToDataRow(ref objRow);
objDT.Rows.Add(objRow);
}
m_objDocument.SetDataSource(objSet);
m_objDocument.Refresh();
crystalReportViewer1.ReportSource = m_objDocument;
crystalReportViewer1.Refresh();
}
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;
}
/// <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;
}
}
/// <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;
}
}
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;
}
}
private void Guia()
{
dsReportes dsReporte = new dsReportes();
dsReportes.GuiaRemisionRow drFilaGuiaRemision = dsReporte.GuiaRemision.NewGuiaRemisionRow();
drFilaGuiaRemision.id_guia_remision = 1;
drFilaGuiaRemision.punto_partida = "LIMA";
drFilaGuiaRemision.punto_llegada = "San Miguel";
drFilaGuiaRemision.fecha_emision = "28/12/2013";
drFilaGuiaRemision.fecha_inicio_traslado = "28/12/2013";
drFilaGuiaRemision.destinatario = "NOMBRE DEL DESTINATARIO";
drFilaGuiaRemision.ruc_destinatario = "099227394";
drFilaGuiaRemision.transportista = "COMESA S.A";
drFilaGuiaRemision.ruc_transportista = "199227395";
drFilaGuiaRemision.marca = "KIA";
drFilaGuiaRemision.placa = "888282828";
drFilaGuiaRemision.certificado = "2013-09";
drFilaGuiaRemision.licencia = "201309345";
dsReporte.GuiaRemision.AddGuiaRemisionRow(drFilaGuiaRemision);
/*
dsReportes.GuiaRemisionDetalleRow drFilaGuiaRemisionDetalle1 = dsReporte.GuiaRemisionDetalle.NewGuiaRemisionDetalleRow();
drFilaGuiaRemisionDetalle1.id_guia_remision = 1;
drFilaGuiaRemisionDetalle1.item = 1;
drFilaGuiaRemisionDetalle1.cantidad = Convert.ToDecimal("12.33");
drFilaGuiaRemisionDetalle1.codigo = "1010010020356";
drFilaGuiaRemisionDetalle1.descripcion = "SULFATO FERROSO 300MG. TAB.";
drFilaGuiaRemisionDetalle1.precio = Convert.ToDecimal("1234.23000");
dsReporte.GuiaRemisionDetalle.AddGuiaRemisionDetalleRow(drFilaGuiaRemisionDetalle1);
dsReportes.GuiaRemisionDetalleRow drFilaGuiaRemisionDetalle2 = dsReporte.GuiaRemisionDetalle.NewGuiaRemisionDetalleRow();
drFilaGuiaRemisionDetalle2.id_guia_remision = 1;
drFilaGuiaRemisionDetalle2.item = 2;
drFilaGuiaRemisionDetalle2.cantidad = Convert.ToDecimal("12.33");
drFilaGuiaRemisionDetalle2.codigo = "6910080080703";
drFilaGuiaRemisionDetalle2.descripcion = "FRASCO 500 ML TAPA ROSCA PIREX USA VIDRIO BOROSILICATO AUTOCLAV.";
drFilaGuiaRemisionDetalle2.precio = Convert.ToDecimal("2004.23000");
dsReporte.GuiaRemisionDetalle.AddGuiaRemisionDetalleRow(drFilaGuiaRemisionDetalle2);
*/
for (int i = 1; i < 31; i++)
{
dsReportes.GuiaRemisionDetalleRow drFilaGuiaRemisionDetalle3 = dsReporte.GuiaRemisionDetalle.NewGuiaRemisionDetalleRow();
drFilaGuiaRemisionDetalle3.id_guia_remision = 1;
drFilaGuiaRemisionDetalle3.item = i;
drFilaGuiaRemisionDetalle3.cantidad = Convert.ToDecimal("12.33");
drFilaGuiaRemisionDetalle3.codigo = "6910080080703";
drFilaGuiaRemisionDetalle3.descripcion = "FRASCO 500 ML TAPA ROSCA PIREX USA VIDRIO BOROSILICATO AUTOCLAV.";
drFilaGuiaRemisionDetalle3.precio = Convert.ToDecimal("2004.23000");
dsReporte.GuiaRemisionDetalle.AddGuiaRemisionDetalleRow(drFilaGuiaRemisionDetalle3);
}
//dsReportes.ParametroRow drFilaParametro = dsReporte.Parametro.NewParametroRow();
//drFilaParametro.IdReporte = 1;
//drFilaParametro.empresa = "EMPRESA";
//drFilaParametro.titulo1 = "ORDEN DE COMPRA N° " + objOrdenCompra.NumeroOrdenCompra;
//dsReporte.Parametro.AddParametroRow(drFilaParametro);
//dsReportes.OrdenCompraRow dsFilaOrdenCompra = dsReporte.OrdenCompra.NewOrdenCompraRow();
//dsFilaOrdenCompra.IdReporte = 1;
//dsFilaOrdenCompra.IdOrdenCompra = objOrdenCompra.IdOrdenCompra;
//dsFilaOrdenCompra.Proyecto = objOrdenCompra.NombreProyecto;
//dsFilaOrdenCompra.RazonSocial = objOrdenCompra.RazonSocial;
//dsFilaOrdenCompra.Moneda = objOrdenCompra.NombreMoneda;
//dsFilaOrdenCompra.Subtotal = objOrdenCompra.ImporteOrdenCompra;
////MONTO DE IGV
//IgvDTO IGVDTO = objIGVDAO.ListarIGVVigente(objOrdenCompra.FechaOrdenCompra);
//dsFilaOrdenCompra.IGV = dsFilaOrdenCompra.Subtotal * IGVDTO.Igv;
//dsFilaOrdenCompra.Total = dsFilaOrdenCompra.Subtotal + dsFilaOrdenCompra.IGV;
//dsReporte.OrdenCompra.AddOrdenCompraRow(dsFilaOrdenCompra);
//foreach (OrdenCompraLineaDTO linea in objOrdenCompraLinea)
//{
// dsReportes.OrdenCompraLineasRow drFilaOrdenCompraLinea = dsReporte.OrdenCompraLineas.NewOrdenCompraLineasRow();
// drFilaOrdenCompraLinea.IdReporte = 1;
// drFilaOrdenCompraLinea.IdOrdenCompra = objOrdenCompra.IdOrdenCompra;
// drFilaOrdenCompraLinea.Linea = linea.NumeroLinea;
// drFilaOrdenCompraLinea.Cantidad = linea.Cantidad;
// drFilaOrdenCompraLinea.UnidadMedida = linea.NombreUnidadMedida;
// drFilaOrdenCompraLinea.DescripcionLinea = linea.DescripcionLinea;
// drFilaOrdenCompraLinea.PrecioUnitario = linea.Precio;
// drFilaOrdenCompraLinea.Importe = linea.Importe;
// dsReporte.OrdenCompraLineas.AddOrdenCompraLineasRow(drFilaOrdenCompraLinea);
//}
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>");
//Response.Write("<script language='javascript'>window.open('" + strRutaWeb + "frmOrdenCompraImpresion.aspx?id=" + IdOrdenCompra.ToString() + "','ventana','scrollbars=1,resizable=1,width=800,height=600,left=20,top=0');</script>");
//Response.Write("<script language='javascript'>JS_openWindow('" + strRutaWeb + "frmOrdenCompraImpresion.aspx?id=" + IdOrdenCompra.ToString() + "','Reporte','600','300','no', 'no', 'no', 'no', 'no');</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
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();
if (Session["lote"] == null)
{
Response.Redirect("~/Inicio.aspx");
}
else
{
try
{
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/lote_comprobantes.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "lote_comprobantes.xsd", true);
string imagen = Server.MapPath("~/Facturacion/Electronica/Reportes/Imagen.xsd");
System.IO.File.Copy(imagen, @System.IO.Path.GetTempPath() + "Imagen.xsd", true);
facturaRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/Factura.rpt");
facturaRpt.Load(reportPath);
FeaEntidades.InterFacturas.lote_comprobantes lc = (FeaEntidades.InterFacturas.lote_comprobantes)Session["lote"];
AsignarCamposOpcionales(lc);
ReemplarResumenImportesMonedaExtranjera(lc);
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(lc.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, lc);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
bool original = true;
try
{
original = (bool)Session["EsComprobanteOriginal"];
if (original == false)
{
facturaRpt.DataDefinition.FormulaFields["Borrador"].Text = "'BORRADOR'";
}
}
catch
{
}
facturaRpt.SetDataSource(ds);
facturaRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
facturaRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
IncrustarLogo(lc.cabecera_lote.cuit_vendedor.ToString(), lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString());
string cae = lc.comprobante[0].cabecera.informacion_comprobante.cae;
if (cae.Replace(" ",string.Empty).Equals(string.Empty))
{
cae = "99999999999999";
}
GenerarCodigoBarras(lc.cabecera_lote.cuit_vendedor + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00") + lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000") + cae +System.DateTime.Now.ToString("yyyyMMdd"));
AsignarParametros(lc.comprobante[0].resumen.importe_total_factura);
facturaRpt.Subreports["impuestos"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
facturaRpt.Subreports["resumen"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(lc.cabecera_lote.cuit_vendedor);
sb.Append("-");
sb.Append(lc.cabecera_lote.punto_de_venta.ToString("0000"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.numero_comprobante.ToString("00000000"));
if (original == false)
{
sb.Append("-BORRADOR");
}
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;
facturaRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: " + ex.Message + " " + ex.StackTrace);
throw new Exception(ex.Message);
//WebForms.Excepciones.Redireccionar(ex, "~/Excepciones/Excepciones.aspx");
}
}
}
//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;
}
//匯出Excel
private void ShowReportB(DataTable dt)
{
#region 利用CrystalReport匯出Excel
//使用者名稱
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath("./REPORT/ITM061/ITM062R01.rpt"));
report.SetDataSource(dt);
//檔案匯出
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=" + HttpUtility.UrlEncode("商品期別異動表_" + System.DateTime.Now.Year.ToString() + System.DateTime.Now.Month.ToString() + System.DateTime.Now.Day.ToString() + ".XLS", System.Text.Encoding.UTF8));//匯出檔名
Response.ContentType = "application/xls";
Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length);
Response.Flush();
Response.Close();
report.Close();
#endregion
}
private void IncrustarLogo(string cuit, string PtoVta)
{
try
{
String path = Server.MapPath("~/ImagenesSubidas/");
string[] archivos = System.IO.Directory.GetFiles(path, cuit + "-" + PtoVta + ".*", System.IO.SearchOption.TopDirectoryOnly);
string imagenCUIT = "";
if (archivos.Length > 0)
{
imagenCUIT = "~/ImagenesSubidas/" + archivos[0].Replace(Server.MapPath("~/ImagenesSubidas/"), String.Empty);
}
else
{
archivos = System.IO.Directory.GetFiles(path, cuit + ".*", System.IO.SearchOption.TopDirectoryOnly);
imagenCUIT = "";
if (archivos.Length > 0)
{
imagenCUIT = "~/ImagenesSubidas/" + archivos[0].Replace(Server.MapPath("~/ImagenesSubidas/"), String.Empty);
}
}
if (imagenCUIT != "")
{
FileStream FilStr = new FileStream(Server.MapPath(imagenCUIT), FileMode.Open);
CrearTabla();
BinaryReader BinRed = new BinaryReader(FilStr);
DataRow dr = this.dsImages.Tables["images"].NewRow();
dr["path"] = Server.MapPath(imagenCUIT);
dr["image"] = BinRed.ReadBytes((int)BinRed.BaseStream.Length);
this.dsImages.Tables["images"].Rows.Add(dr);
FilStr.Close();
BinRed.Close();
imagenRpt = facturaRpt.OpenSubreport("Imagen.rpt");
imagenRpt.SetDataSource(this.dsImages);
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: Imagen OK" );
}
}
catch (Exception ex)
{
string a = ex.Message.ToString().Replace("'", " ");
a = a.Replace("<", " ");
a = a.Replace(">", " ");
a = a.Replace("/", " ");
a = a.Replace(@"\", " ");
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: Imagen NOT OK " + a);
}
}
/// <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 ShowReport(DataSet ds)
{
#region 利用CrystalReport列印報表
//使用者名稱
DataTable dt1 = new DataTable();
dt1 = (DataTable)Session["UserInfo"];
string Login_Name = dt1.Rows[0]["Name"].ToString();
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath("./REPORT/ITM061R.rpt"));
report.SetDataSource(ds);
report.Subreports["ITM061R2"].SetDataSource(ds);
report.Subreports["ITM061R3"].SetDataSource(ds);
report.SetParameterValue("ProgramName", "ITM061R");
report.SetParameterValue("UserName", Session["UID"].ToString() + Login_Name);
if (this.txtCREATEDATE.StartDate.ToString() == "" && this.txtCREATEDATE.EndDate.ToString() == "")
report.SetParameterValue("QueryDateRange", "全部");
else
report.SetParameterValue("QueryDateRange", this.txtCREATEDATE.StartDate.ToString() + "~" + this.txtCREATEDATE.EndDate.ToString());
if (this.SLP_TimeRange1.StartTime.ToString() == "" && this.SLP_TimeRange1.EndTime.ToString() == "")
report.SetParameterValue("QueryTime", "全部");
else
report.SetParameterValue("QueryTime", this.SLP_TimeRange1.StartTime.ToString() + "~" + this.SLP_TimeRange1.EndTime.ToString());
report.SetParameterValue("Par_Count", Convert.ToString(ds.Tables["DataTable1"].Rows.Count) + "筆");
//檔案匯出
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();
report.Close();
#endregion
}
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");
}
}
// 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();
}
}
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>
/// 利用 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;
string par_Chan1 = string.Empty;
string par_Chan2 = string.Empty;
string par_Chan3 = string.Empty;
#region 前置檢查與參數過濾
string par_PlanAcceptData = this.txtPLAN_ACCEPT_DATE.Text;
par_ProgramID = this.PageCode;
string Login_Name = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString();
par_LoginUser = Session["UID"].ToString() + " " + Login_Name;
if (dt_Source.Rows[0]["No1_Name"] != System.DBNull.Value)
{
par_Chan1 = dt_Source.Rows[0]["No1_Name"].ToString();
}
if (dt_Source.Rows[0]["No2_Name"] != System.DBNull.Value)
{
par_Chan2 = dt_Source.Rows[0]["No2_Name"].ToString();
}
if (dt_Source.Rows[0]["No3_Name"] != System.DBNull.Value)
{
par_Chan3 = dt_Source.Rows[0]["No3_Name"].ToString();
}
#endregion
#region 組合查詢條件至ArrayList
report.SetParameterValue("par_ProgramID", par_ProgramID);
report.SetParameterValue("par_LoginUser", par_LoginUser);
report.SetParameterValue("par_PlanAcceptDate", GetValueSetParameter(par_PlanAcceptData, "string"));
report.SetParameterValue("par_Chan1", par_Chan1);
report.SetParameterValue("par_Chan2", par_Chan2);
report.SetParameterValue("par_Chan3", par_Chan3);
#endregion
#region 判斷輸出檔案型態
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;
}
#endregion
}
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();
}
}
private void ShowReport()
{
#region
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
try
{
string strFileName = "";
report.Load(Server.MapPath("./REPORT/ALO21/ALO21R01.rpt"));
strFileName = HttpUtility.UrlEncode("轉門市進貨單明細表.pdf", System.Text.Encoding.UTF8);
#region 2010/02/11 重新查詢
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text);//門市進貨日
ParameterList.Add(SLP_SLPDate2.Text);//轉門市進貨單日
ParameterList.Add(GetDisTypeSelectedValue());//配本方式
ParameterList.Add(SLP_SLPNumber1.Text);//理貨批次
ParameterList.Add(Session["UID"].ToString());//執行者
ParameterList.Add(DateTime.Now);//執行日期
ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString()));//PageTimeStamp_LoginID :Session_ID
ParameterList.Add(-1);//最大筆數
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strErrMsg = "";
DataTable Dt = null;
if (rbtn_TransStatus1.Checked)//已轉單
{
#region
Dt = BCO.QueryStOutAcceptData(ParameterList, out strErrMsg);
#endregion
}
else//未轉單
{
#region
Dt = BCO.QueryForFind(ParameterList, out strErrMsg);
#endregion
}
#endregion
report.SetDataSource(Dt);
string Login_Name = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString();
report.SetParameterValue("par_Program_ID", "ALO21R01");
report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name);
report.SetParameterValue("par_StAcceptDate", SLP_SLPDate1.Text);
report.SetParameterValue("par_OutStAcceptDate", SLP_SLPDate2.Text);
report.SetParameterValue("par_DisType", GetDisTypeSelectedText());
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;
}
finally
{
report.Close();
}
#endregion
}
//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 列印報表
/// </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_PlanAcceptDate = string.Empty;
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();
if (dt_Source2.Rows.Count != 0)
{
par_PlanAcceptDate = dt_Source2.Rows[0]["PLAN_ACCEPT_DATE"].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);
if (par_PlanAcceptDate.Trim() != "")
{
report.SetParameterValue("par_PlanAcceptDate", GetValueSetParameter(par_PlanAcceptDate, "date"));
}
else
{
report.SetParameterValue("par_PlanAcceptDate", "");
}
#endregion
#region 判斷輸出檔案型態
try
{
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);
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
break;
default:
break;
}
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
}
finally
{
report.Close();
}
#endregion
}
protected void InicializaPagina()
{
int linea = 0;
string id = Request.QueryString["id"].ToString();
string id2 = Request.QueryString["id2"].ToString();
Decimal dStockArticulo = 0;
List<InvTransaccionDTO> objTransaccionLista = objTransaccionDAO.ListarPorArticuloProyecto(Convert.ToInt32(id), Convert.ToInt32(id2));
ParametroDTO objParametroDTO = objParametroDAO.ListarPorClave(1);
ArticuloDTO objArticuloDTO = objArticuloDAO.ListarPorClave(Convert.ToInt32(id));
InvUnidadMedidaDTO objInvUnidadMedidaDTO = objUnidadMedidaDAO.ListarPorClave(objArticuloDTO.IdUnidadMedida);
ProyectoDTO objProyectoDTO = objProyectoDAO.ListarPorClave(Convert.ToInt32(id2));
dsReportes dsReporte = new dsReportes();
dsReportes.ParametroRow drParametroRow = dsReporte.Parametro.NewParametroRow();
drParametroRow.id_reporte = 1;
drParametroRow.empresa = objParametroDTO.RazonSocial;
drParametroRow.fecha = DateTime.Now.ToString("dd/MM/yyyy");
dsReporte.Parametro.AddParametroRow(drParametroRow);
foreach (InvTransaccionDTO fila in objTransaccionLista)
{
InvTipoTransaccionDTO objInvTipoTransaccionDTO = objTipoTransaccionDAO.ListarPorClave(fila.IdTipoTransaccion);
dsReportes.KardexRow drKardexRow = dsReporte.Kardex.NewKardexRow();
linea = linea + 1;
drKardexRow.id_reporte = 1;
drKardexRow.linea = linea;
drKardexRow.fecha = fila.Fecha.ToString("dd/MM/yyyy");
drKardexRow.nombre_articulo = objArticuloDTO.Descripcion;
drKardexRow.codigo_articulo = objArticuloDTO.CodigoArticulo;
drKardexRow.unidad_medida = objInvUnidadMedidaDTO.NombreUnidadMedida;
drKardexRow.area = objProyectoDTO.NombreProyecto;
drKardexRow.observaciones = fila.Descripcion;// objInvTipoTransaccionDTO.NombreTransaccion;
if (objInvTipoTransaccionDTO.Clase.Equals("I"))
{
dStockArticulo += fila.Cantidad;
drKardexRow.entrada = fila.Cantidad;
drKardexRow.saldo = dStockArticulo;
}
else
{
dStockArticulo -= fila.Cantidad;
drKardexRow.salida = fila.Cantidad;
drKardexRow.saldo = dStockArticulo;
}
dsReporte.Kardex.AddKardexRow(drKardexRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("KardexArticulo.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();
}
protected void btnPrint_Click(object sender, EventArgs e)
{
DataSet print = new DataSet();
print.Tables.Add("order");
print.Tables[0].Columns.Add("number");
print.Tables[0].Columns.Add("date");
print.Tables[0].Columns.Add("firstName");
print.Tables[0].Columns.Add("lastName");
print.Tables[0].Columns.Add("name");
print.Tables[0].Columns.Add("pib");
print.Tables[0].Columns.Add("address");
print.Tables[0].Columns.Add("city");
print.Tables[0].Columns.Add("zip");
print.Tables[0].Columns.Add("email");
print.Tables[0].Columns.Add("phone");
print.Tables[0].Columns.Add("comment");
print.Tables[0].Columns.Add("payment");
print.Tables[0].Columns.Add("delivery");
print.Tables[0].Columns.Add("total");
print.Tables[0].Columns.Add("code");
print.Tables.Add("orderItem");
print.Tables[1].Columns.Add("code");
print.Tables[1].Columns.Add("name");
print.Tables[1].Columns.Add("webPrice");
print.Tables[1].Columns.Add("userPrice");
print.Tables[1].Columns.Add("quantity");
print.Tables[1].Columns.Add("total");
DataRow newRow = print.Tables[0].NewRow();
newRow["number"] = "1";
newRow["date"] = lblDate.Text;
newRow["firstName"] = lblFirstname.Text;
newRow["lastName"] = lblLastname.Text;
newRow["name"] = lblName.Text;
newRow["pib"] = lblPib.Text;
newRow["address"] = lblAddress.Text;
newRow["city"] = lblCity.Text;
newRow["zip"] = lblZip.Text;
newRow["email"] = lblEmail.Text;
newRow["phone"] = lblPhone.Text;
newRow["comment"] = lblComment.Text;
newRow["payment"] = lblPayment.Text;
newRow["delivery"] = lblDelivery.Text;
newRow["total"] = lblTotal.Text;
newRow["code"] = lblCode.Text;
print.Tables[0].Rows.Add(newRow);
for (int i = 0; i < dgvItems.Rows.Count; i++)
{
newRow = print.Tables[1].NewRow();
newRow["code"] = ((Label)dgvItems.Rows[i].FindControl("lblProductCode")).Text;
newRow["name"] = ((Label)dgvItems.Rows[i].FindControl("lblProductName")).Text;
newRow["webPrice"] = ((Label)dgvItems.Rows[i].FindControl("lblWebPrice")).Text;
newRow["userPrice"] = ((Label)dgvItems.Rows[i].FindControl("lblPrice")).Text;
newRow["quantity"] = ((Label)dgvItems.Rows[i].FindControl("lblQuantity")).Text;
newRow["total"] = ((Label)dgvItems.Rows[i].FindControl("lblTotal")).Text;
print.Tables[1].Rows.Add(newRow);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument rp = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rp.Load(Server.MapPath("~") + "/administrator/reports/rptOrder.rpt");
rp.SetDataSource(print);
Session.Add("orderRp", rp);
Response.Redirect("/administrator/print.aspx");
}
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);
}
}
/// <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
}
/// <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
}
/// <summary>
/// 產生輸出檔案
/// </summary>
/// <param name="s_FileName">產生檔案檔名</param>
/// <param name="s_rptFilePath">RPT報表檔路徑及檔名</param>
/// <param name="dt_Source">DB抓取的資料集(DataTable)</param>
/// <param name="RP">報表變數,如無變數請輸入null</param>
/// <param name="ROF">報表格式</param>
public void LoadCrystalReport(string s_FileName,
string s_rptFilePath,
ref DataTable dt_Source,
ReportParameter[] RP,
string ReportOutputFormat
)
{
int bytesRead = 0;
FileStream FS = new FileStream(s_FileName, FileMode.Create, FileAccess.Write);
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
try
{
report.Load(s_rptFilePath);
report.SetDataSource(dt_Source);
//判斷輸出檔案型態
switch (ReportOutputFormat)
{
case "EXCEL":
//如果有報表參數
if (RP != null)
{
for (int i = 0; i < RP.Length; i++)
{
if ((RP[i].ParameterName != "") && (RP[i].ParameterValue != null))
{
report.SetParameterValue(RP[i].ParameterName, RP[i].ParameterValue);
}
}
}
Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytesXLS;
try
{
bytesXLS = new byte[streamXLS.Length];
bytesRead = streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
//export file
while (bytesRead > 0)
{
FS.Write(bytesXLS, 0, bytesRead);
bytesRead = streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
bytesXLS = null;
streamXLS.Flush();
streamXLS.Close();
streamXLS.Dispose();
}
break;
case "PDF":
//如果有報表參數
if (RP != null)
{
for (int i = 0; i < RP.Length; i++)
{
if ((RP[i].ParameterName != "") && (RP[i].ParameterValue != null))
{
report.SetParameterValue(RP[i].ParameterName, RP[i].ParameterValue);
}
}
}
Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF;
try
{
bytesPDF = new byte[streamPDF.Length];
bytesRead = streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
//streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
while (bytesRead > 0)
{
FS.Write(bytesPDF, 0, bytesRead);
bytesRead = streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
bytesPDF = null;
streamPDF.Flush();
streamPDF.Close();
streamPDF.Dispose();
}
break;
default:
break;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
FS.Flush();
FS.Close();
FS.Dispose();
report.Close();
report.Dispose();
dt_Source.Dispose();
}
}