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