行 138: strSql = "select a.*,b.Title as bTitle from ProductInfo a left join ProType b on a.Ftype=b.Id where a.Ftype in(" + sbTypeId.ToString().Trim(',') + ") order by instr('," + sbTypeId.ToString().Trim(',') + ",',b.Id),b.Orders asc, a.Orders asc";
行 139: //strSql = "select a.*,b.Title as bname,c.Title as cname from (ProductInfo a left join ProType b on a.Type=b.Id) left join ProType c on a.FType=c.Id where a.Ftype=" + strId + " order by c.Orders asc ,b.Orders asc,a.Orders asc";
行 140: strTitle = DBHelpers.ExecuteScalar(DBHelpers.conn, "select Title from ProType where Id=" + strId + "", null).ToString();
行 141: }else if(Request["Title"]!=null){
行 142: foreach (ProductType PInfo in ListTypeInfo)
|