| | |
| | | }) |
| | | } |
| | | |
| | | let _vars = ['tbid', 'ErrorCode', 'retmsg', 'BillCode', 'BVoucher', 'FIBVoucherDate', 'FiYear', 'UserName', 'FullName'] |
| | | |
| | | let primaryKey = setting.primaryKey || 'id' // 主键字段 |
| | | // 系统变量声明与设置初始值 |
| | | let _sql = `Declare @tbid nvarchar(50), @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50) |
| | | Select @BVoucher='',@FIBVoucherDate='',@FiYear='' |
| | | let _sql = `Declare @tbid nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50), @UserName nvarchar(50),@FullName nvarchar(50) |
| | | ` |
| | | if (verify && verify.scripts && verify.scripts.length > 0 && formdata) { |
| | | let _formfields = formdata.filter(form => !_vars.includes(form.key)) |
| | | _formfields = _formfields.map(form => { |
| | | _vars.push(form.key) |
| | | return `@${form.key} nvarchar(50)` |
| | | }) |
| | | _formfields = _formfields.join(',') |
| | | _sql += `,${_formfields} |
| | | ` |
| | | } |
| | | |
| | | _sql += `Select @BVoucher='',@FIBVoucherDate='',@FiYear='' |
| | | ` |
| | | |
| | | if (verify && verify.accountdate === 'true') { // 启用账期验证 |
| | |
| | | }) |
| | | } |
| | | |
| | | if (verify && verify.billcodes.length > 0) { |
| | | if (verify && verify.billcodes.length > 0) { // 单号生成 |
| | | verify.billcodes.forEach(item => { |
| | | let _ModularDetailCode = '' |
| | | if (item.TypeCharOne === 'Lp' || item.TypeCharOne === 'BN') { |
| | | _ModularDetailCode = item.TypeCharOne + item.linkField |
| | | let _val = '' |
| | | if (item.linkField === 'BID' && BID) { // 替换bid |
| | | _val = BID |
| | | } else if (data && data.hasOwnProperty(item.linkField)) { |
| | | _val = data[item.linkField] |
| | | } |
| | | _ModularDetailCode = item.TypeCharOne + _val |
| | | } else { |
| | | _ModularDetailCode = item.ModularDetailCode |
| | | } |
| | | _sql += `Declare @${item.field} nvarchar(50) |
| | | |
| | | let _declare = '' |
| | | if (!_vars.includes(item.field)) { |
| | | _declare = `Declare @${item.field} nvarchar(50)` |
| | | } |
| | | _vars.push(item.field) |
| | | |
| | | _sql += `${_declare} |
| | | select @BillCode='', @${item.field}='' |
| | | exec s_get_BillCode |
| | | @ModularDetailCode='${_ModularDetailCode}', |
| | |
| | | |
| | | let _updateconfig = '' |
| | | |
| | | if (verify && verify.voucher && verify.voucher.enabled) { // 凭证-显示列中选取,必须选行 |
| | | if (verify && verify.voucher && verify.voucher.enabled && data) { // 凭证-显示列中选取,必须选行 |
| | | let _voucher = verify.voucher |
| | | |
| | | _updateconfig = ',BVoucher=@BVoucher,FIBVoucherDate=@FIBVoucherDate,FiYear=@FiYear' |
| | |
| | | ` |
| | | } |
| | | |
| | | let _user = `select @UserName=UserName,@FullName=FullName from SUsers where UID=@UserID |
| | | ` |
| | | |
| | | if (btn.OpenType === 'pop' && btn.sqlType === 'insert') { |
| | | let keys = [] |
| | | let values = [] |
| | | formdata.forEach(item => { |
| | | if (item.type === 'number') { |
| | | if (item.type === 'funcvar') { |
| | | keys.push(item.key) |
| | | values.push('@' + item.key) |
| | | } else if (item.type === 'number') { |
| | | keys.push(item.key) |
| | | values.push(item.value) |
| | | } else { |
| | |
| | | values.push('\'' + item.value + '\'') |
| | | } |
| | | }) |
| | | |
| | | keys = keys.join(',') |
| | | values = values.join(',') |
| | | _sql += `declare @UserName nvarchar(50),@FullName nvarchar(50) |
| | | select @UserName=UserName,@FullName=FullName from SUsers where UID=@UserID |
| | | ` |
| | | _sql += `insert into ${btn.sql} (${keys},createuserid,CreateUser,CreateStaff,BID) select ${values},@userid,@username,@fullname,@BID` |
| | | _sql += _user |
| | | _sql += `insert into ${btn.sql} (${keys},createuserid,CreateUser,CreateStaff,BID) select ${values},@userid,@username,@fullname,@BID;` |
| | | } else if (btn.OpenType === 'pop' && btn.sqlType === 'update') { |
| | | let _form = [] |
| | | formdata.forEach(item => { |
| | | if (item.type === 'number') { |
| | | if (item.type === 'funcvar') { |
| | | _form.push(item.key + '=@' + item.key) |
| | | } else if (item.type === 'number') { |
| | | _form.push(item.key + '=' + item.value) |
| | | } else { |
| | | _form.push(item.key + '=\'' + item.value + '\'') |
| | | } |
| | | }) |
| | | _form = _form.join(',') |
| | | _sql += `update ${btn.sql} set ${_form},modifydate=getdate(),modifyuserid=@userid${_updateconfig} where ${primaryKey}=@${primaryKey}` |
| | | _sql += `update ${btn.sql} set ${_form},modifydate=getdate(),modifyuserid=@userid${_updateconfig} where ${primaryKey}=@${primaryKey};` |
| | | } else if ((btn.OpenType === 'prompt' || btn.OpenType === 'exec') && btn.sqlType === 'LogicDelete') { // 逻辑删除 |
| | | _sql += `update ${btn.sql} set deleted=1,modifydate=getdate(),modifyuserid=@userid where ${primaryKey}=@${primaryKey}` |
| | | _sql += `update ${btn.sql} set deleted=1,modifydate=getdate(),modifyuserid=@userid where ${primaryKey}=@${primaryKey};` |
| | | } else if ((btn.OpenType === 'prompt' || btn.OpenType === 'exec') && btn.sqlType === 'delete') { // 物理删除 |
| | | _sql += `insert into snote (remark,createuserid) select '删除表:${btn.sql} 数据: ${primaryKey}='+@${primaryKey},@userid delete ${btn.sql} where ${primaryKey}=@${primaryKey}` |
| | | _sql += _user |
| | | _sql += `insert into snote (remark,createuserid) select '删除表:${btn.sql} 数据: ${primaryKey}='+@${primaryKey},@userid,@username,@fullname delete ${btn.sql} where ${primaryKey}=@${primaryKey};` |
| | | } |
| | | |
| | | if (verify && verify.scripts && verify.scripts.length > 0) { |
| | | let _scripts = '' |
| | | verify.scripts.forEach(item => { |
| | | _scripts += ` |
| | | ${item.sql}` |
| | | }) |
| | | _sql += `${_scripts}` |
| | | } |
| | | |
| | | _sql += ` |
| | | aaa: |
| | | select @ErrorCode as ErrorCode,@retmsg as retmsg |
| | | ` |
| | | aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg` |
| | | console.log(_sql) |
| | | return _sql |
| | | } |