private void treeRoles_AfterSelect(object sender, TreeViewEventArgs e)
{
DDRole role = new DDRole("RoleName", treeRoles.SelectedNode.Text.Trim());
TreeNode tempTreeNode;
for (int i = 0; i < treeModules.Nodes[0].Nodes.Count; i++)
{
tempTreeNode = treeModules.Nodes[0].Nodes[i];
for (int j = 0; j < tempTreeNode.Nodes.Count; j++)
{
DDModule module = new DDModule("ModuleName", tempTreeNode.Nodes[j].Text.Trim());
Query query = new Query(DDPermission.Schema);
query.AddWhere("RoleID", role.RoleID);
query.AddWhere("ModuleID", module.ModuleID);
DataTable dt = query.ExecuteDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
tempTreeNode.Nodes[j].Checked = true;
}
else
{
tempTreeNode.Nodes[j].Checked = false;
}
}
}
}
public SearchCustomerForm()
{
InitializeComponent();
InitGridDataset();
this.monthCalendar1.Visible = false;
this.ShowDetail.Text = "查看历史";
#region Check Permission
DDUser user = new DDUser("AccountName", MainForm.AccountName);
DDModule module = new DDModule("ModuleName", "修改客户信息");
Query query = new Query(DDPermission.Schema);
query.AddWhere("RoleID", user.RoleID);
query.AddWhere("ModuleID", module.ModuleID);
DataTable dt = query.ExecuteDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
this.btnDelete.Visible = true;
this.btnUpdate.Visible = true;
this.DataSelect.Visible = true;
}
else
{
this.btnDelete.Visible = false;
this.btnUpdate.Visible = false;
this.DataSelect.Visible = false;
}
#endregion
InitCustomerSearchOption();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DDRole role = new DDRole("RoleName", treeRoles.SelectedNode.Text.Trim());
Query queryDel = new Query(DDPermission.Schema);
queryDel.AddWhere("RoleID", role.RoleID);
queryDel.QueryType = QueryType.Delete;
queryDel.Execute();
TreeNode tempTreeNode;
for (int i = 0; i < treeModules.Nodes[0].Nodes.Count; i++)
{
tempTreeNode = treeModules.Nodes[0].Nodes[i];
for (int j = 0; j < tempTreeNode.Nodes.Count; j++)
{
if (tempTreeNode.Nodes[j].Checked == true)
{
DDModule module = new DDModule("ModuleName", tempTreeNode.Nodes[j].Text.Trim());
DDPermission permission = new DDPermission();
permission.RoleID = role.RoleID;
permission.ModuleID = module.ModuleID;
permission.Save();
}
}
}
MessageBox.Show("更新成功！", "提示信息");
}
catch
{
MessageBox.Show("更新失败，请检查数据库是否连接正确！", "提示信息");
}
}
public void Insert(string ModuleName, int?ParentID)
{
DDModule item = new DDModule();
item.ModuleName = ModuleName;
item.ParentID = ParentID;
item.Save(UserName);
}
public void Update(int ModuleID, string ModuleName, int?ParentID)
{
DDModule item = new DDModule();
item.MarkOld();
item.IsLoaded = true;
item.ModuleID = ModuleID;
item.ModuleName = ModuleName;
item.ParentID = ParentID;
item.Save(UserName);
}
private DialogResult CheckPermission(string strModuleName)
{
DDUser user = new DDUser("AccountName", MainForm.AccountName);
DDModule module = new DDModule("ModuleName", strModuleName);
Query query = new Query(DDPermission.Schema);
query.AddWhere("RoleID", user.RoleID);
query.AddWhere("ModuleID", module.ModuleID);
DataTable dt = query.ExecuteDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
return(DialogResult.OK);
}
else
{
return(DialogResult.No);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (treeRoles.SelectedNode != null)
{
this.RoleNameRecord = treeRoles.SelectedNode.Text.Trim();
}
try
{
int AmountLimit = Convert.ToInt32(tbxAmountLimit.Text);
DDRole role = new DDRole("RoleName", RoleNameRecord);
role.AmountLimit = AmountLimit;
role.RoleName = tbxRoleName.Text;
role.Save();
Query queryDel = new Query(DDPermission.Schema);
queryDel.AddWhere("RoleID", role.RoleID);
queryDel.QueryType = QueryType.Delete;
queryDel.Execute();
TreeNode tempTreeNode;
for (int i = 0; i < treeModules.Nodes[0].Nodes.Count; i++)
{
tempTreeNode = treeModules.Nodes[0].Nodes[i];
for (int j = 0; j < tempTreeNode.Nodes.Count; j++)
{
if (tempTreeNode.Nodes[j].Checked == true)
{
DDModule module = new DDModule("ModuleName", tempTreeNode.Nodes[j].Text.Trim());
DDPermission permission = new DDPermission();
permission.RoleID = role.RoleID;
permission.ModuleID = module.ModuleID;
permission.Save();
}
}
}
MessageBox.Show("更新成功！", "提示信息");
}
catch
{
MessageBox.Show("更新失败，请检查资金限额和数据库连接！", "提示信息");
}
InitRoles();
}
public bool Destroy(object ModuleID)
{
return(DDModule.Destroy(ModuleID) == 1);
}
public bool Delete(object ModuleID)
{
return(DDModule.Delete(ModuleID) == 1);
}
