/// <summary> /// /// </summary> /// <returns></returns> public ArrayList LoadLevel2All(string class1) { string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel2All", class1); if (sqlstring == null) { return(null); } ArrayList PowerLevelClass2s = new ArrayList(); try { this.ExecQuery(sqlstring); while (this.Reader.Read()) { PowerLevelClass2 info = PrepareLevel2Data(); if (info != null) { PowerLevelClass2s.Add(info); } } this.Reader.Close(); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } return(PowerLevelClass2s); }
/// <summary> /// /// </summary> /// <returns></returns> private PowerLevelClass2 PrepareLevel2Data() { PowerLevelClass2 info = new PowerLevelClass2(); info.Class1Code = this.Reader[0].ToString(); info.Class2Code = this.Reader[1].ToString(); info.Class2Name = this.Reader[2].ToString(); info.Memo = this.Reader[3].ToString(); info.ValidState = NConvert.ToBoolean(this.Reader[4]); info.Flag = this.Reader[5].ToString(); info.ID = info.Class2Code; info.Name = info.Class2Name; return(info); }
/// <summary> /// /// </summary> /// <param name="id0"></param> /// <param name="lazy"></param> /// <returns></returns> public PowerLevelClass2 LoadLevel2ByPrimaryKey(string id0, bool lazy) { string strSql = ""; if (this.Sql.GetSql("Manager.PowerLevelManager.LoadLevel2ByPrimaryKey", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, id0); } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; return(null); } PowerLevelClass2 level2 = PrepareLevel2Data(); try { this.ExecQuery(strSql); if (this.Reader.Read()) { if (!lazy) { PowerLevel1Manager level1Mgr = new PowerLevel1Manager(); level2.PowerLevelClass1 = level1Mgr.LoadLevel1ByPrimaryKey(level2.Class1Code); } } this.Reader.Close(); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } return(level2); }