private void InitStaffs()
{
DataTable dt = new DataTable();
_staffs = new Dictionary <string, OEEStaff>();
string dataBaseName = gVariable.basicInfoDatabaseName;
string commandText = "select * from `" + gVariable.employeeTableName + "`";
dt = mySQLClass.queryDataTableAction(dataBaseName, commandText, null);
try
{
for (int row = 0; row < dt.Rows.Count; row++)
{
OEEStaff staff;
staff = new OEEStaff(dt.Rows[row][STAFF_WORKID].ToString(),
dt.Rows[row][STAFF_NAME].ToString(),
dt.Rows[row][STAFF_WORKSHOP].ToString());
_staffs.Add(dt.Rows[row][STAFF_WORKID].ToString(), staff);
}
}
catch (Exception)
{
System.Console.WriteLine("Error: No Employees in the database");
}
}
private void BtnStaffQuery_Click(object sender, EventArgs e)
{
int yearStart = Convert.ToInt32(this.CmbYearStart.Text);
int yearEnd = Convert.ToInt32(this.CmbYearEnd.Text);
int monthStart = Convert.ToInt32(this.CmbMonthStart.Text);
int monthEnd = Convert.ToInt32(this.CmbMonthEnd.Text);
DateTime startTime = OEEUtils.ConvertToDayStartOfMonth(yearStart, monthStart);
DateTime endTime = OEEUtils.ConvertToDayEndOfMonth(yearEnd, monthEnd);
totalIndex = 1;
this.LvwMonthView.Items.Clear();
this.LvwDetailView.Items.Clear();
if (DateTime.Compare(startTime, endTime) > 0)
{
MessageBox.Show("起始时间不能大于终止时间", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string id = this.CmbStaffName.Text.Split(' ').First();
selectedStaff = staffs[id];
for (int year = yearStart; year <= yearEnd; year++)
{
if (monthEnd < monthStart)
{
monthEnd = OEETypes.MONTH_END;
}
for (int month = monthStart; month <= monthEnd; month++)
{
OEETypes.OutputInHours outputInHours;
DateTime start = OEEUtils.ConvertToDayStartOfMonth(year, month);
DateTime end = OEEUtils.ConvertToDayEndOfMonth(year, month);
outputInHours = selectedStaff.QueryLabourHour(start, end, factory);
ShowMonthList(outputInHours, selectedStaff.Name, year, month);
}
monthStart = 1;
}
}
}