Line 223: protected void loadModel()
Line 224: {
Line 225: DataSet ds = dbu.executeQuery("select * from (select distinct convert(varchar,md.model_select) as variant,(select top 1 id from tb_75020_model_detail where cc=md.cc and variant=md.variant) as bike_name_id,convert(varchar,(select top 1 id from tb_75020_model_detail where cc=md.cc and variant=md.variant))+'-'+convert(varchar,md.variant_id)as variant_id from tb_75019_model_assign ma join tb_75020_model_detail md on ma.model_id=md.variant_id join tb_75010_model_master mm on md.root_model_id=mm.model_id where md.visible=1 and md.id=" + Request.QueryString["variant_id"].ToString() + " and md.variant_id=" + Request.QueryString["modelid"].ToString() + ") model order by bike_name_id");
Line 226: if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
Line 227: {
|