ConstructionCost/modules/fees/models/fees_db.js

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

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

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

var feeSchema = new mg.Schema({
    ID: Number,
    //projectID: Number,    // 被多个项目引用。项目记录该文件ID
    feeFileID: Number,
    feeFileName: String,
    fees: [feeArrSchema]
});

var feeModel = umDB.model('fees', feeSchema);

var feeFile = function(){};

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

module.exports = new feeFile();