[2026-05-11 18:29:31] SET TEXTSIZE 2147483647

[2026-05-11 18:29:31] select vmbillid from sg_gathering where vmbillid='3950721_xpd021839'

[2026-05-11 18:29:31] select vmbillid from sg_gathering where vmbillid='3950721_xpd021839'

[2026-05-11 18:29:31] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:31] insert into sg_gathering(vmbillid,dtdate,vshop,vpfcode,vsposition,vempcode,vspcode,fquantity,fmoney,
				        frealmoney,fgetmoney,fchange,vvipcard,fdefine4,bputup,btotal,bcancel,ivippoints,breturn,vcustid,vmemo,vxslx,jsje,yxyjje,vYDJH)
				    values('3950721_xpd021839','2026-05-11 18:29:30','395072','1','000','','987993','1','139.00','139.00','139.00',
				        '0.00','C95018_gk000930','0.4649','0','0','0','0','0','C95018_gk000930','','','0.00','0.00','')

[2026-05-11 18:29:31] insert into sg_gatherings(vlbillid,vmbillid,vpfcode,vshop,vempcode,vstyle,vcolor,vsize,vinvname,fquantity,frebate,fprice,frealprice,fmoney,frealmoney,vmemo,vdefine1,bpromote,bsendinv,vinvbarcode,jsjg,yxyjje,jishuije, vCxDJBH, vCxHdMc_iPOS,kl)
				        values('14030119','3950721_xpd021839','000','395072','987993','62LD707009','M1','38','时尚休闲拖鞋','1','0.46','299.00','139','139',
						'139','','红','0','0','','0.00','0.00','0.00', '', '', '0.000000')

[2026-05-11 18:29:31] insert into sg_paymethod(vlbillid,vmbillid,vpfcode,vshop,vempcode,vbalcode,fmoney,fchange,vdefine2,fdefine5,jsjgjs,yxyjjs)
						values('9278352','3950721_xpd021839','1','395072','987993','008','139','0','','1','0','0')

[2026-05-11 18:29:31] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:38] SET TEXTSIZE 2147483647

[2026-05-11 18:29:38] select vmbillid from sg_gathering where vmbillid='3950301_xpd027240'

[2026-05-11 18:29:38] select vmbillid from sg_gathering where vmbillid='3950301_xpd027240'

[2026-05-11 18:29:38] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:38] insert into sg_gathering(vmbillid,dtdate,vshop,vpfcode,vsposition,vempcode,vspcode,fquantity,fmoney,
				        frealmoney,fgetmoney,fchange,vvipcard,fdefine4,bputup,btotal,bcancel,ivippoints,breturn,vcustid,vmemo,vxslx,jsje,yxyjje,vYDJH)
				    values('3950301_xpd027240','2026-05-11 18:29:37','395030','1','000','zq','','1','49.00','49.00','49.00',
				        '0.00','QR679518','1.0000','0','0','0','49','0','QR679518','','','0.00','0.00','')

[2026-05-11 18:29:38] insert into sg_gatherings(vlbillid,vmbillid,vpfcode,vshop,vempcode,vstyle,vcolor,vsize,vinvname,fquantity,frebate,fprice,frealprice,fmoney,frealmoney,vmemo,vdefine1,bpromote,bsendinv,vinvbarcode,jsjg,yxyjje,jishuije, vCxDJBH, vCxHdMc_iPOS,kl)
				        values('14030122','3950301_xpd027240','000','395030','','XXK049-10','000','000','专业洗鞋充值49元卡','1','1','49.00','49','49',
						'49','','王丹','0','0','','0.00','0.00','0.00', '', '', '0.000000')

[2026-05-11 18:29:38] insert into sg_paymethod(vlbillid,vmbillid,vpfcode,vshop,vempcode,vbalcode,fmoney,fchange,vdefine2,fdefine5,jsjgjs,yxyjjs)
						values('9278355','3950301_xpd027240','1','395030','','000','49','0','','1','0','0')

[2026-05-11 18:29:38] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:44] SET TEXTSIZE 2147483647

[2026-05-11 18:29:44] select vmbillid from sg_gathering where vmbillid='3940581_xpd034591'

[2026-05-11 18:29:44] select vmbillid from sg_gathering where vmbillid='3940581_xpd034591'

[2026-05-11 18:29:44] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:44] insert into sg_gathering(vmbillid,dtdate,vshop,vpfcode,vsposition,vempcode,vspcode,fquantity,fmoney,
				        frealmoney,fgetmoney,fchange,vvipcard,fdefine4,bputup,btotal,bcancel,ivippoints,breturn,vcustid,vmemo,vxslx,jsje,yxyjje,vYDJH)
				    values('3940581_xpd034591','2026-05-11 18:29:42','394058','1','000','xc002','xc002','1','169.00','169.00','169.00',
				        '0.00','394058_gk001280','0.4985','0','0','0','169','0','394058_gk001280','','','0.00','0.00','')

[2026-05-11 18:29:44] insert into sg_gatherings(vlbillid,vmbillid,vpfcode,vshop,vempcode,vstyle,vcolor,vsize,vinvname,fquantity,frebate,fprice,frealprice,fmoney,frealmoney,vmemo,vdefine1,bpromote,bsendinv,vinvbarcode,jsjg,yxyjje,jishuije, vCxDJBH, vCxHdMc_iPOS,kl)
				        values('14030123','3940581_xpd034591','000','394058','xc002','52LQD621034','A1','41','艾草磁能科技鞋','1','0.5','339.00','169','169',
						'169','','黄亚琳','0','0','','0.00','0.00','0.00', '', '', '0.000000')

[2026-05-11 18:29:44] insert into sg_paymethod(vlbillid,vmbillid,vpfcode,vshop,vempcode,vbalcode,fmoney,fchange,vdefine2,fdefine5,jsjgjs,yxyjjs)
						values('9278356','3940581_xpd034591','1','394058','xc002','000','169','0','','1','0','0')

[2026-05-11 18:29:44] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:45] SET TEXTSIZE 2147483647

[2026-05-11 18:29:45] select vmbillid from sg_gathering where vmbillid='3740391_xpd008414'

[2026-05-11 18:29:45] select vmbillid from sg_gathering where vmbillid='3740391_xpd008414'

[2026-05-11 18:29:45] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:46] insert into sg_gathering(vmbillid,dtdate,vshop,vpfcode,vsposition,vempcode,vspcode,fquantity,fmoney,
				        frealmoney,fgetmoney,fchange,vvipcard,fdefine4,bputup,btotal,bcancel,ivippoints,breturn,vcustid,vmemo,vxslx,jsje,yxyjje,vYDJH)
				    values('3740391_xpd008414','2026-05-11 18:29:43','374039','1','000','988990','988990','1','100.00','100.00','100.00',
				        '0.00','QR1815522','0.4184','0','0','0','100','0','QR1815522','','','0.00','0.00','')

[2026-05-11 18:29:46] insert into sg_gatherings(vlbillid,vmbillid,vpfcode,vshop,vempcode,vstyle,vcolor,vsize,vinvname,fquantity,frebate,fprice,frealprice,fmoney,frealmoney,vmemo,vdefine1,bpromote,bsendinv,vinvbarcode,jsjg,yxyjje,jishuije, vCxDJBH, vCxHdMc_iPOS,kl)
				        values('14030124','3740391_xpd008414','000','374039','988990','52LD671001','M1','40','时尚休闲拖鞋','1','0.42','239.00','100','100',
						'100','','默认店长','0','0','','0.00','0.00','0.00', '', '', '0.000000')

[2026-05-11 18:29:46] insert into sg_paymethod(vlbillid,vmbillid,vpfcode,vshop,vempcode,vbalcode,fmoney,fchange,vdefine2,fdefine5,jsjgjs,yxyjjs)
						values('9278357','3740391_xpd008414','1','374039','988990','100','100','0','','1','0','0')

[2026-05-11 18:29:46] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:48] SET TEXTSIZE 2147483647

[2026-05-11 18:29:48] select vmbillid from sg_gathering where vmbillid='3712301_xpd000070'

[2026-05-11 18:29:48] select vmbillid from sg_gathering where vmbillid='3712301_xpd000070'

[2026-05-11 18:29:48] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:48] insert into sg_gathering(vmbillid,dtdate,vshop,vpfcode,vsposition,vempcode,vspcode,fquantity,fmoney,
				        frealmoney,fgetmoney,fchange,vvipcard,fdefine4,bputup,btotal,bcancel,ivippoints,breturn,vcustid,vmemo,vxslx,jsje,yxyjje,vYDJH)
				    values('3712301_xpd000070','2026-05-11 18:29:47','371230','1','000','','','1','198.00','198.00','198.00',
				        '0.00','QR1815488','0.5380','0','0','0','198','0','QR1815488','','','0.00','0.00','')

[2026-05-11 18:29:48] insert into sg_gatherings(vlbillid,vmbillid,vpfcode,vshop,vempcode,vstyle,vcolor,vsize,vinvname,fquantity,frebate,fprice,frealprice,fmoney,frealmoney,vmemo,vdefine1,bpromote,bsendinv,vinvbarcode,jsjg,yxyjje,jishuije, vCxDJBH, vCxHdMc_iPOS,kl)
				        values('14030125','3712301_xpd000070','000','371230','','62XD638037','M29','041','休闲阿甘网鞋','1','0.54','368.00','198','198',
						'198','','晓雅','0','0','','0.00','0.00','0.00', '', '', '0.000000')

[2026-05-11 18:29:48] insert into sg_paymethod(vlbillid,vmbillid,vpfcode,vshop,vempcode,vbalcode,fmoney,fchange,vdefine2,fdefine5,jsjgjs,yxyjjs)
						values('9278358','3712301_xpd000070','1','371230','','100','198','0','','1','0','0')

[2026-05-11 18:29:48] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:50] SET TEXTSIZE 2147483647

[2026-05-11 18:29:50] select vmbillid from sg_gathering where vmbillid='3731271_xpd036690'

[2026-05-11 18:29:50] select vmbillid from sg_gathering where vmbillid='3731271_xpd036690'

[2026-05-11 18:29:50] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:50] insert into sg_gathering(vmbillid,dtdate,vshop,vpfcode,vsposition,vempcode,vspcode,fquantity,fmoney,
				        frealmoney,fgetmoney,fchange,vvipcard,fdefine4,bputup,btotal,bcancel,ivippoints,breturn,vcustid,vmemo,vxslx,jsje,yxyjje,vYDJH)
				    values('3731271_xpd036690','2026-05-11 18:29:49','373127','1','000','373127','126','1','49.00','49.00','49.00',
				        '0.00','373127_gk002533','0.2462','0','0','0','5','0','373127_gk002533','','','0.00','0.00','')

[2026-05-11 18:29:50] insert into sg_gatherings(vlbillid,vmbillid,vpfcode,vshop,vempcode,vstyle,vcolor,vsize,vinvname,fquantity,frebate,fprice,frealprice,fmoney,frealmoney,vmemo,vdefine1,bpromote,bsendinv,vinvbarcode,jsjg,yxyjje,jishuije, vCxDJBH, vCxHdMc_iPOS,kl)
				        values('14030126','3731271_xpd036690','000','373127','126','PL6BBX14275','J1','000','女包','1','0.25','199.00','49','49',
						'49','','舒红','0','0','','0.00','0.00','0.00', '', '', '0.000000')

[2026-05-11 18:29:50] insert into sg_paymethod(vlbillid,vmbillid,vpfcode,vshop,vempcode,vbalcode,fmoney,fchange,vdefine2,fdefine5,jsjgjs,yxyjjs)
						values('9278359','3731271_xpd036690','1','373127','126','100','49','0','','1','0','0')

[2026-05-11 18:29:50] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:57] SET TEXTSIZE 2147483647

[2026-05-11 18:29:57] select djbh from dj_cyinfo where DJBH='370033_zdthd008488'

[2026-05-11 18:29:57] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:57] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:57] select count(1) from SPYCD where djbh = '370033_zdthd008488'

[2026-05-11 18:29:58] select ygdm from yuangong where xtmr=1

[2026-05-11 18:29:58] select djbh from spycd where djbh='370033_zdthd008488'

[2026-05-11 18:29:58] BEGIN TRANSACTION DEPS02_DEL

[2026-05-11 18:29:58] insert into SPYCD (djbh,rq,ydjh,djxz,dm2,dm2_1,dm4,qddm,ygdm,sl,je,bzje,zdr, rq_4, bz, fplx, byzd1, dm1, dm1_1, byzd3, byzd12,jz,zs,dm5,sh,shr,shrq)
			        values('370033_zdthd008488','2026-05-11','',0,'391061','000','000','000','002',
			        '1','189.00','189.00','默认店长','2026-05-11','',1,'3','370033',
			        '000','', '1.0000',0,0,'','0','',NULL)

[2026-05-11 18:29:58] SELECT @@IDENTITY AS [insertid];

[2026-05-11 18:29:58] insert into SPYCDMX (djbh,mibh,spdm,gg1dm,gg2dm,pcdm,sl,ckj,zk,dj,dj_1,dj_2,je,bz,sl_2,byzd2)
				        values('370033_zdthd008488','5448623','61XA604091','A1','040','','1','189.00',
				        '1.0000','189.00','189.00','1.0000','189.00','','0','0')

[2026-05-11 18:29:58] COMMIT TRANSACTION DEPS02_DEL

[2026-05-11 18:29:59] select ys from SPYCD where djbh = '370033_zdthd008488'

[2026-05-11 18:30:12] SET TEXTSIZE 2147483647

[2026-05-11 18:30:12] delete from ysrkdmx where djbh = '372083_zdthd004533'

[2026-05-11 18:30:12] INSERT INTO ysrkdmx (djbh,spdm,gg1dm,gg2dm,pcdm,sl,ckj,zk,dj,dj_1,dj_2,je,bz,mibh) VALUES('372083_zdthd004533','62LD661016','F24','37','','1','145.00','1.0000','145.00','145.00','1.0000','145.00','','2783627')

[2026-05-11 18:30:12] select sh from SPYCD where djbh = '372083_zdthd004533'