public override DsPanelInfo LoadDsPanelInfo()
{
DsPanelInfo m_dsPanelInfo = new DsPanelInfo();
RisDAL oKodakDAL = new RisDAL();
try
{
//string szQuery1 = "SELECT ModuleID, 'Modules.' + ModuleID as Title, Parameter, ImageIndex FROM tModule Where (Parameter & 1) = 0 order by OrderNo";
string szQuery1 = "SELECT ModuleID, Title, Parameter, ImageIndex FROM tModule Where (bitand (Parameter , 1) = 0) order by OrderNo";
oKodakDAL.ExecuteQuery(szQuery1, m_dsPanelInfo, "Module");
//string szQuery2 = "SELECT PanelID, 'Panels.' + PanelID as Title, AssemblyQualifiedName, Parameter, ModuleID, Flag, ImageIndex, [Key] FROM tPanel Where (Parameter & 1) = 0 order by OrderNo";
string szQuery2 = "SELECT PanelID, Title, AssemblyQualifiedName, Parameter, ModuleID, Flag, ImageIndex, Key FROM tPanel Where (bitand (Parameter , 1) = 0) order by OrderNo";
oKodakDAL.ExecuteQuery(szQuery2, m_dsPanelInfo, "Panel");
}
catch (Exception Ex)
{
logger.Error((long)ModuleEnum.Framework_Client, ModuleInstanceName.Framework, 1, Ex.Message,
string.Empty, (new System.Diagnostics.StackFrame(true)).GetFileName(),
(new System.Diagnostics.StackFrame(true)).GetFileLineNumber());
m_dsPanelInfo = null;
}
finally
{
if (oKodakDAL != null)
{
oKodakDAL.Dispose();
}
}
return(m_dsPanelInfo);
}
/// <summary>
/// override method of BaseAction.<br></br>
/// </summary>
/// <param name="context">input parameter</param>
/// <returns>if successful,return the result.</returns>
public override BaseActionResult Execute(Context context)
{
DsPanelInfoActionResult result = new DsPanelInfoActionResult();
ModulesAndPanels m = new ModulesAndPanels();
DsPanelInfo info = m.Load();
result.Result = true;
result.DataSetData = info;
return(result);
}
