TargetDataService/db/addrGroupMemberProvider.js

/**
 * Created by thm on 2017/09/08.
 */
var seq;
exports.delete = function(serverId) {
    return seq.query('delete from AddrGroupMember' + serverId,
    {
        type: seq.QueryTypes.DELETE
    });
};

exports.insert = function(addrGroupMember, serverId) {
    return seq.query('insert AddrGroupMember' + serverId + '(ID, LoginName, DisplayName, Mobile, GroupId, Tel, Email, Remark, NickName, Position) ' +
        'values(' +
        ':ID,' +
        ':LoginName,' +
        ':DisplayName,' +
        ':Mobile,' +
        ':GroupId,' +
        ':Tel,' +
        ':Email,' +
        ':Remark,' +
        ':NickName,' +
        ':Position)', {
            replacements: addrGroupMember,
            type: seq.QueryTypes.INSERT
        });
};

exports.setSequelize = function(sequelize) {
    seq = sequelize;
};