INSERT INTO [EETGW_Equipment] ([pdate]) VALUES (@pdate) SELECT pdate FROM EETGW_Equipment WITH (NOLOCK) WHERE (gcode = @gcode) GROUP BY pdate ORDER BY pdate DESC DELETE FROM [EquipmentFilter] WHERE (([idx] = @Original_idx) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ((@IsNull_wuid = 1 AND [wuid] IS NULL) OR ([wuid] = @Original_wuid)) AND ((@IsNull_wdate = 1 AND [wdate] IS NULL) OR ([wdate] = @Original_wdate)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))) INSERT INTO [EquipmentFilter] ([type], [Title], [Filter], [Apply], [memo], [wuid], [wdate], [gcode]) VALUES (@type, @Title, @Filter, @Apply, @memo, @wuid, @wdate, @gcode); SELECT idx, type, Title, Filter, Apply, memo, wuid, wdate, gcode FROM EquipmentFilter WHERE (idx = SCOPE_IDENTITY()) ORDER BY Title SELECT idx, type, Title, Filter, Apply, memo, wuid, wdate, gcode FROM EquipmentFilter WITH (NOLOCK) WHERE (type = @type) AND (gcode = @gcode) ORDER BY Title UPDATE [EquipmentFilter] SET [type] = @type, [Title] = @Title, [Filter] = @Filter, [Apply] = @Apply, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate, [gcode] = @gcode WHERE (([idx] = @Original_idx) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ((@IsNull_wuid = 1 AND [wuid] IS NULL) OR ([wuid] = @Original_wuid)) AND ((@IsNull_wdate = 1 AND [wdate] IS NULL) OR ([wdate] = @Original_wdate)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))); SELECT idx, type, Title, Filter, Apply, memo, wuid, wdate, gcode FROM EquipmentFilter WHERE (idx = @idx) ORDER BY Title DELETE FROM [LineCode] WHERE (([idx] = @Original_idx) AND ((@IsNull_code = 1 AND [code] IS NULL) OR ([code] = @Original_code)) AND ((@IsNull_team = 1 AND [team] IS NULL) OR ([team] = @Original_team)) AND ((@IsNull_part = 1 AND [part] IS NULL) OR ([part] = @Original_part)) AND ((@IsNull_plant = 1 AND [plant] IS NULL) OR ([plant] = @Original_plant)) AND ((@IsNull_except = 1 AND [except] IS NULL) OR ([except] = @Original_except)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_grp2 = 1 AND [grp2] IS NULL) OR ([grp2] = @Original_grp2)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))) INSERT INTO [LineCode] ([code], [team], [part], [plant], [except], [memo], [wuid], [wdate], [grp2], [gcode]) VALUES (@code, @team, @part, @plant, @except, @memo, @wuid, @wdate, @grp2, @gcode); SELECT idx, code, team, part, plant, [except], memo, wuid, wdate, grp2, gcode FROM LineCode WHERE (idx = SCOPE_IDENTITY()) SELECT idx, code, team, part, plant, [except], memo, wuid, wdate, grp2, gcode FROM LineCode WITH (NOLOCK) WHERE (gcode = @gcode) UPDATE [LineCode] SET [code] = @code, [team] = @team, [part] = @part, [plant] = @plant, [except] = @except, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate, [grp2] = @grp2, [gcode] = @gcode WHERE (([idx] = @Original_idx) AND ((@IsNull_code = 1 AND [code] IS NULL) OR ([code] = @Original_code)) AND ((@IsNull_team = 1 AND [team] IS NULL) OR ([team] = @Original_team)) AND ((@IsNull_part = 1 AND [part] IS NULL) OR ([part] = @Original_part)) AND ((@IsNull_plant = 1 AND [plant] IS NULL) OR ([plant] = @Original_plant)) AND ((@IsNull_except = 1 AND [except] IS NULL) OR ([except] = @Original_except)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_grp2 = 1 AND [grp2] IS NULL) OR ([grp2] = @Original_grp2)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))); SELECT idx, code, team, part, plant, [except], memo, wuid, wdate, grp2, gcode FROM LineCode WHERE (idx = @idx) DELETE FROM [EETGW_Equipment] WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_asset = 1 AND [asset] IS NULL) OR ([asset] = @Original_asset)) AND ((@IsNull_grp = 1 AND [grp] IS NULL) OR ([grp] = @Original_grp)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_flag = 1 AND [flag] IS NULL) OR ([flag] = @Original_flag)) AND ((@IsNull_plant = 1 AND [plant] IS NULL) OR ([plant] = @Original_plant)) AND ((@IsNull_grp2 = 1 AND [grp2] IS NULL) OR ([grp2] = @Original_grp2)) AND ((@IsNull_ing = 1 AND [ing] IS NULL) OR ([ing] = @Original_ing)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_lineT = 1 AND [lineT] IS NULL) OR ([lineT] = @Original_lineT)) AND ((@IsNull_lineP = 1 AND [lineP] IS NULL) OR ([lineP] = @Original_lineP)) AND ((@IsNull_serial = 1 AND [serial] IS NULL) OR ([serial] = @Original_serial)) AND ((@IsNull_manu = 1 AND [manu] IS NULL) OR ([manu] = @Original_manu)) AND ((@IsNull_param1 = 1 AND [param1] IS NULL) OR ([param1] = @Original_param1)) AND ((@IsNull_primary = 1 AND [primary] IS NULL) OR ([primary] = @Original_primary)) AND ((@IsNull_except = 1 AND [except] IS NULL) OR ([except] = @Original_except)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_version = 1 AND [version] IS NULL) OR ([version] = @Original_version)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))) INSERT INTO [EETGW_Equipment] ([pdate], [asset], [grp], [type], [flag], [plant], [grp2], [ing], [model], [linecode], [lineT], [lineP], [serial], [manu], [param1], [primary], [except], [memo], [wuid], [wdate], [version], [gcode]) VALUES (@pdate, @asset, @grp, @type, @flag, @plant, @grp2, @ing, @model, @linecode, @lineT, @lineP, @serial, @manu, @param1, @primary, @except, @memo, @wuid, @wdate, @version, @gcode); SELECT idx, pdate, asset, grp, type, flag, plant, grp2, ing, model, linecode, lineT, lineP, serial, manu, param1, [primary], [except], memo, wuid, wdate, version, gcode FROM EETGW_Equipment WHERE (idx = SCOPE_IDENTITY()) SELECT idx, pdate, asset, grp, type, flag, plant, grp2, ing, model, linecode, lineT, lineP, serial, manu, param1, [primary], [except], memo, wuid, wdate, version, gcode FROM EETGW_Equipment WITH (NOLOCK) WHERE (pdate = @pdate) AND (gcode = @gcode) UPDATE [EETGW_Equipment] SET [pdate] = @pdate, [asset] = @asset, [grp] = @grp, [type] = @type, [flag] = @flag, [plant] = @plant, [grp2] = @grp2, [ing] = @ing, [model] = @model, [linecode] = @linecode, [lineT] = @lineT, [lineP] = @lineP, [serial] = @serial, [manu] = @manu, [param1] = @param1, [primary] = @primary, [except] = @except, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate, [version] = @version, [gcode] = @gcode WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_asset = 1 AND [asset] IS NULL) OR ([asset] = @Original_asset)) AND ((@IsNull_grp = 1 AND [grp] IS NULL) OR ([grp] = @Original_grp)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_flag = 1 AND [flag] IS NULL) OR ([flag] = @Original_flag)) AND ((@IsNull_plant = 1 AND [plant] IS NULL) OR ([plant] = @Original_plant)) AND ((@IsNull_grp2 = 1 AND [grp2] IS NULL) OR ([grp2] = @Original_grp2)) AND ((@IsNull_ing = 1 AND [ing] IS NULL) OR ([ing] = @Original_ing)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_lineT = 1 AND [lineT] IS NULL) OR ([lineT] = @Original_lineT)) AND ((@IsNull_lineP = 1 AND [lineP] IS NULL) OR ([lineP] = @Original_lineP)) AND ((@IsNull_serial = 1 AND [serial] IS NULL) OR ([serial] = @Original_serial)) AND ((@IsNull_manu = 1 AND [manu] IS NULL) OR ([manu] = @Original_manu)) AND ((@IsNull_param1 = 1 AND [param1] IS NULL) OR ([param1] = @Original_param1)) AND ((@IsNull_primary = 1 AND [primary] IS NULL) OR ([primary] = @Original_primary)) AND ((@IsNull_except = 1 AND [except] IS NULL) OR ([except] = @Original_except)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_version = 1 AND [version] IS NULL) OR ([version] = @Original_version)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))); SELECT idx, pdate, asset, grp, type, flag, plant, grp2, ing, model, linecode, lineT, lineP, serial, manu, param1, [primary], [except], memo, wuid, wdate, version, gcode FROM EETGW_Equipment WHERE (idx = @idx) DELETE FROM [EETGW_Equipment] WHERE pdate = @pdate DELETE FROM EETGW_Equipment WHERE (pdate = @pdate) AND (gcode = @gcode) SELECT pdate, grp, manu, model, linecode, lineT, lineP, cnt, Remark, plant, grp2, gcode FROM vEquStockAll WITH (NOLOCK) WHERE (pdate = @pdate) AND (gcode = @gcode)