開發(fā)篇-讓點名表自動顯示上課日期

申請免費試用、咨詢電話：400-8352-114

    泛普默認的點名表并沒有提供自動顯示上課日期功能，因為考慮到很多學校上課日期后期變化大等因素。
但是確實有些學校規(guī)律性很強，有這個需求。

所以今天我就帶大家，如何在泛普培訓學校管理軟件平臺上去實現(xiàn)自動顯示上課日期。


第一步：編輯點名表數(shù)據(jù)源：



代碼如下：

ACCESS數(shù)據(jù)庫語法：

table:LessonDegree
cmd: Select LessonDegree.StartDate from LessonDegree where LessonDegree.StartDate > now() and ClassID = @ClassID
GO

SQL數(shù)據(jù)庫語法：

table:LessonDegree
cmd: Select LessonDegree.StartDate from LessonDegree where LessonDegree.StartDate > getdate() and ClassID = @ClassID
GO



第二步編輯報表，將原來備注以上的重復出現(xiàn)的TD代碼替換成如下代碼：



代碼如下：

<td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[1]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[2]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[3]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[4]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[5]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[6]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[7]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[8]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[9]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[10]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[11]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[12]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[13]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[14]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[15]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[16]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[17]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[18]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[19]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[20]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[21]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[22]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[23]/StartDate)" /></td>
              <td width="0.6cm" style="font-size:5;"><xsl:value-of select="String:FormatDate('{0:M-d}',ds/LessonDegree[24]/StartDate)" /></td>



最終效果：