buildtimesheetsummary.asp

来自「Windows Web脚本开发指南/(美) Dan Heflin, Todd N」· ASP 代码 · 共 50 行

<%@ LANGUAGE=JavaScript %>
<%
  Response.ContentType = "text/xml";
  var common = Server.CreateObject("CommonFunctionality.WSC");  
  
  var conn = common.getDatabaseObject();
  var sql = "SELECT StartDate, CreatedBy, ClientID, Sum(DateDiff('n',StartTime,EndTime)) AS Duration ";
  var groupBy = " GROUP BY StartDate, CreatedBy, ClientID";  
  var seperator = "";
  var userID = Request.QueryString("UserID");
  var startDate;
  var tempDate;
  var startInt;
  
  common.setRightsProperties(userID, false); 
  
  sql += "from TimesheetDetail INNER JOIN  TimesheetList ON TimesheetDetail.FileID = TimesheetList.FileID " 
  if (common.tables != "")
    sql += common.tables 
  var whereClause = "";
  if (Request.QueryString("name") != "All"){
     whereClause = " CreatedBy='" + common.replaceQuotes(Request.QueryString("name")) + "' ";
     seperator = " and ";
  } 
  if (Request.QueryString("date") != "All"){
     whereClause += seperator + " StartDate=#" + Request.QueryString("date") + "# ";
     seperator = " and ";
  }
  if (Request.QueryString("client") != "All"){
     whereClause += seperator + " ClientID='" + Request.QueryString("client") + "'";
     seperator = " and ";
  }
 
  if (common.where != "")
    whereClause += seperator + common.where; 
  
  if (whereClause != "")
     sql += " where " + whereClause;  
  sql += groupBy;
  rs = conn.Execute(sql);
  Response.Write("<timeSheetList>");
  while (rs.EOF == false){
     startDate = common.formatDate(rs(0));
     tempDate = new Date(rs(0));
     startInt = tempDate.getTime();
     Response.Write('<timeSheetSummary startDate="' + startDate + '" startInt="' + startInt + '" createdBy="' + common.replaceQuotes(rs(1), 'xml') + '" clientID="' + common.replaceQuotes(rs(2), 'xml') + '" duration="' + rs(3) + '"  />');
     rs.MoveNext();
  }
  Response.Write("</timeSheetList>");
%>