/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysMenuPost_UpdateSet">UpdateSet用户对象</param> /// <param name="tSysMenuPost_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysMenuPostVo tSysMenuPost_UpdateSet, TSysMenuPostVo tSysMenuPost_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tSysMenuPost_UpdateSet, TSysMenuPostVo.T_SYS_MENU_POST_TABLE); strSQL += this.BuildWhereStatement(tSysMenuPost_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysMenuPost">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysMenuPostVo tSysMenuPost) { string strSQL = SqlHelper.BuildUpdateExpress(tSysMenuPost, TSysMenuPostVo.T_SYS_MENU_POST_TABLE); strSQL += string.Format(" where ID='{0}' ", tSysMenuPost.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysMenuPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysMenuPostVo tSysMenuPost, int iIndex, int iCount) { string strSQL = " select * from T_SYS_MENU_POST {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tSysMenuPost)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysMenuPostVo tSysMenuPost) { string strSQL = "delete from T_SYS_MENU_POST "; strSQL += this.BuildWhereStatement(tSysMenuPost); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tSysMenuPost"></param> /// <returns></returns> public string BuildWhereStatement(TSysMenuPostVo tSysMenuPost) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tSysMenuPost) { //编号 if (!String.IsNullOrEmpty(tSysMenuPost.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tSysMenuPost.ID.ToString())); } //人员ID if (!String.IsNullOrEmpty(tSysMenuPost.POST_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POST_ID = '{0}'", tSysMenuPost.POST_ID.ToString())); } //人员职位类型,1,人员,2,职位 if (!String.IsNullOrEmpty(tSysMenuPost.RIGHT_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND RIGHT_TYPE = '{0}'", tSysMenuPost.RIGHT_TYPE.ToString())); } //菜单编号 if (!String.IsNullOrEmpty(tSysMenuPost.MENU_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MENU_ID = '{0}'", tSysMenuPost.MENU_ID.ToString())); } //备注 if (!String.IsNullOrEmpty(tSysMenuPost.REMARK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK = '{0}'", tSysMenuPost.REMARK.ToString())); } //备注1 if (!String.IsNullOrEmpty(tSysMenuPost.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tSysMenuPost.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tSysMenuPost.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tSysMenuPost.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tSysMenuPost.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tSysMenuPost.REMARK3.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 点击职位树节点或者用户列表,获取有权限菜单id字符串 /// </summary> /// <param name="strPostID">职位或者用户id</param> /// <param name="strRightType">职位或者用户,1用户,2职位</param> /// <returns></returns> private string ClickPostTreeNode(string strPostID, string strRightType) { string strResult = ""; TSysMenuPostVo objMenuPostVo = new TSysMenuPostVo(); objMenuPostVo.RIGHT_TYPE = strRightType; objMenuPostVo.POST_ID = strPostID; DataTable dt = new TSysMenuPostLogic().SelectByTable(objMenuPostVo); if (dt.Rows.Count < 1) { return(""); } for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; strResult += (strResult.Length > 0 ? "|":"") + dr[TSysMenuPostVo.MENU_ID_FIELD].ToString(); } return(strResult); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysMenuPost">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysMenuPostVo tSysMenuPost) { return(access.GetSelectResultCount(tSysMenuPost)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysMenuPostVo tSysMenuPost) { return(access.Delete(tSysMenuPost)); }
public TSysMenuPostLogic(TSysMenuPostVo _tSysMenuPost) { tSysMenuPost = _tSysMenuPost; access = new TSysMenuPostAccess(); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysMenuPost">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysMenuPostVo tSysMenuPost) { return(access.Edit(tSysMenuPost)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysMenuPost_UpdateSet">UpdateSet用户对象</param> /// <param name="tSysMenuPost_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysMenuPostVo tSysMenuPost_UpdateSet, TSysMenuPostVo tSysMenuPost_UpdateWhere) { return(access.Edit(tSysMenuPost_UpdateSet, tSysMenuPost_UpdateWhere)); }
/// <summary> /// 权限的菜单树节点选中,保存权限 /// </summary> /// <param name="strPostID">职位或者用户id</param> /// <param name="strChkMenuNodes">选择节点id串</param> /// <param name="strRightType">职位或者用户,1用户,2职位</param> /// <returns></returns> private string SaveCheckMenuNode(string strPostID, string strChkMenuNodes, string strRightType) { string strlogName = "用户"; if (strRightType == "2") { strlogName = "职位"; } string strResult = ""; if (strChkMenuNodes == "")//传入空串,将有关该职位或人员的权限全部删除 { TSysMenuPostVo objMenuPostVoDel = new TSysMenuPostVo(); objMenuPostVoDel.POST_ID = strPostID; objMenuPostVoDel.RIGHT_TYPE = strRightType; new TSysMenuPostLogic().Delete(objMenuPostVoDel); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditUserRight, objMenuPostVoDel.ID, LogInfo.UserInfo.USER_NAME + "删除" + strlogName + ": " + objMenuPostVoDel.ID + " 的所有树菜单权限成功!"); return(strResult); } string[] arrChkMenuNodes = strChkMenuNodes.Split('|'); //查询该该职位或人员原有权限 TSysMenuPostVo objMenuPostVo = new TSysMenuPostVo(); objMenuPostVo.RIGHT_TYPE = strRightType; objMenuPostVo.POST_ID = strPostID; DataTable dt = new TSysMenuPostLogic().SelectByTable(objMenuPostVo); //查询不到,说明原来该职位或人员无权限,直接增加即可 if (dt.Rows.Count < 1) { for (int i = 0; i < arrChkMenuNodes.Length; i++) { TSysMenuPostVo objMenuPostVoAdd = new TSysMenuPostVo(); objMenuPostVoAdd.ID = GetSerialNumber("t_sys_menu_Post_id"); objMenuPostVoAdd.POST_ID = strPostID; objMenuPostVoAdd.RIGHT_TYPE = strRightType; objMenuPostVoAdd.MENU_ID = arrChkMenuNodes[i]; new TSysMenuPostLogic().Create(objMenuPostVoAdd); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditUserRight, objMenuPostVoAdd.ID, LogInfo.UserInfo.USER_NAME + "增加" + strlogName + ": " + objMenuPostVo.ID + " 的树菜单权限" + objMenuPostVoAdd.MENU_ID + "成功!"); } return(strResult); } //比对传来的权限字符串和数据库查询结果,进行比较 //存在于权限字符串,而不存在于数据库的,增加 //存在于数据库,而不存在于的权限字符串,删除 string strRights = ""; for (int i = 0; i < dt.Rows.Count; i++) { strRights += (strRights.Length > 0 ? "|" : "") + dt.Rows[i][TSysMenuPostVo.MENU_ID_FIELD].ToString(); } //存在于权限字符串,而不存在于数据库的,增加 for (int i = 0; i < arrChkMenuNodes.Length; i++) { if (!strRights.Contains(arrChkMenuNodes[i])) { TSysMenuPostVo objMenuPostVoAdd = new TSysMenuPostVo(); objMenuPostVoAdd.ID = GetSerialNumber("t_sys_menu_Post_id"); objMenuPostVoAdd.POST_ID = strPostID; objMenuPostVoAdd.RIGHT_TYPE = strRightType; objMenuPostVoAdd.MENU_ID = arrChkMenuNodes[i]; new TSysMenuPostLogic().Create(objMenuPostVoAdd); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditUserRight, objMenuPostVoAdd.ID, LogInfo.UserInfo.USER_NAME + "增加" + strlogName + ": " + objMenuPostVo.ID + " 的树菜单权限" + objMenuPostVoAdd.MENU_ID + "成功!"); } } //存在于数据库,而不存在于的权限字符串,删除 for (int i = 0; i < dt.Rows.Count; i++) { if (!strChkMenuNodes.Contains(dt.Rows[i][TSysMenuPostVo.MENU_ID_FIELD].ToString())) { TSysMenuPostVo objMenuPostVoDel = new TSysMenuPostVo(); objMenuPostVoDel.POST_ID = strPostID; objMenuPostVoDel.RIGHT_TYPE = strRightType; objMenuPostVoDel.MENU_ID = dt.Rows[i][TSysMenuPostVo.MENU_ID_FIELD].ToString(); new TSysMenuPostLogic().Delete(objMenuPostVoDel); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditUserRight, objMenuPostVoDel.ID, LogInfo.UserInfo.USER_NAME + "删除" + strlogName + ": " + objMenuPostVo.ID + " 的树菜单权限" + objMenuPostVoDel.MENU_ID + "成功!"); } } return(strResult); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tSysMenuPost">对象</param> /// <returns>是否成功</returns> public bool Create(TSysMenuPostVo tSysMenuPost) { string strSQL = SqlHelper.BuildInsertExpress(tSysMenuPost, TSysMenuPostVo.T_SYS_MENU_POST_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysMenuPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysMenuPostVo tSysMenuPost, int iIndex, int iCount) { return(access.SelectByTable(tSysMenuPost, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysMenuPost">对象条件</param> /// <returns>对象</returns> public TSysMenuPostVo Details(TSysMenuPostVo tSysMenuPost) { return(access.Details(tSysMenuPost)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysMenuPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysMenuPostVo> SelectByObject(TSysMenuPostVo tSysMenuPost, int iIndex, int iCount) { string strSQL = String.Format("select * from T_SYS_MENU_POST " + this.BuildWhereStatement(tSysMenuPost)); return(SqlHelper.ExecuteObjectList(tSysMenuPost, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysMenuPost">对象条件</param> /// <returns>对象</returns> public TSysMenuPostVo Details(TSysMenuPostVo tSysMenuPost) { string strSQL = String.Format("select * from T_SYS_MENU_POST " + this.BuildWhereStatement(tSysMenuPost)); return(SqlHelper.ExecuteObject(new TSysMenuPostVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysMenuPost">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysMenuPostVo tSysMenuPost) { string strSQL = "select Count(*) from T_SYS_MENU_POST " + this.BuildWhereStatement(tSysMenuPost); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysMenuPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysMenuPostVo> SelectByObject(TSysMenuPostVo tSysMenuPost, int iIndex, int iCount) { return(access.SelectByObject(tSysMenuPost, iIndex, iCount)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysMenuPost"></param> /// <returns></returns> public DataTable SelectByTable(TSysMenuPostVo tSysMenuPost) { string strSQL = "select * from T_SYS_MENU_POST " + this.BuildWhereStatement(tSysMenuPost); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysMenuPost"></param> /// <returns></returns> public DataTable SelectByTable(TSysMenuPostVo tSysMenuPost) { return(access.SelectByTable(tSysMenuPost)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tSysMenuPost">对象</param> /// <returns></returns> public TSysMenuPostVo SelectByObject(TSysMenuPostVo tSysMenuPost) { return(access.SelectByObject(tSysMenuPost)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TSysMenuPostVo tSysMenuPost) { return(access.Create(tSysMenuPost)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tSysMenuPost">对象</param> /// <returns></returns> public TSysMenuPostVo SelectByObject(TSysMenuPostVo tSysMenuPost) { string strSQL = "select * from T_SYS_MENU_POST " + this.BuildWhereStatement(tSysMenuPost); return(SqlHelper.ExecuteObject(new TSysMenuPostVo(), strSQL)); }