using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IDAL;
|
using System.Data.SqlClient;
|
using System.Data;
|
using CY.Model;
|
|
namespace CY.SQLDAL
|
{
|
public class Sys_Permissions_MenuDAL : ISys_Permissions_MenuDAL
|
{
|
|
private Database _dataBase = null;
|
|
public Sys_Permissions_MenuDAL()
|
{
|
_dataBase = new Database();
|
}
|
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.Sys_Permissions_Menu trueModel = model as Model.Sys_Permissions_Menu;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter(){Direction=ParameterDirection.ReturnValue,SqlDbType = SqlDbType.Int},
|
new SqlParameter("@MenuName",trueModel.MenuName),
|
new SqlParameter("@ParentId",trueModel.ParentId),
|
new SqlParameter("@MenuPath",trueModel.MenuPath),
|
new SqlParameter("@MenuIcon",trueModel.MenuIcon),
|
new SqlParameter("@IsUsed",trueModel.IsUsed),
|
new SqlParameter("@OrderCode",trueModel.OrderCode),
|
new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
|
new SqlParameter("@Operator",trueModel.Operator),
|
new SqlParameter("@Remark",trueModel.Remark)
|
};
|
try
|
{
|
_dataBase.Query("sp_Sys_Permissions_Menu_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
trueModel.Keyid = CY.Infrastructure.Common.MyConvert.ConvertToInt32(sqlParms[0].Value);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 修改
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.Sys_Permissions_Menu trueModel = model as Model.Sys_Permissions_Menu;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{ new SqlParameter("@Keyid",trueModel.Keyid),
|
new SqlParameter("@MenuName",trueModel.MenuName),
|
new SqlParameter("@ParentId",trueModel.ParentId),
|
new SqlParameter("@MenuPath",trueModel.MenuPath),
|
new SqlParameter("@MenuIcon",trueModel.MenuIcon),
|
new SqlParameter("@IsUsed",trueModel.IsUsed),
|
new SqlParameter("@OrderCode",trueModel.OrderCode),
|
new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
|
new SqlParameter("@Operator",trueModel.Operator),
|
new SqlParameter("@Remark",trueModel.Remark)
|
};
|
try
|
{
|
_dataBase.Query("sp_Sys_Permissions_Menu_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 删除
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.Sys_Permissions_Menu trueModel = model as Model.Sys_Permissions_Menu;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@Keyid",trueModel.Keyid)
|
};
|
try
|
{
|
_dataBase.Query("sp_Sys_Permissions_Menu_DeleteRow", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 分页查询
|
/// </summary>
|
/// <param name="query"></param>
|
/// <param name="pagination"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.Sys_Permissions_Menu> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
|
{
|
throw new NotImplementedException();
|
}
|
|
/// <summary>
|
/// 单个查询
|
/// </summary>
|
/// <param name="query"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.Sys_Permissions_Menu> SelectAllModel(Infrastructure.Query.Query query)
|
{
|
throw new NotImplementedException();
|
}
|
|
public IEnumerable<Model.Sys_Permissions_Menu> GetMenuByParentId(int parentId)
|
{
|
throw new NotImplementedException();
|
//string tempName = string.Empty;
|
//IDataReader reader = _Database.QueryDataReader("sp_GetMenuByParentId", System.Data.CommandType.StoredProcedure, new SqlParameter() { ParameterName = "@parentId", Value = parentId });
|
//return Database.ReadDataToModelAndDispose<Sys_Permissions_Menu>(reader);
|
}
|
|
/// <summary>
|
/// 根据上级编号查询全部菜单
|
/// </summary>
|
/// <param name="ParentId">编号</param>
|
/// <returns></returns>
|
public IEnumerable<Sys_Permissions_Menu> SelectListByParentId(int? ParentId)
|
{
|
if (ParentId == null)
|
return null;//错误数据返会空
|
|
IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("*", "Sys_Permissions_Menu", string.Format(" ParentId='{0}' ORDER BY OrderCode ASC", ParentId)) as IList<Sys_Permissions_Menu>;//执行查询
|
|
return result;//返回结果
|
}
|
|
/// <summary>
|
/// 查询全部菜单
|
/// </summary>
|
/// <returns></returns>
|
public DataTable SelectList()
|
{
|
return _dataBase.SelectModel("*", "Sys_Permissions_Menu", string.Format("1= 1 ORDER BY OrderCode ASC"));
|
}
|
|
/// <summary>
|
/// 查询全部启用的菜单
|
/// </summary>
|
/// <returns></returns>
|
public DataTable SelectAllUsedList()
|
{
|
return _dataBase.SelectModel("*", "Sys_Permissions_Menu", string.Format("1= 1 and IsUsed = 'True' ORDER BY OrderCode ASC"));
|
}
|
|
/// <summary>
|
/// 根据编号查询单个信息
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
public Sys_Permissions_Menu SelectModelByKeyId(int? KeyId)
|
{
|
if (KeyId == null)
|
return null;//错误数据返会空
|
|
Sys_Permissions_Menu m_Sys_Permissions_Menu = new Sys_Permissions_Menu();
|
try
|
{
|
IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("*", "Sys_Permissions_Menu", string.Format(" KeyId='{0}' ", KeyId)) as IList<Sys_Permissions_Menu>;//执行查询
|
if (null == result || result.Count == 0)
|
{
|
m_Sys_Permissions_Menu = null;
|
}
|
else
|
{
|
m_Sys_Permissions_Menu = result[0];
|
}
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return m_Sys_Permissions_Menu;
|
}
|
|
/// <summary>
|
/// 根据上级编号查询单个信息
|
/// </summary>
|
/// <param name="ParentId">上级编号</param>
|
/// <returns></returns>
|
public Sys_Permissions_Menu SelectModelByParentId(int? ParentId)
|
{
|
if (ParentId == null)
|
return null;//错误数据返会空
|
|
Sys_Permissions_Menu m_Sys_Permissions_Menu = new Sys_Permissions_Menu();
|
try
|
{
|
IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("*", "Sys_Permissions_Menu", string.Format(" ParentId='{0}' ", ParentId)) as IList<Sys_Permissions_Menu>;//执行查询
|
if (null == result || result.Count == 0)
|
{
|
m_Sys_Permissions_Menu = null;
|
}
|
else
|
{
|
m_Sys_Permissions_Menu = result[0];
|
}
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return m_Sys_Permissions_Menu;
|
}
|
|
/// <summary>
|
/// 根据编号查询此菜单的一二三级
|
/// </summary>
|
/// <param name="MenuId">编号</param>
|
/// <returns></returns>
|
public Sys_Permissions_Menu GetAllKeyidByMenuId(int? MenuId)
|
{
|
if (MenuId == null)
|
return null;//错误数据返会空
|
|
Sys_Permissions_Menu m_Sys_Permissions_Menu = new Sys_Permissions_Menu();
|
try
|
{
|
IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("a.Keyid AS MenuOneId,b.Keyid AS MenuTwoId,c.Keyid AS MenuThreeId", "dbo.Sys_Permissions_Menu AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.Keyid = b.ParentId LEFT JOIN dbo.Sys_Permissions_Menu AS c ON b.Keyid = c.ParentId", string.Format(" c.Keyid='{0}' ", MenuId)) as IList<Sys_Permissions_Menu>;//执行查询
|
if (null == result || result.Count == 0)
|
{
|
m_Sys_Permissions_Menu = null;
|
}
|
else
|
{
|
m_Sys_Permissions_Menu = result[0];
|
}
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return m_Sys_Permissions_Menu;
|
}
|
}
|
}
|
