public IHttpActionResult DeleteGroupUser(string id_group, string id_user)
{
if (!GroupsData.deleteGroupUser(id_group, id_user))
{
return(BadRequest());
}
return(Ok());
}
public IHttpActionResult Put(GroupDTO pGroupDTO)
{
if (!GroupsData.updateGroup(pGroupDTO))
{
return(BadRequest());
}
return(Ok());
}
public IHttpActionResult Delete(int id_group)
{
if (!GroupsData.deleteGroup(id_group.ToString()))
{
return(BadRequest());
}
return(Ok());
}
public IHttpActionResult Post(GroupDTO pGroupDTO)
{
if (!GroupsData.insertGroup(pGroupDTO))
{
return(BadRequest());
}
return(Ok());
}
public void GetGroupsInfo(out List <GroupsData> lstgroup, out List <TersData> lstter)
{
lstgroup = null;
lstter = null;
//获得组信息
string SQL_grp = "SELECT GroupId,Name,Remark FROM EN_Group";
using (SqlDataReader reader_grp = SQLHelper.ExecuteReader(SQL_grp, null))
{
lstgroup = new List <GroupsData>();
while (reader_grp.Read())
{
GroupsData grp = new GroupsData();
grp.groupid = reader_grp["GroupId"].ToString();
grp.groupname = reader_grp["Name"].ToString();
grp.remark = reader_grp["Remark"].ToString();
lstgroup.Add(grp);
}
}
bool addungroup = false; //是否添加一个空分组
string SQL_ter = "SELECT relate.GroupId,rec.RecorderId,rec.Remark,rec.GroupState FROM EN_NoiseRecorder as rec LEFT JOIN MP_GroupRecorder as relate ON rec.RecorderId = relate.RecorderId";
using (SqlDataReader reader_ter = SQLHelper.ExecuteReader(SQL_ter, null))
{
lstter = new List <TersData>();
while (reader_ter.Read())
{
TersData ter = new TersData();
ter.groupid = reader_ter["GroupId"] != DBNull.Value ? reader_ter["GroupId"].ToString() : "";
ter.terid = reader_ter["RecorderId"] != DBNull.Value ? reader_ter["RecorderId"].ToString() : "";
ter.remark = reader_ter["Remark"] != DBNull.Value ? reader_ter["Remark"].ToString() : "";
ter.groupstate = reader_ter["GroupState"] != DBNull.Value ? Convert.ToInt32(reader_ter["GroupState"]) : 0;
//lstter.Add(ter); //未分组终端不发送，未分组不能读取数据
if (ter.groupid == "")
{
;//addungroup = true;
}
else
{
lstter.Add(ter);
}
}
}
if (addungroup)
{
GroupsData grp = new GroupsData();
lstgroup.Add(grp);
}
}
public List <GroupUserDTO> postGroupUsers(List <GroupUserDTO> pGroupUserListDTO)
{
List <GroupUserDTO> insertedUsers = new List <GroupUserDTO>();
foreach (var groupUser in pGroupUserListDTO)
{
if (GroupsData.insertGroupUser(groupUser))
{
insertedUsers.Add(groupUser);
}
}
return(insertedUsers);
}
/// <summary>
/// Clears out all values stored in the dictionaries.
/// </summary>
public static void ClearAll()
{
Configurations.Clear();
Projects.Clear();
FamilyData.Clear();
SheetsData.Clear();
WorksetsData.Clear();
ModelsData.Clear();
TriggerRecords.Clear();
ViewsData.Clear();
StylesData.Clear();
LinksData.Clear();
GroupsData.Clear();
}
public IEnumerable <UserDTO> getGroupMembers(string group_id)
{
List <UserDTO> users = GroupsData.getGroupUsers(group_id);
return(users);
}
public GroupDTO Get(string id_group)
{
GroupDTO group = GroupsData.getGroup(id_group);
return(group);
}
public IEnumerable <GroupDTO> Get()
{
List <GroupDTO> groups = GroupsData.getGroups();
return(groups);
}
/// <summary>
/// Processes Group Stats to create Summary.
/// </summary>
/// <param name="data">Groups Data</param>
/// <returns></returns>
private static HealthReportSummaryViewModel ProcessGroups(GroupsData data)
{
var groupStats = data.GroupStats.FirstOrDefault();
if (groupStats == null)
{
return(null);
}
var unused = groupStats.Groups.Any(x => x.Instances.Count == 0);
var mGroups = 0;
var dGroups = 0;
foreach (var g in groupStats.Groups)
{
if (g.Type == "Model Group")
{
mGroups++;
}
else
{
dGroups++;
}
}
var passingChecks = 0;
if (!unused)
{
passingChecks += 2;
}
if (mGroups <= 10)
{
passingChecks += 2;
}
else if (mGroups > 10 && mGroups <= 20)
{
passingChecks += 1;
}
if (dGroups <= 10)
{
passingChecks += 2;
}
else if (dGroups > 10 && dGroups <= 20)
{
passingChecks += 1;
}
const int maxScore = 6;
var vm = new HealthReportSummaryViewModel
{
Count = groupStats.Groups.Count.ToString(),
Title = "Groups:",
ToolName = "Groups Manager",
ShowButton = true,
Score = passingChecks + "/" + maxScore,
FillColor = GetColor(passingChecks, maxScore)
};
return(vm);
}
