| | |
|---|
| | | |
|---|
| | | fields.push('jskey') |
|---|
| | | |
|---|
| | | let _sql = `Declare @${btn.sheet} table (${usefulfields.map(item => item.field + ' ' + item.type).join(',')},jskey nvarchar(50) ) |
|---|
| | | let _sql = `Declare @${btn.sheet} table (${usefulfields.map(item => item.field + ' ' + item.type).join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(50)) |
|---|
| | | Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(50),@mk_organization nvarchar(50),@login_city nvarchar(50),@ErrorCode nvarchar(50), @retmsg nvarchar(4000),@tbid Nvarchar(512) |
|---|
| | | Select @ErrorCode='', @retmsg='' |
|---|
| | | ` |
|---|
| | |
|---|
| | | </Col> |
|---|
| | | {usefulfields ? <Col span={24} className="sqlfield"> |
|---|
| | | <Form.Item label={'可用字段'}> |
|---|
| | | BID, ID, LoginUID, SessionUid, UserID, Appkey, UserName, FullName, RoleID, mk_departmentcode, mk_organization, login_city, {usefulfields} |
|---|
| | | BID, ID, LoginUID, SessionUid, UserID, Appkey, UserName, FullName, RoleID, mk_departmentcode, mk_organization, login_city, {usefulfields},data_type（注：jskey为主键值，新增时前端生成；data_type为操作类型，新增 - add、修改 - upt、删除 - del） |
|---|
| | | </Form.Item> |
|---|
| | | </Col> : null} |
|---|
| | | <Col span={8} style={{whiteSpace: 'nowrap'}}> |
|---|
