objMs.forEach(itemM => { let sql = `INSERT INTO ` + TB_SQLITE.tb_health + `( healthid, healthname, detailhealth ) VALUES( ?, ?, ? )`; //console.log(sql); let paramSql = [ itemM.healthid, itemM.healthname, itemM.detailhealth ]; this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, paramSql).then( (result) => { SQLiteHandle.recordBeWrite++; //console.log('==== Insert table tb_health successfully.'); } , (error) => { console.log('!!!!!!!!!!!!!!!!!!!!!!!! ==> Insert table tb_health error. ' + error); } ) } , (error) => { reject(error); }); });
(res) => { let valArray: Array<string> = new Array<string>(); objMs.forEach(itemM => { valArray.push("'" + itemM.quotationno + "'"); }); let sqlParameList: string = valArray.join(","); let sql = "DELETE FROM " + TB_SQLITE.tb_quotationrider; sql += " WHERE quotationno IN (" + sqlParameList + ")"; //console.log('SQL command = xxxxxxxxxxxxx ' + sql); this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, []).then( (result) => { //console.log("===== deleteByQuoNo Quotationrider success."); resolve(res); } , (error) => { console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> deleteByQuoNo ERROR Quotationrider " + error); reject(error); } ) } , (error) => { console.log(error); reject(error); } ) },
objM.forEach(itemM => { let paramSql = [ itemM.quotationno, itemM.customerid, itemM.ridertype, itemM.sum, itemM.premium, itemM.createdatetime, itemM.lastmodify, itemM.lastsync, itemM.agentid ]; this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, paramSql).then( (result) => { let num: number = SQLiteHandle.recordBeWrite; SQLiteHandle.recordBeWrite = Number(num + 1); } , (error) => { console.log('==== Insert table Quotationrider error. ' + itemM.agentid + error); } ) } , (error) => { reject(error); } ).catch((error) => { reject(error); }); });
(res) => { let objMs: Array<PlanTypeDetailM> = params; let paramSQL = []; if (objMs != null && objMs.length > 0) { paramSQL = [objMs[0].typecode]; } else { reject("[objM[0].typecode] is null"); } let sql = `DELETE FROM ` + TB_SQLITE.tb_plantypedetail + ` WHERE typecode=?`; console.log(sql); this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, paramSQL).then( (result) => { //console.log("===== Delete tb_plantypedetail success."); resolve(res); } , (error) => { console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Delete tb_plantypedetail error." + error + " : " + error.message); reject(error); } ) } , (error) => { console.log(error); reject(error); } ) },
(res) => { let riderDetailM: Array<RiderDetailM> = objMs; let paramSQL = []; let sql = `DELETE FROM ` + TB_SQLITE.tb_riderdetail + ` WHERE plancode=?`; if (riderDetailM != null && riderDetailM.length > 0) { paramSQL = [riderDetailM[0].plancode]; } else { reject("riderDetailM[0].plancode is null."); } console.log(sql); this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, []).then( (result) => { console.log("===== Delete tb_riderdetail success."); resolve(res); } , (error) => { console.log("===== Delete tb_riderdetail error." + error + " : " + error.message); reject(error); } ) } , (error) => { console.log(error); reject(error); } ) },
() => { this.db.create(ConectionDBName.connectionDB) .then( (connection: SQLiteObject) => { let sql: string = `CREATE TABLE IF NOT EXISTS ` + TB_SQLITE.tb_packagecoverage2 + `( plancode TEXT, pan TEXT, accdsum TEXT, gsum TEXT, lifesum TEXT, rpsum TEXT, srsum TEXT, tr44sum TEXT, PRIMARY KEY (plancode, pan) );`; connection.executeSql(sql, []).then( (result) => { //console.log("Create table tb_packagecoverage2 successfully."); resolve(result); } , (error) => { console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Create table tb_packagecoverage2 error." + JSON.stringify(error)); console.log(error); reject(error); } ) } , (error) => { console.log(error); reject(error); } ).catch((error) => { console.log(error); reject(error); }) }
(res) => { let responseM: ResponseModel = new ResponseModel(); let sql: string = "SELECT COUNT(*) as total FROM " + TB_SQLITE.tb_plantypedetail; //console.log(sql); this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, []).then( (result) => { // console.log("===== Select count success size " + result.rows.length); responseM.size = result.rows.item(0).total; responseM.status = 0; resolve(responseM); } , (error) => { console.log("==> Select count tb_plantypedetail error " + JSON.stringify(error)); reject(error); } ) } , (error) => { console.log(error); reject(error); } ) },
() => { this.db.create(ConectionDBName.connectionDB) .then( (connection: SQLiteObject) => { let sql: string = `CREATE TABLE IF NOT EXISTS ` + TB_SQLITE.tb_subdistrict + `( id TEXT, name TEXT, amphur TEXT, PRIMARY KEY (id) );`; //console.log(sql); connection.executeSql(sql, []).then( (result) => { // console.log("==> Create table " + TB_SQLITE.tb_subdistrict + " successfully."); resolve(result); } , (error) => { console.log("==> Create table " + TB_SQLITE.tb_subdistrict + " error." + JSON.stringify(error)); reject(error); } ) } , (error) => { console.log(error); reject(error); } ).catch((error) => { console.log(error); reject(error); }) }
() => { this.db.create(ConectionDBName.connectionDB) .then( (connection: SQLiteObject) => { let sql: string = `CREATE TABLE IF NOT EXISTS ` + TB_SQLITE.tb_taxsumcondition + `( plancode TEXT, sex TEXT, minage INTEGER, maxage INTEGER, minsum REAL, maxsum REAL, age INTEGER, sum INTEGER, PRIMARY KEY (plancode, sex, minage, maxage, minsum, maxsum) );`; connection.executeSql(sql, []).then( (result) => { //console.log("Create table " + TB_SQLITE.tb_taxsumcondition + " successfully."); resolve(result); } , (error) => { console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Create table tb_taxsumcondition error." + JSON.stringify(error)); console.log(error); reject(error); } ) } , (error) => { console.log(error); reject(error); } ).catch((error) => { console.log(error); reject(error); }) }
(res) => { try { let sql = "UPDATE " + TB_SQLITE.tb_quotation; sql += " SET "; sql += "lastsync='" + DateUtil.date2str(new Date()) + "'"; //console.log(sql); this.db.create(ConectionDBName.connectionDB).then( (connection: SQLiteObject) => { connection.executeSql(sql, []).then( (result) => { //console.log("===== Update LastSync tb_quatation success."); resolve(res); } , (error) => { console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Update LastSync tb_quatation error. " + error); reject(error); } ) } , (error) => { console.log(error); reject(error); } ) } catch (error) { console.log(error); reject(error); } },