def middleCollect(self): '''中间回收''' #左边 new_distri_id = getNextVal(self.oracle) split_tax_end_nbr = addZero(len(self.tax_begin_nbr), int(self.tax_begin_nbr)-1) insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id = self.distri_id, staff_id = self.hold_staff_id, tax_begin_nbr = self.hold_tax_begin_nbr , tax_end_nbr = split_tax_end_nbr) insertDistriLog(oracle = self.oracle, distri_id = new_distri_id, oper_staff_id = self.oper_staff_id, oper = 'split collect', state = 'hold') #右边 new_distri_id = getNextVal(self.oracle) split_tax_begin_nbr = addZero(len(self.tax_end_nbr), int(self.tax_end_nbr)+1) insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id = self.distri_id, staff_id = self.hold_staff_id, tax_begin_nbr = split_tax_begin_nbr , tax_end_nbr = self.hold_tax_end_nbr) insertDistriLog(oracle = self.oracle, distri_id = new_distri_id, oper_staff_id = self.oper_staff_id, oper = 'split collect',state = 'hold')
def insertNewDistri(self): #回收 new_distri_id = getNextVal(self.oracle) insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id = self.distri_id, staff_id = self.oper_staff_id, tax_begin_nbr = self.tax_begin_nbr, tax_end_nbr = self.tax_end_nbr) insertDistriLog(oracle = self.oracle, distri_id = new_distri_id, oper_staff_id = self.oper_staff_id, oper = 'collect', state = 'hold')
def leftCollect(self): '''右回收''' #拆分生成原持有左边剩下的 new_distri_id = getNextVal(self.oracle) split_tax_end_nbr = addZero(len(self.tax_begin_nbr), int(self.tax_begin_nbr)-1) insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id = self.distri_id, staff_id = self.hold_staff_id, tax_begin_nbr = self.hold_tax_begin_nbr, tax_end_nbr = split_tax_end_nbr) insertDistriLog(oracle = self.oracle, distri_id = new_distri_id, oper_staff_id = self.oper_staff_id, oper = 'split collect', state = 'hold')
def allCollect(oracle, distri_id, oper_staff_id): '''全部回收''' update_dic = {'state':'out','state_date':'/sysdate'} where_dic = {'distri_id':distri_id} update(oracle, 'distri', update_dic, where_dic) insertDistriLog(oracle = oracle, distri_id = distri_id, oper_staff_id = oper_staff_id, oper = 'be collect',state = 'out') new_distri_id = getNextVal(oracle) insertDistriAsSplit(oracle, new_distri_id = new_distri_id, distri_id = distri_id, staff_id = oper_staff_id) insertDistriLog(oracle = oracle, distri_id = new_distri_id, oper_staff_id = oper_staff_id, oper = 'collect',state = 'hold')