摘要:
1、定义sql函数 ALTER FUNCTION [dbo].[fn_GetItemStoreQty] ( @ItemID VARCHAR(50) --料品ID ) RETURNS decimal(24,9) AS BEGIN DECLARE @StoreQty decimal(24,9) SET 阅读全文
摘要:
枚举: select trl.Name,t.* from MO_CompleteRptDocType t inner join UBF_Sys_ExtEnumValue e on e.EValue=t.businessType inner join UBF_Sys_ExtEnumType et on 阅读全文
摘要:
DECLARE @MyArray TABLE (Id INT IDENTITY(1,1), Value bigint) INSERT INTO @MyArray (Value) select id from CBO_ItemMaster where Code in ('501-000001') -- 阅读全文
摘要:
#region 生产订单 /// <summary> /// 生产订单核准 /// </summary> public override object Do(object obj) { var responses = new List<ResultDTOData>(); var list = new 阅读全文
摘要:
存储过程字符串拼接超长用pirnt打印显示不全,可以用select方式查询显示 ALTER procedure [dbo].[P_cust_QryCaigou] @DocNo as nvarchar(max), @BusDate as nvarchar(max) as begin declare @ 阅读全文