三层架构dal 层基本代码 非查询/查询

DAL 数据链路层 非查询/查询

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
public class sqlHelper //非查询
{

public static int baba(string sql,List<SqlParameter>paras)

{

SqlConnection conn = new SqlConnection("server=.;database=schoolido;uid=sa;pwd=123");
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddRange(paras.ToArray());
return cmd.ExecuteNonQuery();

}

}
}

public static DataTable name(string sql, List<SqlParameter> arr)
{
DataSet set = new DataSet();
SqlConnection conn = new SqlConnection(); //查询一批值
conn.Open();
SqlCommand dx = new SqlCommand(sql, conn);
dx.Parameters.AddRange(arr.ToArray());
SqlDataAdapter haha = new SqlDataAdapter(dx);
haha.Fill(set);
return set.Tables[0];





}
public static object name(string sql, List<SqlParameter> arr)
{

SqlConnection conn = new SqlConnection("");
SqlCommand dx = new SqlCommand(sql,conn); //查询一个值
dx.Parameters.Add(arr.ToArray());
return dx.ExecuteScalar();


}