android数据库使用方法

MMesBomOffl:

Android.querySqlite("MMesBomOffl")

Android.deleteSqlite("MMesBomOffl")

Android.insertSqliteList("MMesBomOffl", JSON.stringify([{
parentItmId: "2",
itmId: "2",
itmNm: "2",
itmNmAlias: "2",
bomQty: 1,
bomQtySerial: 1,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

Android.insertSqliteList("MMesBomOffl", JSON.stringify([{
pkId: "2",
parentItmId: "3",
itmId: "3",
itmNm: "4",
itmNmAlias: "2",
bomQty: 1,
bomQtySerial: 1,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

Android.insertSqliteList("MMesBomOffl", JSON.stringify([{
parentItmId: "2",
itmId: "2",
itmNm: "2",
itmNmAlias: "2",
aaa: "222",
bbb: "222",
bomQty: 1,
bomQtySerial: 1,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

MMesItmOffl:

Android.querySqlite("MMesItmOffl")

Android.insertSqliteList("MMesItmOffl", JSON.stringify([{
itmId: "2",
itmNm: "2",
itmNmAlias: "2",
itmGrpId: "1",
leaGrpId: "1",
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

MMesOprOffl:

Android.insertSqliteList("MMesOprOffl", JSON.stringify([{
oprId: "2",
oprNm: "2",
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

MMesShiftOffl:

Android.insertSqliteList("MMesShiftOffl", JSON.stringify([{
shiftId: "2",
shiftNm: "2",
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

MMesWkresOffl:
Android.insertSqliteList("MMesWkresOffl", JSON.stringify([{
wkCtrId: "2",
wkNm: "2",
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

MSysCtnrOffl:

Android.insertSqliteList("MSysCtnrOffl", JSON.stringify([{
ctnrId: "2",
ctnrNm: "2",
itmId: "2",
qtyPerCtnr: 0.00999999,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

MSysRoleFuncOffl:
Android.insertSqliteList("MSysRoleFuncOffl", JSON.stringify([{
roleId: "2",
roleNm: "2",
funcId: "2",
funcNm: "2",
termTp: "2",
urlPath: "2",
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

PMesPrdManhourOffl:
Android.insertSqliteList("PMesPrdManhourOffl", JSON.stringify([{
wkCtrId: "2",
oprId: "2",
shiftId: "2",
prdDt: "2",
startTime: "2",
endTime: "2",
workDu: 2.88,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

PMesPrdorderActualOffl:

Android.insertSqliteList("PMesPrdManhourOffl", JSON.stringify([{
wkCtrId: "2",
oprId: "2",
shiftId: "2",
prdDt: "2",
startTime: "2",
endTime: "2",
workDu: 2.88,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

PMesPrdorderActualOffl:
Android.insertSqliteList("PMesPrdorderActualOffl", JSON.stringify([{
prdOrderId: "2",
wkCtrId: "2",
oprId: "2",
shiftId: "2",
prdDt: "2",
itemId: "2",
prdQty: 2.88,
kanbanId: "21321",
scanNum1: "123213",
scanNum2: "213123",
prdTime: "21321",
reservedSts: "21321",
qualitySts: "21321",
defRsnId: "1233",
defUsrs: "21321",
disMethod: "12321",
ppmv: 21313,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

PMesPrdorderIssuedOffl:
Android.insertSqliteList("PMesPrdorderIssuedOffl", JSON.stringify([{
prdOrderId: "2",
wkCtrId: "2",
oprId: "2",
prdDt: "2",
shiftId: "213",
itemId: "2",
feedQty: 2.88,
kanbanId: "21321",
scanNum1: "123213",
scanNum2: "213123",
feedTime: "21321",
qualitySts: "213",
defRsnId: "1233",
defUsrs: "21321",
disMethod: "12321",
ppmv: 21313,
remark: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))
// ------------------------------------------------------------------------------ 0417
LWmsCusKanbanOffl:

Android.insertSqliteList("LWmsCusKanbanOffl", JSON.stringify([{
cusId: "2",
kanbanQrLen: 2,
kanbanIdStartPos: 2,
kanbanIdEndPos: 2,
delFlag: "2",
createUsrId: "2",
createDt: "2",
updateUsrId: "2",
updateDt: "2"
}]))

LWmsIbdDtlOffl:

Android.insertSqliteList("LWmsIbdDtlOffl", JSON.stringify([{
ibdId: "2",
lnNum: 2,
poId: "2",
poLnNum: 2,
delFlag: "2",
itmId: "2",
itmNm: "2",
itmNmAlias: "2",
whId: "2",
plnIbdQty: 12,
actIbdQty: 12,
passQty: 12,

ngQty: 12,
status: "123",

  createUsrId: "2",
  createDt: "2",
  updateUsrId: "2",
  updateDt: "2"
}]))

LWmsIbdItmOffl:

Android.insertSqliteList("LWmsIbdItmOffl", JSON.stringify([{
ibdId: "2",
lnNum: 2,
palletId: 2,
kanbanId: 2,
invKanbanId: 2,
serialNo: "2",
qty: 2,
status: "2",
qmStatus: "2",
scanType: "2",

  createUsrId: "2",
  createDt: "2",
  updateUsrId: "2",
  updateDt: "2"
}]))

LWmsInvTransOffl:

Android.insertSqliteList("LWmsInvTransOffl", JSON.stringify([{
invTransId: 2,
itmId: "2",
itmNm: "2",
itmNmAlias:"2",
siteId: "2",
whId: "2",
areaId: "2",
locId:"2",
palletId: "2",
ctnrId: "22",
cusKanbanId: "2",
serialNo: "2",

qty: 2,
batchNum: "2",
erpRefId: "2",
lnNum: 22,
pdSts: "2",
refereceId: 121,
sourceTp: 121,
actualDate: "213",
syncRefId: "123",
syncSts: "123",
transTp: "123",
syncTime: "123",
failReason: "1231",

  createUsrId: "2",
  createDt: "2",
  updateUsrId: "2",
  updateDt: "2"
}]))

MSysCusOffl:

Android.insertSqliteList("MSysCusOffl", JSON.stringify([{
cusId: "2",

cusNm: "2",
cusShortNm: "213",
pickLt: 2,
isKanban: "2",
isAutoPack: 2,

  createUsrId: "2",
  createDt: "2",
  updateUsrId: "2",
  updateDt: "2"
}]))