public bool AddSysModule(Model_SysModule model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SysModule("); builder.Append("MODULEID,SYSCODE,MODULENAME,PARENTID,SLEVEL,URL,QUERYFORM,OTHKEY,REMARK,IMGICON,ISINTREE,MODULETYPE,ATTACH_SQL,ISINTAB,Depth,isLast,DefaultOrder)"); builder.Append(" values ("); builder.Append("@MODULEID,@SYSCODE,@MODULENAME,@PARENTID,@SLEVEL,@URL,@QUERYFORM,@OTHKEY,@REMARK,@IMGICON,@ISINTREE,@MODULETYPE,@ATTACH_SQL,@ISINTAB,@Depth,@isLast,@DefaultOrder)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@MODULEID", SqlDbType.VarChar, 20), new SqlParameter("@SYSCODE", SqlDbType.NChar, 5), new SqlParameter("@MODULENAME", SqlDbType.VarChar, 200), new SqlParameter("@PARENTID", SqlDbType.VarChar, 20), new SqlParameter("@SLEVEL", SqlDbType.VarChar, 0xff), new SqlParameter("@URL", SqlDbType.VarChar, 0xff), new SqlParameter("@QUERYFORM", SqlDbType.VarChar, 0xff), new SqlParameter("@OTHKEY", SqlDbType.VarChar, 0xff), new SqlParameter("@REMARK", SqlDbType.VarChar, 0xff), new SqlParameter("@IMGICON", SqlDbType.VarChar, 50), new SqlParameter("@ISINTREE", SqlDbType.Char, 1), new SqlParameter("@MODULETYPE", SqlDbType.VarChar, 50), new SqlParameter("@ATTACH_SQL", SqlDbType.VarChar, 0xff), new SqlParameter("@ISINTAB", SqlDbType.Char, 1), new SqlParameter("@Depth", SqlDbType.Int, 4), new SqlParameter("@isLast", SqlDbType.Int, 4), new SqlParameter("@DefaultOrder", SqlDbType.Int, 4) }; cmdParms[0].Value = model.MODULEID; cmdParms[1].Value = "00001"; cmdParms[2].Value = model.MODULENAME; cmdParms[3].Value = model.PARENTID; cmdParms[4].Value = model.SLEVEL; cmdParms[5].Value = model.URL; cmdParms[6].Value = model.QUERYFORM; cmdParms[7].Value = model.OTHKEY; cmdParms[8].Value = model.REMARK; cmdParms[9].Value = model.IMGICON; cmdParms[10].Value = model.ISINTREE; cmdParms[11].Value = model.MODULETYPE; cmdParms[12].Value = model.ATTACH_SQL; cmdParms[13].Value = model.ISINTAB; cmdParms[14].Value = model.Depth; cmdParms[15].Value = model.isLast; cmdParms[0x10].Value = model.DefaultOrder; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
/// <summary> /// 判断是否存在 /// </summary> /// <param name="type">1添加时,2修改时</param> /// <returns>已存在返回true</returns> private bool CheckExists(Model_SysModule model, string type) { try { return(sysModuleBll.ExistsSysModule(model, type)); } catch (Exception) { return(true); } }
//绑定控件 protected void BindData(string moduleID, string sysCode) { try { Model_SysModule model = sysModuleBll.GetSysModuleModelBySyscodeAndModuleID(sysCode, moduleID); //如果是类似新增 if (actionType == "1") { txtMODULEID.Text = model.MODULEID; } else { txtMODULEID.Text = model.MODULEID; txtMODULEID.Enabled = false; } txtMODULENAME.Text = model.MODULENAME; txtPARENTID.Text = model.PARENTID; txtSLEVEL.Text = model.SLEVEL; txtURL.Text = model.URL; if (model.ISINTREE == "Y") { rbtISINTREE1.Checked = true; } else { rbtISINTREE0.Checked = true; } txtDepth.Text = model.Depth.ToString().Trim(); ddlSysCode.SelectedValue = model.SYSCODE; //修改时 if (actionType == "2") { ddlSysCode.Enabled = false; } if (model.isLast == 1) { rbtisLast1.Checked = true; } else { rbtisLast0.Checked = true; } txtDefaultOrder.Text = model.DefaultOrder.ToString().Trim(); } catch (Exception ex) { Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(loginUser.SysUser_ID, Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
public bool Update(Model_SysModule model) { StringBuilder builder = new StringBuilder(); builder.Append("update SysModule set "); builder.Append("MODULEID=@MODULEID,"); builder.Append("MODULENAME=@MODULENAME,"); builder.Append("PARENTID=@PARENTID,"); builder.Append("SLEVEL=@SLEVEL,"); builder.Append("URL=@URL,"); builder.Append("QUERYFORM=@QUERYFORM,"); builder.Append("OTHKEY=@OTHKEY,"); builder.Append("REMARK=@REMARK,"); builder.Append("IMGICON=@IMGICON,"); builder.Append("ISINTREE=@ISINTREE,"); builder.Append("MODULETYPE=@MODULETYPE,"); builder.Append("ATTACH_SQL=@ATTACH_SQL,"); builder.Append("ISINTAB=@ISINTAB,"); builder.Append("Depth=@Depth,"); builder.Append("isLast=@isLast,"); builder.Append("DefaultOrder=@DefaultOrder,"); builder.Append("syscode=@syscode"); builder.Append(" where "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@MODULEID", SqlDbType.VarChar, 20), new SqlParameter("@MODULENAME", SqlDbType.VarChar, 200), new SqlParameter("@PARENTID", SqlDbType.VarChar, 20), new SqlParameter("@SLEVEL", SqlDbType.VarChar, 0xff), new SqlParameter("@URL", SqlDbType.VarChar, 0xff), new SqlParameter("@QUERYFORM", SqlDbType.VarChar, 0xff), new SqlParameter("@OTHKEY", SqlDbType.VarChar, 0xff), new SqlParameter("@REMARK", SqlDbType.VarChar, 0xff), new SqlParameter("@IMGICON", SqlDbType.VarChar, 50), new SqlParameter("@ISINTREE", SqlDbType.Char, 1), new SqlParameter("@MODULETYPE", SqlDbType.VarChar, 50), new SqlParameter("@ATTACH_SQL", SqlDbType.VarChar, 0xff), new SqlParameter("@ISINTAB", SqlDbType.Char, 1), new SqlParameter("@Depth", SqlDbType.Int, 4), new SqlParameter("@isLast", SqlDbType.Int, 4), new SqlParameter("@DefaultOrder", SqlDbType.Int, 4), new SqlParameter("@syscode", SqlDbType.NChar, 5) }; cmdParms[0].Value = model.MODULEID; cmdParms[1].Value = model.MODULENAME; cmdParms[2].Value = model.PARENTID; cmdParms[3].Value = model.SLEVEL; cmdParms[4].Value = model.URL; cmdParms[5].Value = model.QUERYFORM; cmdParms[6].Value = model.OTHKEY; cmdParms[7].Value = model.REMARK; cmdParms[8].Value = model.IMGICON; cmdParms[9].Value = model.ISINTREE; cmdParms[10].Value = model.MODULETYPE; cmdParms[11].Value = model.ATTACH_SQL; cmdParms[12].Value = model.ISINTAB; cmdParms[13].Value = model.Depth; cmdParms[14].Value = model.isLast; cmdParms[15].Value = model.DefaultOrder; cmdParms[0x10].Value = model.syscode; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
//绑定模块 protected Model_SysModule InsertOrUpdate() { try { Model_SysModule model = new Model_SysModule(); model.MODULEID = txtMODULEID.Text.Trim(); model.MODULENAME = txtMODULENAME.Text.Trim(); model.PARENTID = txtPARENTID.Text.Trim(); model.SLEVEL = txtSLEVEL.Text.Trim(); model.URL = txtURL.Text.Trim(); if (rbtISINTREE1.Checked) { model.ISINTREE = "Y"; } else { model.ISINTREE = "N"; } if (!string.IsNullOrEmpty(txtDepth.Text.Trim()) && IsInt(txtDepth.Text.Trim())) { model.Depth = int.Parse(txtDepth.Text.Trim()); } if (rbtisLast1.Checked) { model.isLast = 1; } else { model.isLast = 0; } if (ddlSysCode.SelectedValue.Trim() != null && ddlSysCode.SelectedValue.Trim() != "" && ddlSysCode.SelectedValue.Trim() != "-1") { model.SYSCODE = ddlSysCode.SelectedValue.Trim(); } if (txtDefaultOrder.Text.Trim() != "" && IsInt(txtDefaultOrder.Text.Trim())) { model.DefaultOrder = int.Parse(txtDefaultOrder.Text.Trim()); } return(model); } catch (Exception ex) { Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(loginUser.SysUser_ID, Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
//绑定控件 protected void BindData(string moduleID) { try { Model_SysModule model = sysModuleBll.GetSysModuleModelBySyscodeAndModuleID(moduleID); //如果是类似新增 if (actionType == "1") { txtMODULEID.Text = model.MODULEID; } else { txtMODULEID.Text = model.MODULEID; txtMODULEID.Enabled = false; } txtMODULENAME.Text = model.MODULENAME; txtPARENTID.Text = model.PARENTID; txtSLEVEL.Text = model.SLEVEL; txtURL.Text = model.URL; if (model.ISINTREE == "Y") { rbtISINTREE1.Checked = true; } else { rbtISINTREE0.Checked = true; } txtDepth.Text = model.Depth.ToString().Trim(); if (model.isLast == 1) { rbtisLast1.Checked = true; } else { rbtisLast0.Checked = true; } txtDefaultOrder.Text = model.DefaultOrder.ToString().Trim(); } catch (Exception ex) { new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
public List <Model_SysModule> DataTableToList(DataTable dt) { List <Model_SysModule> list = new List <Model_SysModule>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SysModule item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool ExistsSysModule(Model_SysModule model, string type) { StringBuilder builder = new StringBuilder(); bool flag = false; if (type == "1") { builder.AppendFormat("SELECT COUNT(*) FROM SysModule WHERE SysCode='{0}' and MODULEID='{1}'", model.SYSCODE, model.MODULEID); } else if (type == "2") { builder.AppendFormat("SELECT COUNT(*) FROM SysModule WHERE SysCode='{0}' and MODULEID!='{1}'", model.SYSCODE, model.MODULEID); } if (int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0) { flag = true; } return(flag); }
//绑定模块 protected Model_SysModule InsertOrUpdate() { try { Model_SysModule model = new Model_SysModule(); model.MODULEID = txtMODULEID.Text.Trim(); model.MODULENAME = txtMODULENAME.Text.Trim(); model.PARENTID = txtPARENTID.Text.Trim(); model.SLEVEL = txtSLEVEL.Text.Trim(); model.URL = txtURL.Text.Trim(); if (rbtISINTREE1.Checked) { model.ISINTREE = "Y"; } else { model.ISINTREE = "N"; } if (!string.IsNullOrEmpty(txtDepth.Text.Trim()) && txtDepth.Text.Trim().IsInt()) { model.Depth = int.Parse(txtDepth.Text.Trim()); } if (rbtisLast1.Checked) { model.isLast = 1; } else { model.isLast = 0; } if (txtDefaultOrder.Text.Trim() != "" && txtDefaultOrder.Text.Trim().IsInt()) { model.DefaultOrder = int.Parse(txtDefaultOrder.Text.Trim()); } return(model); } catch (Exception ex) { new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
protected void btn_Search_Click(object sender, EventArgs e) { try { CheckInput(); Model_SysModule model = InsertOrUpdate(); if (module_ID != null && module_ID != "" && actionType == "2") { if (sysModuleBll.UpdateSysModuleBySyscodeAndModuleID(model)) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.Handel('操作成功', '');</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.showTipsErr('修改模块失败!', '4');</script>"); } } else { if (CheckExists(model, "1")) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.showTipsErr('此模块ID已存在', '4');</script>"); } else { if (sysModuleBll.AddSysModule(model)) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.Handel('操作成功', '');</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.showTipsErr('新增模块失败!', '4');</script>"); } } } } catch (Exception ex) { Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(loginUser.SysUser_ID, Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
protected void btn_Search_Click(object sender, EventArgs e) { try { Model_SysModule model = InsertOrUpdate(); if (module_ID != null && module_ID != "" && actionType == "2") { if (sysModuleBll.UpdateSysModuleBySyscodeAndModuleID(model)) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('编辑成功',{icon:1,time:1000},function(){parent.window.location.href=window.parent.pageUrl})})})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('修改失败',{icon:2})})})</script>"); } } else { if (CheckExists(model, "1")) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('此模块ID已存在',{icon:4})})})</script>"); } else { if (sysModuleBll.AddSysModule(model)) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('操作成功',{icon:1,time:1000},function(){parent.window.location.href=window.parent.pageUrl})})})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('新增模块失败',{icon:2})})})</script>"); } } } } catch (Exception ex) { new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
// // 摘要: // 在过程请求授权时调用。 // // 参数: // filterContext: // 筛选器上下文,它封装有关使用 System.Web.Mvc.AuthorizeAttribute 的信息。 // // 异常: // T:System.ArgumentNullException: // filterContext 参数为 null。 public override void OnAuthorization(AuthorizationContext filterContext) { // base.OnAuthorization(filterContext); /** * 如果请求的区域包含area并且area的名称等于Admin * 那么就进行权限验证 * */ if (filterContext.RouteData.DataTokens.Keys.Contains("area")) // && filterContext.RouteData.DataTokens["area"].ToString().ToLower().IndexOf("_area")>0) { /* * Action方法本身以及它所属的控制器都没有定义Skip特性 * 那么就进行权限验证 */ if (!filterContext.ActionDescriptor.IsDefined(typeof(SkipAttribute), false) && !filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(SkipAttribute), false)) { /* * 判断有没有登录 */ if (!Model_UserInfo.IsLogin()) { filterContext.Result = new BaseController().Redirect("/AdminLogin/Login", filterContext.ActionDescriptor, AjaxStatu.nologin); return; } string areaName = filterContext.RouteData.DataTokens["area"].ToString(); string actionName = filterContext.ActionDescriptor.ActionName; string controlName = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName; string httpMethod = filterContext.RequestContext.HttpContext.Request.HttpMethod; RequestMethod method = httpMethod.ToLower().Equals("get") ? RequestMethod.GET : httpMethod.ToLower().Equals("post") ? RequestMethod.POST : RequestMethod.HEAD; if (!Model_SysModule.ExistsPermission(areaName, controlName, actionName, method)) { filterContext.Result = new BaseController().Redirect("/AdminLogin/Login", filterContext.ActionDescriptor, AjaxStatu.nopermission); return; } } } }
public bool ExistsSysModule(Model_SysModule model, string type) { return(this.DAL.ExistsSysModule(model, type)); }
public bool Update(Model_SysModule model) { return(this.dal.Update(model)); }
public bool Add(Model_SysModule model) { return(this.dal.Add(model)); }
public Model_SysModule DataRowToModel(DataRow row) { Model_SysModule module = new Model_SysModule(); if (row != null) { if (row["MODULEID"] != null) { module.MODULEID = row["MODULEID"].ToString(); } if (row["SYSCODE"] != null) { module.SYSCODE = row["SYSCODE"].ToString(); } if (row["MODULENAME"] != null) { module.MODULENAME = row["MODULENAME"].ToString(); } if (row["PARENTID"] != null) { module.PARENTID = row["PARENTID"].ToString(); } if (row["SLEVEL"] != null) { module.SLEVEL = row["SLEVEL"].ToString(); } if (row["URL"] != null) { module.URL = row["URL"].ToString(); } if (row["QUERYFORM"] != null) { module.QUERYFORM = row["QUERYFORM"].ToString(); } if (row["OTHKEY"] != null) { module.OTHKEY = row["OTHKEY"].ToString(); } if (row["REMARK"] != null) { module.REMARK = row["REMARK"].ToString(); } if (row["IMGICON"] != null) { module.IMGICON = row["IMGICON"].ToString(); } if (row["ISINTREE"] != null) { module.ISINTREE = row["ISINTREE"].ToString(); } if (row["MODULETYPE"] != null) { module.MODULETYPE = row["MODULETYPE"].ToString(); } if (row["ATTACH_SQL"] != null) { module.ATTACH_SQL = row["ATTACH_SQL"].ToString(); } if (row["ISINTAB"] != null) { module.ISINTAB = row["ISINTAB"].ToString(); } if ((row["Depth"] != null) && (row["Depth"].ToString() != "")) { module.Depth = new int?(int.Parse(row["Depth"].ToString())); } if ((row["isLast"] != null) && (row["isLast"].ToString() != "")) { module.isLast = new int?(int.Parse(row["isLast"].ToString())); } if ((row["DefaultOrder"] != null) && (row["DefaultOrder"].ToString() != "")) { module.DefaultOrder = new int?(int.Parse(row["DefaultOrder"].ToString())); } } return(module); }
internal Model_SysModule GetSysModuleModelBySyscodeAndModuleID(DbTransaction tran, string moduleid) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT "); builder.Append(" TOP 1 * "); builder.Append(" FROM "); builder.Append(" SysModule "); builder.Append(" WHERE "); builder.Append(" MODULEID=@MODULEID "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@MODULEID", SqlDbType.VarChar, 20) }; cmdParms[0].Value = moduleid; DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); Model_SysModule module = null; if (set.Tables[0].Rows.Count > 0) { DataRow row = set.Tables[0].Rows[0]; module = new Model_SysModule(); if (row["MODULEID"] != null) { module.MODULEID = row["MODULEID"].ToString(); } if (row["MODULENAME"] != null) { module.MODULENAME = row["MODULENAME"].ToString(); } if (row["PARENTID"] != null) { module.PARENTID = row["PARENTID"].ToString(); } if (row["SLEVEL"] != null) { module.SLEVEL = row["SLEVEL"].ToString(); } if (row["URL"] != null) { module.URL = row["URL"].ToString(); } if (row["QUERYFORM"] != null) { module.QUERYFORM = row["QUERYFORM"].ToString(); } if (row["OTHKEY"] != null) { module.OTHKEY = row["OTHKEY"].ToString(); } if (row["REMARK"] != null) { module.REMARK = row["REMARK"].ToString(); } if (row["IMGICON"] != null) { module.IMGICON = row["IMGICON"].ToString(); } if (row["ISINTREE"] != null) { module.ISINTREE = row["ISINTREE"].ToString(); } if (row["MODULETYPE"] != null) { module.MODULETYPE = row["MODULETYPE"].ToString(); } if (row["ATTACH_SQL"] != null) { module.ATTACH_SQL = row["ATTACH_SQL"].ToString(); } if (row["ISINTAB"] != null) { module.ISINTAB = row["ISINTAB"].ToString(); } if (row["Depth"] != null) { if (string.IsNullOrWhiteSpace(row["Depth"].ToString())) { module.Depth = null; } else { module.Depth = new int?(int.Parse(row["Depth"].ToString())); } } if (row["isLast"] != null) { if (string.IsNullOrWhiteSpace(row["isLast"].ToString())) { module.isLast = null; } else { module.isLast = new int?(int.Parse(row["isLast"].ToString())); } } if (row["DefaultOrder"] == null) { return(module); } if (string.IsNullOrWhiteSpace(row["DefaultOrder"].ToString())) { module.DefaultOrder = null; return(module); } module.DefaultOrder = new int?(int.Parse(row["DefaultOrder"].ToString())); } return(module); }
public bool AddSysModule(Model_SysModule model) { return(this.DAL.AddSysModule(model)); }
public bool UpdateSysModuleBySyscodeAndModuleID(Model_SysModule model) { return(this.DAL.UpdateSysModuleBySyscodeAndModuleID(model)); }