/// <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,系列ID,年款ID /// </summary> /// yaoy 16.04.07 /// yand 16.07.25 改数据库链接以及查询方法 /// <param name="vehicle"></param> public void Get(IVehicleInfo vehicle) { //VehicleInfo vehicleInfo= vehicleIautosMapper.Find(vehicle.VehicleKey); VehicleInfo vehicleInfo = new DAL.Vehicle.CarHomeMapper().Find(vehicle.VehicleKey); vehicle.MakeCode = vehicleInfo.MakeCode; vehicle.FamilyCode = vehicleInfo.FamilyCode; vehicle.YearCode = vehicleInfo.YearCode; }