/// <summary> /// 增加一条数据 /// </summary> public void Add(XHD.Model.ssn_authority model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ssn_authority("); strSql.Append("Role_id,Factory_Id,App_ids,Menu_ids,Button_ids,Create_id,Create_date)"); strSql.Append(" values ("); strSql.Append("@Role_id,@Factory_Id,@App_ids,@Menu_ids,@Button_ids,@Create_id,@Create_date)"); MySqlParameter[] parameters = { new MySqlParameter("@Role_id", MySqlDbType.Int32, 4), new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@App_ids", MySqlDbType.VarChar, 250), new MySqlParameter("@Menu_ids", MySqlDbType.VarChar, 10000), new MySqlParameter("@Button_ids", MySqlDbType.VarChar, 10000), new MySqlParameter("@Create_id", MySqlDbType.Int32, 4), new MySqlParameter("@Create_date", MySqlDbType.DateTime) }; parameters[0].Value = model.Role_id; parameters[1].Value = model.Factory_Id; parameters[2].Value = model.App_ids; parameters[3].Value = model.Menu_ids; parameters[4].Value = model.Button_ids; parameters[5].Value = model.Create_id; parameters[6].Value = model.Create_date; DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ssn_authority GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Role_id,Factory_Id,App_ids,Menu_ids,Button_ids,Create_id,Create_date from ssn_authority "); strSql.Append(" where limit 1 "); MySqlParameter[] parameters = { }; XHD.Model.ssn_authority model = new XHD.Model.ssn_authority(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Role_id"] != null && ds.Tables[0].Rows[0]["Role_id"].ToString() != "") { model.Role_id = int.Parse(ds.Tables[0].Rows[0]["Role_id"].ToString()); } if (ds.Tables[0].Rows[0]["App_ids"] != null && ds.Tables[0].Rows[0]["App_ids"].ToString() != "") { model.App_ids = ds.Tables[0].Rows[0]["App_ids"].ToString(); } if (ds.Tables[0].Rows[0]["Menu_ids"] != null && ds.Tables[0].Rows[0]["Menu_ids"].ToString() != "") { model.Menu_ids = ds.Tables[0].Rows[0]["Menu_ids"].ToString(); } if (ds.Tables[0].Rows[0]["Button_ids"] != null && ds.Tables[0].Rows[0]["Button_ids"].ToString() != "") { model.Button_ids = ds.Tables[0].Rows[0]["Button_ids"].ToString(); } if (ds.Tables[0].Rows[0]["Create_id"] != null && ds.Tables[0].Rows[0]["Create_id"].ToString() != "") { model.Create_id = int.Parse(ds.Tables[0].Rows[0]["Create_id"].ToString()); } if (ds.Tables[0].Rows[0]["Create_date"] != null && ds.Tables[0].Rows[0]["Create_date"].ToString() != "") { model.Create_date = DateTime.Parse(ds.Tables[0].Rows[0]["Create_date"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.ssn_authority model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ssn_authority set "); strSql.Append("Role_id=@Role_id,"); strSql.Append("Factory_Id=@Factory_Id,"); strSql.Append("App_ids=@App_ids,"); strSql.Append("Menu_ids=@Menu_ids,"); strSql.Append("Button_ids=@Button_ids,"); strSql.Append("Create_id=@Create_id,"); strSql.Append("Create_date=@Create_date"); strSql.Append(" where "); MySqlParameter[] parameters = { new MySqlParameter("@Role_id", MySqlDbType.Int32, 4), new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@App_ids", MySqlDbType.VarChar, 250), new MySqlParameter("@Menu_ids", MySqlDbType.VarChar, 10000), new MySqlParameter("@Button_ids", MySqlDbType.VarChar, 10000), new MySqlParameter("@Create_id", MySqlDbType.Int32, 4), new MySqlParameter("@Create_date", MySqlDbType.DateTime) }; parameters[0].Value = model.Role_id; parameters[1].Value = model.Factory_Id; parameters[2].Value = model.App_ids; parameters[3].Value = model.Menu_ids; parameters[4].Value = model.Button_ids; parameters[5].Value = model.Create_id; parameters[6].Value = model.Create_date; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; XHD.BLL.ssn_role role = new XHD.BLL.ssn_role(); XHD.BLL.ssn_art_menu menu = new XHD.BLL.ssn_art_menu(); XHD.Model.ssn_role model = new XHD.Model.ssn_role(); XHD.BLL.ssn_visit visit = new XHD.BLL.ssn_visit(); XHD.BLL.ssn_art art = new XHD.BLL.ssn_art(); var cookie = context.Request.Cookies[FormsAuthentication.FormsCookieName]; var ticket = FormsAuthentication.Decrypt(cookie.Value); string CoockiesID = ticket.UserData; XHD.BLL.hr_employee emp = new XHD.BLL.hr_employee(); int emp_id = int.Parse(CoockiesID); DataSet dsemp = emp.GetList("id=" + emp_id); string empname = string.Empty; string uid = string.Empty; string factory_Id = string.Empty; if (dsemp != null && dsemp.Tables[0].Rows.Count > 0) { empname = dsemp.Tables[0].Rows[0]["name"].ToString(); uid = dsemp.Tables[0].Rows[0]["uid"].ToString(); factory_Id = dsemp.Tables[0].Rows[0]["Factory_Id"].ToString(); } //角色保存 if (request["Action"] == "SysSave") { model.RoleName = PageValidate.InputText(request["T_role"], 250); model.RoleSort = int.Parse(request["T_RoleOrder"]); model.RoleDscript = PageValidate.InputText(request["T_Descript"], 255); model.Factory_Id = factory_Id; string id = PageValidate.InputText(request["id"], 50); if (!string.IsNullOrEmpty(id) && id != "null") { DataSet ds = role.GetList("RoleID=" + int.Parse(id)); DataRow dr = ds.Tables[0].Rows[0]; model.RoleID = int.Parse(id); model.UpdateDate = DateTime.Now; model.UpdateID = emp_id; role.Update(model); } else { model.CreateID = emp_id; model.CreateDate = DateTime.Now; int rid = role.Add(model); } } //验证是否唯一 else if (request["Action"] == "Exist") { DataSet ds1 = role.GetList(" RoleName='" + XHD.Common.PageValidate.InputText(request["T_role"], 250) + "'" + " and factory_Id='" + factory_Id + "'"); context.Response.Write(ds1.Tables[0].Rows.Count > 0 ? "false" : "true"); } //获取角色表格json else if (request["Action"] == "grid") { DataSet ds = role.GetList(0, "factory_Id='" + factory_Id + "'", " RoleSort"); string dt = XHD.Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } //获取角色信息 else if (request["Action"] == "form") { DataSet ds = role.GetList(" RoleID=" + int.Parse(request["id"])); string dt = XHD.Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //删除角色 else if (request["Action"] == "del") { string rid = request["id"]; bool isdel = role.Delete(int.Parse(rid)); if (isdel) { context.Response.Write("true"); } else { context.Response.Write("false"); } //角色下员工删除 XHD.BLL.ssn_role_emp rm = new XHD.BLL.ssn_role_emp(); rm.Delete("RoleID=" + int.Parse(rid)); //角色下数据权限删除 XHD.BLL.ssn_visit data_auth = new XHD.BLL.ssn_visit(); data_auth.DeleteByRole(int.Parse(rid)); //角色下功能权限删除 XHD.BLL.ssn_authority auth = new XHD.BLL.ssn_authority(); auth.DeleteWhere("Role_id=" + int.Parse(rid)); } #region 权限设置 //auth else if (request["Action"] == "treegrid") { string appidstr = request["appid"]; int appid = int.Parse(appidstr); //获取单位 string ftyid = PageValidate.InputText(request["factory_id"], 60); //设置查询条件 string wheretext = "App_id=" + appid; //限制menu string wheretext2 = ""; //限制button DataTable dt = menu.GetList(wheretext).Tables[0]; dt.Columns.Add(new DataColumn("Sysroler", typeof(string))); XHD.BLL.ssn_button btn = new XHD.BLL.ssn_button(); for (int i = 0; i < dt.Rows.Count; i++) { DataSet ds = btn.GetList(0, "Menu_id=" + dt.Rows[i]["Menu_id"].ToString() + wheretext2, "Btn_order"); string roler = ""; if (ds.Tables[0].Rows.Count > 0) { for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { roler += ds.Tables[0].Rows[j]["Btn_id"].ToString() + "|" + ds.Tables[0].Rows[j]["Btn_name"].ToString(); roler += ","; } } dt.Rows[i][dt.Columns.Count - 1] = roler; } string dt1 = "{Rows:[" + GetTasksString(0, dt) + "]}"; context.Response.Write(dt1); context.Response.End(); } //get auth else if (request["Action"] == "getauth") { string postdata = Convert.ToString(HttpContext.Current.Request.QueryString["postdata"]); JavaScriptSerializer json = new JavaScriptSerializer(); save sa = json.Deserialize <save>(postdata); XHD.Model.ssn_authority modelauth = new XHD.Model.ssn_authority(); modelauth.Role_id = int.Parse(sa.role_id); modelauth.App_ids = sa.app; modelauth.Menu_ids = sa.menu; modelauth.Button_ids = sa.btn; XHD.BLL.ssn_authority sysau = new XHD.BLL.ssn_authority(); string roledata = "0|0"; DataSet ds = sysau.GetList("Role_id=" + modelauth.Role_id + " and App_ids='" + modelauth.App_ids + "'"); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; roledata = dr["Menu_ids"] + "|" + dr["Button_ids"]; } context.Response.Write(roledata); } // save auth else if (request["Action"] == "saveauth") { string postdata = Convert.ToString(HttpContext.Current.Request.QueryString["postdata"]); JavaScriptSerializer json = new JavaScriptSerializer(); save sa = json.Deserialize <save>(postdata); XHD.Model.ssn_authority modelauth = new XHD.Model.ssn_authority(); modelauth.Role_id = int.Parse(sa.role_id); modelauth.App_ids = PageValidate.InputText(sa.app, 50); modelauth.Menu_ids = PageValidate.InputText(sa.menu, int.MaxValue); modelauth.Button_ids = PageValidate.InputText(sa.btn, int.MaxValue); modelauth.Factory_Id = factory_Id; XHD.BLL.ssn_authority sysau = new XHD.BLL.ssn_authority(); //List<string> relstbtn = new List<string>(); if (!string.IsNullOrEmpty(postdata)) { //给角色分配权限 sysau.DeleteWhere("Role_id=" + modelauth.Role_id + " and App_ids='" + modelauth.App_ids + "'"); if (modelauth.Menu_ids != "" || modelauth.Button_ids != ",,") { sysau.Add(modelauth); } context.Response.Write("{sucess:sucess}"); } } #endregion #region 查看权限设置 //菜单显示 else if (request["Action"] == "menuList") { string appid = request["appid"]; string authtxt = PageValidate.InputText(request["auth"], 50); if (!string.IsNullOrEmpty(appid)) { string serchtxt = " App_id=" + int.Parse(appid); //-context.Response.Write(authtxt); DataSet ds = menu.GetList(0, serchtxt, " Menu_order"); StringBuilder str = new StringBuilder(); str.Append("["); str.Append(GetTreeString(0, ds.Tables[0], authtxt)); str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } } //显示菜单下的文章 else if (request["Action"] == "viewgrid") { //通过菜单id获取旗下的文章 string menuid = request["menuid"]; if (!string.IsNullOrEmpty(menuid)) { string serchtxt = " Factory_Id='" + factory_Id + "' and Art_Menu_Id=" + int.Parse(menuid) + " and is_del=0 "; DataSet ds = art.GetList(serchtxt); string dt = XHD.Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } } //保存查看权限 else if (request["Action"] == "saveview") { string postdata = Convert.ToString(HttpContext.Current.Request.QueryString["postdata"]); JavaScriptSerializer json = new JavaScriptSerializer(); view sa = json.Deserialize <view>(postdata); XHD.Model.ssn_visit modelview = new XHD.Model.ssn_visit(); modelview.Role_id = int.Parse(sa.role_id); modelview.App_ids = PageValidate.InputText(sa.app, 50); modelview.Menu_ids = PageValidate.InputText(sa.menu, int.MaxValue); modelview.Art_id = PageValidate.InputText(sa.art, int.MaxValue); modelview.Factory_Id = factory_Id; modelview.Create_id = emp_id; modelview.Create_date = DateTime.Now; if (!string.IsNullOrEmpty(postdata)) { //给角色分配权限 visit.DeleteWhere("Role_id=" + modelview.Role_id + " and Menu_ids='" + modelview.Menu_ids + "'"); if (modelview.Art_id != "") { visit.Add(modelview); } context.Response.Write("{sucess:sucess}"); } } //获取当前角色的权限 else if (request["Action"] == "getview") { string postdata = Convert.ToString(HttpContext.Current.Request.QueryString["postdata"]); JavaScriptSerializer json = new JavaScriptSerializer(); view sa = json.Deserialize <view>(postdata); XHD.Model.ssn_visit modelview = new XHD.Model.ssn_visit(); modelview.Role_id = int.Parse(sa.role_id); modelview.App_ids = sa.app; modelview.Menu_ids = sa.menu; modelview.Art_id = sa.art; string roledata = ""; DataSet ds = visit.GetList("Role_id=" + modelview.Role_id + " and Menu_ids='" + modelview.Menu_ids + "'"); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; roledata = dr["Art_id"].ToString(); } context.Response.Write(roledata); } #endregion }