![]() |
#3 |
Участник
|
COD
// update project donehours per department
var query2 = "SELECT SUM(FilteredReut_assignment.reut_donehours) AS DoneHours FROM FilteredReut_assignment INNER JOIN FilteredReut_project ON FilteredReut_assignment.reut_projectid = FilteredReut_project.reut_projectid WHERE (FilteredReut_assignment.reut_taskstatus = 3) AND (FilteredReut_project.reut_projectid ='" + Project +"') AND (FilteredReut_assignment.reut_department = " + Department +")"; var rs2 = new ActiveXObject("ADODB.Recordset"); rs2.Open(query2, connection, 1, 2); var ProjDoneHours=rs2.Fields(0).Value; switch (Department) { case "1": var query3 = "UPDATE FilteredReut_project SET reut_managementdone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')"; break; case "2": var query3 = "UPDATE FilteredReut_project SET reut_engineeringdone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')"; break; case "3": var query3 = "UPDATE FilteredReut_project SET reut_operationdone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')"; break; case "4": var query3 = "UPDATE FilteredReut_project SET reut_manufacturedone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')"; break; } |
|
Теги |
javascript, sql, unsupported |
|
|