using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace DAL
{
public class DBHelper
{
private readonly static string connection =”Data Source=.;Initial Catalog=Test;User ID=sa;pwd=123321”;
}
/// <summary>
/// 存储过程增删改
/// </summary>
/// <param name="type"></param>
/// <param name="procSql"></param>
/// <param name="par"></param>
/// <returns></returns>
public int SqlExec(CommandType type,string proSql,SqlParameter[] par)
{
//异常处理机制
try
{
using(Sqlconnection conn = new SqlConnection(connection))
{
conn.Open();
Sqlcommand cmd = new SqlCommand(proSql,conn);
cmd.CommandType = Type;
if(par!=null){
cmd.Parameters.AddRange(par);
}
return cmd.ExecuteNonQuery();
}
}
catch
{
return -1;
}
}
/// <summary>
/// 存储过程调用
/// </summary>
/// <param name="procName"></param>
/// <param name="par"></param>
/// <returns></returns>
public DataTable GetProDataTable(CommandType Type,string proName,SqlParameter[] par)
{
try
{
using(SqlConnction conn = new SqlConnection(connection))
{
SqlCommand command = new SqlCommand(procName, conn); //执行SQL语句
command.CommandType = type;
if (par != null)
{
command.Parameters.AddRange(par);
}
SqlDataAdapter sda = new SqlDataAdapter(command); //适配器
DataTable dt = new DataTable(); //NEW DataTable
dt.TableName = "dt";
sda.Fill(dt); //填充数据
return dt;
}
}
catch(Exception){return null;}
}
}