public List <HoursRecordsDTO> DataTableToDTO(SAPbouiCOM.DataTable pObjDataTable) { List <HoursRecordsDTO> lLstHoursRecords = new List <HoursRecordsDTO>(); for (int i = 0; i < pObjDataTable.Rows.Count; i++) { HoursRecordsDTO lObjHoursRecords = new HoursRecordsDTO(); lObjHoursRecords.Code = pObjDataTable.GetValue("CodeHrs", i).ToString(); lObjHoursRecords.IdRise = int.Parse(pObjDataTable.GetValue("IdRiHrs", i).ToString()); lObjHoursRecords.ContractEntry = int.Parse(pObjDataTable.GetValue("ContOVHrs", i).ToString()); lObjHoursRecords.ContractDocNum = int.Parse(pObjDataTable.GetValue("CDEOVHrs", i).ToString()); lObjHoursRecords.DateHour = DateTime.Parse(pObjDataTable.GetValue("DateHrs", i).ToString()); lObjHoursRecords.SupervisorId = int.Parse(pObjDataTable.GetValue("SupIdHrs", i).ToString()); lObjHoursRecords.Supervisor = pObjDataTable.GetValue("SupNmHrs", i).ToString(); lObjHoursRecords.OperatorId = int.Parse(pObjDataTable.GetValue("OpdIdHrs", i).ToString()); lObjHoursRecords.OperatorName = pObjDataTable.GetValue("OpdNmHrs", i).ToString(); lObjHoursRecords.PrcCode = pObjDataTable.GetValue("EqpHrs", i).ToString(); lObjHoursRecords.EcoNum = pObjDataTable.GetValue("NumEcnHrs", i).ToString(); lObjHoursRecords.HrFeet = double.Parse(pObjDataTable.GetValue("HrsFeetHr", i).ToString()); lObjHoursRecords.SectionId = int.Parse(pObjDataTable.GetValue("SctnIdHrs", i).ToString()); lObjHoursRecords.Section = pObjDataTable.GetValue("SctnNnHrs", i).ToString(); lObjHoursRecords.KmHt = double.Parse(pObjDataTable.GetValue("KmHcHrs", i).ToString()); lObjHoursRecords.Pending = double.Parse(pObjDataTable.GetValue("PendHrs", i).ToString()); lObjHoursRecords.Close = pObjDataTable.GetValue("CloseHrs", i).ToString(); lLstHoursRecords.Add(lObjHoursRecords); } return(lLstHoursRecords); }
public List <HoursRecordsDTO> GetHoursRecordsByRiseId(int pIntRiseId) { List <HoursRecordsDTO> lLstHoursRecordsDTO = new List <HoursRecordsDTO>(); Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); string lStrQuery = this.GetSQL("GetHoursUDTByRiseId").InjectSingleValue("RiseId", pIntRiseId.ToString()); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { HoursRecordsDTO lObjHoursRecordsDTO = new HoursRecordsDTO { Code = lObjRecordset.Fields.Item("Code").Value.ToString(), ContractEntry = int.Parse(lObjRecordset.Fields.Item("DocEntry").Value.ToString()), ContractDocNum = int.Parse(lObjRecordset.Fields.Item("DocNum").Value.ToString()), IdRise = int.Parse(lObjRecordset.Fields.Item("U_IdRise").Value.ToString()), DateHour = DateTime.Parse(lObjRecordset.Fields.Item("U_DateHour").Value.ToString()), SupervisorId = int.Parse(lObjRecordset.Fields.Item("U_Supervisor").Value.ToString()), Supervisor = lObjRecordset.Fields.Item("SupervisorName").Value.ToString(), OperatorId = int.Parse(lObjRecordset.Fields.Item("U_Operator").Value.ToString()), OperatorName = lObjRecordset.Fields.Item("OperatorName").Value.ToString(), PrcCode = lObjRecordset.Fields.Item("U_PrcCode").Value.ToString(), EcoNum = lObjRecordset.Fields.Item("U_EcoNum").Value.ToString(), HrFeet = double.Parse(lObjRecordset.Fields.Item("U_HrFeet").Value.ToString()), SectionId = int.Parse(lObjRecordset.Fields.Item("U_Section").Value.ToString()), Section = lObjRecordset.Fields.Item("SectionName").Value.ToString(), //string.Empty, KmHt = double.Parse(lObjRecordset.Fields.Item("U_KmHt").Value.ToString()), Pending = double.Parse(lObjRecordset.Fields.Item("U_Pending").Value.ToString()), Close = lObjRecordset.Fields.Item("U_Close").Value.ToString(), ContractClient = lObjRecordset.Fields.Item("ClientName").Value.ToString(), }; lLstHoursRecordsDTO.Add(lObjHoursRecordsDTO); lObjRecordset.MoveNext(); } } } catch (Exception lObjException) { LogService.WriteError(string.Format("[HoursRecordsDAO - GetHoursRecordsByRiseId: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lLstHoursRecordsDTO); }