ConstructionCost/protect/models/bills.js

/**
 * Created by Tony on 2017/1/12.
 */
var mongoose = require('mongoose');
var demodb = require('../db/demodb');
//var Schema = demodb.mongoose.Schema;
var Schema = mongoose.Schema;
var BillsSchema = new Schema({
    "SerialNo": Number,
    "ChapterID": Number,
    "ID": Number,
    "ParentID": Number,
    "NextSiblingID": Number,
    "Code": String,
    "FullCode": String,
    "Name": String,
    "Units": String,
    "Quantity": Number,
    "DesignQuantity": Number,
    "DesignQuantity2": Number,
    "DesignPrice": Number,
    "TotalPrice": Number,
    "Memostr": String
});

var ConstructBillsSchema = new Schema({
    "SerialNo": Number,
    "ChapterID": Number,
    "ID": Number,
    "ParentID": Number,
    "NextSiblingID": Number,
    "Code": String,
    "FullCode": String,
    "Name": String,
    "Units": String,
    "Quantity": Number,
    "DesignQuantity": Number,
    "DesignQuantity2": Number,
    "DesignPrice": Number,
    "TotalPrice": Number,
    "Memostr": String
});

//var BillsData = demodb.mongoose.model("bills", BillsSchema);
var BillsData = demodb.mongoose.model("gd_bills", BillsSchema);

var BillDataDAO = function(){};

BillDataDAO.prototype.get = function(id, callback){
    BillsData.find({ID: id}, function(err, templates){
        if(templates.length){
            callback(false, templates[0]);
        }
        else{
            callback('No result found!');
        }
    })
}

BillDataDAO.prototype.getAll = function(userid, callback){
    BillsData.find({}, function(err, templates){
        if(templates.length){
            callback(false, templates);
        }
        else{
            callback('No result found!');
        }
    })
}

module.exports = new BillDataDAO();