using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Data.SqlClient;
using?System.Linq;
using?System.Web;
using?System.Web.Services;

namespace?webServiceShopping
{
????///?

????///?serviceShopping?的摘要說明
????///?

????[WebService（Namespace?=?“http://tempuri.org/“）]
????[WebServiceBinding（ConformsTo?=?WsiProfiles.BasicProfile1_1）]
????[System.ComponentModel.ToolboxItem（false）]
????//?若要允許使用?ASP.NET?AJAX?從腳本中調用此?Web?服務，請取消注釋以下行。?
????//?[System.Web.script.Services.scriptService]
????//web?service代碼
????????public?class?serviceShopping?:?System.Web.Services.WebService
????{
????????[WebMethod]
????????//獲取商品
????????public?DataSet?getGoods（）
????????{
????????????SqlConnection?con?=?new?SqlConnection（“server=.;database=shop;uid=sa;pwd=123456;“）;
????????????con.Open（）;
????????????SqlDataAdapter?adr?=?new?SqlDataAdapter（）;
????????????adr.SelectCommand?=?new?SqlCommand（“select?*?from?goods“?con）;
????????????DataSet?ds?=?new?DataSet（）;
????????????adr.Fill（ds?“goods“）;
????????????con.Close（）;
????????????return?ds;
????????}
????????[WebMethod]
????????//購物
????????public?string?shopping（int?sum）
????????{
????????????try
????????????{
????????????????//買家買東西
????????????????this.buy（sum）;
????????????????//賣家賣東西
????????????????this.sell（sum）;
????????????????return?“交易成功消費：“+sum;
????????????}
????????????catch
????????????{
????????????????return?“交易失敗“;
????????????}
????????}
????????//買家買東西
????????private?void?buy（int?sum）
????????{
????????????SqlConnection?con?=?new?SqlConnection（“server=.;database=shop;uid=sa;pwd=123456;“）;
????????????con.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（“update?buy?set?money=money-“?+?sum.ToString（）?+?“?where??buyer=‘A‘“?con）;
????????????cmd.ExecuteNonQuery（）;
????????????con.Close（）;
????????}
????????//賣家賣東西
????????private?void?sell（int?sum）
????????{
????????????SqlConnection?con?=?new?SqlConnection（“server=.;database=shop;uid=sa;pwd=123456;“）;
????????????con.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（“update?sell?set?money=money+“?+?sum.ToString（）?+?“?where??seller=‘B‘“?con）;
????????????cmd.ExecuteNonQuery（）;
????????????con.Close（）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-05-07?22:26??web服務的建立和引用——模擬網上購物\
?????目錄???????????0??2014-05-07?21:13??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\
?????目錄???????????0??2014-05-07?22:25??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\
?????目錄???????????0??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Properties\
?????文件????????1344??2014-05-07?21:13??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Properties\AssemblyInfo.cs
?????目錄???????????0??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Properties\DataSources\
?????文件?????????599??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Properties\DataSources\System.Data.DataSet.datasource
?????目錄???????????0??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\
?????目錄???????????0??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\
?????文件????????3624??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\Reference.cs
?????文件????????1842??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\Reference.svcmap
?????文件????????1464??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\configuration.svcinfo
?????文件???????19776??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\configuration91.svcinfo
?????文件?????????735??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\serviceShopping.disco
?????文件????????4598??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Service?References\myserviceShopping\serviceShopping.wsdl
?????文件?????????613??2014-05-07?22:25??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\UseServerShopping.aspx
?????文件????????1684??2014-05-07?22:25??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\UseServerShopping.aspx.cs
?????文件????????1524??2014-05-07?21:29??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\UseServerShopping.aspx.designer.cs
?????文件????????1245??2014-05-07?21:13??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Web.Debug.config
?????文件????????1306??2014-05-07?21:13??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Web.Release.config
?????文件?????????870??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\Web.config
?????文件????????6331??2014-05-07?21:27??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\WebUseServiceShopping.csproj
?????文件????????1086??2014-05-07?21:27??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\WebUseServiceShopping.csproj.user
?????目錄???????????0??2014-05-07?21:28??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\bin\
?????文件????????7168??2014-05-07?22:27??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\bin\WebUseServiceShopping.dll
?????文件?????????870??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\bin\WebUseServiceShopping.dll.config
?????文件???????17920??2014-05-07?22:27??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\bin\WebUseServiceShopping.pdb
?????目錄???????????0??2014-05-07?21:13??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\obj\
?????目錄???????????0??2014-05-07?22:27??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\obj\Debug\
?????文件????????9711??2014-05-07?22:27??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2014-05-07?21:26??web服務的建立和引用——模擬網上購物\WebUseServiceShopping\WebUseServiceShopping\obj\Debug\TempPE\
............此處省略39個文件信息