public TDbQueryGroupMemberObject Get(string groupid) { var sqlText = @"select * from t_db_query_group_member where group_id = @group_id"; using (SqlCommand command = new SqlCommand(sqlText, Connection)) { command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@group_id", groupid); DataTable = DatabaseOps.GetDataTable(command); _tDbQueryGroupMemberObj = TransformerUtil.DataTableUtil.SingRowToClass <TDbQueryGroupMemberObject>(DataTable); if (_tDbQueryGroupMemberObj.group_id != 0) { return(_tDbQueryGroupMemberObj); } else { _tDbQueryGroupMemberObj = null; } } return(_tDbQueryGroupMemberObj); }
public TDbQueryGroupMemberHandler() { _tDbQueryGroupMemberObj = new TDbQueryGroupMemberObject(); _tDbQueryGroupMemberObjList = new List <TDbQueryGroupMemberObject>(); }