public ActionResult Create(Model.UserTable model, string authIdsa) { bool result = false; //model.ID = 1; HTNResp.BLL.Program bllProgram = new BLL.Program(); HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid(); if (!String.IsNullOrEmpty(model.UserName) && !String.IsNullOrEmpty(model.UserCode) && !String.IsNullOrEmpty(model.Password)) { HTNResp.BLL.UserTable bll = new HTNResp.BLL.UserTable(); HTNResp.BLL.PermissionTable per = new BLL.PermissionTable(); var state = bll.Add(model); var list = authIdsa.Split(','); if (state != 0) { if (string.IsNullOrEmpty(authIdsa)) { list = new List <string>().ToArray(); } foreach (var item in list) { if (per.Add(new Model.PermissionTable() { TableID = int.Parse(item), UserID = state }) != 0) { continue; } else { result = false; break; } } result = true; } } if (result) { return(this.Json(new { result = 1, data = "" })); } else { return(this.Json(new { result = 0, msg = "新建失败" })); } }
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 = "" })); } }