ConstructionCost/modules/rationLibEditor/models/gljList.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 gljListSchema = mongoose.Schema({
    GLJCode:String,
    GLJName:String,
    specs:String,//规格，钢筋粗细，光圆
    unit:String,//单位
    basePrice:Number,
    type:Number //工料机类型，便于分类
});

var gljListDAO = function(){};

gljListDAO.prototype.insertGLJList = function(LibName,value,callback){
    var db = dbm.getCfgConnection(LibName);
    var gljListModel = db.model("gljlists",gljListSchema);
    if(value.cellCurrValue == value.cellPrimValue) callback(false,false);
    gljListModel.find({GLJCode:value.cellCurrValue},function(err,data){
        if(data.length)
            callback(false,false);
        else{
            if(value.cellPrimValue == null){
                var glj = {};
                glj.GLJCode = value.cellCurrValue;
                glj.GLJName = null;
                glj.specs = null;
                glj.unit = null;
                glj.basePrice = null;
                glj.type = null;
                new gljListModel(glj).save(function(err){
                    if(err)
                        callback(err,false);
                    else
                        callback(err,"ok")
                })
            }else
                gljListModel.update({gljCode:value.cellPrimValue},{$set:{gljCode:value.cellCurrValue}},function(err){
                    if(err) callback("更新工料机发生错误",false);
                    else  callback(err,"ok");
                });
        }
    })
}

gljListDAO.prototype.updateGLJList = function(libName,value,data,callback){
    var db = dbm.getCfgConnection(libName);
    var gljListModel = db.model("gljlists",gljListSchema);
    var glj = {}
    glj.GLJCode = data[0];
    glj.GLJName = data[1];
    glj.specs = data[2];
    glj.unit = data[3];
    glj.basePrice = data[4];
    glj.type = data[5];
    gljListModel.find({GLJCode:glj.GLJCode},function(err,data){
        if(err) callback("请确是否有该工料机！",false)
        else
            gljListModel.update({GLJCode:glj.GLJCode},glj,function(err){
                if(err) callback("更新工料机错误",false);
                else callback(err,"更新成功");
            })
    })
}

gljListDAO.prototype.removeGLJList = function(libName,value,callback){
    var db = dbm.getCfgConnection(libName);
    var gljListModel = db.model("gljlists",gljListSchema);
    gljListModel.remove({GLJCode:value.cellPrimValue},function(err){
        if(err) callback("删除失败",false)
        else callback(err,"ok");
    })
}
module.exports = new gljListDAO()