protected void C1WebReport1_StartSection(object sender, C1.C1Report.ReportEventArgs e) { if (e.Section == C1.C1Report.SectionTypeEnum.Header) { // get picture field C1.C1Report.Field f = this.C1WebReport1.Report.Fields["PictureField"]; // calculate image size in pixels (convert from twips) System.Drawing.Size size = new System.Drawing.Size( (int)(f.Width * 96f / 1440f), (int)(f.Height * 96f / 1440f)); // get image from webchart and assign it to field f.Picture = this.C1WebChart1.GetImage(System.Drawing.Imaging.ImageFormat.Png, size); } }
/// <summary> /// Thachnn: 28/10/2005 /// Preview the report for this form /// Using the "InventoryStatusSummaryByMasterLocationReport.xml" layout /// </summary> /// <history>Thachnn: 29/12/2005: Add parameter display to the report. Change USECASE.</history> /// <param name="sender"></param> /// <param name="e"></param> public DataTable ExecuteReport(string pstrCCNID, string pstrMasterLocationID, string pstrCategoryID, string pstrParameterModel) { #region Constants string mstrReportDefFolder = mstrReportDefinitionFolder; const string REPORT_LAYOUT_FILE = "InventoryStatusSummaryByMasterLocationReport.xml"; const string TABLE_NAME = "InventoryStatusSummaryByMasterLocationReport"; const string REPORT_NAME = "Inventory Status Summary By Master Location"; const string PAGE = "Page"; const string HEADER = "Header"; const string REPORTFLD_TITLE = "fldTitle"; const string REPORTFLD_COMPANY = "fldCompany"; const string REPORTFLD_ADDRESS = "fldAddress"; const string REPORTFLD_TEL = "fldTel"; const string REPORTFLD_FAX = "fldFax"; const string REPORTFLD_DAY = "fldDay"; const string REPORTFLD_MONTH = "fldMonth"; const string REPORTFLD_YEAR = "fldYear"; const string REPORTFLD_CATEGORY = "fldCategory"; const string REPORTFLD_PARTNUMBER = "fldPartNumber"; const string REPORTFLD_PARTNAME = "fldPartName"; const string REPORTFLD_MODEL = "fldModel"; const string REPORTFLD_STOCKUM = "fldStockUM"; const string REPORTFLD_LOCATION = "fldLocation"; const string REPORTFLD_OHQTY = "fldOHQty"; const string REPORTFLD_COMMITQTY = "fldCommitQty"; const string REPORTFLD_AVAILABLEQTY = "fldAvailableQty"; const string REPORTFLD_TYPE = "fldType"; const string REPORTFLD_SOURCE = "fldSource"; const string REPORTFLD_SAFETYSTOCK = "fldSafetyStock"; const string REPORTFLD_LOT = "fldLot"; const string REPORTFLD_WARNING = "fldWarning"; #region QUERY COLUMMS const string CATEGORY_COL = "[Category]"; const string PARTNUMBER_COL = "[Part No.]"; const string PARTNAME_COL = "[Part Name]"; const string MODEL_COL = "[Model]"; const string STOCKUM_COL = "[Stock UM]"; const string LOCATION_COL = "[Location]"; const string OHQTY_COL = "[OH Qty]"; const string COMMITQTY_COL = "[Commit Qty]"; const string AVAILABLEQTY_COL = "[Available Qty]"; const string TYPE_COL = "[Type]"; const string SOURCE_COL = "[Source]"; const string SAFETYSTOCK_COL = "[Safety Stock]"; const string LOT_COL = "[Lot]"; const string WARNING_COL = "[Warning]"; #endregion #endregion #region GETTING THE PARAMETER PCSComUtils.Common.BO.UtilsBO boUtil = new PCSComUtils.Common.BO.UtilsBO(); PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO objBO = new PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO(); string strCCN = boUtil.GetCCNCodeFromID(int.Parse(pstrCCNID)); string strMasterLocation = objBO.GetMasterLocationCodeFromID(int.Parse(pstrMasterLocationID)) + ": " + objBO.GetMasterLocationNameFromID(int.Parse(pstrMasterLocationID)); string strCategory = string.Empty; try { strCategory = objBO.GetCategoryCodeFromID(pstrCategoryID); } catch {} #endregion float fActualPageSize = 9000f; #region Build dtbResult DataTable DataTable dtbResult; try { dtbResult = GetInventoryStatusData(pstrCCNID, pstrMasterLocationID, pstrCategoryID, pstrParameterModel); } catch { dtbResult = new DataTable(); } #endregion ReportBuilder objRB; objRB = new ReportBuilder(); objRB.ReportName = REPORT_NAME; objRB.SourceDataTable = dtbResult; #region INIT REPORT BUIDER OBJECT try { objRB.ReportDefinitionFolder = mstrReportDefinitionFolder; objRB.ReportLayoutFile = REPORT_LAYOUT_FILE; if (objRB.AnalyseLayoutFile() == false) { // PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND, MessageBoxIcon.Error); return(new DataTable()); } //objRB.UseLayoutFile = objRB.AnalyseLayoutFile(); // use layout file if any , auto drawing if not found layout file objRB.UseLayoutFile = true; // always use layout file } catch { objRB.UseLayoutFile = false; // PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND,MessageBoxIcon.Error); } C1.C1Report.Layout objLayout = objRB.Report.Layout; fActualPageSize = objLayout.PageSize.Width - (float)objLayout.MarginLeft - (float)objLayout.MarginRight; #endregion objRB.MakeDataTableForRender(); //grid.DataSource = objRB.RenderDataTable; #region RENDER TO PRINT PREVIEW // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); printPreview.FormTitle = REPORT_NAME; objRB.ReportViewer = printPreview.ReportViewer; objRB.RenderReport(); #region COMPANY INFO header information get from system params // try // { // objRB.DrawPredefinedField(REPORTFLD_COMPANY,SystemProperty.SytemParams.Get(SystemParam.COMPANY_NAME)); // } // catch{} // try // { // objRB.DrawPredefinedField(REPORTFLD_ADDRESS,SystemProperty.SytemParams.Get(SystemParam.ADDRESS)); // } // catch{} // try // { // objRB.DrawPredefinedField(REPORTFLD_TEL,SystemProperty.SytemParams.Get(SystemParam.TEL)); // } // catch{} // try // { // objRB.DrawPredefinedField(REPORTFLD_FAX,SystemProperty.SytemParams.Get(SystemParam.FAX)); // } // catch{} #endregion #region DRAW Parameters const string CCN = "CCN"; const string MASTER_LOCATION = "Master Location"; const string LOCATION = "Location"; const string CATEGORY = "Category"; const string MODEL = "Model"; System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(CCN, strCCN); arrParamAndValue.Add(MASTER_LOCATION, strMasterLocation); if (pstrCategoryID.Trim() != string.Empty) { arrParamAndValue.Add(CATEGORY, strCategory); } if (pstrParameterModel.Trim() != string.Empty) { arrParamAndValue.Add(MODEL, pstrParameterModel); } /// anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = objRB.GetFieldByName(REPORTFLD_TITLE); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; objRB.GetSectionByName(PAGE + HEADER).CanGrow = true; objRB.DrawParameters(objRB.GetSectionByName(PAGE + HEADER), dblStartX, dblStartY, arrParamAndValue, objRB.Report.Font.Size); #endregion /// there are some hardcode numbers here /// but these numbers are use ONLY ONE and ONLY USED HERE, so we don't need to define constant for it. objRB.DrawBoxGroup_Madeby_Checkedby_Approvedby(objRB.GetSectionByName(PAGE + HEADER), 16005 - 1400 - 1400 - 1400, 600, 1400, 1300, 200); #region DAY--MONTH--YEAR INFO DateTime dtm; try { dtm = objUtilBO.GetDBDate(); } catch { dtm = DateTime.Now; } try { objRB.DrawPredefinedField(REPORTFLD_DAY, dtm.Day.ToString("00")); } catch {} try { objRB.DrawPredefinedField(REPORTFLD_MONTH, dtm.Month.ToString("00")); } catch {} try { objRB.DrawPredefinedField(REPORTFLD_YEAR, dtm.Year.ToString("0000")); } catch {} #endregion try // mapping report field with table column { objRB.DrawPredefinedField(REPORTFLD_CATEGORY, CATEGORY_COL); objRB.DrawPredefinedField(REPORTFLD_PARTNUMBER, PARTNUMBER_COL); objRB.DrawPredefinedField(REPORTFLD_PARTNAME, PARTNAME_COL); objRB.DrawPredefinedField(REPORTFLD_MODEL, MODEL_COL); objRB.DrawPredefinedField(REPORTFLD_STOCKUM, STOCKUM_COL); objRB.DrawPredefinedField(REPORTFLD_LOCATION, LOCATION_COL); objRB.DrawPredefinedField(REPORTFLD_OHQTY, OHQTY_COL); objRB.DrawPredefinedField(REPORTFLD_COMMITQTY, COMMITQTY_COL); objRB.DrawPredefinedField(REPORTFLD_AVAILABLEQTY, AVAILABLEQTY_COL); objRB.DrawPredefinedField(REPORTFLD_TYPE, TYPE_COL); objRB.DrawPredefinedField(REPORTFLD_SOURCE, SOURCE_COL); objRB.DrawPredefinedField(REPORTFLD_SAFETYSTOCK, SAFETYSTOCK_COL); objRB.DrawPredefinedField(REPORTFLD_LOT, LOT_COL); objRB.DrawPredefinedField(REPORTFLD_WARNING, WARNING_COL); } catch {} objRB.RefreshReport(); printPreview.Show(); #endregion UseReportViewerRenderEngine = false; mResult = dtbResult; return(dtbResult); }
public DataTable ExecuteReport(string pstrCCNID, string pstrMasLocID, string pstrPartyIDList, string pstrSaleOrderIDList, string pstrProductIDList) { try { const string DATE_FORMAT = "dd-MM-yyyy HH:mm"; const string REPORT_NAME = "SaleOrderManagementReport"; const string REPORT_LAYOUT = "SaleOrderManagementReport.xml"; const string RPT_PAGE_HEADER = "PageHeader"; //Report field names const string RPT_TITLE_FIELD = "fldTitle"; const string RPT_CCN = "CCN"; const string RPT_SO_NO = "SO No."; const string RPT_CUSTOMER = "Customer"; const string RPT_PART_NUMBER = "Part Number"; const string RPT_MASTER_LOCATION = "Master Location"; DataTable dtbTranHis = GetSaleOrderManagementData(pstrCCNID, pstrMasLocID, pstrPartyIDList, pstrSaleOrderIDList, pstrProductIDList); //Create builder object ReportBuilder reportBuilder = new ReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbTranHis; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_LAYOUT; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // And show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); string strCode = GetCCNInfoByID(pstrCCNID); arrParamAndValue.Add(RPT_CCN, strCode); //Master Location strCode = GetMasterLocationInfoByID(pstrMasLocID); arrParamAndValue.Add(RPT_MASTER_LOCATION, strCode); //Party Information if (pstrPartyIDList != null && pstrPartyIDList != string.Empty) { arrParamAndValue.Add(RPT_CUSTOMER, GetPartyInfo(pstrPartyIDList)); } //Sale Order Information if (pstrSaleOrderIDList != null && pstrSaleOrderIDList != string.Empty) { arrParamAndValue.Add(RPT_SO_NO, GetSaleOrderInfo(pstrSaleOrderIDList)); } //Product Information if (pstrProductIDList != null && pstrProductIDList != string.Empty) { arrParamAndValue.Add(RPT_PART_NUMBER, GetProductInfo(pstrProductIDList)); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text; } catch {} reportBuilder.RefreshReport(); printPreview.Show(); return(dtbTranHis); } catch (Exception ex) { throw ex; } }
public DataTable ExecuteReport(string pstrCCNID, string pstrMasLocID, string pstrFromDate, string pstrToDate, string pstrProductIDList, string pstrCustomerIDList, string pstrCurrencyIDList ) { try { const string DATE_FORMAT = "dd-MM-yyyy HH:mm"; const string REPORT_NAME = "SaleTransactionHistoryReport"; const string REPORT_LAYOUT = "SaleTransactionHistoryReport.xml"; const int FOOTER_HEIGHT = 10; const string RPT_PAGE_HEADER = "PageHeader"; const string RPT_CONFIRM_SHIP_NO_FOOTER = "ConfirmShipNoFooter"; //Report field names const string RPT_FIELD_PREFIX = "fld"; const string RPT_TITLE_FIELD = "fldTitle"; const string RPT_CCN = "CCN"; const string RPT_FROM_DATE = "From Date"; const string RPT_TO_DATE = "To Date"; const string RPT_PART_NUMBER = "Part Number"; const string RPT_MASTER_LOCATION = "Master Location"; const string RPT_CURRENCY = "Currency"; const string RPT_CUSTOMER = "Customer"; DataTable dtbTranHis = GetSaleTransactionHistoryData(pstrCCNID, pstrMasLocID, pstrFromDate, pstrToDate, pstrProductIDList, pstrCustomerIDList, pstrCurrencyIDList); //Create builder object ReportBuilder reportBuilder = new ReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbTranHis; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_LAYOUT; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // And show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); string strCode = GetCCNInfoByID(pstrCCNID); arrParamAndValue.Add(RPT_CCN, strCode); //Master Location strCode = GetMasterLocationInfoByID(pstrMasLocID); arrParamAndValue.Add(RPT_MASTER_LOCATION, strCode); //From Date if (pstrFromDate != null && pstrFromDate != string.Empty) { arrParamAndValue.Add(RPT_FROM_DATE, DateTime.Parse(pstrFromDate).ToString(DATE_FORMAT)); } //To Date if (pstrToDate != null && pstrToDate != string.Empty) { arrParamAndValue.Add(RPT_TO_DATE, DateTime.Parse(pstrToDate).ToString(DATE_FORMAT)); } //Product Information if (pstrProductIDList != null && pstrProductIDList != string.Empty) { arrParamAndValue.Add(RPT_PART_NUMBER, GetProductInfo(pstrProductIDList)); } //Customer Information if (pstrCustomerIDList != null && pstrCustomerIDList != string.Empty) { arrParamAndValue.Add(RPT_CUSTOMER, GetCustomerInfoByID(pstrCustomerIDList)); } //Currency Information if (pstrCurrencyIDList != null && pstrCurrencyIDList != string.Empty) { arrParamAndValue.Add(RPT_CURRENCY, GetCurrencyInfoByID(pstrCurrencyIDList)); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text; } catch {} //Hide footer if items were selected if (pstrProductIDList != null && pstrProductIDList != string.Empty) { C1.C1Report.Section confirmFooter = reportBuilder.GetSectionByName(RPT_CONFIRM_SHIP_NO_FOOTER); if (confirmFooter != null) { foreach (C1.C1Report.Field field in confirmFooter.Fields) { field.Top = 0; field.Visible = !(field.Name.StartsWith(RPT_FIELD_PREFIX)); } confirmFooter.Height = FOOTER_HEIGHT; } } reportBuilder.RefreshReport(); printPreview.Show(); return(dtbTranHis); } catch (Exception ex) { throw ex; } }
/// <summary> /// Build and show Detai lItem Price By PO Receipt /// </summary> /// <author> Tuan TQ, 11 Apr, 2006</author> public DataTable ExecuteReport(string pstrCCNID, string pstrStockTakingPeriodID, string pstrDepartmentIDs, string pstrProductionLineIDs, string pstrLocationIDs, string pstrBinIDs ) { // try // { string strPOTypeID = Convert.ToString((int)PCSComUtils.Common.POReceiptTypeEnum.ByInvoice); const string DATE_HOUR_FORMAT = "dd-MM-yyyy HH:mm"; const string REPORT_TEMPLATE = "StockTakingReport.xml"; const string RPT_PAGE_HEADER = "PageHeader"; const string REPORT_NAME = "StockTakingReport"; const string RPT_TITLE_FLD = "fldTitle"; const string RPT_COMPANY_FLD = "fldCompany"; const string RPT_CCN_FLD = "CCN"; const string RPT_MASTER_LOCATION_FLD = "Master Location"; const string RPT_LOCATION_FLD = "Master Location"; const string RPT_FROM_DATE_FLD = "From Date"; const string RPT_TO_DATE_FLD = "To Date"; const string RPT_PART_NO_FLD = "Part No."; const string RPT_TRANSACTION_TYPE_FLD = "Trans. Type"; DataTable dtbDataSource = null; dtbDataSource = GetStockTakingData(pstrCCNID, pstrStockTakingPeriodID, pstrDepartmentIDs, pstrProductionLineIDs, pstrLocationIDs, pstrBinIDs); //Create builder object ReportBuilder reportBuilder = new ReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbDataSource; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_TEMPLATE; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); reportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName()); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCNID)); arrParamAndValue.Add("StockTakingPeriod ", GetFieldInfoFromTable("IV_StockTakingPeriod", "Description", "StockTakingPeriodID", pstrStockTakingPeriodID)); // if (pstrDepartmentIDs != null && pstrDepartmentIDs != string.Empty) { arrParamAndValue.Add("Department ", GetFieldInfoFromTable(MST_DepartmentTable.TABLE_NAME, "Code", MST_DepartmentTable.DEPARTMENTID_FLD, pstrDepartmentIDs)); } // if (pstrProductionLineIDs != null && pstrProductionLineIDs != string.Empty) { arrParamAndValue.Add("Production Line ", GetFieldInfoFromTable(PRO_ProductionLineTable.TABLE_NAME, "Code", PRO_ProductionLineTable.PRODUCTIONLINEID_FLD, pstrProductionLineIDs)); } //Location list if (pstrLocationIDs != null && pstrLocationIDs != string.Empty) { arrParamAndValue.Add("Location ", GetLocationInfo(pstrLocationIDs)); } //Part no list if (pstrBinIDs != null && pstrBinIDs != string.Empty) { arrParamAndValue.Add("Bin ", GetFieldInfoFromTable(MST_BINTable.TABLE_NAME, "Code", MST_BINTable.BINID_FLD, pstrBinIDs)); } // // //Trans. type list // if(pstrTransTypeIDList != null && pstrTransTypeIDList != string.Empty) // { // arrParamAndValue.Add(RPT_TRANSACTION_TYPE_FLD, GetTransTypeInfo(pstrTransTypeIDList)); // } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text; } catch {} reportBuilder.RefreshReport(); printPreview.Show(); //return table return(dtbDataSource); // } // catch (Exception ex) // { // throw ex; // } }
public DataTable ExecuteReport(string pstrCCNID, string pstrFromDate, string pstrToDate, string pstrTransTypeID, string pstrGreaterThan0, string pstrMasLocID, string pstrLocationID, string pstrProductID) { try { const string DATE_FORMAT = "dd-MM-yyyy HH:mm"; const string REPORT_NAME = "TransactionHistoryReport"; const string REPORT_LAYOUT = "TransactionHistoryReport.xml"; const string RPT_PAGE_HEADER = "PageHeader"; //Report field names const string RPT_TITLE_FIELD = "fldTitle"; const string RPT_CCN = "CCN"; const string RPT_FROM_DATE = "From Date"; const string RPT_TO_DATE = "To Date"; const string RPT_LOCATION = "Location"; const string RPT_TRAN_TYPE = "Transation Type"; const string RPT_PART_NUMBER = "Part Number"; const string RPT_MODEL = "Model"; const string RPT_PART_NAME = "Part Name"; const string RPT_MASTER_LOCATION = "Master Location"; DataTable dtbTranHis = GetTransactionHistoryData(pstrCCNID, pstrFromDate, pstrToDate, pstrTransTypeID, pstrGreaterThan0, pstrMasLocID, pstrLocationID, pstrProductID); //Create builder object ReportBuilder reportBuilder = new ReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbTranHis; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_LAYOUT; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // And show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); string strCode = GetCCNInfoByID(pstrCCNID); arrParamAndValue.Add(RPT_CCN, strCode); arrParamAndValue.Add(RPT_FROM_DATE, DateTime.Parse(pstrFromDate).ToString(DATE_FORMAT)); arrParamAndValue.Add(RPT_TO_DATE, DateTime.Parse(pstrToDate).ToString(DATE_FORMAT)); //Master Location if (pstrMasLocID != null && pstrMasLocID != string.Empty) { strCode = GetMasterLocationInfoByID(pstrMasLocID); arrParamAndValue.Add(RPT_MASTER_LOCATION, strCode); } //Location if (pstrLocationID != null && pstrLocationID != string.Empty) { strCode = GetLocationInfoByID(pstrLocationID); arrParamAndValue.Add(RPT_LOCATION, strCode); } //Transaction Type if (pstrTransTypeID != null && pstrTransTypeID != string.Empty) { strCode = GetTranTypeName(pstrTransTypeID); arrParamAndValue.Add(RPT_TRAN_TYPE, strCode); } //Product Information if (pstrProductID != null && pstrProductID != string.Empty) { Hashtable htbProductInfo = GetProductInfoByID(pstrProductID); arrParamAndValue.Add(RPT_PART_NUMBER, htbProductInfo[PRODUCT_CODE].ToString()); arrParamAndValue.Add(RPT_PART_NAME, htbProductInfo[PRODUCT_NAME].ToString()); arrParamAndValue.Add(RPT_MODEL, htbProductInfo[PRODUCT_MODEL].ToString()); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text; } catch {} reportBuilder.RefreshReport(); printPreview.Show(); return(dtbTranHis); } catch (Exception ex) { throw ex; } }
/// <summary> /// Build and show Detai lItem Price By PO Receipt /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <author> Tuan TQ, 11 Apr, 2006</author> public DataTable ExecuteReport(string pstrCCNID, string pstrMasLocID, string pstrFromDate, string pstrToDate, string pstrCurrencyID, string pstrExchangeRate, string pstrProductIDList, string pstrVendorType, string pstrVendorIDList ) { string strPOTypeID = Convert.ToString((int)PCSComUtils.Common.POReceiptTypeEnum.ByInvoice); const string DATE_HOUR_FORMAT = "dd-MM-yyyy HH:mm"; const string NUMERIC_FORMAT = "#,##0.00"; const string REPORT_TEMPLATE_LOCAL = "ReceivingMaterialReport_Local.xml"; const string REPORT_TEMPLATE = "ReceivingMaterialReport.xml"; const string RPT_PAGE_HEADER = "PageHeader"; const string REPORT_NAME = "ReceivingMaterialReport"; const string RPT_TITLE_FLD = "fldTitle"; const string RPT_COMPANY_FLD = "fldCompany"; const string RPT_CCN_FLD = "CCN"; const string RPT_MASTER_LOCATION_FLD = "Master Location"; const string RPT_FROM_DATE_FLD = "From Date"; const string RPT_TO_DATE_FLD = "To Date"; const string RPT_PART_NUMBER_FLD = "Part Number"; const string RPT_CURRENCY_FLD = "Currency"; const string RPT_EXCHANGE_RATE_FLD = "Exchange Rate"; const string RPT_VENDOR_FLD = "Vendor"; const string RPT_VENDOR_TYPE_FLD = "Vendor Type"; DataTable dtbDataSource = null; string strHomeCurrency = GetHomeCurrency(pstrCCNID); dtbDataSource = GetReceivingMaterialReportData(pstrCCNID, pstrMasLocID, pstrFromDate, pstrToDate, pstrProductIDList, pstrCurrencyID, pstrExchangeRate, strHomeCurrency, pstrVendorType, pstrVendorIDList); //Create builder object ReportWithSubReportBuilder reportBuilder = new ReportWithSubReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbDataSource; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; if (pstrVendorType != null && pstrVendorType != string.Empty) { if (pstrVendorType.ToUpper() == LOCAL_STRING.ToUpper()) { reportBuilder.ReportLayoutFile = REPORT_TEMPLATE_LOCAL; } else { reportBuilder.ReportLayoutFile = REPORT_TEMPLATE; } } else { reportBuilder.ReportLayoutFile = REPORT_TEMPLATE; } reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); reportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName()); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCNID)); arrParamAndValue.Add(RPT_MASTER_LOCATION_FLD, GetMasterLocationInfoByID(pstrMasLocID)); Hashtable htbCurrency = GetCurrencyInfo(pstrCurrencyID); if (htbCurrency != null) { arrParamAndValue.Add(RPT_CURRENCY_FLD, htbCurrency[PRODUCT_CODE_FLD].ToString()); if (strHomeCurrency == pstrCurrencyID) { arrParamAndValue.Add(RPT_EXCHANGE_RATE_FLD, decimal.One.ToString(NUMERIC_FORMAT)); } else { if (pstrExchangeRate != string.Empty && pstrExchangeRate != null) { arrParamAndValue.Add(RPT_EXCHANGE_RATE_FLD, decimal.Parse(pstrExchangeRate).ToString(NUMERIC_FORMAT)); } else { arrParamAndValue.Add(RPT_EXCHANGE_RATE_FLD, decimal.Parse(htbCurrency[EXCHANGE_RATE_FLD].ToString()).ToString(NUMERIC_FORMAT)); } } } if (pstrFromDate != null && pstrFromDate != string.Empty) { arrParamAndValue.Add(RPT_FROM_DATE_FLD, DateTime.Parse(pstrFromDate).ToString(DATE_HOUR_FORMAT)); } if (pstrToDate != null && pstrToDate != string.Empty) { arrParamAndValue.Add(RPT_TO_DATE_FLD, DateTime.Parse(pstrToDate).ToString(DATE_HOUR_FORMAT)); } if (pstrProductIDList != null && pstrProductIDList != string.Empty) { arrParamAndValue.Add(RPT_PART_NUMBER_FLD, GetProductInfo(pstrProductIDList)); } if (pstrVendorType != null && pstrVendorType != string.Empty) { arrParamAndValue.Add(RPT_VENDOR_TYPE_FLD, pstrVendorType); } if (pstrVendorIDList != null && pstrVendorIDList != string.Empty) { arrParamAndValue.Add(RPT_VENDOR_FLD, GetPartyInfo(pstrVendorIDList)); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text; } catch {} reportBuilder.RefreshReport(); printPreview.Show(); //return table return(dtbDataSource); }
/// <summary> /// Thachnn: 28/10/2005 /// Preview the report for this form /// Using the "InventoryDetailReport.xml" layout /// </summary> /// <history>Thachnn: 29/12/2005: Add parameter display to the report. Change USECASE.</history> /// <param name="sender"></param> /// <param name="e"></param> public DataTable ExecuteReport(string pstrCCNID, string pstrMasterLocationID, string pstrLocationID, string pstrBinID, string pstrCategoryID, string pstrParameterModel) { #region Constants string mstrReportDefFolder = mstrReportDefinitionFolder; const string REPORT_LAYOUT_FILE = "InventoryDetailReport.xml"; const string TABLE_NAME = "InventoryDetailReport"; const string REPORT_NAME = "Inventory Detail"; const string PAGE = "Page"; const string HEADER = "Header"; const string REPORTFLD_TITLE = "fldTitle"; const string REPORTFLD_COMPANY = "fldCompany"; const string REPORTFLD_ADDRESS = "fldAddress"; const string REPORTFLD_TEL = "fldTel"; const string REPORTFLD_FAX = "fldFax"; const string REPORTFLD_DATETIME = "fldDateTime"; #endregion #region GETTING THE PARAMETER PCSComUtils.Common.BO.UtilsBO boUtil = new PCSComUtils.Common.BO.UtilsBO(); PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO objBO = new PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO(); string strCCN = boUtil.GetCCNCodeFromID(int.Parse(pstrCCNID)); string strMasterLocation = objBO.GetMasterLocationCodeFromID(int.Parse(pstrMasterLocationID)) + ": " + objBO.GetMasterLocationNameFromID(int.Parse(pstrMasterLocationID)); string strLocation = string.Empty; try { strLocation = objBO.GetLocationCodeFromID(int.Parse(pstrLocationID)); } catch {} string strBin = string.Empty; try { strBin = objBO.GetBinCodeFromID(int.Parse(pstrBinID)); } catch {} string strCategory = string.Empty; try { strCategory = objBO.GetCategoryCodeFromID(int.Parse(pstrCategoryID)); } catch {} #endregion float fActualPageSize = 9000f; #region Build dtbResult DataTable DataTable dtbResult; try { dtbResult = GetInventoryDetailData(pstrCCNID, pstrMasterLocationID, pstrLocationID, pstrBinID, pstrCategoryID, pstrParameterModel); } catch { dtbResult = new DataTable(); } #endregion ReportBuilder objRB; objRB = new ReportBuilder(); objRB.ReportName = REPORT_NAME; objRB.SourceDataTable = dtbResult; #region INIT REPORT BUIDER OBJECT try { objRB.ReportDefinitionFolder = mstrReportDefinitionFolder; objRB.ReportLayoutFile = REPORT_LAYOUT_FILE; if (objRB.AnalyseLayoutFile() == false) { // PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND, MessageBoxIcon.Error); return(new DataTable()); } //objRB.UseLayoutFile = objRB.AnalyseLayoutFile(); // use layout file if any , auto drawing if not found layout file objRB.UseLayoutFile = true; // always use layout file } catch { objRB.UseLayoutFile = false; // PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND,MessageBoxIcon.Error); } C1.C1Report.Layout objLayout = objRB.Report.Layout; fActualPageSize = objLayout.PageSize.Width - (float)objLayout.MarginLeft - (float)objLayout.MarginRight; #endregion objRB.MakeDataTableForRender(); //grid.DataSource = objRB.RenderDataTable; #region RENDER TO PRINT PREVIEW // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); printPreview.FormTitle = REPORT_NAME; objRB.ReportViewer = printPreview.ReportViewer; objRB.RenderReport(); #region COMPANY INFO header information get from system params // try // { // objRB.DrawPredefinedField(REPORTFLD_COMPANY,SystemProperty.SytemParams.Get(SystemParam.COMPANY_NAME)); // } // catch{} // try // { // objRB.DrawPredefinedField(REPORTFLD_ADDRESS,SystemProperty.SytemParams.Get(SystemParam.ADDRESS)); // } // catch{} // try // { // objRB.DrawPredefinedField(REPORTFLD_TEL,SystemProperty.SytemParams.Get(SystemParam.TEL)); // } // catch{} // try // { // objRB.DrawPredefinedField(REPORTFLD_FAX,SystemProperty.SytemParams.Get(SystemParam.FAX)); // } // catch{} #endregion #region DRAW Parameters const string CCN = "CCN"; const string MASTER_LOCATION = "Master Location"; const string LOCATION = "Location"; const string BIN = "Bin"; const string CATEGORY = "Category"; const string MODEL = "Model"; System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(CCN, strCCN); arrParamAndValue.Add(MASTER_LOCATION, strMasterLocation); if (pstrLocationID.Trim() != string.Empty) { arrParamAndValue.Add(LOCATION, strLocation); } if (pstrBinID.Trim() != string.Empty) { arrParamAndValue.Add(BIN, strBin); } if (pstrCategoryID.Trim() != string.Empty) { arrParamAndValue.Add(CATEGORY, strCategory); } if (pstrParameterModel.Trim() != string.Empty) { arrParamAndValue.Add(MODEL, pstrParameterModel); } /// anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = objRB.GetFieldByName(REPORTFLD_TITLE); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; objRB.GetSectionByName(PAGE + HEADER).CanGrow = true; objRB.DrawParameters(objRB.GetSectionByName(PAGE + HEADER), dblStartX, dblStartY, arrParamAndValue, objRB.Report.Font.Size); #endregion /// there are some hardcode numbers here /// but these numbers are use ONLY ONE and ONLY USED HERE, so we don't need to define constant for it. objRB.DrawBoxGroup_Madeby_Checkedby_Approvedby(objRB.GetSectionByName(PAGE + HEADER), 15945 - 1400 - 1400 - 1400, 600, 1400, 1300, 200); #region DAY--MONTH--YEAR INFO DateTime dtm; try { dtm = objUtilBO.GetDBDate(); } catch { dtm = DateTime.Now; } try { objRB.DrawPredefinedField(REPORTFLD_DATETIME, dtm.ToString("dd-MM-yyyy hh:mm")); } catch {} #endregion objRB.RefreshReport(); printPreview.Show(); #endregion UseReportViewerRenderEngine = false; mResult = dtbResult; return(dtbResult); }
public DataTable ExecuteReport(string pstrCCN, string pstrCategory, string pstrModel, string pstrSource, string pstrType, string pstrMakeItem) { try { //const char UNCHECK_SQUARE_CHAR = (char)111; //const char CHECK_SQUARE_CHAR = (char)120; //const char SPACE_CHAR = (char)32; //Report name const string REPORT_NAME = "ItemListReport"; const string REPORT_LAYOUT = "ItemListReport.xml"; const string RPT_HEADER = "Header"; //Report field names const string RPT_TITLE_FIELD = "fldTitle"; //Report field names const string RPT_CCN = "CCN"; const string RPT_CATEGORY = "Category"; const string RPT_MODEL = "Model"; const string RPT_SOURCE = "Source"; const string RPT_TYPE = "Type"; const string RPT_MAKE_ITEM = "Make"; DataTable dtbItemList = GetItemListData(pstrCCN, pstrCategory, pstrModel, pstrSource, pstrType, pstrMakeItem); //Create builder object ReportWithSubReportBuilder reportBuilder = new ReportWithSubReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbItemList; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_LAYOUT; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(RPT_CCN, pstrCCN); if (pstrCategory != string.Empty) { arrParamAndValue.Add(RPT_CATEGORY, pstrCategory); } if (pstrModel != string.Empty) { arrParamAndValue.Add(RPT_MODEL, pstrModel); } if (pstrSource != string.Empty) { arrParamAndValue.Add(RPT_SOURCE, pstrSource); } if (pstrType != string.Empty) { arrParamAndValue.Add(RPT_TYPE, pstrType); } if (pstrMakeItem.ToUpper().Equals("TRUE") || pstrMakeItem.Equals("1")) { arrParamAndValue.Add(RPT_MAKE_ITEM, "x"); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text; } catch {} //Show report reportBuilder.RefreshReport(); printPreview.Show(); return(dtbItemList); } catch (Exception ex) { throw ex; } }
/// <summary> /// Change header & column header of report /// </summary> /// <param name="pobjReportBuilder"></param> /// <param name="pintReportYear.ToString()"></param> /// <author> Tuan TQ, 07 Dec, 2005</author> private void ChangeReportDisplayInfo(ReportBuilder pobjReportBuilder, string pstrCCN, string pstrReportYear, string pstrReportMonth, string pstrPartyID, string pstrCategoryID, string pstrProductID) { try { #region Constants const string SHORT_DATE_FORMAT = "d-MMM"; //Report Field's Name const string RPT_COMPANY_FLD = "fldCompany"; const string RPT_PAGE_HEADER = "PageHeader"; //Report field names const string RPT_TITLE_FIELD = "fldTitle"; const string RPT_CCN_FLD = "CCN"; const string RPT_MONTH_FLD = "Month"; const string RPT_YEAR_FLD = "Year"; const string RPT_PARTY_CODE_NAME_FLD = "Customer"; const string RPT_CATEGORY_FLD = "Category"; const string RPT_ITEM_INFO_FLD = "Item(Part No., Part Name, Model)"; const string RPT_DAY_PREFIX = "fldDay_"; const string RPT_DAY_OF_WEEK_PREFIX = "fldDayOfWeek_"; const string RPT_QUANTITY_PREFIX = "fldQuantity_"; #endregion Constants //set start day in month int iReportYear = int.Parse(pstrReportYear); int iReportMonth = int.Parse(pstrReportMonth); DateTime dtmReportDay = new DateTime(iReportYear, iReportMonth, 1); int iDaysInMonth = DateTime.DaysInMonth(iReportYear, iReportMonth); //Change report header's value pobjReportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName()); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCN)); arrParamAndValue.Add(RPT_MONTH_FLD, pstrReportMonth); arrParamAndValue.Add(RPT_YEAR_FLD, pstrReportYear); if (pstrPartyID != null && pstrPartyID != string.Empty) { arrParamAndValue.Add(RPT_PARTY_CODE_NAME_FLD, GetCustomerInfoByID(pstrPartyID)); } if (pstrCategoryID != null && pstrCategoryID != string.Empty) { arrParamAndValue.Add(RPT_CATEGORY_FLD, GetCategoryInfoByID(pstrCategoryID)); } if (pstrProductID != null && pstrProductID != string.Empty) { string strItemInfo = string.Empty; Hashtable htbItem = GetProductInfoByID(pstrProductID); if (htbItem != null) { strItemInfo = htbItem[PRODUCT_CODE].ToString(); strItemInfo += ", " + htbItem[PRODUCT_NAME].ToString(); strItemInfo += ", " + htbItem[PRODUCT_MODEL].ToString(); } arrParamAndValue.Add(RPT_ITEM_INFO_FLD, strItemInfo); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = pobjReportBuilder.GetFieldByName(RPT_TITLE_FIELD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; pobjReportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; pobjReportBuilder.DrawParameters(pobjReportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, pobjReportBuilder.Report.Font.Size); //loop and change caption for (int i = 1; i <= iDaysInMonth; i++) { pobjReportBuilder.DrawPredefinedField(RPT_DAY_PREFIX + i, dtmReportDay.ToString(SHORT_DATE_FORMAT)); pobjReportBuilder.DrawPredefinedField(RPT_DAY_OF_WEEK_PREFIX + i, dtmReportDay.DayOfWeek.ToString().Substring(0, 3)); if (dtmReportDay.DayOfWeek == DayOfWeek.Sunday) { pobjReportBuilder.Report.Fields[RPT_DAY_PREFIX + i.ToString()].BackColor = Color.Yellow; pobjReportBuilder.Report.Fields[RPT_DAY_PREFIX + i.ToString()].ForeColor = Color.Red; pobjReportBuilder.Report.Fields[RPT_DAY_OF_WEEK_PREFIX + i.ToString()].BackColor = Color.Yellow; pobjReportBuilder.Report.Fields[RPT_DAY_OF_WEEK_PREFIX + i.ToString()].ForeColor = Color.Red; //pobjReportBuilder.Report.Fields[RPT_QUANTITY_PREFIX + i.ToString()].Visible = false; } dtmReportDay = dtmReportDay.AddDays(1); } //Company Info //pobjReportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, SystemProperty.SytemParams.Get(SystemParam.COMPANY_FULL_NAME)); //Hide fields those are not displayed for (int i = iDaysInMonth + 1; i <= MAX_DAYS_IN_MONTH; i++) { pobjReportBuilder.Report.Fields[RPT_DAY_PREFIX + i.ToString()].Visible = false; pobjReportBuilder.Report.Fields[RPT_DAY_OF_WEEK_PREFIX + i.ToString()].Visible = false; pobjReportBuilder.Report.Fields[RPT_QUANTITY_PREFIX + i.ToString()].Visible = false; } AdjustWidthAndLocation(pobjReportBuilder, iDaysInMonth); } catch (Exception ex) { throw ex; } }
public DataTable ExecuteReport(string pstrCCNID, string pstrCategoryID, string pstrModel, string pstrProductID) { try { const string REPORT_NAME = "ItemStandardCostReport"; const string REPORT_LAYOUT = "ItemStandardCostReport.xml"; const string RPT_PAGE_HEADER = "PageHeader"; const string RPT_TITLE_FLD = "fldTitle"; const string RPT_CURRENCY_FLD = "fldCurrency"; const string RPT_CCN_FLD = "CCN"; const string RPT_CATEGORY_FLD = "Category"; const string RPT_MODEL_FLD = "Model"; const string RPT_PART_NO_FLD = "Part No."; const string RPT_PART_NAME_FLD = "Part Name"; DataTable dtbData = BuildItemStandardCostData(pstrCCNID, pstrCategoryID, pstrModel, pstrProductID); //Create builder object ReportBuilder reportBuilder = new ReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbData; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_LAYOUT; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO objBO = new PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); reportBuilder.DrawPredefinedField(RPT_CURRENCY_FLD, GetHomeCurrency(pstrCCNID)); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); string strCode = GetCCNInfoByID(pstrCCNID); arrParamAndValue.Add(RPT_CCN_FLD, strCode); //Category if (pstrCategoryID != null && pstrCategoryID != string.Empty) { strCode = objBO.GetCategoryCodeFromID(pstrCategoryID); arrParamAndValue.Add(RPT_CATEGORY_FLD, strCode); } //Model if (pstrModel != null && pstrModel != string.Empty) { arrParamAndValue.Add(RPT_MODEL_FLD, pstrModel); } //Product Information if (pstrProductID != null && pstrProductID != string.Empty) { Hashtable htbProductInfo = GetProductInfoByID(pstrProductID); arrParamAndValue.Add(RPT_PART_NO_FLD, htbProductInfo[CODE_FLD].ToString()); arrParamAndValue.Add(RPT_PART_NAME_FLD, htbProductInfo[DESCRIPTION_FLD].ToString()); if (pstrModel == string.Empty || pstrModel == null) { arrParamAndValue.Add(RPT_MODEL_FLD, htbProductInfo[REVISION_FLD].ToString()); } else { arrParamAndValue[RPT_MODEL_FLD] = htbProductInfo[REVISION_FLD].ToString(); } } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text; } catch { } reportBuilder.RefreshReport(); printPreview.Show(); return(dtbData); } catch (Exception ex) { throw ex; } }
public DataTable ExecuteReport(string pstrMonth, string pstrYear, string pstrCustomerIDList) { try { const string DATE_FORMAT = "MMM-yyyy"; const string REPORT_NAME = "MonthlyReturnGoodsReceipt"; const string REPORT_LAYOUT = "MonthlyReturnGoodsReceipt.xml"; const string RPT_PAGE_HEADER = "PageHeader"; //Report field names const string RPT_TITLE_FIELD = "fldTitle"; const string RPT_REPORT_MONTH = "Month"; const string RPT_CUSTOMER = "Customer"; DataTable dtbTranHis = GetMonthlyReturnGoodsReceiptData(pstrMonth, pstrYear, pstrCustomerIDList); //Create builder object ReportBuilder reportBuilder = new ReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbTranHis; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_LAYOUT; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // And show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); //From Date if (pstrMonth != null && pstrMonth != string.Empty && pstrYear != null && pstrYear != string.Empty) { DateTime dtmTemp = new DateTime(int.Parse(pstrYear), int.Parse(pstrMonth), 1); arrParamAndValue.Add(RPT_REPORT_MONTH, dtmTemp.ToString(DATE_FORMAT)); } //Customer Information if (pstrCustomerIDList != null && pstrCustomerIDList != string.Empty) { arrParamAndValue.Add(RPT_CUSTOMER, GetCustomerInfoByID(pstrCustomerIDList)); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text; } catch {} reportBuilder.RefreshReport(); printPreview.Show(); return(dtbTranHis); } catch (Exception ex) { throw ex; } }
/// <summary> /// Build and show Detai lItem Price By PO Receipt /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <author> Tuan TQ, 11 Apr, 2006</author> public DataTable ExecuteReport(string pstrCCNID, string pstrFromDate, string pstrToDate, string pstrCurrencyIDList ) { try { string strPOTypeID = Convert.ToString((int)PCSComUtils.Common.POReceiptTypeEnum.ByInvoice); const string DATE_HOUR_FORMAT = "dd-MM-yyyy HH:mm"; const string NUMERIC_FORMAT = "#,##0.00"; const string REPORT_TEMPLATE = "ImportMaterialReport.xml"; const string RPT_PAGE_HEADER = "PageHeader"; const string REPORT_NAME = "ImportMaterialReport"; const string RPT_TITLE_FLD = "fldTitle"; const string RPT_COMPANY_FLD = "fldCompany"; const string RPT_CCN_FLD = "CCN"; const string RPT_FROM_DATE_FLD = "From Date"; const string RPT_TO_DATE_FLD = "To Date"; const string RPT_CURRENCY_FLD = "Currency"; DataTable dtbDataSource = null; dtbDataSource = GetImportMaterialReport(pstrCCNID, pstrFromDate, pstrToDate, pstrCurrencyIDList); //Create builder object ReportWithSubReportBuilder reportBuilder = new ReportWithSubReportBuilder(); //Set report name reportBuilder.ReportName = REPORT_NAME; //Set Datasource reportBuilder.SourceDataTable = dtbDataSource; //Set report layout location reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder; reportBuilder.ReportLayoutFile = REPORT_TEMPLATE; reportBuilder.UseLayoutFile = true; reportBuilder.MakeDataTableForRender(); // and show it in preview dialog PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog(); //Attach report viewer reportBuilder.ReportViewer = printPreview.ReportViewer; reportBuilder.RenderReport(); reportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName()); //Draw parameters System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection(); arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCNID)); if (pstrFromDate != null && pstrFromDate != string.Empty) { arrParamAndValue.Add(RPT_FROM_DATE_FLD, DateTime.Parse(pstrFromDate).ToString(DATE_HOUR_FORMAT)); } if (pstrToDate != null && pstrToDate != string.Empty) { arrParamAndValue.Add(RPT_TO_DATE_FLD, DateTime.Parse(pstrToDate).ToString(DATE_HOUR_FORMAT)); } if (pstrCurrencyIDList != null && pstrCurrencyIDList != string.Empty) { arrParamAndValue.Add(RPT_CURRENCY_FLD, GetCurrencyInfo(pstrCurrencyIDList)); } //Anchor the Parameter drawing canvas cordinate to the fldTitle C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD); double dblStartX = fldTitle.Left; double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight; reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true; reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size); try { printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text; } catch {} reportBuilder.RefreshReport(); printPreview.Show(); //return table return(dtbDataSource); } catch (Exception ex) { throw ex; } }