TargetDataService/db/usersProvider.js

/**
 * Created by luququ on 2015/10/15.
 */
var seq;
exports.delete = function(serverId) {
    return seq.query('delete from users where serverId = :sid', {
        replacements: { sid: serverId },
        type: seq.QueryTypes.DELETE
    });
};

exports.insert = function(users) {
    return seq.query('insert users(loginName, displayName, password, watchWord, loginState, branchId, position, company, branch, duty, tel, mobile, version, intro, shortMobile, officeId, serverId, email, id, secret, roles, mainRole, userType, enableAccont, enableSendSms, enableMultiSendSms, addrBookSize, daySMSLimit, address) ' +
        'values(' +
        ':loginName,' +
        ':displayName,' +
        ':password,' +
        ':watchWord,' +
        ':loginState,' +
        ':branchId,' +
        ':position,' +
        ':company,' +
        ':branch,' +
        ':duty,' +
        ':tel,' +
        ':mobile,' +
        ':version,' +
        ':intro,' +
        ':shortMobile,' +
        ':officeId,' +
        ':serverId,' +
        ':email,' +
        ':id,' +
        ':secret,' +
        ':roles,' +
        ':mainRole,' +
        ':userType,' +
        ':enableAccont,' +
        ':enableSendSms,' +
        ':enableMultiSendSms,' +
        ':addrBookSize,' +
        ':daySMSLimit,' + 
        ':address)', {
            replacements: users,
            type: seq.QueryTypes.INSERT
        });
};

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