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, 'б░')); }