ConstructionCost/modules/rationLibEditor/models/rationItems.js

/**
 * Created by Syusuke on 2017/3/23.
 */
var mongoose = require("mongoose");
var dbm = require("../../../config/db/db_manager");
var async = require("async");
var Schema = mongoose.Schema;


var rationItemsSchema = mongoose.Schema({//只记载定额基本元素，并未和工料机挂钩
    rationCode:String,
    rationName:String,
    unit:String,
    basePrice:Number,
    sectionId:Number,
    contentId:Number,
    caption:String,//显示内容
    feeType:Number //取费类别，这条定额对应怎样的费率参与计算，在键定额库的时候手动输入
});

var rationItemsDAO = function(){};

rationItemsDAO.prototype.insertRation = function(LibName,value,callback){
    var db = dbm.getCfgConnection(LibName);
    var rationItemsModel = db.model("rationItems",rationItemsSchema);
    if(value.cellCurrValue == value.cellPrimValue) callback(false,false);
    rationItemsModel.find({rationCode:value.cellCurrValue},function(err,data){
        if(data.length)
            callback(false,false);
        else{
            if(value.cellPrimValue == null){
                var ration = {};
                ration.rationCode = value.cellCurrValue;
                ration.rationName = null;
                ration.unit = null;
                ration.basePrice = null;
                ration.sectionId = null;
                ration.contentId = null;
                ration.caption = null;
                ration.feeType = null;
                new rationItemsModel(ration).save(function(err){
                    if(err)
                        callback(err,false);
                    else
                        callback(err,"ok")

                })
            }else
                rationItemsModel.update({rationCode:value.cellPrimValue},{$set:{rationCode:value.cellCurrValue}},function(err){
                    if(err) callback("更新定额发生错误",false);
                    else  callback(err,"ok");
                });
        }
    })
}
rationItemsDAO.prototype.updateRation = function(libName,value,data,callback){
    var db = dbm.getCfgConnection(libName);
    var rationItemsModel = db.model("rationItems",rationItemsSchema);
    var ration = {}
    ration.rationCode = data[0];
    ration.rationName = data[1];
    ration.unit = data[2];
    ration.basePrice = data[3];
    ration.sectionId = value.sectionSelected;
    ration.contentId = null;
    ration.caption = data[4];
    ration.feeType = data[5];
    rationItemsModel.find({rationCode:ration.rationCode},function(err,data){
        if(err) callback("请确是否有该定额！",false)
        else
        rationItemsModel.update({rationCode:ration.rationCode},ration,function(err){
            if(err) callback("更新定额错误",false)
            else callback(err,"更新成功");
        })
    })
}

module.exports = new rationItemsDAO()