获取单个BOM所有层级
-- 单个母料所有层级获取
-- EXEC Pro_GetBOMItems @ItemMaster=1002103110847604
CREATE OR ALTER PROCEDURE [dbo].[Pro_GetBOMItems...
阅读全文...
U9C SQL笔记1
U9C SQL笔记1修改用户密码update Base_User set Password=upper(substring(sys.fn_VarBinToHexStr(hashbytes('MD5', CAST('zgv9FQWbaNZ2iIhNej0+...
阅读全文...
阅读全文...
U9C 补丁工具免补丁库的方式
U9C 补丁工具免补丁库的方式SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[AllocBuildSerials]
@AllocC...
阅读全文...
阅读全文...
BE插件触发事件模板
BE插件触发事件模板public void Notify(params object[] args)
{
if ((args is not null) && (args.Length is not 0) && (a...
阅读全文...
阅读全文...