//============操作方法===========
#region 数据保存按钮事件
protected void btnSaveClose_Click(object sender, EventArgs e)
{
////设置页面权限
//Power.SetViewPower("mod_role");
////验证权限
//if (Power.VerifyPower() == false)
//{
// return;
//}
string str;
if (Request.QueryString["id"].IsNum())
{
T_ROLES roles = new T_ROLES();
string id = Request.QueryString["id"].ToString();
//修改
var query = new DapperExQuery <T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, Int32.Parse(id));
roles = _rolesBll.GetEntity(query);
roles = Save(roles);
str = _rolesBll.Update(roles) ? "修改成功！" : "修改失败！";
}
else
{
T_ROLES roles = new T_ROLES();
//添加
roles = Save(roles);
str = _rolesBll.Add(roles) ? "添加成功！" : "添加失败！";
}
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
Alert.ShowInTop(str);
}
//=========数据绑定
#region 修改数据绑定
/// <summary>
/// 数据绑定
/// 创建人：林以恒
/// 2015年7月12日15:21:16
/// </summary>
private void LoadData()
{
if (Request.QueryString["id"].IsNum())
{
T_ROLES roles = new T_ROLES();
string id = Request.QueryString["id"].ToString();
var query = new DapperExQuery <T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, Int32.Parse(id));
roles = _rolesBll.GetEntity(query);
tbxR_Name.Text = roles.R_NAME.ToString();
//tbxAD_REMARK.Text = T_ADMIN_ROLES.AD_REMARK.ToString();
}
}
//=========数据绑定
#region 修改数据绑定
/// <summary>
/// 数据绑定
/// 创建人：林以恒
/// 2015年7月12日15:21:16
/// </summary>
private void LoadData()
{
if (Request.QueryString["id"].IsNum())
{
T_ROLES roles = new T_ROLES();
string id = Request.QueryString["id"].ToString();
var query = new DapperExQuery<T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, Int32.Parse(id));
roles = _rolesBll.GetEntity(query);
tbxR_Name.Text = roles.R_NAME.ToString();
//tbxAD_REMARK.Text = T_ADMIN_ROLES.AD_REMARK.ToString();
}
}
/// <summary>
/// 更新实体
/// 创建人：林以恒
/// 2015年7月6日21:49:09
/// </summary>
/// <param name="roles"></param>
/// <returns></returns>
private T_ROLES Save(T_ROLES roles)
{
roles.R_NAME = tbxR_Name.Text.Trim();
if (roles.ID == 0)
{
roles.CREATE_TIME = DateTime.Now;
roles.R_CODE = StringRandomUtil.GuidTo16String();
var creatAdminUser = AdminwebUserManager.GetCurrentAdminUser();
if (creatAdminUser != null)
{
roles.CREATE_USER = creatAdminUser.A_NAME;
roles.CREATE_USER_NAME = creatAdminUser.A_CHINESE_NAME;
}
}
return(roles);
}
/// <summary>
/// 用户数据绑定
/// 创建 2015-4-17
/// </summary>
private void BindGrid()
{
List <T_ADMIN> T_ADMIN_LIST = new List <T_ADMIN>();
//当前页数
int PageIndex = Grid1.PageIndex + 1;
//一页的数据条数
int PageSize = Grid1.PageSize;
//数据总条数
long allcount;
//分页拿到总数据
var queryall = new DapperExQuery <T_ADMIN>();
T_ADMIN_LIST = T_ADMIN_BLL.GetListByPage(queryall, "", PageIndex, PageSize, out allcount);
// 在名称中搜索
string searchText = ttbSearchMessage.Text.Trim();
if (!String.IsNullOrEmpty(searchText))
{
var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, searchText)
.AndWhere(n => n.A_TRUE_NAME, OperationMethod.Equal, searchText);
T_ADMIN_LIST = T_ADMIN_LIST.Where(n => n.A_TRUE_NAME.Contains(searchText) || n.A_NAME.Contains(searchText)).ToList();
}
// 排除已经属于本角色的用户
int rolesid = 0;
if (Request.QueryString[requestStr].IsNum())
{
rolesid = Int32.Parse(Request.QueryString[requestStr]);
T_ROLES T_ROLES = new T_ROLES();
var queryrole = new DapperExQuery <T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, rolesid);
T_ROLES = T_ROLES_BLL.GetEntity(queryrole);
List <T_ADMIN_ROLES> T_ADMIN_ROLES_LIST = new List <T_ADMIN_ROLES>();
var query1 = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, T_ROLES.R_CODE);
T_ADMIN_ROLES_LIST = T_ADMIN_ROLES_BLL.GetAllList(query1);
for (var i = 0; i < T_ADMIN_ROLES_LIST.Count; i++)
{
T_ADMIN_LIST = T_ADMIN_LIST.Where(n => n.A_CODE != T_ADMIN_ROLES_LIST[i].A_CODE).ToList();
}
// 在查询添加之后，获取总记录数
Grid1.RecordCount = Int32.Parse(allcount.ToString());
Grid1.DataSource = T_ADMIN_LIST;
Grid1.DataBind();
}
}
/// <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>
private void LoadData()
{
btnClose.OnClientClick = ActiveWindow.GetHideReference();
int rolesid = 0;
if (Request.QueryString[requestStr].IsNum())
{
rolesid = Int32.Parse(Request.QueryString[requestStr]);
}
T_ROLES T_ROLES = new T_ROLES();
var query = new DapperExQuery<T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, rolesid);
T_ROLES = T_ROLES_BLL.GetEntity(query);
if (T_ROLES == null)
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("参数错误！", String.Empty, ActiveWindow.GetHideReference());
return;
}
// 每页记录数
Grid1.PageSize = 10;
//ddlGridPageSize.SelectedValue = ConfigHelper.PageSize.ToString();
BindGrid();
}
/// <summary>
/// 初始化数据绑定
/// 创建 2015-4-17
/// </summary>
private void LoadData()
{
btnClose.OnClientClick = ActiveWindow.GetHideReference();
int rolesid = 0;
if (Request.QueryString[requestStr].IsNum())
{
rolesid = Int32.Parse(Request.QueryString[requestStr]);
}
T_ROLES T_ROLES = new T_ROLES();
var query = new DapperExQuery <T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, rolesid);
T_ROLES = T_ROLES_BLL.GetEntity(query);
if (T_ROLES == null)
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("参数错误！", String.Empty, ActiveWindow.GetHideReference());
return;
}
// 每页记录数
Grid1.PageSize = 10;
//ddlGridPageSize.SelectedValue = ConfigHelper.PageSize.ToString();
BindGrid();
}
/// <summary>
/// 用户数据绑定
/// 创建 2015-4-17
/// </summary>
private void BindGrid()
{
List<T_ADMIN> T_ADMIN_LIST = new List<T_ADMIN>();
//当前页数
int PageIndex = Grid1.PageIndex + 1;
//一页的数据条数
int PageSize = Grid1.PageSize;
//数据总条数
long allcount;
//分页拿到总数据
var queryall = new DapperExQuery<T_ADMIN>();
T_ADMIN_LIST = T_ADMIN_BLL.GetListByPage(queryall, "", PageIndex, PageSize, out allcount);
// 在名称中搜索
string searchText = ttbSearchMessage.Text.Trim();
if (!String.IsNullOrEmpty(searchText))
{
var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, searchText)
.AndWhere(n => n.A_TRUE_NAME, OperationMethod.Equal, searchText);
T_ADMIN_LIST = T_ADMIN_LIST.Where(n => n.A_TRUE_NAME.Contains(searchText) || n.A_NAME.Contains(searchText)).ToList();
}
// 排除已经属于本角色的用户
int rolesid = 0;
if (Request.QueryString[requestStr].IsNum())
{
rolesid = Int32.Parse(Request.QueryString[requestStr]);
T_ROLES T_ROLES = new T_ROLES();
var queryrole = new DapperExQuery<T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, rolesid);
T_ROLES = T_ROLES_BLL.GetEntity(queryrole);
List<T_ADMIN_ROLES> T_ADMIN_ROLES_LIST = new List<T_ADMIN_ROLES>();
var query1 = new DapperExQuery<T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, T_ROLES.R_CODE);
T_ADMIN_ROLES_LIST = T_ADMIN_ROLES_BLL.GetAllList(query1);
for (var i = 0; i < T_ADMIN_ROLES_LIST.Count; i++)
{
T_ADMIN_LIST = T_ADMIN_LIST.Where(n => n.A_CODE != T_ADMIN_ROLES_LIST[i].A_CODE).ToList();
}
// 在查询添加之后，获取总记录数
Grid1.RecordCount = Int32.Parse(allcount.ToString());
Grid1.DataSource = T_ADMIN_LIST;
Grid1.DataBind();
}
}
/// <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");
}
}
//============操作方法===========
#region 数据保存按钮事件
protected void btnSaveClose_Click(object sender, EventArgs e)
{
////设置页面权限
//Power.SetViewPower("mod_role");
////验证权限
//if (Power.VerifyPower() == false)
//{
// return;
//}
string str;
if (Request.QueryString["id"].IsNum())
{
T_ROLES roles = new T_ROLES();
string id = Request.QueryString["id"].ToString();
//修改
var query = new DapperExQuery<T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, Int32.Parse(id));
roles = _rolesBll.GetEntity(query);
roles = Save(roles);
str = _rolesBll.Update(roles) ? "修改成功！" : "修改失败！";
}
else
{
T_ROLES roles = new T_ROLES();
//添加
roles = Save(roles);
str = _rolesBll.Add(roles) ? "添加成功！" : "添加失败！";
}
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
Alert.ShowInTop(str);
}
/// <summary>
/// 更新实体
/// 创建人：林以恒
/// 2015年7月6日21:49:09
/// </summary>
/// <param name="roles"></param>
/// <returns></returns>
private T_ROLES Save(T_ROLES roles)
{
roles.R_NAME = tbxR_Name.Text.Trim();
if (roles.ID == 0)
{
roles.CREATE_TIME = DateTime.Now;
roles.R_CODE = StringRandomUtil.GuidTo16String();
var creatAdminUser = AdminwebUserManager.GetCurrentAdminUser();
if (creatAdminUser != null)
{
roles.CREATE_USER = creatAdminUser.A_NAME;
roles.CREATE_USER_NAME = creatAdminUser.A_CHINESE_NAME;
}
}
return roles;
}
