<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>一起定西 - 海典H1</title>
    <link>http://yqdx.com/forum.php?mod=forumdisplay&amp;fid=8</link>
    <description>Latest 20 threads of 海典H1</description>
    <copyright>Copyright(C) 一起定西</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Sat, 04 Apr 2026 11:25:39 +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>海典H1  医保对账表、销售明细表、进销存</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=254</link>
      <description><![CDATA[-----医保对账表
select  c.PsnName as 人员姓名,
        c.CERTNO  as  身份证,
        ord.OutSaleNo  as 系统流水号,
        c.psnno   as  人员信息编号,
        c.SETTELID  as   结算ID,
        c.MDTRTID  as  就医ID,
        ord.settletime   as  结算时 ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Wed, 26 Feb 2025 09:31:05 +0000</pubDate>
    </item>
    <item>
      <title>海典H1 期初 期末库存导出</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=216</link>
      <description><![CDATA[]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 12 Dec 2024 02:09:17 +0000</pubDate>
    </item>
    <item>
      <title>海典H1 ERP医保参数说明</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=207</link>
      <description><![CDATA[**上线必须设置参数**------------------------------------------------------
 主要零售录入功能，录入的商品是否显示医保标识标志
是否启用标准版医保云对接(必填)
医保云ERP交互页面调用地址，一般地址默认为127.0.0.1  端口为：7070（必填）
医保云ERP交互交易接 ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Mon, 02 Dec 2024 00:35:35 +0000</pubDate>
    </item>
    <item>
      <title>海典H1 赠品库存(赠品有库存但是会员积分兑换显示0）</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=64</link>
      <description><![CDATA[ALTER trigger [dbo].[tr_u_pst_out_u] on [dbo].[u_pst_out] for insert,update,delete
as
declare @trigger varchar(8000)
declare @2808 varchar(10),@status_i int,@status_d int
declare @busno varchar(10),@pstid varchar(20),@makeno varchar(100),@invalidate]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 03:00:04 +0000</pubDate>
    </item>
    <item>
      <title>传输麻黄碱出错数据库执行</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=63</link>
      <description><![CDATA[if object_id(‘d_ware_xq’) is not null drop table d_ware_xqCREATE TABLE [dbo].[d_ware_xq](
[wareid] varchar NULL,
[barcode] varchar NULL,
[abc] varchar NULL,
[warename] varchar NULL,
[waresimname] varchar NULL,
[warespec] varchar NULL,
[prod_add] va]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:59:36 +0000</pubDate>
    </item>
    <item>
      <title>ADD退仓单更新到退仓申请单</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=62</link>
      <description><![CDATA[update u_distapply_m set distno=’退仓单’ where applyno=’退仓申请单 ‘]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:59:19 +0000</pubDate>
    </item>
    <item>
      <title>查美团商品是否同步</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=61</link>
      <description><![CDATA[select * from t_ol_stock_update
where wareid in (‘103551′,’102641′,’100859’)select * from t_he_ware_store_busi is_upd_price]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:59:05 +0000</pubDate>
    </item>
    <item>
      <title>数据库查询机器的MAC</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=60</link>
      <description><![CDATA[select * from master..sysprocesses where hostname=’电脑名称’]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:58:51 +0000</pubDate>
    </item>
    <item>
      <title>门店收货单单独隐藏一个配送单</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=59</link>
      <description><![CDATA[create table #disable_u_dist_c (id int)
update u_dist_c set md_wareqty =wareqty where distno = ‘001817070518009（门店配送单）’
drop table #disable_u_dist_c]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:58:34 +0000</pubDate>
    </item>
    <item>
      <title>店间调拨传输报错作废调拨单</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=58</link>
      <description><![CDATA[CREATE TABLE #disable_u_distapply_m(id int)
UPDATE dbo.u_distapply_m SET status=2 WHERE applyno=”
DROP TABLE #disable_u_distapply_mcreate table #disable_u_distapply_m(id int)
update u_distapply_m
set status=’2′(单据状态）
where billcode=’APD’ an ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:58:19 +0000</pubDate>
    </item>
    <item>
      <title>店间调拨太大导致传输不过的解决办法</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=57</link>
      <description><![CDATA[select ‘insert #ws_u_distapply_m select ‘+dbo.f_var_to_string(billcode)+’,’+dbo.f_var_to_string(applyno)+’,’+dbo.f_var_to_string(srcbusno)+’,’+dbo.f_var_to_string(objbusno)+’,’+dbo.f_var_to_string(status)+’,’+dbo.f_var_to_string(checkbit1 ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:58:03 +0000</pubDate>
    </item>
    <item>
      <title>店间调拨太大导致传输不过的解决办法</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=56</link>
      <description><![CDATA[select ‘insert #ws_u_distapply_m select ‘+dbo.f_var_to_string(billcode)+’,’+dbo.f_var_to_string(applyno)+’,’+dbo.f_var_to_string(srcbusno)+’,’+dbo.f_var_to_string(objbusno)+’,’+dbo.f_var_to_string(status)+’,’+dbo.f_var_to_string(checkbit1 ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:57:45 +0000</pubDate>
    </item>
    <item>
      <title>更改入库单单号及时间</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=55</link>
      <description><![CDATA[入库单修改单号及日期
create table #disable_u_accept_m (id int)
update u_accept_m set acceptno=’新单号’,execdate=’新日期’,createtime=’新日期’ where acceptno=’原单号’ and billcode=’ACC’
drop table #disable_u_accept_m入库单更新下面商品明细
cre ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:57:25 +0000</pubDate>
    </item>
    <item>
      <title>更改销售单号中一个商品的实收金额</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=54</link>
      <description><![CDATA[通过销售单号修改里面的一个商品的实收金额查询
select netprice, * from u_sale_c where saleno=’21111502260290′
and wareid =’101227′
更新价格
create table #disable_u_sale_c(id int)
update u_sale_c set netprice=35 where saleno=’21111502260290′
and w ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:57:09 +0000</pubDate>
    </item>
    <item>
      <title>更新商品名称 简称</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=53</link>
      <description><![CDATA[update u_ware set warename =’ ‘ where wareid =’ ‘第一个是品名 第二个是编码 更新商品名称update u_ware set waresimname =’盐酸二甲双胍片1′ where wareid =’012196′第二个是改商品简称的]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:56:55 +0000</pubDate>
    </item>
    <item>
      <title>挂单提取出来价格不变</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=52</link>
      <description><![CDATA[系统参数 2857 中设置。 如果门店是1还是挂单不变价格就改成0 。然后门店传输。]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:56:41 +0000</pubDate>
    </item>
    <item>
      <title>会员积分清零</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=51</link>
      <description><![CDATA[if not exists(select * from c_bill where billcode=’CAS_ql’)
begin
INSERT c_bill(billcode,billname,serialtype,serialno,serialdate)
values(‘CAS_ql’,’兑奖单(积分清零)’,’yyyymmddssssssssssssssss’,0,’2015-01-06 17:14:26.950′)
end
go
if object_id ...]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:56:27 +0000</pubDate>
    </item>
    <item>
      <title>会员作废</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=50</link>
      <description><![CDATA[select * into d_memcard_reg_zf_bak1227 from u_memcard_reg where ISNULL(saleamount,0)]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:56:10 +0000</pubDate>
    </item>
    <item>
      <title>积分兑现金额设置</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=49</link>
      <description><![CDATA[自定义事件： 窗口名：w_inputpayamt 里面脚步 2个地方]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:55:57 +0000</pubDate>
    </item>
    <item>
      <title>加盟店增加业务机构改加价配送</title>
      <link>http://yqdx.com/forum.php?mod=viewthread&amp;tid=48</link>
      <description><![CDATA[select sendtype, * from c_org_busi where busno=’252′update c_org_busi set sendtype=2 where busno=’252′]]></description>
      <category>海典H1</category>
      <author>wbv123</author>
      <pubDate>Thu, 29 Aug 2024 02:55:31 +0000</pubDate>
    </item>
  </channel>
</rss>