public fLocalHolidays()
{
InitializeComponent();
var iniYear = DateTime.Now.Year - 1;
var yearRange = 11;
cboYear.DataSource = Enumerable.Range(iniYear, yearRange).ToList();
cboCOD3.Source($"Select valor from dbo.Split((Select COD3 from SISTEMAS.dbo.Users where UserCode='{conn.User}'),'|') order by Valor", conn);
var _mainCOD3 = new StaticRS($"Select MainCOD3 from SISTEMAS.dbo.Users where UserCode='{conn.User}'", conn);
_mainCOD3.Open();
cboCOD3.Update();
cboCOD3.Value = _mainCOD3["MainCOD3"].ToString();
_mainCOD3.Close();
_mainCOD3 = null;
/*
* yearCalendar.MinDate = new System.DateTime(DateTime.Now.Year, 1, 1, 0, 0, 0, 0);
* yearCalendar.MaxDate = new System.DateTime(DateTime.Now.Year, 12, 31, 23, 59, 59, 100);
*/
cboYear.ValueChanged += CboYear_ValueChanged;
cboYear.Value = DateTime.Now.Year;
yearCalendar.CalendarDimensions = new Size(4, 3);
yearCalendar.DateSelected += YearCalendar_DateSelected;
conn.Open();
}
