public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string ModuleID = context.Request.QueryString["ModuleID"].Trim(); //if (mbll.GetTable("Md_parentid='" + ModuleID.Trim() + "' AND Md_deleteFlag =0").Rows.Count == 0) IList <MySqlParameter> parm = new List <MySqlParameter>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" Md_parentid=@Md_parentid AND Md_deleteFlag =0"); parm.Add(new MySqlParameter("@Md_parentid", ModuleID.Trim())); if (mbll.GetTable(strWhere.ToString(), parm).Rows.Count == 0) { //删除模块 //mbll.DelModules(" Md_deleteFlag=1", " Md_id='" + ModuleID + "'"); IList <MySqlParameter> parmD = new List <MySqlParameter>(); StringBuilder strWhereD = new StringBuilder(); strWhereD.Append(" Md_id=@ModuleID"); parmD.Add(new MySqlParameter("@ModuleID", ModuleID)); mbll.DelModules(" Md_deleteFlag=1", strWhereD.ToString(), parmD); //删除模块权限 mpbll.RemoveByPK(ModuleID); //删除角色、模块、权限 rmpbll.RemoveByPK(ModuleID); //返回删除完成 context.Response.Write("0|" + ModuleID); } else { //返回请先删除下级模块! context.Response.Write("1|" + ModuleID); } }
/// <summary> /// 判断某一平台下父模块名称是否存在 /// </summary> /// <returns></returns> private bool CheckModuleName() { //if (mdManage.GetTable(string.Format(" Pf_id = '{0}' AND Md_name = '{1}' AND Md_deleteFlag = 0 ", this.ddlPf.SelectedValue, this.txtMdName.Text.Trim())).Rows.Count > 0) IList <MySqlParameter> parm = new List <MySqlParameter>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" Pf_id = @Pf_id AND Md_name = @Md_name AND Md_deleteFlag = 0 "); parm.Add(new MySqlParameter("@Pf_id", this.ddlPf.SelectedValue)); parm.Add(new MySqlParameter("@Md_name", this.txtMdName.Text.Trim())); //if (mdManage.GetTable(string.Format(" Pf_id = '{0}' AND Md_name = '{1}' AND Md_deleteFlag = 0 ", this.ddlPf.SelectedValue, this.txtMdName.Text.Trim())).Rows.Count > 0) if (mdManage.GetTable(strWhere.ToString(), parm).Rows.Count > 0) { return(false); } else { return(true); } }