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