/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns>是否成功</returns>
public bool Add(Aut_MenuModel model)
{
string sqlStr = @"USE Authority
INSERT INTO Aut_Menu(
IsDel ,
CreateTime ,
Name ,
Url ,
Sort ,
MenuLevel ,
ParentId )
VALUES (
@IsDel ,
@CreateTime ,
@Name ,
@Url ,
@Sort ,
@MenuLevel ,
@ParentId )";
SqlParameter[] parameters =
{
new SqlParameter("@IsDel", model.IsDel),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Url", model.Url),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@MenuLevel", model.MenuLevel),
new SqlParameter("@ParentId", model.ParentId)
};
return SqlHelper.ExecteNonQueryText(sqlStr, parameters) > 0;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Aut_MenuModel model)
{
return _dataDemo.Update(model);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns>是否成功</returns>
public bool Update(Aut_MenuModel model)
{
string sqlStr = @"USE Authority
UPDATE Aut_Menu
SET
IsDel = @IsDel ,
CreateTime = @CreateTime ,
Name = @Name ,
Url = @Url ,
Sort = @Sort ,
MenuLevel = @MenuLevel ,
ParentId = @ParentId
WHERE Id = @Id";
SqlParameter[] parameters =
{
new SqlParameter("@Id",model.Id),
new SqlParameter("@IsDel", model.IsDel),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Url", model.Url),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@MenuLevel", model.MenuLevel),
new SqlParameter("@ParentId", model.ParentId)
};
return SqlHelper.ExecteNonQueryText(sqlStr, parameters) > 0;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Aut_MenuModel model)
{
return _dataDemo.Add(model);
}
