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 counter = require('../../../public/counter/counter');

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

gljItemDAO.prototype.getGljItemsByRep = function(repositoryId,callback){
    gljItemModel.find({"repositoryId": repositoryId},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();