public string getSQLStringValue(string sql)
{
string value = "";
tq.Que _q = tq.Que.Execute(this.ConnectionString, sql, tq.Que.ExecutionEnum.ExecuteReader);
if (_q.DataTable.Rows.Count > 0)
{
value = _q.DataTable.Rows[0][0].ToString();
}
_q.Dispose();
return(value);
}
public int getSQLIntValue(string sql)
{
int value = 0;
tq.Que _q = tq.Que.Execute(_ConnectionString, sql, tq.Que.ExecutionEnum.ExecuteReader);
if (_q.DataTable.Rows.Count > 0)
{
value = int.Parse(_q.DataTable.Rows[0][0].ToString());
}
_q.Dispose();
return(value);
}
public decimal getSQLDecimalValue(string sql)
{
decimal value = 0;
tq.Que _q = tq.Que.Execute(this.ConnectionString, sql, tq.Que.ExecutionEnum.ExecuteReader);
if (_q.DataTable.Rows.Count > 0)
{
value = (decimal)_q.DataTable.Rows[0][0];
}
_q.Dispose();
return(value);
}
