using?System;
using?System.Linq;
using?System.Web;
using?System.Web.Services;
using?System.Web.Services.Protocols;
using?System.xml.Linq;
using?System.Data.SqlClient;
[WebService（Namespace?=?“http://tempuri.org/“）]
[WebServiceBinding（ConformsTo?=?WsiProfiles.BasicProfile1_1）]
//?若要允許使用?ASP.NET?AJAX?從腳本中調用此?Web?服務，請取消對下行的注釋。
//?[System.Web.script.Services.scriptService]
public?class?Service?:?System.Web.Services.WebService
{
????public?Service（）
????{

????????//如果使用設計的組件，請取消注釋以下行?
????????//InitializeComponent（）;?
????}

????[WebMethod]
????public?int?pay（string?userID?int?Money）
????{
????????if?（giveMoney（userID?Money）?==?0）
????????{
????????????return?0;
????????}
????????else
????????{
???????????return?getMoney（（Money））;
???????????
????????}

????}
????public?int?giveMoney（string?userID?int?Money）
????{
????????int?money?=?0;
????????SqlConnection?con?=?new?SqlConnection（“server=WTJ-PC\\SQLEXPRESS;database=shop;uid=sa;password=123“）;
????????con.Open（）;
????????string?sql?=?“select??*?from?users?where?userID=‘“?+?userID?+?“‘“;
????????SqlCommand?sqlCmd?=?new?SqlCommand（sql?con）;
????????SqlDataReader?dr?=?sqlCmd.ExecuteReader（）;
????????if?（dr.Read（））
????????{
????????????money=int.Parse（dr[“money“].ToString（））;?
????????}
????????con.Close（）;
????????if?（money?<=?Money?||?money?<=?0）
????????{
????????????return?0;
????????}
????????else
????????{
????????????money?-=?Money;
????????}
????????con.Open（）;
????????sql?=?“update?users?set?money=‘“?+?money?+?“‘?where?userID=‘“?+?userID?+?“‘“;
????????sqlCmd?=?new?SqlCommand（sql?con）;
????????sqlCmd.ExecuteNonQuery（）;
????????con.Close（）;
????????return?1;

????}

????public?int?getMoney（int?Money）
????{
????????int?money?=?0;
????????SqlConnection?con?=?new?SqlConnection（“server=WTJ-PC\\SQLEXPRESS;database=shop;uid=sa;password=123“）;
????????con.Open（）;
????????string?sql?=?“select??*?from?users?where?userID=‘456‘“;
????????SqlCommand?sqlCmd?=?new?SqlCommand（sql?con）;
????????SqlDataReader?dr?=?sqlCmd.ExecuteReader（）;
????????if?（dr.Read（））
????????{
?????????????money?=?int.Parse（dr[“money“].ToString（））;
????????}
????????con.Close（）;
????????money?+=?Money;
????????con.Open（）;
????????sql?=?“update?users?set?money=‘“?+?money?+?“‘?where?userID=‘456‘“;
????????sqlCmd?=?new?SqlCommand（sql?con）;
????????sqlCmd.ExecuteNonQuery（）;
????????con.Close（）;
????????return?1;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-12-22?03:00??我的購物車\
?????目錄???????????0??2011-12-22?03:00??我的購物車\Data\
?????文件?????3145728??2011-12-22?03:00??我的購物車\Data\shopping.mdf
?????文件?????1048576??2011-12-22?03:00??我的購物車\Data\shopping_log.ldf
?????目錄???????????0??2011-12-18?15:14??我的購物車\paid\
?????目錄???????????0??2011-12-18?15:14??我的購物車\paid\App_Code\
?????文件????????2554??2011-12-06?20:19??我的購物車\paid\App_Code\Service.cs
?????目錄???????????0??2012-01-20?01:37??我的購物車\paid\App_Data\
?????文件??????????87??2008-01-11?20:32??我的購物車\paid\Service.asmx
?????文件????????8068??2011-12-05?10:26??我的購物車\paid\web.config
?????目錄???????????0??2011-12-24?20:44??我的購物車\shop\
?????目錄???????????0??2011-12-18?14:50??我的購物車\shop\App_Code\
?????文件?????????998??2011-11-20?13:29??我的購物車\shop\App_Code\Goods.cs
?????文件????????1403??2011-11-20?19:19??我的購物車\shop\App_Code\OperateDatabase.cs
?????目錄???????????0??2011-12-18?14:50??我的購物車\shop\App_WebReferences\
?????目錄???????????0??2011-12-18?14:50??我的購物車\shop\App_WebReferences\localhost\
?????文件?????????707??2011-12-06?20:02??我的購物車\shop\App_WebReferences\localhost\Service.disco
?????文件?????????578??2011-12-06?20:02??我的購物車\shop\App_WebReferences\localhost\Service.discomap
?????文件????????2955??2011-12-06?20:02??我的購物車\shop\App_WebReferences\localhost\Service.wsdl
?????文件?????????595??2011-12-24?20:44??我的購物車\shop\Default.aspx
?????文件?????????679??2011-12-24?20:44??我的購物車\shop\Default.aspx.cs
?????文件?????????940??2011-11-23?08:11??我的購物車\shop\Global.asax
?????文件????????7112??2011-11-22?21:50??我的購物車\shop\Tshirt.aspx
?????文件????????6240??2011-11-23?08:41??我的購物車\shop\Tshirt.aspx.cs
?????文件????????8024??2011-12-06?20:02??我的購物車\shop\Web.Config
?????文件????????7453??2011-12-05?10:38??我的購物車\shop\car.aspx
?????文件????????5008??2011-12-06?20:11??我的購物車\shop\car.aspx.cs
?????文件????????7110??2011-11-22?21:46??我的購物車\shop\coat.aspx
?????文件????????6238??2011-11-23?08:41??我的購物車\shop\coat.aspx.cs
?????文件????????7109??2011-11-22?21:49??我的購物車\shop\hat.aspx
?????文件????????6236??2011-11-23?08:41??我的購物車\shop\hat.aspx.cs
............此處省略89個文件信息