public ArrayList getAllActionPkeyFromModuleID(int moduleID)
{
ArrayList actions = new ArrayList();
foreach (KeyValuePair <int, ActionTable> index in m_actionList)
{
ActionTable record = new ActionTable();
record = index.Value;
if (record.moduleID == moduleID)
{
actions.Add(record.pkey);
}
}
return(actions);
}
public int getActionPkey(string moduleName, string actionName)
{
int pkey = 0;
int moduleID = SystemModule.getInctance().getModuleIDFromModuleName(moduleName);
foreach (KeyValuePair <int, ActionTable> index in m_actionList)
{
ActionTable record = new ActionTable();
record = index.Value;
if (record.moduleID == moduleID && record.actionName == actionName)
{
pkey = record.pkey;
}
}
return(pkey);
}
private void load()
{
string sql = "SELECT [PKEY],[ACTION_NAME],[MODULE_ID],[UI_ACTION_NAME] FROM [dbo].[BASE_ACTION_LIST] ORDER BY PKEY";
m_actionList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
ActionTable record = new ActionTable();
record.pkey = DbDataConvert.ToInt32(row["PKEY"]);
record.actionName = DbDataConvert.ToString(row["ACTION_NAME"]);
record.moduleID = DbDataConvert.ToInt32(row["MODULE_ID"]);
record.uiActionName = DbDataConvert.ToString(row["UI_ACTION_NAME"]);
m_actionList.Add(m_actionList.Count, record);
}
}
}
public SortedDictionary <int, ActionTable> getActionInfoFromModuleID(int moduleID)
{
if (m_actionList.Count == 0)
{
load();
}
SortedDictionary <int, ActionTable> moduleList = new SortedDictionary <int, ActionTable>();
foreach (KeyValuePair <int, ActionTable> index in m_actionList)
{
ActionTable record = new ActionTable();
record = index.Value;
if (record.moduleID == moduleID)
{
moduleList.Add(moduleList.Count, record);
}
}
return(moduleList);
}
