public PODTrackingMapResponse GPSALLGlobalTracking(PODTrackingMapRequest Request)
{
PODTrackingMapResponse Response = new PODTrackingMapResponse();
string SqlWhere = "";
if (Request != null)
{
SqlWhere = this.SqlWhere(Request);
}
DbParam[] dbParams =
{
new DbParam("@sqlWhere", DbType.String, SqlWhere, ParameterDirection.Input)
};
DataTable dt = this.ExecuteDataTable("[Proc_GPSALLGlobalTracking]", dbParams);
Response.Response = dt.ConvertToEntityCollection <PODTrackingMap>();
//Response.ResponseHub = dt.Tables[1].ConvertToEntityCollection<PODTrackingMap>();
//Response.PODTrackingMap = dt.ConvertToEntityCollection<PodStatusLogMap>();
return(Response);
}
public PODTrackingMapResponse PartialPODView(PODTrackingMapRequest Request)
{
PODTrackingMapResponse Response = new PODTrackingMapResponse();
DbParam[] dbParams =
{
new DbParam("@sqlWhere", DbType.String, Request.ID, ParameterDirection.Input)
};
DataTable dt = new DataTable();
//if (Request.Type == "Car")
//{
// dt = this.ExecuteDataTable("Proc_GetVehicleTrajectoryCar", dbParams);
//}
//else
// {
dt = this.ExecuteDataTable("Proc_GetVehicleTrajectoryOrder", dbParams);
//}
Response.Response = dt.ConvertToEntityCollection <PODTrackingMap>();
//Response.PODTrackingMap = dt.ConvertToEntityCollection<PodStatusLogMap>();
return(Response);
}
