public ActionResult getMan(int AlarmID)
{
string result = "";
try
{
t_AlarmTable_en alarm = bll.t_AlarmTable_en.Where(p => p.AlarmID == AlarmID).ToList().First();
List <t_CM_Constract> ll = bll.t_CM_Constract.Where(p => p.CtrPid == alarm.PID).ToList();
if (ll == null || ll.Count <= 0)
{
return(Content(result));
}
t_CM_Constract t = ll.First();
string sql = "SELECT * FROM t_CM_UserInfo WHERE UserName='******'";
List <t_CM_UserInfo> listUsers = bll.ExecuteStoreQuery <t_CM_UserInfo>(sql).ToList();
if (listUsers != null | listUsers.Count > 0)
{
return(Content("联系班长：" + listUsers.First().UserName + "." + listUsers.First().Mobilephone));
}
return(Content(listUsers.First().Mobilephone));
}
catch
{
return(Content(result));
}
}
public ActionResult AddBugInfo(int AlarmID)
{
string result = "OK";
try
{
List <t_CM_BugInfo> list = bll.t_CM_BugInfo.Where(p => p.AlarmID == AlarmID).ToList();
if (list.Count > 0)
{
result = "此报警隐患已存在，请重新选择！ ";
}
else
{
t_AlarmTable_en Alarm = bll.t_AlarmTable_en.Where(r => r.AlarmID == AlarmID).First();
t_CM_PDRInfo PDRInfo = bll.t_CM_PDRInfo.Where(r => r.PID == Alarm.PID).First();
t_CM_BugInfo info = new t_CM_BugInfo();
info.PID = Alarm.PID;
info.PName = PDRInfo.Name;
info.DID = Alarm.DID;
if (Alarm.DID > 0)
{
t_DM_DeviceInfo DeviceInfo = bll.t_DM_DeviceInfo.Where(r => r.DID == Alarm.DID).First();
info.DeviceName = DeviceInfo.DeviceName;
}
info.ReportWay = "在线监测";
if (Alarm.ALarmType == "关注")
{
info.BugLevel = "一般";
}
else if (Alarm.ALarmType == "预警")
{
info.BugLevel = "重大";
}
else
{
info.BugLevel = "紧急";
}
info.BugLocation = Alarm.AlarmArea;
info.BugDesc = Alarm.ALarmType + "：" + Alarm.AlarmCate + "" + PDRInfo.Name + Alarm.AlarmAddress + Alarm.Company + "：" + Alarm.AlarmValue + "，限值" + Alarm.AlarmMaxValue + "，" + Convert.ToDateTime(Alarm.AlarmDateTime).ToString("yyyy-MM-dd HH:mm:ss");
info.AlarmID = AlarmID;
info.ReportDate = DateTime.Now;
info.HandeSituation = "未审核";
info.ReportUser = CurrentUser.UserName;
bll.t_CM_BugInfo.AddObject(info);
bll.SaveChanges();
Common.InsertLog("隐患管理", CurrentUser.UserName, "报警新增隐患信息[" + AlarmID + "]");
result = "OKadd";
}
}
catch (Exception ex)
{
result = ex.ToString();
result = "出错了！";
}
return(Content(result));
}
public AlarmBean(t_AlarmTable_en t_AlarmTable_en)
{
// TODO: Complete member initialization
this.t_AlarmTable_en = t_AlarmTable_en;
if (t_AlarmTable_en.AlarmCate == "开关量")
{
if (t_AlarmTable_en.AlarmArea == "水浸")
{
AlarmValue = t_AlarmTable_en.AlarmValue == 0 ? "正常" : "浸水";
}
else
{
AlarmValue = t_AlarmTable_en.AlarmValue == 0 ? "分闸" : "合闸";
}
}
else
{
AlarmValue = t_AlarmTable_en.AlarmValue + "";
}
}
public ActionResult DelAlarmById(int AlarmID, string AlarmTreatment)
{
try
{
string PDRList = HomeController.GetPID(CurrentUser.UNITList);
//string PDRList = CurrentUser.PDRList;
if (!PDRList.Equals(""))
{
string sSql = "update [t_AlarmTable_en] set AlarmState = 0,AlarmTreatment = '" + AlarmTreatment + "',AlarmConfirm='已确认',UserName='******',ConfirmDate='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' where PID in (" + PDRList + ") and AlarmConfirm='未确认' and AlarmState>0 and AlarmID=" + AlarmID;
bll.ExecuteStoreCommand(sSql);
if (AlarmTreatment != null && AlarmTreatment.Contains("真实"))//添加隐患，并且下发工单；
{
List <t_AlarmTable_en> list = bll.t_AlarmTable_en.Where(p => p.AlarmID == AlarmID).ToList();
if (list != null && list.Count > 0)
{
try
{
t_AlarmTable_en alarm = list.First();
t_PM_Order order = new t_PM_Order();
order.PID = alarm.PID;
t_CM_PDRInfo pdrinfo = bll.t_CM_PDRInfo.Where(p => p.PID == alarm.PID).ToList().First();
order.PName = pdrinfo.Name;
try
{
string c = pdrinfo.Coordination;
string[] xx = c.Split('|');
order.Latitude = decimal.Parse(xx[1]);
order.Longtitude = decimal.Parse(xx[0]);
}
catch
{
}
order.OrderName = order.PName + "应急抢修" + DateTime.Now;
List <t_CM_Constract> ll = bll.t_CM_Constract.Where(p => p.CtrPid == alarm.PID).ToList();
if (ll == null || ll.Count <= 0)
{
return(Content("报警已确认！\n未找到合同中的负责人！\n自动下发工单失败，请手工处理！"));
}
t_CM_Constract t = ll.First();
string sql = "SELECT * FROM t_CM_UserInfo WHERE UserName='******'";
List <t_CM_UserInfo> listUsers = bll.ExecuteStoreQuery <t_CM_UserInfo>(sql).ToList();
if (listUsers == null | listUsers.Count <= 0)
{
return(Content("报警已确认！\n未找到工单需要下发的人员！\n自动下发工单失败，请手工处理！"));
}
order.UserName = t.person;//根据pid，类型查找合同，到名字；
order.PlanDate = DateTime.Now;
order.UserID = listUsers.First().UserID;
order.Priority = 1;
order.OrderNO = DateTime.Now.Ticks + "";
order.OrderType = "应急抢修";
order.DressCodeID = 2;
order.OrderState = 0; //0待接收 1已受理 2已完成
order.IsQualified = -1; //-1 未检查 0不合格 1合格
order.CreateDate = DateTime.Now;
order.Creater = CurrentUser.UserName;
order.OrderTypeId = 3;
order.OrderContent = "报警内容：" + alarm.ALarmType + ";" + alarm.AlarmDateTime + ";" + alarm.AlarmCate + ";" + ValueReset((double)alarm.AlarmValue, alarm.AlarmCate) + ";" + alarm.AlarmAddress + ";" + alarm.AlarmArea + ";" + alarm.Company + "。已确认为真实故障，请立即检修。";
bll.t_PM_Order.AddObject(order);
bll.SaveChanges();
//发送短信；
Result a = UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll);
AddBugInfo(AlarmID);
return(Content("报警已确认！" + "\n\n" + parserContent(a)));
}
catch (Exception ex)
{
string error = ex.ToString();
return(Content("报警已确认！\n自动下发工单失败，请手工处理！"));
}
}
}
return(Content("报警已确认！"));
}
else
{
return(Content("没有权限，报警未确认！"));
}
}
catch (Exception ex)
{
string error = ex.ToString();
return(Content("报警确认失败！"));
}
}
