/// <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");
}
