//重写抽象方法，设置当前仓储为Role仓储
//public override void SetCurrentRepository()
//{
// //设置当前仓储为Role仓储
// CurrentRepository = _DbSession.RoleRepository;
//}
#endregion
/// <summary>
/// 实现条件查询
/// </summary>
/// <param name="roleinfo">传递过来的多条件查询的信息</param>
/// <returns>返回实现的查询的条件</returns>
public IQueryable <BaseRole> loadSearchDate(RoleInfoQuery roleinfo)
{
var temp = _DbSession.BaseRoleRepository.LoadEntities(c => true);
if (!string.IsNullOrEmpty(roleinfo.RealName))
{
temp = temp.Where <BaseRole>(u => u.Realname.Contains(roleinfo.RealName));
}
if (roleinfo.Enabled != -1)
{
temp = temp.Where <BaseRole>(u => u.Enabled == roleinfo.Enabled);
}
if (roleinfo.CategoryCode != -1)
{
temp = temp.Where <BaseRole>(u => u.CategoryCode == roleinfo.CategoryCode);
}
if (roleinfo.DeletionStateCode == 1)
{
temp = temp.Where <BaseRole>(u => u.DeletionStateCode == roleinfo.DeletionStateCode);
}
else
{
temp = temp.Where <BaseRole>(u => u.DeletionStateCode == 0);
}
roleinfo.Total = temp.Count();
return(temp.OrderBy(u => u.SortCode).Skip(roleinfo.PageSize * (roleinfo.PageIndex - 1)).Take(roleinfo.PageSize));
}
public List <RoleInfoEntity> GetRoleInfoList(RoleInfoQuery query)
{
List <RoleInfoEntity> list = new List <RoleInfoEntity>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT RoleID,JournalID,RoleName,Note,GroupID,AddDate FROM dbo.RoleInfo WITH(NOLOCK)");
string whereSQL = RoleInfoQueryToSQLWhere(query);
string orderBy = RoleInfoQueryToSQLOrder(query);
if (!string.IsNullOrEmpty(whereSQL))
{
sqlCommandText.Append(" WHERE " + whereSQL);
}
if (!string.IsNullOrEmpty(orderBy))
{
sqlCommandText.Append(" ORDER BY " + orderBy);
}
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
using (IDataReader dr = db.ExecuteReader(cmd))
{
list = MakeRoleInfoList(dr);
}
return(list);
}
/// <summary>
/// 获得角色的信息显示在角色列表中
/// </summary>
/// <returns>返回角色信息的Json对象</returns>
public ActionResult GetAllRoleInfos()
{
//实现对用户和多条件的分页的查询，rows表示一共多少条，page表示当前第几页
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
string RealName = Request["RealName"];
int? Enabled = Request["Enabled"] == null ? -1 : int.Parse(Request["Enabled"]);
int? CategoryCode = Request["CategoryCode"] == null ? -1 : int.Parse(Request["CategoryCode"]);
int? DeletionStateCode = Request["DeletionStateCode"] == null ? 0 : int.Parse(Request["DeletionStateCode"]);
int total = 0;
//封装一个业务逻辑层的方法来处理多条件查询的信息
var roleinfo = new RoleInfoQuery()
{
PageIndex = pageIndex,
PageSize = pageSize,
RealName = RealName,
Enabled = Enabled,
CategoryCode = CategoryCode,
DeletionStateCode = DeletionStateCode,
Total = 0
};
var date = from n in _roleInfoService.loadSearchDate(roleinfo)
select new
{
n.AllowDelete, n.AllowEdit, n.CategoryCode, n.Code, n.CreateBy, n.CreateOn, n.CreateUserID, n.DeletionStateCode,
n.Description, n.Enabled, n.ID, n.IsVisible, n.ModifiedBy, n.ModifiedOn, n.ModifiedUserID, n.Realname,
n.SortCode
};
//构造Json对象返回
var result = new { total = roleinfo.Total, rows = date };
return(JsonDate(result));
}
/// <summary>
/// 角色下拉框控件
/// </summary>
/// <param name="helper"></param>
/// <param name="id"></param>
/// <param name="width"></param>
/// <param name="selectedValue">选中值</param>
/// <param name="defaultValue"></param>
/// <param name="defaultText"></param>
/// <returns></returns>
public static string SelectRole(this HtmlHelper helper, string id, string width, string selectedValue, string defaultValue, string defaultText)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<select id=\"{0}\" name=\"{1}\" style=\"width:{2}\" class=\"input-select\">", id, id, width);
if (!string.IsNullOrWhiteSpace(defaultText))
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", defaultValue, defaultText);
}
RoleInfoQuery roleQuery = new RoleInfoQuery();
roleQuery.JournalID = SiteConfig.SiteID;
roleQuery.GroupID = (int)EnumMemberGroup.Editor;
ISiteSystemFacadeService sysService = ServiceContainer.Instance.Container.Resolve <ISiteSystemFacadeService>();
IList <RoleInfoEntity> listRole = sysService.GetRoleList(roleQuery);
foreach (RoleInfoEntity item in listRole)
{
if (item.RoleID.ToString().Equals(selectedValue))
{
sb.AppendFormat("<option value=\"{0}\" selected=\"selected\">{1}</option>", item.RoleID.ToString(), item.RoleName);
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", item.RoleID.ToString(), item.RoleName);
}
}
sb.Append("</select>");
return(sb.ToString());
}
/// <summary>
/// 得到角色Dict
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IDictionary <long, string> GetRoleInfoDict(RoleInfoQuery query)
{
IDictionary <long, string> dictRole = new Dictionary <long, string>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT RoleID,RoleName FROM dbo.RoleInfo WITH(NOLOCK)");
string whereSQL = RoleInfoQueryToSQLWhere(query);
if (!string.IsNullOrEmpty(whereSQL))
{
sqlCommandText.Append(" WHERE " + whereSQL);
}
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
long RoleID = 0;
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
RoleID = WKT.Common.Utils.TypeParse.ToLong(dr["RoleID"], 0);
if (!dictRole.ContainsKey(RoleID))
{
dictRole.Add(RoleID, dr["RoleName"].ToString());
}
}
dr.Close();
}
return(dictRole);
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string RoleInfoQueryToSQLWhere(RoleInfoQuery query)
{
StringBuilder sbWhere = new StringBuilder(" JournalID = " + query.JournalID);
if (query.RoleID != null)
{
sbWhere.Append(" AND RoleID = " + query.RoleID);
}
else
{
if (query.GroupID != null)
{
sbWhere.Append(" AND GroupID = ").Append(query.GroupID.Value);
}
}
return(sbWhere.ToString());
}
public Pager <RoleInfoEntity> GetRoleInfoPageList(RoleInfoQuery query)
{
int recordCount = 0;
string whereSQL = RoleInfoQueryToSQLWhere(query);
string orderBy = RoleInfoQueryToSQLOrder(query);
DataSet ds = db.GetPagingData("RoleInfo", "RoleID,JournalID,RoleName,Note,GroupID,AddDate", orderBy, whereSQL, query.CurrentPage, query.PageSize, out recordCount);
Pager <RoleInfoEntity> pager = new Pager <RoleInfoEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeRoleInfoList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 带有作者和专家的角色下拉框控件
/// </summary>
/// <param name="helper"></param>
/// <param name="id"></param>
/// <param name="width"></param>
/// <param name="selectedValue">选中值</param>
/// <param name="defaultValue"></param>
/// <param name="defaultText"></param>
/// <returns></returns>
public static string SelectAllRole(this HtmlHelper helper, string id, string width, string selectedValue, string defaultValue, string defaultText)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<select id=\"{0}\" name=\"{1}\" style=\"width:{2}\" class=\"input-select\">", id, id, width);
if (!string.IsNullOrWhiteSpace(defaultText))
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", defaultValue, defaultText);
}
RoleInfoQuery roleQuery = new RoleInfoQuery();
roleQuery.JournalID = SiteConfig.SiteID;
roleQuery.GroupID = (int)EnumMemberGroup.Editor;
ISiteSystemFacadeService sysService = ServiceContainer.Instance.Container.Resolve <ISiteSystemFacadeService>();
IList <RoleInfoEntity> listRole = sysService.GetRoleList(roleQuery);
# region 添加作者和专家组
/// <summary>
/// 批量删除
/// </summary>
/// <param name="roleID"></param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool BatchDeleteRoleInfo(RoleInfoQuery queryRole)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.AppendFormat("DELETE FROM dbo.RoleInfo WHERE JournalID=@JournalID AND RoleID IN ({0})", string.Join(",", queryRole.RoleIDList));
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@JournalID", DbType.Int64, queryRole.JournalID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="roleID"></param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool BatchDeleteRoleInfo(RoleInfoQuery queryRole)
{
return(RoleInfoBusProvider.BatchDeleteRoleInfo(queryRole));
}
/// <summary>
/// 得到角色Dict
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IDictionary <long, string> GetRoleInfoDict(RoleInfoQuery query)
{
return(RoleInfoDataAccess.Instance.GetRoleInfoDict(query));
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="roleInfoQuery">RoleInfoQuery查询实体对象</param>
/// <returns>Pager<RoleInfoEntity></returns>
public Pager <RoleInfoEntity> GetRoleInfoPageList(RoleInfoQuery roleInfoQuery)
{
return(RoleInfoDataAccess.Instance.GetRoleInfoPageList(roleInfoQuery));
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="roleID"></param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool BatchDeleteRoleInfo(RoleInfoQuery queryRole)
{
return(RoleInfoDataAccess.Instance.BatchDeleteRoleInfo(queryRole));
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="roleInfoQuery">RoleInfoQuery查询实体对象</param>
/// <returns>List<RoleInfoEntity></returns>
public List <RoleInfoEntity> GetRoleInfoList(RoleInfoQuery roleInfoQuery)
{
return(RoleInfoBusProvider.GetRoleInfoList(roleInfoQuery));
}
/// <summary>
/// 得到角色Dict
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IDictionary <long, string> GetRoleInfoDict(RoleInfoQuery query)
{
return(RoleInfoBusProvider.GetRoleInfoDict(query));
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="roleInfoQuery">RoleInfoQuery查询实体对象</param>
/// <returns>Pager<RoleInfoEntity></returns>
public Pager <RoleInfoEntity> GetRoleInfoPageList(RoleInfoQuery roleInfoQuery)
{
return(RoleInfoBusProvider.GetRoleInfoPageList(roleInfoQuery));
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string RoleInfoQueryToSQLOrder(RoleInfoQuery query)
{
return(" RoleID DESC");
}
