/// <summary>
/// 根据sql语句得到 DataTable
/// </summary>
/// <param name="strSql">sql语句</param>
/// <returns>DataTable</returns>
public static DataTable GetDatatableBySql(string strSql)
{
DataTable dt = new DataTable();
string strConn = SqlDataHelper.GetConnectionString();
using (SqlConnection connection = new SqlConnection(strConn))
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlCommand command = new SqlCommand(strSql, connection);
command.CommandTimeout = iTimeOut;
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dt);
}
return(dt);
}
//public static void Execute()
//{
// string connectionString = SqlDataHelper.GetConnectionString();
// using (SqlConnection connection = new SqlConnection(connectionString))
// {
// connection.Open();
// SqlTransaction transaction;
// using (SqlCommand cmd = connection.CreateCommand())
// {
// //启动事务
// transaction = connection.BeginTransaction();
// cmd.Connection = connection;
// cmd.Transaction = transaction;
// try
// {
// cmd.CommandText = "sql语句！";
// cmd.ExecuteNonQuery();
// //完成提交
// transaction.Commit();
// }
// catch (Exception ex)
// {
// //数据回滚
// transaction.Rollback();
// throw ex;
// }
// }
// }
//}
/// <summary>
/// 执行增删改，返回受影响的行数
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql)
{
int i = 0;
string strConn = SqlDataHelper.GetConnectionString();
using (SqlConnection connection = new SqlConnection(strConn))
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlCommand command = new SqlCommand(sql, connection);
command.CommandTimeout = iTimeOut;
i = command.ExecuteNonQuery();
connection.Close();
}
return(i);
}
public static string GetConnectionString()
{
return(SqlDataHelper.GetConnectionString("HozestERPConnectionString"));
}
