public override ActionResult Index() { DataTable dt = DbHelperSQL.Query("select * from AccessTable a join PermissionTable p on (p.TableID=a.ID)").Tables[0]; string authAll = ModelConvertHelper.ConvertToModel(dt); BLL.AccessTable bllaccess = new BLL.AccessTable(); List <Model.AccessTable> AccessList = bllaccess.GetModelList(""); ViewBag.AccessList = AccessList; ViewBag.EvalGridUserAuth = authAll; return(View()); }
public ActionResult Login(string Username, string Password) { // \ _ " " + HTNResp.BLL.UserTable bllUser = new HTNResp.BLL.UserTable(); if (string.IsNullOrEmpty(Username) || string.IsNullOrEmpty(Password)) { return(this.Json(new { result = 0, data = "" })); } // Password = encryptPwd(Password); string strSql = "UserCode='" + Username + "' and Password='******'"; List <Model.UserTable> userList = bllUser.DataTableToList(bllUser.GetList(strSql).Tables[0]); //authority if (userList.Count > 0) { Model.UserTable userModel = userList[0]; strSql = "select * from AccessTable where ID in (select TableID from PermissionTable where UserID = " + userModel.ID + ")"; List <Model.AccessTable> tableList = new BLL.AccessTable().DataTableToList(DbHelperSQL.Query(strSql).Tables[0]); //get granted table string sessionString = ""; if (tableList.Count != 0) { sessionString += "["; foreach (Model.AccessTable tableModel in tableList) { sessionString += new JavaScriptSerializer().Serialize(tableModel) + ","; } sessionString = sessionString.Remove(sessionString.Length - 1); sessionString += "]"; } //set session time out Session.Timeout = 30; Session["username"] = userModel.UserName; Session["access"] = sessionString; return(this.Json(new { result = 1, data = "" })); } else { return(this.Json(new { result = 0, data = "" })); } }
public ActionResult Login(string Username, string Password) { BLL.AdminTable bllAdmin = new BLL.AdminTable(); BLL.TeacherTable bllTeacher = new BLL.TeacherTable(); BLL.StudentTable bllStudent = new BLL.StudentTable(); if (string.IsNullOrEmpty(Username) || string.IsNullOrEmpty(Password)) { return(this.Json(new { result = 0, data = "" })); } Password = encryptPwd(Password); string strSql = "Username='******' and Password='******'"; List <AdminTable> adminList = bllAdmin.DataTableToList(bllAdmin.GetList(strSql).Tables[0]); List <TeacherTable> teacherList = bllTeacher.DataTableToList(bllTeacher.GetList(strSql).Tables[0]); List <StudentTable> studentList = bllStudent.DataTableToList(bllStudent.GetList(strSql).Tables[0]); if (adminList.Count > 0) { AdminTable adminModel = adminList[0]; strSql = "select * from AccessTable where ID = 1 or ID = 2 or ID = 3 or ID = 4 or ID = 5 or ID = 6"; List <AccessTable> tableList = new BLL.AccessTable().DataTableToList(DbHelperSQL.Query(strSql).Tables[0]); string sessionString = ""; if (tableList.Count != 0) { sessionString += "["; foreach (AccessTable tableModel in tableList) { sessionString += new JavaScriptSerializer().Serialize(tableModel) + ","; } sessionString = sessionString.Remove(sessionString.Length - 1); sessionString += "]"; } Session.Timeout = 30; Session["username"] = adminModel.Username; Session["access"] = sessionString; Session["name"] = adminModel.Name; Session["type"] = "管理员"; return(this.Json(new { result = 1, data = "" })); } else if (teacherList.Count > 0) { TeacherTable teacherModel = teacherList[0]; strSql = "select * from AccessTable where ID = 3 or ID = 4 or ID = 5 or ID = 6"; List <AccessTable> tableList = new BLL.AccessTable().DataTableToList(DbHelperSQL.Query(strSql).Tables[0]); string sessionString = ""; if (tableList.Count != 0) { sessionString += "["; foreach (AccessTable tableModel in tableList) { sessionString += new JavaScriptSerializer().Serialize(tableModel) + ","; } sessionString = sessionString.Remove(sessionString.Length - 1); sessionString += "]"; } Session.Timeout = 30; Session["username"] = teacherModel.Username; Session["access"] = sessionString; Session["name"] = teacherModel.Name; Session["type"] = "教师"; return(this.Json(new { result = 1, data = "" })); } else if (studentList.Count > 0) { BLL.IPTable bllIP = new BLL.IPTable(); string ipv4 = GetIPv4.GetClientIPv4Address(); string strIP = "IP='" + ipv4 + "'"; List <IPTable> ipList1 = bllIP.DataTableToList(bllIP.GetList(strIP).Tables[0]); if (ipList1.Count > 0) { IPTable IPModel = ipList1[0]; if (IPModel.Username.Equals(Username)) { StudentTable studentModel = studentList[0]; strSql = "select * from AccessTable where ID = 7 or ID = 8"; List <AccessTable> tableList = new BLL.AccessTable().DataTableToList(DbHelperSQL.Query(strSql).Tables[0]); string sessionString = ""; if (tableList.Count != 0) { sessionString += "["; foreach (AccessTable tableModel in tableList) { sessionString += new JavaScriptSerializer().Serialize(tableModel) + ","; } sessionString = sessionString.Remove(sessionString.Length - 1); sessionString += "]"; } Session.Timeout = 30; Session["username"] = studentModel.Username; Session["access"] = sessionString; Session["name"] = studentModel.Name; Session["type"] = "学生"; return(this.Json(new { result = 1, data = "" })); } else { return(this.Json(new { result = 2, data = "" })); } } else { strIP = "Username = '******'"; List <IPTable> ipList2 = bllIP.DataTableToList(bllIP.GetList(strIP).Tables[0]); if (ipList2.Count > 0) { return(this.Json(new { result = 2, data = "" })); } else { IPTable model = new IPTable(); model.Username = Username; model.IP = ipv4; bllIP.Add(model); StudentTable studentModel = studentList[0]; strSql = "select * from AccessTable where ID = 7 or ID = 8"; List <AccessTable> tableList = new BLL.AccessTable().DataTableToList(DbHelperSQL.Query(strSql).Tables[0]); string sessionString = ""; if (tableList.Count != 0) { sessionString += "["; foreach (AccessTable tableModel in tableList) { sessionString += new JavaScriptSerializer().Serialize(tableModel) + ","; } sessionString = sessionString.Remove(sessionString.Length - 1); sessionString += "]"; } Session.Timeout = 30; Session["username"] = studentModel.Username; Session["access"] = sessionString; Session["name"] = studentModel.Name; Session["type"] = "学生"; return(this.Json(new { result = 1, data = "" })); } } } else { return(this.Json(new { result = 0, data = "" })); } }