/// <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 btnNew_Click(object sender, EventArgs e)
{
int roleID = FineUITable.GetSelectedDataKeyID(Grid1);
string addUrl = String.Format("/admin/system_manage/user_role_edit.aspx?id={0}", roleID);
PageContext.RegisterStartupScript(Window1.GetShowReference(addUrl, "添加用户到当前色角"));
}
/// <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>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveClose_Click(object sender, EventArgs e)
{
SyncSelectedRowIndexArrayToHiddenField();
string str = "";
// 排除已经属于本角色的用户
int roleID = 0;
if (Request.QueryString[requestStr].IsNum())
{
roleID = Int32.Parse(Request.QueryString[requestStr]);
T_ROLES T_ROLES = new T_ROLES();
var queryrole = new DapperExQuery <T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, roleID);
T_ROLES = T_ROLES_BLL.GetEntity(queryrole);
var r_code = T_ROLES.R_CODE;
// 从每个选中的行中获取ID（在Grid1中定义的DataKeyNames）
List <int> userids = FineUITable.GetSelectedDataKeyIDs(Grid1);
foreach (int userID in userids)
{
var queryAdmin = new DapperExQuery <T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, userID);
T_ADMIN T_ADMIN = new Model.T_ADMIN();
T_ADMIN = T_ADMIN_BLL.GetEntity(queryAdmin);
T_ADMIN_ROLES T_ADMIN_ROLES = new T_ADMIN_ROLES();
T_ADMIN_ROLES.R_CODE = r_code;
T_ADMIN_ROLES.A_CODE = T_ADMIN.A_CODE;
T_ADMIN_ROLES.CREATE_TIME = DateTime.Parse("2015-10-9");
T_ADMIN_ROLES.CREATE_USER = "";
T_ADMIN_ROLES.CREATE_USER_NAME = "";
if (T_ADMIN_ROLES_BLL.Add(T_ADMIN_ROLES))
{
str = "添加成功！";
}
else
{
str = "添加失败！";
}
}
//DB.SaveChanges();
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
Alert.Show("str");
}
}
/// <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();
}
