#眉標=Atlas
#副標=Ajax網頁開發(8)
#大標=使用Microsoft Atlas開發資料操作網頁(下)
#作者=文／王寧疆
#引言=


-----box 指令-----
[WebService(Namespace = "http://tempuri.org/")]
public class EmployeeDataSource : DataService 
{
    [DataObjectMethod(DataObjectMethodType.Insert)]				//負責執行新增記錄的方法
    public void InsertRow(string FirstName, string LastName)
    {
    }
    [DataObjectMethod(DataObjectMethodType.Delete)]				//負責執行刪除記錄的方法
    public void DeleteRow(int EmployeeID)
    {
    }
    [DataObjectMethod(DataObjectMethodType.Select)]				//負責執行查詢記錄的方法
    public DataTable SelectRows()
    {
    }
    [DataObjectMethod(DataObjectMethodType.Update)]				//負責執行更新記錄的方法
    public void UpdateRow(Employee e)
    {
    }
}

-----end-----



-----box 程式-----
public class Employee
{
    public int EmployeeID;
    public string FirstName;
    public string LastName;
}
-----end-----


-----box 指令-----
[DataObjectMethod(DataObjectMethodType.Select)]				//負責執行查詢記錄的方法
public DataTable SelectRows()
{
  //資料庫連線資訊
string strConn = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\SQL Server 2000 Sample " & _ 
   "Databases\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True";
  string strSQL = "Select EmployeeID, FirstName, LastName, BirthDate, HireDate, HomePhone from " & _ 
	"Employees";						//查詢員工記錄的SQL敘述
  SqlConnection conn = new SqlConnection(strConn);				//建立SqlConnection類別的物件
  SqlDataAdapter da = new SqlDataAdapter(strSQL, conn); 		//建立SqlDataAdapter類別的物件
  DataTable table = new DataTable("Employees");					//建立SqlDataTable類別的物件
  da.Fill(table);				//執行查詢，並將查詢得到的記錄填入DataTable 類別的物件
  return table;									//傳回DataTable 類別的物件
}
-----end-----


-----box 指令-----
<script type="text/xml-script">
  <page xmlns:script="..">
    <components>
      <dataSource id="EmployeeDataSource1" autoLoad="true" 									serviceURL="EmployeeDataSource.asmx" propertyChanged="onChange" />
      <listView id="searchResults" cssClass="listView" 
                  itemTemplateParentElementId="myList_itemTemplateParent" 
                  alternatingItemCssClass="alternatingItem" 
                  itemCssClass="item">
        <bindings>
          <binding dataContext="EmployeeDataSource1" dataPath="data" property="data" />
        </bindings>
        定義ListView控制項顯示資料的方式
	</listView>
    </components>
  </page>
</script >

-----end-----


-----box 指令-----
<div id="pageNavigator">
  <input type="button" id="firstPageButton" value="<<" />
  <input type="button" id="previousPageButton" value="<" />
  <span id="pageIndexLabel"></span>
  /
  <span id="pageCountLabel"></span>
  <input type="button" id="nextPageButton" value=">" />
  <input type="button" id="lastPageButton" value=">>" />
</div>

-----end-----



-----box 指令-----
<dataNavigator id="pageNavigator" dataView="view"/>
<button id="previousPageButton" parent="pageNavigator"	command="previousPage">
  <bindings>
    <binding property="enabled" dataPath="hasPreviousPage"/>
  </bindings>
</button>
<label id="pageIndexLabel" parent="pageNavigator">
  <bindings>
    <binding property="text" dataPath="pageIndex" transform="Add"/>
  </bindings>
</label>
<label id="pageCountLabel" parent="pageNavigator">
  <bindings>
    <binding property="text" dataPath="pageCount"/>
  </bindings>
</label>
<button id="nextPageButton" parent="pageNavigator" command="nextPage">
<bindings>
    <binding property="enabled" dataPath="hasNextPage"/>
</bindings>
</button>
<button id="firstPageButton" parent="pageNavigator" command="FIRSTPage">
</button>
<button id="lastPageButton" parent="pageNavigator" command="lastpage">
</button>

-----end-----



-----box 指令-----
<dataSource id="dataSource" autoLoad="true" serviceURL="CustomerDataSource.asmx" />
-----end-----



-----box 指令-----
<dataView id="view" pageSize="10">
  <bindings>
    <binding dataContext="dataSource" dataPath="data" property="data" />
  </bindings>
</dataView>
-----end-----



-----box 指令-----
<a href="javascript:;" id="sortCustomerID">CustomerID</a>
-----end-----



-----box 程式-----
<control id="sortCustomerID">
  <behaviors>
    <sortBehavior dataView="view" sortColumn="CustomerID"/>
  </behaviors>
</control>
-----end-----