work.uts 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661
  1. // #ifdef APP-ANDROID
  2. import { selectTableData, insertTableData, updateTableData, selectJoinTableData, selectRecordData, selectRecordInfo, selectLatestInfoData, deleteTableData, selectTaskInfo, selectLatestTaskData, selectTaskId, selectTaskDetail, selectTableDataByOrder } from '@/utils/sqlite'
  3. // #endif
  4. export type Download = {
  5. pdid : number,
  6. workorder : string,
  7. invname : string,
  8. productno : string,
  9. graphid : string,
  10. cardno : string,
  11. processno : string,
  12. ver : string,
  13. updatetime : string,
  14. progress : string,
  15. status : number
  16. }
  17. export type Record = {
  18. sxid : number,
  19. senum : number,
  20. photoitem : string,
  21. productno : string,
  22. part : string,
  23. descb : string,
  24. date : string,
  25. partno : string,
  26. num : number,
  27. status : number,
  28. urlspl : string[],
  29. imgname : string[],
  30. urlpdt : string[]
  31. }
  32. export type TaskProcess = {
  33. id : number
  34. name : string
  35. num : number
  36. step : number
  37. status : number
  38. }
  39. export type JoinRecord = {
  40. sxid : number,
  41. senum : number,
  42. photoitem : string,
  43. productno : string,
  44. part : string,
  45. descb : string,
  46. date : string,
  47. partno : string,
  48. num : number,
  49. status : number,
  50. urlspl : string
  51. imgname : string,
  52. urlpdt : string,
  53. pid : number,
  54. workorder : string,
  55. invname : string
  56. }
  57. export type RecordCalculate = {
  58. photoitem : string,
  59. pid : number,
  60. step : number,
  61. total : number,
  62. status : number
  63. }
  64. //检验任务
  65. export type TaskInfo = {
  66. gxid : string,
  67. itemTitle : string,
  68. photoitemStep : number,
  69. photoitemTotal : number,
  70. photoitemStatus : string,
  71. recordStep : number,
  72. recordTotal : number,
  73. recordStatus : string,
  74. keypointStep : number,
  75. keypointTotal : number
  76. keypointStatus : string
  77. }
  78. export type TaskDownload = {
  79. pdid : number,
  80. gxpk : string,
  81. cardno : string,
  82. productcode : string,
  83. model : string,
  84. workorder : string,
  85. invname : string,
  86. graphid : string,
  87. processno : string,
  88. gxno : string,
  89. ver : string,
  90. lastupdatetime ?: string,
  91. updateuser ?: string,
  92. progress ?: string,
  93. uploadflag : number
  94. }
  95. export type TaskDetail = {
  96. pdid: string,
  97. gxno: string,
  98. photoTotal: number,
  99. photoCount: number,
  100. photoStatus: string,
  101. keyTotal: number,
  102. keyCount: number,
  103. keyStatus: string,
  104. recordTotal: number,
  105. recordCount: number,
  106. recordStatus: string,
  107. }
  108. export type TaskPhoto = {
  109. sxid : number,
  110. pdid : number,
  111. senum: number,
  112. photographpoint : string,
  113. photographdescription : string,
  114. photourl : string,
  115. photourlSpl : string[],
  116. imgname : string[],
  117. exampleurl : string,
  118. exampleurlSpl : string[],
  119. photoname : string,
  120. fk_qcRecord : string,
  121. fk_prodcode : string,
  122. prodno : string,
  123. processStep ?: string,
  124. }
  125. export type TaskJoinRecord = {
  126. sxid : number,
  127. pdid : number,
  128. photographpoint : string,
  129. photographdescription : string,
  130. photourl ?: string,
  131. photourlSpl ?: string[],
  132. imgname : string,
  133. exampleurl ?: string,
  134. exampleurlSpl ?: string[],
  135. photoname ?: string,
  136. fk_qcRecord ?: string,
  137. fk_prodcode ?: string,
  138. prodno ?: string,
  139. processStep ?: string,
  140. workorder : string,
  141. invname : string,
  142. }
  143. export type QcRecord = {
  144. sxid: number,
  145. pdid: number,
  146. pk: string,
  147. fk_invcode: string,
  148. no: string,
  149. invcode: string,
  150. invname: string,
  151. processStep: string,
  152. fk_processTask: string,
  153. checkTarget: string,
  154. checknum: number,
  155. oknum: number,
  156. ngnum: number,
  157. status: string,
  158. result: string,
  159. checkTime: string,
  160. fk_creator: string,
  161. cs: string,
  162. ts: string,
  163. psxid: number,
  164. fk_qcRecord: string,
  165. fk_prodcode: string,
  166. prodno: string,
  167. name: string,
  168. nature: string,
  169. unit: string,
  170. maxNum: string,
  171. minNum: string,
  172. memo: string,
  173. measuredvalue: string,
  174. measuredvaluemax: string
  175. }
  176. export type TaskKeyProcess = {
  177. sxid: number,
  178. pdid: number,
  179. senum : number,
  180. parameterorder: number,
  181. parametername: string,
  182. prodno: string,
  183. testapparatus?: string,
  184. testrequirelower?: string,
  185. testrequireupper?: string,
  186. memo?: string,
  187. measuredvaluemin?: string,
  188. measuredvaluemax?: string,
  189. result?: string,
  190. }
  191. export function offlineData(data : UTSJSONObject) : Promise<UTSJSONObject> {
  192. return new Promise((resolve, reject) => {
  193. let result = JSON.parseObject(JSON.stringify(data)) as UTSJSONObject
  194. resolve(result)
  195. });
  196. }
  197. export const statusDict = { '1': '未执行', '2': '执行中', '3': '已执行', '4': '执行错误', '5': '已取消' }
  198. export const recordStatusDict = { '1': '未拍照', '2': '拍照中', '3': '拍照完成', '4': '检验不清晰', '5': '拍照取消' }
  199. export const taskType = { '1': '检测任务', '2': '关键工序任务' }
  200. export const funcType = { '1': '新增', '2': '更新', '3': '删除' }
  201. //export const moduleType = {'1': '声像记录', '2':'检验任务', '3':'关键工序','4': '系统管理','5':'其它'}
  202. export async function getList(tableName : string, condition ?: string | null, value ?: string | null, condition2 ?: string | null, value2 ?: string | null, initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  203. // #ifdef APP-ANDROID
  204. const result = await selectTableData(tableName, condition, value, condition2, value2);
  205. console.log(result);
  206. return result;
  207. // #endif
  208. // #ifdef H5
  209. return offlineData(initData)
  210. // #endif
  211. }
  212. export async function getJoinList(dbTable : string, joinTable : string, labels : string, joinCondition : string, lname ?: string, lvalue ?: string, others ?: string) : Promise<UTSJSONObject> {
  213. // #ifdef APP-ANDROID
  214. const result = await selectJoinTableData(dbTable, joinTable, labels, joinCondition, lname, lvalue, others);
  215. console.log(result);
  216. return result;
  217. // #endif
  218. }
  219. export async function updateData(tableName : string, data : string, lname ?: string, lvalue ?: string) : Promise<UTSJSONObject> {
  220. // #ifdef APP-ANDROID
  221. const result = await updateTableData(tableName, data, lname, lvalue);
  222. console.log(result);
  223. addLog({ module: tableName, dataid: lvalue, content: '更新数据', status: result?.['errMsg'] === 'ok' ? 1 : 0, params: data })
  224. return result;
  225. // #endif
  226. }
  227. export async function getRecordCalculate(tableName : string, value ?: string | null, initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  228. // #ifdef APP-ANDROID
  229. const result = await selectRecordData(tableName, value);
  230. console.log(result);
  231. return result;
  232. // #endif
  233. // #ifdef H5
  234. return offlineData(initData)
  235. // #endif
  236. }
  237. export async function getRecordInfoList(initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  238. // #ifdef APP-ANDROID
  239. const result = await selectRecordInfo();
  240. console.log(result);
  241. return result;
  242. // #endif
  243. // #ifdef H5
  244. return offlineData(initData)
  245. // #endif
  246. }
  247. /**
  248. * 保存媒体信息数据到数据库
  249. * @param data MediaInfoData类型的数据
  250. * @returns Promise<UTSJSONObject> 保存结果
  251. */
  252. export async function saveMediaInfo(data ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  253. // #ifdef APP-ANDROID
  254. // 表名
  255. const tableName = 'app_media_info';
  256. // 构造插入的数据字符串,注意数据库字段名和类型
  257. const values = `'${data?.getString('workorder') ?? ''}','${data?.getString('invname') ?? ''}','${data?.getString('productcode') ?? ''}','${data?.getString('cardno') ?? ''}','${data?.getString('model') ?? ''}','${data?.getString('graphid') ?? ''}','${data?.getString('ver') ?? ''}','${data?.getString('phase') ?? ''}','${data?.getString('processno') ?? ''}','${data?.getString('progress') ?? ''}',${data?.getNumber('status') ?? 1},'${data?.getString('createtime') ?? ''}',${data?.getNumber('createuser') ?? 0},'${data?.getString('updatetime') ?? ''}',${data?.getNumber('updateuser') ?? 0}, 0`;
  258. // 构造字段名字符串
  259. const fields = 'workorder,invname,productno,cardno,model,graphid,ver,phase,processno,progress,status,createtime,createuser,updatetime,updateuser,uploadflag';
  260. try {
  261. // 调用sqlite的插入方法
  262. const result = await insertTableData(tableName, values, fields);
  263. console.log('保存app_media_info成功:', result);
  264. addLog({ module: tableName, dataid: 0, content: '保存媒体信息', status: 1, params: values })
  265. return result;
  266. } catch (error) {
  267. console.error('保存app_media_info失败:', error);
  268. addLog({ module: tableName, dataid: 0, content: '保存媒体信息失败', status: 0, params: values })
  269. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  270. }
  271. // #endif
  272. // #ifdef H5
  273. return offlineData({ success: true, data: [] } as UTSJSONObject);
  274. // #endif
  275. }
  276. /**
  277. * 保存媒体信息数据到数据库
  278. * @param data saveMediaRecord类型的数据
  279. * @returns Promise<UTSJSONObject> 保存结果
  280. */
  281. export async function saveMediaRecord(values : string) : Promise<UTSJSONObject> {
  282. // #ifdef APP-ANDROID
  283. // 表名
  284. const tableName = 'app_media_record';
  285. // 构造字段名字符串
  286. const fields = 'senum,photoitem,productno,part,partno,pk,exampleid,descb,num,status,date,urlspl,imgname,urlpdt,createtime,createuser,updatetime,updateuser,pid';
  287. try {
  288. // 调用sqlite的插入方法
  289. const result = await insertTableData(tableName, values, fields);
  290. console.log('保存app_media_record成功:', result);
  291. addLog({ module: tableName, dataid: 0, content: '保存媒体记录', status: 1, params: values })
  292. return result;
  293. } catch (error) {
  294. console.error('保存app_media_record失败:', error);
  295. addLog({ module: tableName, dataid: 0, content: '保存媒体记录失败', status: 0, params: values })
  296. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  297. }
  298. // #endif
  299. // #ifdef H5
  300. return offlineData({ success: true, data: [] } as UTSJSONObject);
  301. // #endif
  302. }
  303. export async function getLatestRecord(productNo : string, initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  304. // #ifdef APP-ANDROID
  305. const result = await selectLatestInfoData(productNo);
  306. console.log(result);
  307. return result;
  308. // #endif
  309. // #ifdef H5
  310. return offlineData({ success: true, data: [] } as UTSJSONObject)
  311. // #endif
  312. }
  313. export async function removeTableData(tableName : string, field : string, value : string) : Promise<UTSJSONObject> {
  314. // #ifdef APP-ANDROID
  315. try {
  316. // 调用sqlite的删除方法
  317. const result = await deleteTableData(tableName, field, value);
  318. console.log('删除数据成功:', result);
  319. addLog({ module: tableName, dataid: 1, content: '删除数据成功', status: 1, params: value })
  320. return result;
  321. } catch (error) {
  322. console.error('删除数据失败:', error);
  323. addLog({ module: tableName, dataid: 1, content: '删除数据失败', status: 0, params: value })
  324. return { errMsg: '删除失败', data: [] as any[] } as UTSJSONObject;
  325. }
  326. // #endif
  327. // #ifdef H5
  328. return offlineData({ success: true, data: [] } as UTSJSONObject);
  329. // #endif
  330. }
  331. export async function removeInfoAndRecord(value : string) : Promise<UTSJSONObject> {
  332. // #ifdef APP-ANDROID
  333. try {
  334. // 调用sqlite的删除方法
  335. const result = await deleteTableData('app_media_record', 'pid', value);
  336. addLog({ module: 'app_media_record', dataid: 1, content: '删除数据成功', status: 1, params: value, updatetime: "strftime('%Y-%m-%d %H:%M:%S', 'now')" })
  337. const result2 = await deleteTableData('app_media_info', 'pdid', value);
  338. addLog({ module: 'app_media_info', dataid: 1, content: '删除数据成功', status: 1, params: value })
  339. return result;
  340. } catch (error) {
  341. console.error('删除数据失败:', error);
  342. addLog({ module: 'app_media_record', dataid: 1, content: '删除数据失败', status: 0, params: value })
  343. return { errMsg: '删除失败', data: [] as any[] } as UTSJSONObject;
  344. }
  345. // #endif
  346. // #ifdef H5
  347. return offlineData({ success: true, data: [] } as UTSJSONObject);
  348. // #endif
  349. }
  350. export async function addLog(data ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  351. const tableName = 'app_log';
  352. // #ifdef APP-ANDROID
  353. const params = data?.getString('params')?.replace(/['"]/g, '')
  354. const dataid = data?.getNumber('dataid') ?? 0
  355. let fields = 'module,dataid,content,status,params';
  356. let values = `'${data?.getString('module') ?? ''}',${data?.getNumber('dataid') ?? 0},'${data?.getString('content') ?? ''}',${data?.getNumber('status') ?? 0},'${params}'`;
  357. if (dataid === 0) {
  358. fields = fields + ",createuser,createtime"
  359. values = values + `,'${data?.getString('createuser') ?? 0}',strftime('%Y-%m-%d %H:%M:%S', 'now')`
  360. } else {
  361. fields = fields + ",updateuser,updatetime"
  362. values = values + `,'${data?.getString('updateuser') ?? 0}',strftime('%Y-%m-%d %H:%M:%S', 'now')`
  363. }
  364. const result = await insertTableData(tableName, values, fields);
  365. console.log(result);
  366. return result;
  367. // #endif
  368. // #ifdef H5
  369. return offlineData({ success: true, data: [] } as UTSJSONObject);
  370. // #endif
  371. }
  372. export async function saveTaskInfo(data ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  373. // #ifdef APP-ANDROID
  374. // 表名
  375. const tableName = 'app_task_info';
  376. // 构造插入的数据字符串,注意数据库字段名和类型
  377. const values = `'${data?.getString('gxpk') ?? ''}','${data?.getString('pk_serial') ?? ''}','${data?.getString('cardno') ?? ''}','${data?.getString('productcode') ?? ''}','${data?.getString('model') ?? ''}','${data?.getString('workorder') ?? ''}','${data?.getString('invname') ?? ''}','${data?.getString('graphid') ?? ''}','${data?.getString('processno') ?? ''}','${data?.getString('gxno') ?? ''}', '${data?.getString('ver') ?? ''}','${data?.getString('lastupdatetime') ?? ''}','${data?.getString('updateuser') ?? ''}', 0`;
  378. // 构造字段名字符串
  379. const fields = 'gxpk,pk_serial,cardno,productcode,model,workorder,invname,graphid,processno,gxno,ver,lastupdatetime,updateuser,uploadflag';
  380. try {
  381. // 调用sqlite的插入方法
  382. const result = await insertTableData(tableName, values, fields);
  383. console.log('保存app_task_info成功:', result);
  384. addLog({ module: tableName, dataid: 0, content: '保存检验任务信息成功', status: 1, params: values })
  385. return result;
  386. } catch (error) {
  387. console.error('保存app_task_info失败:', error);
  388. addLog({ module: tableName, dataid: 0, content: '保存检验任务信息失败', status: 0, params: values })
  389. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  390. }
  391. // #endif
  392. // #ifdef H5
  393. return offlineData({ success: true, data: [] } as UTSJSONObject);
  394. // #endif
  395. }
  396. /**
  397. * 保存检验任务信息里的图片数据到数据库
  398. * @param data saveTaskPhoto类型的数据
  399. * @returns Promise<UTSJSONObject> 保存结果
  400. */
  401. export async function saveTaskPhoto(values : string) : Promise<UTSJSONObject> {
  402. // #ifdef APP-ANDROID
  403. // 表名
  404. const tableName = 'app_task_photo';
  405. // 构造字段名字符串
  406. const fields = 'pdid,pk,photographpoint,photographdescription,photourl,exampleurl,photoname,fk_qcRecord,fk_prodcode,prodno,fk_creator,fks_operator,operator,processStep,fk_processTask,cs,ts';
  407. try {
  408. // 调用sqlite的插入方法
  409. const result = await insertTableData(tableName, values, fields);
  410. console.log('保存app_task_photo成功:', result);
  411. addLog({ module: tableName, dataid: 0, content: '保存任务图像记录', status: 1, params: values })
  412. return result;
  413. } catch (error) {
  414. console.error('保存app_task_photo失败:', error);
  415. addLog({ module: tableName, dataid: 0, content: '保存任务图像记录失败', status: 0, params: values })
  416. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  417. }
  418. // #endif
  419. // #ifdef H5
  420. return offlineData({ success: true, data: [] } as UTSJSONObject);
  421. // #endif
  422. }
  423. export async function getTaskInfoList(initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  424. // #ifdef APP-ANDROID
  425. const result = await selectTaskInfo();
  426. console.log(result);
  427. return result;
  428. // #endif
  429. // #ifdef H5
  430. return offlineData(initData)
  431. // #endif
  432. }
  433. export async function saveTaskKeyProcess(data ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  434. // #ifdef APP-ANDROID
  435. // 表名
  436. const tableName = 'app_task_keyprocess';
  437. // 构造插入的数据字符串,注意数据库字段名和类型
  438. const values = `'${data?.getNumber('pdid') ?? 0}','${data?.getString('pk') ?? ''}','${data?.getString('testapparatus') ?? ''}','${data?.getString('tableid') ?? ''}','${data?.getString('testrequirelower') ?? ''}','${data?.getString('testrequireupper') ?? ''}','${data?.getString('parametername') ?? ''}','${data?.getString('parameterorder') ?? ''}','${data?.getString('measureunit') ?? ''}','${data?.getString('parameterinstruction') ?? ''}', '${data?.getString('parameterid') ?? ''}','${data?.getString('fk_creator') ?? ''}','${data?.getString('fk_prodcode') ?? ''}','${data?.getString('prodno') ?? ''}','${data?.getString('processstep') ?? ''}','${data?.getString('fk_processtask') ?? ''}','${data?.getString('measuredvaluemin') ?? ''}','${data?.getString('measuredvaluemax') ?? ''}','${data?.getString('result') ?? ''}','${data?.getString('memo') ?? ''}','${data?.getString('fks_operator') ?? ''}','${data?.getString('cs') ?? ''}','${data?.getString('ts') ?? ''}'`;
  439. // 构造字段名字符串
  440. const fields = 'pdid,pk,testapparatus,tableid,testrequirelower,testrequireupper,parametername,parameterorder,measureunit,parameterinstruction,parameterid,fk_creator,fk_prodcode,prodno,processstep,fk_processtask,measuredvaluemin,measuredvaluemax,result,memo,fks_operator,cs,ts';
  441. try {
  442. // 调用sqlite的插入方法
  443. const result = await insertTableData(tableName, values, fields);
  444. console.log('保存app_task_info成功:', result);
  445. addLog({ module: tableName, dataid: 0, content: '保存检验任务信息成功', status: 1, params: values })
  446. return result;
  447. } catch (error) {
  448. console.error('保存app_task_info失败:', error);
  449. addLog({ module: tableName, dataid: 0, content: '保存检验任务信息失败', status: 0, params: values })
  450. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  451. }
  452. // #endif
  453. // #ifdef H5
  454. return offlineData({ success: true, data: [] } as UTSJSONObject);
  455. // #endif
  456. }
  457. export async function saveTaskRecord(data ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  458. // #ifdef APP-ANDROID
  459. // 表名
  460. const tableName = 'app_task_record';
  461. // 构造插入的数据字符串,注意数据库字段名和类型
  462. const values = `'${data?.getNumber('pdid') ?? 0}','${data?.getString('pk') ?? ''}','${data?.getString('fk_invcode') ?? ''}','${data?.getString('no') ?? ''}','${data?.getString('invcode') ?? ''}','${data?.getString('invname') ?? ''}','${data?.getString('processStep') ?? ''}','${data?.getString('fk_processTask') ?? ''}','${data?.getString('checkTarget') ?? ''}',${data?.getNumber('checknum') ?? 0}, ${data?.getNumber('oknum') ?? 0},${data?.getNumber('ngnum') ?? 0},'${data?.getString('status') ?? ''}','${data?.getString('result') ?? ''}','${data?.getString('checkTime') ?? ''}','${data?.getString('fk_creator') ?? ''}','${data?.getString('cs') ?? ''}','${data?.getString('ts') ?? ''}'`;
  463. // 构造字段名字符串
  464. const fields = 'pdid,pk,fk_invcode,no,invcode,invname,processStep,fk_processTask,checkTarget,checknum,oknum,ngnum,status,result,checkTime,fk_creator,cs,ts';
  465. try {
  466. // 调用sqlite的插入方法
  467. const result = await insertTableData(tableName, values, fields);
  468. console.log('保存app_task_record成功:', result);
  469. addLog({ module: tableName, dataid: 0, content: '保存检验任务记录信息成功', status: 1, params: values })
  470. return result;
  471. } catch (error) {
  472. console.error('保存app_task_record失败:', error);
  473. addLog({ module: tableName, dataid: 0, content: '保存检验任务记录信息失败', status: 0, params: values })
  474. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  475. }
  476. // #endif
  477. // #ifdef H5
  478. return offlineData({ success: true, data: [] } as UTSJSONObject);
  479. // #endif
  480. }
  481. export async function saveTaskRecordItem(data ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  482. // #ifdef APP-ANDROID
  483. // 表名
  484. const tableName = 'app_task_record_item';
  485. // 构造插入的数据字符串,注意数据库字段名和类型
  486. const values = `'${data?.getNumber('psxid') ?? 0}','${data?.getString('pk') ?? ''}','${data?.getString('fk_qcRecord') ?? ''}','${data?.getString('fk_prodcode') ?? ''}','${data?.getString('prodno') ?? ''}','${data?.getString('name') ?? ''}','${data?.getString('no') ?? ''}','${data?.getString('nature') ?? ''}','${data?.getString('unit') ?? ''}',${data?.getNumber('maxNum') ?? 0}, ${data?.getNumber('maxNum') ?? 0},'${data?.getString('status') ?? ''}','${data?.getString('memo') ?? ''}','${data?.getString('measuredvalue') ?? ''}','${data?.getString('measuredvaluemax') ?? ''}','${data?.getString('result') ?? ''}','${data?.getString('cs') ?? ''}','${data?.getString('ts') ?? ''}'`;
  487. // 构造字段名字符串
  488. const fields = 'psxid,pk,fk_qcRecord,fk_prodcode,prodno,prodno,no,nature,unit,maxNum,minNum,status,memo,measuredvalue,measuredvaluemax,result,cs,ts';
  489. try {
  490. // 调用sqlite的插入方法
  491. const result = await insertTableData(tableName, values, fields);
  492. console.log('保存app_task_record_item成功:', result);
  493. addLog({ module: tableName, dataid: 0, content: '保存检验任务项目信息成功', status: 1, params: values })
  494. return result;
  495. } catch (error) {
  496. console.error('保存app_task_record_item失败:', error);
  497. addLog({ module: tableName, dataid: 0, content: '保存检验任务项目信息失败', status: 0, params: values })
  498. return { errMsg: '保存失败', data: [] as any[] } as UTSJSONObject;
  499. }
  500. // #endif
  501. // #ifdef H5
  502. return offlineData({ success: true, data: [] } as UTSJSONObject);
  503. // #endif
  504. }
  505. export async function getLatestTask(gxpk : string, initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  506. // #ifdef APP-ANDROID
  507. const result = await selectLatestTaskData(gxpk);
  508. console.log(result);
  509. return result;
  510. // #endif
  511. // #ifdef H5
  512. return offlineData({ success: true, data: [] } as UTSJSONObject)
  513. // #endif
  514. }
  515. export async function removeTaskAndRecord(value : string) : Promise<UTSJSONObject> {
  516. // #ifdef APP-ANDROID
  517. try {
  518. // 调用sqlite的删除方法
  519. const taskId = await selectTaskId('app_task_info', 'pdid', 'gxpk', value);
  520. const result = await deleteTableData('app_task_info', 'pdid', taskId);
  521. addLog({ module: 'app_task_info', dataid: 1, content: '删除数据成功', status: 1, params: value, updatetime: "strftime('%Y-%m-%d %H:%M:%S', 'now')" })
  522. const result2 = await deleteTableData('app_task_photo', 'pdid', taskId);
  523. addLog({ module: 'app_task_photo', dataid: 1, content: '删除数据成功', status: 1, params: value })
  524. const recordId = await selectTaskId('app_task_record', 'sxid', 'pdid', taskId);
  525. const result3 = await deleteTableData('app_task_record_item', 'psxid', recordId);
  526. addLog({ module: 'app_task_record_item', dataid: 1, content: '删除数据成功', status: 1, params: value })
  527. const result4 = await deleteTableData('app_task_record', 'sxid', recordId);
  528. addLog({ module: 'app_task_record', dataid: 1, content: '删除数据成功', status: 1, params: value })
  529. return {};
  530. } catch (error) {
  531. console.error('删除数据失败:', error);
  532. addLog({ module: 'app_media_record', dataid: 1, content: '删除数据失败', status: 0, params: value })
  533. return { errMsg: '删除失败', data: [] as any[] } as UTSJSONObject;
  534. }
  535. // #endif
  536. // #ifdef H5
  537. return offlineData({ success: true, data: [] } as UTSJSONObject);
  538. // #endif
  539. }
  540. export async function getTaskDetail(field ?: string | null, value ?: string | null) : Promise<UTSJSONObject> {
  541. // #ifdef APP-ANDROID
  542. const result = await selectTaskDetail(field, value);
  543. console.log(result);
  544. return result;
  545. // #endif
  546. // #ifdef H5
  547. return offlineData({ success: true, data: [] } as UTSJSONObject)
  548. // #endif
  549. }
  550. export async function getListByOrder(tableName : string, condition ?: string | null, value ?: string | null, order ?:string | null, initData ?: UTSJSONObject | null) : Promise<UTSJSONObject> {
  551. // #ifdef APP-ANDROID
  552. const result = await selectTableDataByOrder(tableName, condition, value, null, null, order);
  553. console.log(result);
  554. return result;
  555. // #endif
  556. // #ifdef H5
  557. return offlineData(initData)
  558. // #endif
  559. }