public List <TransitHoursRecordsDTO> GetTransitHoursRecordsByRiseId(int pIntRiseId)
{
List <TransitHoursRecordsDTO> lLstTransitHoursRecordsDTO = new List <TransitHoursRecordsDTO>();
Recordset lObjRecordset = null;
try
{
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
string lStrQuery = this.GetSQL("GetTransitHoursUDTByRiseId").InjectSingleValue("RiseId", pIntRiseId.ToString());
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
TransitHoursRecordsDTO lObjTransitHoursRecordsDTO = new TransitHoursRecordsDTO
{
Code = lObjRecordset.Fields.Item("Code").Value.ToString(),
Hrs = double.Parse(lObjRecordset.Fields.Item("U_Hrs").Value.ToString()),
PrcCode = lObjRecordset.Fields.Item("U_PrcCode").Value.ToString(),
IdRise = int.Parse(lObjRecordset.Fields.Item("U_IdRise").Value.ToString()),
EcoNum = lObjRecordset.Fields.Item("U_EcoNum").Value.ToString(),
OperatorId = int.Parse(lObjRecordset.Fields.Item("U_Operator").Value.ToString()),
OperatorName = lObjRecordset.Fields.Item("OperatorName").Value.ToString(),
SupervisorId = int.Parse(lObjRecordset.Fields.Item("U_Supervisor").Value.ToString()),
SupervisorName = lObjRecordset.Fields.Item("SupervisorName").Value.ToString(),
};
lLstTransitHoursRecordsDTO.Add(lObjTransitHoursRecordsDTO);
lObjRecordset.MoveNext();
}
}
}
catch (Exception lObjException)
{
LogService.WriteError(string.Format("[TransitHoursRecordsDAO - GetTransitHoursRecordsByRiseId: {0}]", lObjException.Message));
throw new DAOException(lObjException.Message, lObjException);
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lLstTransitHoursRecordsDTO);
}
public List <TransitHoursRecordsDTO> DataTableToDTO(SAPbouiCOM.DataTable pObjDataTable)
{
List <TransitHoursRecordsDTO> lLstTransitHours = new List <TransitHoursRecordsDTO>();
for (int i = 0; i < pObjDataTable.Rows.Count; i++)
{
TransitHoursRecordsDTO lObjHoursRecords = new TransitHoursRecordsDTO();
lObjHoursRecords.Code = pObjDataTable.GetValue("CodeTH", i).ToString();
lObjHoursRecords.IdRise = int.Parse(pObjDataTable.GetValue("IdRiTHrs", i).ToString());
lObjHoursRecords.PrcCode = pObjDataTable.GetValue("MaqTHrs", i).ToString();
lObjHoursRecords.EcoNum = pObjDataTable.GetValue("NumEcoTH", i).ToString();
lObjHoursRecords.Hrs = double.Parse(pObjDataTable.GetValue("HrsTH", i).ToString());
lObjHoursRecords.OperatorId = int.Parse(pObjDataTable.GetValue("OpdTH", i).ToString());
lObjHoursRecords.OperatorName = pObjDataTable.GetValue("OpdNmTH", i).ToString();
lLstTransitHours.Add(lObjHoursRecords);
}
return(lLstTransitHours);
}