/// <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);
}
}
