protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select [menuid],[menuname],[menuDesc],[fatherid],[DisplayIndex] from GameOA.dbo.oa_leftmenu where fatherid = -1 order by DisplayIndex";
using (SqlDataReader oReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (oReader == null)
{
throw new Exception();
}
List <BaseLeftMenu> tmpList = new List <BaseLeftMenu>();
if (oReader.HasRows)
{
while (oReader.Read())
{
BaseLeftMenu oTmp = new BaseLeftMenu();
oTmp.InitData(oReader);
oTmp.GetPurviewPages();
sGetSql = "select [menuid],[menuname],[menuDesc],[fatherid],[DisplayIndex] from GameOA.dbo.oa_leftmenu where fatherid =" + oTmp.MenuId;
using (SqlDataReader childReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (childReader == null)
{
throw new Exception();
}
if (childReader.HasRows)
{
while (childReader.Read())
{
BaseLeftMenu childMenu = new BaseLeftMenu();
childMenu.InitData(childReader);
childMenu.GetPurviewPages();
tmpList.Add(childMenu);
oTmp.ChildPages.Add(childMenu);
}
}
}
tmpList.Add(oTmp);
}
}
this.addCache(tmpList);
return(true);
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select [menuid],[menuname],[menuDesc],[fatherid],[DisplayIndex] from GameOA.dbo.oa_leftmenu where fatherid = -1 order by DisplayIndex";
using (SqlDataReader oReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (oReader == null)
{
throw new Exception();
}
List<BaseLeftMenu> tmpList = new List<BaseLeftMenu>();
if (oReader.HasRows)
{
while (oReader.Read())
{
BaseLeftMenu oTmp = new BaseLeftMenu();
oTmp.InitData(oReader);
oTmp.GetPurviewPages();
sGetSql = "select [menuid],[menuname],[menuDesc],[fatherid],[DisplayIndex] from GameOA.dbo.oa_leftmenu where fatherid =" + oTmp.MenuId;
using (SqlDataReader childReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (childReader == null)
{
throw new Exception();
}
if (childReader.HasRows)
{
while (childReader.Read())
{
BaseLeftMenu childMenu = new BaseLeftMenu();
childMenu.InitData(childReader);
childMenu.GetPurviewPages();
tmpList.Add(childMenu);
oTmp.ChildPages.Add(childMenu);
}
}
}
tmpList.Add(oTmp);
}
}
this.addCache(tmpList);
return true;
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return false;
}
}
