SourceDataClient/db/usersProvider.js

/**
 * Created by luququ on 2015/10/15.
 */
var seqs;
var Promise = require('bluebird');

exports.getAll = function(serverId) {
    var seq = seqs[serverId];
    return seq.query('select 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 from users where serverId = :sid', {
            replacements: { sid: serverId },
            type: seq.QueryTypes.SELECT
        });
};

exports.setSequelize = function(sequelizes) {
    seqs = sequelizes;
};