wsw-framework

wsw-framework BaseBLL,BaseDAL底层封装 just for myself study

use by typescript eg.

async function test() { console.log('query'); let bll = new BaseBLL(gcoa); let bll_gcgs = new BaseBLL(yf_gcgs);

let sql = `select mv001,mv002 from cmsmv 
    where mv001='000057'`;
let data = await bll.query(sql);
console.log(data);

// sql = `select MV001,MV002 from CMSMV`;
// let data1 = await bll_gcgs.query(sql);
// console.log(data1);

console.log('getSingleFieldValue');
sql = `select mv002 from cmsmv 
    where mv001='000057'`;
let name = await bll.getSingleFieldValue(sql);
console.log(name);

// console.log('execute');
// sql = `update cmsmv set mv002='王绍伟' where mv001='000057'`;
// let r = await bll.execute(sql);
// console.log(r);

// console.log('update');
// let jdata: IJdata = {
//     dbAction: DbAction.update,
//     table: "cmsmv",
//     data: {
//         MV002: "王绍伟123"
//     },
//     where: {
//         MV001: "000057"
//     }
// };
// let r = await bll.updateSingle(jdata);
// console.log(r);

}