{tryine_classseo}
{tryine:include file="/temp/model/pub/top.html"}
    {tryine:loop table="Cy_Column" field=" * " where="parentid=2 and cl_id not in (3,4,5) " order="cl_px"}
  • {field.cl_name}
  • {/tryine:loop}

场景礼品定制针对企业送礼各种场景提供解决方案

更多选择>>

    {tryine:loopsql sql="SELECT top 8 * FROM dbo.Cy_Ad WHERE afenlei='首页场景礼品定制' AND a_open=1 ORDER BY apx ASC"}
  • {sqlfield.adletter}

    {sqlfield.adletter}
    点击>>

  • {/tryine:loopsql}

热门定制礼品为您定制好礼

更多选择>>

< >

企业礼品定制案例13年专注企业客户定制礼品,服务1000+企业客户

更多选择>>

设计师展示Designer display

    {tryine:loopsql sql="SELECT top 4 * FROM dbo.Cy_news WHERE classid=247 AND audit=1 and n_type like '%1%' AND newmodel LIKE '%2%' order by writertime desc,rootID desc"}
  • {sqlfield.title}

    {sqlfield.title}  {sqlfield.n_titlesub}

    {sqlfield.newscontent}
  • {/tryine:loopsql}

部分荣誉展示

点击查看更多荣誉

公司要闻

    {tryine:loopsql sql="SELECT top 5 *,subtitle = case when len(title) > 36 then substring(title,0,36)+'...' else title end,subcon = case when len(newscontentsub)>80 then substring(newscontentsub,0,80)+'...' else newscontentsub end,yy=datename(yyyy,writertime),mm=substring(convert(varchar(12),writertime,23),6,2),dd=datename(dd,writertime),time = substring(convert(varchar(12),writertime,23),6,5) FROM dbo.Cy_news WHERE classid=30 AND audit=1 and n_type like '%1%' AND newmodel LIKE '%2%' order by writertime desc,rootID desc"}
  • {sqlfield.dd}

    {sqlfield.yy}/{sqlfield.mm}

    {sqlfield.subtitle}

    {sqlfield.subcon}

  • {/tryine:loopsql}

礼品百科

    {tryine:loopsql sql="SELECT top 5 *,subtitle = case when len(title) > 36 then substring(title,0,36)+'...' else title end,subcon = case when len(newscontentsub)>80 then substring(newscontentsub,0,80)+'...' else newscontentsub end,yy=datename(yyyy,writertime),mm=substring(convert(varchar(12),writertime,23),6,2),dd=datename(dd,writertime),time = substring(convert(varchar(12),writertime,23),6,5) FROM dbo.Cy_news WHERE classid=31 AND audit=1 and n_type like '%1%' AND newmodel LIKE '%2%' order by writertime desc,rootID desc"}
  • 012345

    {sqlfield.subtitle}

    {sqlfield.subcon}

  • {/tryine:loopsql}
{tryine:include file="/temp/model/pub/foot.html"}