modsql = """SELECT TOP (1) DLID, cDLCode, cVouchType, cSTCode, dDate, cRdCode, cDepCode, cPersonCode, SBVID, cSBVCode, cSOCode, cCusCode, cPayCode,
cSCCode, cShipAddress, cexch_name, iExchRate, iTaxRate, bFirst, bReturnFlag, bSettleAll, cMemo, cSaleOut, cDefine1, cDefine2, cDefine3,
cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, cVerifier, cMaker, iNetLock, iSale, cCusName, iVTid, cBusType, cCloser,
cAccounter, cCreChpName, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16, bIAFirst, ioutgolden, cgatheringplan, dCreditStart,
dGatheringDate, icreditdays, bCredit, caddcode, iverifystate, ireturncount, iswfcontrolled, icreditstate, bARFirst, cmodifier, dmoddate, dverifydate,
ccusperson, dcreatesystime, dverifysystime, dmodifysystime, csvouchtype, iflowid, bsigncreate, bcashsale, cgathingcode, cChanger, cChangeMemo,
outid, bmustbook, cBookDepcode, cBookType, bSaUsed, bneedbill, baccswitchflag, iPrintCount, ccuspersoncode, cSourceCode, bsaleoutcreatebill,
cSysBarCode, cCurrentAuditor, csscode, cinvoicecompany, fEBweight, cEBweightUnit, cEBExpressCode, iEBExpressCoID, SeparateID,
bNotToGoldTax, cEBTrnumber, cEBBuyer, cEBBuyerNote, ccontactname, cEBprovince, cEBcity, cEBdistrict, cmobilephone, cInvoiceCusName,
cweighter, dweighttime, cPickVouchCode, cGCRouteCode, cbcode FROM DispatchList WHERE (DLID = 1000015017)"""
df0 = pd.read_sql_query(modsql, ENGINES[1])
df0.loc[0, 'DLID'] = dlid
df0.loc[0, 'cDLCode'] = cdlcode
df0.loc[0, 'cSTCode'] = 1
df0.loc[0, 'dDate'] = dt_new
df0.loc[0, 'cDepCode'] = self.depcd[self.frm]
df0.loc[0, 'cPersonCode'] = whom[self.frm]
df0.loc[0, 'cCusCode'] = self.custno[self.frm]
df0.loc[0, 'cCusName'] = self.cust[self.frm]
df0.loc[0, 'iVTid'] = self.vtid[self.frm]
df0.loc[0, 'cinvoicecompany'] = self.custno[self.frm]
df0.loc[0, 'cDefine7'] = None
df0.loc[0, 'iNetLock'] = None
df0.loc[0, 'bCredit'] = 1
df0.loc[0, 'ireturncount'] = None
df0.loc[0, 'iswfcontrolled'] = 1
df0.loc[0, 'cSysBarCode'] = f'||SA01|{cdlcode}'
df0.loc[0, 'cDefine10'] = self.cust[self.frm]
df0.loc[0, 'cMemo'] = f'转自采购入库单:{self.pp}-{nm}'
df0.loc[0, 'dCreditStart'] = None
df0.loc[0, 'dGatheringDate'] = None
df0.loc[0, 'icreditdays'] = 0
df0.loc[0, 'dmoddate'] = None
df0.loc[0, 'dverifydate'] = None
df0.loc[0, 'dcreatesystime'] = Wv0().reg_date
df0.loc[0, 'dverifysystime'] = None
df0.loc[0, 'dmodifysystime'] = None
df0.loc[0, 'iverifystate'] = 0
df0.loc[0, 'cVerifier'] = None
df0.loc[0, 'cMaker'] = self.cmaker
df0.loc[0, 'cgatheringplan'] = None
df0.loc[0, 'cDefine14'] = None
df0.to_sql(name='DispatchList', con=ENGINES[1], chunksize=100, index=False, if_exists='append')
从数据表取一条记录,修改部分字段内容后再插入,但失败了,我在另外一个表中是可以执行的,但就是这个表DispatchList不行。