<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>一起定西 - 海典H2</title>
    <link>http://yqdx.com/forum.php?mod=forumdisplay&amp;fid=9</link>
    <description>Latest 20 threads of 海典H2</description>
    <copyright>Copyright(C) 一起定西</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Sat, 04 Apr 2026 09:45:23 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>http://yqdx.com/static/image/common/logo_88_31.gif</url>
      <title>一起定西</title>
      <link>http://yqdx.com/</link>
    </image>
    <item>
      <title>库房WMS作业未执行导致配送单未审核</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=314</link>
      <description><![CDATA[select *from hinosynt_item where distir_no=\'260203200000250\'
AND ISNULL(box_no,\'\')=\'\'
查询这个配送单
查看   在第一个数据库查询
EXEC p_hino_boxnotohydeeh2
执行作业

select * from openquery(HYDEELINK2,\'select * from       
                           ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Wed, 04 Feb 2026 03:14:13 +0000</pubDate>
    </item>
    <item>
      <title>海典H2  供应商查询语句</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=312</link>
      <description><![CDATA[采购订单流向

select 
       \'\'   as po_id,
       a.billno as po_no,
      a.execdate as po_time,
       a.vencusno as enterprise_inner_code,
      d.vencusname as enterprise_name,
       a.makeno     as po_batch_no,
       a.wareqty   as po_quantit]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Tue, 20 Jan 2026 08:30:50 +0000</pubDate>
    </item>
    <item>
      <title>支付宝医保刷脸设备无线切有线</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=311</link>
      <description><![CDATA[1、 进入终端网络设置界面
输入密码123456或111111进入有线网络配置界面2、配置IP地址。（终端通过有线方式接入到路由器（配置了医保IP，可以访问医保网））IP为路由器分配的IP网关为路由器网关地址子网掩码255.255.255.0DNS为10.126.192.693、重启终端，验证刷脸 ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Fri, 16 Jan 2026 06:44:43 +0000</pubDate>
    </item>
    <item>
      <title>异地因为退费导致的对账失败</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=310</link>
      <description><![CDATA[需要在海典医保云里面，对于配置进行更改。]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Fri, 26 Dec 2025 02:50:03 +0000</pubDate>
    </item>
    <item>
      <title>医保无码商品下账注意事项</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=308</link>
      <description><![CDATA[从2026.1.1起，无码商品一律不能刷医保。严格禁止。







重点要求：      1：无码商品刷卡必须要现在医保两定机构的无码库维护后，才能进行刷卡下账。 

                     2：尽可能无码商品、拆零商品与有码商品分单刷卡，这样对于医保对账不会牵扯太多，容易 ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Sat, 15 Nov 2025 03:26:48 +0000</pubDate>
    </item>
    <item>
      <title>通过数据库更新养护类型</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=306</link>
      <description><![CDATA[merge into t_ware_ext a 
using  (select  * from  t_ware  ) b
on (a.wareid=b.wareid and a.compid=b.compid  and  b.warecode=\'101111\')
when matched then
  update  set maintain_type =2   
where  compid =2  ;
merge into t_ware_ext a 
using  (select  *]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Fri, 10 Oct 2025 09:17:13 +0000</pubDate>
    </item>
    <item>
      <title>供应商隐藏系统参数</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=303</link>
      <description><![CDATA[供应商隐藏系统参数   ：系统参数 9102]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Tue, 30 Sep 2025 10:00:05 +0000</pubDate>
    </item>
    <item>
      <title>甘肃医保钱包刷卡设置</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=301</link>
      <description><![CDATA[]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Thu, 07 Aug 2025 00:27:44 +0000</pubDate>
    </item>
    <item>
      <title>库房WMS   清理</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=299</link>
      <description><![CDATA[create nonclustered index [idx_h_Elec_Info_code] on [dbo].[h_Elec_code]([Code] asc)]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Wed, 16 Jul 2025 02:26:18 +0000</pubDate>
    </item>
    <item>
      <title>海典H2导出门店零售明细（带支付方式）</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=297</link>
      <description><![CDATA[SELECT
a.saleno 销售单号,
a.rowno 销售单内流水号,
a.wareid 商品自编码,
q.warename 商品名称,
q.fileno  批准文号,
q.warespec  规格,
f_get_classname(\'03\',a.wareid,b.compid) 剂型,
q.barcode 本位码,
1 最小包装数量,
q.wareunit 最小包装单位,
q.wareunit 最小 ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Wed, 09 Jul 2025 10:02:54 +0000</pubDate>
    </item>
    <item>
      <title>厂家调取销售数据语句</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=295</link>
      <description><![CDATA[select
CASE 
  WHEN TO_CHAR(a.accdate, \'dd\') &gt;= 26 
  THEN TO_CHAR(ADD_MONTHS(a.accdate, 1), \'yyyy\') 
  ELSE TO_CHAR(a.accdate, \'yyyy\') 
END AS year,  -- 年

CASE 
  WHEN TO_CHAR(a.accdate, \'dd\') &gt;= 26 
  THEN TO_CHAR(ADD_MONTHS(a.accdate,]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Fri, 04 Jul 2025 00:22:46 +0000</pubDate>
    </item>
    <item>
      <title>海典H2 进销存  医保对账  销售明细导出</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=294</link>
      <description><![CDATA[----销售明细表2023
select distinct  a.INSTITUTIONCODE  as   门店编号,
         a.INSTITUTIONNAME  as  门店名称,
         to_char(a.erpsaleno)   as    流水号,
         h.accdate   as  开单日期,
         h.finaltime   as   开单时间,
         f_get_user ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Wed, 11 Jun 2025 10:04:47 +0000</pubDate>
    </item>
    <item>
      <title>查询门店进销存语句</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=293</link>
      <description><![CDATA[-----进销存  
select    \'XXXXX店\'    as   门店名称,
         to_char( w.warecode )  as  货号,
          max(w.warename)   as  商品名及通用名,
          max(w.warespec)   as  商品规格,
          max(w.wareunit)  as   单位,
          nvl(max(qc.qckc),0 ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Mon, 09 Jun 2025 08:57:50 +0000</pubDate>
    </item>
    <item>
      <title>查询门店零售是否加组</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=292</link>
      <description><![CDATA[select   goupid   from    t_sale_d    where   saleno=\'零售单号\'     主要看里面的time字段



select   *  from    t_sale_d    where   times &gt;=1  and  saleno=\'单号\'    里面的  times 组剂数     groupid 是组   主要看groupid   是不是有数字
 ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Mon, 09 Jun 2025 08:56:36 +0000</pubDate>
    </item>
    <item>
      <title>海典H2  导出数据（入库明细、配送明细、退仓明细）</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=291</link>
      <description><![CDATA[海典H1


---111表一：采购入库表_公司总库
---表一：采购入库表_公司总库
select 
f_get_busnoname(a.busno)  单位名称,
b.wareid  商品ID,
w.warename 商品名称,
b.makeno 批号,
CASE WHEN w.scan_flag = \'1\' THEN \'是\' ELSE \'否 \' END AS  是否集采商品,
to_char(a. ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Sat, 24 May 2025 06:25:05 +0000</pubDate>
    </item>
    <item>
      <title>甘肃医保追溯码上传</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=269</link>
      <description><![CDATA[1.机构有上传追溯码，为什么上传率是0？
请在两定端页面，查询、核对追溯码采集上传的数据是否规范：
1) MDTRT_SETL_TPYE 就诊结算类型，医保结算时为1，自费结算时为2。不是“1”的数据不纳入统计；
2) mdtrt sn就医流水号字段，当为医保结算时须上传医保的就诊ID,为其 ...]]></description>
      <category>海典H2</category>
      <author>admin</author>
      <pubDate>Thu, 10 Apr 2025 07:09:37 +0000</pubDate>
    </item>
    <item>
      <title>库房海诺的商品清楚追溯码</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=265</link>
      <description><![CDATA[delete from h_elec_info where wares_no=\'1198184\']]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Wed, 02 Apr 2025 02:03:38 +0000</pubDate>
    </item>
    <item>
      <title>修改海典H2的支付方式的名字</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=264</link>
      <description><![CDATA[SELECT s_dddw_list.dddwname,
       s_dddw_list.dddwlistdata,
       s_dddw_list.dddwliststatus,
       s_dddw_list.dddwlistdisplay,
       s_dddw_list.compidlist,
       s_dddw_list.notes,
       s_dddw_list.status,
       s_dddw_list.sort
 FROM]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Tue, 01 Apr 2025 08:42:09 +0000</pubDate>
    </item>
    <item>
      <title>甘肃医保测试及正式环境地址</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=263</link>
      <description><![CDATA[正式环境

医保接口:http://10.126.34.90/prd/hsa/hgs/{0}
接口编码:/prd/hsa/hgs/
服务路径:{infno}
医保划分 依据行政地址填写
接口ak:d869ebf5-3053-4f96-85aa-6721426e69b4
接口asp:64eb3d2fb6416135bc1742c5f366274f97c673f17fd6783262413d05f46bced7
读卡:http:// ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Fri, 28 Mar 2025 06:54:51 +0000</pubDate>
    </item>
    <item>
      <title>往来单位档案相关信息导出</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=262</link>
      <description><![CDATA[----往来单位的名称  编码  注册地址 仓库地址 往来单位类型 经营方式   还有证照里面的证照名称跟证照号码

SELECT 
       v_vencus.vencusno  as 编码,
       v_vencus.vencusname  as 往来单位的名称,
       v_vencus.address  as 注册地址 ,
       v_vencus.war ...]]></description>
      <category>海典H2</category>
      <author>wbv123</author>
      <pubDate>Thu, 27 Mar 2025 02:14:24 +0000</pubDate>
    </item>
  </channel>
</rss>