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;
}
}
