public List <DriverTrip> GetDriverTrip_ByDate(string date) { List <DriverTrip> list = new List <DriverTrip>(); string sql = string.Format(@"with tab1 as ( select Driver,Towhead from CTM_DriverLog where DATEDIFF(d,Date,'{0}')=0 ), tab2 as ( select DriverCode,JobNo,ContainerNo,FromDate,FromTime,ToDate,ToTime,Id from CTM_JobDet2 where DATEDIFF(d,FromDate,'{0}')=0 or DATEDIFF(d,ToDate,'{0}')=0 ) select tab1.Driver,tab1.Towhead,tab2.* from tab1 left outer join tab2 on tab1.Driver=tab2.DriverCode order by Driver,FromDate,FromTime,ToDate,ToTime", date); DataTable dt = ConnectSql.GetTab(sql); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; DriverTrip row = new DriverTrip(); row.Driver = dr["Driver"].ToString(); row.Towhead = dr["Towhead"].ToString(); row.ContainerNo = dr["ContainerNo"].ToString(); row.JobNo = dr["JobNo"].ToString(); row.FromDate = dr["FromDate"].ToString(); row.FromTime = dr["FromTime"].ToString(); row.ToDate = dr["ToDate"].ToString(); row.ToTime = dr["ToTime"].ToString(); row.Id = dr["Id"].ToString(); list.Add(row); } return(list); }
public DriverTrip GetDriverTripToast_ById(string Id) { string sql = string.Format(@"select det1.JobNo,det1.ContainerNo,det1.ContainerType,DriverCode,TowheadCode,convert(nvarchar,FromDate,111) as FromDate,FromTime,convert(nvarchar,ToDate,111) as ToDate,ToTime ,(case job.JobType when 'KD-IMP' then 'I' when 'KD-EXP' then 'E' when 'FCL-IMP' then 'I' when 'FCL-EXP' then 'E' else 'L' end) as JobType,LoadCode,StageCode,StageStatus from CTM_JobDet2 as det2 left outer join CTM_JobDet1 as det1 on det2.Det1Id=det1.Id left outer join CTM_Job as job on det1.JobNo=job.JobNo where det2.Id={0}", Id); DataTable dt = ConnectSql.GetTab(sql); DriverTrip toast = new DriverTrip(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; toast.Id = Id; toast.JobNo = dr["JobNo"].ToString(); toast.ContainerNo = dr["ContainerNo"].ToString(); toast.ContainerSize = dr["ContainerType"].ToString(); toast.Driver = dr["DriverCode"].ToString(); toast.Towhead = dr["TowheadCode"].ToString(); toast.FromDate = dr["FromDate"].ToString(); toast.FromTime = dr["FromTime"].ToString(); toast.ToDate = dr["ToDate"].ToString(); toast.ToTime = dr["ToTime"].ToString(); toast.JobType = dr["JobType"].ToString(); toast.LoadCode = dr["LoadCode"].ToString(); toast.StageCode = dr["StageCode"].ToString(); toast.StageStatus = dr["StageStatus"].ToString(); } return(toast); }
public void Add(ITrip driverTrip, ExtractPersonalAndTripRecords module) { var chain = driverTrip.TripChain; var driver = chain.Person; var driverID = driver.Id; int tripIndex = ComputeTripIndex(driverTrip, chain, driver, module); // Now that we have our index data see if it already exists for (int i = 0; i < _driverRecords.Count; i++) { if (_driverRecords[i].DriverID == driverID && _driverRecords[i].DriverTripID == tripIndex) { _driverRecords[i] = new DriverTrip(_driverRecords[i]); return; } } // If it was not found we need to add a new record _driverRecords.Add(new DriverTrip(driverID, tripIndex, 1)); }
public DriverTrip(DriverTrip previous) : this(previous.DriverID, previous.DriverTripID, previous.Count + 1) { }