libraytest.cs

我的一个Ado.Net一个框架设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace BLL
{
    public class LibrayTest
    {
        string connString = new DAL.ConnectionSring().SqlConnectionString;
        public DataTable GetStudent()
        {
            string sql = "Select * from Student";
            DataTable dt = DAL.SQLHelper.ExecuteTable(connString, CommandType.Text, sql, null);
            return dt;
        }
        public void BatchUpdate(DataTable dt)
        {
            string[] setColumn = new string[] {"Name","Adress" };
            string[] setWhere = new string[] { "Id"};
            SqlParameter[] sqlParam = new SqlParameter[] { 
                new SqlParameter("@Name",SqlDbType.VarChar,50,"Name"),
                new SqlParameter("@Id",SqlDbType.Int,4,"Id"),
                new SqlParameter("@Adress",SqlDbType.VarChar,50,"Adress")
            };
            DAL.BatchHelper.BatchUpdate(connString, dt, 50, setColumn, setWhere, sqlParam);
        }

        public void BatchInsert(DataTable addingTable)
        {
            SqlParameter[] columnInfo = new SqlParameter[] { 
                new SqlParameter("@Name",SqlDbType.VarChar,50,"Name"),
                new SqlParameter("@Birthday",SqlDbType.DateTime,1,"Birthday"),//日期类型中的size没用
                new SqlParameter("@Adress",SqlDbType.VarChar,100,"Adress")
            };
            DAL.BatchHelper.BatchInsert(connString, addingTable, 50, columnInfo);
        }
        public void BatchDelete(DataTable dt)
        {
            string[] whereColumn = new string[] { "Id"};
            SqlParameter[] columnInfo = new SqlParameter[] {
                new SqlParameter("@Id",SqlDbType.Int,4,"Id")
            };
            DAL.BatchHelper.BatchDelete(connString, dt, 50, whereColumn, columnInfo);
        }
    }
}