public List <ConsumablesDocumentsDTO> GetInitialRecordsByRiseId(int pIntRiseId) { List <ConsumablesDocumentsDTO> lLstInitialRecordsDTO = new List <ConsumablesDocumentsDTO>(); Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); string lStrQuery = this.GetSQL("GetInitialRecordsByRiseId").InjectSingleValue("RiseId", pIntRiseId); //GetInitialRecordsByInvRequest lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { ConsumablesDocumentsDTO lObjInitialRecordsDTO = new ConsumablesDocumentsDTO { IdRise = int.Parse(lObjRecordset.Fields.Item("IdRise").Value.ToString()), Code = lObjRecordset.Fields.Item("Code").Value.ToString() == "0" ? string.Empty : lObjRecordset.Fields.Item("Code").Value.ToString(), ActivoCode = lObjRecordset.Fields.Item("Equipo").Value.ToString(), EcoNum = lObjRecordset.Fields.Item("NumEconomico").Value.ToString(), DocType = 0, //int.Parse(lObjRecordset.Fields.Item("ObjType").Value.ToString()), DieselM = double.Parse(lObjRecordset.Fields.Item("DieselM").Value.ToString()), DieselT = double.Parse(lObjRecordset.Fields.Item("DieselT").Value.ToString()), Gas = double.Parse(lObjRecordset.Fields.Item("Gasolina").Value.ToString()), F15W40 = double.Parse(lObjRecordset.Fields.Item("15W40").Value.ToString()), Hidraulic = double.Parse(lObjRecordset.Fields.Item("Hidraulico").Value.ToString()), SAE40 = double.Parse(lObjRecordset.Fields.Item("SAE_40").Value.ToString()), Transmition = double.Parse(lObjRecordset.Fields.Item("Transm").Value.ToString()), Oils = double.Parse(lObjRecordset.Fields.Item("Grasa").Value.ToString()), EquipmentType = lObjRecordset.Fields.Item("EqType").Value.ToString(), KmHr = double.Parse(lObjRecordset.Fields.Item("Km/Hr").Value.ToString()), }; /*lDblQuantity = string.IsNullOrEmpty(lObjRecordset.Fields.Item("Quantity").Value.ToString()) * ? 0 : double.Parse(lObjRecordset.Fields.Item("Quantity").Value.ToString()); * * AssignQuantityValue(ref lObjInitialRecordsDTO, lDblQuantity);*/ lLstInitialRecordsDTO.Add(lObjInitialRecordsDTO); lObjRecordset.MoveNext(); } } } catch (Exception lObjException) { LogService.WriteError(string.Format("[ConsumablesDAO - GetInitialRecordsByRiseId: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lLstInitialRecordsDTO); }
public List <ConsumablesDocumentsDTO> GetTotalsRecordsUDTByRiseId(int pIntRiseId) { List <ConsumablesDocumentsDTO> lLstInitialRecordsDTO = new List <ConsumablesDocumentsDTO>(); Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); string lStrQuery = this.GetSQL("GetTotalsRecordsUDTByRiseId").InjectSingleValue("RiseId", pIntRiseId); //GetInitialRecordsByInvRequest lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { ConsumablesDocumentsDTO lObjInitialRecordsDTO = new ConsumablesDocumentsDTO { IdRise = int.Parse(lObjRecordset.Fields.Item("U_IdRise").Value.ToString()), Code = lObjRecordset.Fields.Item("Code").Value.ToString() == "0" ? string.Empty : lObjRecordset.Fields.Item("Code").Value.ToString(), ActivoCode = lObjRecordset.Fields.Item("U_PrcCode").Value.ToString(), EcoNum = lObjRecordset.Fields.Item("U_EcoNum").Value.ToString(), DocType = 0, //int.Parse(lObjRecordset.Fields.Item("U_Type").Value.ToString()), DieselM = double.Parse(lObjRecordset.Fields.Item("U_DieselM").Value.ToString()), DieselT = double.Parse(lObjRecordset.Fields.Item("U_DieselT").Value.ToString()), Gas = double.Parse(lObjRecordset.Fields.Item("U_Gas").Value.ToString()), F15W40 = double.Parse(lObjRecordset.Fields.Item("U_F15W40").Value.ToString()), Hidraulic = double.Parse(lObjRecordset.Fields.Item("U_Hidraulic").Value.ToString()), SAE40 = double.Parse(lObjRecordset.Fields.Item("U_SAE40").Value.ToString()), Transmition = double.Parse(lObjRecordset.Fields.Item("U_Transmition").Value.ToString()), Oils = double.Parse(lObjRecordset.Fields.Item("U_Oils").Value.ToString()), KmHr = double.Parse(lObjRecordset.Fields.Item("U_KmHr").Value.ToString()), EquipmentType = lObjRecordset.Fields.Item("EqType").Value.ToString(), }; lLstInitialRecordsDTO.Add(lObjInitialRecordsDTO); lObjRecordset.MoveNext(); } } } catch (Exception lObjException) { LogService.WriteError(string.Format("[ConsumablesDAO - GetTotalsRecordsUDTByRiseId: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lLstInitialRecordsDTO); }
public List <ConsumablesDocumentsDTO> PurchasesDataTableToDTO(SAPbouiCOM.DataTable pObjDataTable) { try { List <ConsumablesDocumentsDTO> lLstConsumablesDocuments = new List <ConsumablesDocumentsDTO>(); for (int i = 0; i < pObjDataTable.Rows.Count; i++) { ConsumablesDocumentsDTO lObjConsumableDoc = new ConsumablesDocumentsDTO(); lObjConsumableDoc.Code = pObjDataTable.GetValue("CodeTPrch", i).ToString(); lObjConsumableDoc.IdRise = int.Parse(pObjDataTable.GetValue("IdRiPrch", i).ToString()); lObjConsumableDoc.ActivoCode = pObjDataTable.GetValue("ActCodPrc", i).ToString(); lObjConsumableDoc.EcoNum = pObjDataTable.GetValue("ActNumPrc", i).ToString(); lObjConsumableDoc.DieselM = 0; lObjConsumableDoc.DieselT = double.Parse(pObjDataTable.GetValue("DslTPrch", i).ToString()); lObjConsumableDoc.Gas = double.Parse(pObjDataTable.GetValue("GasPrch", i).ToString()); lObjConsumableDoc.F15W40 = double.Parse(pObjDataTable.GetValue("15W40Prch", i).ToString()); lObjConsumableDoc.Hidraulic = double.Parse(pObjDataTable.GetValue("HidPrch", i).ToString()); lObjConsumableDoc.SAE40 = double.Parse(pObjDataTable.GetValue("SAE40Prch", i).ToString()); lObjConsumableDoc.Transmition = double.Parse(pObjDataTable.GetValue("TransPrch", i).ToString()); lObjConsumableDoc.Oils = double.Parse(pObjDataTable.GetValue("OilsPrch", i).ToString()); lObjConsumableDoc.KmHr = 0; lObjConsumableDoc.DocType = int.Parse(pObjDataTable.GetValue("DocTyPrch", i).ToString()); lObjConsumableDoc.EquipmentType = pObjDataTable.GetValue("EqTypPrch", i).ToString(); lLstConsumablesDocuments.Add(lObjConsumableDoc); } return(lLstConsumablesDocuments); } catch (Exception pObjException) { LogService.WriteError(string.Format("[ConsumablesService - PurchasesDataTableToDTO: {0}]", pObjException.Message)); throw pObjException; } }