V8 Function List-Backend

Introduction

server-side V8 engine code and front-end V8 programming language are Javascript syntax
Server-side V8 engine supports ES6 syntax
The server-side V8 engine integrates some back-end objects and methods, and can use js to call back-end methods (not http)
Server-side V8 engine code is executed on the server side

V8.ApiEngine

V8 events on the server side can directly call the interface engine (not http)

javascript

//调用方式有两种，第一种：
var result = V8.ApiEngine.Run('ApiEngineKey', { 
    Param1 : '1',
});
//第二种
V8.Result = V8.ApiEngine.Run({
  ApiEngineKey : 'ApiEngineKey',
  Param1 : '1'
});

V8.Cache

Cache operation class

javascript

//设置缓存
//第一个参数为缓存key，支持多级缓存，如：'First'、'First:OsClient'、'First:OsClient:Third'
//通常缓存Key的命名规则为第一级自定义，第二级强烈建议使用OsClient值，在saas模式下更容易区分。
//第二个参数为缓存值，需要是string类型，若要存储对象，请使用JSON.stringify()序列化
//第三个参数为有效期，格式为【HH:mm:ss】、或【dd.HH:mm:ss】。不传则为永久。
//HH范围为0-23；mm、ss范围为0-59；dd范围为0-int最大值。用例：5分钟有效期'00:05:00'、5天有效期'5.00:00:00'
var result1 = V8.Cache.Set('Test:microi:userid', '0000-0000-0000', '00:00:59');//返回bool类型
//获取缓存
var result2 = V8.Cache.Get('Test:microi:userid');//返回string类型，无缓存返回null
//删除缓存。注：若在Set时设置了有效期，到期会自动删除。
var result3 = V8.Cache.Remove('Test:A');//返回bool类型

System

server-side V8 code can directly use the System namespace under. net

csharp

//生成一个服务器端GUID值
System.Guid.NewGuid()

//将字符串转为base64字符串，建议使用后封装的V8.Base64
var bytes = System.Text.Encoding.UTF8.GetBytes(originalString);  
var base64String = System.Convert.Convert.ToBase64String(bytes);
//解密base64，，建议使用后封装的V8.Base64
var bytes = System.Text.Encoding.UTF8.GetBytes(originalString);  
var base64String = System.Convert.Convert.ToBase64String(bytes);

V8.Action.GetDateTimeNow()
调用服务器端全局函数，获取yyyy-MM-dd HH:mm:ss格式的当前时间字符串。若获取日期格式，可使用new Date();

V8.Method

Integrates some common functions

javascript

V8.Method.GetCurrentToken(token, osClient)
从redis中获取当前登陆用户的token和身份信息，token, osClient为可选参数
返回：{ OsClient : '', CurrentUser : {}, Token : '' }

V8.Method.RefreshLoginUser(userId, osClient)
刷新用户的登陆身份redis缓存信息，必传userId、osClient

V8.Method.GetPrivateFileUrl()
获取私有文件的临时访问地址，可传入FilePathName、或FilePathNames
var result = V8.Method.GetPrivateFileUrl({
    FilePathName : '/microi/file/2023-08-06/xxx.doc',
    //FilePathNameS : ['/microi/file/2023-08-06/xxx.doc']
});
返回{ Code : 1/0, Data : '临时访问地址'/['临时访问地址'], Msg : '错误信息' }

V8.Base64

Base64 conversion. Unlike System.Convert.Convert.ToBase64String(bytes), V8.Base64 directly returns the source string if an exception occurs.

javascript

var result = V8.Base64.StringToBase64('123456');
var result = V8.Base64.Base64ToString('MTIzNDU2');

V8.CurrentUser

The current login user information, including the user's role, organization, etc., including the use of forms engine to add fields to the sys_user table information.

V8.Db

Database access Dos.ORM object

csharp

用例：
var list = V8.Db.FromSql("select * from table")
                .ToArray() //返回数组数据，一般用于select语句
                .ExecuteNonQuery() //返回受影响行数，一般用于update、delete、insert语句
                .First() //返回单条数据，一般用于select语句
                .ToScalar() //返回单个值，一般用于select 聚合函数、单个字段

V8.DbRead

Database read-only object. The usage is the same as that of V8.Db. When read/write splitting is not deployed in the database, the value of this object is the same as that of the V8.Db object.

V8.Dbs.DbKey

Multi-database usage, such as V8.Dbs.OracleDB1.FromSql('')(V8.Dbs.OracleDB1 with V8.Db)

V8.MongoDb

see related articles:Microi code-interface engine actual combat: MongoDB related operations

V8.Http

Encapsulation of RestSharp

javascript

//post请求，返回string，对应的也有V8.Http.Get，参数数名称则为GetParam
var loginResult = V8.Http.Post({
  Url : 'http://192.168.0.173:1052/api/SysUser/login',
  PostParam : { Account : 'admin', Pwd : '****', OsClient : 'veken' }
});
//post请求，返回Response对象，目前里面暂时只包含Headers、Content。，对应的也有V8.Http.GetResponse，参数数名称则为GetParam
var loginResult2 = V8.Http.PostResponse({
  Url : 'http://192.168.0.173:1052/api/SysUser/login',
  PostParam : { Account : 'admin', Pwd : '@kaifa123', OsClient : 'veken' }
});
//获取header中的Authorization值
var header = loginResult2.Headers.find(item => {
  return item.Name == 'Authorization' || item.Name == 'authorization';
})
if(header){
  //再获取当前登陆身份信息，测试传入header
  var token = header.Value;
  var getCurrentUser = V8.Http.Post({
    Url: 'http://192.168.0.173:1052/api/SysUser/getCurrentUser',
    Headers: { authorization : 'Bearer ' + token}
  });
  V8.Result = '获取身份信息成功：' + getCurrentUser;
}else{
  //未获取到token
  V8.Result = '获取header失败：' + loginResult2;
}

//发起xml请求
var result = V8.Http.Post({
  Url : 'http://192.168.0.173:1052/api/SysUser/login',
  ParamType : 'xml',
  PostParamString : '<xml><text>1</text></xml>'
});

V8.Header, V8.Param

Currently, both of them can only be used in the interface engine to obtain the message sent by the client http post request interface engine address and Request Payload parameters.

V8.EncryptHelper

Dos.Common encryption help class

javascript

//DES加密
var pwd = V8.EncryptHelper.DESDecode('JdZe5gWKjZo=');
//DES解密
var pwd2 = V8.EncryptHelper.DESEncode('123456');
V8.SysConfig
访问系统设置信息

V8.Form

The form data can be accessed in the form submission event, and this object is empty in the interface engine.

V8.FormSubmitAction

Form submission type: Insert/Delete/Update(string type) Note that there are no FormOutAction or FormOutAfterAction in the server-side V8 event, only FormSubmitAction

V8.EventName

The name of the front-end V8 event, which is relatively easy to use in the global V8 engine code. Possible values: FormSubmitBefore: V8 event before form submission FormSubmitAfter: V8 event after form submission DataFilter: Data Processing V8 Events WFNodeLine: process node condition judgment V8 event WFNodeEnd: Process Node End V8 Event WFNodeStart: Process Node Start V8 Event

Event

Server-side data processing V8 engine code This event will be executed every row after obtaining the list data and after obtaining the form data. Encapsulated object: a)V8.RowIndex: the row index of the list data, starting from 0 B) V8.Form: List data per row object, form data object c)V8.NotSaveField: Specify which fields are not saved during editing d)V8.CacheData: for caching data Some fields can be desensitized, such as V8.Form. Price = ""; Be sure to set: V8.NotSaveField = ["Price"]; Otherwise will be written to the database when modifying the data. Writing:

javascript

var listData = [];
//如果是第一行数据、或是表单数据，从数据库中获取数据
if(V8.RowIndex == 0 || V8.RowIndex == null){
    listData = V8.Db.FromSql("select * from table").ToDataTable();
    //将数据缓存起来，第二行还要用到，没必要再从数据库取一次。
    V8.CacheData = listData;
}else{
    listData = V8.CacheData;
}
//获取第一条数据的Id值
var id = listData.Rows[0]["Id"];
//获取总共多少条数据
var rowsCount = listData.Rows.Count;
全局服务器端V8引擎代码
在系统设置-->全局服务器端v8引擎代码中新增：
//增加一个自定义全局变量：TestParam1
V8.Param.TestParam1 = "abc";
//增加一个全局自定义方法：TestAction1
V8.Action.TestAction1 = function(){
        V8.Form["Price"] = "***";
        V8.NotSaveField = ["Price"];
}
在其它服务器端V8引擎代码事件中调用：
V8.Action.TestAction1();
V8.Form.Beizhu = V8.Param.TestParam1;

Server-side form pre-submit V8 event

Form submission can be prevented by V8.Result = { Code : 0, Msg: 'error information'}. Note: As long as the {} object is assigned to V8.Result, the form is prevented from being submitted and the transaction is rolled back, regardless of the Code value.

V8 event after server-side form submission

The submission of the form can be rolled back via V8.DbTrans.Rollback() and V8.Result = { Code : 0, Msg 'error information'}. Note: Whenever a {} object is assigned to V8.Result, the transaction is rolled back, regardless of the Code value.

Server-side V8 code debugging scheme

javascript

//【第一步】定义是否需要向前端输出日志内容，需要调试时为true，不需要调试时为false
var isDebugLog = true;//也可以使用系统设置全局变量：var isDebugLog = V8.SysConfig.V8EngineDebugLog;
//【第二步】定义需要向前端输出的日志内容
var debugLog = {};
//获取业务数据
var list1Result = V8.FormEngineGetTableData({
    FormEngineKey: 'test1',
    _Where: [{ Name : 'field1', Value : '1', Type : '=' }]
});
if(list1Result.Code != 1){
    V8.Result = list1Result; return;
}
//【记录日志】测试记录日志1
debugLog.Log1 = list1Result.Data;
//处理业务数据
debugLog.Log2 = [];
for(var i = 0; i < list1Result.Data.length){
    var item = list1Result.Data[i];
    if(item.Number < 10){
        item.Number = '0' + item.Number;
        //【记录日志】测试记录日志2
        debugLog.Log2.push(item.Id);
    }
}
V8.Result = { 
    Code : 1, 
    Data :  , 
    DataAppend : {
        DebugLog : isDebugLog ? debugLog : ''//【第三步】判断是否向前端输出日志
    }
};

V8.DbTrans

Database transaction objects, which can be used like V8.Db, such:

var array = V8.DbTrans.FromSql('...').ToArray();

The transaction object must execute [V8.DbTrans.Commit()] or [V8.DbTrans.Rollback()] in the interface engine]
There is no need to use try catch in the interface engine to catch the exception and execute [V8.DbTrans.Rollback()]. The interface engine will recognize the exception and execute [V8.DbTrans.Rollback()]]
Interface Engine Example

javascript

//操作第一张表，带事务
var result1 = V8.FormEngine.UptFormData('表名或表Id，不区分大小写', {
    Id : '',//必传
    Age : 20, //要修改的字段，注意字段值不能是{}或[]，需要序列化
    Sex : '女'
}， V8.DbTrans);
//操作第二张表，带事务
var result2 = V8.FormEngine.UptFormData('表名或表Id，不区分大小写', {
    Id : '',//必传
    Age : 20, //要修改的字段，注意字段值不能是{}或[]，需要序列化
    Sex : '女'
}， V8.DbTrans);
//如果第二张表操作成功
if(result2.Code == 1){
  V8.DbTrans.Commit();//提交事务
  return { Code : 1 }
}else{//如果第二张表操作失败
  V8.DbTrans.Rollback();//回滚事务
  return { Code : 0, Msg : result.Msg }
}

V8.Param

Used to access the parameters passed in by the front end, url parameters, form-data parameters, and payload-json parameters can be accessed.

V8.Action

Used to access methods customized at the global server V8 code

V8.Result

for return value

V8 Function List-Backend ​

Introduction ​

V8.ApiEngine ​

V8.Cache ​

System ​

V8.Method ​

V8.Base64 ​

V8.CurrentUser ​

V8.Db ​

V8.DbRead ​

V8.Dbs.DbKey ​

V8.MongoDb ​

V8.Http ​

V8.Header, V8.Param ​

V8.EncryptHelper ​

V8.Form ​

V8.FormSubmitAction ​

V8.EventName ​

Event ​

Server-side form pre-submit V8 event ​

V8 event after server-side form submission ​

Server-side V8 code debugging scheme ​

V8.DbTrans ​

V8.Param ​

V8.Action ​

V8.Result ​

V8 Function List-Backend

Introduction

V8.ApiEngine

V8.Cache

System

V8.Method

V8.Base64

V8.CurrentUser

V8.Db

V8.DbRead

V8.Dbs.DbKey

V8.MongoDb

V8.Http

V8.Header, V8.Param

V8.EncryptHelper

V8.Form

V8.FormSubmitAction

V8.EventName

Event

Server-side form pre-submit V8 event

V8 event after server-side form submission

Server-side V8 code debugging scheme

V8.DbTrans

V8.Param

V8.Action

V8.Result