/// <summary> /// 单行删除 /// 创建 毛枫 2015-4-17 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid2_RowCommand(object sender, GridCommandEventArgs e) { object[] values = Grid2.DataKeys[e.RowIndex]; string A_CODE = values[1].ToString(); //T_ADMIN T_ADMIN = new T_ADMIN(); //var queryuser = new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, userID); //T_ADMIN = T_ADMIN_BLL.GetEntity(queryuser); //string a_code = T_ADMIN.A_CODE; //判断点击的是删除 if (e.CommandName == "Delete") { //// 在操作之前进行权限检查 //if (!CheckPower("CoreRoleUserDelete")) //{ // CheckPowerFailWithAlert(); // return; //} string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1); var query = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE) .AndWhere(n => n.A_CODE, OperationMethod.Equal, A_CODE); var user_role = T_ADMIN_ROLES_BLL.GetEntity(query); if (user_role != null) { T_ADMIN_ROLES_BLL.Delete(query); } //绑定刷新 BindGrid2(); } }
/// <summary> /// 右侧角色对应用户的数据绑定 /// 创建 毛枫 2015-4-17 /// </summary> private void BindGrid2() { string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1); if (R_CODE == "") { Grid2.RecordCount = 0; Grid2.DataSource = null; Grid2.DataBind(); } else { // 过滤选中角色下的所有用户 long allcount = 0; var query = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE); int PageIndex = Grid2.PageIndex + 1; int PageSize = Grid2.PageSize; List <T_ADMIN_ROLES> qs = T_ADMIN_ROLES_BLL.GetListByPage(query, "", PageIndex, PageSize, out allcount); List <T_ADMIN> q = new List <T_ADMIN>(); foreach (T_ADMIN_ROLES t in qs) { var query1 = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, t.A_CODE); T_ADMIN T_ADMIN = new T_ADMIN(); T_ADMIN = T_ADMIN_BLL.GetEntity(query1); q.Add(T_ADMIN); } //获取总记录数 Grid2.RecordCount = Int32.Parse(allcount.ToString()); Grid2.DataSource = q; Grid2.DataBind(); } }
/// <summary> /// 删除选中的用户 /// 创建 毛枫 2015-4-17 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDeleteSelected_Click(object sender, EventArgs e) { //// 在操作之前进行权限检查 //if (!CheckPower("CoreRoleUserDelete")) //{ // CheckPowerFailWithAlert(); // return; //} // 从每个选中的行中获取ID(在Grid1中定义的DataKeyNames) string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1); //T_ROLES T_ROLES = new Model.T_ROLES(); //var queryrole = new DapperExQuery<T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, roleID); //T_ROLES = T_ROLES_BLL.GetEntity(queryrole); //string r_code = T_ROLES.R_CODE; List <string> A_CODES = FineUITable.GetSelectedDataKeyCODES(Grid2); foreach (string A_CODE in A_CODES) { //T_ADMIN T_ADMIN = new T_ADMIN(); //var queryuser= new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, userID); //T_ADMIN = T_ADMIN_BLL.GetEntity(queryuser); //string a_code = T_ROLES.R_CODE; var query = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE) .AndWhere(n => n.A_CODE, OperationMethod.Equal, A_CODE); var user_role = T_ADMIN_ROLES_BLL.GetEntity(query); if (user_role != null) { T_ADMIN_ROLES_BLL.Delete(query); } } //DB.SaveChanges(); // 清空当前选中的项 Grid2.SelectedRowIndexArray = null; // 重新绑定表格 BindGrid2(); }