ConstructionCost/modules/feeLibs/models/feeLibs_db.js

/**
 * Created by CSL on 2017-03-22.
 */

var mg = require('mongoose');
var dbm = require("../../../config/db/db_manager");
var umDB = dbm.getCfgConnection("feeLibs");

var feesSchema = new mg.Schema({
    ID: Number,
    ParentID: Number,
    name: String,
    fee: Number,
    memo: String
});

var stdFeeSchema = new mg.Schema({
    region: String,                     // 工程所在地
    fileID: Number,                     // 费率标准文件ID
    fileName: String,                   // 费率标准文件名称
    fees: [feesSchema]                  // 树表结构费率值
});

var feeLibModel = umDB.model('files', stdFeeSchema);

var StdFeeLib = function(){};

StdFeeLib.prototype.files = function(region, controllerFun){
    feeLibModel.find({"region": region}, ["fileID", "fileName"], function(err, data){
        if(data.length){
            controllerFun(data);
        }
        else{
            controllerFun(false);
        }
    })
};

StdFeeLib.prototype.fees = function(fileID, controllerFun){
    feeLibModel.find({"fileID": fileID}, ["fees"], function(err, data){
        if(data.length){
            controllerFun(data);
        }
        else{
            controllerFun(false);
        }
    })
};

module.exports = new StdFeeLib();