/// <versions>23-03-2018(GesAMFC-v1.0.0.3)</versions> //private void SetYearComboList() //{ // try // { // Int32 iSelecteIndex = 0; // Int32 iIndex = 0; // ComboBoxEdit_Year.Properties.Items.Clear(); // foreach (AMFCYear objYear in ListYears.List) // { // ComboboxItem objComboBoxItem = new ComboboxItem(objYear.Value, objYear.Description); // if (objYear.Value == this.YearSelected.Value) // iSelecteIndex = iIndex; // ComboBoxEdit_Year.Properties.Items.Add(objComboBoxItem); // iIndex++; // } // ComboBoxEdit_Year.SelectedIndex = iSelecteIndex; // } // catch (Exception ex) // { // Program.HandleError(ex.TargetSite.Name, ex.Message, Program.ErroType.EXCEPTION, true, false); // } //} /// <versions>23-03-2018(GesAMFC-v1.0.0.3)</versions> //private void SetMonthComboList() //{ // try // { // Int32 iSelecteIndex = 0; // Int32 iIndex = 0; // ComboBoxEdit_Month.Properties.Items.Clear(); // foreach (AMFCMonth objMonth in ListMonths.List) // { // ComboboxItem objComboBoxItem = new ComboboxItem(objMonth.Value, objMonth.Description); // if (objMonth.Value == this.MonthSelected.Value) // iSelecteIndex = iIndex; // ComboBoxEdit_Month.Properties.Items.Add(objComboBoxItem); // iIndex++; // } // ComboBoxEdit_Month.SelectedIndex = iSelecteIndex; // } // catch (Exception ex) // { // Program.HandleError(ex.TargetSite.Name, ex.Message, Program.ErroType.EXCEPTION, true, false); // } //} /// <versions>23-03-2018(GesAMFC-v1.0.0.3)</versions> private void Load_Folha_Caixa() { try { String sFilePath = "Templates" + "/" + "Folha_Caixa_Minuta" + "." + "xls"; SpreadsheetControl_Folha_Caixa.LoadDocument(sFilePath, DevExpress.Spreadsheet.DocumentFormat.Xls); if ( //Program.IsValidYear(this.YearSelected.Value) //&& //Program.IsValidMonth(this.MonthSelected.Value) Program.IsValidDateTime(this.DateSelected) ) { AMFCCashPayments objAMFCCashPayments = Get_DBF_Date_Folha_Caixa(); if (objAMFCCashPayments == null) { return; } IWorkbook workbook = SpreadsheetControl_Folha_Caixa.Document; Worksheet objWorksheet = workbook.Worksheets[0]; objWorksheet.Cells["B2"].Value = "FOLHA DE CAIXA DE " + this.DateSelected.ToString("dd/MM/yyyy", CultureInfo.CurrentCulture); String sCol_Socio_Numero = "B"; String sCol_Socio_Nome = "C"; String sCol_Pay_Descricao = "D"; String sCol_Pay_Valor = "E"; Int32 iRowsValuesStartIdx = 4; Int32 iRowTotalIdx = 30; foreach (AMFCCashPayment objPayment in objAMFCCashPayments.Payments) { objWorksheet.Cells[sCol_Socio_Numero + iRowsValuesStartIdx].Value = objPayment.SOCIO; objWorksheet.Cells[sCol_Socio_Nome + iRowsValuesStartIdx].Value = objPayment.NOME; objWorksheet.Cells[sCol_Pay_Descricao + iRowsValuesStartIdx].Value = objPayment.DESIGNACAO; objWorksheet.Cells[sCol_Pay_Valor + iRowsValuesStartIdx].Value = objPayment.VALOR; iRowsValuesStartIdx++; } if (iRowsValuesStartIdx < iRowTotalIdx) { objWorksheet.Rows.Remove(iRowsValuesStartIdx, iRowTotalIdx - iRowsValuesStartIdx - 1); } //else //Tinha de se formatrar as linhas tb dp de adicioná-las: tipo de letra, agrupadas e tipo de célula // objWorksheet.Rows.Insert(iRowsValuesStartIdx - 1, iRowsValuesStartIdx - iRowTotalIdx); //´Qdo for mais de 30 adicionar as linhas no template } } catch (Exception ex) { Program.HandleError(ex.TargetSite.Name, ex.Message, Program.ErroType.EXCEPTION, true, false); } }
/// <versions>23-03-2018(GesAMFC-v1.0.0.3)</versions> private void Button_Print_Click(object sender, EventArgs e) { SpreadsheetControl_Folha_Caixa.ShowPrintDialog(); }