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); }