DELETE FROM Users WHERE (id = @Original_id) INSERT INTO Users (id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate, processs, gcode) VALUES (@id,@password,@nameE,@name,@dept,@grade,@email,@level,@indate,@outdate,@tel,@hp,@place,@ads_employNo,@ads_title,@ads_created,@memo,@wuid,@wdate,@processs,@gcode); SELECT id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate FROM Users WHERE (id = @id) ORDER BY name SELECT id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate, processs, gcode FROM Users WITH (nolock) WHERE (ISNULL(dept, N'') LIKE @dept) AND (ISNULL(processs, N'') LIKE @process) ORDER BY name UPDATE Users SET password = @password, nameE = @nameE, name = @name, dept = @dept, grade = @grade, email = @email, level = @level, indate = @indate, outdate = @outdate, tel = @tel, hp = @hp, place = @place, ads_employNo = @ads_employNo, ads_title = @ads_title, ads_created = @ads_created, memo = @memo, wuid = @wuid, wdate = @wdate, processs = @process, gcode = @gcode WHERE (id = @Original_id); SELECT id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate FROM Users WHERE (id = @id) ORDER BY name SELECT COUNT(*) AS Expr1 FROM Users WITH (nolock) WHERE (id = @userid) SELECT id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate, processs, gcode FROM Users WITH (nolock) WHERE (name = @username) AND (password = @encpw) SELECT id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate, processs, gcode FROM Users WITH (nolock) WHERE (id = @id) ORDER BY name SELECT ads_created, ads_employNo, ads_title, dept, email, grade, hp, id, indate, level, memo, name, nameE, outdate, password, place, tel, wdate, wuid, processs, gcode FROM Users WITH (nolock) WHERE (password = @encpw) AND (level > 0) AND (email = @idkey) OR (password = @encpw) AND (level > 0) AND (id = @idkey) OR (password = @encpw) AND (level > 0) AND (email = { fn CONCAT(@idkey, '@amkor.co.kr') }) INSERT INTO Users (id, password, nameE, name, dept, email, level, tel, ads_employNo, ads_title, ads_created, memo, wuid, wdate) VALUES (@id, 'B6589FC6AB0DC82CF12099D1C2D40AB994E8410C',@nameE,@name,@dept,@email, 0,@tel,@ads_employNo,@ads_title,@ads_created,@memo,@wuid,@wdate); SELECT id, password, nameE, name, dept, grade, email, level, indate, outdate, tel, hp, place, ads_employNo, ads_title, ads_created, memo, wuid, wdate FROM Users WHERE (id = @id) ORDER BY name UPDATE Users SET dept = @dept,name=@name,ads_title=@title WHERE (id = @Original_id); DELETE FROM [Projects] WHERE (([idx] = @Original_idx) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_request = 1 AND [request] IS NULL) OR ([request] = @Original_request)) AND ((@IsNull_reqstaff = 1 AND [reqstaff] IS NULL) OR ([reqstaff] = @Original_reqstaff)) AND ((@IsNull_sdate = 1 AND [sdate] IS NULL) OR ([sdate] = @Original_sdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_odate = 1 AND [odate] IS NULL) OR ([odate] = @Original_odate)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [Projects] ([name], [pdate], [request], [reqstaff], [sdate], [edate], [odate], [memo], [wuid], [wdate]) VALUES (@name, @pdate, @request, @reqstaff, @sdate, @edate, @odate, @memo, @wuid, @wdate); SELECT idx, name, pdate, request, reqstaff, sdate, edate, odate, memo, wuid, wdate FROM Projects WHERE (idx = SCOPE_IDENTITY()) SELECT Projects.* FROM Projects UPDATE [Projects] SET [name] = @name, [pdate] = @pdate, [request] = @request, [reqstaff] = @reqstaff, [sdate] = @sdate, [edate] = @edate, [odate] = @odate, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_request = 1 AND [request] IS NULL) OR ([request] = @Original_request)) AND ((@IsNull_reqstaff = 1 AND [reqstaff] IS NULL) OR ([reqstaff] = @Original_reqstaff)) AND ((@IsNull_sdate = 1 AND [sdate] IS NULL) OR ([sdate] = @Original_sdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_odate = 1 AND [odate] IS NULL) OR ([odate] = @Original_odate)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, name, pdate, request, reqstaff, sdate, edate, odate, memo, wuid, wdate FROM Projects WHERE (idx = @idx) DELETE FROM [Items] WHERE (([idx] = @Original_idx) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_sid = 1 AND [sid] IS NULL) OR ([sid] = @Original_sid)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_manu = 1 AND [manu] IS NULL) OR ([manu] = @Original_manu)) AND ((@IsNull_supply = 1 AND [supply] IS NULL) OR ([supply] = @Original_supply)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [Items] ([name], [sid], [model], [manu], [supply], [price], [memo], [wuid], [wdate]) VALUES (@name, @sid, @model, @manu, @supply, @price, @memo, @wuid, @wdate); SELECT idx, name, sid, model, manu, supply, price, memo, wuid, wdate FROM Items WHERE (idx = SCOPE_IDENTITY()) SELECT idx, name, sid, model, manu, supply, price, memo, wuid, wdate FROM Items WITH (nolock) UPDATE [Items] SET [name] = @name, [sid] = @sid, [model] = @model, [manu] = @manu, [supply] = @supply, [price] = @price, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_sid = 1 AND [sid] IS NULL) OR ([sid] = @Original_sid)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_manu = 1 AND [manu] IS NULL) OR ([manu] = @Original_manu)) AND ((@IsNull_supply = 1 AND [supply] IS NULL) OR ([supply] = @Original_supply)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, name, sid, model, manu, supply, price, memo, wuid, wdate FROM Items WHERE (idx = @idx) DELETE FROM [Inventory] WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ((@IsNull_item = 1 AND [item] IS NULL) OR ([item] = @Original_item)) AND ((@IsNull_serial = 1 AND [serial] IS NULL) OR ([serial] = @Original_serial)) AND ((@IsNull_dr_qty = 1 AND [dr_qty] IS NULL) OR ([dr_qty] = @Original_dr_qty)) AND ((@IsNull_dr_amt = 1 AND [dr_amt] IS NULL) OR ([dr_amt] = @Original_dr_amt)) AND ((@IsNull_cr_qty = 1 AND [cr_qty] IS NULL) OR ([cr_qty] = @Original_cr_qty)) AND ((@IsNull_cr_amt = 1 AND [cr_amt] IS NULL) OR ([cr_amt] = @Original_cr_amt)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_invtype = 1 AND [invtype] IS NULL) OR ([invtype] = @Original_invtype)) AND ((@IsNull_ItemName = 1 AND [ItemName] IS NULL) OR ([ItemName] = @Original_ItemName)) AND ((@IsNull_projectName = 1 AND [projectName] IS NULL) OR ([projectName] = @Original_projectName))) INSERT INTO [Inventory] ([pdate], [uid], [item], [serial], [dr_qty], [dr_amt], [cr_qty], [cr_amt], [memo], [project], [wuid], [wdate], [invtype], [ItemName], [projectName]) VALUES (@pdate, @uid, @item, @serial, @dr_qty, @dr_amt, @cr_qty, @cr_amt, @memo, @project, @wuid, @wdate, @invtype, @ItemName, @projectName); SELECT idx, pdate, uid, item, serial, dr_qty, dr_amt, cr_qty, cr_amt, memo, project, wuid, wdate, invtype, ItemName, projectName FROM Inventory WHERE (idx = SCOPE_IDENTITY()) ORDER BY pdate SELECT idx, pdate, uid, item, serial, dr_qty, dr_amt, cr_qty, cr_amt, memo, project, wuid, wdate, invtype, item AS Expr1, projectName FROM Inventory WITH (nolock) ORDER BY pdate UPDATE [Inventory] SET [pdate] = @pdate, [uid] = @uid, [item] = @item, [serial] = @serial, [dr_qty] = @dr_qty, [dr_amt] = @dr_amt, [cr_qty] = @cr_qty, [cr_amt] = @cr_amt, [memo] = @memo, [project] = @project, [wuid] = @wuid, [wdate] = @wdate, [invtype] = @invtype, [ItemName] = @ItemName, [projectName] = @projectName WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ((@IsNull_item = 1 AND [item] IS NULL) OR ([item] = @Original_item)) AND ((@IsNull_serial = 1 AND [serial] IS NULL) OR ([serial] = @Original_serial)) AND ((@IsNull_dr_qty = 1 AND [dr_qty] IS NULL) OR ([dr_qty] = @Original_dr_qty)) AND ((@IsNull_dr_amt = 1 AND [dr_amt] IS NULL) OR ([dr_amt] = @Original_dr_amt)) AND ((@IsNull_cr_qty = 1 AND [cr_qty] IS NULL) OR ([cr_qty] = @Original_cr_qty)) AND ((@IsNull_cr_amt = 1 AND [cr_amt] IS NULL) OR ([cr_amt] = @Original_cr_amt)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_invtype = 1 AND [invtype] IS NULL) OR ([invtype] = @Original_invtype)) AND ((@IsNull_ItemName = 1 AND [ItemName] IS NULL) OR ([ItemName] = @Original_ItemName)) AND ((@IsNull_projectName = 1 AND [projectName] IS NULL) OR ([projectName] = @Original_projectName))); SELECT idx, pdate, uid, item, serial, dr_qty, dr_amt, cr_qty, cr_amt, memo, project, wuid, wdate, invtype, ItemName, projectName FROM Inventory WHERE (idx = @idx) ORDER BY pdate SELECT item, cr_amt, cr_qty, dr_amt, dr_qty, idx, invtype, item AS Expr1, memo, pdate, project, projectName, serial, uid, wdate, wuid FROM Inventory WITH (nolock) WHERE (pdate BETWEEN @sd AND @ed) AND (uid = @uid) ORDER BY pdate 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_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_plant = 1 AND [plant] IS NULL) OR ([plant] = @Original_plant)) AND ((@IsNull_grp2 = 1 AND [grp2] IS NULL) OR ([grp2] = @Original_grp2))) INSERT INTO [LineCode] ([code], [team], [part], [except], [memo], [wuid], [wdate], [plant], [grp2]) VALUES (@code, @team, @part, @except, @memo, @wuid, @wdate, @plant, @grp2); SELECT idx, code, team, part, [except], memo, wuid, wdate, plant, grp2 FROM LineCode WHERE (idx = SCOPE_IDENTITY()) SELECT idx, code, team, part, [except], memo, wuid, wdate, plant, grp2 FROM LineCode WITH (nolock) UPDATE [LineCode] SET [code] = @code, [team] = @team, [part] = @part, [except] = @except, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate, [plant] = @plant, [grp2] = @grp2 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_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_plant = 1 AND [plant] IS NULL) OR ([plant] = @Original_plant)) AND ((@IsNull_grp2 = 1 AND [grp2] IS NULL) OR ([grp2] = @Original_grp2))); SELECT idx, code, team, part, [except], memo, wuid, wdate, plant, grp2 FROM LineCode WHERE (idx = @idx) DELETE FROM [UserGroup] WHERE (([dept] = @Original_dept) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode)) AND ((@IsNull_path_kj = 1 AND [path_kj] IS NULL) OR ([path_kj] = @Original_path_kj)) AND ((@IsNull_advpurchase = 1 AND [advpurchase] IS NULL) OR ([advpurchase] = @Original_advpurchase)) AND ((@IsNull_permission = 1 AND [permission] IS NULL) OR ([permission] = @Original_permission)) AND ((@IsNull_advkisul = 1 AND [advkisul] IS NULL) OR ([advkisul] = @Original_advkisul)) AND ((@IsNull_managerinfo = 1 AND [managerinfo] IS NULL) OR ([managerinfo] = @Original_managerinfo)) AND ((@IsNull_devinfo = 1 AND [devinfo] IS NULL) OR ([devinfo] = @Original_devinfo))) INSERT INTO [UserGroup] ([dept], [gcode], [path_kj], [advpurchase], [permission], [advkisul], [managerinfo], [devinfo]) VALUES (@dept, @gcode, @path_kj, @advpurchase, @permission, @advkisul, @managerinfo, @devinfo); SELECT dept, gcode, path_kj, advpurchase, permission, advkisul, managerinfo, devinfo FROM UserGroup WHERE (dept = @dept) SELECT dept, gcode, path_kj, advpurchase, permission, advkisul, managerinfo, devinfo FROM UserGroup WITH (nolock) WHERE (ISNULL(gcode, '') <> '') AND (ISNULL(permission, 0) > 0) UPDATE [UserGroup] SET [dept] = @dept, [gcode] = @gcode, [path_kj] = @path_kj, [advpurchase] = @advpurchase, [permission] = @permission, [advkisul] = @advkisul, [managerinfo] = @managerinfo, [devinfo] = @devinfo WHERE (([dept] = @Original_dept) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode)) AND ((@IsNull_path_kj = 1 AND [path_kj] IS NULL) OR ([path_kj] = @Original_path_kj)) AND ((@IsNull_advpurchase = 1 AND [advpurchase] IS NULL) OR ([advpurchase] = @Original_advpurchase)) AND ((@IsNull_permission = 1 AND [permission] IS NULL) OR ([permission] = @Original_permission)) AND ((@IsNull_advkisul = 1 AND [advkisul] IS NULL) OR ([advkisul] = @Original_advkisul)) AND ((@IsNull_managerinfo = 1 AND [managerinfo] IS NULL) OR ([managerinfo] = @Original_managerinfo)) AND ((@IsNull_devinfo = 1 AND [devinfo] IS NULL) OR ([devinfo] = @Original_devinfo))); SELECT dept, gcode, path_kj, advpurchase, permission, advkisul, managerinfo, devinfo FROM UserGroup WHERE (dept = @dept) DELETE FROM [EETGW_GroupUser] WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ([uid] = @Original_uid) AND ((@IsNull_level = 1 AND [level] IS NULL) OR ([level] = @Original_level)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_useJobReport = 1 AND [useJobReport] IS NULL) OR ([useJobReport] = @Original_useJobReport)) AND ((@IsNull_useUserState = 1 AND [useUserState] IS NULL) OR ([useUserState] = @Original_useUserState)) AND ((@IsNull_state = 1 AND [state] IS NULL) OR ([state] = @Original_state)) AND ((@IsNull_Process = 1 AND [Process] IS NULL) OR ([Process] = @Original_Process)) AND ((@IsNull_exceptHoly = 1 AND [exceptHoly] IS NULL) OR ([exceptHoly] = @Original_exceptHoly))) INSERT INTO [EETGW_GroupUser] ([gcode], [uid], [level], [wuid], [wdate], [useJobReport], [useUserState], [state], [Process], [exceptHoly]) VALUES (@gcode, @uid, @level, @wuid, @wdate, @useJobReport, @useUserState, @state, @Process, @exceptHoly); SELECT idx, gcode, uid, level, wuid, wdate, useJobReport, useUserState, state, Process, exceptHoly FROM EETGW_GroupUser WHERE (idx = SCOPE_IDENTITY()) SELECT idx, gcode, uid, level, wuid, wdate, useJobReport, useUserState, state, Process, exceptHoly FROM EETGW_GroupUser WITH (nolock) WHERE (gcode = @gcode) UPDATE [EETGW_GroupUser] SET [gcode] = @gcode, [uid] = @uid, [level] = @level, [wuid] = @wuid, [wdate] = @wdate, [useJobReport] = @useJobReport, [useUserState] = @useUserState, [state] = @state, [Process] = @Process, [exceptHoly] = @exceptHoly WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ([uid] = @Original_uid) AND ((@IsNull_level = 1 AND [level] IS NULL) OR ([level] = @Original_level)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_useJobReport = 1 AND [useJobReport] IS NULL) OR ([useJobReport] = @Original_useJobReport)) AND ((@IsNull_useUserState = 1 AND [useUserState] IS NULL) OR ([useUserState] = @Original_useUserState)) AND ((@IsNull_state = 1 AND [state] IS NULL) OR ([state] = @Original_state)) AND ((@IsNull_Process = 1 AND [Process] IS NULL) OR ([Process] = @Original_Process)) AND ((@IsNull_exceptHoly = 1 AND [exceptHoly] IS NULL) OR ([exceptHoly] = @Original_exceptHoly))); SELECT idx, gcode, uid, level, wuid, wdate, useJobReport, useUserState, state, Process, exceptHoly FROM EETGW_GroupUser WHERE (idx = @idx) SELECT COUNT(*) AS Expr1 FROM EETGW_GroupUser WITH (nolock) WHERE (gcode = @gcode) AND (uid = @uid) SELECT idx, gcode, uid, level, wuid, wdate, useJobReport, useUserState, state, Process, exceptHoly FROM EETGW_GroupUser WITH (nolock) WHERE (gcode = @gcode) AND (uid = @uid) SELECT gcode, dept, level, name, nameE, grade, email, tel, indate, outdate, hp, place, ads_employNo, ads_title, ads_created, memo, processs, id, state, useJobReport, useUserState, password, exceptHoly FROM vGroupUser WHERE (gcode = @gcode) AND (ISNULL(processs, '') LIKE @processs) ORDER BY name UPDATE EETGW_GroupUser SET Process = @Process, state = @state, exceptHoly = @exceptHoly WHERE (gcode = @gcode) AND (uid = @id) SELECT ads_created, ads_employNo, ads_title, dept, email, exceptHoly, gcode, grade, hp, id, indate, level, memo, name, nameE, outdate, password, place, processs, state, tel, useJobReport, useUserState FROM vGroupUser WHERE (gcode = @gcode) AND (id = @id) ORDER BY name SELECT gcode, dept, level, name, nameE, grade, email, tel, indate, outdate, hp, place, ads_employNo, ads_title, ads_created, memo, processs, id, state, useJobReport, useUserState, password, exceptHoly FROM vGroupUser WHERE id = @id DELETE FROM [JobReport] WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_pidx = 1 AND [pidx] IS NULL) OR ([pidx] = @Original_pidx)) AND ((@IsNull_projectName = 1 AND [projectName] IS NULL) OR ([projectName] = @Original_projectName)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ((@IsNull_requestpart = 1 AND [requestpart] IS NULL) OR ([requestpart] = @Original_requestpart)) AND ((@IsNull_package = 1 AND [package] IS NULL) OR ([package] = @Original_package)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_process = 1 AND [process] IS NULL) OR ([process] = @Original_process)) AND ((@IsNull_remark = 1 AND [remark] IS NULL) OR ([remark] = @Original_remark)) AND ((@IsNull_hrs = 1 AND [hrs] IS NULL) OR ([hrs] = @Original_hrs)) AND ((@IsNull_ot = 1 AND [ot] IS NULL) OR ([ot] = @Original_ot)) AND ((@IsNull_import = 1 AND [import] IS NULL) OR ([import] = @Original_import)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_tag = 1 AND [tag] IS NULL) OR ([tag] = @Original_tag)) AND ((@IsNull_autoinput = 1 AND [autoinput] IS NULL) OR ([autoinput] = @Original_autoinput))) INSERT INTO [JobReport] ([gcode], [pdate], [pidx], [projectName], [uid], [requestpart], [package], [status], [type], [process], [description], [remark], [hrs], [ot], [import], [wuid], [wdate], [description2], [tag], [autoinput]) VALUES (@gcode, @pdate, @pidx, @projectName, @uid, @requestpart, @package, @status, @type, @process, @description, @remark, @hrs, @ot, @import, @wuid, @wdate, @description2, @tag, @autoinput); SELECT idx, gcode, pdate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput FROM JobReport WHERE (idx = SCOPE_IDENTITY()) ORDER BY pdate SELECT idx, gcode, pdate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput FROM JobReport WITH (nolock) WHERE (gcode = @GCODE) AND (uid = @UID) ORDER BY pdate UPDATE [JobReport] SET [gcode] = @gcode, [pdate] = @pdate, [pidx] = @pidx, [projectName] = @projectName, [uid] = @uid, [requestpart] = @requestpart, [package] = @package, [status] = @status, [type] = @type, [process] = @process, [description] = @description, [remark] = @remark, [hrs] = @hrs, [ot] = @ot, [import] = @import, [wuid] = @wuid, [wdate] = @wdate, [description2] = @description2, [tag] = @tag, [autoinput] = @autoinput WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_pidx = 1 AND [pidx] IS NULL) OR ([pidx] = @Original_pidx)) AND ((@IsNull_projectName = 1 AND [projectName] IS NULL) OR ([projectName] = @Original_projectName)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ((@IsNull_requestpart = 1 AND [requestpart] IS NULL) OR ([requestpart] = @Original_requestpart)) AND ((@IsNull_package = 1 AND [package] IS NULL) OR ([package] = @Original_package)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_process = 1 AND [process] IS NULL) OR ([process] = @Original_process)) AND ((@IsNull_remark = 1 AND [remark] IS NULL) OR ([remark] = @Original_remark)) AND ((@IsNull_hrs = 1 AND [hrs] IS NULL) OR ([hrs] = @Original_hrs)) AND ((@IsNull_ot = 1 AND [ot] IS NULL) OR ([ot] = @Original_ot)) AND ((@IsNull_import = 1 AND [import] IS NULL) OR ([import] = @Original_import)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_tag = 1 AND [tag] IS NULL) OR ([tag] = @Original_tag)) AND ((@IsNull_autoinput = 1 AND [autoinput] IS NULL) OR ([autoinput] = @Original_autoinput))); SELECT idx, gcode, pdate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput FROM JobReport WHERE (idx = @idx) ORDER BY pdate SELECT idx, gcode, pdate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput FROM JobReport WITH (nolock) WHERE (gcode = @GCODE) AND (uid = @UID) and pdate = @pdate ORDER BY pdate DELETE FROM [MailData] WHERE (([idx] = @Original_idx) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ([gcode] = @Original_gcode) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_SendOK = 1 AND [SendOK] IS NULL) OR ([SendOK] = @Original_SendOK)) AND ((@IsNull_SendMsg = 1 AND [SendMsg] IS NULL) OR ([SendMsg] = @Original_SendMsg)) AND ((@IsNull_aidx = 1 AND [aidx] IS NULL) OR ([aidx] = @Original_aidx)) AND ((@IsNull_atime = 1 AND [atime] IS NULL) OR ([atime] = @Original_atime)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [MailData] ([project], [gcode], [cate], [pdate], [subject], [tolist], [bcc], [cc], [body], [SendOK], [SendMsg], [aidx], [atime], [wuid], [wdate], [fromlist]) VALUES (@project, @gcode, @cate, @pdate, @subject, @tolist, @bcc, @cc, @body, @SendOK, @SendMsg, @aidx, @atime, @wuid, @wdate, @fromlist); SELECT idx, project, gcode, cate, pdate, subject, tolist, bcc, cc, body, SendOK, SendMsg, aidx, atime, wuid, wdate, fromlist FROM MailData WHERE (idx = SCOPE_IDENTITY()) SELECT idx, project, gcode, cate, pdate, subject, tolist, bcc, cc, body, SendOK, SendMsg, aidx, atime, wuid, wdate, fromlist FROM MailData WITH (nolock) WHERE (ISNULL(SendOK, 0) = 0) UPDATE [MailData] SET [project] = @project, [gcode] = @gcode, [cate] = @cate, [pdate] = @pdate, [subject] = @subject, [tolist] = @tolist, [bcc] = @bcc, [cc] = @cc, [body] = @body, [SendOK] = @SendOK, [SendMsg] = @SendMsg, [aidx] = @aidx, [atime] = @atime, [wuid] = @wuid, [wdate] = @wdate, [fromlist] = @fromlist WHERE (([idx] = @Original_idx) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ([gcode] = @Original_gcode) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_SendOK = 1 AND [SendOK] IS NULL) OR ([SendOK] = @Original_SendOK)) AND ((@IsNull_SendMsg = 1 AND [SendMsg] IS NULL) OR ([SendMsg] = @Original_SendMsg)) AND ((@IsNull_aidx = 1 AND [aidx] IS NULL) OR ([aidx] = @Original_aidx)) AND ((@IsNull_atime = 1 AND [atime] IS NULL) OR ([atime] = @Original_atime)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, project, gcode, cate, pdate, subject, tolist, bcc, cc, body, SendOK, SendMsg, aidx, atime, wuid, wdate, fromlist FROM MailData WHERE (idx = @idx) SELECT COUNT(*) AS Expr1 FROM MailData WHERE (aidx = @aidx) AND (pdate = @pdate) AND (atime = @atime) AND (cate = @cate) SELECT SendMsg, SendOK, aidx, atime, bcc, body, cate, cc, fromlist, gcode, idx, pdate, project, subject, tolist, wdate, wuid FROM MailData WITH (nolock) WHERE (gcode = @gcode) AND (cate = @cate) AND (pdate = @pdate) SELECT SendMsg, SendOK, aidx, atime, bcc, body, cate, cc, fromlist, gcode, idx, pdate, project, subject, tolist, wdate, wuid FROM MailData WITH (nolock) WHERE (gcode = @gcode) AND (wuid = @uid) AND (pdate = @pdate) AND (cate = @cate) SELECT COUNT(*) AS cnt FROM MailData WITH (nolock) WHERE (aidx = @aidx) AND (atime = @atime) AND (pdate = @pdate) AND (cate = @cate) UPDATE MailData SET SendOK = 1, SendMsg = @msg WHERE (idx = @idx) UPDATE [MailData] SET SendOK = 1 WHERE (idx = @idx) DELETE FROM [MailAuto] WHERE (([idx] = @Original_idx) AND ((@IsNull_enable = 1 AND [enable] IS NULL) OR ([enable] = @Original_enable)) AND ([fidx] = @Original_fidx) AND ([gcode] = @Original_gcode) AND ((@IsNull_sdate = 1 AND [sdate] IS NULL) OR ([sdate] = @Original_sdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_stime = 1 AND [stime] IS NULL) OR ([stime] = @Original_stime)) AND ((@IsNull_sday = 1 AND [sday] IS NULL) OR ([sday] = @Original_sday)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [MailAuto] ([enable], [fidx], [gcode], [fromlist], [tolist], [bcc], [cc], [sdate], [edate], [stime], [sday], [wuid], [wdate], [subject], [body]) VALUES (@enable, @fidx, @gcode, @fromlist, @tolist, @bcc, @cc, @sdate, @edate, @stime, @sday, @wuid, @wdate, @subject, @body); SELECT idx, enable, fidx, gcode, fromlist, tolist, bcc, cc, sdate, edate, stime, sday, wuid, wdate, subject, body FROM MailAuto WHERE (idx = SCOPE_IDENTITY()) SELECT idx, enable, fidx, gcode, fromlist, tolist, bcc, cc, sdate, edate, stime, sday, wuid, wdate, subject, body FROM MailAuto WITH (nolock) UPDATE [MailAuto] SET [enable] = @enable, [fidx] = @fidx, [gcode] = @gcode, [fromlist] = @fromlist, [tolist] = @tolist, [bcc] = @bcc, [cc] = @cc, [sdate] = @sdate, [edate] = @edate, [stime] = @stime, [sday] = @sday, [wuid] = @wuid, [wdate] = @wdate, [subject] = @subject, [body] = @body WHERE (([idx] = @Original_idx) AND ((@IsNull_enable = 1 AND [enable] IS NULL) OR ([enable] = @Original_enable)) AND ([fidx] = @Original_fidx) AND ([gcode] = @Original_gcode) AND ((@IsNull_sdate = 1 AND [sdate] IS NULL) OR ([sdate] = @Original_sdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_stime = 1 AND [stime] IS NULL) OR ([stime] = @Original_stime)) AND ((@IsNull_sday = 1 AND [sday] IS NULL) OR ([sday] = @Original_sday)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, enable, fidx, gcode, fromlist, tolist, bcc, cc, sdate, edate, stime, sday, wuid, wdate, subject, body FROM MailAuto WHERE (idx = @idx) SELECT bcc, body, cc, edate, enable, fidx, fromlist, gcode, idx, sdate, sday, stime, subject, tolist, wdate, wuid FROM MailAuto WITH (nolock) WHERE (enable = 1) AND (ISNULL(fromlist, '') <> '') AND (ISNULL(tolist, '') <> '') AND (ISNULL(stime, '') <> '') DELETE FROM [Board] WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_bidx = 1 AND [bidx] IS NULL) OR ([bidx] = @Original_bidx)) AND ((@IsNull_pidx = 1 AND [pidx] IS NULL) OR ([pidx] = @Original_pidx)) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ((@IsNull_header = 1 AND [header] IS NULL) OR ([header] = @Original_header)) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)) AND ((@IsNull_file = 1 AND [file] IS NULL) OR ([file] = @Original_file)) AND ((@IsNull_guid = 1 AND [guid] IS NULL) OR ([guid] = @Original_guid)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_close = 1 AND [close] IS NULL) OR ([close] = @Original_close)) AND ((@IsNull_remark = 1 AND [remark] IS NULL) OR ([remark] = @Original_remark))) INSERT INTO [Board] ([gcode], [bidx], [pidx], [project], [header], [cate], [title], [contents], [file], [guid], [url], [wuid], [wdate], [close], [remark]) VALUES (@gcode, @bidx, @pidx, @project, @header, @cate, @title, @contents, @file, @guid, @url, @wuid, @wdate, @close, @remark); SELECT idx, gcode, bidx, pidx, project, header, cate, title, contents, [file], guid, url, wuid, wdate, [close], remark FROM Board WHERE (idx = SCOPE_IDENTITY()) SELECT idx, gcode, bidx, pidx, project, header, cate, title, contents, [file], guid, url, wuid, wdate, [close], remark FROM Board UPDATE [Board] SET [gcode] = @gcode, [bidx] = @bidx, [pidx] = @pidx, [project] = @project, [header] = @header, [cate] = @cate, [title] = @title, [contents] = @contents, [file] = @file, [guid] = @guid, [url] = @url, [wuid] = @wuid, [wdate] = @wdate, [close] = @close, [remark] = @remark WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_bidx = 1 AND [bidx] IS NULL) OR ([bidx] = @Original_bidx)) AND ((@IsNull_pidx = 1 AND [pidx] IS NULL) OR ([pidx] = @Original_pidx)) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ((@IsNull_header = 1 AND [header] IS NULL) OR ([header] = @Original_header)) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)) AND ((@IsNull_file = 1 AND [file] IS NULL) OR ([file] = @Original_file)) AND ((@IsNull_guid = 1 AND [guid] IS NULL) OR ([guid] = @Original_guid)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_close = 1 AND [close] IS NULL) OR ([close] = @Original_close)) AND ((@IsNull_remark = 1 AND [remark] IS NULL) OR ([remark] = @Original_remark))); SELECT idx, gcode, bidx, pidx, project, header, cate, title, contents, [file], guid, url, wuid, wdate, [close], remark FROM Board WHERE (idx = @idx) DELETE FROM [EETGW_LoginInfo] WHERE (([idx] = @Original_idx) AND ([uid] = @Original_uid) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_ip = 1 AND [ip] IS NULL) OR ([ip] = @Original_ip)) AND ((@IsNull_hostname = 1 AND [hostname] IS NULL) OR ([hostname] = @Original_hostname)) AND ((@IsNull_wuid = 1 AND [wuid] IS NULL) OR ([wuid] = @Original_wuid)) AND ((@IsNull_wdate = 1 AND [wdate] IS NULL) OR ([wdate] = @Original_wdate))) INSERT INTO [EETGW_LoginInfo] ([uid], [login], [ip], [hostname], [wuid], [wdate]) VALUES (@uid, @login, @ip, @hostname, @wuid, @wdate); SELECT idx, uid, login, ip, hostname, wuid, wdate FROM EETGW_LoginInfo WHERE (idx = SCOPE_IDENTITY()) SELECT EETGW_LoginInfo.* FROM EETGW_LoginInfo UPDATE [EETGW_LoginInfo] SET [uid] = @uid, [login] = @login, [ip] = @ip, [hostname] = @hostname, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ([uid] = @Original_uid) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_ip = 1 AND [ip] IS NULL) OR ([ip] = @Original_ip)) AND ((@IsNull_hostname = 1 AND [hostname] IS NULL) OR ([hostname] = @Original_hostname)) AND ((@IsNull_wuid = 1 AND [wuid] IS NULL) OR ([wuid] = @Original_wuid)) AND ((@IsNull_wdate = 1 AND [wdate] IS NULL) OR ([wdate] = @Original_wdate))); SELECT idx, uid, login, ip, hostname, wuid, wdate FROM EETGW_LoginInfo WHERE (idx = @idx) DELETE FROM [EETGW_JobReport_AutoInput] WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_pidx = 1 AND [pidx] IS NULL) OR ([pidx] = @Original_pidx)) AND ((@IsNull_projectName = 1 AND [projectName] IS NULL) OR ([projectName] = @Original_projectName)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ((@IsNull_requestpart = 1 AND [requestpart] IS NULL) OR ([requestpart] = @Original_requestpart)) AND ((@IsNull_package = 1 AND [package] IS NULL) OR ([package] = @Original_package)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_process = 1 AND [process] IS NULL) OR ([process] = @Original_process)) AND ((@IsNull_remark = 1 AND [remark] IS NULL) OR ([remark] = @Original_remark)) AND ((@IsNull_hrs = 1 AND [hrs] IS NULL) OR ([hrs] = @Original_hrs)) AND ((@IsNull_ot = 1 AND [ot] IS NULL) OR ([ot] = @Original_ot)) AND ((@IsNull_import = 1 AND [import] IS NULL) OR ([import] = @Original_import)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_tag = 1 AND [tag] IS NULL) OR ([tag] = @Original_tag)) AND ((@IsNull_autoinput = 1 AND [autoinput] IS NULL) OR ([autoinput] = @Original_autoinput)) AND ((@IsNull_enable = 1 AND [enable] IS NULL) OR ([enable] = @Original_enable)) AND ((@IsNull_jobgrp = 1 AND [jobgrp] IS NULL) OR ([jobgrp] = @Original_jobgrp))) INSERT INTO [EETGW_JobReport_AutoInput] ([gcode], [pdate], [edate], [pidx], [projectName], [uid], [requestpart], [package], [status], [type], [process], [description], [remark], [hrs], [ot], [import], [wuid], [wdate], [description2], [tag], [autoinput], [enable], [jobgrp]) VALUES (@gcode, @pdate, @edate, @pidx, @projectName, @uid, @requestpart, @package, @status, @type, @process, @description, @remark, @hrs, @ot, @import, @wuid, @wdate, @description2, @tag, @autoinput, @enable, @jobgrp); SELECT idx, gcode, pdate, edate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput, enable, jobgrp FROM EETGW_JobReport_AutoInput WHERE (idx = SCOPE_IDENTITY()) SELECT idx, gcode, pdate, edate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput, enable, jobgrp FROM EETGW_JobReport_AutoInput WHERE (gcode = @gcode) UPDATE [EETGW_JobReport_AutoInput] SET [gcode] = @gcode, [pdate] = @pdate, [edate] = @edate, [pidx] = @pidx, [projectName] = @projectName, [uid] = @uid, [requestpart] = @requestpart, [package] = @package, [status] = @status, [type] = @type, [process] = @process, [description] = @description, [remark] = @remark, [hrs] = @hrs, [ot] = @ot, [import] = @import, [wuid] = @wuid, [wdate] = @wdate, [description2] = @description2, [tag] = @tag, [autoinput] = @autoinput, [enable] = @enable, [jobgrp] = @jobgrp WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_pidx = 1 AND [pidx] IS NULL) OR ([pidx] = @Original_pidx)) AND ((@IsNull_projectName = 1 AND [projectName] IS NULL) OR ([projectName] = @Original_projectName)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ((@IsNull_requestpart = 1 AND [requestpart] IS NULL) OR ([requestpart] = @Original_requestpart)) AND ((@IsNull_package = 1 AND [package] IS NULL) OR ([package] = @Original_package)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_process = 1 AND [process] IS NULL) OR ([process] = @Original_process)) AND ((@IsNull_remark = 1 AND [remark] IS NULL) OR ([remark] = @Original_remark)) AND ((@IsNull_hrs = 1 AND [hrs] IS NULL) OR ([hrs] = @Original_hrs)) AND ((@IsNull_ot = 1 AND [ot] IS NULL) OR ([ot] = @Original_ot)) AND ((@IsNull_import = 1 AND [import] IS NULL) OR ([import] = @Original_import)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_tag = 1 AND [tag] IS NULL) OR ([tag] = @Original_tag)) AND ((@IsNull_autoinput = 1 AND [autoinput] IS NULL) OR ([autoinput] = @Original_autoinput)) AND ((@IsNull_enable = 1 AND [enable] IS NULL) OR ([enable] = @Original_enable)) AND ((@IsNull_jobgrp = 1 AND [jobgrp] IS NULL) OR ([jobgrp] = @Original_jobgrp))); SELECT idx, gcode, pdate, edate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput, enable, jobgrp FROM EETGW_JobReport_AutoInput WHERE (idx = @idx) SELECT idx, gcode, pdate, edate, pidx, projectName, uid, requestpart, package, status, type, process, description, remark, hrs, ot, import, wuid, wdate, description2, tag, autoinput, enable, jobgrp FROM EETGW_JobReport_AutoInput WHERE (gcode = @gcode) AND (autoinput = @autoinputflag) AND (uid LIKE @uid) AND (pdate <= @pdate) AND (ISNULL(edate, '') = '') OR (gcode = @gcode) AND (autoinput = @autoinputflag) AND (uid LIKE @uid) AND (pdate <= @pdate) AND (edate > @pdate) ORDER BY pdate DELETE FROM [Purchase] WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_state = 1 AND [state] IS NULL) OR ([state] = @Original_state)) AND ((@IsNull_process = 1 AND [process] IS NULL) OR ([process] = @Original_process)) AND ((@IsNull_receive = 1 AND [receive] IS NULL) OR ([receive] = @Original_receive)) AND ((@IsNull_sc = 1 AND [sc] IS NULL) OR ([sc] = @Original_sc)) AND ((@IsNull_request = 1 AND [request] IS NULL) OR ([request] = @Original_request)) AND ((@IsNull_sid = 1 AND [sid] IS NULL) OR ([sid] = @Original_sid)) AND ((@IsNull_pumname = 1 AND [pumname] IS NULL) OR ([pumname] = @Original_pumname)) AND ((@IsNull_pumidx = 1 AND [pumidx] IS NULL) OR ([pumidx] = @Original_pumidx)) AND ((@IsNull_pumscale = 1 AND [pumscale] IS NULL) OR ([pumscale] = @Original_pumscale)) AND ((@IsNull_pumunit = 1 AND [pumunit] IS NULL) OR ([pumunit] = @Original_pumunit)) AND ((@IsNull_pumqty = 1 AND [pumqty] IS NULL) OR ([pumqty] = @Original_pumqty)) AND ((@IsNull_pumqtyReq = 1 AND [pumqtyReq] IS NULL) OR ([pumqtyReq] = @Original_pumqtyReq)) AND ((@IsNull_pumprice = 1 AND [pumprice] IS NULL) OR ([pumprice] = @Original_pumprice)) AND ((@IsNull_pumpriceD = 1 AND [pumpriceD] IS NULL) OR ([pumpriceD] = @Original_pumpriceD)) AND ((@IsNull_pumamt = 1 AND [pumamt] IS NULL) OR ([pumamt] = @Original_pumamt)) AND ((@IsNull_supply = 1 AND [supply] IS NULL) OR ([supply] = @Original_supply)) AND ((@IsNull_supplyidx = 1 AND [supplyidx] IS NULL) OR ([supplyidx] = @Original_supplyidx)) AND ((@IsNull_projectidx = 1 AND [projectidx] IS NULL) OR ([projectidx] = @Original_projectidx)) AND ((@IsNull_asset = 1 AND [asset] IS NULL) OR ([asset] = @Original_asset)) AND ((@IsNull_manuproc = 1 AND [manuproc] IS NULL) OR ([manuproc] = @Original_manuproc)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_indate = 1 AND [indate] IS NULL) OR ([indate] = @Original_indate)) AND ((@IsNull_po = 1 AND [po] IS NULL) OR ([po] = @Original_po)) AND ((@IsNull_dept = 1 AND [dept] IS NULL) OR ([dept] = @Original_dept)) AND ((@IsNull_bigo = 1 AND [bigo] IS NULL) OR ([bigo] = @Original_bigo)) AND ((@IsNull_import = 1 AND [import] IS NULL) OR ([import] = @Original_import)) AND ((@IsNull_isdel = 1 AND [isdel] IS NULL) OR ([isdel] = @Original_isdel)) AND ((@IsNull_orderno = 1 AND [orderno] IS NULL) OR ([orderno] = @Original_orderno)) AND ((@IsNull_place = 1 AND [place] IS NULL) OR ([place] = @Original_place)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_inqty = 1 AND [inqty] IS NULL) OR ([inqty] = @Original_inqty)) AND ((@IsNull_inremark = 1 AND [inremark] IS NULL) OR ([inremark] = @Original_inremark)) AND ((@IsNull_winuid = 1 AND [winuid] IS NULL) OR ([winuid] = @Original_winuid)) AND ((@IsNull_windate = 1 AND [windate] IS NULL) OR ([windate] = @Original_windate)) AND ((@IsNull_chk1 = 1 AND [chk1] IS NULL) OR ([chk1] = @Original_chk1)) AND ((@IsNull_chk2 = 1 AND [chk2] IS NULL) OR ([chk2] = @Original_chk2)) AND ((@IsNull_chkremark = 1 AND [chkremark] IS NULL) OR ([chkremark] = @Original_chkremark)) AND ((@IsNull_costcenter = 1 AND [costcenter] IS NULL) OR ([costcenter] = @Original_costcenter)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_purchase_manager = 1 AND [purchase_manager] IS NULL) OR ([purchase_manager] = @Original_purchase_manager)) AND ((@IsNull_purchase_admin = 1 AND [purchase_admin] IS NULL) OR ([purchase_admin] = @Original_purchase_admin)) AND ((@IsNull_currency = 1 AND [currency] IS NULL) OR ([currency] = @Original_currency)) AND ((@IsNull_prdate = 1 AND [prdate] IS NULL) OR ([prdate] = @Original_prdate)) AND ((@IsNull_bigo_admin = 1 AND [bigo_admin] IS NULL) OR ([bigo_admin] = @Original_bigo_admin)) AND ((@IsNull_bigo_manager = 1 AND [bigo_manager] IS NULL) OR ([bigo_manager] = @Original_bigo_manager)) AND ((@IsNull_conf_status = 1 AND [conf_status] IS NULL) OR ([conf_status] = @Original_conf_status)) AND ((@IsNull_conf_request = 1 AND [conf_request] IS NULL) OR ([conf_request] = @Original_conf_request)) AND ((@IsNull_conf_reponse = 1 AND [conf_reponse] IS NULL) OR ([conf_reponse] = @Original_conf_reponse)) AND ((@IsNull_spmqty = 1 AND [spmqty] IS NULL) OR ([spmqty] = @Original_spmqty)) AND ((@IsNull_UpdateToItem = 1 AND [UpdateToItem] IS NULL) OR ([UpdateToItem] = @Original_UpdateToItem))) INSERT INTO [Purchase] ([gcode], [pdate], [state], [process], [receive], [sc], [request], [sid], [pumname], [pumidx], [pumscale], [pumunit], [pumqty], [pumqtyReq], [pumprice], [pumpriceD], [pumamt], [supply], [supplyidx], [project], [projectidx], [asset], [manuproc], [edate], [indate], [po], [dept], [bigo], [import], [isdel], [orderno], [place], [wuid], [wdate], [inqty], [inremark], [winuid], [windate], [chk1], [chk2], [chkremark], [costcenter], [linecode], [purchase_manager], [purchase_admin], [currency], [prdate], [bigo_admin], [bigo_manager], [conf_status], [conf_request], [conf_reponse], [spmqty], [UpdateToItem]) VALUES (@gcode, @pdate, @state, @process, @receive, @sc, @request, @sid, @pumname, @pumidx, @pumscale, @pumunit, @pumqty, @pumqtyReq, @pumprice, @pumpriceD, @pumamt, @supply, @supplyidx, @project, @projectidx, @asset, @manuproc, @edate, @indate, @po, @dept, @bigo, @import, @isdel, @orderno, @place, @wuid, @wdate, @inqty, @inremark, @winuid, @windate, @chk1, @chk2, @chkremark, @costcenter, @linecode, @purchase_manager, @purchase_admin, @currency, @prdate, @bigo_admin, @bigo_manager, @conf_status, @conf_request, @conf_reponse, @spmqty, @UpdateToItem); SELECT idx, gcode, pdate, state, process, receive, sc, request, sid, pumname, pumidx, pumscale, pumunit, pumqty, pumqtyReq, pumprice, pumpriceD, pumamt, supply, supplyidx, project, projectidx, asset, manuproc, edate, indate, po, dept, bigo, import, isdel, orderno, place, wuid, wdate, inqty, inremark, winuid, windate, chk1, chk2, chkremark, costcenter, linecode, purchase_manager, purchase_admin, currency, prdate, bigo_admin, bigo_manager, conf_status, conf_request, conf_reponse, spmqty, UpdateToItem FROM Purchase WHERE (idx = SCOPE_IDENTITY()) SELECT idx, gcode, pdate, state, process, receive, sc, request, sid, pumname, pumidx, pumscale, pumunit, pumqty, pumqtyReq, pumprice, pumpriceD, pumamt, supply, supplyidx, project, projectidx, asset, manuproc, edate, indate, po, dept, bigo, import, isdel, orderno, place, wuid, wdate, inqty, inremark, winuid, windate, chk1, chk2, chkremark, costcenter, linecode, purchase_manager, purchase_admin, currency, prdate, bigo_admin, bigo_manager, conf_status, conf_request, conf_reponse, spmqty, UpdateToItem FROM Purchase WHERE (gcode = @gcode) UPDATE [Purchase] SET [gcode] = @gcode, [pdate] = @pdate, [state] = @state, [process] = @process, [receive] = @receive, [sc] = @sc, [request] = @request, [sid] = @sid, [pumname] = @pumname, [pumidx] = @pumidx, [pumscale] = @pumscale, [pumunit] = @pumunit, [pumqty] = @pumqty, [pumqtyReq] = @pumqtyReq, [pumprice] = @pumprice, [pumpriceD] = @pumpriceD, [pumamt] = @pumamt, [supply] = @supply, [supplyidx] = @supplyidx, [project] = @project, [projectidx] = @projectidx, [asset] = @asset, [manuproc] = @manuproc, [edate] = @edate, [indate] = @indate, [po] = @po, [dept] = @dept, [bigo] = @bigo, [import] = @import, [isdel] = @isdel, [orderno] = @orderno, [place] = @place, [wuid] = @wuid, [wdate] = @wdate, [inqty] = @inqty, [inremark] = @inremark, [winuid] = @winuid, [windate] = @windate, [chk1] = @chk1, [chk2] = @chk2, [chkremark] = @chkremark, [costcenter] = @costcenter, [linecode] = @linecode, [purchase_manager] = @purchase_manager, [purchase_admin] = @purchase_admin, [currency] = @currency, [prdate] = @prdate, [bigo_admin] = @bigo_admin, [bigo_manager] = @bigo_manager, [conf_status] = @conf_status, [conf_request] = @conf_request, [conf_reponse] = @conf_reponse, [spmqty] = @spmqty, [UpdateToItem] = @UpdateToItem WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_state = 1 AND [state] IS NULL) OR ([state] = @Original_state)) AND ((@IsNull_process = 1 AND [process] IS NULL) OR ([process] = @Original_process)) AND ((@IsNull_receive = 1 AND [receive] IS NULL) OR ([receive] = @Original_receive)) AND ((@IsNull_sc = 1 AND [sc] IS NULL) OR ([sc] = @Original_sc)) AND ((@IsNull_request = 1 AND [request] IS NULL) OR ([request] = @Original_request)) AND ((@IsNull_sid = 1 AND [sid] IS NULL) OR ([sid] = @Original_sid)) AND ((@IsNull_pumname = 1 AND [pumname] IS NULL) OR ([pumname] = @Original_pumname)) AND ((@IsNull_pumidx = 1 AND [pumidx] IS NULL) OR ([pumidx] = @Original_pumidx)) AND ((@IsNull_pumscale = 1 AND [pumscale] IS NULL) OR ([pumscale] = @Original_pumscale)) AND ((@IsNull_pumunit = 1 AND [pumunit] IS NULL) OR ([pumunit] = @Original_pumunit)) AND ((@IsNull_pumqty = 1 AND [pumqty] IS NULL) OR ([pumqty] = @Original_pumqty)) AND ((@IsNull_pumqtyReq = 1 AND [pumqtyReq] IS NULL) OR ([pumqtyReq] = @Original_pumqtyReq)) AND ((@IsNull_pumprice = 1 AND [pumprice] IS NULL) OR ([pumprice] = @Original_pumprice)) AND ((@IsNull_pumpriceD = 1 AND [pumpriceD] IS NULL) OR ([pumpriceD] = @Original_pumpriceD)) AND ((@IsNull_pumamt = 1 AND [pumamt] IS NULL) OR ([pumamt] = @Original_pumamt)) AND ((@IsNull_supply = 1 AND [supply] IS NULL) OR ([supply] = @Original_supply)) AND ((@IsNull_supplyidx = 1 AND [supplyidx] IS NULL) OR ([supplyidx] = @Original_supplyidx)) AND ((@IsNull_projectidx = 1 AND [projectidx] IS NULL) OR ([projectidx] = @Original_projectidx)) AND ((@IsNull_asset = 1 AND [asset] IS NULL) OR ([asset] = @Original_asset)) AND ((@IsNull_manuproc = 1 AND [manuproc] IS NULL) OR ([manuproc] = @Original_manuproc)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_indate = 1 AND [indate] IS NULL) OR ([indate] = @Original_indate)) AND ((@IsNull_po = 1 AND [po] IS NULL) OR ([po] = @Original_po)) AND ((@IsNull_dept = 1 AND [dept] IS NULL) OR ([dept] = @Original_dept)) AND ((@IsNull_bigo = 1 AND [bigo] IS NULL) OR ([bigo] = @Original_bigo)) AND ((@IsNull_import = 1 AND [import] IS NULL) OR ([import] = @Original_import)) AND ((@IsNull_isdel = 1 AND [isdel] IS NULL) OR ([isdel] = @Original_isdel)) AND ((@IsNull_orderno = 1 AND [orderno] IS NULL) OR ([orderno] = @Original_orderno)) AND ((@IsNull_place = 1 AND [place] IS NULL) OR ([place] = @Original_place)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate) AND ((@IsNull_inqty = 1 AND [inqty] IS NULL) OR ([inqty] = @Original_inqty)) AND ((@IsNull_inremark = 1 AND [inremark] IS NULL) OR ([inremark] = @Original_inremark)) AND ((@IsNull_winuid = 1 AND [winuid] IS NULL) OR ([winuid] = @Original_winuid)) AND ((@IsNull_windate = 1 AND [windate] IS NULL) OR ([windate] = @Original_windate)) AND ((@IsNull_chk1 = 1 AND [chk1] IS NULL) OR ([chk1] = @Original_chk1)) AND ((@IsNull_chk2 = 1 AND [chk2] IS NULL) OR ([chk2] = @Original_chk2)) AND ((@IsNull_chkremark = 1 AND [chkremark] IS NULL) OR ([chkremark] = @Original_chkremark)) AND ((@IsNull_costcenter = 1 AND [costcenter] IS NULL) OR ([costcenter] = @Original_costcenter)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_purchase_manager = 1 AND [purchase_manager] IS NULL) OR ([purchase_manager] = @Original_purchase_manager)) AND ((@IsNull_purchase_admin = 1 AND [purchase_admin] IS NULL) OR ([purchase_admin] = @Original_purchase_admin)) AND ((@IsNull_currency = 1 AND [currency] IS NULL) OR ([currency] = @Original_currency)) AND ((@IsNull_prdate = 1 AND [prdate] IS NULL) OR ([prdate] = @Original_prdate)) AND ((@IsNull_bigo_admin = 1 AND [bigo_admin] IS NULL) OR ([bigo_admin] = @Original_bigo_admin)) AND ((@IsNull_bigo_manager = 1 AND [bigo_manager] IS NULL) OR ([bigo_manager] = @Original_bigo_manager)) AND ((@IsNull_conf_status = 1 AND [conf_status] IS NULL) OR ([conf_status] = @Original_conf_status)) AND ((@IsNull_conf_request = 1 AND [conf_request] IS NULL) OR ([conf_request] = @Original_conf_request)) AND ((@IsNull_conf_reponse = 1 AND [conf_reponse] IS NULL) OR ([conf_reponse] = @Original_conf_reponse)) AND ((@IsNull_spmqty = 1 AND [spmqty] IS NULL) OR ([spmqty] = @Original_spmqty)) AND ((@IsNull_UpdateToItem = 1 AND [UpdateToItem] IS NULL) OR ([UpdateToItem] = @Original_UpdateToItem))); SELECT idx, gcode, pdate, state, process, receive, sc, request, sid, pumname, pumidx, pumscale, pumunit, pumqty, pumqtyReq, pumprice, pumpriceD, pumamt, supply, supplyidx, project, projectidx, asset, manuproc, edate, indate, po, dept, bigo, import, isdel, orderno, place, wuid, wdate, inqty, inremark, winuid, windate, chk1, chk2, chkremark, costcenter, linecode, purchase_manager, purchase_admin, currency, prdate, bigo_admin, bigo_manager, conf_status, conf_request, conf_reponse, spmqty, UpdateToItem FROM Purchase WHERE (idx = @idx) SELECT name, idx, gcode, pdate, state, process, receive, sc, request, sid, pumname, pumidx, pumscale, pumunit, pumqty, pumprice, pumpriceD, pumamt, supply, supplyidx, project, projectidx, asset, manuproc, edate, indate, po, dept, bigo, import, isdel, orderno, place, wuid, wdate, inqty FROM vPurchase WHERE (gcode = @gcode) SELECT name, idx, gcode, pdate, state, process, receive, sc, request, sid, pumname, pumidx, pumscale, pumunit, pumqty, pumprice, pumpriceD, pumamt, supply, supplyidx, project, projectidx, asset, manuproc, edate, indate, po, dept, bigo, import, isdel, orderno, place, wuid, wdate, inqty FROM vPurchase WHERE (gcode = @gcode) AND (pdate >= @pdate) ORDER BY pdate DESC DELETE FROM [holidaylist] WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_free = 1 AND [free] IS NULL) OR ([free] = @Original_free)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [holidaylist] ([pdate], [free], [memo], [wuid], [wdate]) VALUES (@pdate, @free, @memo, @wuid, @wdate); SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WHERE (idx = SCOPE_IDENTITY()) select * from holidaylist where pdate = @pdate UPDATE [holidaylist] SET [pdate] = @pdate, [free] = @free, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_free = 1 AND [free] IS NULL) OR ([free] = @Original_free)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WHERE (idx = @idx) SELECT idx, Location, date, gcode, name, sid, model, manu, unit, supply, price, remark FROM vFindSID WITH (nolock) WHERE (ISNULL(sid, N'') LIKE @search) OR (ISNULL(name, N'') LIKE @search) OR (ISNULL(manu, N'') LIKE @search) OR (ISNULL(model, N'') LIKE @search) ORDER BY sid, name SELECT vJobReportForUser.* FROM vJobReportForUser with(nolock) where gcode = @gcode and idx = @idx SELECT idx, pdate, gcode, id, name, process, type, svalue, hrs, ot, requestpart, package, userProcess, status, projectName, description, ww, otStart, otEnd, ot2, otReason, grade, indate, outdate FROM vJobReportForUser WITH (nolock) WHERE (gcode = @gcode) AND (id = @id) AND (pdate BETWEEN @sd AND @ed) ORDER BY pdate DESC SELECT vJobReportForUser.* FROM vJobReportForUser with(nolock) where gcode = @gcode and pdate = @pdate order by name DELETE FROM [customs] WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_grp = 1 AND [grp] IS NULL) OR ([grp] = @Original_grp)) AND ((@IsNull_uptae = 1 AND [uptae] IS NULL) OR ([uptae] = @Original_uptae)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_name2 = 1 AND [name2] IS NULL) OR ([name2] = @Original_name2)) AND ((@IsNull_owner = 1 AND [owner] IS NULL) OR ([owner] = @Original_owner)) AND ((@IsNull_ownertel = 1 AND [ownertel] IS NULL) OR ([ownertel] = @Original_ownertel)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ((@IsNull_tel = 1 AND [tel] IS NULL) OR ([tel] = @Original_tel)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ((@IsNull_staff = 1 AND [staff] IS NULL) OR ([staff] = @Original_staff)) AND ((@IsNull_stafftel = 1 AND [stafftel] IS NULL) OR ([stafftel] = @Original_stafftel)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [customs] ([gcode], [grp], [uptae], [name], [name2], [owner], [ownertel], [address], [tel], [fax], [email], [memo], [staff], [stafftel], [wuid], [wdate]) VALUES (@gcode, @grp, @uptae, @name, @name2, @owner, @ownertel, @address, @tel, @fax, @email, @memo, @staff, @stafftel, @wuid, @wdate); SELECT idx, gcode, grp, uptae, name, name2, owner, ownertel, address, tel, fax, email, memo, staff, stafftel, wuid, wdate FROM Customs WHERE (idx = SCOPE_IDENTITY()) ORDER BY name SELECT idx, gcode, grp, uptae, name, name2, owner, ownertel, address, tel, fax, email, memo, staff, stafftel, wuid, wdate FROM Customs WITH (nolock) WHERE (gcode = @gcode) ORDER BY name UPDATE [customs] SET [gcode] = @gcode, [grp] = @grp, [uptae] = @uptae, [name] = @name, [name2] = @name2, [owner] = @owner, [ownertel] = @ownertel, [address] = @address, [tel] = @tel, [fax] = @fax, [email] = @email, [memo] = @memo, [staff] = @staff, [stafftel] = @stafftel, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_grp = 1 AND [grp] IS NULL) OR ([grp] = @Original_grp)) AND ((@IsNull_uptae = 1 AND [uptae] IS NULL) OR ([uptae] = @Original_uptae)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_name2 = 1 AND [name2] IS NULL) OR ([name2] = @Original_name2)) AND ((@IsNull_owner = 1 AND [owner] IS NULL) OR ([owner] = @Original_owner)) AND ((@IsNull_ownertel = 1 AND [ownertel] IS NULL) OR ([ownertel] = @Original_ownertel)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ((@IsNull_tel = 1 AND [tel] IS NULL) OR ([tel] = @Original_tel)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ((@IsNull_staff = 1 AND [staff] IS NULL) OR ([staff] = @Original_staff)) AND ((@IsNull_stafftel = 1 AND [stafftel] IS NULL) OR ([stafftel] = @Original_stafftel)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, gcode, grp, uptae, name, name2, owner, ownertel, address, tel, fax, email, memo, staff, stafftel, wuid, wdate FROM Customs WHERE (idx = @idx) ORDER BY name SELECT ISNULL(name, '') AS itemName FROM Items WITH (nolock) WHERE (idx = @id) SELECT ISNULL(name, '') AS ProjectName FROM Projects WITH (nolock) WHERE (idx = @idx) dbo.GetUserLoginCheck