public DataSet SelectinDataSet()
{
string sTableName = null;
//string sTableName = "BankMaster";
int nfrom = 0, nChars = 0;
nfrom = this.sQry.ToLower().IndexOf("from");
nfrom += 5;
nChars = sQry.IndexOf(" ", nfrom);
if (nChars >= 0)
{
nChars = nChars - nfrom;
}
else
{
nChars = sQry.Length - nfrom;
}
sTableName = this.sQry.Substring(nfrom, nChars);
try
{
_Parameters ColParam = dbParameters;
SqlCommand dComm = new SqlCommand(this.sQry, oConn);
for (int i = 0; i < ColParam.Count; i++)
{
if (ColParam.Item(i).ParamType == -1)
{
dComm.Parameters.Add(new SqlParameter(ColParam.Item(i).ParamName, ColParam.Item(i).ParamValue));
}
else if (ColParam.Item(i).ParamSize == -1)
{
dComm.Parameters.Add(new SqlParameter(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType));
}
else
{
dComm.Parameters.Add(new SqlParameter(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType, ColParam.Item(i).ParamSize));
}
dComm.Parameters[ColParam.Item(i).ParamName].Value = ColParam.Item(i).ParamValue;
}
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dComm;
DataSet ds = new DataSet();
da.Fill(ds, sTableName);
return(ds);
}
catch (Exception e)
{
System.Diagnostics.Debug.Write(e.Message);
return(null);
}
finally
{
oConn.Close();
SqlConnection.ClearAllPools();
}
}
public int ExecuteNonQuery()
{
try
{
_Parameters ColParam = dbParameters;
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
SqlCommand dComm = new SqlCommand(this.sQry, oConn);
if (trans != null)
{
dComm.Transaction = trans;
}
for (int i = 0; i < ColParam.Count; i++)
{
if (ColParam.Item(i).ParamType == -1)
{
dComm.Parameters.Add(ColParam.Item(i).ParamName, ColParam.Item(i).ParamValue);
}
else if (ColParam.Item(i).ParamSize == -1)
{
dComm.Parameters.Add(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType);
}
else
{
dComm.Parameters.Add(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType, ColParam.Item(i).ParamSize);
}
if (ColParam.Item(i).ParamValue == "" && ColParam.Item(i).ParamType == (int)SqlDbType.DateTime)
{
dComm.Parameters[ColParam.Item(i).ParamName].Value = System.Data.SqlTypes.SqlDateTime.Null;
}
else
{
dComm.Parameters[ColParam.Item(i).ParamName].Value = ColParam.Item(i).ParamValue;
}
}
int nRet = dComm.ExecuteNonQuery();
return(nRet);
}
catch (Exception e)
{
this.Write_Variables();
System.Diagnostics.Trace.Write(e.Message);
if (trans != null)
{
this.Rollback();
}
return(-1);
}
finally
{
oConn.Close();
}
}
public DbClass(SqlConnection Connection)
{
try
{
dbParameters = new _Parameters();
oConn = Connection;
}
catch (Exception e)
{
System.Diagnostics.Trace.Write(e.Message);
}
}
public void Dispose()
{
try
{
oConn = null;
dbParameters = null;
trans.Dispose();
}
catch (Exception e)
{
System.Diagnostics.Trace.Write(e.Message);
}
}
public DbClass()
{
try
{
// string connStr = System.Configuration.ConfigurationSettings.AppSettings["lrc"];
// oConn = new SqlConnection(connStr);
// oConn.Open();
dbParameters = new _Parameters();
}
catch (Exception e)
{
System.Diagnostics.Trace.Write(e.Message);
}
}
public SqlDataReader SelectinReader()
{
try
{
_Parameters ColParam = dbParameters;
SqlCommand dComm = new SqlCommand(this.sQry, oConn);
if (trans != null)
{
dComm.Transaction = trans;
}
for (int i = 0; i < ColParam.Count; i++)
{
if (ColParam.Item(i).ParamType == -1)
{
dComm.Parameters.Add(new SqlParameter(ColParam.Item(i).ParamName, ColParam.Item(i).ParamValue));
}
else if (ColParam.Item(i).ParamSize == -1)
{
dComm.Parameters.Add(new SqlParameter(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType));
}
else
{
dComm.Parameters.Add(new SqlParameter(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType, ColParam.Item(i).ParamSize));
}
dComm.Parameters[ColParam.Item(i).ParamName].Value = ColParam.Item(i).ParamValue;
}
SqlDataReader dr = dComm.ExecuteReader();
return(dr);
}
catch (Exception e)
{
System.Diagnostics.Trace.Write(e.Message);
if (trans != null)
{
this.Rollback();
}
return(null);
}
finally
{
oConn.Close();
}
}
public long ExecuteScalar()
{
try
{
_Parameters ColParam = dbParameters;
SqlCommand dComm = new SqlCommand(this.sQry, oConn);
for (int i = 0; i < ColParam.Count; i++)
{
if (ColParam.Item(i).ParamType == -1)
{
dComm.Parameters.Add(ColParam.Item(i).ParamName, ColParam.Item(i).ParamValue);
}
else if (ColParam.Item(i).ParamSize == -1)
{
dComm.Parameters.Add(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType);
}
else
{
dComm.Parameters.Add(ColParam.Item(i).ParamName, (SqlDbType)ColParam.Item(i).ParamType, ColParam.Item(i).ParamSize);
}
dComm.Parameters[ColParam.Item(i).ParamName].Value = ColParam.Item(i).ParamValue;
}
object obj = dComm.ExecuteScalar();
long nRet = Convert.ToInt64(obj);
return(nRet);
}
catch (Exception e)
{
System.Diagnostics.Trace.Write(e.Message);
return(-1);
}
finally
{
oConn.Close();
}
}
