MiLu/謎鹿進銷存系統/謎鹿DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="謎鹿DataSet" targetNamespace="http://tempuri.org/謎鹿DataSet.xsd" xmlns:mstns="http://tempuri.org/謎鹿DataSet.xsd" xmlns="http://tempuri.org/謎鹿DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="謎鹿ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="謎鹿ConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.謎鹿進銷存系統.My.MySettings.GlobalReference.Default.謎鹿ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="謎鹿ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="謎鹿ConnectionString1 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.謎鹿進銷存系統.My.MySettings.GlobalReference.Default.謎鹿ConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="商品TableAdapter" GeneratorDataComponentClassName="商品TableAdapter" Name="商品" UserDataComponentName="商品TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.商品" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[商品] WHERE (([商品編號] = @Original_商品編號) AND ((@IsNull_商品名稱 = 1 AND [商品名稱] IS NULL) OR ([商品名稱] = @Original_商品名稱)) AND ((@IsNull_庫存數量 = 1 AND [庫存數量] IS NULL) OR ([庫存數量] = @Original_庫存數量)) AND ((@IsNull_定價 = 1 AND [定價] IS NULL) OR ([定價] = @Original_定價)) AND ((@IsNull_種類 = 1 AND [種類] IS NULL) OR ([種類] = @Original_種類)) AND ((@IsNull_管理者編號 = 1 AND [管理者編號] IS NULL) OR ([管理者編號] = @Original_管理者編號)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_商品名稱" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品名稱" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_商品名稱" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="商品名稱" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_庫存數量" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="庫存數量" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_庫存數量" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_定價" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="定價" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_定價" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="定價" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_種類" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="種類" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_種類" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="種類" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_管理者編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="管理者編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_管理者編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="管理者編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[商品] ([商品編號], [商品名稱], [庫存數量], [定價], [種類], [管理者編號]) VALUES (@商品編號, @商品名稱, @庫存數量, @定價, @種類, @管理者編號);
SELECT 商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號 FROM 商品 WHERE (商品編號 = @商品編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@商品名稱" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="商品名稱" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@庫存數量" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@定價" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="定價" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@種類" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="種類" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@管理者編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="管理者編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT 商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號 FROM dbo.商品</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[商品] SET [商品編號] = @商品編號, [商品名稱] = @商品名稱, [庫存數量] = @庫存數量, [定價] = @定價, [種類] = @種類, [管理者編號] = @管理者編號 WHERE (([商品編號] = @Original_商品編號) AND ((@IsNull_商品名稱 = 1 AND [商品名稱] IS NULL) OR ([商品名稱] = @Original_商品名稱)) AND ((@IsNull_庫存數量 = 1 AND [庫存數量] IS NULL) OR ([庫存數量] = @Original_庫存數量)) AND ((@IsNull_定價 = 1 AND [定價] IS NULL) OR ([定價] = @Original_定價)) AND ((@IsNull_種類 = 1 AND [種類] IS NULL) OR ([種類] = @Original_種類)) AND ((@IsNull_管理者編號 = 1 AND [管理者編號] IS NULL) OR ([管理者編號] = @Original_管理者編號)));
SELECT 商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號 FROM 商品 WHERE (商品編號 = @商品編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@商品名稱" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="商品名稱" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@庫存數量" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@定價" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="定價" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@種類" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="種類" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@管理者編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="管理者編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_商品名稱" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品名稱" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_商品名稱" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="商品名稱" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_庫存數量" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="庫存數量" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_庫存數量" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_定價" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="定價" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_定價" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="定價" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_種類" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="種類" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_種類" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="種類" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_管理者編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="管理者編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_管理者編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="管理者編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="商品編號" DataSetColumn="商品編號" />
              <Mapping SourceColumn="商品名稱" DataSetColumn="商品名稱" />
              <Mapping SourceColumn="庫存數量" DataSetColumn="庫存數量" />
              <Mapping SourceColumn="定價" DataSetColumn="定價" />
              <Mapping SourceColumn="種類" DataSetColumn="種類" />
              <Mapping SourceColumn="管理者編號" DataSetColumn="管理者編號" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 商品
WHERE          (商品編號 = @商品編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="商品編號" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.商品" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByKeyword" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByKeyword" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByKeyword">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號
FROM              商品
WHERE          (商品編號 LIKE @keyword) OR
                            (商品名稱 LIKE @keyword) OR
                            (庫存數量 LIKE @keyword) OR
                            (定價 LIKE @keyword) OR
                            (種類 LIKE @keyword) OR
                            (管理者編號 LIKE @keyword)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="keyword" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@keyword" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.商品" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBysql" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBysql" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillBysql">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號
FROM              商品
WHERE          (商品編號 LIKE @sql)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="sql" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@sql" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 商品
                            (商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號)
VALUES          (@商品編號,@商品名稱,@庫存數量,@定價,@種類,@管理者編號); 
SELECT 商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號 FROM 商品 WHERE (商品編號 = @商品編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="商品編號" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="商品名稱" ColumnName="商品名稱" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@商品名稱" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="商品名稱" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="庫存數量" ColumnName="庫存數量" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@庫存數量" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="定價" ColumnName="定價" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@定價" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="定價" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="種類" ColumnName="種類" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@種類" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="種類" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="管理者編號" ColumnName="管理者編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@管理者編號" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="管理者編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE          商品
SET                   商品編號 = @商品編號, 商品名稱 = @商品名稱, 庫存數量 = @庫存數量, 定價 = @定價, 種類 = @種類, 
                            管理者編號 = @管理者編號
WHERE          (商品編號 = @商品編號); 
SELECT 商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號 FROM 商品 WHERE (商品編號 = @商品編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="商品編號" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="商品名稱" ColumnName="商品名稱" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@商品名稱" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="商品名稱" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="庫存數量" ColumnName="庫存數量" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@庫存數量" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="定價" ColumnName="定價" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@定價" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="定價" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="種類" ColumnName="種類" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@種類" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="種類" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="管理者編號" ColumnName="管理者編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@管理者編號" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="管理者編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQueryNumber" Modifier="Public" Name="UpdateQueryNumber" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateQueryNumber">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE          商品
SET                   庫存數量 = @庫存數量
WHERE          (商品編號 = @商品編號); 
SELECT 商品編號, 商品名稱, 庫存數量, 定價, 種類, 管理者編號 FROM 商品 WHERE (商品編號 = @商品編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="庫存數量" ColumnName="庫存數量" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@庫存數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="庫存數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="商品編號" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.商品" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="會員TableAdapter" GeneratorDataComponentClassName="會員TableAdapter" Name="會員" UserDataComponentName="會員TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.會員" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[會員] WHERE (([會員編號] = @Original_會員編號) AND ((@IsNull_帳號 = 1 AND [帳號] IS NULL) OR ([帳號] = @Original_帳號)) AND ((@IsNull_密碼 = 1 AND [密碼] IS NULL) OR ([密碼] = @Original_密碼)) AND ((@IsNull_姓名 = 1 AND [姓名] IS NULL) OR ([姓名] = @Original_姓名)) AND ((@IsNull_電話 = 1 AND [電話] IS NULL) OR ([電話] = @Original_電話)) AND ((@IsNull_住址 = 1 AND [住址] IS NULL) OR ([住址] = @Original_住址)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_帳號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="帳號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_帳號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="帳號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_密碼" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="密碼" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_密碼" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="密碼" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_姓名" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="姓名" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_姓名" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="姓名" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_電話" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="電話" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_電話" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="電話" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_住址" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="住址" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_住址" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="住址" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[會員] ([會員編號], [帳號], [密碼], [姓名], [電話], [住址], [email]) VALUES (@會員編號, @帳號, @密碼, @姓名, @電話, @住址, @email);
SELECT 會員編號, 帳號, 密碼, 姓名, 電話, 住址, email FROM 會員 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@帳號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="帳號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@密碼" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="密碼" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@姓名" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="姓名" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@電話" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="電話" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@住址" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="住址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT 會員編號, 帳號, 密碼, 姓名, 電話, 住址, email FROM dbo.會員</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[會員] SET [會員編號] = @會員編號, [帳號] = @帳號, [密碼] = @密碼, [姓名] = @姓名, [電話] = @電話, [住址] = @住址, [email] = @email WHERE (([會員編號] = @Original_會員編號) AND ((@IsNull_帳號 = 1 AND [帳號] IS NULL) OR ([帳號] = @Original_帳號)) AND ((@IsNull_密碼 = 1 AND [密碼] IS NULL) OR ([密碼] = @Original_密碼)) AND ((@IsNull_姓名 = 1 AND [姓名] IS NULL) OR ([姓名] = @Original_姓名)) AND ((@IsNull_電話 = 1 AND [電話] IS NULL) OR ([電話] = @Original_電話)) AND ((@IsNull_住址 = 1 AND [住址] IS NULL) OR ([住址] = @Original_住址)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)));
SELECT 會員編號, 帳號, 密碼, 姓名, 電話, 住址, email FROM 會員 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@帳號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="帳號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@密碼" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="密碼" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@姓名" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="姓名" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@電話" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="電話" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@住址" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="住址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_帳號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="帳號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_帳號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="帳號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_密碼" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="密碼" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_密碼" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="密碼" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_姓名" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="姓名" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_姓名" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="姓名" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_電話" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="電話" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_電話" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="電話" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_住址" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="住址" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_住址" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="住址" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="會員編號" DataSetColumn="會員編號" />
              <Mapping SourceColumn="帳號" DataSetColumn="帳號" />
              <Mapping SourceColumn="密碼" DataSetColumn="密碼" />
              <Mapping SourceColumn="姓名" DataSetColumn="姓名" />
              <Mapping SourceColumn="電話" DataSetColumn="電話" />
              <Mapping SourceColumn="住址" DataSetColumn="住址" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 會員
WHERE          (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.會員" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByemail" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByemail" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByemail">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          會員編號, 帳號, 密碼, 姓名, 電話, 住址, email
FROM              會員
WHERE          (email LIKE @nvarchar)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="nvarchar" ColumnName="email" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@nvarchar" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.會員" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByKeyword" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByKeyword" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByKeyword">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          會員編號, 帳號, 密碼, 姓名, 電話, 住址, email
FROM              會員
WHERE          (會員編號 LIKE @keyword) OR
                            (帳號 LIKE @keyword) OR
                            (密碼 LIKE @keyword) OR
                            (姓名 LIKE @keyword) OR
                            (電話 LIKE @keyword) OR
                            (住址 LIKE @keyword) OR
                            (email LIKE @keyword)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="keyword" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@keyword" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.會員" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBysql" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBysql" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="FillBysql">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          會員編號, 帳號, 密碼, 姓名, 電話, 住址, email
FROM              會員
WHERE          (會員編號 LIKE @sql)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="sql" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@sql" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 會員
                            (會員編號, 帳號, 密碼, 姓名, 電話, 住址, email)
VALUES          (@會員編號,@帳號,@密碼,@姓名,@電話,@住址,@email);  
SELECT 會員編號, 帳號, 密碼, 姓名, 電話, 住址, email FROM 會員 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="帳號" ColumnName="帳號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@帳號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="帳號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="密碼" ColumnName="密碼" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@密碼" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="密碼" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="姓名" ColumnName="姓名" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@姓名" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="姓名" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="電話" ColumnName="電話" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@電話" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="電話" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="住址" ColumnName="住址" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@住址" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="住址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="email" ColumnName="email" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE          會員
SET                   會員編號 = @會員編號, 帳號 = @帳號, 密碼 = @密碼, 姓名 = @姓名, 電話 = @電話, 住址 = @住址, 
                            email = @email
WHERE          (會員編號 = @會員編號);  
SELECT 會員編號, 帳號, 密碼, 姓名, 電話, 住址, email FROM 會員 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="帳號" ColumnName="帳號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@帳號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="帳號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="密碼" ColumnName="密碼" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@密碼" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="密碼" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="姓名" ColumnName="姓名" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@姓名" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="姓名" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="電話" ColumnName="電話" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@電話" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="電話" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="住址" ColumnName="住址" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@住址" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="住址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="email" ColumnName="email" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.會員" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="訂單TableAdapter" GeneratorDataComponentClassName="訂單TableAdapter" Name="訂單" UserDataComponentName="訂單TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.訂單" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[訂單] WHERE (([訂單編號] = @Original_訂單編號) AND ((@IsNull_付款方式 = 1 AND [付款方式] IS NULL) OR ([付款方式] = @Original_付款方式)) AND ((@IsNull_取貨方式 = 1 AND [取貨方式] IS NULL) OR ([取貨方式] = @Original_取貨方式)) AND ((@IsNull_訂單日期 = 1 AND [訂單日期] IS NULL) OR ([訂單日期] = @Original_訂單日期)) AND ((@IsNull_會員編號 = 1 AND [會員編號] IS NULL) OR ([會員編號] = @Original_會員編號)) AND ((@IsNull_購物車編號 = 1 AND [購物車編號] IS NULL) OR ([購物車編號] = @Original_購物車編號)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_訂單編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_付款方式" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="付款方式" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_付款方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="付款方式" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_取貨方式" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="取貨方式" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_取貨方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="取貨方式" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_訂單日期" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂單日期" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_訂單日期" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="訂單日期" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_會員編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_購物車編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_購物車編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[訂單] ([訂單編號], [付款方式], [取貨方式], [訂單日期], [會員編號], [購物車編號]) VALUES (@訂單編號, @付款方式, @取貨方式, @訂單日期, @會員編號, @購物車編號);
SELECT 訂單編號, 付款方式, 取貨方式, 訂單日期, 會員編號, 購物車編號 FROM 訂單 WHERE (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@付款方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="付款方式" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@取貨方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="取貨方式" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@訂單日期" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="訂單日期" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@購物車編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT 訂單編號, 付款方式, 取貨方式, 訂單日期, 會員編號, 購物車編號 FROM dbo.訂單</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[訂單] SET [訂單編號] = @訂單編號, [付款方式] = @付款方式, [取貨方式] = @取貨方式, [訂單日期] = @訂單日期, [會員編號] = @會員編號, [購物車編號] = @購物車編號 WHERE (([訂單編號] = @Original_訂單編號) AND ((@IsNull_付款方式 = 1 AND [付款方式] IS NULL) OR ([付款方式] = @Original_付款方式)) AND ((@IsNull_取貨方式 = 1 AND [取貨方式] IS NULL) OR ([取貨方式] = @Original_取貨方式)) AND ((@IsNull_訂單日期 = 1 AND [訂單日期] IS NULL) OR ([訂單日期] = @Original_訂單日期)) AND ((@IsNull_會員編號 = 1 AND [會員編號] IS NULL) OR ([會員編號] = @Original_會員編號)) AND ((@IsNull_購物車編號 = 1 AND [購物車編號] IS NULL) OR ([購物車編號] = @Original_購物車編號)));
SELECT 訂單編號, 付款方式, 取貨方式, 訂單日期, 會員編號, 購物車編號 FROM 訂單 WHERE (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@付款方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="付款方式" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@取貨方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="取貨方式" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@訂單日期" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="訂單日期" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@購物車編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_訂單編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_付款方式" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="付款方式" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_付款方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="付款方式" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_取貨方式" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="取貨方式" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_取貨方式" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="取貨方式" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_訂單日期" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂單日期" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_訂單日期" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="訂單日期" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_會員編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_購物車編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_購物車編號" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="訂單編號" DataSetColumn="訂單編號" />
              <Mapping SourceColumn="付款方式" DataSetColumn="付款方式" />
              <Mapping SourceColumn="取貨方式" DataSetColumn="取貨方式" />
              <Mapping SourceColumn="訂單日期" DataSetColumn="訂單日期" />
              <Mapping SourceColumn="會員編號" DataSetColumn="會員編號" />
              <Mapping SourceColumn="購物車編號" DataSetColumn="購物車編號" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 訂單
WHERE          (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="訂單編號" ColumnName="訂單編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 訂單
                            (訂單編號, 付款方式, 取貨方式, 訂單日期, 會員編號, 購物車編號)
VALUES          (@訂單編號,@付款方式,@取貨方式,@訂單日期,@會員編號,@購物車編號); 
SELECT 訂單編號, 付款方式, 取貨方式, 訂單日期, 會員編號, 購物車編號 FROM 訂單 WHERE (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="訂單編號" ColumnName="訂單編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="付款方式" ColumnName="付款方式" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@付款方式" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="付款方式" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="取貨方式" ColumnName="取貨方式" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@取貨方式" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="取貨方式" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="訂單日期" ColumnName="訂單日期" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@訂單日期" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="訂單日期" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="購物車編號" ColumnName="購物車編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂單" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@購物車編號" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="購物車TableAdapter" GeneratorDataComponentClassName="購物車TableAdapter" Name="購物車" UserDataComponentName="購物車TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.購物車" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[購物車] WHERE (([會員編號] = @Original_會員編號) AND ((@IsNull_運費 = 1 AND [運費] IS NULL) OR ([運費] = @Original_運費)) AND ((@IsNull_總金額 = 1 AND [總金額] IS NULL) OR ([總金額] = @Original_總金額)) AND ((@IsNull_購物車編號 = 1 AND [購物車編號] IS NULL) OR ([購物車編號] = @Original_購物車編號)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_運費" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="運費" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_運費" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="運費" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_總金額" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="總金額" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_總金額" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="總金額" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_購物車編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_購物車編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[購物車] ([會員編號], [運費], [總金額], [購物車編號]) VALUES (@會員編號, @運費, @總金額, @購物車編號);
SELECT 會員編號, 運費, 總金額, 購物車編號 FROM 購物車 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@運費" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="運費" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@總金額" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="總金額" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@購物車編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT 會員編號, 運費, 總金額, 購物車編號 FROM dbo.購物車</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[購物車] SET [會員編號] = @會員編號, [運費] = @運費, [總金額] = @總金額, [購物車編號] = @購物車編號 WHERE (([會員編號] = @Original_會員編號) AND ((@IsNull_運費 = 1 AND [運費] IS NULL) OR ([運費] = @Original_運費)) AND ((@IsNull_總金額 = 1 AND [總金額] IS NULL) OR ([總金額] = @Original_總金額)) AND ((@IsNull_購物車編號 = 1 AND [購物車編號] IS NULL) OR ([購物車編號] = @Original_購物車編號)));
SELECT 會員編號, 運費, 總金額, 購物車編號 FROM 購物車 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@運費" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="運費" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@總金額" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="總金額" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@購物車編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_運費" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="運費" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_運費" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="運費" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_總金額" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="總金額" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_總金額" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="總金額" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_購物車編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_購物車編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="會員編號" DataSetColumn="會員編號" />
              <Mapping SourceColumn="運費" DataSetColumn="運費" />
              <Mapping SourceColumn="總金額" DataSetColumn="總金額" />
              <Mapping SourceColumn="購物車編號" DataSetColumn="購物車編號" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 購物車
WHERE          (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.購物車" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 購物車
                            (會員編號, 運費, 總金額, 購物車編號)
VALUES          (@會員編號,@運費,@總金額,@購物車編號); 
SELECT 會員編號, 運費, 總金額, 購物車編號 FROM 購物車 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.購物車" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="運費" ColumnName="運費" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.購物車" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@運費" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="運費" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="總金額" ColumnName="總金額" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.購物車" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@總金額" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="總金額" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="購物車編號" ColumnName="購物車編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.購物車" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@購物車編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="購物車編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="紀錄TableAdapter" GeneratorDataComponentClassName="紀錄TableAdapter" Name="紀錄" UserDataComponentName="紀錄TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.紀錄" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[紀錄] WHERE (([訂單編號] = @Original_訂單編號) AND ((@IsNull_商品編號 = 1 AND [商品編號] IS NULL) OR ([商品編號] = @Original_商品編號)) AND ((@IsNull_訂購數量 = 1 AND [訂購數量] IS NULL) OR ([訂購數量] = @Original_訂購數量)) AND ((@IsNull_價錢 = 1 AND [價錢] IS NULL) OR ([價錢] = @Original_價錢)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_訂單編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_訂購數量" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_價錢" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="價錢" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_價錢" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="價錢" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[紀錄] ([訂單編號], [商品編號], [訂購數量], [價錢]) VALUES (@訂單編號, @商品編號, @訂購數量, @價錢);
SELECT 訂單編號, 商品編號, 訂購數量, 價錢 FROM 紀錄 WHERE (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@價錢" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="價錢" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT 訂單編號, 商品編號, 訂購數量, 價錢 FROM dbo.紀錄</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[紀錄] SET [訂單編號] = @訂單編號, [商品編號] = @商品編號, [訂購數量] = @訂購數量, [價錢] = @價錢 WHERE (([訂單編號] = @Original_訂單編號) AND ((@IsNull_商品編號 = 1 AND [商品編號] IS NULL) OR ([商品編號] = @Original_商品編號)) AND ((@IsNull_訂購數量 = 1 AND [訂購數量] IS NULL) OR ([訂購數量] = @Original_訂購數量)) AND ((@IsNull_價錢 = 1 AND [價錢] IS NULL) OR ([價錢] = @Original_價錢)));
SELECT 訂單編號, 商品編號, 訂購數量, 價錢 FROM 紀錄 WHERE (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@價錢" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="價錢" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_訂單編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_訂購數量" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_價錢" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="價錢" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_價錢" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="價錢" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="訂單編號" DataSetColumn="訂單編號" />
              <Mapping SourceColumn="商品編號" DataSetColumn="商品編號" />
              <Mapping SourceColumn="訂購數量" DataSetColumn="訂購數量" />
              <Mapping SourceColumn="價錢" DataSetColumn="價錢" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.紀錄" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByKeyword" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByKeyword" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByKeyword">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          訂單編號, 商品編號, 訂購數量, 價錢
FROM              紀錄
WHERE          (訂單編號 LIKE @keyword) OR
                            (商品編號 LIKE @keyword) OR
                            (訂購數量 LIKE @keyword) OR
                            (價錢 LIKE @keyword)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="keyword" ColumnName="訂單編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.紀錄" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@keyword" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.紀錄" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBysql" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBysql" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillBysql">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          訂單編號, 商品編號, 訂購數量, 價錢
FROM              紀錄
WHERE          (訂單編號 LIKE @sql)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="sql" ColumnName="訂單編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.紀錄" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@sql" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 紀錄
                            (訂單編號, 商品編號, 訂購數量, 價錢)
VALUES          (@訂單編號,@商品編號,@訂購數量,@價錢); 
SELECT 訂單編號, 商品編號, 訂購數量, 價錢 FROM 紀錄 WHERE (訂單編號 = @訂單編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="訂單編號" ColumnName="訂單編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.紀錄" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@訂單編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="訂單編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="商品編號" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.紀錄" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="訂購數量" ColumnName="訂購數量" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.紀錄" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="價錢" ColumnName="價錢" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.紀錄" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@價錢" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="價錢" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="訂購TableAdapter" GeneratorDataComponentClassName="訂購TableAdapter" Name="訂購" UserDataComponentName="訂購TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.訂購" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[訂購] WHERE (([會員編號] = @Original_會員編號) AND ((@IsNull_商品編號 = 1 AND [商品編號] IS NULL) OR ([商品編號] = @Original_商品編號)) AND ((@IsNull_訂購數量 = 1 AND [訂購數量] IS NULL) OR ([訂購數量] = @Original_訂購數量)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_訂購數量" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[訂購] ([會員編號], [商品編號], [訂購數量]) VALUES (@會員編號, @商品編號, @訂購數量);
SELECT 會員編號, 商品編號, 訂購數量 FROM 訂購 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT 會員編號, 商品編號, 訂購數量 FROM dbo.訂購</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[訂購] SET [會員編號] = @會員編號, [商品編號] = @商品編號, [訂購數量] = @訂購數量 WHERE (([會員編號] = @Original_會員編號) AND ((@IsNull_商品編號 = 1 AND [商品編號] IS NULL) OR ([商品編號] = @Original_商品編號)) AND ((@IsNull_訂購數量 = 1 AND [訂購數量] IS NULL) OR ([訂購數量] = @Original_訂購數量)));
SELECT 會員編號, 商品編號, 訂購數量 FROM 訂購 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_商品編號" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_訂購數量" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="會員編號" DataSetColumn="會員編號" />
              <Mapping SourceColumn="商品編號" DataSetColumn="商品編號" />
              <Mapping SourceColumn="訂購數量" DataSetColumn="訂購數量" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.訂購" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByKeyword" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByKeyword" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByKeyword">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          會員編號, 商品編號, 訂購數量
FROM              訂購
WHERE          (會員編號 LIKE @keyword) OR
                            (商品編號 LIKE @keyword) OR
                            (訂購數量 LIKE @keyword)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="keyword" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂購" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@keyword" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="dbo.訂購" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBysql" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBysql" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillBysql">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT          會員編號, 商品編號, 訂購數量
FROM              訂購
WHERE          (會員編號 LIKE @sql)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="sql" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂購" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@sql" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="謎鹿ConnectionString1 (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 訂購
                            (會員編號, 商品編號, 訂購數量)
VALUES          (@會員編號,@商品編號,@訂購數量); 
SELECT 會員編號, 商品編號, 訂購數量 FROM 訂購 WHERE (會員編號 = @會員編號)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="會員編號" ColumnName="會員編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂購" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@會員編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="會員編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="商品編號" ColumnName="商品編號" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂購" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@商品編號" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="商品編號" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="訂購數量" ColumnName="訂購數量" DataSourceName="[C:\USERS\奕穎\DOCUMENTS\資管\大三上\系分\謎鹿\謎鹿.MDF].dbo.訂購" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@訂購數量" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="訂購數量" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="謎鹿DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="謎鹿DataSet" msprop:Generator_UserDSName="謎鹿DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="商品" msprop:Generator_TableClassName="商品DataTable" msprop:Generator_TableVarName="table商品" msprop:Generator_RowChangedName="商品RowChanged" msprop:Generator_TablePropName="商品" msprop:Generator_RowDeletingName="商品RowDeleting" msprop:Generator_RowChangingName="商品RowChanging" msprop:Generator_RowEvHandlerName="商品RowChangeEventHandler" msprop:Generator_RowDeletedName="商品RowDeleted" msprop:Generator_RowClassName="商品Row" msprop:Generator_UserTableName="商品" msprop:Generator_RowEvArgName="商品RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="商品編號" msprop:Generator_ColumnVarNameInTable="column商品編號" msprop:Generator_ColumnPropNameInRow="商品編號" msprop:Generator_ColumnPropNameInTable="商品編號Column" msprop:Generator_UserColumnName="商品編號" type="xs:string" />
              <xs:element name="商品名稱" msprop:Generator_ColumnVarNameInTable="column商品名稱" msprop:Generator_ColumnPropNameInRow="商品名稱" msprop:Generator_ColumnPropNameInTable="商品名稱Column" msprop:Generator_UserColumnName="商品名稱" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="庫存數量" msprop:Generator_ColumnVarNameInTable="column庫存數量" msprop:Generator_ColumnPropNameInRow="庫存數量" msprop:Generator_ColumnPropNameInTable="庫存數量Column" msprop:Generator_UserColumnName="庫存數量" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="定價" msprop:Generator_ColumnVarNameInTable="column定價" msprop:Generator_ColumnPropNameInRow="定價" msprop:Generator_ColumnPropNameInTable="定價Column" msprop:Generator_UserColumnName="定價" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="種類" msprop:Generator_ColumnVarNameInTable="column種類" msprop:Generator_ColumnPropNameInRow="種類" msprop:Generator_ColumnPropNameInTable="種類Column" msprop:Generator_UserColumnName="種類" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="管理者編號" msprop:Generator_ColumnVarNameInTable="column管理者編號" msprop:Generator_ColumnPropNameInRow="管理者編號" msprop:Generator_ColumnPropNameInTable="管理者編號Column" msprop:Generator_UserColumnName="管理者編號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="會員" msprop:Generator_TableClassName="會員DataTable" msprop:Generator_TableVarName="table會員" msprop:Generator_TablePropName="會員" msprop:Generator_RowDeletingName="會員RowDeleting" msprop:Generator_RowChangingName="會員RowChanging" msprop:Generator_RowEvHandlerName="會員RowChangeEventHandler" msprop:Generator_RowDeletedName="會員RowDeleted" msprop:Generator_UserTableName="會員" msprop:Generator_RowChangedName="會員RowChanged" msprop:Generator_RowEvArgName="會員RowChangeEvent" msprop:Generator_RowClassName="會員Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="會員編號" msprop:Generator_ColumnVarNameInTable="column會員編號" msprop:Generator_ColumnPropNameInRow="會員編號" msprop:Generator_ColumnPropNameInTable="會員編號Column" msprop:Generator_UserColumnName="會員編號">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="帳號" msprop:Generator_ColumnVarNameInTable="column帳號" msprop:Generator_ColumnPropNameInRow="帳號" msprop:Generator_ColumnPropNameInTable="帳號Column" msprop:Generator_UserColumnName="帳號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="密碼" msprop:Generator_ColumnVarNameInTable="column密碼" msprop:Generator_ColumnPropNameInRow="密碼" msprop:Generator_ColumnPropNameInTable="密碼Column" msprop:Generator_UserColumnName="密碼" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="姓名" msprop:Generator_ColumnVarNameInTable="column姓名" msprop:Generator_ColumnPropNameInRow="姓名" msprop:Generator_ColumnPropNameInTable="姓名Column" msprop:Generator_UserColumnName="姓名" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="電話" msprop:Generator_ColumnVarNameInTable="column電話" msprop:Generator_ColumnPropNameInRow="電話" msprop:Generator_ColumnPropNameInTable="電話Column" msprop:Generator_UserColumnName="電話" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="住址" msprop:Generator_ColumnVarNameInTable="column住址" msprop:Generator_ColumnPropNameInRow="住址" msprop:Generator_ColumnPropNameInTable="住址Column" msprop:Generator_UserColumnName="住址" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="訂單" msprop:Generator_TableClassName="訂單DataTable" msprop:Generator_TableVarName="table訂單" msprop:Generator_TablePropName="訂單" msprop:Generator_RowDeletingName="訂單RowDeleting" msprop:Generator_RowChangingName="訂單RowChanging" msprop:Generator_RowEvHandlerName="訂單RowChangeEventHandler" msprop:Generator_RowDeletedName="訂單RowDeleted" msprop:Generator_UserTableName="訂單" msprop:Generator_RowChangedName="訂單RowChanged" msprop:Generator_RowEvArgName="訂單RowChangeEvent" msprop:Generator_RowClassName="訂單Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="訂單編號" msprop:Generator_ColumnVarNameInTable="column訂單編號" msprop:Generator_ColumnPropNameInRow="訂單編號" msprop:Generator_ColumnPropNameInTable="訂單編號Column" msprop:Generator_UserColumnName="訂單編號" type="xs:string" />
              <xs:element name="付款方式" msprop:Generator_ColumnVarNameInTable="column付款方式" msprop:Generator_ColumnPropNameInRow="付款方式" msprop:Generator_ColumnPropNameInTable="付款方式Column" msprop:Generator_UserColumnName="付款方式" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="取貨方式" msprop:Generator_ColumnVarNameInTable="column取貨方式" msprop:Generator_ColumnPropNameInRow="取貨方式" msprop:Generator_ColumnPropNameInTable="取貨方式Column" msprop:Generator_UserColumnName="取貨方式" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="訂單日期" msprop:Generator_ColumnVarNameInTable="column訂單日期" msprop:Generator_ColumnPropNameInRow="訂單日期" msprop:Generator_ColumnPropNameInTable="訂單日期Column" msprop:Generator_UserColumnName="訂單日期" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="會員編號" msprop:Generator_ColumnVarNameInTable="column會員編號" msprop:Generator_ColumnPropNameInRow="會員編號" msprop:Generator_ColumnPropNameInTable="會員編號Column" msprop:Generator_UserColumnName="會員編號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="購物車編號" msprop:Generator_ColumnVarNameInTable="column購物車編號" msprop:Generator_ColumnPropNameInRow="購物車編號" msprop:Generator_ColumnPropNameInTable="購物車編號Column" msprop:Generator_UserColumnName="購物車編號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="購物車" msprop:Generator_TableClassName="購物車DataTable" msprop:Generator_TableVarName="table購物車" msprop:Generator_TablePropName="購物車" msprop:Generator_RowDeletingName="購物車RowDeleting" msprop:Generator_RowChangingName="購物車RowChanging" msprop:Generator_RowEvHandlerName="購物車RowChangeEventHandler" msprop:Generator_RowDeletedName="購物車RowDeleted" msprop:Generator_UserTableName="購物車" msprop:Generator_RowChangedName="購物車RowChanged" msprop:Generator_RowEvArgName="購物車RowChangeEvent" msprop:Generator_RowClassName="購物車Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="會員編號" msprop:Generator_ColumnVarNameInTable="column會員編號" msprop:Generator_ColumnPropNameInRow="會員編號" msprop:Generator_ColumnPropNameInTable="會員編號Column" msprop:Generator_UserColumnName="會員編號">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="運費" msprop:Generator_ColumnVarNameInTable="column運費" msprop:Generator_ColumnPropNameInRow="運費" msprop:Generator_ColumnPropNameInTable="運費Column" msprop:Generator_UserColumnName="運費" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="總金額" msprop:Generator_ColumnVarNameInTable="column總金額" msprop:Generator_ColumnPropNameInRow="總金額" msprop:Generator_ColumnPropNameInTable="總金額Column" msprop:Generator_UserColumnName="總金額" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="購物車編號" msprop:Generator_ColumnVarNameInTable="column購物車編號" msprop:Generator_ColumnPropNameInRow="購物車編號" msprop:Generator_ColumnPropNameInTable="購物車編號Column" msprop:Generator_UserColumnName="購物車編號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="紀錄" msprop:Generator_TableClassName="紀錄DataTable" msprop:Generator_TableVarName="table紀錄" msprop:Generator_RowChangedName="紀錄RowChanged" msprop:Generator_TablePropName="紀錄" msprop:Generator_RowDeletingName="紀錄RowDeleting" msprop:Generator_RowChangingName="紀錄RowChanging" msprop:Generator_RowEvHandlerName="紀錄RowChangeEventHandler" msprop:Generator_RowDeletedName="紀錄RowDeleted" msprop:Generator_RowClassName="紀錄Row" msprop:Generator_UserTableName="紀錄" msprop:Generator_RowEvArgName="紀錄RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="訂單編號" msprop:Generator_ColumnVarNameInTable="column訂單編號" msprop:Generator_ColumnPropNameInRow="訂單編號" msprop:Generator_ColumnPropNameInTable="訂單編號Column" msprop:Generator_UserColumnName="訂單編號">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="商品編號" msprop:Generator_ColumnVarNameInTable="column商品編號" msprop:Generator_ColumnPropNameInRow="商品編號" msprop:Generator_ColumnPropNameInTable="商品編號Column" msprop:Generator_UserColumnName="商品編號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="訂購數量" msprop:Generator_ColumnVarNameInTable="column訂購數量" msprop:Generator_ColumnPropNameInRow="訂購數量" msprop:Generator_ColumnPropNameInTable="訂購數量Column" msprop:Generator_UserColumnName="訂購數量" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="價錢" msprop:Generator_ColumnVarNameInTable="column價錢" msprop:Generator_ColumnPropNameInRow="價錢" msprop:Generator_ColumnPropNameInTable="價錢Column" msprop:Generator_UserColumnName="價錢" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="訂購" msprop:Generator_TableClassName="訂購DataTable" msprop:Generator_TableVarName="table訂購" msprop:Generator_RowChangedName="訂購RowChanged" msprop:Generator_TablePropName="訂購" msprop:Generator_RowDeletingName="訂購RowDeleting" msprop:Generator_RowChangingName="訂購RowChanging" msprop:Generator_RowEvHandlerName="訂購RowChangeEventHandler" msprop:Generator_RowDeletedName="訂購RowDeleted" msprop:Generator_RowClassName="訂購Row" msprop:Generator_UserTableName="訂購" msprop:Generator_RowEvArgName="訂購RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="會員編號" msprop:Generator_ColumnVarNameInTable="column會員編號" msprop:Generator_ColumnPropNameInRow="會員編號" msprop:Generator_ColumnPropNameInTable="會員編號Column" msprop:Generator_UserColumnName="會員編號">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="商品編號" msprop:Generator_ColumnVarNameInTable="column商品編號" msprop:Generator_ColumnPropNameInRow="商品編號" msprop:Generator_ColumnPropNameInTable="商品編號Column" msprop:Generator_UserColumnName="商品編號" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="訂購數量" msprop:Generator_ColumnVarNameInTable="column訂購數量" msprop:Generator_ColumnPropNameInRow="訂購數量" msprop:Generator_ColumnPropNameInTable="訂購數量Column" msprop:Generator_UserColumnName="訂購數量" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:商品" />
      <xs:field xpath="mstns:商品編號" />
    </xs:unique>
    <xs:unique name="會員_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:會員" />
      <xs:field xpath="mstns:會員編號" />
    </xs:unique>
    <xs:unique name="訂單_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:訂單" />
      <xs:field xpath="mstns:訂單編號" />
    </xs:unique>
    <xs:unique name="購物車_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:購物車" />
      <xs:field xpath="mstns:會員編號" />
    </xs:unique>
    <xs:unique name="紀錄_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:紀錄" />
      <xs:field xpath="mstns:訂單編號" />
    </xs:unique>
    <xs:unique name="訂購_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:訂購" />
      <xs:field xpath="mstns:會員編號" />
    </xs:unique>
  </xs:element>
</xs:schema>