dyDeliver/conf/sqlroot/com/dderp/business/dao/PrintBillDao.dql

-- [selectPrintBill]
select *
from $table$;

-- [selectPrintPart]
select *
from $table$;

-- [selectPrintProcess]
select *
from $table$;

-- [selectPrintBreed]
select *
from $table$;

-- [selectPrintBillStep]
select *
from $table$;

-- [newPrintBill]
insert into $table$ (id, billYear, billCode, productName,
                     billName, clientName, processText,
                     outSourceProcessText, deliveryDate, printTime,
                     voidFlag, billNote, billState, billType,
                     billMoneyPlate, billMoneyPaper, billMoneyPrint,
                     billMoneyProcess, billMoneyTotal, billMoneyAdjust,
                     orderMoneyTotal, containsOrderIds, containsOrderCodes,
                     breedFileUrl, idCompany, autoPDFFlag, idProduct, createManName,
                     orderPrintRequire, orderSendKind, assembleBreedRequire, importantBill, idClientLevel,
                     createBy, createTime,
                     updateBy, updateTime)
values ( #{id}, #{billyear}, #{billcode}, #{productname},
#{billname}, #{clientname}, #{processtext},
#{outsourceprocesstext}, #{deliverydate}, #{printtime},
#{voidflag}, #{billnote}, #{billstate}, #{billtype},
#{billmoneyplate}, #{billmoneypaper}, #{billmoneyprint},
#{billmoneyprocess}, #{billmoneytotal}, #{billmoneyadjust},
#{ordermoneytotal}, #{containsorderids}, #{containsordercodes}, #{breedfileurl},
#{idcompany}, #{autopdfflag}, #{idproduct}, #{createmanname}, #{orderprintrequire}, #{ordersendkind}, #{assemblebreedrequire}, #{importantbill}, #{idclientlevel},
#{createby},
#{createtime},  #{updateby},
#{updatetime} );

-- [newPrintBillPart]
insert into $table$ (id, billYear, idProduct, idPartInfo,
                     idPrintBill, idPrintBreed, idOrder,
                     idOrderPart, idWorkPart, partHeight,
                     partWidth, locationX, locationY,
                     rotationAngle, productName, orderName, orderCode,
                     productPartName, semiFeedbackStatus, semiFeedbackContent,
                     idSemiFeedbackMan, semiFeedbackTime, semiFeedbackTimeLong, cropRect ) values ( #{id}, #{billyear}, #{idproduct}, #{idpartinfo},
                                                                                          #{idprintbill}, #{idprintbreed}, #{idorder},
                                                                                          #{idorderpart}, #{idworkpart}, #{partheight},
                                                                                          #{partwidth}, #{locationx}, #{locationy},
                                                                                          #{rotationangle}, #{productname}, #{ordername}, #{ordercode},
                                                                                          #{productpartname}, #{semifeedbackstatus}, #{semifeedbackcontent},
                                                                                          #{idsemifeedbackman}, #{semifeedbacktime}, #{semifeedbacktimelong}, #{croprect} );

-- [semiFeedback]
update $table$ set semiFeedbackStatus = #{semifeedbackstatus}, semiFeedbackContent = #{semifeedbackcontent},
                   idSemiFeedbackMan = #{idsemifeedbackman}, semiFeedbackTime = #{semifeedbacktime}, semiFeedbackTimeLong = #{semifeedbacktimelong}
where id = #{id};

-- [newPrintBillBreed]
insert into $table$ (id, billYear, idPrintBill, breedName,
                     breedTypeName, selfProvidedPaper, wholePaperSize,
                     paperBand, idPaperBaseInfo, paperName,
                     idPaperCutInfo, cutName, cutCount,
                     cutSize, partCount, breedNo, partPrintTotalQty,
                     breedSets, printCount, printFlowCount,
                     craftFlowCount, wholePaperCount, originWholePaperCount, paperPrice,
                     breedPaperPrice, idActualPaperInfo, actualPaperName,
                     idMachineType, machineTypeName, idMachine,
                     machineName, colorCount, specialColor,
                     breedFlipType, breedSize, psSize,
                     psGroupCount, psCount, completeCount,
                     printCount1000, printCosts, breedProcess,
                     breedStatus, printRequire, preOutStockState,
                     preOutStockLockIdRoom, preOutStockLockQty, preOutLockState,
                     preOutLockManId, preOutLockManName, idPlateSizeTemplate,
                     voidFlag, containsOrderIds, idCompany, preOutStockUnlocked, paperRequireFlag, createBy, createTime,
                     updateBy, updateTime, pickPaperCount, paperPreRequestFlag, paperStockInFlag, paperPickingFlag, paperStockOutFlag) values ( #{id}, #{billyear}, #{idprintbill}, #{breedname},
                                               #{breedtypename}, #{selfprovidedpaper}, #{wholepapersize},
                                               #{paperband}, #{idpaperbaseinfo}, #{papername},
                                               #{idpapercutinfo}, #{cutname}, #{cutcount},
                                               #{cutsize}, #{partcount}, #{breedno}, #{partprinttotalqty},
                                               #{breedsets}, #{printcount}, #{printflowcount},
                                               #{craftflowcount}, #{wholepapercount}, #{originwholepapercount}, #{paperprice},
                                               #{breedpaperprice}, #{idactualpaperinfo}, #{actualpapername},
                                               #{idmachinetype}, #{machinetypename}, #{idmachine},
                                               #{machinename}, #{colorcount}, #{specialcolor},
                                               #{breedfliptype}, #{breedsize}, #{pssize},
                                               #{psgroupcount}, #{pscount}, #{completecount},
                                               #{printcount1000}, #{printcosts}, #{breedprocess},
                                               #{breedstatus}, #{printrequire}, #{preoutstockstate},
                                               #{preoutstocklockidroom}, #{preoutstocklockqty}, #{preoutlockstate},
                                               #{preoutlockmanid}, #{preoutlockmanname}, #{idplatesizetemplate},
                                               #{voidflag}, #{containsorderids}, #{idcompany}, #{preoutstockunlocked}, #{paperrequireflag}, #{createby}, #{createtime},
                                               #{updateby}, #{updatetime}, #{pickpapercount}, #{paperprerequestflag}, #{paperstockinflag}, #{paperpickingflag}, #{paperstockoutflag});

-- [updatePrintBillBreed]
update $table$ set billYear = #{billyear},idPrintBill = #{idprintbill},breedName = #{breedname},breedTypeName = #{breedtypename},
selfProvidedPaper = #{selfprovidedpaper},wholePaperSize = #{wholepapersize},paperBand = #{paperband},idPaperBaseInfo = #{idpaperbaseinfo},
paperName = #{papername},idPaperCutInfo = #{idpapercutinfo},cutName = #{cutname},cutCount = #{cutcount},
cutSize = #{cutsize},partCount = #{partcount},breedNo = #{breedno},breedSets = #{breedsets},
printCount = #{printcount},printFlowCount = #{printflowcount},craftFlowCount = #{craftflowcount},wholePaperCount = #{wholepapercount}, originWholePaperCount = #{originwholepapercount},
paperPrice = #{paperprice},breedPaperPrice = #{breedpaperprice},idActualPaperInfo = #{idactualpaperinfo},actualPaperName = #{actualpapername},
idMachineType = #{idmachinetype},machineTypeName = #{machinetypename},idMachine = #{idmachine},machineName = #{machinename},
colorCount = #{colorcount},specialColor = #{specialcolor},breedFlipType = #{breedfliptype},breedSize = #{breedsize},
psSize = #{pssize},psGroupCount = #{psgroupcount},psCount = #{pscount},completeCount = #{completecount},
printCount1000 = #{printcount1000},printCosts = #{printcosts},breedProcess = #{breedprocess},breedStatus = #{breedstatus},
printRequire = #{printrequire},preOutStockState = #{preoutstockstate},preOutStockLockIdRoom = #{preoutstocklockidroom},preOutStockLockQty = #{preoutstocklockqty},
preOutLockState = #{preoutlockstate},preOutLockManId = #{preoutlockmanid},preOutLockManName = #{preoutlockmanname},idPlateSizeTemplate = #{idplatesizetemplate},
containsOrderIds = #{containsorderids},updateBy = #{updateby},updateTime = #{updatetime}, idCompany = #{idcompany}, preOutStockUnlocked = #{preoutstockunlocked},
paperRequireFlag = #{paperrequireflag}, paperPreRequestFlag = #{paperprerequestflag}, paperStockInFlag = #{paperstockinflag}, paperPickingFlag = #{paperpickingflag},
paperStockOutFlag = #{paperstockoutflag}, partPrintTotalQty = #{partprinttotalqty}
where id = #{id};

-- [newPrintBillProcess]
insert into $table$ (id, billYear, idPrintBill, idPrintBreed,
                     idOrder, idProcess, processName,
                     feedbackStatus, feedbackCount, totalCount,
                     completeTime, completeTimeLong, isOutAssisted,
                     idOutAssistBill, outAssistBillCode, idMaterial,
                     materialName, orderProcessMemo ) values ( #{id}, #{billyear}, #{idprintbill}, #{idprintbreed},
                                                               #{idorder}, #{idprocess}, #{processname},
                                                               #{feedbackstatus}, #{feedbackcount}, #{totalcount},
                                                               #{completetime}, #{completetimelong}, #{isoutassisted},
                                                               #{idoutassistbill}, #{outassistbillcode}, #{idmaterial},
                                                               #{materialname}, #{orderprocessmemo} );

-- [newPrintBillStep]
insert into $table$ ( billYear, idPrintBill, idWorkMan, workMan,
workTime, workTimeLong, workMemo,
workExplain ) values ( #{billyear}, #{idprintbill}, #{idworkman}, #{workman},
#{worktime}, #{worktimelong}, #{workmemo},
#{workexplain} );


-- [newBreedPlateSize]
insert into $table$ (id, idPlateSizeTemplate, idBreed, idPrintBill,
                     billYear, pageBlankTop, pageBlankLeft,
                     pageBlankBottom, pageBlankRight, distanceHoldVertocal,
                     distancePlateVertocal, distanceWidthVertocal, distanceHeightVertocal,
                     distanceHoldHorizontal, distancePlateHorizontal, distanceWidthHorizontal,
                     distanceHeightHorizontal, drawTChiPDF, tchiPDFFile,
                     tchiPDFSize, holdPlace, sidePlace,
                     faceCount, moqieArea, fumoArea,
                     createBy, createTime,
                     updateBy, updateTime ) values ( #{id}, #{idplatesizetemplate}, #{idbreed}, #{idprintbill},
                                                                     #{billyear}, #{pageblanktop}, #{pageblankleft},
                                                                     #{pageblankbottom}, #{pageblankright}, #{distanceholdvertocal},
                                                                     #{distanceplatevertocal}, #{distancewidthvertocal}, #{distanceheightvertocal},
                                                                     #{distanceholdhorizontal}, #{distanceplatehorizontal}, #{distancewidthhorizontal},
                                                                     #{distanceheighthorizontal}, #{drawtchipdf}, #{tchipdffile},
                                                                     #{tchipdfsize}, #{holdplace}, #{sideplace},
                                                                     #{facecount}, #{moqiearea}, #{fumoarea},
                                                                     #{createby}, #{createtime},
                                                                     #{updateby}, #{updatetime} );

-- [workPartBuild]
update $table$ set workPartState = #{workpartstate},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [addOrderStep]
insert into $table$ (id, idOrder, idWorkMan, workMan,
workTime, workMemo,
workExplain, orderYear ) values ( #{id}, #{idorder}, #{idworkman}, #{workman},
#{worktime}, #{workmemo},
#{workexplain}, #{orderyear} );

-- [updatePrintBillState]
update $table$ set billState = #{billstate},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [updatePrintBreedState]
update $table$ set breedStatus = #{breedstatus},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};


-- [voidPrintBill]
update $table$ set voidFlag = #{voidflag},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [voidPrintBillBreed]
update $table$ set voidFlag = #{voidflag},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [updatePrintBill]
update $table$ set processText = #{processtext},outSourceProcessText = #{outsourceprocesstext},deliveryDate = #{deliverydate},
billNote = #{billnote},billState = #{billstate},idCompany = #{idcompany}, orderPrintRequire = #{orderprintrequire}, orderSendKind = #{ordersendkind},
billMoneyPlate = #{billmoneyplate}, billMoneyPaper = #{billmoneypaper}, billMoneyPrint = #{billmoneyprint}, billMoneyTotal = #{billmoneytotal}, idClientLevel = #{idclientlevel},
updateBy = #{updateby},updateTime = #{updatetime}
 where id = #{id};

-- [deletePrintBreed]
delete from $table$ where idPrintBill = #{id};

-- [deletePrintBreedPart]
delete from  $table$  where idPrintBill = #{id};

-- [deletePrintBreedProcess]
delete from $table$  where idPrintBill = #{id};


-- [schedulePrintBreed]
update $table$ set idMachine = #{idmachine}, machineName = #{machinename}, breedStatus = #{breedstatus},
    updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [selectMachineBreedTasks]
select * from $table$;

-- [newMachineBreedTask]
insert into $table$ (id, billYear, idMachineInfo, idProcess, idPrintBreed, idPrintBill, expectedWorkTime,
beginAt,  completeAt, scheduleStatus, pauseStatus,
 taskStatus, sortIndex,
lastOperateManId, lastOperateManName,taskMemo, voidFlag, assembleBreedId, madeBreedId, cutPaperId, printId, createBy, createTime,
updateBy, updateTime ) values ( #{id}, #{billyear}, #{idmachineinfo}, #{idprocess}, #{idprintbreed}, #{idprintbill},
#{expectedworktime}, #{beginat},
#{completeat}, #{schedulestatus}, #{pausestatus}, #{taskstatus},
#{sortindex}, #{lastoperatemanid}, #{lastoperatemanname}, #{taskmemo}, #{voidflag}, #{assemblebreedid}, #{madebreedid}, #{cutpaperid}, #{printid}, #{createby},
#{createtime},  #{updateby},
#{updatetime} );

-- [newOrderProcessTask]
insert into $table$ (id, billYear, idOrder, idPrintBill,
                     idBreed, idProcess, processName,
                     orderSize, idWorkTeam, workTeamName,
                     scheduleStatus, pauseStatus, taskStatus,
                     sortIndex, beginAt, beginAtLong,
                     completeAt, completeAtLong, idFeedbackMan,
                     feedbackTime, feedbackTimeLong, taskMemo,
                     voidFlag, createBy, createTime,
                     createTimeLong, updateBy, updateTime,
                     updateTimeLong ) values ( #{id}, #{billyear}, #{idorder}, #{idprintbill},
                                               #{idbreed}, #{idprocess}, #{processname},
                                               #{ordersize}, #{idworkteam}, #{workteamname},
                                               #{schedulestatus}, #{pausestatus}, #{taskstatus},
                                               #{sortindex}, #{beginat}, #{beginatlong},
                                               #{completeat}, #{completeatlong}, #{idfeedbackman},
                                               #{feedbacktime}, #{feedbacktimelong}, #{taskmemo},
                                               #{voidflag}, #{createby}, #{createtime},
                                               #{createtimelong}, #{updateby}, #{updatetime},
                                               #{updatetimelong} );

-- [scheduleMachineBreedTask]
update $table$ set idMachineInfo = #{idmachineinfo}, expectedWorkTime = #{expectedworktime}, scheduleStatus = #{schedulestatus}, taskStatus = #{taskstatus}, sortIndex = #{sortindex},
    lastOperateManId = #{lastoperatemanid}, lastOperateManName = #{lastoperatemanname}, updateBy = #{updateby},updateTime = #{updatetime}
     where id = #{id};

-- [voidMachineTask]
update $table$ set voidFlag = #{voidflag},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [voidOrderProcessTask]
update $table$ set voidFlag = #{voidflag},
updateBy = #{updateby},updateTime = #{updatetime} where id = #{id};

-- [deleteMachineTask]
delete from $table$ where idPrintBreed = #{id};

-- [scheduleBreedTasksBack]
update $table$ set idMachineInfo = #{idmachineinfo}, expectedWorkTime = #{expectedworktime}, scheduleStatus = #{schedulestatus}, taskStatus = #{taskstatus}, sortIndex = #{sortindex},
    lastOperateManId = #{lastoperatemanid}, lastOperateManName = #{lastoperatemanname}, beginAt = #{beginat}, updateBy = #{updateby},updateTime = #{updatetime}
     where id = #{id};

-- [feedbackBreedTask]
update $table$ set taskStatus = #{taskstatus}, beginAt = #{beginat}, completeAt = #{completeat}, taskMemo = #{taskmemo}, sortIndex = #{sortindex},
lastOperateManId = #{lastoperatemanid}, lastOperateManName = #{lastoperatemanname}, updateBy = #{updateby},updateTime = #{updatetime}
     where id = #{id};


-- [feedbackOrderTask]
update $table$ set taskStatus = #{taskstatus}, feedbackTime = #{feedbacktime}, taskMemo = #{taskmemo},
idFeedbackMan = #{idfeedbackman},  updateBy = #{updateby},updateTime = #{updatetime}
where id = #{id};

-- [selectOrderProcessTasks]
select * from $table$;


-- [pauseBreedTask]
update $table$ set pauseStatus = #{pausestatus}, taskMemo = #{taskmemo},
lastOperateManId = #{lastoperatemanid}, lastOperateManName = #{lastoperatemanname}, updateBy = #{updateby},updateTime = #{updatetime}
where id = #{id};

-- [pauseOrderTask]
update $table$ set pauseStatus = #{pausestatus}, taskMemo = #{taskmemo},
 updateBy = #{updateby},updateTime = #{updatetime}
where id = #{id};


-- [addFeedbackRecord]
insert into $table$ (id, billYear, idTask, recordType,
                     idProcess, processName, idReference,
                     feedbackCount, feedbackBegin, feedbackComplete,
                     feedbackManId, feedbackMan, feedbackTime,
                     feedbackTimeLong, feedbackMemo, createBy,
                     createTime, updateBy,
                     updateTime ) values ( #{id}, #{billyear}, #{idtask}, #{recordtype},
                                                           #{idprocess}, #{processname}, #{idreference},
                                                           #{feedbackcount}, #{feedbackbegin}, #{feedbackcomplete},
                                                           #{feedbackmanid}, #{feedbackman}, #{feedbacktime},
                                                           #{feedbacktimelong}, #{feedbackmemo}, #{createby},
                                                           #{createtime}, #{updateby},
                                                           #{updatetime} );

-- [lockPreOutStockBreed]
update $table$ set idActualPaperInfo = #{idactualpaperinfo}, actualPaperName = #{actualpapername}, preOutStockLockQty = #{preoutstocklockqty},
preOutStockLockIdRoom = #{preoutstocklockidroom}, preOutStockState = #{preoutstockstate}, updateBy = #{updateby}, updateTime = #{updatetime}
where id = #{id};

-- [preOutStockComplete]
update $table$ set preOutStockState = #{preoutstockstate}, updateBy = #{updateby}, updateTime = #{updatetime}
where id = #{id};


-- [lockPreOutStockBreedV2]
update $table$ set preOutLockState = #{preoutlockstate}, preOutLockManId = #{preoutlockmanid}, preOutLockManName = #{preoutlockmanname},
updateBy = #{updateby}, updateTime = #{updatetime}
where id = #{id};


-- [preOutStockCompleteV2]
update $table$ set
preOutStockState = #{preoutstockstate},
idActualPaperInfo = #{idactualpaperinfo},
actualPaperName = #{actualpapername},
preOutStockLockIdRoom = #{preoutstocklockidroom},
preOutStockLockQty = #{preoutstocklockqty},
preOutStockUnlocked = #{preoutstockunlocked},
wholePaperCount = #{wholepapercount},
pickPaperCount = #{pickpapercount},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};


-- [preOutStockBackV2]
update $table$ set preOutStockState = #{preoutstockstate}, preOutLockManId = #{preoutlockmanid}, preOutLockManName = #{preoutlockmanname},
preOutLockState =  #{preoutlockstate}, preOutStockUnlocked = #{preoutstockunlocked}, idActualPaperInfo = #{idactualpaperinfo}, actualPaperName = #{actualpapername},
preOutStockLockQty = #{preoutstocklockqty},  wholePaperCount = #{wholepapercount}, updateBy = #{updateby}, updateTime = #{updatetime}
where id = #{id};

-- [breedPickPaperIn]
update $table$ set
 pickPaperCount = pickPaperCount + 1
where id = #{id};

-- [breedPickPaperOut]
update $table$ set
 pickPaperCount = pickPaperCount - 1
where id = #{id};

-- [newPrintBillLifeCycle]
insert into $table$ (id, idPrintBill, idBreed, lifeNodeId,
lifeNodeName, lifeNodeState, billYear,
referenceMasterId, referenceSlaveId, createManName,
updateManName, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idprintbill}, #{idbreed}, #{lifenodeid},
#{lifenodename}, #{lifenodestate}, #{billyear},
#{referencemasterid}, #{referenceslaveid}, #{createmanname},
#{updatemanname}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePrintBillLifeCycle]
update $table$ set lifeNodeState = #{lifenodestate},
   updateBy = #{updateby}, updateManName = #{updatemanname}, updateTime = #{updatetime}, updateTimeLong = #{updatetimelong}
where idPrintBill = #{idprintbill} and idBreed = #{idbreed} and lifeNodeId = #{lifenodeid};

-- [updatePrintBillLifeCycleByParam]
update $table$ set lifeNodeState = #{lifenodestate},
 updateBy = #{updateby}, updateManName = #{updatemanname}, updateTime = #{updatetime}, updateTimeLong = #{updatetimelong}
where idPrintBill = #{idprintbill}

-- [selectPrintBillLifeCycle]
select * from $table$;

-- [voidPrintBillLifeCycle]
update $table$ set lifeNodeState = #{lifenodestate},
 updateBy = #{updateby}, updateManName = #{updatemanname}, updateTime = #{updatetime}, updateTimeLong = #{updatetimelong}
where idPrintBill = #{idprintbill}


-- [stockOutBillBreedWithPreState]
update $table$ set
idActualPaperInfo = #{idactualpaperinfo},
actualPaperName = #{actualpapername},
preOutStockUnlocked = #{preoutstockunlocked}
where id = #{id};

-- [stockOutBillBreed]
update $table$ set
idActualPaperInfo = #{idactualpaperinfo},
actualPaperName = #{actualpapername}
where id = #{id};

-- [stockOutBillBreedHidePreState]
update $table$ set
preOutStockUnlocked = #{preoutstockunlocked}
where id = #{id};

-- [deleteBreedPlateSize]
delete from $table$ where idBreed = #{idbreed};

-- [insertBreedPlateSize]
insert into $table$ (idBreed, idPlateSizeTemplate, idPrintBill, billYear,
                     pageBlankTop, pageBlankLeft, pageBlankBottom,
                     pageBlankRight, distanceHoldVertocal, distancePlateVertocal,
                     distanceWidthVertocal, distanceHeightVertocal, distanceHoldHorizontal,
                     distancePlateHorizontal, distanceWidthHorizontal, distanceHeightHorizontal,
                     drawTChiPDF, tchiPDFFile, tchiPDFSize,
                     holdPlace, sidePlace, faceCount,
                     moqieArea, fumoArea, exchangeHoldPlace,
                     createBy, createTime, createTimeLong,
                     updateBy, updateTime, updateTimeLong ) values ( #{idbreed}, #{idplatesizetemplate}, #{idprintbill}, #{billyear},
                                                                     #{pageblanktop}, #{pageblankleft}, #{pageblankbottom},
                                                                     #{pageblankright}, #{distanceholdvertocal}, #{distanceplatevertocal},
                                                                     #{distancewidthvertocal}, #{distanceheightvertocal}, #{distanceholdhorizontal},
                                                                     #{distanceplatehorizontal}, #{distancewidthhorizontal}, #{distanceheighthorizontal},
                                                                     #{drawtchipdf}, #{tchipdffile}, #{tchipdfsize},
                                                                     #{holdplace}, #{sideplace}, #{facecount},
                                                                     #{moqiearea}, #{fumoarea}, #{exchangeholdplace},
                                                                     #{createby}, #{createtime}, #{createtimelong},
                                                                     #{updateby}, #{updatetime}, #{updatetimelong} );

-- [selectBreedPlateSize]
select * from $table$ where idBreed = #{idbreed};

-- [updatePrintBillAssembleBreedRequire]
update $table$ set
assembleBreedRequire = #{assemblebreedrequire}
where id = #{id};

-- [forceUpdatePrintBill_PrintInfo]
update $table$ set
billNote = #{billnote},
billMoneyPlate = #{billmoneyplate},
billMoneyPaper = #{billmoneypaper},
billMoneyPrint = #{billmoneyprint},
billMoneyProcess = #{billmoneyprocess},
billMoneyTotal = #{billmoneytotal},
billMoneyAdjust = #{billmoneyadjust},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

-- [forceUpdatePrintBreed_PrintInfo]
update $table$ set
idMachineType = #{idmachinetype},
colorCount = #{colorcount},
specialColor = #{specialcolor},
breedFlipType = #{breedfliptype},
psGroupCount = #{psgroupcount},
psSize = #{pssize},
psCount = #{pscount},
printCount1000 = #{printcount1000},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};









-- [recoverDataBaseFromEs_PrintBill]
insert into $table$
(id,billYear,billCode,productName,billName,clientName,processText,outSourceProcessText,deliveryDate,printTime,voidFlag,billNote,billState,billMoneyPlate,billMoneyPaper,billMoneyPrint,billMoneyProcess,billMoneyTotal,billMoneyAdjust,orderMoneyTotal,containsOrderIds,breedFileUrl,idCompany,createBy,createTime,updateBy,updateTime,billType,containsOrderCodes,idProduct,autoPDFFlag,createManName,orderPrintRequire,orderSendKind,assembleBreedRequire)
values(#{id},#{billyear},#{billcode},#{productname},#{billname},#{clientname},#{processtext},#{outsourceprocesstext},#{deliverydate},#{printtime},#{voidflag},#{billnote},#{billstate},#{billmoneyplate},#{billmoneypaper},#{billmoneyprint},#{billmoneyprocess},#{billmoneytotal},#{billmoneyadjust},#{ordermoneytotal},#{containsorderids},#{breedfileurl},#{idcompany},#{createby},#{createtime},#{updateby},#{updatetime},#{billtype},#{containsordercodes},#{idproduct},#{autopdfflag},#{createmanname},#{orderprintrequire},#{ordersendkind},#{assemblebreedrequire});

-- [recoverDataBaseFromEs_PrintBreed]
insert into $table$
(id,billYear,idPrintBill,breedName,breedTypeName,selfProvidedPaper,wholePaperSize,paperBand,idPaperBaseInfo,paperName,cutCount,cutSize,partCount,breedNo,printCount,printFlowCount,craftFlowCount,wholePaperCount,paperPrice,breedPaperPrice,idActualPaperInfo,idMachineType,idMachine,colorCount,specialColor,breedFlipType,breedSize,PSSize,PSGroupCount,PSCount,completeCount,printCount1000,printCosts,breedProcess,breedStatus,createBy,createTime,updateBy,updateTime,printRequire,machineName,machineTypeName,actualPaperName,cutName,preOutStockState,preOutStockLockQty,preOutStockLockIdRoom,preOutLockState,preOutLockManId,preOutLockManName,breedSets,idPlateSizeTemplate,idPaperCutInfo,voidFlag,containsOrderIds,idCompany,preOutStockUnlocked,pickPaperCount,paperRequireFlag,paperPreRequestFlag,paperStockInFlag,paperPickingFlag,paperStockOutFlag)
values(#{id},#{billyear},#{idprintbill},#{breedname},#{breedtypename},#{selfprovidedpaper},#{wholepapersize},#{paperband},#{idpaperbaseinfo},#{papername},#{cutcount},#{cutsize},#{partcount},#{breedno},#{printcount},#{printflowcount},#{craftflowcount},#{wholepapercount},#{paperprice},#{breedpaperprice},#{idactualpaperinfo},#{idmachinetype},#{idmachine},#{colorcount},#{specialcolor},#{breedfliptype},#{breedsize},#{pssize},#{psgroupcount},#{pscount},#{completecount},#{printcount1000},#{printcosts},#{breedprocess},#{breedstatus},#{createby},#{createtime},#{updateby},#{updatetime},#{printrequire},#{machinename},#{machinetypename},#{actualpapername},#{cutname},#{preoutstockstate},#{preoutstocklockqty},#{preoutstocklockidroom},#{preoutlockstate},#{preoutlockmanid},#{preoutlockmanname},#{breedsets},#{idplatesizetemplate},#{idpapercutinfo},#{voidflag},#{containsorderids},#{idcompany},#{preoutstockunlocked},#{pickpapercount},#{paperrequireflag},#{paperprerequestflag},#{paperstockinflag},#{paperpickingflag},#{paperstockoutflag});

-- [recoverDataBaseFromEs_PrintBreedPart]
insert into $table$
(id,billYear,idPrintBill,idPrintBreed,idOrder,idOrderPart,idWorkPart,partHeight,partWidth,locationX,locationY,rotationAngle,idProduct,idPartInfo,productName,orderName,productPartName,semiFeedbackStatus,semiFeedbackContent,idSemiFeedbackMan,semiFeedbackTime,semiFeedbackTimeLong,orderCode)
values(#{id},#{billyear},#{idprintbill},#{idprintbreed},#{idorder},#{idorderpart},#{idworkpart},#{partheight},#{partwidth},#{locationx},#{locationy},#{rotationangle},#{idproduct},#{idpartinfo},#{productname},#{ordername},#{productpartname},#{semifeedbackstatus},#{semifeedbackcontent},#{idsemifeedbackman},#{semifeedbacktime},#{semifeedbacktimelong},#{ordercode});

-- [recoverDataBaseFromEs_MachineBreedTask]
insert into $table$
(id,billYear,idMachineInfo,idProcess,idPrintBreed,idPrintBill,expectedWorkTime,beginAt,beginAtLong,completeAt,completeAtLong,taskStatus,sortIndex,lastOperateManId,lastOperateManName,taskMemo,createBy,createTime,updateBy,updateTime,scheduleStatus,pauseStatus,voidFlag)
values(#{id},#{billyear},#{idmachineinfo},#{idprocess},#{idprintbreed},#{idprintbill},#{expectedworktime},#{beginat},#{beginatlong},#{completeat},#{completeatlong},#{taskstatus},#{sortindex},#{lastoperatemanid},#{lastoperatemanname},#{taskmemo},#{createby},#{createtime},#{updateby},#{updatetime},#{schedulestatus},#{pausestatus},#{voidflag});

-- [recoverDataBaseFromEs_FeedbackRecord]
insert into $table$
(id,billYear,idTask,recordType,idProcess,processName,idReference,feedbackCount,feedbackComplete,feedbackManId,feedbackMan,feedbackTime,feedbackTimeLong,feedbackMemo,createBy,createTime,updateBy,updateTime,feedbackBegin)
values(#{id},#{billyear},#{idtask},#{recordtype},#{idprocess},#{processname},#{idreference},#{feedbackcount},#{feedbackcomplete},#{feedbackmanid},#{feedbackman},#{feedbacktime},#{feedbacktimelong},#{feedbackmemo},#{createby},#{createtime},#{updateby},#{updatetime},#{feedbackbegin});

-- [recoverDataBaseFromEs_BillStep]
insert into $table$
(billYear,idPrintBill,idWorkMan,workMan,workTime,workTimeLong,workMemo,workExplain)
values(#{billyear},#{idprintbill},#{idworkman},#{workman},#{worktime},#{worktimelong},#{workmemo},#{workexplain});

-- [recoverDataBaseFromEs_BreedProcess]
insert into $table$
(id,billYear,idPrintBill,idPrintBreed,idOrder,idProcess,processName,feedbackStatus,feedbackCount,totalCount,completeTime,completeTimeLong,isOutAssisted,idOutAssistBill,outAssistBillCode,idMaterial,materialName,orderProcessMemo)
values(#{id},#{billyear},#{idprintbill},#{idprintbreed},#{idorder},#{idprocess},#{processname},#{feedbackstatus},#{feedbackcount},#{totalcount},#{completetime},#{completetimelong},#{isoutassisted},#{idoutassistbill},#{outassistbillcode},#{idmaterial},#{materialname},#{orderprocessmemo});


-- [backDoor_updateBreedPreOutLockState]
update $table$ set preOutStockUnlocked = #{preoutstockunlocked} where id = #{id};


-- [selectExclusiveBillSpliceTask]
select * from $table$;

-- [addExclusiveBillSpliceTask]
insert into $table$ (id, billYear, idPrintBill, printBillCode,
                     productName, breedCount, taskStatus,
                     voidFlag, idSpliceMan, spliceManName,
                     idAssignMan, assignManName, taskBeginTime,
                     taskCompleteTime, processedCount, backReason, currentVersion, pauseStatus, pauseMemo,
                     createBy, createTime, createTimeLong,
                     updateBy, updateTime, updateTimeLong ) values ( #{id}, #{billyear}, #{idprintbill}, #{printbillcode},
                                                                     #{productname}, #{breedcount}, #{taskstatus},
                                                                     #{voidflag}, #{idspliceman}, #{splicemanname},
                                                                     #{idassignman}, #{assignmanname}, #{taskbegintime},
                                                                     #{taskcompletetime}, #{processedcount}, #{backreason}, #{currentversion}, #{pausestatus}, #{pausememo},
                                                                     #{createby}, #{createtime}, #{createtimelong},
                                                                     #{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateExclusiveBillSpliceTask]
update $table$ set billYear = #{billyear},taskStatus = #{taskstatus},idSpliceMan = #{idspliceman},
spliceManName = #{splicemanname},idAssignMan = #{idassignman},assignManName = #{assignmanname},taskBeginTime = #{taskbegintime},
taskCompleteTime = #{taskcompletetime},processedCount = #{processedcount},backReason = #{backreason}, currentVersion = #{currentversion}, createBy = #{createby},
createTime = #{createtime},createTimeLong = #{createtimelong},updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [voidExclusiveBillSpliceTask]
update $table$ set voidFlag = #{voidflag}, updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [assignExclusiveTask]
update $table$ set taskStatus = #{taskstatus},idSpliceMan = #{idspliceman},
spliceManName = #{splicemanname},idAssignMan = #{idassignman},assignManName = #{assignmanname},
assignTime = #{assigntime}, backReason = #{backreason},
updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [feedbackExclusiveTask]
update $table$ set taskStatus = #{taskstatus}, taskBeginTime = #{taskbegintime}, taskCompleteTime = #{taskcompletetime}, processedCount = #{processedcount},
backReason = #{backreason},
updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [pauseExclusiveTask]
update $table$ set pauseStatus = #{pausestatus}, pauseMemo = #{pausememo},
updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

-- [backDoor_updateMachineTaskAssortIds]
update $table$ set cutPaperId = #{cutpaperid}, madeBreedId = #{madebreedid},
               assembleBreedId = #{assemblebreedid}, printId = #{printid}
               where id = #{id};