用SQLHelper类对数据库进行增删改查+C#3层架构开发

开发时建议用SQLHelper类，因为此类对数据库操作的方法进行了封装，开发时，只需要反复调用就可以了。提高重用性。

using CustomerManagementSystem.DAL;
using CustomerManagementSystem.Model;
namespace CustomerManagementSystem.BLL
{
    public class CustomerBLL
    {
        CustomerDAL customerDAL = new CustomerDAL（）;
        public int  Login（UserInfo user）
        {
            int  count =customerDAL.UserLogin（user）;

            return count;

        }
        //全部数据   
        public void Insert（Customer customer）
        {
            customerDAL.Insert（customer）;
        }
        public void Delete（int id）
        {
            customerDAL.DeleteById（id）;
        }
        public void Update（Customer customer）
        {
            customerDAL.Update（customer）;
        }
        public object LoadGetAllData（）
        {
            object a = customerDAL.GetAllData（）;

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

    ..A..H.    146432  2017-05-19 16:36  相关文件\CustomerManagementSystem.UI\.vs\CustomerManagementSystem.UI\v14\.suo

     文件       5632  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\bin\Debug\CustomerManagementSystem.Bll.dll

     文件      13824  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\bin\Debug\CustomerManagementSystem.Bll.pdb

     文件      11776  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\bin\Debug\CustomerManagementSystem.Dal.dll

     文件      19968  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\bin\Debug\CustomerManagementSystem.Dal.pdb

     文件       6656  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\bin\Debug\CustomerManagementSystem.Model.dll

     文件      17920  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\bin\Debug\CustomerManagementSystem.Model.pdb

     文件       1487  2017-05-19 15:25  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\CustomerBLL.cs

     文件       3016  2017-05-16 18:22  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\CustomerManagementSystem.BLL.csproj

     文件       2567  2017-05-17 09:42  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\CustomerManagementSystem.Bll.csproj.FileListAbsolute.txt

     文件      15024  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\CustomerManagementSystem.BLL.csprojResolveAssemblyReference.cache

     文件       5632  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\CustomerManagementSystem.Bll.dll

     文件      13824  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\CustomerManagementSystem.Bll.pdb

     文件       7129  2017-05-17 09:39  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件          0  2017-05-12 14:52  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

     文件          0  2017-05-12 14:52  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

     文件          0  2017-05-12 14:52  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

     文件       1364  2017-05-12 14:52  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Bll\Properties\AssemblyInfo.cs

     文件      11776  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\bin\Debug\CustomerManagementSystem.Dal.dll

     文件      19968  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\bin\Debug\CustomerManagementSystem.Dal.pdb

     文件       6656  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\bin\Debug\CustomerManagementSystem.Model.dll

     文件      17920  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\bin\Debug\CustomerManagementSystem.Model.pdb

     文件       6976  2017-05-19 15:26  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\CustomerDAL.cs

     文件       2915  2017-05-15 18:17  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\CustomerManagementSystem.DAL.csproj

     文件       2013  2017-05-17 10:43  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\obj\Debug\CustomerManagementSystem.Dal.csproj.FileListAbsolute.txt

     文件       7386  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\obj\Debug\CustomerManagementSystem.DAL.csprojResolveAssemblyReference.cache

     文件      11776  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\obj\Debug\CustomerManagementSystem.Dal.dll

     文件      19968  2017-05-19 16:11  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\obj\Debug\CustomerManagementSystem.Dal.pdb

     文件       7206  2017-05-17 09:39  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件          0  2017-05-12 14:52  相关文件\CustomerManagementSystem.UI\CustomerManagementSystem.Dal\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

............此处省略120个文件信息