门店按照一个店增加经营范围 insert into s_busi_range (compid, busno, classcode, status, lastmodify, lasttime,notes) select 2, s.busno, CLASSCODE, 1, 168, sysdate,'自动生成' from s_busi_range cross join s_busi s where s.busno<> 1001 按照最后批次进价更新最新进价 INSERT INTO tmp_disable_trigger (table_name) VALUES ('t_ware'); MERGE INTO t_ware a USING (SELECT wareid, purprice          FROM (SELECT wareid,                       purprice,                       ROW_NUMBER() OVER (PARTITION BY wareid ORDER BY batid DESC) AS rn …

建立透明网关 delete D_WARE_SALEPRICE_H1 insert into D_WARE_SALEPRICE_H1 d(d.compid,d.salegroupid,d.warecode-- ,d.wareid,d.saleprice,d.minprice,d.memprice,d.maxsaleprice,d.maxwhlprice,d.memcardflag,d.memminprice,d.memprice2,d.memminprice2,d.memprice3,d.memminprice3,d.memprice4,d.memminprice4,d.memprice5,d.memminprice5,d.memprice6,d.memminprice6,d.memprice7,d.memminprice7,d.integral_cash,d.lastpurprice) select 2 as compid,s."groupid" as salegroupid,s."wareid" as warecode,nvl(s."saleprice",0) as salepric…

收款的时候判断是否有处方药，如果有要弹出医师药师录入账号密码校验 If Long(lastreturnvalue) <> 0 Then Return Long(lastreturnvalue) //收款的时候判断是否有处方药，如果有要弹出医师药师录入账号密码校验 String ls_3071,ls_3072,ls_classcode,ls_busno ls_busno = gnvo_app.of_getini("posset","busno","0") ls_3071 = ','+ P19#is_3071 +',' ls_3072 = ','+ p19#is_3072 +',' //p33#ids_classcode.SetFilter("") //p33#ids_classcode.SetFilter("classgroupno='"+p19#is_3070+"'") //p33#ids_classcode.Filter() Long i,ll_cfy,…

更新t_ware 去除空格 UPDATE T_WARE SET barcode = TRIM(barcode), wareabc = TRIM(wareabc), warename = TRIM(warename), waregeneralname = TRIM(waregeneralname), warespec = TRIM(warespec), factoryid = TRIM(factoryid), warekind = TRIM(warekind), wareunit = TRIM(wareunit), waremark = TRIM(waremark), maxqty = TRIM(maxqty), midqty = TRIM(midqty), minunit = TRIM(minunit), minqty = TRIM(minqty), warningdays = TRIM(warningdays), saletax = TRIM(saletax), inittime = TRIM(inittime), lastmodify = TRIM(lastmodify), las…

小票自动换行: select '/*{txt.width=800 txt.height=60 txt.x=10 txt.y=4 txt.height.autosize=yes DataWindow.detail.height.autosize=yes }*/' from dual 商品漏的加价格组: declare begin FOR rec IN (SELECT * FROM s_saleprice_group WHERE compid = 2) LOOP for rec2 in (select distinct * from t_ware where t_Ware.wareid in (select distinct wareid from t_store_d where wareqty > 0)) loop INSERT INTO t_ware_saleprice (compid, salegroupid, wareid, saleprice, minprice, memprice, maxsaleprice, maxwhlprice, stamp, memcardflag…

这篇文章没有摘要

///单头已审核，标记绿色；已作废，标记红色 未审核 黄色 隔行显示深一些的颜色(行颜色区分) dw_master.Object.datawindow.detail.Color = "1073741824~tif(t_prom_h.status = 1,RGB(0,255,0),if(t_prom_h.status = 2,RGB(255,0,0),if(t_prom_h.status = 0,RGB(255,255,0),if(Mod(GetRow(), 2) = 0, RGB(247, 247, 247), 134217752))))" //首营颜色 dw_master_free.Modify("listing_holder_t.color = 0 ") dw_master.Modify("listing_holder_t.color = 0 ")//设置字段提示颜色为默认 //采购状态作废的颜色区分(字段颜色区分) dw_data.modify("datawindow.detail.color='1677721…

点击打开记事本

点击打开文件下载

NAS网盘路由粘贴板