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); }