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