- 博客(22)
- 收藏
- 关注
RSS订阅原创 产品入库更新库存
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[cpinstock](@FBillNO varchar(255),@FName varchar(255),@FQty decimal(28, 10),@FEntryID int, @insert int out)asbegin--存在生产任务...
2019-03-14 10:30:42
668
2
原创 更新生产任务单关联数量
select FCommitQty , FAuxCommitQty,* from icmo where FBillNo in ('GF7904-A555K*11')--update icmo set FCommitQty = 0, FAuxCommitQty = 0--where FBillNo in ('GF7904-A555K*11')
2019-03-07 16:10:48
397
原创 重复值查询
--select t1.FName from icbom a--inner join icbomchild b on a.FinterID = b.FinterID--inner join t_icitem t1 on a.FitemID = t1.FitemID--inner join t_icitem t2 on b.FitemID = t2.FitemID--where (t2.FN...
2019-03-07 16:09:54
124
原创 插入订单通知单，更新批次调整单日期
插入订单通知单select b.* from t_bosddtzd ainner join t_bosddtzdentry b on a.FID = b.FIDwhere FBillNo= 'GF3309-109-ME'select a.* from seorder ainner join seorderentry b on a.FinterID = b.FinterIDwhere...
2019-03-07 16:07:32
378
原创 快速复制新增物料
alter TRIGGER GF_快速复制新增物料ON t_copyitemFOR updateASSET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus intselect @FID = FID,@FMultiCheckStatus = FMultiCheckStatus from ...
2019-03-07 16:06:34
399
原创 验货计划控制
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [GF_update_dateyh]ON [dbo].[t_yhplan]FOR updateASSET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus intsel...
2019-03-07 16:04:35
228
原创 生产周计划单控制
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [T_update_面料及工序日期更新]ON [dbo].[t_BOSSCZJHD]FOR updateASSET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int...
2019-03-07 16:03:40
183
原创 SQl存储过程：销售出库更新生产周计划单出货数量和产品入库自动生成领料单
---销售出库更新生产周计划单出货数量和产品入库自动生成领料单ALTER trigger [GF_UpdateFOUTQty] on [dbo].[ICStockBill]for updateasdeclare @FinterID int,@FStatus int,@FOldStatus int,@FTranType intselect @FinterID = FinterID,@...
2019-02-23 17:01:00
951
1
转载 函数：字符串分割（数组）
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].[Get_StrArrayStrOfIndex]( @str varchar(5000), --要分割的字符串 @split varchar(10), --分隔符号 @index int --取第几个元素)returns varcha...
2019-02-23 16:59:21
176
原创 存储过程：产品自动入库
alter PROCEDURE cpinstock(@FBillNO varchar(255),@FName varchar(255),@FQty decimal(28, 10),@FEntryID int, @insert int out)asbegin---判断条件:生产任务单必须是下达状态,未完全入库 if exists( select 1 from ic...
2019-02-23 16:51:30
827
原创 触发器：序列号自动生成
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [tr_SerialNO]ON [dbo].[t_BOSSerialNO]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int sel...
2019-02-23 16:51:08
542
原创 tr_更新最高限价
alter trigger tr_更新最高限价 on t_supplyentry for updateas declare @FUsed int,@FOldUsed int select @FUsed = FUsed from insertedselect @FOldUsed= FUsed from deleted if update (FUsed) and @FOldUsed ...
2019-02-23 16:50:56
121
原创 存储过程：批量出库
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--declare @Fgh nvarchar(255),@FBillNO nvarchar(255),@FName nvarchar(255), @FOrderNo nvarchar(255),@FQty nvarchar(255),@FNote nvarchar(500),@FTime nvar...
2019-02-23 16:50:48
281
原创 定时任务
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[gf_updatesczjhd]as---面料是否入库if object_id('tempdb..#ml') is not null Begin drop table #mlendselect * into #ml from (s...
2019-02-22 16:04:14
248
原创 存储过程：计划库存查询
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[gf_planstock](@FBillNo_SRC varchar(255))asselect b.FBillNo_SRC as 'FSeorderNo',w.Fname as 'FitemName',cast(b.Fqty as decim...
2019-02-22 16:03:19
223
原创 物料变更
alter TRIGGER [GF_物料变更] ON [dbo].[t_BOSPosqbg]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int select @FID = FID,@FMultiCheckStatus = FMultiCheckStatus...
2019-02-22 16:00:29
403
原创 BOM删除记录
create TRIGGER [GF_BOM删除记录] ON [dbo].[t_bomdeleted]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int select @FID = FID,@FMultiCheckStatus = FMultiCheckS...
2019-02-22 15:59:44
515
原创 BOM插入记录
alter TRIGGER [GF_BOM插入记录] ON [dbo].[t_bominserted]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int select @FID = FID,@FMultiCheckStatus = FMultiCheckS...
2019-02-22 15:59:11
227
原创 研发费用查询
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOalter procedure GF_2017研发费用( @FDateStart datetime, @FDateEnd datetime )asset nocount on--可调节腰靠座椅的研发if object_id('tempdb..#a') is not nu...
2019-02-22 15:57:46
522
原创 财务凭证查询
if object_id('tempdb..#pz') is not null Begin drop table #pzEnd select * into #pz from (select a.FDate ,a.FYear,a.FNumber as Fpznum,b.FExplanation ,case when CHARINDEX('.',REPLACE(REPLACE(b.F...
2019-02-22 15:56:41
614
原创 触发器：出货调整单
alter trigger GF_出货调整单 on t_AdjustBillfor update as declare @FID int,@FStatus int,@FOldStatus intselect @FID = FID,@FStatus = FMultiCheckStatus from inserted select @FOldStatus = FMultiCheckS...
2019-02-22 15:54:30
155
原创 触发器：订单通知单加单
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER trigger [GF_insert_ddtzd] on [dbo].[t_ddtzdIncrease]for update as declare @FID int,@FStatus int,@FOldStatus int select @FID = FID,@FStatus =...
2019-02-22 15:44:27
284
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人