/// <versions>20-02-2018(GesAMFC-v1.0.0.3)</versions> private void Button_Print_Click(object sender, EventArgs e) { SpreadsheetControl_Recibo_Quotas.ShowPrintDialog(); }
/// <versions>20-02-2018(GesAMFC-v1.0.0.3)</versions> private void Load_Member_Quotas_Recibo() { try { String sFilePath = "Templates" + "/" + "Impresso_Quotas_Minuta" + "." + "xls"; SpreadsheetControl_Recibo_Quotas.LoadDocument(sFilePath, DevExpress.Spreadsheet.DocumentFormat.Xls); if ( Program.IsValidYear(this.YearSelected.Value) && (this.Member != null && this.Member.NUMERO >= this.Member.MinNumber && this.Member.NUMERO < this.Member.MaxNumber && !String.IsNullOrEmpty(this.Member.NOME)) ) { Double dQuotaMonthValue = Program.Get_Current_Parameter_QUOTA_Valor_Mes(); String sQuotaMonthValue = Program.SetPayCurrencyEuroStringValue(dQuotaMonthValue, Program.FormatString_Double2_Euro); //Double dQuotaYearValue = Convert.ToDouble(Decimal.Multiply(Convert.ToDecimal(dQuotaMonthValue), 12)); Double dQuotaYearValue = Program.Get_Current_Parameter_QUOTA_Valor_Ano(); String sQuotaYearValue = Program.SetPayCurrencyEuroStringValue(dQuotaYearValue, Program.FormatString_Double2_Euro); IWorkbook workbook = SpreadsheetControl_Recibo_Quotas.Document; Worksheet objWorksheet = workbook.Worksheets[0]; //objWorksheet.Rows[1].RowHeight = 1.5; //objWorksheet.Columns[1].ColumnWidth = 1.0; //objWorksheet.Columns[1].Alignment.Vertical = SpreadsheetVerticalAlignment.Center; //objWorksheet.Columns[2].ColumnWidth = 2.5; //objWorksheet.Columns[2].Alignment.WrapText = true; //objWorksheet.Cells["C2"].Formula = "FIELDPICTURE(\"Photo\", \"range\", C2, FALSE, 50)"; objWorksheet.Cells["J3"].Value = "Sócio Nº: " + this.Member.NUMERO; objWorksheet.Cells["D7"].Value = this.Member.NOME; objWorksheet.Cells["J4"].Value = sQuotaYearValue; objWorksheet.Cells["F9"].Value = "Quotas " + this.YearSelected.Value.ToString(); objWorksheet.Cells["F12"].Value = "Quotas " + this.YearSelected.Value.ToString(); objWorksheet.Cells["C13"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C14"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C15"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C16"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C17"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C18"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C19"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C20"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C21"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C22"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C23"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["C24"].Value = "Sócio nº: " + this.Member.NUMERO; objWorksheet.Cells["J13"].Value = sQuotaMonthValue; objWorksheet.Cells["J14"].Value = sQuotaMonthValue; objWorksheet.Cells["J15"].Value = sQuotaMonthValue; objWorksheet.Cells["J16"].Value = sQuotaMonthValue; objWorksheet.Cells["J17"].Value = sQuotaMonthValue; objWorksheet.Cells["J18"].Value = sQuotaMonthValue; objWorksheet.Cells["J19"].Value = sQuotaMonthValue; objWorksheet.Cells["J20"].Value = sQuotaMonthValue; objWorksheet.Cells["J21"].Value = sQuotaMonthValue; objWorksheet.Cells["J22"].Value = sQuotaMonthValue; objWorksheet.Cells["J23"].Value = sQuotaMonthValue; objWorksheet.Cells["J24"].Value = sQuotaMonthValue; } } catch (Exception ex) { Program.HandleError(ex.TargetSite.Name, ex.Message, Program.ErroType.EXCEPTION, true, false); } }