gaby2312-优快云博客

原创 V_PAAI

alter view V_PAAI as SELECT a.对象ID 母件对象ID, a.版本ID 母件版本ID, a.编号母件编号, a.版本+'/'+CAST(a.版本序号 as varchar(8)) 母件版本, a.品名母件品名, a.品名序号母件品名序号, a.状态ID 母件状态ID, a.发版时间母件发版时间, a.资源类...

2019-12-19 20:11:36 116

原创 V_PAAH

alter VIEW V_PAAH as SELECT 对象ID, 版本ID, 编号, 版本+'/'+cast(版本序号 as varchar(8)) 版本, SUBSTRING(品名, 1, 5) 工序编号, SUBSTRING(品名, 7, LEN(品名) - 6) 工序品名, 品名序号, 资源类型, 状态ID, 发版时间, b.py6_...

2019-12-19 20:11:02 119 1

原创 V_PAAF

alter view V_PAAF as SELECT 对象ID, 版本ID, 编号, 版本+'/'+cast(版本序号 as varchar(8)) as 版本, isnull(b.py6_ProductCode, '') + (CASE WHEN SUBSTRING(编号, 1, 1) = '4' THEN isnull(b.py6_Customer_Number, '') ELSE...

2019-12-19 20:10:21 98

原创 V_PAAC

alter view V_PAAC as SELECT a.puid AS 对象ID, c.puid AS 版本ID, a.pitem_id AS 编号, c.pitem_revision_id as 版本,c.psequence_id 版本序号, b.pobject_name AS 品名, b.pactive_seq AS 品名序号, d....

2019-12-19 20:09:28 101

原创 V_PAAE

SELECT a.对象ID 母件对象ID, a.版本ID 母件版本ID, a.编号母件编号, a.版本母件版本, a.品名母件品名, a.品名序号母件品名序号, a.状态ID 母件状态ID, CONVERT(varchar(100), a.发版时间, 23) 母件发版日期, a.发版时间母件发版时间, a.资源类型母件资源类型, a...

2019-12-19 20:08:19 163

原创 P_VAAG

SELECT a.puid, a.pseq, a.pval_0, a.PIPNOTE_TEXTS_0_1_0, b.pvalu_0, c.pname, c.pdesc FROM dbo.PNOTE_TEXTS_0 AS a LEFT OUTER JOIN dbo.PNOTE_TYPES_0 AS b ON a.puid = b.p...

2019-12-19 20:06:54 99

原创 V_PAAC

SELECT a.puid AS 对象ID, c.puid AS 版本ID, a.pitem_id AS 编号, c.pitem_revision_id AS 版本, c.psequence_id AS 版本序号, b.pobject_name AS 品名, b.pactive_seq AS 品名序号, d.pvalu_0 AS 状态ID, D...

2019-12-19 20:05:12 120

excel VBA VB 可调用的生成二维码DLL，支持中文调用方法：先用regsvr32 注册DLL再调用 Public Function ShowQrcode(ByVal S As String) Dim Img As New Qrcode.cMain If Trim(S) = "" Then Exit Function End If Sheet1.Image1.PictureSizeMode = fmPictureSizeModeStretch Set Sheet1.Image1.Picture = Img.QRcode_EN(S) End Function

2020-11-23