| | |
|---|
| | | if (_verify.voucher && _verify.voucher.enabled) { |
|---|
| | | _voucher = ',BVoucher=@BVoucher,FIBVoucherDate=@FIBVoucherDate,FiYear=@FiYear' |
|---|
| | | } |
|---|
| | | _defaultsql = `update ${card.sql} set deleted=1,modifydate=getdate(),modifyuser=@username,modifyuserid=@userid@${_voucher} where ${_primaryKey}${card.Ot !== 'requiredOnce' ? '=@ID@' : ' in (select ID from dbo.SplitComma(@ID@))'};` |
|---|
| | | _defaultsql = `update ${card.sql} set deleted=1,modifydate=getdate(),modifyuser=@username,modifystaff=@fullname,modifyuserid=@userid@${_voucher} where ${_primaryKey}${card.Ot !== 'requiredOnce' ? '=@ID@' : ' in (select ID from dbo.SplitComma(@ID@))'};` |
|---|
| | | } else if (card.sqlType === 'delete') { |
|---|
| | | let _msg = '' |
|---|
| | | if (columns && columns.length > 0 && card.Ot !== 'notRequired' && card.Ot !== 'requiredOnce') { |
|---|
| | | if (columns && columns.length > 0 && card.Ot !== 'notRequired') { |
|---|
| | | let _index = 0 |
|---|
| | | columns.forEach(col => { |
|---|
| | | if (!col.field || col.Hide === 'true' || _index >= 4) return |
|---|
