public static Object getMyCarMode(int i, int CM_Code)
{
BL_MyCar myCar = new BL_MyCar();
CT_Car_Model Model = myCar.getCarModel(i, CM_Code);
if (Model != null && !Intern)
{
Model.CM_Model_EN = Model.CM_Model_CN;
}
return(Model);
}
/// <summary>
/// i=0是表示，根据CM_Code 获取Model；i=1是表示，根据CS_Code反推Model
/// </summary>
/// <param name="i"></param>
/// <param name="CM_Code"></param>
/// <returns></returns>
public CT_Car_Model GetModel(int i, int CM_Code)
{
string strSql = string.Empty;
if (i == 0)
{
strSql = @"select CM_Code,CM_Model_EN,CM_Model_CN from CT_Car_Model where CM_Code=@CM_Code;";
}
else if (i == 1)
{
strSql = @"select CM_Code,CM_Model_EN,CM_Model_CN
from CT_Car_Model inner join CT_Car_Style on CM_Code=CS_CM_Code where CS_Code=@CM_Code;";
}
SqlParameter[] parameters = { new SqlParameter("@CM_Code", SqlDbType.Int) };
parameters[0].Value = CM_Code;
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql, parameters);
CT_Car_Model Model = DataHelper.ConvertToObject <CT_Car_Model>(ds);
return(Model);
}
