public void insert(AtionAndStaffTable record)
{
if (record.actionID == 0)
{
return;
}
string insert = "INSERT INTO [dbo].[BASE_ACTION_STAFF]([ACTION_ID],[STAFF_ID]) VALUES(";
insert += Convert.ToString(record.actionID) + ",";
insert += Convert.ToString(record.staffID) + "";
insert += ")";
try
{
DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert);
load();
}
catch (Exception error)
{
MessageBoxExtend.messageWarning(error.Message);
return;
}
}
private void load()
{
string sql = "SELECT [ACTION_ID],[STAFF_ID] FROM [dbo].[BASE_ACTION_STAFF]";
m_actionAndStaffList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
AtionAndStaffTable record = new AtionAndStaffTable();
record.actionID = DbDataConvert.ToInt32(row["ACTION_ID"]);
record.staffID = DbDataConvert.ToInt32(row["STAFF_ID"]);
m_actionAndStaffList.Add(m_actionAndStaffList.Count, record);
}
}
}
// 判断某个用户是否拥有某个操作权限
public bool isAccess(int staffID, int actionID)
{
bool isRet = false;
if (m_actionAndStaffList.Count == 0)
{
load();
}
foreach (KeyValuePair <int, AtionAndStaffTable> index in m_actionAndStaffList)
{
AtionAndStaffTable record = new AtionAndStaffTable();
record = index.Value;
if (record.staffID == staffID && record.actionID == actionID)
{
isRet = true;
break;
}
}
return(isRet);
}