/** * 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()