public bool Add(AlarmInfo alarmInfo, out string strResult)
{
strResult = string.Empty;
bool result = false;
var al = AlarmInfoRepository.GetQueryable().FirstOrDefault(a => a.AlarmCode == alarmInfo.AlarmCode);
if (al == null)
{
AlarmInfo alarm = new AlarmInfo();
try
{
alarm.AlarmCode = alarmInfo.AlarmCode;
alarm.Description = alarmInfo.Description;
AlarmInfoRepository.Add(alarm);
AlarmInfoRepository.SaveChanges();
result = true;
}
catch (Exception e)
{
strResult = "原因：" + e.Message;
}
}
else
{
strResult = "原因：报警编码已存在";
}
return(result);
}
private void buttonX_Save_Click(object sender, EventArgs e)
{
try
{
AlarmInfoRepository repo = new AlarmInfoRepository();
AlarmInfo newAlarmInfo = new AlarmInfo();
newAlarmInfo.AlarmID = DateTime.Now.Ticks.ToString();
newAlarmInfo.AlarmTime = dateTimeInput_Time.Value;
newAlarmInfo.AlarmLocation = textBoxX_AlarmLocation.Text;
newAlarmInfo.AlarmType = (int)comboBoxEx_AlarmType.SelectedIndex;
newAlarmInfo.TargetAttribute = (int)comboBoxEx_TargetAttribute.SelectedIndex;
newAlarmInfo.Description = textBoxX_Description.Text;
repo.Insert(newAlarmInfo);
string sendMsg = "PostAlarmInfo " + JsonConvert.SerializeObject(newAlarmInfo) + "\r\n";
IMCommunicate.SendMsgToServer(sendMsg);
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void buttonX_Del_Click(object sender, EventArgs e)
{
if (dataGridView_AlarmInfo.SelectedRows.Count <= 0)
{
MessageBox.Show("请先选中一行数据");
return;
}
var row = dataGridView_AlarmInfo.SelectedRows[0];
long ID = (long)(row.Cells[0].Value);
var AlarmInfo = alarmInfoList.Find(_ => _.ID == ID);
if (AlarmInfo == null)
{
MessageBox.Show("数据错误");
return;
}
try
{
AlarmInfoRepository repo = new AlarmInfoRepository();
repo.Delete(ID);
RefreshAlarmInfo();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public System.Data.DataTable GetAlarmInfo(int page, int rows, AlarmInfo alarmInfo)
{
IQueryable <AlarmInfo> alarmInfoQuery = AlarmInfoRepository.GetQueryable();
var alarmInfoDetail = alarmInfoQuery.Where(a =>
a.AlarmCode.Contains(alarmInfo.AlarmCode) &&
a.Description.Contains(alarmInfo.Description))
.OrderBy(a => a.AlarmCode);
var alarmInfo_Detail = alarmInfoDetail.ToArray().Select(a => new
{
a.AlarmCode,
a.Description
});
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("报警编码", typeof(string));
dt.Columns.Add("描述", typeof(string));
foreach (var s in alarmInfo_Detail)
{
dt.Rows.Add
(
s.AlarmCode,
s.Description
);
}
return(dt);
}
/// <summary>
/// 物理删除报警信息
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public async Task <OperationResult> Delete(params Guid[] ids)
{
ids.CheckNotNull("ids");
AlarmInfoRepository.UnitOfWork.BeginTransaction();
var result = await AlarmInfoRepository.DeleteAsync(ids);
AlarmInfoRepository.UnitOfWork.Commit();
return(result);
}
/// <summary>
/// 更新报警信息
/// </summary>
/// <param name="inputDtos"></param>
/// <returns></returns>
public async Task <OperationResult> Update(params AlarmInfoInputDto[] inputDtos)
{
inputDtos.CheckNotNull("inputDtos");
AlarmInfoRepository.UnitOfWork.BeginTransaction();
var result = await AlarmInfoRepository.UpdateAsync(inputDtos);
AlarmInfoRepository.UnitOfWork.Commit();
return(result);
}
public object GetDetails(int page, int rows, AlarmInfo alarmInfo)
{
IQueryable <AlarmInfo> alarmInfoQuery = AlarmInfoRepository.GetQueryable();
var alarmInfos = alarmInfoQuery
.Where(a => a.AlarmCode.Contains(alarmInfo.AlarmCode) && a.Description.Contains(alarmInfo.Description))
.OrderBy(a => a.AlarmCode);
int total = alarmInfos.Count();
var alarmInfoRow = alarmInfos.Skip((page - 1) * rows).Take(rows);
var alarmInfoSelect = alarmInfoRow.ToArray().Select(a => new
{
a.AlarmCode,
a.Description
});
return(new { total, rows = alarmInfoSelect.ToArray() });
}
private void buttonX_Search_Click(object sender, EventArgs e)
{
StringBuilder searchCondition = new StringBuilder(" where 1=1");
if (!dateTimeInput_TimeStart.IsEmpty)
{
searchCondition.Append(" and AlarmTime>@TimeStart");
}
if (!dateTimeInput_TimeEnd.IsEmpty)
{
searchCondition.Append(" and AlarmTime<@TimeEnd");
}
if (!string.IsNullOrWhiteSpace(comboBoxEx_AlarmType.Text))
{
searchCondition.Append(" and AlarmType=@AlarmType");
}
if (!string.IsNullOrWhiteSpace(comboBoxEx_TargetAttribute.Text))
{
searchCondition.Append(" and TargetAttribute=@TargetAttribute");
}
AlarmInfoRepository repo = new AlarmInfoRepository();
alarmInfoList = repo.GetListWithCondition(searchCondition.ToString(), new
{
TimeStart = dateTimeInput_TimeStart.Value,
TimeEnd = dateTimeInput_TimeEnd.Value,
AlarmType = comboBoxEx_AlarmType.SelectedIndex,
TargetAttribute = comboBoxEx_TargetAttribute.SelectedIndex
});
dataGridView_AlarmInfo.DataSource = alarmInfoList.Select(_ =>
{
return(new
{
_.ID,
_.AlarmID,
_.AlarmLocation,
_.AlarmTime,
AlarmType = Enum.Parse(typeof(AlarmType), _.AlarmType.ToString()).ToString(),
TargetAttribute = Enum.Parse(typeof(TargetAttribute), _.TargetAttribute.ToString()).ToString(),
_.Description,
_.Mark
});
}).ToList();
}
public bool Delete(string code, out string strResult)
{
strResult = string.Empty;
bool result = false;
var alarmInfo = AlarmInfoRepository.GetQueryable().FirstOrDefault(a => a.AlarmCode == code);
if (alarmInfo != null)
{
AlarmInfoRepository.Delete(alarmInfo);
AlarmInfoRepository.SaveChanges();
result = true;
}
else
{
strResult = "原因：没有找到相应数据";
}
return(result);
}
public bool Save(AlarmInfo alarmInfo, out string strResult)
{
strResult = string.Empty;
bool result = false;
var alarmInfos = AlarmInfoRepository.GetQueryable().FirstOrDefault(s => s.AlarmCode == alarmInfo.AlarmCode);
if (alarmInfos != null)
{
alarmInfos.Description = alarmInfo.Description;
AlarmInfoRepository.SaveChanges();
result = true;
}
else
{
strResult = "原因：找不到相应数据";
}
return(result);
}
private void RefreshAlarmInfo()
{
AlarmInfoRepository repo = new AlarmInfoRepository();
alarmInfoList = repo.GetList();
dataGridView_AlarmInfo.DataSource = alarmInfoList.Select(_ =>
{
return(new
{
_.ID,
_.AlarmID,
_.AlarmLocation,
_.AlarmTime,
AlarmType = Enum.Parse(typeof(AlarmType), _.AlarmType.ToString()).ToString(),
TargetAttribute = Enum.Parse(typeof(TargetAttribute), _.TargetAttribute.ToString()).ToString(),
_.Description,
_.Mark
});
}).ToList();
}
/// <summary>
/// 检查实体是否存在
/// </summary>
/// <param name="predicate"></param>
/// <param name="id"></param>
/// <returns></returns>
public bool CheckAlarmInfoExists(Expression <Func <AlarmInfo, bool> > predicate, Guid id)
{
return(AlarmInfoRepository.CheckExists(predicate, id));
}
