public ActionResult InsertMsg(string Mbno, string SendTime, string Msg)//运维-档案-人员管理-发送短信
{
string result = "";
try
{
if (SendTime.Equals(""))
{
SendTime = DateTime.Now.ToString();
}
if (!Mbno.Equals("") && !Msg.Equals(""))
{
string[] Mlist = Mbno.Split(',');
if (Mlist.Length > 0)
{
for (int i = 0; i < Mlist.Length; i++)
{
UtilsSms.smsContent(Mlist[i], Msg);
}
}
result = "OK";
}
return(Content(result));
}
catch (Exception ex)
{
return(Content(ex.ToString()));
}
}
private void sendAlarm(IDAO.Models.t_AlarmTable_en alarm)
{
int pid = (int)alarm.PID;
//List<t_CM_UserInfo> userList = bll.ExecuteStoreQuery<t_CM_UserInfo>("SELECT * FROM t_CM_UserInfo WHERE (PDRList LIKE '" + pid + ",%' OR PDRList = '%," + pid + "' OR PDRList LIKE '%," + pid + ",%' OR PDRList = '" + pid + "')").ToList();
IList <IDAO.Models.t_CM_Unit> unitlist = UnitDAL.getInstance().GetUnitListByPID(pid);
if (unitlist.Count() > 0)
{
string uids = string.Empty;
foreach (var item in unitlist)
{
uids += item.UnitID + ",";
}
if (!string.IsNullOrEmpty(uids))
{
uids = uids.Substring(0, uids.Length - 1);
IList <IDAO.Models.t_CM_UserInfo> userList = UserInfoDAL.getInstance().GetUsersByUnits(uids);
if (userList == null || userList.Count <= 0)
{
return;
}
for (int i = 0; i < userList.Count; i++)
{
if (userList[i].OpenAlarmMsg == 1)
{
//根据手机号查询该报警是否发过短信；
List <t_Alarm_SMS> sendedList = bll.ExecuteStoreQuery <t_Alarm_SMS>("SELECT * FROM t_Alarm_SMS WHERE mobilephone='" + userList[i].Mobilephone + "' AND alarmId=" + alarm.AlarmID).ToList();
if (sendedList == null || sendedList.Count <= 0)
{
UtilsSms.smsAlarm(userList[i].Mobilephone, alarm);
//INSERT INTO t_Alarm_SMS (alarmTime,alarmId,sendTime,mobilephone) VALUES ('2018-03-20 16:53:11',1522,'2018-03-20 16:53:11','15210091230')
string insert = "INSERT INTO t_Alarm_SMS (alarmTime,alarmId,sendTime,mobilephone) VALUES ('" + alarm.AlarmDateTime + "'," + alarm.AlarmID + ",'" + DateTime.Now.ToString() + "','" + userList[i].Mobilephone + "')";
bll.ExecuteStoreCommand(insert);
}
}
}
}
}
//Debug.WriteLine(DateTime.Now.ToString() + ",alarm.PID=" + alarm.PID);//c#打印输出信息
}
public void SendConTemp(object sender, System.Timers.ElapsedEventArgs e)
{
try
{
var list = bll.t_ES_ContractTemplet.Where(p => p.IsOk == 0).ToList();
foreach (var item in list)
{
//var sss = item.StartTime.Value.Date;
//var ss = DateTime.Now.AddDays(Convert.ToDouble(item.BeforDay)).Date;
if (null != item.StartTime && null != item.AlarmTime)
{
if (
(item.StartTime.Value.Date == DateTime.Now.AddDays(Convert.ToDouble(item.BeforDay)).Date&& item.AlarmTime.Value.Date != DateTime.Now.Date) ||
item.AlarmTime.Value.Date == Convert.ToDateTime("1900-01-01").Date ||
(item.StartTime.Value.Date == DateTime.Now.Date && item.AlarmTime.Value.Date != DateTime.Now.Date)
)
{
t_CM_UserInfo user = bll.t_CM_UserInfo.Where(p => p.UserID == item.PersonID).FirstOrDefault();
if (user != null)
{
item.AlarmTime = DateTime.Now;
bll.ObjectStateManager.ChangeObjectState(item, System.Data.EntityState.Modified);
UtilsSms.smsConTemp(user.Telephone);
}
}
}
}
bll.SaveChanges();
}
catch (Exception ex)
{
string error = ex.ToString();
return;
}
}
public ActionResult SaveOrder_templateList(int CtrOrderId, t_PM_Order order, FormCollection collection)
{
//string content = collection["OrderContent"].ToString();
string result = "OK";
try
{
if (order.OrderID > 0)
{
t_PM_Order orderinfo = bll.t_PM_Order.Where(o => o.OrderID == order.OrderID).First();
orderinfo.OrderContent = Common.ReplaceEnter(order.OrderContent);
orderinfo.OrderNO = order.OrderNO;
orderinfo.PID = order.PID;
orderinfo.PlanDate = order.PlanDate;
orderinfo.CtrPlanDate = order.CtrPlanDate;
orderinfo.PName = order.PName;
orderinfo.Priority = order.Priority;
orderinfo.Remarks = Common.ReplaceEnter(order.Remarks);
orderinfo.UserID = order.UserID;
orderinfo.OrderState = 0;
if (orderinfo.UserName != order.UserName)
{
UtilsSms.smsOrderCancel(orderinfo.UserName, orderinfo.OrderName, bll);
}
orderinfo.UserName = order.UserName;
orderinfo.BugID = order.BugID;
orderinfo.BugInfo = order.BugInfo;
orderinfo.OrderType = order.OrderType;
orderinfo.OrderName = order.OrderName;
orderinfo.DressCodeID = order.DressCodeID;
bll.ObjectStateManager.ChangeObjectState(orderinfo, EntityState.Modified);
bll.SaveChanges();
//发送短信；
UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll);
//
if (orderinfo.sTemplateIDs != order.sTemplateIDs || orderinfo.sTemplateCount != order.sTemplateCount)
{
//delete date
//删除工单
string strsql = "delete from t_PM_Order_Info where OrderID = " + order.OrderID;
int docount = bll.ExecuteStoreCommand(strsql, null);
//
if (!string.IsNullOrEmpty(order.sTemplateIDs) && !string.IsNullOrEmpty(order.sTemplateCount))
{
string[] sTemplateIDsArry = order.sTemplateIDs.Split(',');
string[] sTemplateCountArry = order.sTemplateCount.Split(',');
if (sTemplateIDsArry.Length > 0 && sTemplateIDsArry.Length == sTemplateCountArry.Length)
{
for (int i = 0; i < sTemplateIDsArry.Length; i++)
{
//result = DeleteInfo(int.Parse(sTemplateIDsArry[i].Trim()));
t_PM_Order_Info Order_Info = new t_PM_Order_Info();
Order_Info.orderId = order.OrderID;
Order_Info.templateId = int.Parse((sTemplateIDsArry[i]));
Order_Info.deviceCount = int.Parse((sTemplateCountArry[i]));
Order_Info.unCount = Order_Info.deviceCount;
bll.t_PM_Order_Info.AddObject(Order_Info);
bll.SaveChanges();
}
}
}
}
Common.InsertLog("工单管理", CurrentUser.UserName, "编辑工单信息[" + order.OrderNO + "]");//log
}
else
{
order.OrderState = 0; //0待接收 1已受理 2已完成
order.IsQualified = -1; //-1 未检查 0不合格 1合格
order.CreateDate = DateTime.Now;
order.Creater = CurrentUser.UserName;
order.OrderContent = order.OrderContent.Replace("\n", "<br>");
int iOrderTypeId = 1;
if (order.OrderType.Equals("日常巡检"))
{
iOrderTypeId = 3;
}
if (order.OrderType.Equals("检修试验"))
{
iOrderTypeId = 2;
}
if (order.OrderType.Equals("应急抢修"))
{
iOrderTypeId = 1;
}
order.OrderTypeId = iOrderTypeId;
bll.t_PM_Order.AddObject(order);
bll.SaveChanges();
if (CtrOrderId > 0)
{
t_PM_Order order2 = bll.t_PM_Order.ToList().Last();
updateCstrOrder(CtrOrderId, order2.OrderID);
}
if (!string.IsNullOrEmpty(order.sTemplateIDs) && !string.IsNullOrEmpty(order.sTemplateCount))
{
string[] sTemplateIDsArry = order.sTemplateIDs.Split(',');
string[] sTemplateCountArry = order.sTemplateCount.Split(',');
if (sTemplateIDsArry.Length > 0 && sTemplateIDsArry.Length == sTemplateCountArry.Length)
{
t_PM_Order orderNew = null;
List <t_PM_Order> list = bll.t_PM_Order.Where(o => o.OrderNO == order.OrderNO).ToList();
if (list.Count > 0)
{
orderNew = list[0];
if (orderNew == null)
{
return(Content("添加工单错误！"));
}
for (int i = 0; i < sTemplateIDsArry.Length; i++)
{
//result = DeleteInfo(int.Parse(sTemplateIDsArry[i].Trim()));
t_PM_Order_Info Order_Info = new t_PM_Order_Info();
Order_Info.orderId = orderNew.OrderID;
Order_Info.templateId = int.Parse((sTemplateIDsArry[i]));
Order_Info.deviceCount = int.Parse((sTemplateCountArry[i]));
Order_Info.unCount = Order_Info.deviceCount;
bll.t_PM_Order_Info.AddObject(Order_Info);
bll.SaveChanges();
}
}
}
}
Common.InsertLog("工单管理", CurrentUser.UserName, "新增工单信息[" + order.OrderNO + "]");//log
//发送短信；
UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll);
Console.WriteLine(result);
}
}
catch (Exception ex)
{
result = ex.ToString();
}
return(Content(result));
}
public ActionResult SaveOrder(t_PM_Order order, FormCollection collection)
{
//string content = collection["OrderContent"].ToString();
string result = "OK";
try
{
if (order.OrderID > 0)
{
t_PM_Order orderinfo = bll.t_PM_Order.Where(o => o.OrderID == order.OrderID).First();
orderinfo.OrderContent = Common.ReplaceEnter(order.OrderContent);
orderinfo.OrderNO = order.OrderNO;
orderinfo.PID = order.PID;
orderinfo.PlanDate = order.PlanDate;
orderinfo.PName = order.PName;
orderinfo.Priority = order.Priority;
orderinfo.Remarks = Common.ReplaceEnter(order.Remarks);
orderinfo.UserID = order.UserID;
orderinfo.OrderState = 0;
if (orderinfo.UserName != order.UserName)
{
UtilsSms.smsOrderCancel(orderinfo.UserName, orderinfo.OrderName, bll);
}
orderinfo.UserName = order.UserName;
orderinfo.BugID = order.BugID;
orderinfo.BugInfo = order.BugInfo;
orderinfo.OrderType = order.OrderType;
orderinfo.OrderName = order.OrderName;
orderinfo.DressCodeID = order.DressCodeID;
bll.ObjectStateManager.ChangeObjectState(orderinfo, EntityState.Modified);
bll.SaveChanges();
Common.InsertLog("工单管理", CurrentUser.UserName, "编辑工单信息[" + order.OrderNO + "]");//log
}
else
{
order.OrderState = 0; //0待接收 1已受理 2已完成
order.IsQualified = -1; //-1 未检查 0不合格 1合格
order.CreateDate = DateTime.Now;
order.Creater = CurrentUser.UserName;
order.OrderContent = order.OrderContent.Replace("\n", "<br>");
int iOrderTypeId = 1;
if (order.OrderType.Equals("日常巡检"))
{
iOrderTypeId = 3;
}
if (order.OrderType.Equals("检修试验"))
{
iOrderTypeId = 2;
}
if (order.OrderType.Equals("应急抢修"))
{
iOrderTypeId = 1;
}
order.OrderTypeId = iOrderTypeId;
bll.t_PM_Order.AddObject(order);
bll.SaveChanges();
Common.InsertLog("工单管理", CurrentUser.UserName, "新增工单信息[" + order.OrderNO + "]");//log
}
//发送短信；
UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll);
Console.WriteLine(result);
}
catch (Exception ex)
{
result = ex.ToString();
}
return(Content(result));
}
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("报警确认失败！"));
}
}
