public ActionResult ExportData_View(decimal pAppHeaderId, string p_appCode, decimal p_View_Translate) { try { string language = AppsCommon.GetCurrentLang(); App_Detail_PLB01_SDD_BL objBL = new App_Detail_PLB01_SDD_BL(); ApplicationHeaderInfo applicationHeaderInfo = new ApplicationHeaderInfo(); App_Detail_PLB01_SDD_Info app_Detail = new App_Detail_PLB01_SDD_Info(); List <AppFeeFixInfo> appFeeFixInfos = new List <AppFeeFixInfo>(); List <AppDocumentInfo> appDocumentInfos = new List <AppDocumentInfo>(); app_Detail = objBL.GetByID(pAppHeaderId, language, ref applicationHeaderInfo, ref appDocumentInfos, ref appFeeFixInfos); AppsCommon.Prepare_Data_Export_3B(ref app_Detail, applicationHeaderInfo, appDocumentInfos); List <App_Detail_PLB01_SDD_Info> _lst = new List <App_Detail_PLB01_SDD_Info>(); _lst.Add(app_Detail); DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_PLB01_SDD_Info>(_lst, false); //_ds_all.WriteXml(@"C:\inetpub\B01.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string _tempfile = "TM_PLB01SDD.rpt"; string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); if (p_View_Translate == 1) { // nếu là tiếng việt thì xem bản tiếng anh và ngược lại if (applicationHeaderInfo.Languague_Code == Language.LangVI) { _tempfile = "TM_PLB01SDD_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"; } } else { if (applicationHeaderInfo.Languague_Code == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"; } else { _tempfile = "TM_PLB01SDD_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"; } } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; // đè các bản dịch lên if (p_View_Translate == 1) { // nếu là bản xem của thằng dịch App_Translate_BL _App_Translate_BL = new App_Translate_BL(); List <App_Translate_Info> _lst_translate = _App_Translate_BL.App_Translate_GetBy_AppId(pAppHeaderId); AppsCommon.Overwrite_DataSouce_Export(ref _ds_all, _lst_translate); } oRpt.Database.Tables["Table"].SetDataSource(_ds_all.Tables[0]); //oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(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 })); } }
/// <summary> /// 按账务期统计 /// </summary> public void m_mthButtonClickToStatistic() { string p_strPriodId = ""; clsPeriod_VO[] objPriodItems = this.m_objViewer.m_cboSelPeriod.Tag as clsPeriod_VO[]; if (this.m_objViewer.m_cboSelPeriod.SelectedItem == null) { MessageBox.Show("请选择账务期"); return; } if (this.m_objViewer.m_cboSelPeriod.Text != "所有财务期的数据") { p_strPriodId = objPriodItems[this.m_objViewer.m_cboSelPeriod.SelectedIndex - 1].m_strPeriodID; } DataTable dtbStatistic; long lngRes = 0; lngRes = this.m_objManage.m_lngGetStatiticsData(out dtbStatistic, p_strPriodId); System.Data.DataColumn dc = new DataColumn("SEQUENCEID"); dtbStatistic.Columns.Add(dc); if (dtbStatistic.Rows.Count != 0) { for (int j1 = 0; j1 < dtbStatistic.Rows.Count; j1++) { dtbStatistic.Rows[j1]["SEQUENCEID"] = j1 + 1; } } if (lngRes < 0) { return; } else { CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rpt.Load("Report\\CrystalReportHisMedInOrderStaticstic.rpt"); // HISMedTypeManage.Rpt.CrystalReportHisMedInOrderStaticstic rpt = new HISMedTypeManage.Rpt.CrystalReportHisMedInOrderStaticstic(); ((TextObject)rpt.ReportDefinition.ReportObjects["Text11"]).Text = this.m_objViewer.m_cboSelPeriod.SelectedText; double totalMoney = 0; if (dtbStatistic.Rows.Count > 0) { for (int i1 = 0; i1 < dtbStatistic.Rows.Count; i1++) { totalMoney += Convert.ToDouble(dtbStatistic.Rows[i1]["TOLMNY_MNY"].ToString().Trim()); } //((TextObject)rpt.ReportDefinition.ReportObjects["Text9"]).Text = totalMoney.ToString("######.00"); } else { //((TextObject)rpt.ReportDefinition.ReportObjects["Text9"]).Text = "0.00"; } ((TextObject)rpt.ReportDefinition.ReportObjects["Text11"]).Text = this.m_objViewer.m_cboSelPeriod.Text; rpt.SetDataSource(dtbStatistic); rpt.Refresh(); this.m_objViewer.m_crystalReportViewer1.ReportSource = rpt; } }
public void m_mthFindByDateReport() { str_firstDate = m_objViewer.m_daFinDate.Value.ToShortDateString(); str_lasttDate = m_objViewer.m_daFinDateLast.Value.ToShortDateString(); m_rptRpt.Load("Report\\AllOPREMP_month.rpt"); DataTable m_dtRpt = new DataTable(); DataTable m_dtRptDitial = new DataTable(); long lngRes; lngRes = clsDomain.m_lngChargeMnothReport(str_firstDate, str_lasttDate, out m_dtRpt); if (lngRes >= 1) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtReportTitle"]).Text = this.m_objComInfo.m_strGetHospitalTitle() + "收费处月结算表"; ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["dateArear"]).Text = "统计日期: " + str_firstDate + " 至 " + str_lasttDate; m_rptRpt.SetDataSource(m_dtRpt); m_rptRpt.Refresh(); m_objViewer.cryReportViewer.ReportSource = m_rptRpt; } }
public void m_mthFindByDateReport() { str_firstDate = m_objViewer.m_daFinDate.Value.ToShortDateString(); str_lastDate = m_objViewer.m_daFinDateLast.Value.ToShortDateString(); m_rptRpt.Load("Report\\rpt_medicineProtect.rpt"); DataTable m_dtRpt = new DataTable(); DataTable m_dtRptDitial = new DataTable(); long lngRes; lngRes = clsDomain.m_lngMeditionProtectReport(str_firstDate, str_lastDate, out m_dtRpt); if (lngRes >= 1) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["acceptDate"]).Text = "就诊年月: " + Convert.ToDateTime(str_lastDate).Year + "-" + Convert.ToDateTime(str_lastDate).Month; //((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtReportTitle"]).Text = this.m_objComInfo.m_strGetHospitalTitle() + "医保月结算表"; ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtReportTitle"]).Text = "城镇职工基本医疗月报表"; ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["unitName"]).Text = "单位名称: " + this.m_objComInfo.m_strGetHospitalTitle(); m_rptRpt.SetDataSource(m_dtRpt); m_rptRpt.Refresh(); m_objViewer.cryReportViewer.ReportSource = m_rptRpt; } }
/// <summary> /// 统计操作 /// </summary> public void m_mthButtonClickToStatistic() { DataTable dtbStatistic; string dtmStart = this.m_objViewer.m_dateTimePickerbegin.Value.ToShortDateString(); string dtmEnd = this.m_objViewer.m_dateTimePickerEnd.Value.ToShortDateString(); long lngRes = this.m_objManage.m_lngGetStatiticsData(dtmStart, dtmEnd, out dtbStatistic); if (lngRes < 0) { return; } else { CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rpt.Load("Report\\CrystalReportOutPatient.rpt"); // HISMedTypeManage.Rpt.CrystalReportOutPatient rpt = new HISMedTypeManage.Rpt.CrystalReportOutPatient(); ((TextObject)rpt.ReportDefinition.ReportObjects["Text7"]).Text = this.m_objViewer.m_dateTimePickerbegin.Value.ToShortDateString(); ((TextObject)rpt.ReportDefinition.ReportObjects["Text8"]).Text = this.m_objViewer.m_dateTimePickerEnd.Value.ToShortDateString(); if (dtbStatistic.Rows.Count > 0) { double totalMoney = 0; for (int i1 = 0; i1 < dtbStatistic.Rows.Count; i1++) { totalMoney += Convert.ToDouble(dtbStatistic.Rows[i1]["TOTALMONEY"].ToString().Trim()); } ((TextObject)rpt.ReportDefinition.ReportObjects["Text13"]).Text = totalMoney.ToString(); } else { MessageBox.Show("无统计数据!"); return; } //((TextObject)rpt.ReportDefinition.ReportObjects["Text13"]).Text = rpt.SetDataSource(dtbStatistic); rpt.Refresh(); this.m_objViewer.m_crystalReportViewer1.ReportSource = rpt; } }
public void m_mthFindByDateReport() { str_firstDate = m_objViewer.m_daFinDate.Value.ToShortDateString(); str_toDate = m_objViewer.m_toDate.Value.ToShortDateString(); m_rptRpt.Load("Report\\rptPublicPay.rpt"); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtReportTitle"]).Text = this.m_objComInfo.m_strGetHospitalTitle() + "公费费用报表"; DataTable m_dtRpt = new DataTable(); DataTable m_dtRptDitial = new DataTable(); if (m_objViewer.m_chbPatienName.Checked == true && m_objViewer.m_chbDate.Checked == true) { m_intFindType = 1; } else if (m_objViewer.m_chbPatienName.Checked == true && m_objViewer.m_chbDate.Checked == false) { m_intFindType = 2; } else if (m_objViewer.m_chbPatienName.Checked == false && m_objViewer.m_chbDate.Checked == true) { m_intFindType = 3; } else { m_intFindType = 4; } long lngRes; lngRes = clsDomain.m_lngPublicPayReport(m_intFindType, m_objViewer.m_txtName.Text.Trim(), str_firstDate, str_toDate, out m_dtRpt); if (lngRes >= 1) { m_rptRpt.SetDataSource(m_dtRpt); m_rptRpt.Refresh(); m_objViewer.cryReportViewer.ReportSource = m_rptRpt; } }
public void m_mthFindByDateReport() { for (int i = 0; i < 17; i++) { Doe_[i] = 0; } str_firstDate = m_objViewer.m_daFinDate.Value.ToShortDateString(); str_lasttDate = m_objViewer.m_daFinDateLast.Value.ToShortDateString(); m_rptRpt.Load("Report\\rptDepWork.rpt"); DataTable m_dtRpt = new DataTable(); DataTable m_dtRptDitial = new DataTable(); long lngRes; lngRes = clsDomain.m_lngChargeMnothReport(str_firstDate, str_lasttDate, out m_dtRpt); if (lngRes >= 1) { m_rptRpt.SetDataSource(m_dtRpt); m_rptRpt.Refresh(); m_objViewer.cryReportViewer.ReportSource = m_rptRpt; } }
public void m_mthFindByDateReport() { for (int i = 3; i < 47; i++) { Doe_[i] = 0; } str_firstDate = m_objViewer.m_daFinDate.Value.ToShortDateString(); m_intSelectedIndex = 0; m_rptRpt.Load("Report\\OPREMP_day.rpt"); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtReportTitle"]).Text = this.m_objComInfo.m_strGetHospitalTitle() + "操作员日实收数报表"; m_dtRpt = new DataTable(); m_dtRptDitial = new DataTable(); long lngRes; if (this.m_objViewer.LoginInfo != null) { strEmployee = this.m_objViewer.LoginInfo.m_strEmpID; strEmployeeName = this.m_objViewer.LoginInfo.m_strEmpName; } lngRes = clsDomain.m_lngFindByDateReport(m_intSelectedIndex, strEmployee, str_firstDate, out m_dtRpt, out m_dtRptDitial); if (lngRes >= 1) { for (int i = 0; i < m_dtRptDitial.Rows.Count; i++) { #region 统计 switch (m_dtRptDitial.Rows[i]["ITEMCATID_CHR"].ToString().Trim()) { case "1003": Doe_[3] = Doe_[3] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1004": Doe_[4] = Doe_[4] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1005": Doe_[5] = Doe_[5] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1006": Doe_[6] = Doe_[6] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1007": Doe_[7] = Doe_[7] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1008": Doe_[8] = Doe_[8] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1009": Doe_[9] = Doe_[9] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1010": Doe_[10] = Doe_[10] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1011": Doe_[11] = Doe_[11] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1012": Doe_[12] = Doe_[12] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1013": Doe_[13] = Doe_[13] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1014": Doe_[14] = Doe_[14] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1015": Doe_[15] = Doe_[15] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1016": Doe_[16] = Doe_[16] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1017": Doe_[17] = Doe_[17] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1018": Doe_[18] = Doe_[18] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1019": Doe_[19] = Doe_[19] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1020": Doe_[20] = Doe_[20] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1021": Doe_[21] = Doe_[21] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1022": Doe_[22] = Doe_[22] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1023": Doe_[23] = Doe_[23] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1024": Doe_[24] = Doe_[24] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1025": Doe_[25] = Doe_[25] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1026": Doe_[26] = Doe_[26] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1027": Doe_[27] = Doe_[27] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1028": Doe_[28] = Doe_[28] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1029": Doe_[29] = Doe_[29] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1030": Doe_[30] = Doe_[30] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1031": Doe_[31] = Doe_[31] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1032": Doe_[32] = Doe_[32] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1033": Doe_[33] = Doe_[33] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1034": Doe_[34] = Doe_[34] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1035": Doe_[35] = Doe_[35] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1036": Doe_[36] = Doe_[36] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1037": Doe_[37] = Doe_[37] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1038": Doe_[38] = Doe_[38] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1039": Doe_[39] = Doe_[39] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1040": Doe_[40] = Doe_[40] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1041": Doe_[41] = Doe_[41] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1042": Doe_[42] = Doe_[42] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1043": Doe_[43] = Doe_[43] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1044": Doe_[44] = Doe_[44] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1045": Doe_[45] = Doe_[45] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; case "1046": Doe_[46] = Doe_[46] + Convert.ToDouble(m_dtRptDitial.Rows[i]["TOLFEE_MNY"]); break; } #endregion } } #region 付值 if (Doe_[3] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe03"]).Text = Doe_[3].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe03"]).Text = ""; } if (Doe_[4] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe04"]).Text = Doe_[4].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe04"]).Text = ""; } if (Doe_[5] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe05"]).Text = Doe_[5].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe05"]).Text = ""; } if (Doe_[6] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe06"]).Text = Doe_[6].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe06"]).Text = ""; } if (Doe_[7] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe07"]).Text = Doe_[7].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe07"]).Text = ""; } if (Doe_[8] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe08"]).Text = Doe_[8].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe08"]).Text = ""; } if (Doe_[9] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe09"]).Text = Doe_[9].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe09"]).Text = ""; } if (Doe_[10] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe10"]).Text = Doe_[10].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe10"]).Text = ""; } if (Doe_[11] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe11"]).Text = Doe_[11].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe11"]).Text = ""; } if (Doe_[12] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe12"]).Text = Doe_[12].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe12"]).Text = ""; } if (Doe_[13] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe13"]).Text = Doe_[13].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe13"]).Text = ""; } if (Doe_[14] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe14"]).Text = Doe_[14].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe14"]).Text = ""; } if (Doe_[15] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe15"]).Text = Doe_[15].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe15"]).Text = ""; } if (Doe_[16] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe16"]).Text = Doe_[16].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe16"]).Text = ""; } if (Doe_[17] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe17"]).Text = Doe_[17].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe17"]).Text = ""; } if (Doe_[18] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe18"]).Text = Doe_[18].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe18"]).Text = ""; } if (Doe_[19] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe19"]).Text = Doe_[19].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe19"]).Text = ""; } if (Doe_[20] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe20"]).Text = Doe_[20].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe20"]).Text = ""; } if (Doe_[21] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe21"]).Text = Doe_[21].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe21"]).Text = ""; } if (Doe_[22] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe22"]).Text = Doe_[22].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe22"]).Text = ""; } if (Doe_[23] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe23"]).Text = Doe_[23].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe23"]).Text = ""; } if (Doe_[24] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe24"]).Text = Doe_[24].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe24"]).Text = ""; } if (Doe_[25] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe25"]).Text = Doe_[25].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe25"]).Text = ""; } if (Doe_[26] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe26"]).Text = Doe_[26].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe26"]).Text = ""; } if (Doe_[27] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe27"]).Text = Doe_[27].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe27"]).Text = ""; } if (Doe_[28] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe28"]).Text = Doe_[28].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe28"]).Text = ""; } if (Doe_[29] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe29"]).Text = Doe_[29].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe29"]).Text = ""; } if (Doe_[30] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe30"]).Text = Doe_[30].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe30"]).Text = ""; } if (Doe_[31] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe31"]).Text = Doe_[31].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe31"]).Text = ""; } if (Doe_[32] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe32"]).Text = Doe_[32].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe32"]).Text = ""; } if (Doe_[33] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe33"]).Text = Doe_[33].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe33"]).Text = ""; } if (Doe_[34] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe34"]).Text = Doe_[34].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe34"]).Text = ""; } if (Doe_[35] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe35"]).Text = Doe_[35].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe35"]).Text = ""; } if (Doe_[36] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe36"]).Text = Doe_[36].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe36"]).Text = ""; } if (Doe_[37] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe37"]).Text = Doe_[37].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe37"]).Text = ""; } if (Doe_[38] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe38"]).Text = Doe_[38].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe38"]).Text = ""; } if (Doe_[39] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe39"]).Text = Doe_[39].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe39"]).Text = ""; } if (Doe_[40] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe40"]).Text = Doe_[40].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe40"]).Text = ""; } if (Doe_[41] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe41"]).Text = Doe_[41].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe41"]).Text = ""; } if (Doe_[42] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe42"]).Text = Doe_[42].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe42"]).Text = ""; } if (Doe_[43] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe43"]).Text = Doe_[43].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe43"]).Text = ""; } if (Doe_[44] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe44"]).Text = Doe_[44].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe44"]).Text = ""; } if (Doe_[45] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe45"]).Text = Doe_[45].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe45"]).Text = ""; } if (Doe_[46] != 0) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe46"]).Text = Doe_[46].ToString("0.00"); } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["doe46"]).Text = ""; } #endregion ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["acceptDate"]).Text = "实收日期: " + m_objViewer.m_daFinDate.Value.ToShortDateString(); if (m_dtRpt.Rows.Count >= 1) { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["INVOICENO"]).Text = "发票号: " + m_dtRpt.Rows[0]["INVOICENO_VCHR"].ToString().Trim() + " - " + m_dtRpt.Rows[m_dtRpt.Rows.Count - 1]["INVOICENO_VCHR"].ToString().Trim(); this.m_objViewer.m_btnPrint.Enabled = true; } else { ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["INVOICENO"]).Text = "发票号: "; } m_rptRpt.SetDataSource(m_dtRpt); m_rptRpt.Refresh(); m_objViewer.cryReportViewer.ReportSource = m_rptRpt; }
// <JG> 03/08/2017 externalisation méthode export PDF static internal void ExportPDF(string report_path, Model.Sage.Piece Piece, uint TypeDoc, String CT_Num, string temp_file) { #region PDF CrystalDecisions.CrystalReports.Engine.ReportDocument Etat = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); Etat.Load(report_path); if (Etat.ParameterFields.Count == 0) { Etat.RecordSelectionFormula = "{Commande.DO_Piece} = '" + Piece.DO_Piece + "'"; } // fonctions avec application sur les sous-états Core.PrintCrystal.Logon(Etat, Core.Global.GetConnectionInfos().SageServer, Core.Global.GetConnectionInfos().SageIntegratedSecurity, Core.Global.GetConnectionInfos().SageDatabase, Core.Global.GetConnectionInfos().SageSQLUser, Core.Global.GetConnectionInfos().SageSQLPass); Etat.Refresh(); if (Etat.ParameterFields.Count > 0) { Etat.SetParameterValue("piece", Piece.DO_Piece); } Etat.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, temp_file); Etat.Close(); if (Core.Global.GetConfig().ModuleAECInvoiceHistoryArchivePDFActive && System.IO.Directory.Exists(Core.Global.GetConfig().ModuleAECInvoiceHistoryArchivePDFFolder)) { string path = null; if (!string.IsNullOrWhiteSpace(CT_Num)) { path = System.IO.Path.Combine(Core.Global.GetConfig().ModuleAECInvoiceHistoryArchivePDFFolder, CT_Num); if (!System.IO.Directory.Exists(path)) { System.IO.Directory.CreateDirectory(path); } switch (TypeDoc) { case 1: path = System.IO.Path.Combine(path, "Order"); break; case 7: path = System.IO.Path.Combine(path, "Invoice"); break; default: break; } if (!System.IO.Directory.Exists(path)) { System.IO.Directory.CreateDirectory(path); } path = System.IO.Path.Combine(path, Piece.DO_Piece + ".pdf"); } if (path != null) { System.IO.File.Copy(temp_file, path, true); } } #endregion }
public void RPT_Sub(Int64 PIID, string PurchaseCode, Boolean _IsList) { mpdfFile = CurrentUser.DocumentPath + @"pdf\Purchase.pdf"; DataTable dt = new DataTable(); LogoBind(dt); //if (dgvPurchaseInvoice.CurrentRow != null) //{ DataTable dtReport = new DataTable(); DataTable dtTNC = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_Code", PurchaseCode); para.Add("@i_TNC_Sub", "Purchase"); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); dtTNC = objDA.ExecuteDataTableSP("rpt_Purchase_TNC", para, false, ref mException, ref mErrorMsg, "Purchase TNC"); //NameValueCollection para = new NameValueCollection(); //para.Add("@i_RecID", Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value).ToString()); //dtReport = objList.ListOfRecord("rpt_PO", para, "PurchaseInvoice - Report"); dtReport = CommSelect.SelectRecord(PIID, "rpt_PO", "PurchaseInvoice - Report"); if (CommSelect.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoice.rpt")) { //dtblPurchaseInvoice.TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\ERP-CRM\Reports Project\POL_IGMS_Reports\DataSets\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoice.rpt"); rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC); rptDoc.Database.Tables[1].SetDataSource(dt); rptDoc.Refresh(); CurrentUser.AddReportParameters(rptDoc, dtReport, "Purchase Order", true, true, true, true, true, true, true, true, true, true, false); //CurrentUser.AddExtraParameter(rptDoc); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Purchase Order - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; if (_IsList == true) { fRptView.ShowDialog(); } else if (_IsList == false) { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = mpdfFile; CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; rptDoc.Export(); } } else { MessageBox.Show("File is not exist..."); } } }
public ActionResult ExportData_View(decimal pAppHeaderId, string p_appCode, string p_Language) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); var objBL = new C07_BL(); List<C07_Info_Export> _lst = new List<C07_Info_Export>(); List<AppDocumentInfo> appDocumentInfos = new List<AppDocumentInfo>(); List<AppFeeFixInfo> _lst_appFeeFixInfos = new List<AppFeeFixInfo>(); ApplicationHeaderInfo applicationHeaderInfo = new ApplicationHeaderInfo(); List<Other_MasterInfo> _lst_Other_MasterInfo = new List<Other_MasterInfo>(); List<AppDocumentOthersInfo> _LstDocumentOthersInfo = new List<AppDocumentOthersInfo>(); List<AppClassDetailInfo> appClassDetailInfos = new List<AppClassDetailInfo>(); C07_Info_Export pDetail = objBL.GetByID_Exp(pAppHeaderId, language, ref applicationHeaderInfo, ref appDocumentInfos, ref _lst_appFeeFixInfos, ref _lst_Other_MasterInfo, ref _LstDocumentOthersInfo, ref appClassDetailInfos); pDetail.LOGOURL = Server.MapPath(pDetail.LOGOURL); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C07_VN_" + _datetimenow + ".pdf"); if (pDetail.Languague_Code == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C07_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C07_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C07_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C07_EN_" + _datetimenow + ".pdf"; } Prepare_Data_Export_C07(ref pDetail, applicationHeaderInfo, appDocumentInfos, _lst_appFeeFixInfos, _lst_Other_MasterInfo, _LstDocumentOthersInfo, appClassDetailInfos); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet<C07_Info_Export>(_lst, false); try { _ds_all.WriteXml(@"C:\inetpub\C07.xml", XmlWriteMode.WriteSchema); } catch (Exception ex) { Logger.LogException(ex); } CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "C07.rpt"; if (p_Language == Language.LangEN) { _tempfile = "C07_EN.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); #region Set vị trí ảnh CrystalDecisions.CrystalReports.Engine.PictureObject _pic01; _pic01 = (CrystalDecisions.CrystalReports.Engine.PictureObject)oRpt.ReportDefinition.Sections[0].ReportObjects["Picture1"]; _pic01.Width = 200; _pic01.Height = 200; try { Bitmap img = new Bitmap(pDetail.LOGOURL); try { double _Const = 6.666666666666/2; int _left = 0, _top = 0, _marginleft = 225, _margintop = 5580; int _h = 600; double _d1 = (_h - img.Width) / 2; _d1 = _Const * _d1; _left = _marginleft + Convert.ToInt32(_d1); if (_left < 0) { _left = _marginleft; } _pic01.Left = _left; // top _d1 = (_h - img.Height) / 2; _d1 = _Const * _d1; _top = _margintop + Convert.ToInt32(_d1); if (_top < 0) { _top = _margintop; } _pic01.Top = _top; } catch (Exception ex) { Logger.LogException(ex); } finally { img.Dispose(); } } catch (Exception ex) { } System.IO.FileInfo file = new System.IO.FileInfo(pDetail.LOGOURL); #endregion if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); //oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, fileName_pdf); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return Json(new { success = 0 }); } catch (Exception ex) { Logger.LogException(ex); return Json(new { success = 0 }); } }
public void PrintToPrinter() { DEC.PrintToPrinter(1, false, 1, 1); DEC.Refresh(); }
public ActionResult ExportData_View(decimal pAppHeaderId, string p_appCode, string p_Language) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); var objBL = new C08_BL(); List <C08_Info_Export> _lst = new List <C08_Info_Export>(); List <AppDocumentInfo> appDocumentInfos = new List <AppDocumentInfo>(); List <AppFeeFixInfo> _lst_appFeeFixInfos = new List <AppFeeFixInfo>(); ApplicationHeaderInfo applicationHeaderInfo = new ApplicationHeaderInfo(); List <Other_MasterInfo> _lst_Other_MasterInfo = new List <Other_MasterInfo>(); List <AppDocumentOthersInfo> _LstDocumentOthersInfo = new List <AppDocumentOthersInfo>(); C08_Info_Export pDetail = objBL.GetByID_Exp(pAppHeaderId, language, ref applicationHeaderInfo, ref appDocumentInfos, ref _lst_appFeeFixInfos, ref _lst_Other_MasterInfo, ref _LstDocumentOthersInfo); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C08_VN_" + _datetimenow + ".pdf"); if (pDetail.Languague_Code == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C08_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C08_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C08_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C08_EN_" + _datetimenow + ".pdf"; } Prepare_Data_Export_C08(ref pDetail, applicationHeaderInfo, appDocumentInfos, _lst_appFeeFixInfos, _lst_Other_MasterInfo, _LstDocumentOthersInfo); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet <C08_Info_Export>(_lst, false); try { _ds_all.WriteXml(@"C:\inetpub\C08.xml", XmlWriteMode.WriteSchema); } catch (Exception ex) { Logger.LogException(ex); } CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "C08.rpt"; if (p_Language == Language.LangEN) { _tempfile = "C08_EN.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); //oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, fileName_pdf); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public ActionResult ExportData_IU(ApplicationHeaderInfo pInfo, App_Detail_PLB01_SDD_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo) { try { string language = AppsCommon.GetCurrentLang(); //string language = pInfo.View_Language_Report; string _fileTemp = System.Web.HttpContext.Current.Server.MapPath("/Content/AppForms/B01_VI.docx"); DocumentModel document = DocumentModel.Load(_fileTemp); // Fill export_header AppsCommon.Prepare_Data_Export_3B(ref pDetail, pInfo, pAppDocumentInfo); List <App_Detail_PLB01_SDD_Info> _lst = new List <App_Detail_PLB01_SDD_Info>(); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_PLB01_SDD_Info>(_lst, false); //_ds_all.Tables[0].TableName = "Table"; //_ds_all.WriteXml(@"C:\inetpub\B01.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "TM_PLB01SDD.rpt"; string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"; } else { _tempfile = "TM_PLB01SDD_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; oRpt.Database.Tables["Table"].SetDataSource(_ds_all.Tables[0]); //oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public ActionResult ExportData_View_IU(ApplicationHeaderInfo pInfo, A05_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo, List <Other_MasterInfo> pOther_MasterInfo, List <AppClassDetailInfo> pAppClassInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo ) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); var objBL = new A05_BL(); List <A05_Info_Export> _lst = new List <A05_Info_Export>(); string p_appCode = "A05_Preview"; string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "A05_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "A05_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "A05_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "A05_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "A05_EN_" + _datetimenow + ".pdf"; } A05_Info_Export _A05_Info_Export = new A05_Info_Export(); if (string.IsNullOrEmpty(pDetail.IMG_URL)) { pDetail.IMG_URL = pDetail.IMG_URLOrg; } if (pDetail.pfileLogo != null) { pDetail.IMG_URL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo); } A05_Info_Export.CopyA05_Info(ref _A05_Info_Export, pDetail); _A05_Info_Export.IMG_URL = Server.MapPath(_A05_Info_Export.IMG_URL); // Phí cố định List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_A05(pDetail, pAppDocumentInfo); Prepare_Data_Export_A05(ref _A05_Info_Export, pInfo, pAppDocumentInfo, _lstFeeFix, pOther_MasterInfo, pAppDocOtherInfo); _lst.Add(_A05_Info_Export); DataSet _ds_all = ConvertData.ConvertToDataSet <A05_Info_Export>(_lst, false); //_ds_all.WriteXml(@"C:\inetpub\A05.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "A05.rpt"; if (pInfo.View_Language_Report == Language.LangEN) { _tempfile = "A05_EN.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); #region Set vị trí ảnh CrystalDecisions.CrystalReports.Engine.PictureObject _pic01; _pic01 = (CrystalDecisions.CrystalReports.Engine.PictureObject)oRpt.ReportDefinition.Sections[0].ReportObjects["Picture1"]; _pic01.Width = 200; _pic01.Height = 200; try { pDetail.IMG_URL = Server.MapPath(pDetail.IMG_URL); Bitmap img = new Bitmap(pDetail.IMG_URL); try { double _Const = 6.666666666666 / 2; int _left = 0, _top = 0, _marginleft = 225, _margintop = 3540; int _h = 600; double _d1 = (_h - img.Width) / 2; _d1 = _Const * _d1; _left = _marginleft + Convert.ToInt32(_d1); if (_left < 0) { _left = _marginleft; } _pic01.Left = _left; // top _d1 = (_h - img.Height) / 2; _d1 = _Const * _d1; _top = _margintop + Convert.ToInt32(_d1); if (_top < 0) { _top = _margintop; } _pic01.Top = _top; } catch (Exception ex) { Logger.LogException(ex); } finally { img.Dispose(); } } catch (Exception) { } System.IO.FileInfo file = new System.IO.FileInfo(pDetail.IMG_URL); #endregion if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table1"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(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 })); } }
private void m_mthDepIncomrpt() { DataTable p_dtbRpt = new DataTable(); DataTable p_depdt = new DataTable(); long lngRes = clsDomain.m_lngDepIncomerpt(m_objViewer.m_datFirstdate.Value.ToShortDateString(), m_objViewer.m_datLastdate.Value.ToShortDateString(), out p_dtbRpt, out p_depdt); if (lngRes > 0) { int DaySum = 0; int NightSum = 0; int ExpertSum = 0; int QuickSum = 0; int intParentDay = 0, intParentNight = 0, intParentExport = 0, intParentQuick = 0; int intDay = 0, intNight = 0, intExport = 0, intQuick = 0; ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["fDate"]).Text = "统计日期:" + str_firstDate + " 至 " + str_lasttDate; DataTable m_dtbSource = new DataTable(); m_dtbSource.Columns.Add("strComm1"); m_dtbSource.Columns.Add("decComm1", typeof(int)); m_dtbSource.Columns.Add("decComm2", typeof(int)); m_dtbSource.Columns.Add("decComm3", typeof(int)); m_dtbSource.Columns.Add("decComm4", typeof(int)); m_dtbSource.Columns.Add("decComm5", typeof(int)); int intPatienRow = 0; if (p_depdt.Rows.Count > 0) { string tempDep = ""; for (int i1 = 0; i1 < p_depdt.Rows.Count; i1++) { if (p_depdt.Rows[i1]["code_vchr"].ToString().Trim() != "1" || p_depdt.Rows[i1]["code_vchr"].ToString().Trim() == "1") { #region if (p_depdt.Rows[i1]["parentname_vchr"].ToString().Trim() != tempDep.Trim()) { tempDep = p_depdt.Rows[i1]["parentname_vchr"].ToString(); if (i1 != 0) { m_dtbSource.Rows[intPatienRow]["decComm1"] = intParentDay; m_dtbSource.Rows[intPatienRow]["decComm2"] = intParentNight; m_dtbSource.Rows[intPatienRow]["decComm3"] = intParentExport; m_dtbSource.Rows[intPatienRow]["decComm4"] = intParentQuick; } //DaySum += intParentDay; //NightSum += intParentNight; //ExpertSum += intParentExport; //QuickSum += intParentQuick; m_dtbSource.Rows.Add(new object[] { tempDep, intParentExport, intParentQuick, intParentNight, intParentDay, 1 }); intPatienRow = m_dtbSource.Rows.Count - 1; intParentExport = 0; intParentQuick = 0; intParentNight = 0; intParentDay = 0; } DataRow[] ArrRow = p_dtbRpt.Select("deptname_vchr='" + p_depdt.Rows[i1]["deptname_vchr"].ToString() + "'"); intExport = 0; intQuick = 0; intNight = 0; intDay = 0; foreach (DataRow dr in ArrRow) { if (dr["registertypeid_chr"].ToString().Trim() == "0002") //专家号 { #region MyRegion if (dr["flag_int"].ToString().Trim() == "3") //退票 { intExport--; } else //正常 还原 { intExport++; } #endregion } else if (dr["registertypeid_chr"].ToString().Trim() == "0003") //急诊号 { #region MyRegion if (dr["flag_int"].ToString().Trim() == "3") //退票 { intQuick--; } else //正常 还原 { intQuick++; } #endregion } else //普通号 { #region MyRegion if (dr["flag_int"].ToString().Trim() == "3") //退票 { if (dr["planperiod_chr"].ToString().Trim() == "晚上") { intNight--; } else { intDay--; } } else // 正常 还原 { if (dr["planperiod_chr"].ToString().Trim() == "晚上") { intNight++; } else { intDay++; } } #endregion } } m_dtbSource.Rows.Add(new object[] { " " + p_depdt.Rows[i1]["DEPTNAME_VCHR"].ToString(), intDay, intNight, intExport, intQuick, 0 }); intParentExport += intExport; intParentQuick += intQuick; intParentNight += intNight; intParentDay += intDay; DaySum += intDay; NightSum += intNight; ExpertSum += intExport; QuickSum += intQuick; #endregion } else { tempDep = ""; DataRow[] seleRow = p_depdt.Select("PARENTNAME_VCHR='" + p_depdt.Rows[i1]["deptname_vchr"].ToString() + "'"); if (seleRow.Length == 0) { DataRow[] ArrRow = p_dtbRpt.Select("deptname_vchr='" + p_depdt.Rows[i1]["deptname_vchr"].ToString() + "'"); intExport = 0; intQuick = 0; intNight = 0; intDay = 0; foreach (DataRow dr in ArrRow) { if (dr["registertypeid_chr"].ToString().Trim() == "0002") //专家号 { #region MyRegion if (dr["flag_int"].ToString().Trim() == "3") //退票 { intExport--; } else //正常 还原 { intExport++; } #endregion } else if (dr["registertypeid_chr"].ToString().Trim() == "0003") //急诊号 { #region MyRegion if (dr["flag_int"].ToString().Trim() == "3") //退票 { intQuick--; } else //正常 还原 { intQuick++; } #endregion } else //普通号 { #region MyRegion if (dr["flag_int"].ToString().Trim() == "3") //退票 { if (dr["planperiod_chr"].ToString().Trim() == "晚上") { intNight--; } else { intDay--; } } else // 正常 还原 { if (dr["planperiod_chr"].ToString().Trim() == "晚上") { intNight++; } else { intDay++; } } #endregion } } m_dtbSource.Rows.Add(new object[] { p_depdt.Rows[i1]["DEPTNAME_VCHR"].ToString(), intDay, intNight, intExport, intQuick, 0 }); intParentExport += intExport; intParentQuick += intQuick; intParentNight += intNight; intParentDay += intDay; DaySum += intDay; NightSum += intNight; ExpertSum += intExport; QuickSum += intQuick; } } } } m_dtbSource.Rows[intPatienRow]["decComm1"] = intParentDay; m_dtbSource.Rows[intPatienRow]["decComm2"] = intParentNight; m_dtbSource.Rows[intPatienRow]["decComm3"] = intParentExport; m_dtbSource.Rows[intPatienRow]["decComm4"] = intParentQuick; m_rptRpt.SetDataSource(m_dtbSource); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtDaySum"]).Text = DaySum.ToString(); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtNightSum"]).Text = NightSum.ToString(); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtComSum"]).Text = Convert.ToString(DaySum + NightSum); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtExpertSum"]).Text = ExpertSum.ToString(); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtQuickSum"]).Text = QuickSum.ToString(); ((TextObject)m_rptRpt.ReportDefinition.ReportObjects["txtTotal"]).Text = Convert.ToString(DaySum + NightSum + ExpertSum + QuickSum); m_rptRpt.Refresh(); m_objViewer.cryReportViewer.ReportSource = m_rptRpt; m_dtbSource = null; } else { MessageBox.Show("加载数据时出错!!", "iCare", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; }
public ActionResult ExportData_View_IU(ApplicationHeaderInfo pInfo, Pattent_Lao_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo, List <Other_MasterInfo> pOther_MasterInfo, List <Inventor_Info> pInventor_Info, List <AppClassDetailInfo> pAppClassInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo, List <UTienInfo> pUTienInfo, List <AppDocumentOthersInfo> pLstImagePublic) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); //var objBL = new A01_BL(); List <Pattent_Lao_Info_Export> _lst = new List <Pattent_Lao_Info_Export>(); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "L_Patent_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "L_Patent_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "L_Patent_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "L_Patent_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "L_Patent_EN_" + _datetimenow + ".pdf"; } Pattent_Lao_Info_Export _A01_Info_Export = new Pattent_Lao_Info_Export(); Pattent_Lao_Info_Export.CopyA01_Info(ref _A01_Info_Export, pDetail); foreach (var item in MemoryData.c_lst_Country) { if (item.Country_Id == pInfo.Master_Country_Nationality) { pInfo.Master_Country_Nationality_Name = item.Name; } if (item.Country_Id == pInfo.Master_Country_Incorporation) { pInfo.Master_Country_Incorporation_Name = item.Name; } if (item.Country_Id == pInfo.Master_Country_Residence) { pInfo.Master_Country_Residence_Name = item.Name; } } // Phí cố định List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_PT_Lao(pDetail, pAppDocumentInfo, pUTienInfo, pLstImagePublic, pAppDocOtherInfo); Call_Fee.Prepare_Data_Export_PT_Lao(ref _A01_Info_Export, pInfo, pAppDocumentInfo, _lstFeeFix, pInventor_Info, pOther_MasterInfo, pAppClassInfo, pAppDocOtherInfo, pUTienInfo, pLstImagePublic); _lst.Add(_A01_Info_Export); DataSet _ds_all = ConvertData.ConvertToDataSet <Pattent_Lao_Info_Export>(_lst, false); //_ds_all.WriteXml(@"D:\A01.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "L_Patent.rpt"; //if (language == Language.LangEN) //{ // _tempfile = "L_Patent_EN.rpt"; //} oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table1"; oRpt.Database.Tables["Table"].SetDataSource(_ds_all.Tables[0]); //oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); //oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, fileName_pdf); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public ActionResult ExportData_View_IU(ApplicationHeaderInfo pInfo, A02_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo, List <AuthorsInfo> pAppAuthorsInfo, List <Other_MasterInfo> pOther_MasterInfo, List <AppClassDetailInfo> pAppClassInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo, List <UTienInfo> pUTienInfo, List <AppDocumentOthersInfo> pAppDocDesign) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); var objBL = new A02_BL(); List <A02_Info_Export> _lst = new List <A02_Info_Export>(); string p_appCode = "A02_Preview"; string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "A02_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "A02_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "A02_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "A02_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "A02_EN_" + _datetimenow + ".pdf"; } A02_Info_Export _A02_Info_Export = new A02_Info_Export(); A02_Info_Export.CopyA02_Info(ref _A02_Info_Export, pDetail); // Phí cố định List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_A02(pDetail, pAppDocumentInfo, pAppDocDesign); Prepare_Data_Export_A02(ref _A02_Info_Export, pInfo, pAppDocumentInfo, _lstFeeFix, pAppAuthorsInfo, pOther_MasterInfo, pAppDocOtherInfo, pAppDocDesign); _lst.Add(_A02_Info_Export); DataSet _ds_all = ConvertData.ConvertToDataSet <A02_Info_Export>(_lst, false); //_ds_all.WriteXml(@"C:\inetpub\A02.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "A02.rpt"; if (language == Language.LangEN) { _tempfile = "A02_EN.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table1"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public void RPT_Sub(Int64 QuotationID, string Code, Boolean _IsList) { DataTable dt = new DataTable(); LogoBind(dt); mpdfFile = CurrentUser.DocumentPath + @"pdf\Quotation.pdf"; DataTable dtReport = new DataTable(); dtReport = CommSelect.SelectRecord(QuotationID, "rpt_Quotation", "Quotation - Report"); DataTable dtTNC = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_Code", Code); para.Add("@i_TNC_Sub", "Quotation"); dtTNC = objDA.ExecuteDataTableSP("rpt_Quotation_TNC", para, false, ref mException, ref mErrorMsg, "Quotation TNC"); DataTable dtCompany = new DataTable(); dtCompany = objDA.ExecuteDataTableSP("rpt_Company", null, false, ref mException, ref mErrorMsg, "Quotation TNC"); //dtReport.TableName = "Quotation"; //dtReport.WriteXmlSchema(@"D:\Quotation.xsd"); if (CommSelect.Exception == null) { //if (TypeOFSale == "AMC") //{ // if (System.IO.File.Exists(CurrentUser.ReportPath + "rptQuotation_AMC.rpt")) // { // CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); // rptDoc.Load(CurrentUser.ReportPath + "rptQuotation_AMC.rpt"); // //rptDoc.SetDatabaseLogon("sa", "Un!ek3RP"); // CurrentUser.AddReportParameters(rptDoc, dtReport, "", false, false, false, false, false, false, false, false, false, false, false); // rptDoc.Database.Tables[1].SetDataSource(dtCompany); // rptDoc.Subreports[0].DataSourceConnections.Clear(); // rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC); // rptDoc.Refresh(); // Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); // fRptView.Text = "Quotation - [Page Size: A4]"; // fRptView.crViewer.ReportSource = rptDoc; // if (_IsList == true) // { // fRptView.ShowDialog(); // } // else if (_IsList == false) // { // ExportOptions CrExportOptions; // DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); // PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); // CrDiskFileDestinationOptions.DiskFileName = mpdfFile; // CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here // CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; // CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; // CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; // CrExportOptions.FormatOptions = CrFormatTypeOptions; // rptDoc.Export(); // } // } // else // { // MessageBox.Show("File is not exist..."); // } //} //else if (TypeOFSale != "AMC") //{ if (System.IO.File.Exists(CurrentUser.ReportPath + "rptQuotation.rpt")) { CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptQuotation.rpt"); //rptDoc.Subreports[0].DataSourceConnections.Clear(); rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC); rptDoc.Database.Tables[1].SetDataSource(dtCompany); rptDoc.Database.Tables[2].SetDataSource(dt); rptDoc.Refresh(); CurrentUser.AddReportParameters(rptDoc, dtReport, "", false, false, false, false, false, false, false, false, false, false, false); CurrentUser.AddExtraParameter(rptDoc); if (CurrentCompany.Com_Profile != null || CurrentCompany.Com_Profile.Trim() != "") { rptDoc.SetParameterValue("pCompanyProfile", CurrentCompany.Com_Profile); } Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Quotation - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; if (_IsList == true) { fRptView.ShowDialog(); } else if (_IsList == false) { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = mpdfFile; CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; rptDoc.Export(); } } else { MessageBox.Show("File is not exist..."); } //} } }
private void m_btnFind_Click(object sender, EventArgs e) { if (m_lsv.Items.Count == 1) { MessageBox.Show("没有配置好药房数据,请联系管理员", "错误"); return; } #region 取得相关条件 int intSelCount = 0; string strDep = ""; int index = 0; for (int i = 1; i < m_lsv.Items.Count; i++) { if (m_lsv.Items[i].Checked) { intSelCount++; } } string[] strMedStoreIDArr = null; if (m_lsv.Items[0].Checked) { strMedStoreIDArr = new string[m_lsv.Items.Count - 1]; for (int i = 1; i < m_lsv.Items.Count; i++) { strMedStoreIDArr[i - 1] = m_lsv.Items[i].SubItems[1].Text; strDep += m_lsv.Items[i].SubItems[0].Text + " "; } } else { strMedStoreIDArr = new string[intSelCount]; for (int i = 1; i < m_lsv.Items.Count; i++) { if (m_lsv.Items[i].Checked) { strMedStoreIDArr[index++] = m_lsv.Items[i].SubItems[1].Text; strDep += m_lsv.Items[i].SubItems[0].Text + " "; } } } if (strDep == "") { MessageBox.Show("请选择统计药房", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } //未配1 //已配2 //已发3 string[] strStatusArr = null; if (m_cboState.Text == "全部") { strStatusArr = new string[] { "1", "2", "3" } } ; else if (m_cboState.Text == "未配") { strStatusArr = new string[] { "1" }; } else if (m_cboState.Text == "已配") { strStatusArr = new string[] { "2" }; } else if (m_cboState.Text == "已发") { strStatusArr = new string[] { "3" }; } #endregion #region order by string strASC = " ASC "; if (m_cboAsc.Text != "升序") { strASC = " DESC "; } string strOrder = " " + m_strGetColName(m_cbocol.Text) + " " + strASC; #endregion string strRPT = ""; long lngRes = 0; switch (m_cboRptSel.SelectedIndex) { case 0: case 2: #region 配置报表 strRPT = "cryMedSendDetails.rpt"; m_rptRpt.Load("Report\\" + strRPT); lngRes = m_objSvc.m_lngGetMedSendItemData(m_dtmStart.Value.ToShortDateString(), m_dtmEnd.Value.ToShortDateString(), strMedStoreIDArr, strStatusArr, strOrder, m_ctlTBFindItem.txtValuse.Trim(), out m_DataTable); //DataRow[] drArr = m_DataTable.Select(" OUTPATRECIPEID_CHR is not null ", strOrder); //m_DataTable.Rows.Clear(); //for (int i = 0; i < drArr.Length; i++) //{ // m_DataTable.Rows.Add(drArr[i]); //} if (m_cboRptSel.SelectedIndex == 2) { TextObject m_sendman = m_rptRpt.ReportDefinition.ReportObjects["m_sendman"] as TextObject; m_sendman.Text = "发料人"; TextObject m_setman = m_rptRpt.ReportDefinition.ReportObjects["m_setman"] as TextObject; m_setman.Text = "配料人"; TextObject m_title = m_rptRpt.ReportDefinition.ReportObjects["m_title"] as TextObject; m_title.Text = "门诊综合材料发放清单(明细)"; } else if (m_cboRptSel.SelectedIndex == 0) { TextObject m_sendman = m_rptRpt.ReportDefinition.ReportObjects["m_sendman"] as TextObject; m_sendman.Text = "发药人"; TextObject m_setman = m_rptRpt.ReportDefinition.ReportObjects["m_setman"] as TextObject; m_setman.Text = "配药人"; TextObject m_title = m_rptRpt.ReportDefinition.ReportObjects["m_title"] as TextObject; m_title.Text = "门诊药房药品发放清单(明细)"; } TextObject m_PrintDate = m_rptRpt.ReportDefinition.ReportObjects["m_PrintDate"] as TextObject; m_PrintDate.Text = System.DateTime.Now.ToString(); TextObject m_state = m_rptRpt.ReportDefinition.ReportObjects["m_state"] as TextObject; m_state.Text = m_cboState.Text; TextObject m_dept = m_rptRpt.ReportDefinition.ReportObjects["m_dept"] as TextObject; m_dept.Text = strDep; TextObject m_statis = m_rptRpt.ReportDefinition.ReportObjects["m_statis"] as TextObject; m_statis.Text = m_dtmStart.Value.ToShortDateString() + " ~ " + m_dtmEnd.Value.ToShortDateString(); double dblTotal = 0; string str = ""; for (int i = 0; i < m_DataTable.Rows.Count; i++) { str = m_DataTable.Rows[i]["tolprice_mny"].ToString(); if (str != "") { dblTotal += double.Parse(str); } } TextObject m_total = m_rptRpt.ReportDefinition.ReportObjects["m_total"] as TextObject; m_total.Text = dblTotal.ToString(); #endregion if (lngRes > 0) { m_rptRpt.SetDataSource(m_DataTable); m_rptRpt.Refresh(); crystalReportViewer1.ReportSource = m_rptRpt; } else { MessageBox.Show("查找数据库出错."); } break; case 1: case 3: #region 配置报表 strRPT = "cryMedSum.rpt"; m_rptRpt.Load("Report\\" + strRPT); lngRes = m_objSvc.m_lngGetMedSendItemData(m_dtmStart.Value.ToShortDateString(), m_dtmEnd.Value.ToShortDateString(), strMedStoreIDArr, strStatusArr, strOrder, m_ctlTBFindItem.txtValuse.Trim(), out m_DataTable); TextObject m_title2 = m_rptRpt.ReportDefinition.ReportObjects["m_title"] as TextObject; if (m_cboRptSel.SelectedIndex == 1) { m_title2.Text = "门诊药房药品发放清单(汇总)"; } else { m_title2.Text = "门诊综合材料发放清单(汇总)"; } TextObject m_PrintDate2 = m_rptRpt.ReportDefinition.ReportObjects["m_PrintDate"] as TextObject; m_PrintDate2.Text = System.DateTime.Now.ToString(); TextObject m_state2 = m_rptRpt.ReportDefinition.ReportObjects["m_state"] as TextObject; m_state2.Text = m_cboState.Text; TextObject m_dept2 = m_rptRpt.ReportDefinition.ReportObjects["m_dept"] as TextObject; m_dept2.Text = strDep; TextObject m_statis2 = m_rptRpt.ReportDefinition.ReportObjects["m_statis"] as TextObject; m_statis2.Text = m_dtmStart.Value.ToShortDateString() + " ~ " + m_dtmEnd.Value.ToShortDateString(); #endregion if (lngRes > 0) { DataTable dtTemp = m_DataTable.Clone(); DataRow dr = null; DataRow[] drarr = null; string itemid = ""; int indexHas = -1; bool blnHas = false; if (m_DataTable != null) { for (int i = 0; i < m_DataTable.Rows.Count; i++) { blnHas = false; itemid = m_DataTable.Rows[i]["strTemp1"].ToString().Trim(); for (int i2 = 0; i2 < dtTemp.Rows.Count; i2++) { if (itemid == dtTemp.Rows[i2]["strTemp1"].ToString().Trim()) { blnHas = true; indexHas = i2; break; } } if (blnHas) { dtTemp.Rows[indexHas]["qty_dec"] = Math.Ceiling(double.Parse(dtTemp.Rows[indexHas]["qty_dec"].ToString().Trim())) + Math.Ceiling(double.Parse(m_DataTable.Rows[i]["qty_dec"].ToString().Trim())); dtTemp.Rows[indexHas]["tolprice_mny"] = Convert.ToDouble(dtTemp.Rows[indexHas]["tolprice_mny"].ToString().Trim()) + Convert.ToDouble(m_DataTable.Rows[i]["tolprice_mny"].ToString().Trim()); } else { dr = dtTemp.NewRow(); for (int j = 0; j < dtTemp.Columns.Count; j++) { dr[j] = m_DataTable.Rows[i][j]; } dtTemp.Rows.Add(dr); } } } drarr = dtTemp.Select("qty_dec >-100", strOrder); DataTable dtsource = dtTemp.Clone(); for (int i3 = 0; i3 < drarr.Length; i3++) { dr = dtsource.NewRow(); for (int j = 0; j < dtsource.Columns.Count; j++) { dr[j] = drarr[i3][j]; } dtsource.Rows.Add(dr); } m_rptRpt.SetDataSource(dtsource); m_rptRpt.Refresh(); crystalReportViewer1.ReportSource = m_rptRpt; } break; default: break; } }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { //try //{ // if (dgvCreditNote.CurrentRow != null) // { // RPT_Sub(Convert.ToInt64(dgvCreditNote.CurrentRow.Cells["CNID"].Value), dgvCreditNote.CurrentRow.Cells["CNnumber"].Value.ToString(), true); // } // else // { // MessageBox.Show(CommSelect.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); // } //} //catch (Exception exc) //{ // Utill.Common.ExceptionLogger.writeException("Quotation - Report", exc.StackTrace); // MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception"); //} try { if (cmbreports.SelectedIndex == 1) { DataTable dt = new DataTable(); LogoBind(dt); if (dgvCreditNote.CurrentRow != null) { DataTable dtTNC = new DataTable(); //NameValueCollection para2 = new NameValueCollection(); //para2.Add("@i_Code", dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString()); //para2.Add("@i_TNC_Sub", "SALES"); //dtTNC = objDA.ExecuteDataTableSP("rpt_Sales_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC"); DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_RecID", Convert.ToInt64(dgvCreditNote.CurrentRow.Cells["CNID"].Value).ToString()); dtReport = objList.ListOfRecord("rpt_CreditNote", para, "CreditNote - Report"); //NameValueCollection para2 = new NameValueCollection(); //_CompId = CurrentCompany.CompId; //para2.Add("@i_CompId", _CompId.ToString()); //dtCompany = objList.ListOfRecord("rpt_Company", para2, "Quotation - Report"); //dtReport.TableName = "CreditNote"; //dtReport.WriteXmlSchema(@"D:\CreditNote.xsd"); dtReport = objList.ListOfRecord("rpt_CreditNote", para, "CreditNote - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCreditNote.rpt")) { //dtReport.TableName = "PurchaseOrder"; //dtReport.WriteXmlSchema(@"D:\PurchaseOrder.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCreditNote.rpt"); rptDoc.Subreports[0].DataSourceConnections.Clear(); //rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC); rptDoc.Database.Tables[1].SetDataSource(dt); //rptDoc.Database.Tables[2].SetDataSource(dtCompany); rptDoc.Refresh(); CurrentUser.AddReportParameters(rptDoc, dtReport, "", true, false, false, false, false, false, false, false, false, false, false); CurrentUser.AddExtraParameter(rptDoc); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Credit Note - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("Please check Company Details,\n Go to the Master->Edit->Company Details->ReportPath/DocPath."); } } else { MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception"); } }