public static List <ExportEDIEntity> GetExportEdi(Int64 vesselId, Int64 voyageId, Int32 polId, Int32 locId) { string strExecution = "[exp].[rptExportEDI]"; List <ExportEDIEntity> lstDO = new List <ExportEDIEntity>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@VesselID", vesselId); oDq.AddBigIntegerParam("@VoyageID", voyageId); oDq.AddBigIntegerParam("@POLID", polId); oDq.AddBigIntegerParam("@LocationID", locId); oDq.AddBigIntegerParam("@cf", 2); DataTableReader reader = oDq.GetTableReader(); //while (reader.Read()) //{ // //Do nothing //} //reader.NextResult(); while (reader.Read()) { ExportEDIEntity container = new ExportEDIEntity(reader, false); lstDO.Add(container); } reader.Close(); } return(lstDO); }
public static List <ExportEDIEntity> GetExportEdiHeader(Int64 vesselId, Int64 voyageId, Int32 polId, Int32 locId) { string strExecution = "[exp].[rptExportEDI]"; List <ExportEDIEntity> lstDO = new List <ExportEDIEntity>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@VesselID", vesselId); oDq.AddBigIntegerParam("@VoyageID", voyageId); oDq.AddBigIntegerParam("@POLID", polId); oDq.AddBigIntegerParam("@LocationID", locId); oDq.AddBigIntegerParam("@cf", 1); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ExportEDIEntity shpbl = new ExportEDIEntity(reader, true); lstDO.Add(shpbl); } reader.Close(); } return(lstDO); }