/// <summary> /// 查询所有指令信息 /// </summary> /// <returns>list</returns> public List <Instr> GetAllInstrs() { List <Instr> instrList = new List <Instr>(); string GET_INSTR_SQL = "select * from T_INSTR"; SqlCommand sqlCmd = new SqlCommand(GET_INSTR_SQL, db.sqlCon); using (SqlDataReader sqlReader = sqlCmd.ExecuteReader()) { try { while (sqlReader.Read()) { Instr instr = new Instr(); instr.setNo(Convert.ToInt32(sqlReader["I_NO"])); instr.setKeyWord(Convert.ToString(sqlReader["I_KEYWORD"]));; instr.setType(Convert.ToString(sqlReader["I_TYPE"])); instrList.Add(instr); } sqlReader.Close(); } catch (SqlException e) { throw new Exception(e.Message); } } return(instrList); }