物流管理系统-vs2008-sql2005

用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  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个文件信息