/// <summary> /// 获取车辆特定时间的驾驶员 /// </summary> /// <param name="plate"></param> /// <param name="date"></param> /// <returns></returns> public Sys_Users GetCarUser(string plate, DateTime date) { Sys_Car car = new Sys_Car(plate); string sql = string.Format(" select top 1 * from sys_caruser where CarId={0} and updatetime<'{1}' order by updatetime desc", car.Id, date); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { Sys_Users su = new Sys_Users(DBTool.GetIntFromRow(ds.Tables[0].Rows[0], "UserId", 0)); return(su); } else { return(null); } }
/// <summary> /// 获取车辆当前驾驶员 /// </summary> /// <param name="plate"></param> /// <returns></returns> public Sys_Users GetCarUser(string plate) { Sys_Car car = new Sys_Car(plate); return(GetCarUser(car.Id)); }
/// <summary> /// 更换车辆 /// </summary> /// <param name="userId"></param> /// <param name="carId"></param> /// <returns></returns> public bool ChangeCar(int userId, string CarPlate) { Sys_Car car = new Sys_Car(CarPlate); return(ChangeCar(userId, car.Id)); }