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