/***************************************************** Property ***************************************************/
public OEEEnergyManager(OEEFactory factory)
{
machineGroups = factory.MachineGroups;
InitializeComponent();
InitializeParameters();
InitializeChart();
InitializeList();
}
/***************************************************** Property ***************************************************/
/***************************************************** Functions ***************************************************/
public OEEStaffManager(OEEFactory thefactory)
{
factory = thefactory;
workshops = factory.Workshops;
staffs = factory.Staffs;
InitializeComponent();
InitializeParameters();
}
/****************************************** Function ****************************************/
public OEEMachineManager(OEEFactory factory)
{
machineGroups = factory.MachineGroups;
InitializeComponent();
InitializeQueryCondition();
InitialTabOutputCapacity();
InitialTabOutputStatus();
InitialTabOutputHours();
InitialOutputCapacityChartInfo();
DoQuery();
}
/***************************************************** Property ***************************************************/
public OEESummaryManager(OEEFactory factory)
{
machineGroups = factory.MachineGroups;
InitializeComponent();
InitializeParameters();
InitializeOEESummary();
InitializeTabPerformance();
InitializeTabHoursRate();
InitialTabQualityRate();
DoQuery();
}
public DataTable QueryLabourHourDetails(int year, int month, string name, OEEFactory factory)
{
DateTime queryStartTime = OEEUtils.ConvertToDayStartOfMonth(year, month);
DateTime queryEndTime = OEEUtils.ConvertToDayEndOfMonth(year, month);
OEEMachineGroup[] machineGroups = factory.MachineGroups;
DataTable dt = null;
for (int groupIndex = 0; groupIndex < machineGroups.Count(); groupIndex++)
{
foreach (OEEMachine machine in machineGroups[groupIndex].Machines)
{
DataTable temp = new DataTable();
string dataBaseName = machine.getDeviceDatabaseName();
string commandText = "select dispatchCode," +
"productCode," +
"productName," +
"processName," +
"serialNumber," +
"startTime," +
"completeTime," +
"qualifyNum, " +
"unqualifyNum," +
"machineID from " +
"`" + gVariable.dispatchListTableName + "`" +
" where completeTime >= '" + queryStartTime.ToString(OEETypes.QUERY_TIME_FORMAT) +
"' and completeTime <= '" + queryEndTime.ToString(OEETypes.QUERY_TIME_FORMAT) +
"' and reportor = '" + _id + "'";
temp = mySQLClass.queryDataTableAction(dataBaseName, commandText, null);
try
{
object[] obj = new object[temp.Columns.Count];
if (dt == null)
{
dt = temp.Clone();
}
for (int i = 0; i < temp.Rows.Count; i++)
{
temp.Rows[i].ItemArray.CopyTo(obj, 0);
dt.Rows.Add(obj);
}
}
catch (Exception)
{
}
}
}
return(dt);
}
//private OEEMachine[] machines;
/***************************************************** Property ***************************************************/
public OEECostManager(OEEFactory factory)
{
machineGroups = factory.MachineGroups;
InitializeComponent();
}
public OEETypes.OutputInHours QueryLabourHour(DateTime startTime, DateTime endTime, OEEFactory factory)
{
DateTime queryStartTime = OEEUtils.ConvertToStartOfDay(startTime);
DateTime queryEndTime = OEEUtils.ConvertToEndOfDay(endTime);
OEEMachineGroup[] machineGroups = factory.MachineGroups;
DataTable dt = null;
for (int groupIndex = 0; groupIndex < machineGroups.Count(); groupIndex++)
{
foreach (OEEMachine machine in machineGroups[groupIndex].Machines)
{
DataTable temp = new DataTable();
string dataBaseName = machine.getDeviceDatabaseName();
string commandText = "select startTime, completeTime, qualifyNum, unqualifyNum from " + "`" + gVariable.dispatchListTableName + "`" +
" where completeTime >= '" + queryStartTime.ToString(OEETypes.QUERY_TIME_FORMAT) + "' and completeTime <= '" + queryEndTime.ToString(OEETypes.QUERY_TIME_FORMAT) + "' and reportor = '" + _id + "'";
temp = mySQLClass.queryDataTableAction(dataBaseName, commandText, null);
try
{
object[] obj = new object[temp.Columns.Count];
if (dt == null)
{
dt = temp.Clone();
}
for (int i = 0; i < temp.Rows.Count; i++)
{
temp.Rows[i].ItemArray.CopyTo(obj, 0);
dt.Rows.Add(obj);
}
}
catch (Exception)
{
}
}
}
return(CalculateLabourHour(dt));
}