public bool DeleteRelease(int releaseID) { bool isSucess = true; using (var tran = DbContext.DbTransaction) { try { var releaseQuery = new DapperExQuery <T_RELEASE>().AndWhere(s => s.ID, OperationMethod.Equal, releaseID); DbContext.Delete <T_RELEASE>(releaseQuery.GetSqlQuery(DbContext)); var releaseSprintsQuery = new DapperExQuery <T_RELEASE_SPRINT>().AndWhere(s => s.R_RELEASE_ID, OperationMethod.Equal, releaseID); DbContext.Delete <T_RELEASE_SPRINT>(releaseSprintsQuery.GetSqlQuery(DbContext)); } catch (Exception e) { isSucess = false; throw e; } finally { if (isSucess) { tran.Commit(); } else { tran.Rollback(); } } return(isSucess); } }
public List <BacklogInfoModel> GetBacklogInfoList(int teamID, int sprintID) { var query = new DapperExQuery <T_BACKLOG>(); query.AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID); query.AndWhere(s => s.B_STATE, OperationMethod.NotEqual, (int)BacklogState.REMOVE); string orderString = string.Empty; sprintID = sprintID < 0 ? 0 : sprintID; if (sprintID > 0 && this._scrumRepository.GetSprintInfoByTeamIDAndSprintID(teamID, sprintID) == null) { Enforce.Throw(new LogicErrorException("当前Sprint不存在")); } query.AndWhere(s => s.R_SPRINT_ID, OperationMethod.Equal, sprintID); if (sprintID > 0) { orderString = "B_LEVEL ASC"; } else { orderString = "CREATE_TIME DESC"; } var list = this._backlogBll.GetList(query, orderString); var backlogInfoList = Mapper.Map <List <T_BACKLOG>, List <BacklogInfoModel> >(list); return(backlogInfoList); }
public bool DeleteTeam(int teamID) { bool isSucess = true; using (var tran = DbContext.DbTransaction) { try { var teamQuery = new DapperExQuery <T_TEAM>().AndWhere(s => s.ID, OperationMethod.Equal, teamID); DbContext.Delete <T_TEAM>(teamQuery.GetSqlQuery(DbContext)); var teamMembersQuery = new DapperExQuery <T_TEAM_MEMBER>().AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID); DbContext.Delete <T_TEAM_MEMBER>(teamMembersQuery.GetSqlQuery(DbContext)); } catch (Exception e) { isSucess = false; throw e; } finally { if (isSucess) { tran.Commit(); } else { tran.Rollback(); } } return(isSucess); } }
public bool DeleteProject(int projectID) { bool isSucess = true; using (var tran = DbContext.DbTransaction) { try { var projectQuery = new DapperExQuery <T_PROJECT>().AndWhere(s => s.ID, OperationMethod.Equal, projectID); DbContext.Delete <T_PROJECT>(projectQuery.GetSqlQuery(DbContext)); var projectMembersQuery = new DapperExQuery <T_PROJECT_MEMBER>().AndWhere(s => s.P_PROJECT_ID, OperationMethod.Equal, projectID); DbContext.Delete <T_PROJECT_MEMBER>(projectMembersQuery.GetSqlQuery(DbContext)); } catch (Exception e) { isSucess = false; throw e; } finally { if (isSucess) { tran.Commit(); } else { tran.Rollback(); } } return(isSucess); } }
/// <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(); } }
public bool DeleteSprint(DapperExQuery <T_RELEASE_SPRINT> deleteQuery, T_RELEASE_SPRINT modifySprint) { bool isSucess = true; using (var tran = DbContext.DbTransaction) { try { bool deleteResult = DbContext.Delete <T_RELEASE_SPRINT>(deleteQuery.GetSqlQuery(DbContext)); if (deleteResult && modifySprint != null) { this.Update(modifySprint); } } catch (Exception e) { isSucess = false; throw e; } finally { if (isSucess) { tran.Commit(); } else { tran.Rollback(); } } return(isSucess); } }
//=========数据绑定 #region 数据绑定 /// <summary> /// 数据绑定 /// 创建人:林以恒 /// 2015年7月6日14:09:00 /// </summary> private void LoadData() { if (!Request.QueryString["id"].IsNum()) { return; } string id = Request.QueryString["id"]; var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, Int32.Parse(id)); var adminUser = _adminUserBll.GetEntity(query); tbxA_NAME.Text = adminUser.A_NAME; tbxA_CHINESE_NAME.Text = adminUser.A_TRUE_NAME; tbxPassword.Text = adminUser.PASSWORD; tbxCfm_Password.Text = adminUser.PASSWORD; tbxPhone.Text = adminUser.A_PHONE; if (adminUser.A_GENDER == 1) { rbtnFirst.Checked = true; } else { rbtnSecond.Checked = true; } //tbxAD_REMARK.Text = T_ADMIN_ROLES.AD_REMARK.ToString(); }
public IDictionary <int, List <ProjectInfoModel> > LoadProjectInfosByUserArray(List <int> userList) { IDictionary <int, List <ProjectInfoModel> > dict = new Dictionary <int, List <ProjectInfoModel> >(); if (userList != null && userList.Count > 0) { userList = userList.Distinct().ToList(); var query = new DapperExQuery <T_PROJECT_MEMBER>().AndWhere(s => s.U_USER_ID, OperationMethod.In, userList.ToArray()); var projectMembers = this._projectMemberBll.GetList(query); var projectMemberList = Mapper.Map <List <T_PROJECT_MEMBER>, List <ProjectMemberModel> >(projectMembers); var projectInfos = this._projectBll.GetList(new DapperExQuery <T_PROJECT>().AndWhere( s => s.ID, OperationMethod.In, projectMemberList.Select(s => s.projectID).Distinct().ToArray())); var projectInfoList = Mapper.Map <List <T_PROJECT>, List <ProjectInfoModel> >(projectInfos); dict = userList.ToDictionary( s => s, s => projectInfoList.Where( n => projectMemberList.Where(m => m.userID.Equals(s)).Select(m => m.projectID).ToList().Contains(n.projectID)).ToList()); } return(dict); }
/// <summary> /// 获得单个实体 /// </summary> /// <param name="expr">查询对象</param> /// <param name="operation"></param> /// <param name="value"></param> /// <returns></returns> public virtual T GetEntity(DapperExQuery <T> query) { using (DbBase DbContext = new DbBase(connectionName)) { return(DbContext.SingleOrDefault <T>(query.GetSqlQuery(DbContext))); } }
//=========数据绑定 #region 数据绑定 /// <summary> /// 添加或修改数据绑定 /// </summary> private void LoadData() { if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"].ToString(); var query = new DapperExQuery <T_POWERS>().AndWhere(n => n.ID, OperationMethod.Equal, id); T_POWERS powers = null; powers = _powersBll.GetEntity(query); if (powers == null) { return; } tbxP_Name.Text = powers.P_NAME.ToString(); tbxP_CHINESE_NAME.Text = powers.P_CHINESE_NAME != null?powers.P_CHINESE_NAME.ToString() : ""; //tbx_groupname.Text = powers.GROUP_NAME != null ? powers.GROUP_NAME.ToString() : ""; //tbxAP_GROUP_NAME.Text = (powers.AP_GROUP_NAME.ToString() != null // ? powers.AP_GROUP_NAME.ToString() // : ""); //tbxAP_REMARK.Text = (powers.AP_REMARK.ToString() != null // ? powers.AP_REMARK.ToString() // : ""); //tbxAP_TITLE.Text = (powers.AP_TITLE.ToString() != null ? powers.AP_TITLE.ToString() : ""); } }
//============操作方法=========== #region 数据保存 /// <summary> /// 数据保存按钮事件 /// 创建 林以恒 /// 2015年4月14日 /// </summary> protected void btnSaveClose_Click(object sender, EventArgs e) { ////设置页面权限 //Power.SetViewPower("mod_menu"); ////验证权限 //if (Power.VerifyPower() == false) //{ // return; //} string str; if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"].ToString(); //修改 T_ADMIN_MENUS T_ADMIN_MENUS = new T_ADMIN_MENUS(); var q = new DapperExQuery <T_ADMIN_MENUS>().AndWhere(n => n.ID, OperationMethod.Equal, id); T_ADMIN_MENUS = _adminMenusBll.GetEntity(q); T_ADMIN_MENUS = GetnewModel(T_ADMIN_MENUS); str = _adminMenusBll.Update(T_ADMIN_MENUS) ? "修改成功!" : "修改失败!"; } else { //添加 T_ADMIN_MENUS adminMenus = new T_ADMIN_MENUS(); adminMenus = GetnewModel(adminMenus); adminMenus.PARENT_ID = Int32.Parse(Request.QueryString["fatherId"].ToString()); str = _adminMenusBll.Add(adminMenus) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
//============操作方法=========== #region 数据保存 /// <summary> /// 数据保存按钮事件 /// 创建人:林以恒 /// 2015年7月6日21:28:17 /// </summary> protected void btnSaveClose_Click(object sender, EventArgs e) { ////设置页面权限 //Power.SetViewPower("mod_power"); ////验证权限 //if (Power.VerifyPower() == false) //{ // return; //} string str; if (Request.QueryString["id"].IsNum()) { T_POWERS powers = null; string id = Request.QueryString["id"]; //修改 var query = new DapperExQuery <T_POWERS>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id)); powers = _powersBll.GetEntity(query); powers = Save(powers); str = _powersBll.Update(powers) ? "修改成功!" : "修改失败!"; } else { T_POWERS powers = new T_POWERS(); //添加 powers = Save(powers); powers.FATHER_CODE = Request.QueryString["fathercode"].ToString(); str = _powersBll.Add(powers) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
/// <summary> /// 分组绑定右侧权限 /// 修改人:金协民 2015年7月29日 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid2_RowDataBound(object sender, GridRowEventArgs e) { AspNet.CheckBoxList ddlPowers = (AspNet.CheckBoxList)Grid2.Rows[e.RowIndex].FindControl("ddlPowers"); var GroupName = e.DataItem.GetType().GetProperty("GroupName").GetValue(e.DataItem, null); List <T_POWERS> T_POWERS_LIST = new List <T_POWERS>(); var query = new DapperExQuery <T_POWERS>().AndWhere(n => n.GROUP_NAME, OperationMethod.Equal, GroupName); T_POWERS_LIST = T_POWERS_BLL.GetAllList(query); foreach (var po in T_POWERS_LIST) { AspNet.ListItem item = new AspNet.ListItem { Value = po.P_CODE.ToString(), Text = string.Format("{0}({1})", po.P_CHINESE_NAME, po.P_NAME) }; item.Attributes["data-qtip"] = po.P_NAME; if (_currentRolePowers.ContainsKey(po.P_NAME)) { item.Selected = true; } else { item.Selected = false; } ddlPowers.Items.Add(item); } }
/// <summary> /// 根据用户角色code来获取权限列表 /// 创建 毛枫 2015-4-21 /// </summary> /// <param name="RoleId"></param> /// <returns></returns> public static List <T_POWERS> GetUserPower(string r_code) { List <T_POWERS> T_POWERS_LIST = new List <T_POWERS>(); List <T_ROLES_POWERS> T_ROLES_POWER_LIST = new List <Mammothcode.Model.T_ROLES_POWERS>(); var query = new DapperExQuery <T_ROLES_POWERS>().AndWhere(n => n.R_CODE, OperationMethod.Equal, r_code); //获取权限列表 T_ROLES_POWER_LIST = T_ROLES_POWERS_BLL.GetAllList(query); if (T_ROLES_POWER_LIST != null) { foreach (T_ROLES_POWERS q in T_ROLES_POWER_LIST) { string powerCode = q.P_CODE; var querypower = new DapperExQuery <T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, powerCode); T_POWERS T_POWERS = new T_POWERS(); //获取权限model T_POWERS = T_POWERS_BLL.GetEntity(querypower); T_POWERS_LIST.Add(T_POWERS); } } else { T_POWERS_LIST = null; } return(T_POWERS_LIST); }
/// <summary> /// 统计指定条件的数据量 /// </summary> /// <param name="queryList"></param> /// <returns></returns> public virtual long GetCount(DapperExQuery <T> query) { using (DbBase DbContext = new DbBase(connectionName)) { return(DbContext.Count <T>(query.GetSqlQuery(DbContext))); } }
/// <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> /// 获得子查询条件 /// </summary> /// <param name="query"></param> /// <returns></returns> public virtual InWhereQuery GetInWhereSql(string selectField, DapperExQuery <T> query) { using (DbBase DbContext = new DbBase(connectionName)) { SqlQuery sql = query.GetSqlQuery(DbContext); return(query.TranInWhereQuery(selectField, sql)); } }
/// <summary> /// 分页_获取指定条件的数据集合(开始位置,结束位置) /// </summary> /// <param name="query">查询条件</param> /// <param name="pageIndex">开始位置(默认从1开始)</param> /// <param name="pageSize">当前页数</param> /// <param name="pageCount">总页数</param> /// <param name="dataCount">总查询数</param> /// <returns></returns> public virtual List <T> GetListByByRowNumber(DapperExQuery <T> query, string orderString, int startRowNumber, int endRowNumber, out long dataCount) { using (DbBase DbContext = new DbBase(connectionName)) { //设置Order条件 query.SetOrder(orderString); return(DbContext.PageDataByRowNumber <T>(startRowNumber, endRowNumber, out dataCount, query.GetSqlQuery(DbContext))); } }
/// <summary> /// 获取指定条件的实体集合 /// </summary> /// <param name="queryList"></param> /// <returns></returns> public virtual List <T> GetList(DapperExQuery <T> query, string orderString = "") { if (!string.IsNullOrEmpty(orderString)) { //设置Order条件 query.SetOrder(orderString); } return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext))); }
/// <summary> /// 分页_获取指定条件的数据集合(第几页,每页个数) /// </summary> /// <param name="query">查询条件</param> /// <param name="pageIndex">开始位置(默认从1开始)</param> /// <param name="pageSize">页面显示数量</param> /// <param name="pageCount">总页数</param> /// <param name="dataCount">总查询数</param> /// <returns></returns> public virtual List <T> GetListByPage(DapperExQuery <T> query, string orderString, int pageIndex, int pageSize, out long dataCount) { using (DbBase DbContext = new DbBase(connectionName)) { //设置Order条件 query.SetOrder(orderString); return(DbContext.PageData <T>(pageIndex, pageSize, out dataCount, query.GetSqlQuery(DbContext))); } }
/// <summary> /// 私有方法:从数据库中判断用户是否登录 /// 创建 毛枫 2015-4-21 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> private static T_ADMIN IsLoginFromSql(string username, string password) { T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, username) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(password.Trim(), 16)); var admin = T_ADMIN_BLL.GetEntity(query); return(admin); }
/// <summary> /// 删除实体 /// </summary> /// <param name="expr"></param> /// <param name="operation"></param> /// <param name="value"></param> public virtual bool Delete(DapperExQuery <T> query, IDbTransaction transaction = null) { bool flag = false; using (DbBase DbContext = new DbBase(connectionName)) { flag = DbContext.Delete <T>(query.GetSqlQuery(DbContext), transaction); DbContext.CloseConnection(); } return(flag); }
//=========数据绑定 #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> /// 获取第三方绑定信息 /// </summary> /// <param name="userID"></param> /// <param name="from"></param> /// <returns></returns> private ThirdPartyInfoModel getThirdPartyInfoModel(int userID, string from) { ThirdPartyInfoModel thirdPartyInfoModel = null; var query = new DapperExQuery <T_THIRD_PARTY>().AndWhere(t => t.U_USER_ID, OperationMethod.Equal, userID).AndWhere(k => k.T_FROM, OperationMethod.Equal, from); var model = this._thirdBll.GetEntity(query); if (model != null) { thirdPartyInfoModel = Mapper.Map <T_THIRD_PARTY, ThirdPartyInfoModel>(model); } return(thirdPartyInfoModel); }
//=========数据绑定 #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> /// 获取指定条件的所有数据集合 /// </summary> /// <param name="queryList"></param> /// <returns></returns> public virtual List <T> GetAllList(DapperExQuery <T> query, string orderString = "") { using (DbBase DbContext = new DbBase(connectionName)) { if (!string.IsNullOrEmpty(orderString)) { //设置Order条件 query.SetOrder(orderString); } return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext))); } }
/// <summary> /// 返回按钮事件 ///创建 毛枫 2015-4-20 /// </summary> protected void back_Click(object sender, EventArgs e) { if (fathercode != "0") { var query = new DapperExQuery <T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, fathercode); var q = _powersbll.GetEntity(query); if (q != null) { fathercode = q.FATHER_CODE; Replace(); } } }
public virtual bool IsExist(DapperExQuery <T> query) { bool returnBool = false; using (DbBase DbContext = new DbBase(connectionName)) { if (DbContext.SingleOrDefault <T>(query.GetSqlQuery(DbContext)) != null) { returnBool = true; } } return(returnBool); }
/// <summary> /// 获取指定条件的实体集合 /// </summary> /// <param name="queryList"></param> /// <returns></returns> public virtual List <T> GetAllList(string orderString = "") { if (!string.IsNullOrEmpty(orderString)) { DapperExQuery <T> query = new DapperExQuery <T>(); query.SetOrder(orderString); return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext))); } else { return(DbContext.QueryData <T>()); } }
/// <summary> /// 返回按钮事件 ///创建 毛枫 2015-4-20 /// </summary> protected void back_Click(object sender, EventArgs e) { if (fatherId != 0) { var query = new DapperExQuery <T_ADMIN_MENUS>().AndWhere(n => n.ID, OperationMethod.Equal, fatherId); var q = _adminMenusBll.GetEntity(query); if (q != null) { fatherId = q.PARENT_ID; Replace(); } } }
public bool TransformTeam(int teamID, string oldOwnerMail, string newOwnerMail) { bool isSucess = true; using (var tran = DbContext.DbTransaction) { try { var oldTeamOwnerQuery = new DapperExQuery <T_TEAM_MEMBER>() .AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID) .AndWhere(s => s.U_USER_EMAIL, OperationMethod.Equal, oldOwnerMail) .AndWhere(s => s.R_USER_ROLE_CODE, OperationMethod.Equal, RoleCode.Owner); var oldTeamOwner = DbContext.SingleOrDefault <T_TEAM_MEMBER>(oldTeamOwnerQuery.GetSqlQuery(DbContext)); var newTeamOwnerQuery = new DapperExQuery <T_TEAM_MEMBER>() .AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID) .AndWhere(s => s.U_USER_EMAIL, OperationMethod.Equal, newOwnerMail); var newTeamOwner = DbContext.SingleOrDefault <T_TEAM_MEMBER>(newTeamOwnerQuery.GetSqlQuery(DbContext)); if (oldTeamOwner != null && newTeamOwner != null) { oldTeamOwner.R_USER_ROLE_CODE = RoleCode.Member; newTeamOwner.R_USER_ROLE_CODE = RoleCode.Owner; DbContext.Update(oldTeamOwner); DbContext.Update(newTeamOwner); isSucess = true; } else { isSucess = false; } } catch (Exception e) { isSucess = false; throw e; } finally { if (isSucess) { tran.Commit(); } else { tran.Rollback(); } } return(isSucess); } }
//=========数据绑定 #region 数据绑定 /// <summary> /// 修改数据绑定 /// 创建 林以恒 /// 2015年4月14日 /// </summary> private void LoadData() { if (!Request.QueryString["id"].IsNum()) return; string id = Request.QueryString["id"].ToString(); var query = new DapperExQuery<T_ADMIN_MENUS>().AndWhere(n => n.ID, OperationMethod.Equal, id); _adminMenus = _adminMenusBll.GetEntity(query); tbxAM_NAME.Text = (_adminMenus.AM_NAME != null ? _adminMenus.AM_NAME.ToString() : ""); tbxAM_NAVIGATE_URL.Text = (_adminMenus.AM_NAVIGATE_URL != null ? _adminMenus.AM_NAVIGATE_URL.ToString() : ""); tbxAM_REMARK.Text = (_adminMenus.AM_REMARK != null ? _adminMenus.AM_REMARK.ToString() : ""); tbxAM_SORTINDEX.Text = _adminMenus.AM_SORTINDEX.ToString(); if (_adminMenus.P_CODE != null && _adminMenus.P_CODE != "") { tbxVIEWPOWER_ID.Text = _powersBll.GetEntity(new DapperExQuery<T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, _adminMenus.P_CODE)).P_NAME; } }
//=========数据绑定 #region 数据绑定 /// <summary> /// 添加或修改数据绑定 /// </summary> private void LoadData() { if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"].ToString(); var query = new DapperExQuery<T_POWERS>().AndWhere(n => n.ID, OperationMethod.Equal, id); T_POWERS powers = null; powers = _powersBll.GetEntity(query); if (powers == null) return; tbxP_Name.Text = powers.P_NAME.ToString(); tbxP_CHINESE_NAME.Text = powers.P_CHINESE_NAME != null ? powers.P_CHINESE_NAME.ToString() : ""; //tbx_groupname.Text = powers.GROUP_NAME != null ? powers.GROUP_NAME.ToString() : ""; //tbxAP_GROUP_NAME.Text = (powers.AP_GROUP_NAME.ToString() != null // ? powers.AP_GROUP_NAME.ToString() // : ""); //tbxAP_REMARK.Text = (powers.AP_REMARK.ToString() != null // ? powers.AP_REMARK.ToString() // : ""); //tbxAP_TITLE.Text = (powers.AP_TITLE.ToString() != null ? powers.AP_TITLE.ToString() : ""); } }
//=========数据绑定 #region 数据绑定 /// <summary> /// 数据绑定 /// 创建人:林以恒 /// 2015年7月6日14:09:00 /// </summary> private void LoadData() { if (!Request.QueryString["id"].IsNum()) return; string id = Request.QueryString["id"]; var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, Int32.Parse(id)); var adminUser = _adminUserBll.GetEntity(query); tbxA_NAME.Text = adminUser.A_NAME; tbxA_CHINESE_NAME.Text = adminUser.A_TRUE_NAME; tbxPassword.Text = adminUser.PASSWORD; tbxCfm_Password.Text = adminUser.PASSWORD; tbxPhone.Text = adminUser.A_PHONE; if (adminUser.A_GENDER == 1) { rbtnFirst.Checked = true; } else { rbtnSecond.Checked = true; } //tbxAD_REMARK.Text = T_ADMIN_ROLES.AD_REMARK.ToString(); }
/// <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年7月29日 /// </summary> private void BindGrid2() { var roleId = GetSelectedDataKeyID(Grid1); if (string.IsNullOrEmpty(roleId)) { Grid2.DataSource = null; Grid2.DataBind(); } else { // 当前选中角色拥有的权限列表 _currentRolePowers.Clear(); List<T_ROLES_POWERS> T_ADMIN_ROLE_POWER_LIST = new List<T_ROLES_POWERS>(); var query = new DapperExQuery<T_ROLES_POWERS>().AndWhere(n => n.R_CODE, OperationMethod.Equal, roleId); //拿到角色对应的权限,标记为选中 T_ADMIN_ROLE_POWER_LIST = T_ROLES_POWERS_BLL.GetAllList(query); if (T_ADMIN_ROLE_POWER_LIST != null) { foreach (var power in T_ADMIN_ROLE_POWER_LIST) { var powersId = power.P_CODE; var query1 = new DapperExQuery<T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, powersId); T_POWERS T_POWERS = new Model.T_POWERS(); T_POWERS = T_POWERS_BLL.GetEntity(query1); string powerName = T_POWERS.P_NAME; if (!_currentRolePowers.ContainsKey(powerName)) { _currentRolePowers.Add(powerName, true); } } } //分组拿到所有权限 var q = T_POWERS_BLL.GetAllList().GroupBy(n => n.GROUP_NAME); //自定数据结构,包括组名,组内权限集 var powers = q.Select(g => new { GroupName = g.Key, Powers = g }); Grid2.DataSource = powers; Grid2.DataBind(); } }
//============操作方法=========== #region 删除 /// <summary> /// 删除后台用户 /// 创建人: 林以恒 /// 2015年7月29日11:46:14 /// </summary> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { //设置页面权限 power.SetViewPower("mod_admin"); //验证权限 if (power.VerifyPower() == false) { return; } object[] keys = Grid1.DataKeys[e.RowIndex]; int id = int.Parse(keys[0].ToString()); if (e.CommandName != "Delete") return; var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, id); Alert.ShowInTop(t_admin_bll.Delete(query) ? "删除成功!" : "删除失败!"); BindGrid(); }
/// <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-20 /// </summary> protected void back_Click(object sender, EventArgs e) { if (fathercode != "0") { var query = new DapperExQuery<T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, fathercode); var q = _powersbll.GetEntity(query); if (q != null) { fathercode = q.FATHER_CODE; Replace(); } } }
//============ GRID事件========== #region 删除 /// <summary> /// 删除 /// 修改:林以恒 2015-4-19 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { ////设置页面权限 //Power.SetViewPower("mod_role"); ////验证权限 //if (Power.VerifyPower() == false) //{ // return; //} object[] keys = Grid1.DataKeys[e.RowIndex]; int id = Int32.Parse(keys[0].ToString()); if (e.CommandName != "Delete") return; var query = new DapperExQuery<T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, id); Alert.ShowInTop(_rolesBll.Delete(query) ? "删除成功!" : "删除失败!"); //页面刷新 Bind(); }
/// <summary> /// 返回按钮事件 ///创建 毛枫 2015-4-20 /// </summary> protected void back_Click(object sender, EventArgs e) { if (fatherId != 0) { var query = new DapperExQuery<T_ADMIN_MENUS>().AndWhere(n => n.ID, OperationMethod.Equal, fatherId); var q = _adminMenusBll.GetEntity(query); if (q != null) { fatherId = q.PARENT_ID; Replace(); } } }
/// <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> /// 根据登入的用户ID,获取用户角色ID列表 /// 创建 金协民 2015-7-3 /// </summary> /// <param name="userId"></param> /// <returns></returns> private static List<string> GetUserRole(string adminCode) { List<string> RoleList = new List<string>(); var query = new DapperExQuery<T_ADMIN_ROLES>().AndWhere(n => n.A_CODE, OperationMethod.Equal, adminCode); List<T_ADMIN_ROLES> ROLE_USERS_LIST = new List<T_ADMIN_ROLES>(); //获取用户角色CODE列表 ROLE_USERS_LIST = new T_ADMIN_ROLES_BLL().GetAllList(query); if (ROLE_USERS_LIST != null) { RoleList.AddRange(ROLE_USERS_LIST.Select(q => q.R_CODE)); } else { RoleList = null; } return RoleList; }
/// <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> /// 根据用户角色code来获取权限列表 /// 创建 毛枫 2015-4-21 /// </summary> /// <param name="RoleId"></param> /// <returns></returns> public static List<T_POWERS> GetUserPower(string r_code) { List<T_POWERS> T_POWERS_LIST = new List<T_POWERS>(); List<T_ROLES_POWERS> T_ROLES_POWER_LIST = new List<Mammothcode.Model.T_ROLES_POWERS>(); var query = new DapperExQuery<T_ROLES_POWERS>().AndWhere(n => n.R_CODE, OperationMethod.Equal, r_code); //获取权限列表 T_ROLES_POWER_LIST = T_ROLES_POWERS_BLL.GetAllList(query); if (T_ROLES_POWER_LIST != null) { foreach (T_ROLES_POWERS q in T_ROLES_POWER_LIST) { string powerCode = q.P_CODE; var querypower = new DapperExQuery<T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, powerCode); T_POWERS T_POWERS = new T_POWERS(); //获取权限model T_POWERS = T_POWERS_BLL.GetEntity(querypower); T_POWERS_LIST.Add(T_POWERS); } } else { T_POWERS_LIST = null; } return T_POWERS_LIST; }
/// <summary> /// 私有方法:从数据库中判断用户是否登录 /// 创建 毛枫 2015-4-21 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> private static T_ADMIN IsLoginFromSql(string username, string password) { T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, username) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(password.Trim(), 16)); var admin = T_ADMIN_BLL.GetEntity(query); return admin; }
/// <summary> /// 更新实体 /// 创建人:林以恒 /// 2015年7月6日21:30:29 /// </summary> /// <returns></returns> private T_POWERS Save(T_POWERS powers) { powers.P_NAME = tbxP_Name.Text.Trim(); powers.P_CHINESE_NAME = tbxP_CHINESE_NAME.Text.Trim(); if (powers.ID == 0) { //获取随机码 powers.P_CODE = StringRandomUtil.GuidTo16String(); powers.CREATE_TIME = DateTime.Now; var creatAdminUser = AdminwebUserManager.GetCurrentAdminUser(); if (creatAdminUser != null) { powers.CREATE_USER = creatAdminUser.A_NAME; powers.CREATE_USER_NAME = creatAdminUser.A_CHINESE_NAME; } } //组别 T_POWERS entity = new T_POWERS(); var F_CODE = Request.QueryString["fathercode"]; if (F_CODE != null) { if (F_CODE != "0") { var fatherquery = new DapperExQuery<T_POWERS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, F_CODE); entity = _powersBll.GetEntity(fatherquery); powers.GROUP_NAME = entity.P_CHINESE_NAME; } else { powers.GROUP_NAME = powers.P_CHINESE_NAME; } } return powers; }
/// <summary> /// 编辑角色对应的权限 (待优化) /// 修改人:金协民 2015年7月29日 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnGroupUpdate_Click(object sender, EventArgs e) { var currentUser = AdminwebUserManager.GetCurrentAdminUser(); var roleId = GetSelectedDataKeyID(Grid1); if (string.IsNullOrEmpty(roleId)) { return; } // 当前角色新的权限列表 List<string> newPowerIDs = new List<string>(); for (int i = 0; i < Grid2.Rows.Count; i++) { AspNet.CheckBoxList ddlPowers = (AspNet.CheckBoxList)Grid2.Rows[i].FindControl("ddlPowers"); foreach (AspNet.ListItem item in ddlPowers.Items) { if (item.Selected) { newPowerIDs.Add((item.Value)); } } } //删除原有权限 var query = new DapperExQuery<T_ROLES_POWERS>().AndWhere(n => n.R_CODE, OperationMethod.Equal, roleId); if (T_ROLES_POWERS_BLL.GetEntity(query) != null) { T_ROLES_POWERS_BLL.Delete(query); } int newPowerLen = newPowerIDs.Count; //新增权限 for (var i = 0; i < newPowerLen; i++) { T_ROLES_POWERS T_ROLES_POWERS = new T_ROLES_POWERS { P_CODE = newPowerIDs[i], R_CODE = roleId, CREATE_TIME = DateTime.Now, CREATE_USER = currentUser.A_NAME, CREATE_USER_NAME = currentUser.A_CHINESE_NAME }; T_ROLES_POWERS_BLL.Add(T_ROLES_POWERS); } //Alert.Show(str); }
//============操作方法=========== #region 数据保存 /// <summary> /// 数据保存按钮事件 /// 创建 林以恒 /// 2015年4月14日 /// </summary> protected void btnSaveClose_Click(object sender, EventArgs e) { ////设置页面权限 //Power.SetViewPower("mod_menu"); ////验证权限 //if (Power.VerifyPower() == false) //{ // return; //} string str; if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"].ToString(); //修改 T_ADMIN_MENUS T_ADMIN_MENUS = new T_ADMIN_MENUS(); var q = new DapperExQuery<T_ADMIN_MENUS>().AndWhere(n => n.ID, OperationMethod.Equal, id); T_ADMIN_MENUS = _adminMenusBll.GetEntity(q); T_ADMIN_MENUS = GetnewModel(T_ADMIN_MENUS); str = _adminMenusBll.Update(T_ADMIN_MENUS) ? "修改成功!" : "修改失败!"; } else { //添加 T_ADMIN_MENUS adminMenus = new T_ADMIN_MENUS(); adminMenus = GetnewModel(adminMenus); adminMenus.PARENT_ID = Int32.Parse(Request.QueryString["fatherId"].ToString()); str = _adminMenusBll.Add(adminMenus) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
/// <summary> /// 分组绑定右侧权限 /// 修改人:金协民 2015年7月29日 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid2_RowDataBound(object sender, GridRowEventArgs e) { AspNet.CheckBoxList ddlPowers = (AspNet.CheckBoxList)Grid2.Rows[e.RowIndex].FindControl("ddlPowers"); var GroupName = e.DataItem.GetType().GetProperty("GroupName").GetValue(e.DataItem, null); List<T_POWERS> T_POWERS_LIST = new List<T_POWERS>(); var query = new DapperExQuery<T_POWERS>().AndWhere(n => n.GROUP_NAME, OperationMethod.Equal, GroupName); T_POWERS_LIST = T_POWERS_BLL.GetAllList(query); foreach (var po in T_POWERS_LIST) { AspNet.ListItem item = new AspNet.ListItem { Value = po.P_CODE.ToString(), Text = string.Format("{0}({1})", po.P_CHINESE_NAME, po.P_NAME) }; item.Attributes["data-qtip"] = po.P_NAME; if (_currentRolePowers.ContainsKey(po.P_NAME)) { item.Selected = true; } else { item.Selected = false; } ddlPowers.Items.Add(item); } }
/// <summary> /// 更新实体 /// 创建人:林以恒 /// 2015年7月6日18:16:18 /// </summary> /// <param name="adminMenus"></param> /// <returns></returns> private T_ADMIN_MENUS GetnewModel(T_ADMIN_MENUS adminMenus) { adminMenus.AM_NAME = tbxAM_NAME.Text.Trim(); adminMenus.AM_NAVIGATE_URL = tbxAM_NAVIGATE_URL.Text.Trim(); adminMenus.AM_REMARK = tbxAM_REMARK.Text.Trim(); adminMenus.AM_SORTINDEX = int.Parse(tbxAM_SORTINDEX.Text.Trim()); var queryPower = new DapperExQuery<T_POWERS>().AndWhere(n => n.P_NAME, OperationMethod.Equal, tbxVIEWPOWER_ID.Text.ToString()); var powerid = _powersBll.GetEntity(queryPower); adminMenus.P_CODE= powerid != null ? powerid.P_CODE : ""; adminMenus.AM_ISTREELEAF = tbxAM_NAVIGATE_URL.Text.Trim() == "" ? 0 : 1; if (adminMenus.ID == 0) { //获取登入用户信息 var AdminUserModel = AdminwebUserManager.GetCurrentAdminUser(); if (AdminUserModel != null) { adminMenus.CREATE_USER = AdminUserModel.A_NAME; adminMenus.CREATE_USER_NAME = AdminUserModel.A_CHINESE_NAME; } adminMenus.CREATE_TIME = DateTime.Now; } return adminMenus; }
//============ GRID事件========== #region Grid事件 /// <summary> /// 删除 /// 创建 林以恒 /// 2015年4月14日 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { object[] keys = Grid1.DataKeys[e.RowIndex]; int id = int.Parse(keys[0].ToString()); if (e.CommandName == "Delete") { var query = new DapperExQuery<T_ADMIN_MENUS>().AndWhere(n => n.ID, OperationMethod.Equal, id); Alert.ShowInTop(_adminMenusBll.Delete(query) ? "删除成功!" : "删除失败!"); Replace(); } else { Alert.ShowInTop("点击成功!"); } }
/// <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(); }
//============操作方法=========== #region 数据保存按钮事件 /// <summary> /// 保存 /// 创建人:林以恒 /// 2015年7月6日14:24:11 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveClose_Click(object sender, EventArgs e) { //设置页面权限 power.SetViewPower("mod_admin"); //验证权限 if (power.VerifyPower() == false) { return; } string str; if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"]; //修改 var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id)); var adminUser = _adminUserBll.GetEntity(query); if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text == tbxCfm_Password.Text) { adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); } else if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text != tbxCfm_Password.Text) { Alert.Show("确认密码与填写密码不匹配"); } adminUser = Save(adminUser); str = _adminUserBll.Update(adminUser) ? "修改成功!" : "修改失败!"; } else { T_ADMIN adminUser = new T_ADMIN(); //添加 adminUser = Save(adminUser); if (tbxPassword.Text != tbxCfm_Password.Text) { Alert.Show("确认密码与填写密码不匹配"); } else { adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); } str = _adminUserBll.Add(adminUser) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
/// <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(); } }
//============ GRID事件========== #region 删除 /// <summary> /// 列表数据绑定 /// 创建 林以恒 2015-4-13 /// 修改:林以恒 2015-4-18 /// </summary> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { object[] keys = Grid1.DataKeys[e.RowIndex]; int id = Int32.Parse(keys[0].ToString()); if (e.CommandName != "Delete") return; var query = new DapperExQuery<T_POWERS>().AndWhere(n => n.ID, OperationMethod.Equal, id); Alert.ShowInTop(_powersbll.Delete(query) ? "删除成功!" : "删除失败!"); BindGrid(); }
/// <summary> /// 保存修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_OnClick(object sender, EventArgs e) { string message = ""; T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); try { //①获取当前登录用户 AdminUserModel adminInfo = AdminwebUserManager.GetCurrentAdminUser(); //②判断当前登录用户原密码 var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, adminInfo.A_CODE) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(tbxOriPassword.Text.Trim(), 16)); var entity = T_ADMIN_BLL.GetEntity(query); if (entity != null) { //③判断确认密码是否等于密码 if (tbxPassword.Text == tbxCfm_Password.Text) { //④保存新密码 entity.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); if (new T_ADMIN_BLL().Update(entity)) { message = "修改成功"; updateWindow.Hidden = true; } else { message = "修改失败"; } } else { message = "确认密码错误"; } } else { message = "用户密码错误,请输入原密码"; } } catch (Exception ex) { message = ex.ToString(); } Alert.Show(message); }
//============操作方法=========== #region 数据保存 /// <summary> /// 数据保存按钮事件 /// 创建人:林以恒 /// 2015年7月6日21:28:17 /// </summary> protected void btnSaveClose_Click(object sender, EventArgs e) { ////设置页面权限 //Power.SetViewPower("mod_power"); ////验证权限 //if (Power.VerifyPower() == false) //{ // return; //} string str; if (Request.QueryString["id"].IsNum()) { T_POWERS powers = null; string id = Request.QueryString["id"]; //修改 var query = new DapperExQuery<T_POWERS>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id)); powers = _powersBll.GetEntity(query); powers = Save(powers); str = _powersBll.Update(powers) ? "修改成功!" : "修改失败!"; } else { T_POWERS powers = new T_POWERS(); //添加 powers = Save(powers); powers.FATHER_CODE = Request.QueryString["fathercode"].ToString(); str = _powersBll.Add(powers) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
/// <summary> /// 根据用户权限,获取菜单列表 /// </summary> /// <returns></returns> public List<T_ADMIN_MENUS> Get_PowerMenu() { List<T_ADMIN_MENUS> T_ADMIN_MENUS_LIST = new List<T_ADMIN_MENUS>(); List<T_POWERS> T_POWERS_LIST = new List<T_POWERS>(); T_POWERS_LIST = T_POWERS_BLL.GetAllList(); int count = T_POWERS_LIST.Count; int j = 0; for (int i = 0; i < count; i++) { if (AdminwebUserManager.CompareRole(T_POWERS_LIST[i].P_NAME)) { string p_code = T_POWERS_LIST[i].P_CODE; var query = new DapperExQuery<T_ADMIN_MENUS>().AndWhere(n => n.P_CODE, OperationMethod.Equal, p_code); T_ADMIN_MENUS T_ADMIN_MENUS = new T_ADMIN_MENUS(); T_ADMIN_MENUS = T_ADMIN_MENUS_BLL.GetEntity(query); if (T_ADMIN_MENUS != null) { T_ADMIN_MENUS_LIST.Add(T_ADMIN_MENUS); } } } //排序 T_ADMIN_MENUS q = new T_ADMIN_MENUS(); for (int i = 0; i < T_ADMIN_MENUS_LIST.Count - 1; i++) { for (j = 0; j < T_ADMIN_MENUS_LIST.Count - 1 - i; j++) { if (T_ADMIN_MENUS_LIST[j].AM_SORTINDEX > T_ADMIN_MENUS_LIST[j + 1].AM_SORTINDEX) { q = T_ADMIN_MENUS_LIST[j]; T_ADMIN_MENUS_LIST[j] = T_ADMIN_MENUS_LIST[j + 1]; T_ADMIN_MENUS_LIST[j + 1] = q; } } } //T_ADMIN_MENUS_LIST = T_ADMIN_MENUS_LIST.OrderBy(n => n.AM_SORTINDEX) as List<T_ADMIN_MENUS>; return T_ADMIN_MENUS_LIST; }