//public IEnumerable<AlarmLogModel> GetLogList(int alarmId)
//{
// string condition = " and alarmId = @alarmId";
// var searchObj = new { alarmId = alarmId };
// return _provider.GetLog(condition, searchObj);
//}
public IEnumerable <AlarmModel> GetList(int organId)
{
int[] organs = _organBusiness.GetChildren(organId).Select(m => m.Id).ToArray();
string condition = new ConditionHelper().And("OrganId", organs, CompareType.In)
.And("Confirm", 0, CompareType.Equal)
.ToString();
var searchObj = new { OrganId = organs, Confirm = 0 };
return(_provider.GetList(condition, searchObj, " order by LastTime desc LIMIT 0,100"));
}
public PageableData <TelbookModel> GetPage(string name, string telephone, int limit, int offset)
{
string condition = new ConditionHelper().And("Name", name, CompareType.Like)
.And("Telephone", telephone, CompareType.Like)
.ToString();
var searchObj = new
{
Name = $"%{name}%",
Telephone = $"%{telephone}%"
};
return(_provider.GetPage(condition, searchObj, "order by Id ASC", offset, limit));
}
public object GetPage(string name, int?state, int?typeId, int limit, int offset)
{
string condition = new ConditionHelper().And("Name", ref name, CompareType.Like)
.And("State", state, CompareType.Equal)
.ToString();
var searchObj = new
{
Name = name,
State = state
};
return(_provider.GetAllItems(condition, searchObj, " order by Id ASC"));
}
/// <summary>
/// 返回Line的页数据
/// </summary>
/// <param name="organizationName"></param>
/// <param name="name"></param>
/// <param name="lineIP"></param>
/// <param name="user"></param>
/// <param name="limit"></param>
/// <param name="offset"></param>
/// <returns></returns>
public PageableData <LineModel> GetPage(string organizationName, string name, string lineIP, int OrganId, int limit, int offset)
{
string condition = "";
var searchObj = new object();
int[] organs = _organBusiness.GetChildren(OrganId).Select(m => m.Id).ToArray();
condition = new ConditionHelper().And("OrganizationName", ref organizationName, CompareType.Like)
.And("Name", ref name, CompareType.Like)
.And("OrganizationId", organs, CompareType.In)
.And("LineIP", lineIP, CompareType.Equal)
.ToString();
searchObj = new { OrganizationName = organizationName, Name = name, LineIP = lineIP, OrganizationId = organs };
return(_provider.GetPage(condition, searchObj, " ", offset, limit));
}
public PageableData <UserModel> GetPage(string userName, int?state, int?typeId, int limit, int offset)
{
string condition = new ConditionHelper().And("Username", ref userName, CompareType.Like)
.And("State", state, CompareType.Equal)
//.And("TypeId", typeId, CompareType.Equal)
.ToString();
var searchObj = new
{
Username = string.Format("%{0}%", userName),
State = state
};
return(_provider.GetPage(condition, searchObj, " order by Id ASC", offset, limit));
}
public string GetTelephone(params string[] ids)
{
string condition = new ConditionHelper().And("Id", new { Id = ids }, CompareType.In).ToString();
var searchObj = new { Id = ids };
var list = _provider.GetList(condition, searchObj).ToList();
string result = string.Empty;
list.ForEach(n =>
{
result += $"{n.Name}-{n.Telephone},";
});
if (!string.IsNullOrEmpty(result))
{
result = result.Substring(0, result.Length - 1);
}
return(result);
}
/// <summary>
/// 获取部门地址及状态
/// </summary>
/// <param name="id">父部门Id，空为全部</param>
/// <returns></returns>
public List <OrganModel> GetPosition(int?id)
{
List <OrganModel> items;
if (id == null)
{
items = _provider.GetPosition("", null);
}
else
{
var organs = GetChildren(id.Value).Select(n => n.Id).ToArray();
string condition = new ConditionHelper().And("Id", organs, CompareType.In).ToString();
var searchObj = new { Id = organs };
items = _provider.GetPosition(condition, searchObj);
}
return(items);
}
public PageableData <LogModel> GetPage(int?logType, DateTime?startTime, DateTime?endTime, int limit, int offset)
{
string conditionTimeStr = "";
if (startTime != null)
{
conditionTimeStr += " AND TIME >=@StartTime";
}
if (endTime != null)
{
conditionTimeStr += " AND TIME <=@EndTime";
}
if (conditionTimeStr.Length > 0)
{
conditionTimeStr = conditionTimeStr.Substring(4);
}
//var condition = new ConditionHelper().And("Type", logType, CompareType.Equal)
// .And(conditionTimeStr)
// .ToString();
string condition = string.Empty;
if (logType > -1)
{
condition = new ConditionHelper().And("Type", logType, CompareType.Equal)
.And(conditionTimeStr)
.ToString();
}
condition += new ConditionHelper().And(conditionTimeStr).ToString();
var searchObj = new
{
Type = logType,
StartTime = startTime,
EndTime = endTime
};
return(_provider.GetPage(condition, searchObj, " ORDER BY TIME DESC", offset, limit));
}
public void Del(params int[] ids)
{
string condition = new ConditionHelper().And("Id", new { Id = ids }, CompareType.In).ToString();
_provider.Del(condition, ids);
}
/// <summary>
/// 将总天数划分时间段返回时间节点报警总数的集合
/// </summary>
/// <param name="startTime">起始时间</param>
/// <param name="endTime">终止时间</param>
/// <param name="groupDays">时间组节点天数</param>
/// <param name="totalDays">总天数</param>
/// <returns></returns>
public Dictionary <DateTime, int> GetLogDataForStatistics(DateTime?startTime, DateTime?endTime, int[] alarmIds, int groupDays, int totalDays)
{
#region condition
string conditionIPStr = "";
if (startTime != null)
{
conditionIPStr += " AND LastTime >= @startTime";
}
if (endTime != null)
{
conditionIPStr += " AND LastTime <= @endTime";
}
if (conditionIPStr.Length > 0)
{
conditionIPStr = conditionIPStr.Substring(4);
}
string condition = new ConditionHelper().And(conditionIPStr)
.And("AlarmId", alarmIds, CompareType.In).ToString() + " and state > 0 order by LastTime asc";
var searchObj = new { startTime = startTime, endTime = endTime, AlarmId = alarmIds };
#endregion
List <AlarmModel> list = _provider.GetList(condition, searchObj, "").ToList();
Dictionary <DateTime, int> dicDayCount = new Dictionary <DateTime, int>();
Dictionary <DateTime, int> result = new Dictionary <DateTime, int>();
if (list.Count > 0)
{
int tempCount = 0;
DateTime tempTime = list[0].LastTime.Date;
dicDayCount.Add(tempTime, tempCount);
for (int i = 0; i < list.Count; i++)
{
if (list[i].LastTime.Date == tempTime)
{
dicDayCount[tempTime] += list[i].AlarmCount;
}
else
{
tempTime = list[i].LastTime.Date;
tempCount = list[i].AlarmCount;
dicDayCount.Add(tempTime, tempCount);
}
}
//开始生成节点
for (int i = groupDays; i < totalDays + groupDays; i++)
{
if (i % groupDays == 0)
{
tempTime = startTime.Value.AddDays(i).Date;
tempCount = !dicDayCount.ContainsKey(tempTime) ? 0 : dicDayCount[tempTime];
result.Add(tempTime, tempCount);
}
else
{
result[tempTime] += !dicDayCount.ContainsKey(startTime.Value.AddDays(i).Date) ? 0 : dicDayCount[startTime.Value.AddDays(i).Date];
}
}
}
return(result);
}