/// <summary> /// 查询已办列表 /// </summary> /// yand 15.11.27 /// qiy 16.03.08 /// yand 16.07.25(添加主要信息字段) /// <param name="page"></param> /// <param name="filters"></param> /// <returns></returns> public DataTable DoneList(Models.Pagination page, NameValueCollection filters) { filters.Add("CurrentUser", User.User.CurrentUserId.ToString()); CarHomeInfo carHome = new CarHomeInfo(); DataTable dt = instanceMapper.FindDoneList(page, filters); dt.Columns.Add("MainInfo", Type.GetType("System.String")); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i]["VehicleKey"].ToString())) { carHome = new DAL.Vehicle.CarHomeMapper().FindCarInfo(dt.Rows[i]["VehicleKey"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i]["Name"].ToString())) { dt.Rows[i]["MainInfo"] = "客户姓名:" + dt.Rows[i]["Name"]; } if (!string.IsNullOrEmpty(dt.Rows[i]["PlateNo"].ToString())) { dt.Rows[i]["MainInfo"] += " 车牌号:" + dt.Rows[i]["PlateNo"]; } if (!string.IsNullOrEmpty(carHome.Vehicle)) { dt.Rows[i]["MainInfo"] += " 车型:" + carHome.Vehicle; } } } return(dt); }
/// <summary> /// 根据车辆ID获取品牌,系列 /// </summary> /// yand 16.07.25 /// <param name="vehicleKey"></param> /// <returns></returns> public CarHomeInfo FindCarInfo(string vehicleKey) { CarHomeInfo carHome = new CarHomeInfo(); SqlCommand comm = carHomeHelper.GetSqlCommand(@" SELECT sv.Vehicle,ss.Series,sb.CarBrand FROM Sys_Vehicle AS sv LEFT JOIN Sys_Series AS ss ON sv.SeriesCode = ss.SeriesCode LEFT JOIN Sys_Brand AS sb ON sb.BrandCode = ss.BrandCode WHERE sv.VehicleCode =@VehicleKey "); carHomeHelper.AddInParameter(comm, "@VehicleKey", SqlDbType.NVarChar, vehicleKey); DataTable dt = carHomeHelper.ExecuteDataTable(comm); if (dt.Rows.Count > 0) { carHome = ConvertHelper.Data2Model <CarHomeInfo>(dt.Rows[0]); } return(carHome); }