private DataSet QueryDataSetExec(QueryContext query) { SqlDataReader read = null; SqlCommand cmd = null; SqlDataAdapter adapter = null; try { this.sqlMutex.WaitOne(); query.Open(); cmd = this.InitCommand(query); adapter = new SqlDataAdapter(cmd); DataSet datas = new DataSet(); adapter.Fill(datas); adapter.Dispose(); cmd.Dispose(); adapter = null; query.Close(); return(datas); } catch (Exception e) { query.Close(e); throw; } finally { if (transac == null) { this.Close(); } this.sqlMutex.ReleaseMutex(); } }
private object QueryScalarExec(QueryContext query) { SqlDataReader read = null; SqlCommand cmd = null; try { this.sqlMutex.WaitOne(); query.Open(); cmd = this.InitCommand(query); object retourobj = cmd.ExecuteScalar(); cmd.Dispose(); query.Close(); return(retourobj); } catch (Exception e) { query.Close(e); throw; } finally { if (transac == null) { this.Close(); } this.sqlMutex.ReleaseMutex(); } }
private DataTable QueryExec(QueryContext query) { SqlDataReader read = null; SqlCommand cmd = null; SqlDataAdapter adapter = null; try { this.sqlMutex.WaitOne(); query.Open(); cmd = this.InitCommand(query); DataTable datas = new DataTable(); read = cmd.ExecuteReader(); datas.Load(read); read.Close(); read = null; cmd.Dispose(); if (datas != null) { query.CountResult = datas.Rows.Count; } query.Close(); return(datas); } catch (Exception e) { query.Close(e); throw; } finally { if (transac == null) { this.Close(); } this.sqlMutex.ReleaseMutex(); } }