public IList GetItemsByProduct(string productId) ...{//返回一个数组 IList itemsByProduct =new ArrayList(); SqlParameter parm =new SqlParameter(PARM_PRODUCT_ID, SqlDbType.Char, 10); parm.Value = productId; //Execute the query against the database using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.CONN_STRING_NON_DTC, CommandType.Text, SQL_SELECT_ITEMS_BY_PRODUCT, parm)) ...{ // Scroll through the results while (rdr.Read())...{ ItemInfo item =new ItemInfo(rdr.GetString(0).Trim(), rdr.GetString(1), rdr.GetDecimal(2), rdr.GetString(3), null); //Add each item to the arraylist itemsByProduct.Add(item); } } return itemsByProduct; }
/**////<summary> /// Get an individual item based on a the unique key ///</summary> ///<param name="itemId">unique key</param> ///<returns></returns> public ItemInfo GetItem(string itemId) ...{ //Set up a return value ItemInfo item =null; //Create a parameter SqlParameter parm =new SqlParameter(PARM_ITEM_ID, SqlDbType.Char, 10); //Bind the parameter parm.Value = itemId; //Execute the query using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.CONN_STRING_NON_DTC, CommandType.Text, SQL_SELECT_ITEM, parm)) ...{ rdr.Read(); item =new ItemInfo(rdr.GetString(0).Trim(), rdr.GetString(1), rdr.GetInt32(2), rdr.GetDecimal(3), rdr.GetString(4), rdr.GetString(5)); } return item; }