• R/O
  • SSH
  • HTTPS

mlapplication: Commit


Commit MetaInfo

Revision76 (tree)
Time2018-07-13 17:32:51
Authoryukio_miura

Log Message

(empty log message)

Change Summary

Incremental Difference

--- trunk/ML.DBAccess/DataBase/01.SQL/03 TransactSQL/D161_UPD.sql (revision 75)
+++ trunk/ML.DBAccess/DataBase/01.SQL/03 TransactSQL/D161_UPD.sql (revision 76)
@@ -14,8 +14,7 @@
1414 @DP numeric(7),
1515 @LN numeric(3),
1616 @CD nvarchar(34),
17- @DT datetime,
18- @SU numeric(13,3)
17+ @SU numeric(11,3)
1918 )
2019 As
2120 DECLARE
--- trunk/ML.DBAccess/DataBase/01.SQL/02 Trigger/D141.sql (revision 75)
+++ trunk/ML.DBAccess/DataBase/01.SQL/02 Trigger/D141.sql (revision 76)
@@ -1,6 +1,6 @@
11 /* 仕入明細(D141) */
22 /* 作成日:2016/12/20 */
3-/* 更新日:2016/12/20 */
3+/* 更新日:2018/07/13 */
44 if exists (select * from sysobjects where id = object_id('D141_INS'))
55 Drop Trigger D141_INS
66 GO
@@ -103,12 +103,11 @@
103103 BEGIN
104104 SET @D141KING1 = @D141KING1 - @D141ZEI3
105105
106- -- Z131
106+ -- Z131,D161
107107 IF ISNULL(@D141M150CD1,'')!=''
108108 BEGIN
109109 EXEC Z131_CMP_CRE @D141M150CD1,@D141DATE1,1,@D141DPKB1,@D141DPNO1,@D141LNNO1,@D141SURY1
110- EXEC D161_UPD_UPD @D141D161DP1,@D141D161LN1,
111- D61_UPD.UPD(:OLD.D41_D60NO1,:OLD.D41_D60LN1,:OLD.D41_M47CD1,:OLD.D41_M30CD1,:OLD.D41_SURY1*(-1));
110+ EXEC D161_UPD_UPD @D141D160DP1,@D141D160LN1,@D141M150CD1,@D141SURY1
112111 END
113112 -- Lxx
114113 IF ISNULL(@SDT,'')!=''
@@ -279,10 +278,11 @@
279278 SET @D141SURY1 = @D141SURY1 * (-1)
280279 SET @D141KING1 = (@D141KING1 - @D141ZEI3) * (-1)
281280
282- -- Z131
281+ -- Z131,D161
283282 IF ISNULL(@D141M150CD1,'')!=''
284283 BEGIN
285284 EXEC Z131_CMP_CRE @D141M150CD1,@D141DATE1,1,@D141DPKB1,@D141DPNO1,@D141LNNO1,NULL
285+ EXEC D161_UPD_UPD @D141D160DP1,@D141D160LN1,@D141M150CD1,@D141SURY1
286286 END
287287
288288 -- Lxx
@@ -393,10 +393,11 @@
393393 BEGIN
394394 SET @D141KING1 = @D141KING1 - @D141ZEI3
395395
396- -- Z131
396+ -- Z131,D161
397397 IF ISNULL(@D141M150CD1,'')!=''
398398 BEGIN
399399 EXEC Z131_CMP_CRE @D141M150CD1,@D141DATE1,1,@D141DPKB1,@D141DPNO1,@D141LNNO1,@D141SURY1
400+ EXEC D161_UPD_UPD @D141D160DP1,@D141D160LN1,@D141M150CD1,@D141SURY1
400401 END
401402 IF ISNULL(@SDT,'')!=''
402403 BEGIN
@@ -566,10 +567,11 @@
566567 SET @D141SURY1 = @D141SURY1 * (-1)
567568 SET @D141KING1 = (@D141KING1 - @D141ZEI3) * (-1)
568569
569- -- Z131
570+ -- Z131,D161
570571 IF ISNULL(@D141M150CD1,'')!=''
571572 BEGIN
572573 EXEC Z131_CMP_CRE @D141M150CD1,@D141DATE1,1,@D141DPKB1,@D141DPNO1,@D141LNNO1,NULL
574+ EXEC D161_UPD_UPD @D141D160DP1,@D141D160LN1,@D141M150CD1,@D141SURY1
573575 END
574576 IF ISNULL(@SDT,'')!=''
575577 BEGIN
--- trunk/ML.DBAccess/DataBase/01.SQL/02 Trigger/D111.sql (revision 75)
+++ trunk/ML.DBAccess/DataBase/01.SQL/02 Trigger/D111.sql (revision 76)
@@ -1,6 +1,6 @@
11 /* 売上明細(D111) */
22 /* 作成日:2017/01/10 */
3-/* 更新日:2017/01/10 */
3+/* 更新日:2018/07/13 */
44 if exists (select * from sysobjects where id = object_id('D111_INS'))
55 Drop Trigger D111_INS
66 GO
@@ -133,10 +133,11 @@
133133 BEGIN
134134 SET @D111KING1 = @D111KING1 - @D111ZEI3
135135
136- -- Z131
136+ -- Z131,D131
137137 IF ISNULL(@D111M150CD1,'')!=''
138138 BEGIN
139139 EXEC Z131_CMP_CRE @D111M150CD1,@D111DATE1,1,@D111DPKB1,@D111DPNO1,@D111LNNO1,@D111SURY1
140+ EXEC D131_UPD_UPD @D111D130DP1,@D111D130LN1,@D111M150CD1,@D111SURY1
140141 END
141142 -- Lxx
142143 IF ISNULL(@SDT,'')!=''
@@ -357,10 +358,11 @@
357358 SET @D111SURY1 = @D111SURY1 * (-1)
358359 SET @D111KING1 = (@D111KING1 - @D111ZEI3) * (-1)
359360
360- -- Z131
361+ -- Z131,D131
361362 IF ISNULL(@D111M150CD1,'')!=''
362363 BEGIN
363364 EXEC Z131_CMP_CRE @D111M150CD1,@D111DATE1,1,@D111DPKB1,@D111DPNO1,@D111LNNO1,NULL
365+ EXEC D131_UPD_UPD @D111D130DP1,@D111D130LN1,@D111M150CD1,@D111SURY1
364366 END
365367
366368 -- Lxx
@@ -506,10 +508,11 @@
506508 BEGIN
507509 SET @D111KING1 = @D111KING1 - @D111ZEI3
508510
509- -- Z131
511+ -- Z131,D131
510512 IF ISNULL(@D111M150CD1,'')!=''
511513 BEGIN
512514 EXEC Z131_CMP_CRE @D111M150CD1,@D111DATE1,1,@D111DPKB1,@D111DPNO1,@D111LNNO1,@D111SURY1
515+ EXEC D131_UPD_UPD @D111D130DP1,@D111D130LN1,@D111M150CD1,@D111SURY1
513516 END
514517 IF ISNULL(@SDT,'')!=''
515518 BEGIN
@@ -729,10 +732,11 @@
729732 SET @D111SURY1 = @D111SURY1 * (-1)
730733 SET @D111KING1 = (@D111KING1 - @D111ZEI3) * (-1)
731734
732- -- Z131
735+ -- Z131,D131
733736 IF ISNULL(@D111M150CD1,'')!=''
734737 BEGIN
735738 EXEC Z131_CMP_CRE @D111M150CD1,@D111DATE1,1,@D111DPKB1,@D111DPNO1,@D111LNNO1,NULL
739+ EXEC D131_UPD_UPD @D111D130DP1,@D111D130LN1,@D111M150CD1,@D111SURY1
736740 END
737741 IF ISNULL(@SDT,'')!=''
738742 BEGIN
Show on old repository browser