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 ratesSchema = new mg.Schema({
    ID: Number,
    ParentID: Number,
    name: String,
    rate: Number,
    memo: String
});

var feeRatesSchema = new mg.Schema({
    ID: Number,
    libID: Number,
    libName: String,
    rates: [ratesSchema]
});

var feeRatesModel = umDB.model('feeRates', feeRatesSchema, 'feeRates');

var FeeRateFile = function(){};

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

// 1 保存成功; 0 保存失败；-1没有找到对应记录。
FeeRateFile.prototype.updateRate = function(rateObj, controllerFun){
    feeRatesModel.find({"ID": rateObj.fileID}, ["rates"], function(err, data){
        if(data.length){
            for (var i = 0; i < data[0].rates.length; i++) {
                if (data[0].rates[i].ID == rateObj.rateID) {
                    data[0].rates[i].rate = rateObj.rateValue;
                    data[0].save(function (err) {
                        if (err) { controllerFun(0); } else { controllerFun(1); }
                    });
                    break;
                }
            };
        }
        else{ controllerFun(-1); }
    })
};

module.exports = new FeeRateFile();