Skip to content

Instantly share code, notes, and snippets.

@bluemoon2014
bluemoon2014 / BidPlanSQLServer.js
Last active April 24, 2018 09:08
普通基线接口 包含下载上传
/**
* Created by Linyuning on 2018/4/10.
*/
var MysqlDB = require("../db/MysqlDB.js");
var mysqldb = new MysqlDB(config.mysqlDatabase);
var commonUtil = require("../utils/commonUtil.js");
var sqlUtil = require("../utils/sqlUtil.js");
var bidPlanSQLServer = {};
@bluemoon2014
bluemoon2014 / promise快速学习.js
Last active April 24, 2018 09:41
许诺的学习
//then 中 是可以把返回值 当做promise 包装的
//但是在new promise 中 是没有这个能力的 return 只会导致跳出函数 promise 的状态永远不会被设定
//无论return 与否 链式的then 都会一直往下走 找下一个then
//catch 后 如果什么都没有 也会一直依次的走then 下去
//return function 直接不执行了 就等你调用 函数的参数 只能写名字 不能写一个函数实现了 最多写函数变量名
//return promise 则提供一个函数作为参数 这个参数不是外面给的 而是自己用的
//resolve 后 还是会执行promise里的语句的
//一旦resolve 或者reject 后 promise 状态就不再变化了
//promise 里的代码实际上是在调用promise时候同步执行的 一直执行到resolve 或是reject 以后,
//也还是会继续同步执行,一直到末尾或者遇到return 除非有代码是异步的 不然里面的代码实际上是同步的
@bluemoon2014
bluemoon2014 / app.js
Created April 21, 2018 11:43
发射内部调用
var request = require('request');
var options = {
  method: 'post',
url: "http://127.0.0.1:2000/publicInterface/login",
form: {userName:"admin",password : 123456},
headers: {
'Content-Type': 'application/x-www-form-urlencoded'
}
};
@bluemoon2014
bluemoon2014 / index.js
Created April 21, 2018 11:44
设置后门
if (req.method == "GET") {
req.headers["token"] = tokenTemp.toString();
}else{
req.body.token = tokenTemp.toString();
}
@bluemoon2014
bluemoon2014 / js实验.js
Created April 22, 2018 10:05
JavaScript 深复制
function deepCopyObjt(argument) {
if (typeof argument != "object") return argument;
var newObjt = {};
for (attr in argument){
newObjt[attr] = deepCopyObjt(argument[attr]);
}
return newObjt;
}
sqlUtil.generateUpdateSql(BID_ISSUE_TABLE_NAME, {
code : params.code,
bidCode:"",
}, {code : params.code }).then(function (option) {
return mysqldb.execute(option.sql, option.sql_param).then(resolve).catch(function (error) {
// console.log("sql error " +error);
reject(error);
})
}).catch(reject);
@bluemoon2014
bluemoon2014 / sqlUtil.js
Created April 23, 2018 03:03
删除SQL语句
var sqlString = "DELETE FROM " + _tableName +" WHERE code=?";
@bluemoon2014
bluemoon2014 / managerBidBackAndIssue.js
Created April 23, 2018 03:16
增加删除修改三合一一张表
.then(function () {
return Promise.all(bidWindSegsObjcToDeal.inserts.map(function (currentBidWinSeg) {
return bidSegSQLServer.addBidWinSegMycWrapper(currentBidWinSeg);
}));
}).then(function (bidWinSegCodes) {
//增加分标段成功
@bluemoon2014
bluemoon2014 / managerBidBackAndIssue.js
Last active April 26, 2018 01:57
重构后的路由
/**
* Created by myc on 2018/4/16.
*/
var express = require('express');
var managerBidBackAndIssue = express.Router();
var bidBackAndIssueSQLServer = require('../server/BidBackAndIssueSQLServer.js');
var bidQKLServer = require('../server/BidQKLServer.js');
var bidIssueDetailSQLServer = require("../server/BidIssueDetailSQLServer.js");
var bidAttachSQLServer = require("../server/AttachSQLServer.js");
MysqlDB.prototype.atomCRUD = function (_sqlOptions) {
var self = this;
if (!self._pool) {
throw new Error("MysqlDB was not initialized");
}
return new Promise(function (resolve, reject) {
self._pool.getConnection(function(err, connection) {
var counter = 0;
if (err) {