方象系列问题及解决办法方案

1、打印方案注意事项 方象软件标价签打印打印驱动里需注意参数1.打印首选项中，卷设置，设置标签尺寸比如38*90,并且设置默认。2.卷设置中，有选项【热敏】【热转印】，选择【热转印】。卷设置中【有标记】【有间距】的，标价签选择有【标记的】，条码签选择【有间距】的。标价签设置标签高=纸长，纸宽=标签宽*列数+列间距*（列数-1）条码签在标价签打印模块下打印的设置标签高=纸长，纸宽=标签宽*列数+列间距*（列数-1），行间距=0打印6个标签预览效果预览第一页预览图左下角有page 1 of 3.如果是1of1 说明标签设置有问题，需要重新修改页面定义2000单据打印设置单据表头表尾单据打印常见问题单据

2、无法正常打印的原因：1.页面定义中的纸张设置长度和纸张实际的格式不一致。2.页面定义的纸张和打印机设置中的纸张尺寸不一致。3.打印机驱动有问题，建议重新安装驱动程序5000打印方案5000标价签打印方案条码签打印系统自带条码签打印自定义打印方案报表打印大写金额函数添加供应商的电话号在软件中添加单据打印次数添加打印次数商贸通添加商品货架调用整个表中字段3000打印市斤价在原有售价上除以22000类软件导数据1.excel表格导入sql sever。2.通过存储过程重命名某一列EXEC sp_rename prodcode.F37, GatherRate3.导数据Insert into tvipi

3、nfo(vipcode,vipname)Select vipcode,vipname from vipinfo-根据商品编码重新进行编码，使用游标(王工)use pfdbmisdeclare DepCode VARCHAR(20), iInt INTdeclare get_unitName cursor for select distinct DepCode from productOpen get_unitNamefetch next from get_unitName into DepCodewhile (fetch_status=0)begin SET iInt = 0 UPDATE p

4、roduct SET ProdCode = 88 + right(0000 + CAST(iInt AS VARCHAR(4), 4),iInt = iInt + 1 where DepCode = DepCode and len(prodcode)6 fetch next from get_unitName into DepCodeendclose get_unitNamedeallocate get_unitName根据部门编码重新编码根据部门编码重新进行编码，使用游标（杨工）declare DepCode VARCHAR(20), iInt INTdeclare get_unitName

5、 cursor for select distinct DepCode from tmpProOpen get_unitNamefetch next from get_unitName into DepCodewhile (fetch_status=0)begin SET iInt = 0 UPDATE tmpPro SET ProdCode = DepCode + right(0000 + CAST(iInt AS VARCHAR(4), 4),iInt = iInt + 1 where DepCode = DepCode fetch next from get_unitName into

6、DepCodeendclose get_unitNamedeallocate get_unitName补齐会员编码长度及跨计算机查询导出数据补齐会员编码资料-补齐会员编码Update kgtmis2008.vipinfo set vipcode=left(0000000000000,13-Len(lTrim(vipcode)+lTrim(vipcode)where Len(rTrim(lTrim(vipcode)13从其他机器上复制数据到其他机器select *into #aa from openrowset(sqloledb,dcm;sa;,select * from fdbmis5000.

7、PRODRPT201209) 单位编码导数据单位编码取数据truncate table fdbmis5000.tUnitSetdeclare UnitName varchar(50)declare midi intdeclare get_unitName cursor for select distinct UnitName from (select distinct Unit as UnitName from zbzsysdb.goodswhere Unitunion allselect distinct unit1 as unitname from zbzsysdb.goodswhere

8、unit1union allselect distinct unit2 as unitname from zbzsysdb.goodswhere unit2 ) as aset midi=1001Open get_unitNamefetch next from get_unitName into UnitNamewhile (fetch_status=0)begin insert into fdbmis5000.tUnitSet(UnitCode,UnitName) values(right(cast(midi as varchar(255),3),UnitName) set midi=mid

9、i+1 fetch next from get_unitName into UnitNameendclose get_unitNamedeallocate get_unitName多条码商品取数据导会员数据到专卖根据会员个数标示id-求会员个数n，把select IDENTITY(INT,0 ,-1)中的换成查询出的数值，建立临时文件#aaaselect IDENTITY(INT,-n,-1) as VipID, vipcode,vipname,viptype,cardtype,vipgrade,vipstate,gender,metier,address,phoneno, mobilephoneno,idcode,zipcode,email,oicqno,birthday,regdate,validdate,editdate, sumconsume,sumdeposit,sumpayout,sumtend,sumfeed,vipscore,currscore,currconsume,nocalconsume into #aaa from kgtmis2008.vipinfo -select *from kgtvip2010.#aaa常用函数数据类型转换: convert（money，列名） cast（列名 as money）获取系统日期： getdate()获