using
System;
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel;
namespace DAL
{
///
/// 糸统用到的方法
///
public class ManageDAO
{
SqlConnection objConn;
public ManageDAO()
{
string conSQL=EtoonProductConfiguration.ConnectionString;
objConn=new SqlConnection(conSQL);
}
//执行
public bool ExecSQL(string str)
{
try
{
objConn.Open();
SqlCommand cmd=objConn.CreateCommand();
cmd.CommandText=str;
cmd.CommandTimeout=1000;
cmd.ExecuteNonQuery();
objConn.Close();
objConn.Dispose();
return true;
}
catch(SqlException e)
{
throw e;
}
}
//查询
public DataSet FindMange(string sql)
{
try
{
objConn.Open();
DataSet dt=new DataSet();
SqlDataAdapter da=new SqlDataAdapter(sql,objConn);
da.Fill(dt);
objConn.Close();
objConn.Dispose();
return dt;
}
catch(SqlException e)
{
throw e;
}
}
//执行存储过程,带输出参数
public string ExecuteProc1(string procName,SqlParameter []sp,SqlParameter out_sp)
{
objConn.Open();
SqlCommand sqlCmd = objConn.CreateCommand();
sqlCmd.CommandText = procName;
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
foreach(SqlParameter s in sp)
{
sqlCmd.Parameters.Add(s);
}
sqlCmd.Parameters.Add(out_sp);
out_sp.Direction=ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
objConn.Close();
return out_sp.Value.ToString();;
}
catch(SqlException ee)
{
throw ee;
}
}
//执行存储过程,返回真假(带参数)
public bool ExecuteProc(string procName,SqlParameter []sp)
{
objConn.Open();
SqlCommand sqlCmd = objConn.CreateCommand();
sqlCmd.CommandText = procName;
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
foreach(SqlParameter s in sp)
{
sqlCmd.Parameters.Add(s);
}
sqlCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch(SqlException ee)
{
throw ee;
}
}
//执行存储过程,返回真假(不带参数)
public bool ExecuteProc(string procName)
{
objConn.Open();
SqlCommand sqlCmd = objConn.CreateCommand();
sqlCmd.CommandText = procName;
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
sqlCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch(SqlException ee)
{
throw ee;
}
}
//执行存储过程,返回记录集
private DataSet FillClientproData(String commandText,SqlParameter[] prams)
{
objConn.Open();
SqlCommand command = objConn.CreateCommand();
command.CommandText = commandText;
command.CommandType = CommandType.StoredProcedure;
try
{
foreach (SqlParameter parameter in prams)
command.Parameters.Add(parameter);
SqlDataAdapter ds=new SqlDataAdapter(command);
DataSet data = new DataSet();
ds.Fill(data);
return data;
}
catch(SqlException ee)
{
throw ee;
}
}
}
}
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel;
namespace DAL
{
///
/// 糸统用到的方法
///
public class ManageDAO
{
SqlConnection objConn;
public ManageDAO()
{
string conSQL=EtoonProductConfiguration.ConnectionString;
objConn=new SqlConnection(conSQL);
}
//执行
public bool ExecSQL(string str)
{
try
{
objConn.Open();
SqlCommand cmd=objConn.CreateCommand();
cmd.CommandText=str;
cmd.CommandTimeout=1000;
cmd.ExecuteNonQuery();
objConn.Close();
objConn.Dispose();
return true;
}
catch(SqlException e)
{
throw e;
}
}
//查询
public DataSet FindMange(string sql)
{
try
{
objConn.Open();
DataSet dt=new DataSet();
SqlDataAdapter da=new SqlDataAdapter(sql,objConn);
da.Fill(dt);
objConn.Close();
objConn.Dispose();
return dt;
}
catch(SqlException e)
{
throw e;
}
}
//执行存储过程,带输出参数
public string ExecuteProc1(string procName,SqlParameter []sp,SqlParameter out_sp)
{
objConn.Open();
SqlCommand sqlCmd = objConn.CreateCommand();
sqlCmd.CommandText = procName;
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
foreach(SqlParameter s in sp)
{
sqlCmd.Parameters.Add(s);
}
sqlCmd.Parameters.Add(out_sp);
out_sp.Direction=ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
objConn.Close();
return out_sp.Value.ToString();;
}
catch(SqlException ee)
{
throw ee;
}
}
//执行存储过程,返回真假(带参数)
public bool ExecuteProc(string procName,SqlParameter []sp)
{
objConn.Open();
SqlCommand sqlCmd = objConn.CreateCommand();
sqlCmd.CommandText = procName;
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
foreach(SqlParameter s in sp)
{
sqlCmd.Parameters.Add(s);
}
sqlCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch(SqlException ee)
{
throw ee;
}
}
//执行存储过程,返回真假(不带参数)
public bool ExecuteProc(string procName)
{
objConn.Open();
SqlCommand sqlCmd = objConn.CreateCommand();
sqlCmd.CommandText = procName;
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
sqlCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch(SqlException ee)
{
throw ee;
}
}
//执行存储过程,返回记录集
private DataSet FillClientproData(String commandText,SqlParameter[] prams)
{
objConn.Open();
SqlCommand command = objConn.CreateCommand();
command.CommandText = commandText;
command.CommandType = CommandType.StoredProcedure;
try
{
foreach (SqlParameter parameter in prams)
command.Parameters.Add(parameter);
SqlDataAdapter ds=new SqlDataAdapter(command);
DataSet data = new DataSet();
ds.Fill(data);
return data;
}
catch(SqlException ee)
{
throw ee;
}
}
}
}