// GET: Role public ActionResult Index(string CompanyId) { ViewBag.Companyid = CompanyId; CompanyId = Base64MIMA.JIE(CompanyId); #region 添加显示的权限 //查出所有父权限 string sqlstr = string.Format("select * from Author where PID is null and IsValid=0 and Fanwei=0"); DataTable dt = sql.GetDataTableCommand(sqlstr); //根据父id得到子id List <AuthorModellist> authorlist = new List <AuthorModellist>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AuthorModellist Authors = new AuthorModellist(); Authors.Id = dt.Rows[i]["AuthorID"].ToString(); Authors.Name = dt.Rows[i]["AuthorName"].ToString(); List <AuthorModel> amlist = new List <AuthorModel>(); string sqlstr2 = string.Format("select * from Author where PID={0} and IsValid=0 and Fanwei=0", dt.Rows[i]["AuthorID"].ToString()); DataTable dt2 = sql.GetDataTableCommand(sqlstr2); if (dt2.Rows.Count > 0) { for (int ii = 0; ii < dt2.Rows.Count; ii++) { AuthorModel am = new AuthorModel(); am.AuthorId = dt2.Rows[ii]["AuthorID"].ToString(); am.AuthorName = dt2.Rows[ii]["AuthorName"].ToString(); am.AuthorUrl = dt2.Rows[ii]["AuthorUrl"].ToString(); am.AuthorIcons = dt2.Rows[ii]["AuthorIcon"].ToString(); amlist.Add(am); } Authors.listAuthor = amlist; } authorlist.Add(Authors); } ViewBag.authorlist2 = authorlist; } else { ViewBag.authorlist2 = null; } #endregion #region 查询 //根据公司查对应的角色 string sqlstrRole = string.Format("select * from Role where CompanyID='{0}'", CompanyId); DataTable dtRole = sql.GetDataTableCommand(sqlstrRole); if (dtRole.Rows.Count > 0) { ViewBag.Rolelist = dtRole; } else { ViewBag.Rolelist = null; } #endregion return(View()); }
//添加页面 public ActionResult AddRole(string CompanyID) { #region 添加显示的权限 try { //查出所有父权限 string sqlstr = string.Format("select * from Author where PID is null and IsValid=0 and Fanwei=0"); DataTable dt = sql.GetDataTableCommand(sqlstr); //根据父id得到子id List <AuthorModellist> authorlist = new List <AuthorModellist>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AuthorModellist Authors = new AuthorModellist(); Authors.Id = dt.Rows[i]["AuthorID"].ToString(); Authors.Name = dt.Rows[i]["AuthorName"].ToString(); List <AuthorModel> amlist = new List <AuthorModel>(); string sqlstr2 = string.Format("select * from Author where PID={0} and IsValid=0 and Fanwei=0", dt.Rows[i]["AuthorID"].ToString()); DataTable dt2 = sql.GetDataTableCommand(sqlstr2); if (dt2.Rows.Count > 0) { for (int ii = 0; ii < dt2.Rows.Count; ii++) { AuthorModel am = new AuthorModel(); am.AuthorId = dt2.Rows[ii]["AuthorID"].ToString(); am.AuthorName = dt2.Rows[ii]["AuthorName"].ToString(); am.AuthorUrl = dt2.Rows[ii]["AuthorUrl"].ToString(); am.AuthorIcons = dt2.Rows[ii]["AuthorIcon"].ToString(); amlist.Add(am); } Authors.listAuthor = amlist; } authorlist.Add(Authors); } ViewBag.authorlist2 = authorlist; } else { ViewBag.authorlist2 = null; } } catch (Exception ex) { return(Redirect("/ErrorPage/Index")); } #endregion ViewBag.CompanyID = CompanyID; return(View()); }
// GET: Main public ActionResult Index(string userId, string counts, string companyId) { try { ViewBag.count = counts; ViewBag.counts = int.Parse(Base64MIMA.JIE(counts)); ViewBag.CompanyID = companyId; string userid = Base64MIMA.JIE(userId); companyId = Base64MIMA.JIE(companyId); #region //string code1 = Request["code"]; ////通过code得到userid 解决办法:把code根据时间来刷新,让他可以不停的访问哪个链接 //log.AppenLog("code1:" + code1); //if (code1 != "") //{ // Tuple<bool, string> tu2 = BonusHelper.AccessTokenHelper.GetWechatUserInfo(code1); // //Tuple<bool, string> tu2 = new Tuple<bool, string>(true,""); // if (tu2.Item1 || Session["aaa"] != null) // { // if (Session["aaa"] == null) // { // log.AppenLog("if"); // userid = tu2.Item2;//得到userid // Session["aaa"] = userid; // // c.Value = tu2.Item2; // } // else // { // log.AppenLog("else"); // userid = Session["aaa"].ToString(); // //userid = c.Value; // } // } //} //else //{ //} //userid = Session["aaa"].ToString(); //userid = "qwezzz"; //userid = Session["aaa"].ToString(); //WriteLog("id:" + Session["aaa"].ToString()); //userid = userid.Replace('"', ' '); //userid = userid.Trim(); #endregion //查找员工所属 ViewBag.userid = userId; Session["ComeUserID"] = userid; //看登录进来的人有没有公司,如果有公司就进入主界面 #region //string[] canshu = new string[] { "SelectEmp", userid }; //DataTable dt_canshu = sql.GetDataTableProcedure("proc_Main", canshu); //if (dt_canshu.Rows.Count > 0) //{ // //有这个人,判断是否有公司 // if (dt_canshu.Rows[0]["CompanyID"].ToString() == "") // { // //没有公司,需要注册公司 // return Redirect("/CompanyRegist/Index?UserID=" + userid); // } // else // { // //有公司 // //用base64机密用户id和公司id // ViewBag.userids = Convert.ToBase64String(Encoding.Default.GetBytes(userid)); // ViewBag.CompanyID = Convert.ToBase64String(Encoding.Default.GetBytes(dt_canshu.Rows[0]["CompanyID"].ToString())); // } //} //else //{ // //没有这个人,需要注册公司 // return Redirect("/CompanyRegist/Index?UserID=" + userid); //} #endregion //通过userid得到公司id //string sqlstr22 = string.Format($"select CompanyID from Employee where EmpID='{userid}'"); //DataTable dt22 = sql.GetDataTableCommand(sqlstr22); //if (dt22.Rows.Count > 0) //{ // ViewBag.CompanyID = Base64MIMA.JIA(dt22.Rows[0]["CompanyID"].ToString()); //} //else //{ // //公司注册页面 // return Redirect("/CompanyRegist/Index?UserID=" + userId); // //return Content("<script>alert('出现错误,请联系相关人员处理');history.go(-1);</script>"); //} #region 查出所有父权限 //查出所有父权限 //string sqlstr = string.Format("select * from Author where PID is null"); string sqlstr = string.Format("exec proc_Main 'SelectAuthorFi','{0}',0,'{1}'", userid, companyId); DataTable dt = sql.GetDataTableCommand(sqlstr); //根据父id得到子 List <AuthorModellist> authorlist = new List <AuthorModellist>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AuthorModellist Authors = new AuthorModellist(); Authors.Id = dt.Rows[i]["AuthorID"].ToString(); Authors.Name = dt.Rows[i]["AuthorName"].ToString(); List <AuthorModel> amlist = new List <AuthorModel>(); string sqlstr2 = string.Format("exec proc_Main 'SelectAuthorzi','{0}',{1},'{2}'", userid, dt.Rows[i]["AuthorID"].ToString(), companyId); DataTable dt2 = sql.GetDataTableCommand(sqlstr2); if (dt2.Rows.Count > 0) { for (int ii = 0; ii < dt2.Rows.Count; ii++) { AuthorModel am = new AuthorModel(); am.AuthorId = dt2.Rows[ii]["AuthorID"].ToString(); am.AuthorName = dt2.Rows[ii]["AuthorName"].ToString(); am.AuthorUrl = dt2.Rows[ii]["AuthorUrl"].ToString(); am.AuthorIcons = dt2.Rows[ii]["AuthorIcon"].ToString(); amlist.Add(am); } Authors.listAuthor = amlist; } authorlist.Add(Authors); } ViewBag.authorlist = authorlist; } else { ViewBag.authorlist = null; } #endregion } catch (Exception ex) { log.AppenLog("mainIndex错误:" + ex.Message); return(Redirect("/ErrorPage/Index")); } return(View()); }
//找到编辑的数据 public ActionResult Detial(string RoleId) { string sqlstr3 = string.Format("select r.RoleName,r.RoleID,a.ModuleCode,r.IsActive from Role r,Authorities a where r.RoleID=a.RoleID and a.RoleID='{0}'", RoleId); DataTable dt3 = sql.GetDataTableCommand(sqlstr3); if (dt3.Rows?.Count > 0) { ViewBag.detialRole = dt3; #region 添加显示的权限 //查出所有父权限 string sqlstr = ""; if (dt3.Rows[0]["RoleName"].ToString() == "超级管理员") { sqlstr = string.Format("select * from Author where PID is null and IsValid=0"); } else { sqlstr = string.Format("select * from Author where PID is null and IsValid=0 and Fanwei=0"); } DataTable dt = sql.GetDataTableCommand(sqlstr); //根据父id得到子id List <AuthorModellist> authorlist = new List <AuthorModellist>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AuthorModellist Authors = new AuthorModellist(); Authors.Id = dt.Rows[i]["AuthorID"].ToString(); Authors.Name = dt.Rows[i]["AuthorName"].ToString(); Authors.AuthName = dt3.Rows[0]["RoleName"].ToString(); Authors.AuthId = dt3.Rows[0]["RoleID"].ToString(); Authors.IsActive = dt3.Rows[0]["IsActive"].ToString();//是否有效 List <AuthorModel> amlist = new List <AuthorModel>(); string sqlstr2 = ""; if (dt3.Rows[0]["RoleName"].ToString() == "超级管理员") { sqlstr2 = string.Format("select * from Author where PID={0} and IsValid=0", dt.Rows[i]["AuthorID"].ToString()); } else { sqlstr2 = string.Format("select * from Author where PID={0} and IsValid=0 and Fanwei=0", dt.Rows[i]["AuthorID"].ToString()); } DataTable dt2 = sql.GetDataTableCommand(sqlstr2); if (dt2.Rows.Count > 0) { for (int ii = 0; ii < dt2.Rows.Count; ii++) { AuthorModel am = new AuthorModel(); for (int a = 0; a < dt3.Rows.Count; a++) { if (dt3.Rows[a]["ModuleCode"].ToString() == dt2.Rows[ii]["AuthorID"].ToString()) { am.AuthorContian = "0";//为0就代表有这个 a = dt3.Rows.Count; } else { am.AuthorContian = "1"; } } am.AuthorId = dt2.Rows[ii]["AuthorID"].ToString(); am.AuthorName = dt2.Rows[ii]["AuthorName"].ToString(); am.AuthorUrl = dt2.Rows[ii]["AuthorUrl"].ToString(); am.AuthorIcons = dt2.Rows[ii]["AuthorIcon"].ToString(); amlist.Add(am); } Authors.listAuthor = amlist; } authorlist.Add(Authors); } ViewBag.authorlist2 = authorlist; } else { ViewBag.authorlist2 = null; } #endregion } else { ViewBag.detialRole = null; } return(View()); }