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");
}
public string DeleteData(string ID)
{
var Ent = SysOrganization.Find(ID);
//删除相关联的人员
var RefEnts = SysOrgUser.FindAllByProperties(SysOrgUser.Prop_OrgID, Ent.ID);
if (RefEnts.Length > 0)
{
foreach (var item in RefEnts)
{
item.DoDelete();
}
}
Ent.DoDelete();
return("1");
}
public string RefUserToOrg(string Json, string PID)
{
var OrgEnt = SysOrganization.Find(PID);
var Ents = JSON.Deserialize <SysUser[]>(Json);
foreach (var item in Ents)
{
//去除重复
int a = SysOrgUser.GetCount(Expression.Sql("UserID='" + item.ID + "' and OrgID='" + OrgEnt.ID + "'"));
if (a > 0)
{
continue;
}
SysOrgUser OrgUsr = new SysOrgUser();
OrgUsr.OrgID = OrgEnt.ID;
OrgUsr.OrgName = OrgEnt.Name;
OrgUsr.UserID = item.ID;
OrgUsr.UserName = item.Name;
OrgUsr.DoCreate();
}
return("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");
}
