# 永职汪意到此一游，宣布我最帅 #

# 永州我罗树坪一片天 #

# 卡 #

# using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;

namespace DAL
{
public class DBHelper
{
private static string DBConnectString="server=.;database=DBsong;uid=sa;pwd=123456;";
private static SqlConnection conn;
private static SqlDataAdapter da;
private static SqlCommand cmd;
private static DBHelper dBHelper;

public DBHelper()
{
conn = new SqlConnection(DBConnectString);
}

public static DBHelper Instance()
{
if(dBHelper==null)
{
dBHelper = new DBHelper();
}
return dBHelper;
}

void DBOpen()
{
if(conn.State== ConnectionState.Closed)
{
conn.Open();
}
}
void DBClose()
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}

public DataTable GetDataTableBySql(string sql)
{
DBOpen();
DataTable dt = new DataTable();
da = new SqlDataAdapter(sql, conn);
try
{
da.Fill(dt);
return dt;
}
catch
{
return null;
}
finally
{
DBClose();
}
}

public bool ExcuteSql(string sql)
{
DBOpen();
cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
DBClose();
}
}

public bool ExcuteProcedure(string proName,SqlParameter[] paras)
{
DBOpen();
cmd = new SqlCommand(proName,conn);
cmd.CommandType = CommandType.StoredProcedure;
for(int i=0;i< paras.Length;i++)
{
cmd.Parameters.Add(paras[i]);
}
try
{
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
DBClose();
}

}

}
} #

# 曹尼玛 #