開發(fā)篇-讓點(diǎn)名表自動(dòng)顯示上課日期

申請(qǐng)免費(fèi)試用、咨詢電話：400-8352-114

    泛普默認(rèn)的點(diǎn)名表并沒有提供自動(dòng)顯示上課日期功能，因?yàn)榭紤]到很多學(xué)校上課日期后期變化大等因素。
但是確實(shí)有些學(xué)校規(guī)律性很強(qiáng)，有這個(gè)需求。

所以今天我就帶大家，如何在泛普培訓(xùn)學(xué)校管理軟件平臺(tái)上去實(shí)現(xiàn)自動(dòng)顯示上課日期。


第一步：編輯點(diǎ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



第二步編輯報(bào)表，將原來備注以上的重復(fù)出現(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>



最終效果：