def deleteTask(self,taskId): conn,cursor = self.connectToServer() projectId = taskId[0:3] subprojectId = taskId[0:6] del_statement = mysql_utility.sqldeletState(table='task', condition={u'任务编号':taskId}) cursor.execute(del_statement) conn.commit() cursor.close() conn.close() membersList = self.taskDict[taskId][u'参与人员'].split(u';') for member in membersList: if member == u'': continue memberId = member.split(u'(')[1][0:6] oldTasks = self.allMembers[memberId][u'任务'] newTasks = oldTasks.replace(taskId+u';',u'') self.allMembers[memberId][u'任务'] = newTasks varsList = [(u'任务',newTasks)] condistionList = [(u'编号',memberId)] self.updateServer(table='member', varsList=varsList, conditionsList=condistionList) self.hierTree[projectId][subprojectId].remove(taskId) self.taskDict.pop(taskId) return 1
def delDaily(self,dailyDict={}): conn,cursor = self.connectToServer() statement = mysql_utility.sqldeletState(table='daily', condition=dailyDict) cursor.execute(statement) conn.commit() cursor.close() conn.close() return 1
def deleteSubproject(self,subprojectId): conn,cursor = self.connectToServer() projectId = subprojectId[0:3] deleteDict = self.hierTree[projectId][subprojectId] taskList = [] del_statments = [] del_statments.append(mysql_utility.sqldeletState(table='subproject', condition={u'展项编号':subprojectId})) for taskId in deleteDict: taskList.append(taskId) del_statments.append(mysql_utility.sqldeletState(table='task', condition={u'任务编号':taskId})) for statement in del_statments: cursor.execute(statement) conn.commit() cursor.close() conn.close() for taskId in taskList: self.deleteTask(taskId) self.hierTree[projectId].pop(subprojectId) self.subprojectDict.pop(subprojectId) return 1
def deleteTask_old(self,taskId): conn,cursor = self.connectToServer() projectId = taskId[0:3] subprojectId = taskId[0:6] del_statement = mysql_utility.sqldeletState(table='task', condition={u'任务编号':taskId}) cursor.execute(del_statement) conn.commit() cursor.close() conn.close() self.hierTree[projectId][subprojectId].remove(taskId) self.taskDict.pop(taskId) return 1
def deleteProject(self,projectdict): loginfile = open('hostname','r').read().split(' ') hostid = loginfile[0] database = loginfile[1] user = loginfile[2] pwd = loginfile[3] if hostid[:3] == codecs.BOM_UTF8: hostid = hostid[3:] conn = sql.connect(hostid,user,pwd,database,charset='utf8') cursor = conn.cursor() delete_statment = mysql_utility.sqldeletState('project',projectdict) project delete_statment cursor.execute(delete_statment) conn.commit() cursor.close() return 1