ConstructionCost/modules/rationRepository/models/gljRepository.js

/**
 * Created by Tony on 2017/5/4.
 * 工料机的总库，根据不同定额库分类，参考原gljList表
 */

var mongoose = require("mongoose");
var dbm = require("../../../config/db/db_manager");
var db = dbm.getCfgConnection("rationRepository")
var async = require("async");
var Schema = mongoose.Schema;

var gljTypeSchema = mongoose.Schema({
    repositoryId: Number,
    ID: Number,
    ParentID: Number,
    NextSiblingID: Number,
    Name: String
});

var gljSchema = mongoose.Schema({
    repositoryId: Number,
    ID:Number,
    //以下是基于已有access库
    code: String,
    name: String,
    specs: String,
    unit: String,
    basePrice: Number,
    gljType: Number
});
var gljTypeModel = db.model("gljType",gljTypeSchema, "gljType");
var gljItemModel = db.model("gljRepository",gljSchema, "gljRepository");
var repositoryMap = require('./repositoryMap');
var counter = require('../../../public/counter/counter');

var gljItemDAO = function(){};
gljItemDAO.prototype.getGljTypes = function(repositoryName, callback){
    repositoryMap.getRealLibName(repositoryName, function(err, rst){
        if (err || rst.length == 0) {
            callback("获取定额库错误！",false)
        } else {
            gljTypeModel.find({"repositoryId": rst[0].ID, "$or": [{"isDeleted": null}, {"isDeleted": false} ]},function(err,data){
                if(data.length) callback(false,data);
                else  if(err) callback("获取工料机类型错误！",false)
                else callback(false,false);
            })
        }
    });
};

gljItemDAO.prototype.getGljItemsByRep = function(repositoryId,callback){
    gljItemModel.find({"repositoryId": repositoryId},function(err,data){
        if(err) callback(true, "获取工料机错误！", "")
        else callback(false,"获取工料机", data);
    })
};

gljItemDAO.prototype.getGljItemByType = function(repositoryId, type, callback){
    gljItemModel.find({"repositoryId": repositoryId, "gljType": type},function(err,data){
        if(err) callback(true, "获取工料机错误！", "")
        else callback(false,"获取工料机", data);
    })
};

gljItemDAO.prototype.getGljItem = function(repositoryId, code, callback){
    gljItemModel.find({"repositoryId": repositoryId, "code": code},function(err,data){
        if(err) callback(true, "获取工料机错误！", "")
        else callback(false,"获取工料机", data);
    })
};

module.exports = new gljItemDAO();