/// <summary> /// 获取最大编号 /// </summary> private void GetMaxNum() { var MuxNum = SysGroupOrRole.FindAll().Max(ten => ten.SortIndex); Response.Write(MuxNum.GetValueOrDefault() + 5); Response.End(); }
public string SaveSelectNode(string NodeIds, string RoleOrGroupID) { if (string.IsNullOrEmpty(NodeIds)) { return("0"); } if (!string.IsNullOrEmpty(RoleOrGroupID)) { string[] idList = JsonConvert.DeserializeObject <string[]>(NodeIds); var GrEnt = SysGroupOrRole.Find(RoleOrGroupID); //先删除 string SQL = "delete from SysOrgRefGroupOrRole where GroupOrRoleID='" + RoleOrGroupID + "'"; DataHelper.ExecSql(SQL); foreach (var item in idList) { var OrgEnt = SysOrganization.Find(item); SysOrgRefGroupOrRole Ent = new SysOrgRefGroupOrRole(); Ent.OrgID = OrgEnt.ID; Ent.OrgName = OrgEnt.Name; Ent.GroupOrRoleID = GrEnt.ID; Ent.GroupOrRoleName = GrEnt.GroupName; Ent.DoCreate(); } } else { return("0"); } return("1"); }
protected void LoadOrgTreeData() { var list = SysGroupOrRole.FindAll().OrderBy(ten => ten.SortIndex).ToArray(); List <NodeObject> NodeList = GetOrgTree(list.ToArray(), "root"); string TreeJson = Razor.DynamicJson.DynamicJsonConvert.SerializeObject(NodeList); Response.Write(TreeJson); Response.End(); }
public string SaveData(string Record) { SysGroupOrRole Ent = JSON.Deserialize <SysGroupOrRole>(Record); Ent.Type = TypeSign;//role 代表角色 if (string.IsNullOrEmpty(Ent.ParentID)) { Ent.ParentID = "root"; } if (string.IsNullOrEmpty(Ent.ID)) { Ent.DoCreate(); } else { Ent.Update(); } return(Ent.ID); }
public string RefUserToOrg(string Json, string PID) { var OrgEnt = SysGroupOrRole.Find(PID); var Ents = JSON.Deserialize <SysUser[]>(Json); foreach (var item in Ents) { //去除重复 int a = SysGroupUser.GetCount(Expression.Sql("SysUserID='" + item.ID + "' and SysGroupID='" + OrgEnt.ID + "'")); if (a > 0) { continue; } SysGroupUser OrgUsr = new SysGroupUser(); OrgUsr.SysGroupID = OrgEnt.ID; OrgUsr.SysGroupName = OrgEnt.GroupName; OrgUsr.SysUserID = item.ID; OrgUsr.SysUserName = item.Name; OrgUsr.DoCreate(); } return("1"); }
public string DeleteData(string ID) { var Ent = SysGroupOrRole.Find(ID); //删除相关联的数据 var GUEnts = SysGroupUser.FindAllByProperties(SysGroupUser.Prop_SysGroupID, Ent.ID); var OrgEnts = SysOrgRefGroupOrRole.FindAllByProperty(SysOrgRefGroupOrRole.Prop_GroupOrRoleID, Ent.ID); if (GUEnts.Length > 0) { foreach (var item in GUEnts) { item.DoDelete(); } } if (OrgEnts.Length > 0) { foreach (var item in OrgEnts) { item.DoDelete(); } } Ent.DoDelete(); return("1"); }
public string DeleteCheck(string ID) { var Count = SysGroupOrRole.GetCount(Expression.Sql("ParentID='" + ID + "'")); return(Count > 0 ? "0" : "1"); }
public string CheckCode(string Code) { int Count = SysGroupOrRole.GetCount(Expression.Sql("GroupCode='" + Code + "'")); return(Count > 0 ? "0" : "1"); }
public string SaveSelectNode(string NodeIds, string RefID, string TabIndex) { if (string.IsNullOrEmpty(NodeIds)) { return("0"); } if (!string.IsNullOrEmpty(RefID)) { string[] idList = JsonConvert.DeserializeObject <string[]>(NodeIds); switch (TabIndex) { case "0": { //先删除 string SQL = "delete from SysOrgAuth where OrgID='" + RefID + "'"; DataHelper.ExecSql(SQL); var GrEnt = SysOrganization.Find(RefID); foreach (var item in idList) { var OrgEnt = DataModel.SysModule.Find(item); //创建 SysOrgAuth Ent = new SysOrgAuth(); Ent.OrgID = GrEnt.ID; Ent.OrgName = GrEnt.Name; Ent.ModuleID = OrgEnt.ID; Ent.ModuleName = OrgEnt.Name; Ent.DoCreate(); } } break; case "1": { //先删除 string SQL = "delete from SysGroupAuth where GroupID='" + RefID + "'"; DataHelper.ExecSql(SQL); var GrEnt = SysGroupOrRole.Find(RefID); foreach (var item in idList) { var OrgEnt = DataModel.SysModule.Find(item); //创建 SysGroupAuth Ent = new SysGroupAuth(); Ent.GroupID = GrEnt.ID; Ent.GroupName = GrEnt.GroupName; Ent.ModuleID = OrgEnt.ID; Ent.ModuleName = OrgEnt.Name; Ent.DoCreate(); } } break; case "2": { //先删除 string SQL = "delete from SysUserAuth where UserID='" + RefID + "'"; DataHelper.ExecSql(SQL); var GrEnt = SysUser.Find(RefID); foreach (var item in idList) { var OrgEnt = DataModel.SysModule.Find(item); //创建 SysUserAuth Ent = new SysUserAuth(); Ent.UserID = GrEnt.ID; Ent.UserName = GrEnt.Name; Ent.ModuleID = OrgEnt.ID; Ent.ModuleName = OrgEnt.Name; Ent.DoCreate(); } } break; } } else { return("0"); } return("1"); }