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