物流管理系统-vs2008-sql2005

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  LogisticsManagementBLL
     目录           0  2010-06-17 01:09  LogisticsManagementBLLin
     目录           0  2010-06-17 17:19  LogisticsManagementBLLinDebug
     文件       22016  2010-06-18 23:31  LogisticsManagementBLLinDebugBLL.dll
     文件       42496  2010-06-18 23:31  LogisticsManagementBLLinDebugBLL.pdb
     文件        5632  2010-06-17 10:55  LogisticsManagementBLLinDebugDAL.dll
     文件       15872  2010-06-17 10:55  LogisticsManagementBLLinDebugDAL.pdb
     文件        5632  2010-06-18 21:18  LogisticsManagementBLLinDebugModel.dll
     文件        7680  2010-06-18 21:18  LogisticsManagementBLLinDebugModel.pdb
     文件        3261  2010-06-13 10:14  LogisticsManagementBLLBLL.csproj
     文件         269  2010-06-10 12:05  LogisticsManagementBLLBLL.csproj.vspscc
     文件        6210  2010-06-18 23:31  LogisticsManagementBLLCarrierBLL.cs
     文件        4708  2010-06-18 23:31  LogisticsManagementBLLCartBLL.cs
     文件        4942  2010-06-18 23:31  LogisticsManagementBLLCustomerBLL.cs
     文件        4492  2010-06-18 23:31  LogisticsManagementBLLDriverBLL.cs
     文件        5016  2010-06-18 23:31  LogisticsManagementBLLEmployeeBLL.cs
     文件        4883  2010-06-18 23:31  LogisticsManagementBLLFinancialBLL.cs
     文件        4129  2010-06-18 23:31  LogisticsManagementBLLFleetBLL.cs
     文件         235  2010-06-10 12:05  LogisticsManagementBLLmssccprj.scc
     目录           0  2010-06-17 01:09  LogisticsManagementBLLobj
     目录           0  2010-06-18 23:31  LogisticsManagementBLLobjDebug
     文件        2088  2010-06-18 23:30  LogisticsManagementBLLobjDebugBLL.csproj.FileListAbsolute.txt
     文件       22016  2010-06-18 23:31  LogisticsManagementBLLobjDebugBLL.dll
     文件       42496  2010-06-18 23:31  LogisticsManagementBLLobjDebugBLL.pdb
     目录           0  2010-06-18 21:11  LogisticsManagementBLLobjDebugRefactor
     文件        4608  2010-06-18 21:11  LogisticsManagementBLLobjDebugRefactorBLL.dll
     文件       17805  2010-06-18 21:18  LogisticsManagementBLLobjDebugResolveAssemblyReference.cache
     目录           0  2010-06-17 01:09  LogisticsManagementBLLobjDebugTempPE
     目录           0  2010-06-17 17:19  LogisticsManagementBLLProperties
     文件        1346  2010-06-02 15:29  LogisticsManagementBLLPropertiesAssemblyInfo.cs
............此处省略219个文件信息