public static string getMake_Model_Style(int i, int Code, bool isEn = true)
{
CRMTree.DAL.DL_Car Car = new CRMTree.DAL.DL_Car();
CT_Car_Style style = Car.GetMake_Model_Style(i, Code);
if (style == null)
{
return(" ");
}
if (i == 1)
{
return(isEn ? style.MK_Make_EN : style.MK_Make_CN);
}
else if (i == 2)
{
return(isEn ? style.MK_Make_EN + "-" + style.CM_Model_EN : style.MK_Make_CN + "-" + style.CM_Model_CN);
}
else if (i == 3)
{
return(isEn ? style.MK_Make_EN + "-" + style.CM_Model_EN + "-" + style.CS_Style_CN : style.MK_Make_CN + "-" + style.CM_Model_CN + "-" + style.CS_Style_CN);
}
else
{
return(null);
}
}
public CT_Car_Style GetStyle(int CS_Code)
{
string strSql = "SELECT * FROM CT_Car_Style WHERE CS_Code=" + CS_Code + " ORDER BY CS_Style_CN;";
CT_Car_Style style = DataHelper.ConvertToObject <CT_Car_Style>(strSql);
return(style);
}
public static Object getMyCarStyle(int CS_Code)
{
BL_MyCar myCar = new BL_MyCar();
CT_Car_Style Style = myCar.getMyStyle(CS_Code);
if (Style != null && !Intern)
{
Style.CS_Style_EN = Style.CS_Style_CN;
}
return(Style);
}
public CT_Car_Style GetMake_Model_Style(int i, int Code)
{
string sqlStr = string.Empty;
if (i == 1)
{
sqlStr = string.Format(@"select MK_Code,MK_Make_EN,MK_Make_CN from CT_Make where MK_Code={0};", Code);
}
else if (i == 2)
{
sqlStr = string.Format(@"select MK_Code,MK_Make_EN,MK_Make_CN,CM_Code,CM_Model_EN,CM_Model_CN from CT_Make inner join CT_Car_Model on MK_Code=CM_MK_Code where CM_Code={0};", Code);
}
else if (i == 3)
{
sqlStr = string.Format(@"select MK_Code,MK_Make_EN,MK_Make_CN,CM_Code,CM_Model_EN,CM_Model_CN,CS_Code,CS_Style_EN,CS_Style_CN from CT_Make inner join CT_Car_Model on MK_Code=CM_MK_Code inner join CT_Car_Style on CM_Code=CS_CM_Code where CS_Code={0};", Code);
}
CT_Car_Style Make = DataHelper.ConvertToObject <CT_Car_Style>(sqlStr);
return(Make);
}
/// <summary>
/// 车信息和联动列表
/// </summary>
/// <param name="id"></param>
/// <param name="CI_CS_Code"></param>
private void Get_Car_InventoryAndLendon(int id)
{
dynamic d = new ExpandoObject();
var db = DBCRMTree.GetInstance();
d.CT_Car_Inventory = CT_Car_Inventory.SingleOrDefault(id);
d.CT_Car_Style = CT_Car_Style.SingleOrDefault(d.CT_Car_Inventory.CI_CS_Code);
//Get_CT_Car_Style(d.CT_Car_Inventory.CM_Code, d.CT_Car_Inventory.CI_YR_Code);
d.CT_Car_Inventory.CI_YR_Code = db.ExecuteScalar <Byte>(@"select YR_Code from [CT_Years]
where YR_Year = @0", d.CT_Car_Style.CS_Year);
d.CT_Car_Inventory.CM_Code = d.CT_Car_Style.CS_CM_Code;
// db.ExecuteScalar<int>(@"select cs_cm_code from [CT_Car_Style] where cs_code = @0", d.CT_Car_Inventory.CI_CS_Code);
d.CT_Car_Inventory.MK_Code = db.ExecuteScalar <int>(@"select cm_mk_code from [CT_Car_Model]
where cm_code = @0", d.CT_Car_Inventory.CM_Code);
d.CT_Car_Inventory.CP_Picture_FN = db.ExecuteScalar <string>(@" SELECT [CP_Picture_FN] + ',' FROM [CT_Car_Pictures]
WHERE CP_CI_Code =@0 FOR XML PATH('')" , d.CT_Car_Inventory.CI_Code);
d.CT_Car_Model = Get_CT_Car_Model(d.CT_Car_Inventory.MK_Code, d.CT_Car_Inventory.CI_YR_Code);
d.CT_Car_Style = Get_CT_Car_Style(d.CT_Car_Inventory.CM_Code, d.CT_Car_Inventory.CI_YR_Code);
d.CT_Auto_Insurance = CT_Auto_Insurance.FirstOrDefault("where AI_CI_Code = @0 order by AI_Update_dt desc", d.CT_Car_Inventory.CI_Code);
// d.CT_Auto_Insurance = CT_Auto_Insurance.SingleOrDefault(@"Select TOP 1
// AI_Code,AI_CI_Code,AI_IC_Code,AI_IA_Code,AI_Policy,AI_Start_dt,AI_End_dt,AI_Update_dt
// from CT_Auto_Insurance where AI_CI_Code = @0 order by AI_Update_dt desc", d.CT_Car_Inventory.CI_Code);
string sql_carInfo = string.Format(@"SELECT dbo.Get_Connect_Car(CI.CI_Code,1)AS CAR_CN,
dbo.Get_Connect_Car(CI.CI_Code,2)AS CAR_EN,MK_Code,CM_Code,CS_Code,CI.* FROM CT_Make MK
INNER JOIN CT_Car_Model CM ON CM.CM_MK_Code=MK.MK_Code
INNER JOIN CT_Car_Style CS ON CS.CS_CM_Code=CM.CM_Code
INNER JOIN CT_Car_Inventory CI ON CI.CI_CS_Code=CS.CS_Code
WHERE CI.CI_Code=@0");
d.carInfo = db.Query <dynamic>(sql_carInfo, id);
Response.Write(JsonConvert.SerializeObject(d));
}
