using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
using?DAL;
using?Model;

namespace?BLL
{
????public?static?class?CarrierBLL
????{
????????static?SqlCommand?cmd;
????????///?

????????///?
????????///?

????????///?
????????public?static?DataTable?GetList（）
????????{

????????????cmd?=?new?SqlCommand（“select?*?from?TB_CarrierInformation“）;

????????????return?DBSQL.QueryData（cmd）.Tables[0];
????????}
????????///?

????????///?模糊查詢承運單信息
????????///?

????????///?
????????public?static?DataTable?SearchList（string?id）
????????{

????????????cmd?=?new?SqlCommand（“select?*?from?TB_CarrierInformation?where?CarrierID?like?‘%“?+?id?+?“%‘“）;

????????????return?DBSQL.QueryData（cmd）.Tables[0];
????????}
????????///?

????????///?
????????///?

????????///?
????????///?
????????public?static?DataTable?GetListByID（string?id）
????????{

????????????cmd?=?new?SqlCommand（“select?*?from?TB_CarrierInformation?where?CarrierID=‘“?+?id?+?“‘“）;

????????????return?DBSQL.QueryData（cmd）.Tables[0];
????????}
????????public?static?bool?Delete（string?id）
????????{
????????????cmd?=?new?SqlCommand（“delete?from?TB_CarrierInformation?where?CarrierID=‘“?+?id?+?“‘“）;
????????????if?（DBSQL.ExecuteSQL（cmd）?>?0）
????????????????return?true;
????????????else
????????????????return?false;
????????}
????????///?

????????///?更新承運單信息
????????///?

????????///?承運單編號
????????///?
????????public?static?bool?Update（CarrierInformation?Carrier）
????????{
????????????StringBuilder?txtcmd?=new?StringBuilder?（“UPDATE?TB_CarrierInformation?SET?“）;???????????
????????????txtcmd.Append（“CarrierDate=‘“?+?Carrier.CarrierDate?+?“‘“）;
????????????txtcmd.Append（“GoodsStart=‘“?+?Carrier.GoodsStart?+?“‘“）;
????????????txtcmd.Append（“GoodsEnd=‘“?+?Carrier.GoodsEnd?+?“‘“）;
????????????txtcmd.Append（“ShipperName=‘“?+?Carrier.ShipperName?+?“‘“）;
????????????txtcmd.Append（“ShipperTell=‘“?+?Carrier.ShipperTell?+?“‘“）;
????????????txtcmd.Append（“ShipperAddr=‘“?+?Carrier.ShipperAddr?+?“‘“）;
????????????txtcmd.Append（“AddresseeAddr=‘“?+?Carrier.AddresseeAddr?+?“‘“）;
????????????txtcmd.Append（“ConsigneeName=‘“?+?Carrier.ConsigneeName?+?“‘“）;
????????????txtcmd.Append（“ConsigneeTell=‘“?+?Carrier.ConsigneeTell?+?“‘“）;
????????????txtcmd.Append（“ConsigneeAddr=‘“?+?Carrier.ConsigneeAddr?+?“‘“）;
????????????txtcmd.Append（“TranCartNum=‘“?+?Carrier.TranCartNum?+?“‘“）;
????????????txtcmd.Append（“Number=‘“?+?Carrier.Number?+?“‘“）;
????????????txtcmd.Append（“Charge=“?+?Carrier.Charge?+?““）;
????????????txtcmd.Append（“PayMent=“?+?Carrier.PayMent?+?““）;
????????????txtcmd.Append（“Formalities=“?+?Carrier.Formalities?+?““）;
????????????txtcmd.Append（“MatC

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-06-19?11:41??LogisticsManagement\
?????目錄???????????0??2010-06-18?23:31??LogisticsManagement\BLL\
?????目錄???????????0??2010-06-17?01:09??LogisticsManagement\BLL\bin\
?????目錄???????????0??2010-06-17?17:19??LogisticsManagement\BLL\bin\Debug\
?????文件???????22016??2010-06-18?23:31??LogisticsManagement\BLL\bin\Debug\BLL.dll
?????文件???????42496??2010-06-18?23:31??LogisticsManagement\BLL\bin\Debug\BLL.pdb
?????文件????????5632??2010-06-17?10:55??LogisticsManagement\BLL\bin\Debug\DAL.dll
?????文件???????15872??2010-06-17?10:55??LogisticsManagement\BLL\bin\Debug\DAL.pdb
?????文件????????5632??2010-06-18?21:18??LogisticsManagement\BLL\bin\Debug\Model.dll
?????文件????????7680??2010-06-18?21:18??LogisticsManagement\BLL\bin\Debug\Model.pdb
?????文件????????3261??2010-06-13?10:14??LogisticsManagement\BLL\BLL.csproj
?????文件?????????269??2010-06-10?12:05??LogisticsManagement\BLL\BLL.csproj.vspscc
?????文件????????6210??2010-06-18?23:31??LogisticsManagement\BLL\CarrierBLL.cs
?????文件????????4708??2010-06-18?23:31??LogisticsManagement\BLL\CartBLL.cs
?????文件????????4942??2010-06-18?23:31??LogisticsManagement\BLL\CustomerBLL.cs
?????文件????????4492??2010-06-18?23:31??LogisticsManagement\BLL\DriverBLL.cs
?????文件????????5016??2010-06-18?23:31??LogisticsManagement\BLL\EmployeeBLL.cs
?????文件????????4883??2010-06-18?23:31??LogisticsManagement\BLL\FinancialBLL.cs
?????文件????????4129??2010-06-18?23:31??LogisticsManagement\BLL\FleetBLL.cs
?????文件?????????235??2010-06-10?12:05??LogisticsManagement\BLL\mssccprj.scc
?????目錄???????????0??2010-06-17?01:09??LogisticsManagement\BLL\obj\
?????目錄???????????0??2010-06-18?23:31??LogisticsManagement\BLL\obj\Debug\
?????文件????????2088??2010-06-18?23:30??LogisticsManagement\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件???????22016??2010-06-18?23:31??LogisticsManagement\BLL\obj\Debug\BLL.dll
?????文件???????42496??2010-06-18?23:31??LogisticsManagement\BLL\obj\Debug\BLL.pdb
?????目錄???????????0??2010-06-18?21:11??LogisticsManagement\BLL\obj\Debug\Refactor\
?????文件????????4608??2010-06-18?21:11??LogisticsManagement\BLL\obj\Debug\Refactor\BLL.dll
?????文件???????17805??2010-06-18?21:18??LogisticsManagement\BLL\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2010-06-17?01:09??LogisticsManagement\BLL\obj\Debug\TempPE\
?????目錄???????????0??2010-06-17?17:19??LogisticsManagement\BLL\Properties\
?????文件????????1346??2010-06-02?15:29??LogisticsManagement\BLL\Properties\AssemblyInfo.cs
............此處省略219個文件信息