public TDbQueryGroupObject Get(string groupname) { var sqlText = @"select * from t_db_query_group where group_name = @group_name"; using (SqlCommand command = new SqlCommand(sqlText, Connection)) { command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@group_name", groupname); DataTable = DatabaseOps.GetDataTable(command); _tDbQueryGroupObj = TransformerUtil.DataTableUtil.SingRowToClass <TDbQueryGroupObject>(DataTable); if (_tDbQueryGroupObj.group_id != 0) { return(_tDbQueryGroupObj); } else { _tDbQueryGroupObj = null; } } return(_tDbQueryGroupObj); }
public TDbQueryGroupHandler() { _tDbQueryGroupObj = new TDbQueryGroupObject(); _tDbQueryGroupObjList = new List <TDbQueryGroupObject>(); }