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