/// <summary>
/// 年款
/// </summary>
/// <param name="makeCode"></param>
/// <param name="familyCode"></param>
/// <returns></returns>
public List <ComboInfo> YearOption(string makeCode, string familyCode)
{
List <ComboInfo> list = new List <ComboInfo>();
SQLHelper iautosHelper = new SQLHelper(new WebConfigure("connIautos"));
SqlCommand comm = iautosHelper.GetSqlCommand(@"
SELECT yi.ID,yi.Year FROM IautosYearInfo AS yi
LEFT JOIN IautosSeriesInfo AS si ON si.SeriesID = yi.SeriesID
WHERE si.SeriesID = @SeriesID AND si.BrandID = @BrandID
ORDER BY Year DESC
");
iautosHelper.AddInParameter(comm, "@BrandID", SqlDbType.Int, makeCode);
iautosHelper.AddInParameter(comm, "@SeriesID", SqlDbType.Int, familyCode);
DataTable dt = iautosHelper.ExecuteDataTable(comm);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ComboInfo cbi = new ComboInfo(dr["ID"].ToString(), dr["Year"].ToString());
list.Add(cbi);
}
}
return(list);
}
/// <summary>
/// 系列
/// </summary>
/// <param name="makeCode"></param>
/// <returns></returns>
public List <ComboInfo> FamilyOption(string makeCode)
{
List <ComboInfo> list = new List <ComboInfo>();
SQLHelper iautosHelper = new SQLHelper(new WebConfigure("connIautos"));
SqlCommand comm = iautosHelper.GetSqlCommand(@"
SELECT SeriesID,SeriesName FROM IautosSeriesInfo WHERE BrandID = @BrandID ORDER BY SeriesName ASC
");
iautosHelper.AddInParameter(comm, "@BrandID", SqlDbType.Int, makeCode);
DataTable dt = iautosHelper.ExecuteDataTable(comm);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ComboInfo cbi = new ComboInfo(dr["SeriesID"].ToString(), dr["SeriesName"].ToString());
list.Add(cbi);
}
}
return(list);
}
/// <summary>
/// 获取二手车价格
/// </summary>
/// yaoy 16.04.08
/// <param name="vehicleKey"></param>
/// <param name="cityName"></param>
/// <returns></returns>
public decimal FindUsedVehicleIautosPrice(int vehicleKey, string cityName)
{
SQLHelper iautosHelper = new SQLHelper(new WebConfigure("connIautos"));
SqlCommand comm = iautosHelper.GetSqlCommand(@"
SELECT TOP(1) BuyPrice FROM CarSeriesRegionPrice
WHERE SpecialID = @VehicleKey AND CityName = @CityName
");
iautosHelper.AddInParameter(comm, "@VehicleKey", SqlDbType.Int, vehicleKey);
iautosHelper.AddInParameter(comm, "@CityName", SqlDbType.VarChar, "北京");
string temp = Convert.ToString(iautosHelper.ExecuteScalar(comm));
return(Convert.ToDecimal(0 + temp));
}
/// <summary>
/// 通过VehicleKey获取品牌ID,系列ID,年款ID
/// </summary>
/// yaoy 16.04.07
/// <param name="vehicleKey"></param>
/// <returns></returns>
public VehicleInfo Find(string vehicleKey)
{
VehicleInfo vehicle = new VehicleInfo();
SQLHelper iautosHelper = new SQLHelper(new WebConfigure("connIautos"));
SqlCommand comm = iautosHelper.GetSqlCommand(@"
SELECT CAST(isi.BrandID AS VARCHAR) AS MakeCode, si.SeriesID AS FamilyCode,CAST(si.yearsID AS VARCHAR) AS YearCode FROM IautosSpecialInfo AS si
LEFT JOIN IautosSeriesInfo AS isi ON isi.SeriesID = si.SeriesID
WHERE si.ID = @VehicleKey
");
iautosHelper.AddInParameter(comm, "@VehicleKey", SqlDbType.Int, vehicleKey);
DataTable dt = iautosHelper.ExecuteDataTable(comm);
if (dt.Rows.Count > 0)
{
vehicle = ConvertHelper.Data2Model <VehicleInfo>(dt.Rows[0]);
}
return(vehicle);
}
/// <summary>
/// 根据车辆ID获取品牌，系列
/// </summary>
/// yand 16.05.13
/// <param name="vehicleKey"></param>
/// <returns></returns>
public VehicleDescInfo FindDesc(string vehicleKey)
{
VehicleDescInfo vehicle = new VehicleDescInfo();
SQLHelper iautosHelper = new SQLHelper(new WebConfigure("connIautos"));
SqlCommand comm = iautosHelper.GetSqlCommand(@"
SELECT isi.brand, si.SpecialName,si.Year FROM IautosSpecialInfo AS si
LEFT JOIN IautosSeriesInfo AS isi ON isi.SeriesID = si.SeriesID
LEFT JOIN IautosBrandInfo AS ib ON ib.BrandID = isi.BrandID
WHERE si.ID = @VehicleKey
");
iautosHelper.AddInParameter(comm, "@VehicleKey", SqlDbType.Int, vehicleKey);
DataTable dt = iautosHelper.ExecuteDataTable(comm);
if (dt.Rows.Count > 0)
{
vehicle = ConvertHelper.Data2Model <VehicleDescInfo>(dt.Rows[0]);
}
return(vehicle);
}
/// <summary>
/// 根据车辆品牌查询车辆系列
/// </summary>
/// yand 16.07.25
/// <param name="brandCode">品牌ID</param>
/// <returns></returns>
public List <ComboInfo> GetSeries(string brandCode)
{
List <ComboInfo> list = new List <ComboInfo>();
SqlCommand comm = carHomeHelper.GetSqlCommand(@"
SELECT SeriesCode,Series FROM Sys_Series WHERE BrandCode = @SeriesCode ORDER BY Series ASC
");
carHomeHelper.AddInParameter(comm, "@SeriesCode", SqlDbType.NVarChar, brandCode);
DataTable dt = carHomeHelper.ExecuteDataTable(comm);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ComboInfo cbi = new ComboInfo(dr["SeriesCode"].ToString(), dr["Series"].ToString());
list.Add(cbi);
}
}
return(list);
}