Winform简单三层架构考试系统附数据库文件

Winform简单三层架构考试系统

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace OnLineTest.DAL
{
    public class DBHelper
    {
        private static readonly string str = ConfigurationManager.ConnectionStrings[“OnLineTest“].ToString（）;

        /// 

        /// 增删改查
        /// 

        /// sql语句
        /// sql参数
        /// 行数
        public static int ExeCuteNonQuery（string sql params SqlParameter[] parm）
        {
            using （SqlConnection conn = new SqlConnection（str））
            {
                using （SqlCommand comm = new SqlCommand（sql conn））
                {

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2016-10-26 19:45  OnLineTest.BLL\
     文件         789  2016-10-26 19:45  OnLineTest.BLL\ErrorBLL.cs
     文件        3054  2016-10-26 19:46  OnLineTest.BLL\OnLineTest.BLL.csproj
     目录           0  2016-10-23 12:01  OnLineTest.BLL\Properties\
     文件        1352  2016-10-19 08:34  OnLineTest.BLL\Properties\AssemblyInfo.cs
     文件        2947  2016-10-26 08:59  OnLineTest.BLL\QuestionInfoBLL.cs
     文件        1036  2016-10-26 10:32  OnLineTest.BLL\ScoreBLL.cs
     文件         406  2016-10-26 09:27  OnLineTest.BLL\TimeBLL.cs
     文件        2108  2016-10-25 14:48  OnLineTest.BLL\UserInfoBLL.cs
     目录           0  2016-10-23 12:01  OnLineTest.BLL\bin\
     目录           0  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\
     文件        6656  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\OnLineTest.BLL.dll
     文件       24064  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\OnLineTest.BLL.pdb
     文件       13824  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\OnLineTest.DAL.dll
     文件       30208  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\OnLineTest.DAL.pdb
     文件        8192  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\OnLineTest.Model.dll
     文件        7680  2016-10-27 20:35  OnLineTest.BLL\bin\Debug\OnLineTest.Model.pdb
     目录           0  2016-10-27 20:36  OnLineTest.BLL\bin\Release\
     目录           0  2016-10-23 12:01  OnLineTest.BLL\obj\
     目录           0  2016-10-27 20:35  OnLineTest.BLL\obj\Debug\
     文件        6555  2016-10-26 08:12  OnLineTest.BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
     文件        1839  2016-10-27 20:35  OnLineTest.BLL\obj\Debug\OnLineTest.BLL.csproj.FileListAbsolute.txt
     文件       10161  2016-10-27 20:35  OnLineTest.BLL\obj\Debug\OnLineTest.BLL.csprojResolveAssemblyReference.cache
     文件        6656  2016-10-27 20:35  OnLineTest.BLL\obj\Debug\OnLineTest.BLL.dll
     文件       24064  2016-10-27 20:35  OnLineTest.BLL\obj\Debug\OnLineTest.BLL.pdb
     目录           0  2016-10-27 20:36  OnLineTest.BLL\obj\Debug\TempPE\
     文件           0  2016-10-19 08:34  OnLineTest.BLL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
     文件           0  2016-10-19 08:34  OnLineTest.BLL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
     文件           0  2016-10-19 08:34  OnLineTest.BLL\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
     目录           0  2016-10-23 12:01  OnLineTest.DB\
     文件     6291456  2016-10-27 20:36  OnLineTest.DB\OnLineTest.mdf
............此处省略140个文件信息