/// <summary>
/// 获取DataTable
/// </summary>
/// <param name="key">
/// 数据库连接标示
/// </param>
/// <param name="sql">
/// sql语句
/// </param>
/// <param name="paras">
/// 参数
/// </param>
/// <returns>
/// </returns>
public static DataTable GetTable(string sql, SQLiteParameter[] sqlParam)
{
try
{
using (SQLiteConnection conn = MyConnection.GetSQLiteConnection())
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.CommandText = sql;
cmd.Connection = conn;
if (null != sqlParam)
{
cmd.Parameters.AddRange(sqlParam);
}
using (SQLiteDataAdapter da = new SQLiteDataAdapter())
{
da.SelectCommand = cmd;
using (DataTable ds = new DataTable())
{
if (conn != null && conn.State == ConnectionState.Open)
{
da.Fill(ds);
return(ds);
}
else
{
return(null);
}
}
}
}
}
}
catch (Exception e)
{
//MyLog.DalSqlite.Print.Error("Exception GetSQLiteDataReader" + command.SqlText, e);
return(null);
}
finally
{
}
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="command">
/// 数据操作设置
/// </param>
/// <returns>
/// </returns>
public static bool ExecuteNonQuery(List <string> sql, SQLiteParameter[] sqlParam)
{
SQLiteTransaction tran = null;
try
{
using (SQLiteConnection con = MyConnection.GetSQLiteConnection())
{
tran = con.BeginTransaction();
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = con;
foreach (var item in sql)
{
cmd.CommandText = item;
if (null != sqlParam)
{
cmd.Parameters.AddRange(sqlParam);
}
if (cmd.Connection != null && cmd.Connection.State == ConnectionState.Open)
{
cmd.ExecuteNonQuery();
}
}
tran.Commit();
}
}
return(true);
}
catch (Exception e)
{
tran.Rollback();
return(false);
}
finally
{
//command.Dispose();
}
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="command">
/// 数据操作设置
/// </param>
/// <returns>
/// </returns>
public static int ExecuteNonQuery(string sql, SQLiteParameter[] sqlParam)
{
try
{
int resu = 0;
using (SQLiteConnection con = MyConnection.GetSQLiteConnection())
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.CommandText = sql;
cmd.Connection = con;
if (null != sqlParam)
{
cmd.Parameters.AddRange(sqlParam);
}
if (cmd.Connection != null && cmd.Connection.State == ConnectionState.Open)
{
resu = cmd.ExecuteNonQuery();
}
else
{
resu = 0;
}
}
}
return(resu);
}
catch (Exception e)
{
//MyLog.DalSqlite.Print.Error("Exception ExecuteNonQuery" + command.SqlText, e);
return(0);
}
finally
{
//command.Dispose();
}
}