/// <summary> /// 编辑一条数据 /// </summary> /// <returns>"true"/"false"</returns> private string doUpdate() { try { int id = IRequest.GetFormInt("Role_Id", 0); if (id > 0) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp(id)); List <SqlDb.Dcms_Role> roleList = query.GetList <SqlDb.Dcms_Role>(); if (roleList.Count > 0) { role = roleList[0]; role.Role_Name = IRequest.GetFormString("Role_Name"); role.Role_Order = IRequest.GetFormInt("Role_Order", 0); //提交编辑 session.Update(role); } } } return("true"); } catch { return("false"); } }
protected void Page_Load(object sender, EventArgs e) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery query = session.GetQuery(role).OrderBy(SqlDb.Dcms_Role._ROLE_ORDER_, Direction.ASC); Admin_RoleId.DataSource = query.GetList<SqlDb.Dcms_Role>(); Admin_RoleId.DataTextField = "Role_Name"; Admin_RoleId.DataValueField = "Role_Id"; Admin_RoleId.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery query = session.GetQuery(role).OrderBy(SqlDb.Dcms_Role._ROLE_ORDER_, Direction.ASC); Admin_RoleId.DataSource = query.GetList <SqlDb.Dcms_Role>(); Admin_RoleId.DataTextField = "Role_Name"; Admin_RoleId.DataValueField = "Role_Id"; Admin_RoleId.DataBind(); } }
/// <summary> /// 按页取数据 /// </summary> /// <returns>json</returns> private string doSelect() { StringBuilder sb = new StringBuilder(); //取Grid提交来的数据开始 int rp = IRequest.GetFormInt("rp", 1); int page = IRequest.GetFormInt("page", 1); string keyword = IRequest.GetFormString("query"); string qtype = IRequest.GetFormString("qtype"); //取Grid提交来的数据结束 using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); //创建查询 IQuery query = session.GetQuery(role); if (keyword.Length > 0) { query.Where(SqlDb.Dcms_Role._ROLE_NAME_.Like('%', keyword, '%')).OrderBy(SqlDb.Dcms_Role._ROLE_ID_, Direction.DESC); } else { query.OrderBy(SqlDb.Dcms_Role._ROLE_ID_, Direction.DESC); } //取总记录 int totalCount = query.Count(); List <SqlDb.Dcms_Role> roleList = query.GetList <SqlDb.Dcms_Role>(page, rp); //Json格式 sb.Append("{\n"); sb.Append("\"page\":" + page.ToString() + ",\n"); sb.Append("\"total\":" + totalCount.ToString() + ",\n"); sb.Append("\"rows\": [\n"); for (int i = 0; i < roleList.Count; i++) { sb.Append("{"); sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\"]", roleList[i].Role_Id.ToString(), roleList[i].Role_Id.ToString(), roleList[i].Role_Name, roleList[i].Role_Order.ToString(), roleList[i].Role_AddTime.ToString("yyyy/MM/dd"))); if ((i + 1) == roleList.Count) { sb.Append("}\n"); } else { sb.Append("},\n"); } } sb.Append("]\n"); sb.Append("}"); } return(sb.ToString()); }
/// <summary> /// 取对应的权限 /// </summary> /// <param name="popedomString">select/update/delete/insert</param> /// <param name="roleId">角色id</param> /// <returns></returns> private string getRoleCateLang(int roleId) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = roleId; IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List <SqlDb.Dcms_Role> rList = query.GetList <SqlDb.Dcms_Role>(); if (rList.Count > 0) { return(rList[0].Role_CateLang); } } return(""); }
/// <summary> /// 插入一条数据 /// </summary> /// <returns>"true"/"false"</returns> private string doInsert() { try { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_AddTime = DateTime.Now; role.Role_Name = IRequest.GetFormString("Role_Name"); role.Role_Order = IRequest.GetFormInt("Role_Order", 0); session.Create(role); } return("true"); } catch { return("false"); } }
/// <summary> /// 取单条编辑数据 /// </summary> /// <returns>json</returns> private string doGetOne() { int id = IRequest.GetQueryInt("id", 0); string oneRecord = ""; if (id > 0) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp(id)); List <SqlDb.Dcms_Role> roleList = query.GetList <SqlDb.Dcms_Role>(); if (roleList.Count > 0) { oneRecord = "[{\"Role_Name\":\"" + roleList[0].Role_Name + "\",\"Role_Order\":\"" + roleList[0].Role_Order + "\",\"Role_Id\":\"" + roleList[0].Role_Id.ToString() + "\"}]"; } } } return(oneRecord); }
/// <summary> /// 系统版本设置 /// </summary> /// <param name="roleId"></param> /// <returns></returns> private string getSysDomain(int roleId) { StringBuilder SysDomain = new StringBuilder(); string xmlpath = HttpContext.Current.Server.MapPath(@"~/sysconfig/urls.config"); XmlDocument objXmlDoc = new XmlDocument(); objXmlDoc.Load(xmlpath); XmlNode objNode = objXmlDoc.SelectSingleNode("urls"); if (roleId == 0) { foreach (XmlNode xn in objNode.ChildNodes) { SysDomain.Append(string.Format("<li onclick='javascript:checkState(this);'> <a href='MainFrame.aspx?langflag={0}&langname={2}'>{1}</a> </li>\n", xn.Attributes["langflag"].Value, xn.Attributes["name"].Value, Server.UrlEncode(xn.Attributes["name"].Value))); } } else { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = roleId; IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List <SqlDb.Dcms_Role> rList = query.GetList <SqlDb.Dcms_Role>(); if (rList.Count > 0) { string roleCateFlag = rList[0].Role_CateLang; foreach (XmlNode xn in objNode.ChildNodes) { if (roleCateFlag.ToUpper().IndexOf(xn.Attributes["langflag"].Value.ToUpper()) >= 0) { SysDomain.Append(string.Format("<li onclick='javascript:checkState(this);'> <a href='MainFrame.aspx?langflag={0}&langname={2}'>{1}</a> </li>\n", xn.Attributes["langflag"].Value, xn.Attributes["name"].Value, Server.UrlEncode(xn.Attributes["name"].Value))); } } } } } return(SysDomain.ToString()); }
/// <summary> /// 编辑一条数据 /// </summary> /// <returns>"true"/"false"</returns> private string doUpdate() { try { string selectvalue = IRequest.GetFormString("selectvalue").TrimStart(new char[] { ',' }); string[] selectCateId = selectvalue.Split(','); if (selectCateId.Length > 0) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { int roleId = Dcms.Utility.IRequest.GetFormInt("roleId", 0); if (roleId > 0) { //处理select权限 session.simple("delete from [Dcms_Permissions] where [Permissions_RoleId]=" + roleId); for (int i = 0; i < selectCateId.Length; i++) { SqlDb.Dcms_Permissions perm = new SqlDb.Dcms_Permissions(); perm.Permissions_AdminId = 0; perm.Permissions_CateId = Utils.StrToInt(selectCateId[i], 0); perm.Permissions_Delete = 0; perm.Permissions_Insert = 0; perm.Permissions_RoleId = roleId; perm.Permissions_Select = 1; perm.Permissions_Update = 0; session.Create(perm); } string Sql = string.Empty; //处理insert权限 string insertvalue = IRequest.GetFormString("insertvalue").TrimStart(new char[] { ',' }); if (insertvalue.Length > 0) { Sql = "update [Dcms_Permissions] set Permissions_Insert=1 where [Permissions_CateId] in(" + insertvalue + ") and [Permissions_RoleId]=" + roleId; session.simple(Sql); } //处理update权限 string updatevalue = IRequest.GetFormString("updatevalue").TrimStart(new char[] { ',' }); if (updatevalue.Length > 0) { Sql = "update [Dcms_Permissions] set Permissions_Update=1 where [Permissions_CateId] in(" + updatevalue + ") and [Permissions_RoleId]=" + roleId; session.simple(Sql); } //处理delete权限 string deletevalue = IRequest.GetFormString("deletevalue").TrimStart(new char[] { ',' }); if (deletevalue.Length > 0) { Sql = "update [Dcms_Permissions] set Permissions_Delete=1 where [Permissions_CateId] in(" + deletevalue + ") and [Permissions_RoleId]=" + roleId; session.simple(Sql); } //处理角色语言版本权限 string catelang = IRequest.GetFormString("catelang").TrimStart(new char[] { ',' }); SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = roleId; IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List<SqlDb.Dcms_Role> rList = query.GetList<SqlDb.Dcms_Role>(); if (rList.Count > 0) { role = rList[0]; role.Role_CateLang = catelang.ToUpper(); role.Update(); } } } } return "true"; } catch { return "false"; } }
/// <summary> /// 取对应的权限 /// </summary> /// <param name="popedomString">select/update/delete/insert</param> /// <param name="roleId">角色id</param> /// <returns></returns> private string getRoleCateLang(int roleId) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = roleId; IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List<SqlDb.Dcms_Role> rList = query.GetList<SqlDb.Dcms_Role>(); if (rList.Count > 0) { return rList[0].Role_CateLang; } } return ""; }
protected void btn_login_Click(object sender, EventArgs e) { string Admin_Name = this.txb_adminzh.Text.Trim(); string Admin_Pwd = this.txb_adminmm.Text.Trim(); using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Admin admin = new SqlDb.Dcms_Admin(); admin.Admin_Name = Admin_Name; admin.Admin_Pwd = Utils.MD5(Utils.SHA256(Admin_Pwd)); IQuery query = session.GetQuery(admin).Where(SqlDb.Dcms_Admin._ADMIN_NAME_.EqulesExp().AND(SqlDb.Dcms_Admin._ADMIN_PWD_.EqulesExp())); List<SqlDb.Dcms_Admin> adminList = query.GetList<SqlDb.Dcms_Admin>(); if (adminList.Count == 1) { SessionHelper.Add("adminInfo", adminList[0]); Utils.WriteCookie("Admin_Id", adminList[0].Admin_Id.ToString(), 60); Utils.WriteCookie("AuthId", Utils.MD5(Utils.SHA256(adminList[0].Admin_Pwd + adminList[0].Admin_Name)), 60); admin.Admin_LoginTimes = adminList[0].Admin_LoginTimes + 1; admin.Admin_LastIp = IRequest.GetIP(); admin.Admin_LastTime = DateTime.Now; admin.Admin_Id = adminList[0].Admin_Id; admin.Admin_RoleId = adminList[0].Admin_RoleId; //更新记录 session.Update(admin); //取默认语言版本开始 string langFlag = "CN"; string langName = "中文版"; getDefaultLangFlag(ref langFlag, ref langName); //超级用户跳过验证 string[] superUser = ConfigurationManager.AppSettings["superUser"].ToUpper().Split(new char[] { ',' }); bool isSuper = false; for (int i = 0; i < superUser.Length; i++) { if (superUser[i].Equals(admin.Admin_Name.ToUpper())) { SessionHelper.Add("LangFlag", langFlag.ToUpper()); SessionHelper.Add("LangName", langName); Utils.WriteCookie("LangFlag", Utils.UrlEncode(langFlag.ToUpper()), 60); Utils.WriteCookie("LangName", Utils.UrlEncode(langName), 60); isSuper=true; break; } } if (!isSuper)//组别用户验证 { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = admin.Admin_RoleId; IQuery Rolequery = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List<SqlDb.Dcms_Role> rList = Rolequery.GetList<SqlDb.Dcms_Role>(); string thisRoleCateLang = string.Empty; if (rList.Count > 0) { if (String.IsNullOrEmpty(rList[0].Role_CateLang)) { lit_ErrorInfo.Text = "<div class='errorinfo'>此用户还没有任何权限,请联系管理员设置权限!</div>"; return; } thisRoleCateLang = Convert.ToString(rList[0].Role_CateLang).ToUpper(); if (thisRoleCateLang.IndexOf(langFlag.ToUpper()) >= 0) { SessionHelper.Add("LangFlag", langFlag.ToUpper()); SessionHelper.Add("LangName", langName); Utils.WriteCookie("LangFlag", Utils.UrlEncode(langFlag.ToUpper()), 60); Utils.WriteCookie("LangName", Utils.UrlEncode(langName), 60); } else { string thisCateLangFlag = Utils.SplitString(thisRoleCateLang, ",")[0].ToUpper(); SessionHelper.Add("LangFlag", thisCateLangFlag); SessionHelper.Add("LangName", getRoleLangName(thisCateLangFlag)); Utils.WriteCookie("LangFlag", Utils.UrlEncode(langFlag.ToUpper()), 60); Utils.WriteCookie("LangName", Utils.UrlEncode(langName), 60); } } else { lit_ErrorInfo.Text = "<div class='errorinfo'>此用户还没有任何权限,请联系管理员设置权限!</div>"; return; } } //取默认语言版本结束 Response.Redirect("BaseManage/MainFrame.aspx"); } else { lit_ErrorInfo.Text = "<div class='errorinfo'>登录失败,用户名或密码出错,请重试!</div>"; } } }
/// <summary> /// 按页取数据 /// </summary> /// <returns>json</returns> private string doSelect() { StringBuilder sb = new StringBuilder(); //取Grid提交来的数据开始 int rp = IRequest.GetFormInt("rp", 1); int page = IRequest.GetFormInt("page", 1); string keyword = IRequest.GetFormString("query"); string qtype = IRequest.GetFormString("qtype"); //取Grid提交来的数据结束 using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery rQuery = session.GetQuery(role).OrderBy(SqlDb.Dcms_Role._ROLE_ID_, Direction.DESC); List<SqlDb.Dcms_Role> roleList = rQuery.GetList<SqlDb.Dcms_Role>(); for (int a = 0; a < roleList.Count; a++) { roleName.Add(roleList[a].Role_Id, roleList[a].Role_Name); } SqlDb.Dcms_Admin admin = new SqlDb.Dcms_Admin(); //创建查询 if (keyword.Length > 0) { admin.Admin_Name = keyword; } IQuery query = session.GetQuery(admin); if (keyword.Length > 0) { query.Where(SqlDb.Dcms_Admin._ADMIN_NAME_.Like().AND(SqlDb.Dcms_Admin._ADMIN_NAME_.NotEquls("dcms"))); } else { query.Where(SqlDb.Dcms_Admin._ADMIN_NAME_.NotEquls("dcms")); } query.OrderBy(SqlDb.Dcms_Admin._ADMIN_ID_, Direction.DESC); //取总记录 int totalCount = query.Count(); List<SqlDb.Dcms_Admin> adminList = query.GetList<SqlDb.Dcms_Admin>(page, rp); //Json格式 sb.Append("{\n"); sb.Append("\"page\":" + page.ToString() + ",\n"); sb.Append("\"total\":" + totalCount.ToString() + ",\n"); sb.Append("\"rows\": [\n"); for (int i = 0; i < adminList.Count; i++) { sb.Append("{"); sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\"]", adminList[i].Admin_Id.ToString(), adminList[i].Admin_Id.ToString(), adminList[i].Admin_Name, adminList[i].Admin_Email, adminList[i].Admin_LoginTimes.ToString(), adminList[i].Admin_LastTime.ToString("yyyy/MM/dd"), adminList[i].Admin_LastIp, getRoleName(adminList[i].Admin_RoleId))); if ((i + 1) == adminList.Count) { sb.Append("}\n"); } else { sb.Append("},\n"); } } sb.Append("]\n"); sb.Append("}"); } return sb.ToString(); }
/// <summary> /// 按页取数据 /// </summary> /// <returns>json</returns> private string doSelect() { StringBuilder sb = new StringBuilder(); //取Grid提交来的数据开始 int rp = IRequest.GetFormInt("rp", 1); int page = IRequest.GetFormInt("page", 1); string keyword = IRequest.GetFormString("query"); string qtype = IRequest.GetFormString("qtype"); //取Grid提交来的数据结束 using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); //创建查询 IQuery query = session.GetQuery(role); if (keyword.Length > 0) { query.Where(SqlDb.Dcms_Role._ROLE_NAME_.Like('%', keyword, '%')).OrderBy(SqlDb.Dcms_Role._ROLE_ID_, Direction.DESC); } else { query.OrderBy(SqlDb.Dcms_Role._ROLE_ID_, Direction.DESC); } //取总记录 int totalCount = query.Count(); List<SqlDb.Dcms_Role> roleList = query.GetList<SqlDb.Dcms_Role>(page, rp); //Json格式 sb.Append("{\n"); sb.Append("\"page\":" + page.ToString() + ",\n"); sb.Append("\"total\":" + totalCount.ToString() + ",\n"); sb.Append("\"rows\": [\n"); for (int i = 0; i < roleList.Count; i++) { sb.Append("{"); sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\"]", roleList[i].Role_Id.ToString(), roleList[i].Role_Id.ToString(), roleList[i].Role_Name, roleList[i].Role_Order.ToString(), roleList[i].Role_AddTime.ToString("yyyy/MM/dd"))); if ((i + 1) == roleList.Count) { sb.Append("}\n"); } else { sb.Append("},\n"); } } sb.Append("]\n"); sb.Append("}"); } return sb.ToString(); }
/// <summary> /// 插入一条数据 /// </summary> /// <returns>"true"/"false"</returns> private string doInsert() { try { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_AddTime = DateTime.Now; role.Role_Name = IRequest.GetFormString("Role_Name"); role.Role_Order = IRequest.GetFormInt("Role_Order", 0); session.Create(role); } return "true"; } catch { return "false"; } }
/// <summary> /// 编辑一条数据 /// </summary> /// <returns>"true"/"false"</returns> private string doUpdate() { try { string selectvalue = IRequest.GetFormString("selectvalue").TrimStart(new char[] { ',' }); string[] selectCateId = selectvalue.Split(','); if (selectCateId.Length > 0) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { int roleId = Dcms.Utility.IRequest.GetFormInt("roleId", 0); if (roleId > 0) { //处理select权限 session.simple("delete from [Dcms_Permissions] where [Permissions_RoleId]=" + roleId); for (int i = 0; i < selectCateId.Length; i++) { SqlDb.Dcms_Permissions perm = new SqlDb.Dcms_Permissions(); perm.Permissions_AdminId = 0; perm.Permissions_CateId = Utils.StrToInt(selectCateId[i], 0); perm.Permissions_Delete = 0; perm.Permissions_Insert = 0; perm.Permissions_RoleId = roleId; perm.Permissions_Select = 1; perm.Permissions_Update = 0; session.Create(perm); } string Sql = string.Empty; //处理insert权限 string insertvalue = IRequest.GetFormString("insertvalue").TrimStart(new char[] { ',' }); if (insertvalue.Length > 0) { Sql = "update [Dcms_Permissions] set Permissions_Insert=1 where [Permissions_CateId] in(" + insertvalue + ") and [Permissions_RoleId]=" + roleId; session.simple(Sql); } //处理update权限 string updatevalue = IRequest.GetFormString("updatevalue").TrimStart(new char[] { ',' }); if (updatevalue.Length > 0) { Sql = "update [Dcms_Permissions] set Permissions_Update=1 where [Permissions_CateId] in(" + updatevalue + ") and [Permissions_RoleId]=" + roleId; session.simple(Sql); } //处理delete权限 string deletevalue = IRequest.GetFormString("deletevalue").TrimStart(new char[] { ',' }); if (deletevalue.Length > 0) { Sql = "update [Dcms_Permissions] set Permissions_Delete=1 where [Permissions_CateId] in(" + deletevalue + ") and [Permissions_RoleId]=" + roleId; session.simple(Sql); } //处理角色语言版本权限 string catelang = IRequest.GetFormString("catelang").TrimStart(new char[] { ',' }); SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = roleId; IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List <SqlDb.Dcms_Role> rList = query.GetList <SqlDb.Dcms_Role>(); if (rList.Count > 0) { role = rList[0]; role.Role_CateLang = catelang.ToUpper(); role.Update(); } } } } return("true"); } catch { return("false"); } }
/// <summary> /// 按页取数据 /// </summary> /// <returns>json</returns> private string doSelect() { StringBuilder sb = new StringBuilder(); //取Grid提交来的数据开始 int rp = IRequest.GetFormInt("rp", 1); int page = IRequest.GetFormInt("page", 1); string keyword = IRequest.GetFormString("query"); string qtype = IRequest.GetFormString("qtype"); //取Grid提交来的数据结束 using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery rQuery = session.GetQuery(role).OrderBy(SqlDb.Dcms_Role._ROLE_ID_, Direction.DESC); List <SqlDb.Dcms_Role> roleList = rQuery.GetList <SqlDb.Dcms_Role>(); for (int a = 0; a < roleList.Count; a++) { roleName.Add(roleList[a].Role_Id, roleList[a].Role_Name); } SqlDb.Dcms_Admin admin = new SqlDb.Dcms_Admin(); //创建查询 if (keyword.Length > 0) { admin.Admin_Name = keyword; } IQuery query = session.GetQuery(admin); if (keyword.Length > 0) { query.Where(SqlDb.Dcms_Admin._ADMIN_NAME_.Like().AND(SqlDb.Dcms_Admin._ADMIN_NAME_.NotEquls("dcms"))); } else { query.Where(SqlDb.Dcms_Admin._ADMIN_NAME_.NotEquls("dcms")); } query.OrderBy(SqlDb.Dcms_Admin._ADMIN_ID_, Direction.DESC); //取总记录 int totalCount = query.Count(); List <SqlDb.Dcms_Admin> adminList = query.GetList <SqlDb.Dcms_Admin>(page, rp); //Json格式 sb.Append("{\n"); sb.Append("\"page\":" + page.ToString() + ",\n"); sb.Append("\"total\":" + totalCount.ToString() + ",\n"); sb.Append("\"rows\": [\n"); for (int i = 0; i < adminList.Count; i++) { sb.Append("{"); sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\"]", adminList[i].Admin_Id.ToString(), adminList[i].Admin_Id.ToString(), adminList[i].Admin_Name, adminList[i].Admin_Email, adminList[i].Admin_LoginTimes.ToString(), adminList[i].Admin_LastTime.ToString("yyyy/MM/dd"), adminList[i].Admin_LastIp, getRoleName(adminList[i].Admin_RoleId))); if ((i + 1) == adminList.Count) { sb.Append("}\n"); } else { sb.Append("},\n"); } } sb.Append("]\n"); sb.Append("}"); } return(sb.ToString()); }
/// <summary> /// 系统版本设置 /// </summary> /// <param name="roleId"></param> /// <returns></returns> private string getSysDomain(int roleId) { StringBuilder SysDomain = new StringBuilder(); string xmlpath = HttpContext.Current.Server.MapPath(@"~/sysconfig/urls.config"); XmlDocument objXmlDoc = new XmlDocument(); objXmlDoc.Load(xmlpath); XmlNode objNode = objXmlDoc.SelectSingleNode("urls"); if (roleId == 0) { foreach (XmlNode xn in objNode.ChildNodes) { SysDomain.Append(string.Format("<li onclick='javascript:checkState(this);'> <a href='MainFrame.aspx?langflag={0}&langname={2}'>{1}</a> </li>\n", xn.Attributes["langflag"].Value, xn.Attributes["name"].Value, Server.UrlEncode(xn.Attributes["name"].Value))); } } else { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = roleId; IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List<SqlDb.Dcms_Role> rList = query.GetList<SqlDb.Dcms_Role>(); if (rList.Count > 0) { string roleCateFlag = rList[0].Role_CateLang; foreach (XmlNode xn in objNode.ChildNodes) { if (roleCateFlag.ToUpper().IndexOf(xn.Attributes["langflag"].Value.ToUpper()) >= 0) { SysDomain.Append(string.Format("<li onclick='javascript:checkState(this);'> <a href='MainFrame.aspx?langflag={0}&langname={2}'>{1}</a> </li>\n", xn.Attributes["langflag"].Value, xn.Attributes["name"].Value, Server.UrlEncode(xn.Attributes["name"].Value))); } } } } } return SysDomain.ToString(); }
/// <summary> /// 编辑一条数据 /// </summary> /// <returns>"true"/"false"</returns> private string doUpdate() { try { int id = IRequest.GetFormInt("Role_Id", 0); if (id > 0) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp(id)); List<SqlDb.Dcms_Role> roleList = query.GetList<SqlDb.Dcms_Role>(); if (roleList.Count > 0) { role = roleList[0]; role.Role_Name = IRequest.GetFormString("Role_Name"); role.Role_Order = IRequest.GetFormInt("Role_Order", 0); //提交编辑 session.Update(role); } } } return "true"; } catch { return "false"; } }
protected void btn_login_Click(object sender, EventArgs e) { string Admin_Name = this.txb_adminzh.Text.Trim(); string Admin_Pwd = this.txb_adminmm.Text.Trim(); using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Admin admin = new SqlDb.Dcms_Admin(); admin.Admin_Name = Admin_Name; admin.Admin_Pwd = Utils.MD5(Utils.SHA256(Admin_Pwd)); IQuery query = session.GetQuery(admin).Where(SqlDb.Dcms_Admin._ADMIN_NAME_.EqulesExp().AND(SqlDb.Dcms_Admin._ADMIN_PWD_.EqulesExp())); List <SqlDb.Dcms_Admin> adminList = query.GetList <SqlDb.Dcms_Admin>(); if (adminList.Count == 1) { SessionHelper.Add("adminInfo", adminList[0]); Utils.WriteCookie("Admin_Id", adminList[0].Admin_Id.ToString(), 60); Utils.WriteCookie("AuthId", Utils.MD5(Utils.SHA256(adminList[0].Admin_Pwd + adminList[0].Admin_Name)), 60); admin.Admin_LoginTimes = adminList[0].Admin_LoginTimes + 1; admin.Admin_LastIp = IRequest.GetIP(); admin.Admin_LastTime = DateTime.Now; admin.Admin_Id = adminList[0].Admin_Id; admin.Admin_RoleId = adminList[0].Admin_RoleId; //更新记录 session.Update(admin); //取默认语言版本开始 string langFlag = "CN"; string langName = "中文版"; getDefaultLangFlag(ref langFlag, ref langName); //超级用户跳过验证 string[] superUser = ConfigurationManager.AppSettings["superUser"].ToUpper().Split(new char[] { ',' }); bool isSuper = false; for (int i = 0; i < superUser.Length; i++) { if (superUser[i].Equals(admin.Admin_Name.ToUpper())) { SessionHelper.Add("LangFlag", langFlag.ToUpper()); SessionHelper.Add("LangName", langName); Utils.WriteCookie("LangFlag", Utils.UrlEncode(langFlag.ToUpper()), 60); Utils.WriteCookie("LangName", Utils.UrlEncode(langName), 60); isSuper = true; break; } } if (!isSuper)//组别用户验证 { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); role.Role_Id = admin.Admin_RoleId; IQuery Rolequery = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp()); List <SqlDb.Dcms_Role> rList = Rolequery.GetList <SqlDb.Dcms_Role>(); string thisRoleCateLang = string.Empty; if (rList.Count > 0) { if (String.IsNullOrEmpty(rList[0].Role_CateLang)) { lit_ErrorInfo.Text = "<div class='errorinfo'>此用户还没有任何权限,请联系管理员设置权限!</div>"; return; } thisRoleCateLang = Convert.ToString(rList[0].Role_CateLang).ToUpper(); if (thisRoleCateLang.IndexOf(langFlag.ToUpper()) >= 0) { SessionHelper.Add("LangFlag", langFlag.ToUpper()); SessionHelper.Add("LangName", langName); Utils.WriteCookie("LangFlag", Utils.UrlEncode(langFlag.ToUpper()), 60); Utils.WriteCookie("LangName", Utils.UrlEncode(langName), 60); } else { string thisCateLangFlag = Utils.SplitString(thisRoleCateLang, ",")[0].ToUpper(); SessionHelper.Add("LangFlag", thisCateLangFlag); SessionHelper.Add("LangName", getRoleLangName(thisCateLangFlag)); Utils.WriteCookie("LangFlag", Utils.UrlEncode(langFlag.ToUpper()), 60); Utils.WriteCookie("LangName", Utils.UrlEncode(langName), 60); } } else { lit_ErrorInfo.Text = "<div class='errorinfo'>此用户还没有任何权限,请联系管理员设置权限!</div>"; return; } } //取默认语言版本结束 Response.Redirect("BaseManage/MainFrame.aspx"); } else { lit_ErrorInfo.Text = "<div class='errorinfo'>登录失败,用户名或密码出错,请重试!</div>"; } } }
/// <summary> /// 取单条编辑数据 /// </summary> /// <returns>json</returns> private string doGetOne() { int id = IRequest.GetQueryInt("id", 0); string oneRecord = ""; if (id > 0) { using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_Role role = new SqlDb.Dcms_Role(); IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp(id)); List<SqlDb.Dcms_Role> roleList = query.GetList<SqlDb.Dcms_Role>(); if (roleList.Count > 0) { oneRecord = "[{\"Role_Name\":\"" + roleList[0].Role_Name + "\",\"Role_Order\":\"" + roleList[0].Role_Order + "\",\"Role_Id\":\"" + roleList[0].Role_Id.ToString() + "\"}]"; } } } return oneRecord; }