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