| | |
|---|
| | | }> |
|---|
| | | <span className="operation-btn" style={{color: '#ff4d4f'}}><DeleteOutlined /></span> |
|---|
| | | </Popconfirm> |
|---|
| | | <span className="anticon operation-btn" style={{color: '#4D6BFE'}} onClick={() => { |
|---|
| | | if (record.sql) { |
|---|
| | | sessionStorage.setItem('deepseek_sql', `对以下sql server脚本，编写注释，不能用--，只能用/**/ ，@bid@是上级组件id,@id@是当前行数据id，@userid@为当前登录用户id，所有字段不要用..来省略，不要增加过多的回车改变原有格式，这样会影响代码的可读性，如果代码太长一条回复不完，就回复多条信息完成\n${record.sql}`) |
|---|
| | | |
|---|
| | | window.open('#/ai') |
|---|
| | | |
|---|
| | | setTimeout(() => { |
|---|
| | | sessionStorage.removeItem('deepseek_sql') |
|---|
| | | }, 0) |
|---|
| | | } |
|---|
| | | }}> |
|---|
| | | <svg viewBox="0 0 1391 1024" width="20px" fill="currentColor"> |
|---|
| | | <path d="M1361.92 83.136c-14.272-7.04-20.416 6.272-28.736 12.992-2.816 2.24-5.248 5.12-7.68 7.68-20.8 22.336-45.056 36.864-76.8 35.136-46.464-2.56-86.08 12.032-121.152 47.616-7.552-43.904-32.256-70.08-69.888-86.912-19.712-8.768-39.68-17.472-53.376-36.48-9.664-13.44-12.288-28.48-17.216-43.264-3.008-8.96-6.08-18.112-16.32-19.712-11.2-1.728-15.552 7.68-19.968 15.424-17.536 32.128-24.32 67.52-23.68 103.296 1.6 80.448 35.52 144.576 103.04 190.144 7.68 5.312 9.6 10.56 7.168 18.176-4.608 15.68-10.048 30.976-14.912 46.592-3.072 10.112-7.68 12.352-18.304 8a308.224 308.224 0 0 1-97.28-66.176c-48-46.4-91.392-97.664-145.472-137.792a655.36 655.36 0 0 0-38.528-26.432c-55.232-53.76 7.232-97.792 21.632-103.04 15.104-5.376 5.312-24.128-43.52-23.936C652.032 24.704 607.36 41.024 550.4 62.72a156.8 156.8 0 0 1-26.048 7.68 542.016 542.016 0 0 0-161.408-5.696c-105.6 11.904-189.888 61.824-251.904 147.2C36.608 314.24 19.072 430.848 40.512 552.32c22.528 128 87.808 234.048 188.16 316.992 104 85.888 223.808 128 360.512 120 82.944-4.864 175.424-16 279.68-104.32 26.368 13.056 53.888 18.24 99.712 22.272 35.2 3.328 69.184-1.792 95.424-7.232 41.216-8.704 38.4-46.848 23.424-53.888-120.576-56.32-94.208-33.408-118.272-51.84 61.376-72.768 153.792-148.224 189.952-392.768 2.816-19.392 0.384-31.552 0-47.36-0.256-9.536 1.92-13.312 12.8-14.4a231.04 231.04 0 0 0 86.592-26.56c78.272-42.88 109.696-113.024 117.184-197.184 1.088-12.928-0.256-26.24-13.76-32.96z m-681.408 757.76c-116.928-92.096-173.696-122.368-197.12-120.96-21.888 1.152-17.984 26.304-13.184 42.624 5.12 16.128 11.648 27.328 20.8 41.408 6.464 9.408 10.752 23.424-6.272 33.92-37.76 23.424-103.232-7.872-106.24-9.472-76.288-44.8-140.032-104.192-184.96-185.344-43.264-78.08-68.48-161.92-72.576-251.328-1.152-21.632 5.184-29.312 26.688-33.152a265.6 265.6 0 0 1 85.696-2.24c119.296 17.472 220.928 71.04 306.048 155.52 48.768 48.32 85.504 105.92 123.392 162.176 40.256 59.776 83.648 116.672 138.88 163.392 19.392 16.32 35.072 28.8 49.92 37.952-44.928 5.056-119.872 6.08-171.008-34.496z m56.064-361.024a17.152 17.152 0 1 1 2.752 9.6 16.896 16.896 0 0 1-2.752-9.664z m174.08 89.472a102.72 102.72 0 0 1-33.024 8.96 70.528 70.528 0 0 1-44.736-14.272c-15.296-12.8-26.176-19.968-30.848-42.496a99.264 99.264 0 0 1 0.832-32.96c4.032-18.368-0.384-30.08-13.248-40.768-10.624-8.768-23.872-11.072-38.592-11.072a31.168 31.168 0 0 1-14.272-4.416c-6.144-3.072-11.136-10.752-6.336-20.16 1.536-3.008 8.96-10.304 10.752-11.712 19.84-11.328 42.88-7.68 64.192 0.896 19.712 8.064 34.56 22.848 56 43.776 21.952 25.28 25.792 32.384 38.4 51.328 9.856 14.848 18.816 30.208 24.96 47.616 3.776 10.88-1.152 19.776-14.08 25.28z"></path> |
|---|
| | | </svg> |
|---|
| | | </span> |
|---|
| | | </div>) |
|---|
| | | } |
|---|
| | | ], |
|---|
| | |
|---|
| | | }> |
|---|
| | | <span className="operation-btn" style={{color: '#ff4d4f'}}><DeleteOutlined /></span> |
|---|
| | | </Popconfirm> |
|---|
| | | <span className="anticon operation-btn" style={{color: '#4D6BFE'}} onClick={() => { |
|---|
| | | if (record.sql) { |
|---|
| | | sessionStorage.setItem('deepseek_sql', `对以下sql server脚本，编写注释，不能用--，只能用/**/ ，@bid@是上级组件id,@id@是当前行数据id，@userid@为当前登录用户id，所有字段不要用..来省略，不要增加过多的回车改变原有格式，这样会影响代码的可读性，如果代码太长一条回复不完，就回复多条信息完成\n${record.sql}`) |
|---|
| | | |
|---|
| | | window.open('#/ai') |
|---|
| | | |
|---|
| | | setTimeout(() => { |
|---|
| | | sessionStorage.removeItem('deepseek_sql') |
|---|
| | | }, 0) |
|---|
| | | } |
|---|
| | | }}> |
|---|
| | | <svg viewBox="0 0 1391 1024" width="20px" fill="currentColor"> |
|---|
| | | <path d="M1361.92 83.136c-14.272-7.04-20.416 6.272-28.736 12.992-2.816 2.24-5.248 5.12-7.68 7.68-20.8 22.336-45.056 36.864-76.8 35.136-46.464-2.56-86.08 12.032-121.152 47.616-7.552-43.904-32.256-70.08-69.888-86.912-19.712-8.768-39.68-17.472-53.376-36.48-9.664-13.44-12.288-28.48-17.216-43.264-3.008-8.96-6.08-18.112-16.32-19.712-11.2-1.728-15.552 7.68-19.968 15.424-17.536 32.128-24.32 67.52-23.68 103.296 1.6 80.448 35.52 144.576 103.04 190.144 7.68 5.312 9.6 10.56 7.168 18.176-4.608 15.68-10.048 30.976-14.912 46.592-3.072 10.112-7.68 12.352-18.304 8a308.224 308.224 0 0 1-97.28-66.176c-48-46.4-91.392-97.664-145.472-137.792a655.36 655.36 0 0 0-38.528-26.432c-55.232-53.76 7.232-97.792 21.632-103.04 15.104-5.376 5.312-24.128-43.52-23.936C652.032 24.704 607.36 41.024 550.4 62.72a156.8 156.8 0 0 1-26.048 7.68 542.016 542.016 0 0 0-161.408-5.696c-105.6 11.904-189.888 61.824-251.904 147.2C36.608 314.24 19.072 430.848 40.512 552.32c22.528 128 87.808 234.048 188.16 316.992 104 85.888 223.808 128 360.512 120 82.944-4.864 175.424-16 279.68-104.32 26.368 13.056 53.888 18.24 99.712 22.272 35.2 3.328 69.184-1.792 95.424-7.232 41.216-8.704 38.4-46.848 23.424-53.888-120.576-56.32-94.208-33.408-118.272-51.84 61.376-72.768 153.792-148.224 189.952-392.768 2.816-19.392 0.384-31.552 0-47.36-0.256-9.536 1.92-13.312 12.8-14.4a231.04 231.04 0 0 0 86.592-26.56c78.272-42.88 109.696-113.024 117.184-197.184 1.088-12.928-0.256-26.24-13.76-32.96z m-681.408 757.76c-116.928-92.096-173.696-122.368-197.12-120.96-21.888 1.152-17.984 26.304-13.184 42.624 5.12 16.128 11.648 27.328 20.8 41.408 6.464 9.408 10.752 23.424-6.272 33.92-37.76 23.424-103.232-7.872-106.24-9.472-76.288-44.8-140.032-104.192-184.96-185.344-43.264-78.08-68.48-161.92-72.576-251.328-1.152-21.632 5.184-29.312 26.688-33.152a265.6 265.6 0 0 1 85.696-2.24c119.296 17.472 220.928 71.04 306.048 155.52 48.768 48.32 85.504 105.92 123.392 162.176 40.256 59.776 83.648 116.672 138.88 163.392 19.392 16.32 35.072 28.8 49.92 37.952-44.928 5.056-119.872 6.08-171.008-34.496z m56.064-361.024a17.152 17.152 0 1 1 2.752 9.6 16.896 16.896 0 0 1-2.752-9.664z m174.08 89.472a102.72 102.72 0 0 1-33.024 8.96 70.528 70.528 0 0 1-44.736-14.272c-15.296-12.8-26.176-19.968-30.848-42.496a99.264 99.264 0 0 1 0.832-32.96c4.032-18.368-0.384-30.08-13.248-40.768-10.624-8.768-23.872-11.072-38.592-11.072a31.168 31.168 0 0 1-14.272-4.416c-6.144-3.072-11.136-10.752-6.336-20.16 1.536-3.008 8.96-10.304 10.752-11.712 19.84-11.328 42.88-7.68 64.192 0.896 19.712 8.064 34.56 22.848 56 43.776 21.952 25.28 25.792 32.384 38.4 51.328 9.856 14.848 18.816 30.208 24.96 47.616 3.776 10.88-1.152 19.776-14.08 25.28z"></path> |
|---|
| | | </svg> |
|---|
| | | </span> |
|---|
| | | </div>) |
|---|
| | | } |
|---|
| | | ], |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | _verify.default = _verify.default || 'true' |
|---|
| | | _verify.wxNote = _verify.wxNote || 'false' // 公众号消息推送是否开启 |
|---|
| | | _verify.noteEnable = _verify.noteEnable || 'false' // 短信发送是否开启 |
|---|
| | | _verify.emailEnable = _verify.emailEnable || 'false' // 邮件发送是否开启 |
|---|
| | | _verify.printEnable = _verify.printEnable || 'false' // 单据打印是否开启 |
|---|
| | | _verify.preHandle = _verify.preHandle || 'false' // 按钮预处理是否开启 |
|---|
| | | _verify.wxNote = _verify.wxNote || 'false' // 公众号消息推送是否开启 |
|---|
| | | _verify.noteEnable = _verify.noteEnable || 'false' // 短信发送是否开启 |
|---|
| | | _verify.DeepSeekable = _verify.DeepSeekable || 'false'// DeepSeek是否开启 |
|---|
| | | _verify.emailEnable = _verify.emailEnable || 'false' // 邮件发送是否开启 |
|---|
| | | _verify.printEnable = _verify.printEnable || 'false' // 单据打印是否开启 |
|---|
| | | _verify.preHandle = _verify.preHandle || 'false' // 按钮预处理是否开启 |
|---|
| | | _verify.invalid = _invalid |
|---|
| | | _verify.uniques = _verify.uniques || [] |
|---|
| | | _verify.contrasts = _verify.contrasts || [] |
|---|
| | |
|---|
| | | _f.writein = _f.writein !== 'false' |
|---|
| | | _f.fieldlen = _f.fieldlength || 50 |
|---|
| | | |
|---|
| | | if (_f.type === 'linkMain' && _f.verifyVal === 'true') { |
|---|
| | | _f.$verify = true |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (_f.type === 'datemonth') { |
|---|
| | | _f.type = 'text' |
|---|
| | | } else if (_f.type === 'number' || _f.type === 'rate') { |
|---|
| | |
|---|
| | | colfields: colfields.join(', '), |
|---|
| | | uniqueColumns: this.state.uniqueColumns.map(col => { |
|---|
| | | if (col.dataIndex === 'field') { |
|---|
| | | col.options = unionFields |
|---|
| | | col.options = fromJS(unionFields).toJS().map(n => { |
|---|
| | | n.label = `${n.label}（${n.field}）` |
|---|
| | | return n |
|---|
| | | }) |
|---|
| | | } |
|---|
| | | return col |
|---|
| | | }), |
|---|
| | | onceUniqueColumns: this.state.onceUniqueColumns.map(col => { |
|---|
| | | if (col.dataIndex === 'field') { |
|---|
| | | col.options = _columns |
|---|
| | | col.options = fromJS(_columns).toJS().map(n => { |
|---|
| | | n.label = `${n.label}（${n.field}）` |
|---|
| | | return n |
|---|
| | | }) |
|---|
| | | } |
|---|
| | | return col |
|---|
| | | }), |
|---|
| | |
|---|
| | | |
|---|
| | | formdata = formdata.length ? formdata : null |
|---|
| | | |
|---|
| | | let verifyValSql = '' |
|---|
| | | // 获取字段键值对 |
|---|
| | | formdata && formdata.forEach(form => { |
|---|
| | | if (form.$verify) { |
|---|
| | | verifyValSql += ` |
|---|
| | | if @${form.field}=${form.type === 'number' ? 0 : `''`} |
|---|
| | | begin |
|---|
| | | select @errorcode='E',@retmsg='${form.label}，关联主表失效' |
|---|
| | | goto aaa |
|---|
| | | end |
|---|
| | | ` |
|---|
| | | } |
|---|
| | | |
|---|
| | | let _key = form.field.toLowerCase() |
|---|
| | | if (!_initvars.includes(_key)) { |
|---|
| | | _initvars.push(_key) |
|---|
| | |
|---|
| | | |
|---|
| | | verify.billcodes.forEach(item => { |
|---|
| | | let _key = item.field.toLowerCase() |
|---|
| | | let _linkKey = item.linkField ? item.linkField.toLowerCase() : '' |
|---|
| | | |
|---|
| | | if (!keys.includes(_key)) return // 表单中不含单号生成字段 |
|---|
| | | |
|---|
| | | let _lpline = '' |
|---|
| | | if (item.TypeCharOne === 'Lp') { |
|---|
| | | if (_linkKey === 'bid' && BID) { // 替换bid |
|---|
| | | if (/^BID$/ig.test(item.linkField)) { |
|---|
| | | _lpline = `set @ModularDetailCode= 'Lp'+ right('${item.mark || btn.uuid}'+@BID@,48)` |
|---|
| | | } else { |
|---|
| | | _lpline = `set @ModularDetailCode= 'Lp'+ right('${item.mark || btn.uuid}'+@${_linkKey},48)` |
|---|
| | | _lpline = `set @ModularDetailCode= 'Lp'+ right('${item.mark || btn.uuid}'+@${item.linkField},48)` |
|---|
| | | } |
|---|
| | | } else if (item.TypeCharOne === 'BN') { |
|---|
| | | if (_linkKey === 'bid' && BID) { // 替换bid |
|---|
| | | if (/^BID$/ig.test(item.linkField)) { |
|---|
| | | _lpline = `set @ModularDetailCode= 'BN'+ right(@BID@,48)` |
|---|
| | | } else { |
|---|
| | | _lpline = `set @ModularDetailCode= 'BN'+ right(@${_linkKey},48)` |
|---|
| | | _lpline = `set @ModularDetailCode= 'BN'+ right(@${item.linkField},48)` |
|---|
| | | } |
|---|
| | | } else { |
|---|
| | | _lpline = `set @ModularDetailCode= right('${item.ModularDetailCode}',50)` |
|---|
| | |
|---|
| | | let hasvoucher = false |
|---|
| | | |
|---|
| | | // 凭证-显示列中选取,必须选行 |
|---|
| | | if (verify.voucher && verify.voucher.enabled && btn.Ot !== 'requiredOnce') { |
|---|
| | | if (verify.voucher && verify.voucher.enabled) { |
|---|
| | | let _voucher = verify.voucher |
|---|
| | | let linkField = `@${_voucher.linkField}` |
|---|
| | | |
|---|
| | | if (/^BID$/ig.test(_voucher.linkField)) { |
|---|
| | | linkField = `'${BID}'` |
|---|
| | | } |
|---|
| | | |
|---|
| | | hasvoucher = true |
|---|
| | | |
|---|
| | | _sql += ` |
|---|
| | | /* 创建凭证 */ |
|---|
| | | exec s_BVoucher_Create |
|---|
| | | @Bill ='0', |
|---|
| | | @Bill = ${linkField}, |
|---|
| | | @BVoucherType ='${_voucher.BVoucherType}', |
|---|
| | | @VoucherTypeOne ='${_voucher.VoucherTypeOne}', |
|---|
| | | @VoucherTypeTwo ='${_voucher.VoucherTypeTwo}', |
|---|
| | |
|---|
| | | let keys = [] |
|---|
| | | let values = [] |
|---|
| | | |
|---|
| | | formdata.forEach(item => { |
|---|
| | | formdata && formdata.forEach(item => { |
|---|
| | | if (item.writein === false) return |
|---|
| | | let _key = item.field.toLowerCase() |
|---|
| | | |
|---|
| | |
|---|
| | | } else if (_backCustomScript) { |
|---|
| | | _sql += _backCustomScript |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (verifyValSql) { |
|---|
| | | _sql += verifyValSql |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (btn.procMode === 'system') { |
|---|
| | | _sql += ` |
|---|
| | |
|---|
| | | _sql = _sql.replace(/@BID@/ig, `'${BID}'`) |
|---|
| | | _sql = _sql.replace(/@typename@/ig, `'typename'`) |
|---|
| | | _sql = _sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`) |
|---|
| | | _sql = _sql.replace(/\$check@|@check\$/ig, '') |
|---|
| | | |
|---|
| | | return _sql |
|---|
| | | } |
|---|
| | |
|---|
| | | let hasvoucher = false |
|---|
| | | |
|---|
| | | // 凭证-显示列中选取,必须选行 |
|---|
| | | if (verify.voucher && verify.voucher.enabled && btn.Ot !== 'requiredOnce') { |
|---|
| | | if (verify.voucher && verify.voucher.enabled) { |
|---|
| | | hasvoucher = true |
|---|
| | | } |
|---|
| | | if (hasvoucher) { |
|---|
| | |
|---|
| | | _lpline = `set @ModularDetailCode= right('${record.ModularDetailCode}',50)` |
|---|
| | | } |
|---|
| | | |
|---|
| | | let sql = `select @BillCode='', @${record.field}='', @ModularDetailCode='' |
|---|
| | | let sql = `Declare @BillCode nvarchar(50),@ModularDetailCode nvarchar(50) |
|---|
| | | select @BillCode='', @${record.field}='', @ModularDetailCode='' |
|---|
| | | ${_lpline} |
|---|
| | | exec s_get_BillCode |
|---|
| | | @ModularDetailCode=@ModularDetailCode, |
|---|
| | |
|---|
| | | /> |
|---|
| | | <EditTable actions={['move']} data={verify.customverifys} columns={customColumns} onChange={(customverifys) => {this.setState({verify: {...verify, customverifys}})}}/> |
|---|
| | | </TabPane> : null} |
|---|
| | | {verifyInter === 'system' ? <TabPane tab={ |
|---|
| | | {verifyInter === 'system' && (['form', 'pop'].includes(card.OpenType) || !card.OpenType) ? <TabPane tab={ |
|---|
| | | <span> |
|---|
| | | 单号生成 |
|---|
| | | {verify.billcodes.length ? <span className="count-tip">{verify.billcodes.length}</span> : null} |
|---|
| | |
|---|
| | | /> |
|---|
| | | <EditTable actions={['move']} data={verify.billcodes} columns={orderColumns} onChange={(billcodes) => {this.setState({verify: {...verify, billcodes}})}}/> |
|---|
| | | </TabPane> : null} |
|---|
| | | {verifyInter === 'system' ? <TabPane tab={ |
|---|
| | | {verifyInter === 'system' && (card.Ot === 'requiredOnce' || (['form', 'pop'].includes(card.OpenType) || !card.OpenType)) ? <TabPane tab={ |
|---|
| | | <span> |
|---|
| | | {card.Ot !== 'requiredOnce' ? '唯一性验证' : '同类数据验证'} |
|---|
| | | {verify.uniques.length ? <span className="count-tip">{verify.uniques.length}</span> : null} |
|---|
| | |
|---|
| | | } key="voucher"> |
|---|
| | | <VoucherForm |
|---|
| | | voucher={voucher} |
|---|
| | | columns={columns} |
|---|
| | | columns={unionFields} |
|---|
| | | voucherobj={verify.voucher} |
|---|
| | | voucherDetail={voucherDetail} |
|---|
| | | voucherChange={this.voucherChange} |
|---|
