private void btnSave_Click(object sender, EventArgs e)
{
//获得所有选中的末端树节点（即功能模块）的id列表
funcsLst.Clear();
foreach (TreeNode node in trV.Nodes)
{
getAllCheckedIds(node);
}
//删除当前角色的缘由的功能模块
trolefuncsTableAdapter1 = new trolefuncsTableAdapter();
trolefuncsTableAdapter1.DeleteQuery(roleId);
//向trolesfuncs表中插入所有选中的功能模块id
//方法：构造一个可插入多条记录的INSERT语句
if (funcsLst.Count > 0)
{
string[] insLst = funcsLst.ConvertAll(delegate(int n) {
string s = roleId + "," + n;
return(ClsQ.Q0(s, '('));
}).ToArray();
string str = string.Join(",", insLst);
string sql = "INSERT INTO trolefuncs (roleid, funcid) VALUES " + str;
ClsMSSQL.ExecuteCmd(sql, ClsDBCon.ConStrKj);
}
this.DialogResult = DialogResult.OK;
}
private void btnTest_Click(object sender, EventArgs e)
{
lst.Items.Add(ClsQ.Q1(txtA.Text));
lst.Items.Add(ClsQ.Q2(txtA.Text));
lst.Items.Add(ClsQ.Q0(txtA.Text, '('));
lst.Items.Add(ClsQ.Q0(txtA.Text, '['));
lst.Items.Add(ClsQ.Q0(txtA.Text, 'бо'));
lst.Items.Add(ClsQ.Q0(txtA.Text, 'б░'));
}
private void btnDel_Click(object sender, EventArgs e)
{
//数据表为空时不执行本操作
if (bds.Current == null)
{
return;
}
Datasets.DSjckja.toptionlbRow r = (Datasets.DSjckja.toptionlbRow)(((DataRowView)bds.Current).Row);
string cmd = "SELECT * FROM toptionxm WHERE lbdm =" + ClsQ.Q1(r.dm);
if (ClsMSSQL.Exists(cmd, ClsDBCon.ConStrKj))
{
ClsMsgBox.Jg("该类别下存在项目无法删除");
return;
}
ClsMsgBox.YesNo("确定要删除该记录吗？", deleting);
}
