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 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 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("报警确认失败!")); } }