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

最新推荐文章于 2023-09-13 18:08:05 发布

weixin_33895016

最新推荐文章于 2023-09-13 18:08:05 发布

阅读量231

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/liyiyong/p/5134740.html

版权

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();

}

转载于:https://www.cnblogs.com/liyiyong/p/5134740.html