/// <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);
}
