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);
}
}
