public int GetWorkingDays(int year, int month) { int holidays = 0; int days = DateTime.DaysInMonth(year, month); for (int i = 1; i <= days; i++) { DateTime date = new DateTime(year, month, i); DayOfWeek dayofWeek = date.DayOfWeek; if (dayofWeek == DayOfWeek.Saturday || dayofWeek == DayOfWeek.Sunday) { holidays += 1; } } DatabaseSet.����DataTable table = new DatabaseSet.����DataTable(); ����TableAdapter.Instance.FillBy���(table, year, month); for (int i = 0; i < table.Rows.Count; i++) { DateTime date = (DateTime)table[i]["���"]; if ((bool)table[i]["�W�["]) { holidays += 1; } else { holidays -= 1; } } return days - holidays; }
public EditHourDataForm() { InitializeComponent(); _lwHelper = new LaborWageHelper(); _holidayTable = ����TableAdapter.Instance.GetByRange(Settings.UnfilledDate, DateTime.Today); rbProduce.Checked = true; // Load the lines _suspendLineChangedEvent = true; bsLine.DataSource = DatabaseSet.���uTable; // Load the nonproduce items bsNonProduce.DataSource = DatabaseSet.�D�Ͳ�Table; // Create a table for input bsHourData.DataSource = _dataTable = CreateDataTable(); cbbLine.ValueMember = cbbLine.DisplayMember = "���u"; cbbNonProduce.ValueMember = "�s��"; cbbNonProduce.DisplayMember = "�W��"; dtpDate.Value = dateFinishDate.Value = DateTime.Today; cbbLine.SelectedIndex = -1; _suspendLineChangedEvent = false; }