// public bool Update(SysFun model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_SysFun set "); strSql.Append("DisplayName=@DisplayName,"); strSql.Append("NodeURL=@NodeURL,"); strSql.Append("DisplayOrder=@DisplayOrder,"); strSql.Append("ParentNodeId=@ParentNodeId,"); strSql.Append("Editor=@Editor,"); strSql.Append("FunImgNum=@FunImgNum,"); strSql.Append("CreateDate=@CreateDate"); strSql.Append(" where NodeId=@NodeId"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }
/// <summary> /// 修改NodeId所对应的记录 (只修改DisplayOrder属性) /// </summary> /// <param name="nodeId"></param> /// <param name="sys"></param> /// <returns></returns> public static int UpdateSysFun(int nodeId, SysFun sys) { string sql = "update SysFun set DisplayOrder=@DisplayOrder where nodeId=@nodeId"; SqlParameter[] parameters = { new SqlParameter("@DisplayOrder", sys.DisplayOrder), new SqlParameter("@nodeId", nodeId) }; return(DBHelper.ExecuteCommand(sql, parameters)); }
/// <summary> /// 交换两个对象的displayOrder值 /// </summary> /// <param name="oldNodeId"></param> /// <param name="newNodeId"></param> private static void ChangeNode(int oldNodeId, int newNodeId) { SysFun oldSys = SysFunService.GetSysFunById(oldNodeId); SysFun newSys = SysFunService.GetSysFunById(newNodeId); SysFunService.UpdateSysFun(oldNodeId, newSys); SysFunService.UpdateSysFun(newNodeId, oldSys); }
private void AddFunIfNotExists(SysFun Fun) { if (_context.SysFun.IgnoreQueryFilters().Any(l => l.Name == Fun.Name)) { return; } _context.SysFun.Add(Fun); _context.SaveChanges(); }
// private SysFun GetModels(HttpContext context) { SysFun model = new SysFun(); model.DisplayName = context.Request.Form["DisplayName"]; model.NodeURL = context.Request.Form["NodeURL"]; try { model.DisplayOrder = int.Parse(context.Request.Form["DisplayOrder"]); } catch { } try { model.ParentNodeId = int.Parse(context.Request.Form["ParentNodeId"]); } catch { } model.Editor = adminUser.AdminName; try { model.NodeId = int.Parse(context.Request.Form["NodeId"]); } catch { } return(model); }
private static IList <SysFun> GetSysFunBySql(string sql, params SqlParameter[] parameters) { IList <SysFun> lists = new List <SysFun>(); DataTable table = DBHelper.GetDataSet(sql, parameters); foreach (DataRow row in table.Rows) { SysFun sysFun = new SysFun(); sysFun.NodeId = Convert.ToInt32(row["nodeId"]); sysFun.DisplayName = Convert.ToString(row["displayName"]); sysFun.NodeURL = Convert.ToString(row["NodeURL"]); sysFun.DisplayOrder = Convert.ToInt32(row["DisplayOrder"]); sysFun.ParentNodeId = Convert.ToInt32(row["ParentNodeId"]); lists.Add(sysFun); } return(lists); }
// public bool Create(SysFun model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_SysFun("); strSql.Append("DisplayName,NodeURL,DisplayOrder,ParentNodeId,Editor,CreateDate,FunImgNum)"); strSql.Append(" values ("); strSql.Append("@DisplayName,@NodeURL,@DisplayOrder,@ParentNodeId,@Editor,@CreateDate,@FunImgNum)"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }
/// <summary> /// 菜单排序中上移节点 /// </summary> /// <param name="nodeId">被移动的节点ID</param> /// <returns>是否成功</returns> public static bool UpNode(int nodeId) { try { SysFun sys = SysFunService.GetSysFunById(nodeId); int row_Number = SysFunService.GetRow_NumberByNodeId(nodeId, sys.ParentNodeId); if (row_Number == 1) { return(false); } else { int nodeIdUp = SysFunService.GetNodeIdByRow_Number(row_Number - 1, sys.ParentNodeId); ChangeNode(nodeId, nodeIdUp); return(true); } } catch (Exception) { return(false); } }
/// <summary> /// 菜单排序中下移节点 /// </summary> /// <param name="nodeId">被移动的节点ID</param> /// <returns>是否成功</returns> public static bool DownNode(int nodeId) { try { SysFun sys = SysFunService.GetSysFunById(nodeId); int row_Number = SysFunService.GetRow_NumberByNodeId(nodeId, sys.ParentNodeId); if (row_Number == SysFunService.GetCountByParentId(sys.ParentNodeId)) { return(false); } else { int nodeIdDown = SysFunService.GetNodeIdByRow_Number(row_Number + 1, sys.ParentNodeId); ChangeNode(nodeId, nodeIdDown); return(true); } } catch (Exception) { return(false); } }
// private SqlParameter[] GetSqlParameter(SysFun model) { SqlParameter[] parameters = { new SqlParameter("@DisplayName", SqlDbType.NVarChar, 50), new SqlParameter("@NodeURL", SqlDbType.NVarChar, 50), new SqlParameter("@DisplayOrder", SqlDbType.Int, 4), new SqlParameter("@ParentNodeId", SqlDbType.Int, 4), new SqlParameter("@Editor", SqlDbType.NVarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@NodeId", SqlDbType.Int, 4), new SqlParameter("@FunImgNum", SqlDbType.NVarChar, 10) }; parameters[0].Value = model.DisplayName; parameters[1].Value = model.NodeURL; parameters[2].Value = model.DisplayOrder; parameters[3].Value = model.ParentNodeId; parameters[4].Value = model.Editor; parameters[5].Value = model.CreateDate; parameters[6].Value = model.NodeId; parameters[7].Value = model.FunImgNum; return(parameters); }
// public dynamic GetModel(int NodeId) { try { dynamic model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 NodeId,DisplayName,NodeURL,DisplayOrder,ParentNodeId,Editor,CreateDate,FunImgNum from T_SysFun "); strSql.Append(" where NodeId=@NodeId"); SqlParameter[] parameters = { new SqlParameter("@NodeId", SqlDbType.Int, 4) }; parameters[0].Value = NodeId; using (dynamic read = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters)) { if (read.Read()) { model = new SysFun(); model.DisplayName = read["DisplayName"].ToString(); model.NodeURL = read["NodeURL"].ToString(); try { model.DisplayOrder = int.Parse(read["DisplayOrder"].ToString()); } catch { } try { model.ParentNodeId = int.Parse(read["ParentNodeId"].ToString()); } catch { } model.Editor = read["Editor"].ToString(); model.FunImgNum = read["FunImgNum"].ToString(); try { model.CreateDate = DateTime.Parse(read["CreateDate"].ToString()); } catch { } try { model.NodeId = int.Parse(read["NodeId"].ToString()); } catch { } } read.Dispose(); } return(model); } catch { throw; } }