buildtimesheet.asp

Windows Web脚本开发指南/(美) Dan Heflin, Todd Ney著 的源码

<%@ LANGUAGE=JavaScript %>
<%
  
  Response.ContentType = "text/xml";
  
  var common = Server.CreateObject("CommonFunctionality.WSC");  
  var conn = common.getDatabaseObject();
  var sql = "select StartDate, CreatedBy, Day, ClientID, Format([StartTime],'Medium Time'), Format([EndTime],'Medium Time'), Description ";
  var orderBy = " ORDER BY CreatedBy, StartDate";  
  var seperator = "";
  var userID = Request.QueryString("UserID");
  common.setRightsProperties(userID, false);
  sql += "from TimesheetDetail INNER JOIN  TimesheetList ON TimesheetList.FileID = TimesheetDetail.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 += orderBy;
  rs = conn.Execute(sql);
  Response.Write("<timeSheetGroup>");
  var priorStartDate = "";
  var priorCreator = "";
  var tempStartDate;
  var tempCreator;
  while (rs.EOF != true){
    tempStartDate = String(rs(0).value);
    tempCreator = rs(1).value;
    //Check to see if we need to create a new timesheet
    if (tempStartDate != priorStartDate || tempCreator != priorCreator){
      if (priorStartDate != "")
        Response.Write('</timeSheet>');
      priorStartDate = tempStartDate;
      priorCreator = tempCreator;
      var startDate = common.formatDate(tempStartDate);
      Response.Write('<timeSheet startDate="'  + startDate + '" createdBy="' + common.replaceQuotes(tempCreator, 'xml') + '">');
    }
    Response.Write("<task day='" + rs(2) + "' clientID='" + common.replaceQuotes(rs(3)) + "' startTime='" + rs(4) + "' endTime='" + rs(5) + "'>" + rs(6) + "</task>");
    rs.MoveNext();
  }
  if (priorStartDate != "") 
    Response.Write('</timeSheet>');
  Response.Write("</timeSheetGroup>");

%>