修改表结构,增加字段 首营表: ALTER TABLE T_CHK_VENDOR ADD ( XYYNO VARCHAR2(100), YSBNO VARCHAR2(100) ); 批发申请单主表 ALTER TABLE T_BATSALEAPPLY_H ADD ( djbh VARCHAR2(100), billsource VARCHAR2(100)); 批发申请单明细表 ALTER TABLE T_BATSALEAPPLY_H ADD DJ_SN NUMBER; 批发销售单主表 ALTER TABLE T_BATSALE_H ADD ( djbh VARCHAR2(100), billsource VARCHAR2(100), sale_idbs VARCHAR2(100), expresscompany VARCHAR2(100), express_code VARCHAR2(100), express_no VARCHAR2(100), expressno VARCHAR2(100) ); 创建客户视图 CREATE OR REPLACE VIEW XYY_SELLER_CO…

修改表结构,增加字段 首营表: ALTER TABLE T_CHK_VENDOR ADD ( XYYNO VARCHAR2(100), YSBNO VARCHAR2(100) ); 批发申请单主表 ALTER TABLE T_BATSALEAPPLY_H ADD ( djbh VARCHAR2(100), billsource VARCHAR2(100)); 批发申请单明细表 ALTER TABLE T_BATSALEAPPLY_H ADD DJ_SN NUMBER; 批发销售单主表 ALTER TABLE T_BATSALE_H ADD ( djbh VARCHAR2(100), billsource VARCHAR2(100), sale_idbs VARCHAR2(100), expresscompany VARCHAR2(100), express_code VARCHAR2(100), express_no VARCHAR2(100), expressno VARCHAR2(100) ); 创建药师帮用户 CREATE USER ysbuser IDENTIFIED BY y…

复制往来单位到其他企业 create or replace procedure CPROC_往来单位复制其他企业(p_compid NUMBER, p_vencuscode varchar2, p_userid NUMBER) as v_compid t_vencus.compid%TYPE := 1; v_vencusno t_vencus.vencusno%TYPE ; begin select vencusno into v_vencusno from t_vencus where vencuscode = p_vencuscode and compid = p_compid; insert into t_vencus (compid, vencusno, vencusname, vencustype, vencuscode, vencusflag, address, postcode, ordername, ordertel, orderfax, ordermobil, orderemail, orderurl, managename, managetel, taxtype, …

零售加postopen事件 ,打开窗口 弹出来近效期商品 String ls_dyc010,ls_days String ls_sql[],ls_err str_exec_args lstr_args[] Long ll_busno Long ll_number ll_busno = Long(gnvo_app.of_getini("posset","busno","0")) ls_dyc010 = String(gf_get_sys_inicode(gl_compid,'DYC010', gl_userid)) ls_days = String(gf_get_sys_inicode(gl_compid,'DYC011', gl_userid)) If ls_dyc010 = '1' Then ls_sql[1] = "select count(distinct A.wareid) from t_store_d A "+& "left join t_store_i B on A.warei…

实库存导入 select * from T_CT_STORE_NEW_hjx SELECT * FROM T_CT_STORE_NEW_hjx; delete from T_CT_STORE_NEW_hjx update T_CT_STORE_NEW_hjx set FACTORYID = '01' where nvl(FACTORYID,'0') = 0 ; ---SELECT * FROM t_ct_store_new --delete from T_CT_STORE_NEW_hjx;--真几把慢 --truncate table T_CT_STORE_NEW_hjx; SELECT * FROM T_CT_STORE_NEW_hjx where WAREQTY < 0 ; delete from T_CT_STORE_NEW_hjx where WAREQTY < 0 ; SELECT count(1) FROM T_CT_STORE_NEW_hjx where MAKEDATE is null ; SELECT count(1) FROM T_CT_STORE_NE…

药师帮销售转单流程 CREATE OR REPLACE PROCEDURE P_HC_BATSALE_GSP(an_billsource in varchar2) AS v_procname t_proc_rep.procrepname%TYPE; v_batsaleno t_batsale_h.batsaleno%type; v_para2825 s_sys_ini.inipara%TYPE; --前台销售按批次还是效期出库存 0：按批次，1：按效期 v_para2778 s_sys_ini.inipara%TYPE; --前台销售按批次还是效期出库存 0：按批次，1：按效期 v_para8139 s_sys_ini.inipara%TYPE; --是否开启整件优先 v_para2975 s_sys_ini.inipara%TYPE; --批发销售限制货位 v_para2976 s_sys_ini.inipara%TYPE; --批发销售限制,批发申请转批发需要过滤的商品类别 v_para2977 s_sys_ini.inipara%TYPE; --控制批发申请转批发，多少天以内的批…

以root用户登录主库所在服务器，执行 su - oracle 再执行 export ORACLE_SID=主库实例名 然后执行 sqlplus / as sysdba 进入数据库; 查看数据库名，确定没进错库 show parameter db_name; 查看空间权限: col directory_path for a60 col directory_name for a30 set line 300 select * from dba_directories; 如上,可以直接使用DUMP_CHUSHI 的文件夹 进行导出; 下面需要先退出Oracle模式 exit; 在Linux命令下执行导出 导出命令如下: expdp system/**********(密码) directory=DUMP_CHUSHI dumpfile=H2.dmp logfile=H2.log full=y 也可以修改导出文件的名字 避免重复或者文件找不到的情况 例如: expdp system/**********(密码) directory=DUMP_CHUSHI dumpfile=H2_202502…

选择商品 窗体增加排序 47.1、选择商品前执行的脚本(ads)_pre(事件执行前客户化) ads.setsort("") ads.setsort("purstatus A,warecode A,wareqty_store D") ads.sort() 数据库创建高权限用户 -- 使用 DBA 用户登录数据库 --CONNECT DB_ADMIN/your_password; -- 创建 ZKZX 用户 CREATE USER ZKZX IDENTIFIED BY your_password DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; -- 授予创建会话的权限 GRANT CREATE SESSION TO ZKZX; -- 授予无限表空间的权限 GRANT UNLIMITED TABLESPACE TO ZKZX; -- 授予系统权限 GRANT CREATE TABLE TO ZKZX; GRANT INSERT ANY TABLE TO ZKZX; GRANT UPDATE AN…

按照商品信息更新证照效期 INSERT INTO t_ware_certificate (compid, wareid, certificateid, lastmodify, lasttime, status) SELECT 2, w.wareid, c.certificateid, 168, SYSDATE, -1 FROM t_ware w CROSS JOIN (SELECT LEVEL AS certificateid FROM dual CONNECT BY LEVEL <= (SELECT COUNT(1) FROM t_ware_certificate_set)) c LEFT JOIN t_ware_certificate wc ON w.wareid = wc.wareid AND c.certificateid = wc.certificateid WHERE wc.wareid IS NULL; INSERT INTO t_ware_certificate_image (compid, wareid, filetype , lastmodify, lastt…

导会员销售数据: --------------------U_SALE_C------------------ create table U_SALE_C ( saleno VARCHAR2(24) not null, row_id NUMBER not null, busno VARCHAR2(10) not null, accdate DATE not null, wareid VARCHAR2(13) not null, batchno VARCHAR2(30) not null, idno VARCHAR2(12) not null, stallno VARCHAR2(10) not null, makeno VARCHAR2(100), stdprice NUMBER(16,6) not null, netprice NUMBER(16,6) not null, minprice NUMBER(16,6) not null, wareqty NUMBER(16,6) not null, groupid NUMBER not null, saler VARCHAR2(10), …