public IEntity Get(MySql.Data.MySqlClient.MySqlDataReader aReader) { PartSellingPriceInformation bank = null; while (aReader.Read()) { bank = new PartSellingPriceInformation(); bank.ID = Convert.ToInt32(aReader[0]); bank.CODE = aReader[1].ToString(); bank.NAME = aReader[2].ToString(); bank.MODIFIED_BY = aReader["modified_by"].ToString(); bank.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); bank.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); } return(bank); }
public IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader) { IList result = new ArrayList(); while (aReader.Read()) { PartSellingPriceInformation bank = new PartSellingPriceInformation(); bank.ID = Convert.ToInt32(aReader[0]); bank.CODE = aReader[1].ToString(); bank.NAME = aReader[2].ToString(); bank.MODIFIED_BY = aReader["modified_by"].ToString(); bank.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); bank.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); result.Add(bank); } return(result); }