public ActionResult CTR080_QuotationForCancelContractMemorandum(int iDocID) { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTCancelContractMemoDo> rptList = contractDocHandler.GetRptCancelContractMemoData(iDocID); List <RPTCancelContractMemoDetailDo> rptListDetail = contractDocHandler.GetRptCancelContractMemoDetail(iDocID); bool isShowDefaultData = false; if (rptListDetail == null || rptListDetail.Count == 0) { rptListDetail = GetDefaultCancelContractMemoDetailData(); isShowDefaultData = true; } ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR080_QuotationForCancelContractMemorandum.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR080_QuotationForCancelContractMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); rptH.Subreports["CTR080_1"].SetDataSource(rptListDetail); rptH.SetParameterValue("ShowDefaultData", isShowDefaultData, "CTR080_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult ISR080_GetRptIECheckSheetData(string strMaintenanceNo, string strSubcontractorCode) { strMaintenanceNo = "5020N20110030"; strSubcontractorCode = "00002"; IReportHandler reportHandler = ServiceContainer.GetService <IReportHandler>() as IReportHandler; List <RPTIECheckSheetDo> rptList = reportHandler.GetRptIECheckSheetData(strMaintenanceNo, strSubcontractorCode); IDocumentHandler dochandler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; List <tbm_DocumentTemplate> dLst = dochandler.GetDocumentTemplateByDocumentCode(DocumentCode.C_DOCUMENT_CODE_IE_CHECK_SHEET); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/ISR080_IECheckSheet.rpt", Server.MapPath("/")); rptH.Load(path); List <RPTIECheckSheetDo> lst = new List <RPTIECheckSheetDo>(); lst.Add(rptList[0]); if (dLst.Count > 0) { lst[0].DocumentNameEN = dLst[0].DocumentNameEN; lst[0].DocumentVersion = dLst[0].DocumentVersion; } rptH.SetDataSource(lst); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult CTR020_ChangeNotice(int iDocID) { try { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTChangeNoticeDo> rptList = contractDocHandler.GetRptChangeNoticeData(iDocID); IDocumentHandler documentHandler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; //doDocumentDataGenerate doDoc = new doDocumentDataGenerate(); //if (rptList.Count > 0) //{ // doDoc.DocumentNo = rptList[0].DocNo; // doDoc.DocumentCode = rptList[0].DocumentCode; // doDoc.DocumentData = rptList; //} //Stream stream = documentHandler.GenerateDocument(doDoc); string path = ReportUtil.GetReportPath("Reports/CTR020_ChangeNotice.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR020_ChangeNotice.rpt"); ReportDocument rptH = new ReportDocument(); rptH.Load(path); rptH.SetDataSource(rptList); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); } catch (Exception ex) { throw; } }
public ActionResult CMR010_IssueList() { try { ICommonHandler CommonHandler = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; List <dtIssueListData> rptList = CommonHandler.GetTmpIssueListData(); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CMR010_IssueList.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR060_CancelContractMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); //rptH.Subreports["CTR060_1"].SetDataSource(rptListDetail); //rptH.SetParameterValue("AutoBillingTypeNone", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_NONE, "CTR060_1"); //rptH.SetParameterValue("AutoBillingTypeAll", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_ALL, "CTR060_1"); //rptH.SetParameterValue("AutoBillingTypePartial", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_PARTIAL, "CTR060_1"); //rptH.SetParameterValue("BankBillingTypeNone", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_NONE, "CTR060_1"); //rptH.SetParameterValue("BankBillingTypeAll", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_ALL, "CTR060_1"); //rptH.SetParameterValue("BankBillingTypePartial", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_PARTIAL, "CTR060_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); } catch (Exception ex) { throw ex; } }
public ActionResult CTR090_CoverLetter(int iDocID) { try { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTCoverLetterDo> rptListCover = contractDocHandler.GetRptCoverLetterData(iDocID); List <RPTInstrumentDetailDo> rptListInst = contractDocHandler.GetRptInstrumentDetailData(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR090_CoverLetter.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR090_CoverLetter.rpt"); rptH.Load(path); rptH.SetDataSource(rptListCover); rptH.Subreports["CTR090_1"].SetDataSource(rptListInst); rptH.Subreports["CTR090_2"].SetDataSource(rptListInst); rptH.Subreports["CTR090_3"].SetDataSource(rptListInst); rptH.SetParameterValue("FlagOn", FlagType.C_FLAG_ON); rptH.SetParameterValue("ShowInstrument", (rptListInst != null && rptListInst.Count > 0)); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); //IDocumentHandler documentHandler = ServiceContainer.GetService<IDocumentHandler>() as IDocumentHandler; //doDocumentDataGenerate doDoc = new doDocumentDataGenerate(); //if (rptListCover.Count > 0) //{ // rptListCover[0].DocumentCode = "CTR090"; // doDoc.DocumentNo = rptListCover[0].DocNo; // doDoc.DocumentCode = rptListCover[0].DocumentCode; // doDoc.DocumentData = rptListCover; //} //List<ReportParameterObject> listSubReportDataSource = new List<ReportParameterObject>(); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR090_1", Value = rptListInst }); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR090_2", Value = rptListInst }); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR090_3", Value = rptListInst }); //doDoc.SubReportDataSource = listSubReportDataSource; //List<ReportParameterObject> listMainReportParam = new List<ReportParameterObject>(); //listMainReportParam.Add(new ReportParameterObject() { ParameterName = "FlagOn", Value = FlagType.C_FLAG_ON }); //doDoc.MainReportParam = listMainReportParam; //doDoc.SubReportParam = null; //Stream stream = documentHandler.GenerateDocument(doDoc); return(File(stream, "application/pdf")); } catch (Exception ex) { throw ex; } }
public ActionResult CTR070_ChangeFeeMemorandum(int iDocID) { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTChangeFeeMemoDo> rptList = contractDocHandler.GetRptChangeFeeMemoData(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR070_ChangeFeeMemorandum.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR070_ChangeFeeMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult ISR010_GetNewInstallationSlip(string strSlipNo) { IReportHandler reportHandler = ServiceContainer.GetService <IReportHandler>() as IReportHandler; List <RPTNewRentalSlipDo> rptList = reportHandler.GetRptNewRentalSlipReport(strSlipNo); IDocumentHandler dochandler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; List <tbm_DocumentTemplate> dLst = dochandler.GetDocumentTemplateByDocumentCode(DocumentCode.C_DOCUMENT_CODE_NEW_INSTALL_SLIP_RENTAL); ReportDocument rptH = new ReportDocument(); //string path = ReportUtil.GetReportTemplatePath("ISR010_NewInstallationSlip.rpt"); string path = ReportUtil.GetReportPath("Reports/ISR010_NewInstallationSlip.rpt", Server.MapPath("/")); rptH.Load(path); List <RPTNewRentalSlipDo> lst = new List <RPTNewRentalSlipDo>(); if (rptList != null && rptList.Count > 0) { lst.Add(rptList[0]); if (dLst.Count > 0) { lst[0].DocumentNameEN = dLst[0].DocumentNameEN; lst[0].DocumentVersion = dLst[0].DocumentVersion; } } else { rptList.Add(new RPTNewRentalSlipDo()); } rptH.SetDataSource(lst); rptH.Subreports["Page1"].SetDataSource(rptList); rptH.Subreports["Page2"].SetDataSource(rptList); rptH.Subreports["Page3"].SetDataSource(rptList); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult ISR090_GetRptInstallCompleteConfirmData(string strSlipNo) { strSlipNo = "401029201112043"; IReportHandler reportHandler = ServiceContainer.GetService <IReportHandler>() as IReportHandler; List <RPTInstallCompleteDo> rptList = reportHandler.GetRptInstallCompleteConfirmData(strSlipNo); IDocumentHandler dochandler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; List <tbm_DocumentTemplate> dLst = dochandler.GetDocumentTemplateByDocumentCode(DocumentCode.C_DOCUMENT_CODE_INSTALL_COMPLETE_CONFIRM); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/ISR090_InstallCompleteConfirmData.rpt", Server.MapPath("/")); rptH.Load(path); List <RPTInstallCompleteDo> lst = new List <RPTInstallCompleteDo>(); int i = 0; foreach (RPTInstallCompleteDo rptDataRow in rptList) { lst.Add(rptDataRow); if (dLst.Count > 0) { lst[i].DocumentNameEN = dLst[0].DocumentNameEN; lst[i].DocumentVersion = dLst[0].DocumentVersion; } i++; } rptH.SetDataSource(lst); rptH.SetParameterValue("C_RENTAL_INSTALL_TYPE_REMOVE_ALL", RentalInstallationType.C_RENTAL_INSTALL_TYPE_REMOVE_ALL); rptH.SetParameterValue("C_SALE_INSTALL_TYPE_REMOVE_ALL", SaleInstallationType.C_SALE_INSTALL_TYPE_REMOVE_ALL); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult CTR011_ContractThai(int iDocID) { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTContractReportDo> rptList = contractDocHandler.GetRptContractReportData(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR011_ContractThai.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR011_ContractThai.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); rptH.Subreports["CTR011_1"].SetDataSource(rptList); rptH.SetParameterValue("FlagOn", FlagType.C_FLAG_ON, "CTR011_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult ISR100_GetRptAcceptanceInspectionNotice(string strMaintenanceNo, string strSubcontractorCode) { strMaintenanceNo = "5020N20110030"; strSubcontractorCode = "00002"; IReportHandler reportHandler = ServiceContainer.GetService <IReportHandler>() as IReportHandler; List <RPTAcceptInspecDo> rptList = reportHandler.GetRptAcceptInspecNocticeData(strMaintenanceNo, strSubcontractorCode); IDocumentHandler dochandler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; List <tbm_DocumentTemplate> dLst = dochandler.GetDocumentTemplateByDocumentCode(DocumentCode.C_DOCUMENT_CODE_ACCEPT_INSPECT_NOTICE); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/ISR100_AcceptanceInspectionNotice.rpt", Server.MapPath("/")); rptH.Load(path); List <RPTAcceptInspecDo> lst = new List <RPTAcceptInspecDo>(); int i = 0; foreach (RPTAcceptInspecDo rptDataRow in rptList) { lst.Add(rptDataRow); if (dLst.Count > 0) { lst[i].DocumentNameEN = dLst[0].DocumentNameEN; lst[i].DocumentVersion = dLst[0].DocumentVersion; } i++; } rptH.SetDataSource(lst); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult CTR060_CancelContractMemorandum(int iDocID) { try { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTCancelContractMemoDo> rptList = contractDocHandler.GetRptCancelContractMemoData(iDocID); List <RPTCancelContractMemoDetailDo> rptListDetail = contractDocHandler.GetRptCancelContractMemoDetail(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR060_CancelContractMemorandum.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR060_CancelContractMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); rptH.Subreports["CTR060_1"].SetDataSource(rptListDetail); rptH.SetParameterValue("AutoBillingTypeNone", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_NONE, "CTR060_1"); rptH.SetParameterValue("AutoBillingTypeAll", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_ALL, "CTR060_1"); rptH.SetParameterValue("AutoBillingTypePartial", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_PARTIAL, "CTR060_1"); rptH.SetParameterValue("BankBillingTypeNone", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_NONE, "CTR060_1"); rptH.SetParameterValue("BankBillingTypeAll", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_ALL, "CTR060_1"); rptH.SetParameterValue("BankBillingTypePartial", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_PARTIAL, "CTR060_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); //IDocumentHandler documentHandler = ServiceContainer.GetService<IDocumentHandler>() as IDocumentHandler; //doDocumentDataGenerate doDoc = new doDocumentDataGenerate(); //if (rptList.Count > 0) //{ // doDoc.DocumentNo = rptList[0].DocNo; // doDoc.DocumentCode = rptList[0].DocumentCode; // doDoc.DocumentData = rptList; //} //List<ReportParameterObject> listSubReportDataSource = new List<ReportParameterObject>(); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR060_1", Value = rptListDetail }); //doDoc.SubReportDataSource = listSubReportDataSource; //doDoc.MainReportParam = null; //List<ReportParameterObject> listSubReportParam = new List<ReportParameterObject>(); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "AutoBillingTypeNone", Value = AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_NONE, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "AutoBillingTypeAll", Value = AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_ALL, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "AutoBillingTypePartial", Value = AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_PARTIAL, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "BankBillingTypeNone", Value = BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_NONE, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "BankBillingTypeAll", Value = BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_ALL, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "BankBillingTypePartial", Value = BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_PARTIAL, SubReportName = "CTR060_1" }); //doDoc.SubReportParam = listSubReportParam; //// doDoc2 //List<RPTCoverLetterDo> rptListCover = contractDocHandler.GetRptCoverLetterData(100); // iDocID = 100 , fixed to 100 for test //List<RPTInstrumentDetailDo> rptListInst = contractDocHandler.GetRptInstrumentDetailData(100); // iDocID = 100 , fixed to 100 for test //doDocumentDataGenerate doDoc2 = new doDocumentDataGenerate(); //if (rptListCover.Count > 0) //{ // rptListCover[0].DocumentCode = "CTR090"; // doDoc2.DocumentNo = rptListCover[0].DocNo; // doDoc2.DocumentCode = rptListCover[0].DocumentCode; // doDoc2.DocumentData = rptListCover; //} //List<ReportParameterObject> listSubReportDataSource2 = new List<ReportParameterObject>(); //listSubReportDataSource2.Add(new ReportParameterObject() { SubReportName = "CTR090_1", Value = rptListInst }); //listSubReportDataSource2.Add(new ReportParameterObject() { SubReportName = "CTR090_2", Value = rptListInst }); //listSubReportDataSource2.Add(new ReportParameterObject() { SubReportName = "CTR090_3", Value = rptListInst }); //doDoc2.SubReportDataSource = listSubReportDataSource2; //List<ReportParameterObject> listMainReportParam2 = new List<ReportParameterObject>(); //listMainReportParam2.Add(new ReportParameterObject() { ParameterName = "FlagOn", Value = FlagType.C_FLAG_ON }); //doDoc2.MainReportParam = listMainReportParam2; //doDoc2.SubReportParam = null; //Stream stream = documentHandler.GenerateDocument(doDoc, doDoc2); return(File(stream, "application/pdf")); } catch (Exception ex) { throw ex; } }