public static void SetListSYS_CatagoryInfo(ref DbDataReader reader, ref List <SYS_Catagory> SYS_Catagorys) { SYS_Catagory SYS_Catagory = null; while (reader.Read()) { SYS_Catagory = new SYS_Catagory(); SYS_CatagoryDataAccess.SetSYS_CatagoryInfo(reader, ref SYS_Catagory); SYS_Catagorys.Add(SYS_Catagory); } }
public SYS_Catagory SelectSYS_Catagory(string ID, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); Connection = connect.DecryptSYS_ConfigConnection(Connection); DbConnection connection = _DbHelper.CreateConnection(Connection); connection.Open(); SYS_Catagory SYS_Catagory = new SYS_Catagory(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_CatagoryDataAccess.SetSYS_CatagoryInfo(reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(SYS_Catagory); }