Example #1
0
 def m_ribbonButton_newSOOnRibbonButtonClicked( self, event ):
     newdialog = SO_DIALOG(self, flag='new')
     if newdialog.ShowModal() == wx.ID_OK:
         newdata = newdialog.getData()
         self.connectDb()
       
         for item in  newdata.keys():
             print 'key is %s,data is %s' % (item , newdata[item])             
         
        
         #data = (newdata[u'订单号'], newdata[u'客户号'], newdata[u'客户采购单号'], newdata[u'下单日期'],  newdata[u'箱号范围'], newdata[u'交货日期'],newdata[u'总数量'], newdata[u'总金额'], newdata[u'内容'], newdata[u'注意事项'])
         #data = (newdata[u'订单号'], newdata[u'客户号'], newdata[u'客户采购单号'], newdata[u'下单日期'],  newdata[u'箱号范围'], newdata[u'交货日期'], newdata[u'总数量']) # newdata[u'总金额'], newdata[u'内容'], newdata[u'注意事项'])
         #print self.cur.mogrify(SO_INSERT_NEWHEADER, data)
         #self.cur.execute(SO_INSERT_NEWHEADER, data)
         #self.conn.commit()
         #self.closeDb()
             
         
         #data = (newdata[u'订单号'], newdata[u'客户号'], newdata[u'下单日期'])
         #sql = """INSERT INTO soheader (订单号,客户号,下单日期)  VALUES (%s,%s,%s);"""
         #print newdata[u'下单日期']
        
         #self.cur.execute(sql, data)
         #self.conn.commit()
         #self.closeDb()
         
         
         
    
     event.Skip()
Example #2
0
 def OnCellDClicked(self, event):
     
     soshowdialog = SO_DIALOG(self, flag='read', data=self.selectedItem)
     soshowdialog.Center(wx.CENTER_ON_SCREEN)
     
     Detailcollables = [item[2] for item in SODETAIL]
     Detailtablecollables = [item[1] for item in SODETAIL]
             
     detailtable = SoTable(self.detaildata, None, Detailcollables, Detailtablecollables, None)
     soshowdialog.m_grid4.SetTable(detailtable)
     soshowdialog.m_grid4.AutoSizeColumns() 
     if soshowdialog.ShowModal() == wx.ID_OK:
         soshowdialog.getData()