/// <summary> /// 获取学校数据 /// </summary> /// <returns></returns> public string GetSchoolList() { List <object> Ret = new List <object>(); try { string sql = "SELECT row_number() over (order by CreateTime DESC) as rowid, * FROM Z_School "; DBOperation db = new DBOperation(); DataSet ds = new DataSet(); ds = db.GetDataSet(sql); //保存数据表并返回 Ret.Add(ds); return("{\"result\":\"success\",\"list\":" + ToJosn.wxListToJson(Ret) + "}"); } catch (Exception ex) { Ret.Add("state:0,msg:获取数据错误!"); return(ToJosn.wxListToJson(Ret)); } }
/// <summary> /// 分页数据 /// 页面权限信息 /// </summary> /// <param name="title">页面权限名称</param> /// <returns></returns> public string Select_Role_Page(string title) { List <object> Ret = new List <object>(); try { string sql = "SELECT row_number() over (order by EditDate DESC) as rowid, * FROM Z_Role WHERE Del = '0' AND Title LIKE '%" + title + "%'"; DBOperation db = new DBOperation(); DataSet ds = new DataSet(); ds = db.GetDataSet(sql); //保存数据表并返回 Ret.Add(ds); return("{\"result\":\"success\",\"list\":" + ToJosn.wxListToJson(Ret) + "}"); } catch (Exception ex) { Ret.Add("state:0,msg:获取数据错误!"); return(ToJosn.wxListToJson(Ret)); } }
/// <summary> /// 获取角色下的用户 /// </summary> /// <param name="title">页面权限名称</param> /// <returns></returns> public string get_role_user_list(string id) { List <object> Ret = new List <object>(); try { string sql = "select * from Z_User "; sql = sql + " where PageRole_ID='" + id + "' "; DBOperation db = new DBOperation(); DataSet ds = new DataSet(); ds = db.GetDataSet(sql); //保存数据表并返回 // Ret.Add(ds); return("{\"result\":\"success\",\"id\":\"" + id + "\",\"list\":" + JsonHelper.ToJson(ds) + "}"); } catch (Exception ex) { Ret.Add("state:0,msg:获取数据错误!"); return(ToJosn.wxListToJson(Ret)); } }
public string GetSchoolBySchoolId(string SchoolId) { List <object> Ret = new List <object>(); try { string sql = " "; sql = sql + " select * from Z_School "; sql = sql + " where RecordId = '" + SchoolId + "'"; DBOperation db = new DBOperation(); DataSet ds = new DataSet(); ds = db.GetDataSet(sql); //保存数据表并返回 Ret.Add(ds); return("{\"result\":\"success\",\"list\":" + ToJosn.wxListToJson(Ret) + "}"); } catch (Exception ex) { Ret.Add("state:0,msg:获取数据错误!"); return(ToJosn.wxListToJson(Ret)); } }
/// <summary> /// 分页数据 /// 页面权限信息 /// </summary> /// <param name="title">页面权限名称</param> /// <returns></returns> public string get_role_user() { List <object> Ret = new List <object>(); try { string sql = "select Z_Role.* ,(select count(*) from Z_User "; sql = sql + " where Z_Role.ID=Z_User.PageRole_ID) as usercount "; sql = sql + " FROM Z_Role WHERE Del = '0'"; DBOperation db = new DBOperation(); DataSet ds = new DataSet(); ds = db.GetDataSet(sql); //保存数据表并返回 Ret.Add(ds); return("{\"result\":\"success\",\"list\":" + ToJosn.wxListToJson(Ret) + "}"); } catch (Exception ex) { Ret.Add("state:0,msg:获取数据错误!"); return(ToJosn.wxListToJson(Ret)); } }