public bool ModifyJxRecord(A15dot1Tab nVal) { using (var db = base.NewDB()) { try { var modifyA15 = db.A15dot1Tab.Where(a => a.Id == nVal.Id).First(); modifyA15.timesNonPlanStop = nVal.timesNonPlanStop; modifyA15.scoreDeductFaultIntensity = nVal.scoreDeductFaultIntensity; modifyA15.rateBigUnitFault = nVal.rateBigUnitFault; modifyA15.rateFaultMaintenance = nVal.rateFaultMaintenance; modifyA15.MTBF = nVal.MTBF; modifyA15.rateEquipUse = nVal.rateEquipUse; modifyA15.rateUrgentRepairWorkHour = nVal.rateUrgentRepairWorkHour; modifyA15.hourWorkOrderFinish = nVal.hourWorkOrderFinish; modifyA15.avgLifeSpanSeal = nVal.avgLifeSpanSeal; modifyA15.avgLifeSpanAxle = nVal.avgLifeSpanAxle; modifyA15.percentEquipAvailability = nVal.percentEquipAvailability; modifyA15.percentPassOnetimeRepair = nVal.percentPassOnetimeRepair; modifyA15.avgEfficiencyPump = nVal.avgEfficiencyPump; modifyA15.avgEfficiencyUnit = nVal.avgEfficiencyUnit; modifyA15.hiddenDangerInvestigation = nVal.hiddenDangerInvestigation; modifyA15.rateLoad = nVal.rateLoad; modifyA15.gyChange = nVal.gyChange; modifyA15.equipChange = nVal.equipChange; modifyA15.otherDescription = nVal.otherDescription; modifyA15.evaluateEquipRunStaeDesc = nVal.evaluateEquipRunStaeDesc; modifyA15.evaluateEquipRunStaeImgPath = nVal.evaluateEquipRunStaeImgPath; modifyA15.reliabilityConclusion = nVal.reliabilityConclusion; modifyA15.jdcAdviseImproveMeasures = nVal.jdcAdviseImproveMeasures; modifyA15.submitDepartment = nVal.submitDepartment; modifyA15.submitUser = nVal.submitUser; modifyA15.submitTime = nVal.submitTime; modifyA15.reportType = nVal.reportType; modifyA15.submitUser = nVal.submitUser; modifyA15.submitTime = nVal.submitTime; modifyA15.state = nVal.state; db.SaveChanges(); return(true); } catch { return(false); } } }
public JsonResult JdcModify_submitsignal(string json1) { JObject item = (JObject)JsonConvert.DeserializeObject(json1); A15dot1Tab new_15dot1 = new A15dot1Tab(); new_15dot1.Id = Convert.ToInt32(item["A15dot1_id"].ToString()); new_15dot1.jdcAdviseImproveMeasures = item["jdcAdviseImproveMeasures"].ToString(); new_15dot1.jdcOperator = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name; new_15dot1.jdcOperateTime = DateTime.Now; new_15dot1.state = Convert.ToInt32(item["state"].ToString()); bool res = Jx.JdcModifyJxItem(new_15dot1); return Json(new { result = res }); }
public bool AddJxRecord(A15dot1Tab nVal) { using (var db = base.NewDB()) { try { db.A15dot1Tab.Add(nVal); db.SaveChanges(); return(true); } catch { return(false); } } }
public bool JdcModifyJxRecord(A15dot1Tab nVal) { using (var db = base.NewDB()) { try { var modifyA15 = db.A15dot1Tab.Where(a => a.Id == nVal.Id).First(); modifyA15.jdcAdviseImproveMeasures = nVal.jdcAdviseImproveMeasures; modifyA15.jdcOperateTime = nVal.jdcOperateTime; modifyA15.jdcOperator = nVal.jdcOperator; modifyA15.state = nVal.state; db.SaveChanges(); return(true); } catch { return(false); } } }
public Index_ModelforA15 getRecord() { Index_ModelforA15 RecordforA15 = new Index_ModelforA15(); //ViewBag.curtime = DateTime.Now.ToString(); int UserId = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id; PersonManagment pm = new PersonManagment(); EquipBLL.AdminManagment.PersonManagment.P_viewModal pv = pm.Get_PersonModal(UserId); RecordforA15.Am=new List<A15dot1Tab>(); if (pv.Role_Names.Contains("可靠性工程师") || pv.Role_Names.Contains("检维修人员")) RecordforA15.isSubmit = 1; else RecordforA15.isSubmit = 0; if (pv.Role_Names.Contains("可靠性工程师")) RecordforA15.kkxgcs = 1; else RecordforA15.kkxgcs = 0; List<string> cjname = new List<string>(); List<Equip_Archi> EA = pm.Get_Person_Cj(UserId); foreach (var ea in EA) { cjname.Add(ea.EA_Name); } List<A15dot1Tab> miss = Jx.GetJxItem(pv.Role_Names,pv.Department_Name,pv.Person_Name); foreach (var item in miss) { A15dot1Tab a = new A15dot1Tab(); a.timesNonPlanStop = item.timesNonPlanStop; a.scoreDeductFaultIntensity = item.scoreDeductFaultIntensity; a.rateBigUnitFault = item.rateBigUnitFault; a.rateFaultMaintenance = item.rateFaultMaintenance; a.MTBF = item.MTBF; a.rateEquipUse = item.rateEquipUse; a.rateUrgentRepairWorkHour = item.rateUrgentRepairWorkHour; a.hourWorkOrderFinish = item.hourWorkOrderFinish; a.avgLifeSpanSeal = item.avgLifeSpanSeal; a.avgLifeSpanAxle = item.avgLifeSpanAxle; a.percentEquipAvailability = item.percentEquipAvailability; a.percentPassOnetimeRepair = item.percentPassOnetimeRepair; a.avgEfficiencyPump = item.avgEfficiencyPump; a.avgEfficiencyUnit = item.avgEfficiencyUnit; a.hiddenDangerInvestigation = item.hiddenDangerInvestigation; a.rateLoad = item.rateLoad; a.gyChange = item.gyChange; a.equipChange = item.equipChange; a.otherDescription = item.otherDescription; a.evaluateEquipRunStaeDesc = item.evaluateEquipRunStaeDesc; a.evaluateEquipRunStaeImgPath = item.evaluateEquipRunStaeImgPath; a.reliabilityConclusion = item.reliabilityConclusion; a.jdcAdviseImproveMeasures = item.jdcAdviseImproveMeasures; a.submitDepartment = item.submitDepartment; a.submitUser = item.submitUser; a.submitTime = item.submitTime; a.jdcOperator = item.jdcOperator; a.jdcOperateTime = item.jdcOperateTime; a.reportType = item.reportType; a.temp1 = Convert.ToString(miss.IndexOf(item) + 1); a.submitUser = item.submitUser; a.submitTime = item.submitTime; a.state = item.state; a.Id = item.Id; RecordforA15.Am.Add(a); } RecordforA15.Hm = new List<A15dot1Tab>(); List<A15dot1Tab> His = Jx.GetHisJxItem(pv.Role_Names, pv.Department_Name, pv.Person_Name); foreach (var item in His) { A15dot1Tab a = new A15dot1Tab(); a.Id = item.Id; a.state = item.state; a.jdcOperateTime = item.jdcOperateTime; a.jdcOperator = item.jdcOperator; a.temp1 = Convert.ToString(His.IndexOf(item) + 1); RecordforA15.Hm.Add(a); } return RecordforA15; }
public JsonResult Modify_submitsignal(string json1) { JObject item = (JObject)JsonConvert.DeserializeObject(json1); A15dot1Tab new_15dot1 = new A15dot1Tab(); new_15dot1.Id = Convert.ToInt32(item["A15dot1_id"].ToString()); new_15dot1.timesNonPlanStop = Convert.ToInt32(item["timesNonPlanStop"].ToString()); new_15dot1.scoreDeductFaultIntensity = Convert.ToInt32(item["scoreDeductFaultIntensity"].ToString()); new_15dot1.rateBigUnitFault = Convert.ToDouble(item["scoreDeductFaultIntensity"].ToString()); new_15dot1.rateFaultMaintenance = Convert.ToDouble(item["rateFaultMaintenance"].ToString()); new_15dot1.MTBF = Convert.ToInt32(item["MTBF"].ToString()); new_15dot1.rateEquipUse = Convert.ToDouble(item["rateEquipUse"].ToString()); if (item["rateUrgentRepairWorkHour"].ToString() != "") { new_15dot1.rateUrgentRepairWorkHour = Convert.ToDouble(item["rateUrgentRepairWorkHour"].ToString()); } else new_15dot1.rateUrgentRepairWorkHour = 0.0; if (item["hourWorkOrderFinish"].ToString() != "") { new_15dot1.hourWorkOrderFinish = Convert.ToDouble(item["hourWorkOrderFinish"].ToString()); } new_15dot1.hourWorkOrderFinish = 0.0; new_15dot1.avgLifeSpanSeal = Convert.ToInt32(item["avgLifeSpanSeal"].ToString()); new_15dot1.avgLifeSpanAxle = Convert.ToInt32(item["avgLifeSpanAxle"].ToString()); new_15dot1.percentEquipAvailability = Convert.ToDouble(item["percentEquipAvailability"].ToString()); new_15dot1.percentPassOnetimeRepair = Convert.ToDouble(item["percentPassOnetimeRepair"].ToString()); if (item["avgEfficiencyPump"].ToString() != "") { new_15dot1.avgEfficiencyPump = Convert.ToDouble(item["avgEfficiencyPump"].ToString()); } new_15dot1.avgEfficiencyPump = 0.0; if (item["avgEfficiencyUnit"].ToString() != "") { new_15dot1.avgEfficiencyUnit = Convert.ToDouble(item["avgEfficiencyUnit"].ToString()); } new_15dot1.avgEfficiencyUnit = 0.0; new_15dot1.Count_timesNonPlanStop = Convert.ToInt32(item["Count_timesNonPlanStop"].ToString()); new_15dot1.Count_scoreDeductFaultIntensity = Convert.ToInt32(item["Count_scoreDeductFaultIntensity"].ToString()); new_15dot1.Count_rateBigUnitFault = Convert.ToInt32(item["Count_rateBigUnitFault"].ToString()); new_15dot1.Count_rateFaultMaintenance = Convert.ToInt32(item["Count_rateFaultMaintenance"].ToString()); new_15dot1.Count_MTBF = Convert.ToInt32(item["Count_MTBF"].ToString()); new_15dot1.Count_rateEquipUse = Convert.ToInt32(item["Count_rateEquipUse"].ToString()); new_15dot1.Count_avgLifeSpanSeal = Convert.ToInt32(item["Count_avgLifeSpanSeal"].ToString()); new_15dot1.Count_avgLifeSpanAxle = Convert.ToInt32(item["Count_avgLifeSpanAxle"].ToString()); new_15dot1.Count_percentEquipAvailability = Convert.ToInt32(item["Count_percentEquipAvailability"].ToString()); new_15dot1.Count_percentPassOnetimeRepair = Convert.ToInt32(item["Count_percentPassOnetimeRepair"].ToString()); new_15dot1.hiddenDangerInvestigation = item["hiddenDangerInvestigation"].ToString(); new_15dot1.rateLoad = item["rateLoad"].ToString(); new_15dot1.gyChange = item["gyChange"].ToString(); new_15dot1.equipChange = item["equipChange"].ToString(); new_15dot1.otherDescription = item["otherDescription"].ToString(); new_15dot1.evaluateEquipRunStaeDesc = item["evaluateEquipRunStaeDesc"].ToString(); new_15dot1.evaluateEquipRunStaeImgPath = item["evaluateEquipRunStaeImgPath"].ToString(); new_15dot1.reliabilityConclusion = item["reliabilityConclusion"].ToString(); new_15dot1.jdcAdviseImproveMeasures = ""; new_15dot1.submitDepartment = item["submitDepartment"].ToString(); new_15dot1.submitUser = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name; new_15dot1.submitTime = DateTime.Now; new_15dot1.state = Convert.ToInt32(item["state"].ToString()); new_15dot1.reportType = item["reportType"].ToString(); bool res = Jx.ModifyJxItem(new_15dot1); return Json(new { result = res }); }
public JsonResult DSSubmit_submitsignal(string json1) { JObject item = (JObject)JsonConvert.DeserializeObject(json1); A15dot1Tab new_15dot1 = new A15dot1Tab(); new_15dot1.timesNonPlanStop = Convert.ToInt32(item["timesNonPlanStop"].ToString()); new_15dot1.scoreDeductFaultIntensity = Convert.ToInt32(item["scoreDeductFaultIntensity"].ToString()); new_15dot1.rateBigUnitFault = Convert.ToDouble(item["scoreDeductFaultIntensity"].ToString()); new_15dot1.rateFaultMaintenance = Convert.ToDouble(item["rateFaultMaintenance"].ToString()); new_15dot1.MTBF = Convert.ToInt32(item["MTBF"].ToString()); new_15dot1.rateEquipUse = Convert.ToDouble(item["rateEquipUse"].ToString()); if (item["rateUrgentRepairWorkHour"].ToString() != "") { new_15dot1.rateUrgentRepairWorkHour = Convert.ToDouble(item["rateUrgentRepairWorkHour"].ToString()); } if (item["hourWorkOrderFinish"].ToString() != "") { new_15dot1.hourWorkOrderFinish = Convert.ToDouble(item["hourWorkOrderFinish"].ToString()); } new_15dot1.avgLifeSpanSeal = Convert.ToInt32(item["avgLifeSpanSeal"].ToString()); new_15dot1.avgLifeSpanAxle = Convert.ToInt32(item["avgLifeSpanAxle"].ToString()); new_15dot1.percentEquipAvailability = Convert.ToDouble(item["percentEquipAvailability"].ToString()); new_15dot1.percentPassOnetimeRepair = Convert.ToDouble(item["percentPassOnetimeRepair"].ToString()); new_15dot1.Count_timesNonPlanStop = Convert.ToInt32(item["Count_timesNonPlanStop"].ToString()); new_15dot1.Count_scoreDeductFaultIntensity = Convert.ToInt32(item["Count_scoreDeductFaultIntensity"].ToString()); new_15dot1.Count_rateBigUnitFault = Convert.ToInt32(item["Count_rateBigUnitFault"].ToString()); new_15dot1.Count_rateFaultMaintenance = Convert.ToInt32(item["Count_rateFaultMaintenance"].ToString()); new_15dot1.Count_MTBF = Convert.ToInt32(item["Count_MTBF"].ToString()); new_15dot1.Count_rateEquipUse = Convert.ToInt32(item["Count_rateEquipUse"].ToString()); new_15dot1.Count_avgLifeSpanSeal = Convert.ToInt32(item["Count_avgLifeSpanSeal"].ToString()); new_15dot1.Count_avgLifeSpanAxle = Convert.ToInt32(item["Count_avgLifeSpanAxle"].ToString()); new_15dot1.Count_percentEquipAvailability = Convert.ToInt32(item["Count_percentEquipAvailability"].ToString()); new_15dot1.Count_percentPassOnetimeRepair = Convert.ToInt32(item["Count_percentPassOnetimeRepair"].ToString()); if (item["avgEfficiencyPump"].ToString() != "") { new_15dot1.avgEfficiencyPump = Convert.ToDouble(item["avgEfficiencyPump"].ToString()); } if (item["avgEfficiencyUnit"].ToString() != "") { new_15dot1.avgEfficiencyUnit = Convert.ToDouble(item["avgEfficiencyUnit"].ToString()); } new_15dot1.hiddenDangerInvestigation = item["hiddenDangerInvestigation"].ToString(); new_15dot1.rateLoad = item["rateLoad"].ToString(); new_15dot1.gyChange = item["gyChange"].ToString(); new_15dot1.equipChange = item["equipChange"].ToString(); new_15dot1.otherDescription = item["otherDescription"].ToString(); new_15dot1.evaluateEquipRunStaeDesc = item["evaluateEquipRunStaeDesc"].ToString(); new_15dot1.evaluateEquipRunStaeImgPath = item["evaluateEquipRunStaeImgPath"].ToString(); new_15dot1.reliabilityConclusion = item["reliabilityConclusion"].ToString(); new_15dot1.jdcAdviseImproveMeasures = ""; new_15dot1.submitDepartment = item["submitDepartment"].ToString(); new_15dot1.submitUser = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name; new_15dot1.submitTime = DateTime.Now; new_15dot1.jdcOperator = ""; //new_15dot1.state = Convert.ToInt32(item["state"].ToString()); new_15dot1.reportType = item["reportType"].ToString(); bool res = Jx.AddJxItem(new_15dot1); string flowname = item["Flow_Name"].ToString(); Dictionary<string, string> signal = new Dictionary<string, string>(); signal["ZzSubmit_done"] = "true"; //record Dictionary<string, string> record = new Dictionary<string, string>(); record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name; record["time"] = DateTime.Now.ToString(); //submit CWFEngine.SubmitSignal(Convert.ToInt32(flowname), signal, record); return Json(new { result = res }); }
public Index_ModelforA15 getRecord_detail(string id) { Index_ModelforA15 RecordforA15 = new Index_ModelforA15(); RecordforA15.Am = new List<A15dot1Tab>(); RecordforA15.Hm = new List<A15dot1Tab>(); ViewBag.curtime = DateTime.Now.ToString(); ViewBag.curuser = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name; int IntId = Convert.ToInt32(id); List<A15dot1Tab> miss = Jx.GetJxItem_detail(IntId); foreach (var item in miss) { A15dot1Tab a = new A15dot1Tab(); a.timesNonPlanStop = item.timesNonPlanStop; a.scoreDeductFaultIntensity = item.scoreDeductFaultIntensity; a.rateBigUnitFault = item.rateBigUnitFault; a.rateFaultMaintenance = item.rateFaultMaintenance; a.MTBF = item.MTBF; a.rateEquipUse = item.rateEquipUse; a.rateUrgentRepairWorkHour = item.rateUrgentRepairWorkHour; a.hourWorkOrderFinish = item.hourWorkOrderFinish; a.avgLifeSpanSeal = item.avgLifeSpanSeal; a.avgLifeSpanAxle = item.avgLifeSpanAxle; a.percentEquipAvailability = item.percentEquipAvailability; a.percentPassOnetimeRepair = item.percentPassOnetimeRepair; a.avgEfficiencyPump = item.avgEfficiencyPump; a.avgEfficiencyUnit = item.avgEfficiencyUnit; a.hiddenDangerInvestigation = item.hiddenDangerInvestigation; a.rateLoad = item.rateLoad; a.gyChange = item.gyChange; a.equipChange = item.equipChange; a.otherDescription = item.otherDescription; a.evaluateEquipRunStaeDesc = item.evaluateEquipRunStaeDesc; a.evaluateEquipRunStaeImgPath = item.evaluateEquipRunStaeImgPath; a.reliabilityConclusion = item.reliabilityConclusion; a.jdcAdviseImproveMeasures = item.jdcAdviseImproveMeasures; a.submitDepartment = item.submitDepartment; a.submitUser = item.submitUser; a.submitTime = item.submitTime; a.jdcOperator = item.jdcOperator; a.jdcOperateTime = item.jdcOperateTime; a.reportType = item.reportType; a.temp1 = Convert.ToString(miss.IndexOf(item) + 1); a.submitUser = item.submitUser; a.submitTime = item.submitTime; a.state = item.state; a.Id = item.Id; //增加变量--参与统计台数 a.Count_timesNonPlanStop = item.Count_timesNonPlanStop; a.Count_scoreDeductFaultIntensity = item.Count_scoreDeductFaultIntensity; a.Count_rateBigUnitFault = item.Count_rateBigUnitFault; a.Count_rateFaultMaintenance = item.Count_rateFaultMaintenance; a.Count_MTBF = item.Count_MTBF; a.Count_rateEquipUse = item.Count_rateEquipUse; a.Count_avgLifeSpanSeal = item.Count_avgLifeSpanSeal; a.Count_avgLifeSpanAxle = item.Count_avgLifeSpanAxle; a.Count_percentEquipAvailability = item.Count_percentEquipAvailability; a.Count_percentPassOnetimeRepair = item.Count_percentPassOnetimeRepair; RecordforA15.Am.Add(a); } string name = RecordforA15.Am[0].submitUser; PersonManagment pm = new PersonManagment(); int UserId = pm.Get_Person(name).Person_Id; EquipBLL.AdminManagment.PersonManagment.P_viewModal pv = pm.Get_PersonModal(UserId); if (pv.Role_Names.Contains("可靠性工程师")) RecordforA15.am = 1; else RecordforA15.am = 0; List<A15dot1Tab> His = Jx.GetHisJxItem_detail(IntId); foreach (var item in His) { A15dot1Tab a = new A15dot1Tab(); a.timesNonPlanStop = item.timesNonPlanStop; a.scoreDeductFaultIntensity = item.scoreDeductFaultIntensity; a.rateBigUnitFault = item.rateBigUnitFault; a.rateFaultMaintenance = item.rateFaultMaintenance; a.MTBF = item.MTBF; a.rateEquipUse = item.rateEquipUse; a.rateUrgentRepairWorkHour = item.rateUrgentRepairWorkHour; a.hourWorkOrderFinish = item.hourWorkOrderFinish; a.avgLifeSpanSeal = item.avgLifeSpanSeal; a.avgLifeSpanAxle = item.avgLifeSpanAxle; a.percentEquipAvailability = item.percentEquipAvailability; a.percentPassOnetimeRepair = item.percentPassOnetimeRepair; a.avgEfficiencyPump = item.avgEfficiencyPump; a.avgEfficiencyUnit = item.avgEfficiencyUnit; a.hiddenDangerInvestigation = item.hiddenDangerInvestigation; a.rateLoad = item.rateLoad; a.gyChange = item.gyChange; a.equipChange = item.equipChange; a.otherDescription = item.otherDescription; a.evaluateEquipRunStaeDesc = item.evaluateEquipRunStaeDesc; a.evaluateEquipRunStaeImgPath = item.evaluateEquipRunStaeImgPath; a.reliabilityConclusion = item.reliabilityConclusion; a.jdcAdviseImproveMeasures = item.jdcAdviseImproveMeasures; a.submitDepartment = item.submitDepartment; a.submitUser = item.submitUser; a.submitTime = item.submitTime; a.jdcOperator = item.jdcOperator; a.jdcOperateTime = item.jdcOperateTime; a.reportType = item.reportType; a.temp1 = Convert.ToString(miss.IndexOf(item) + 1); a.submitUser = item.submitUser; a.submitTime = item.submitTime; a.state = item.state; a.Id = item.Id; //增加变量--参与统计台数 a.Count_timesNonPlanStop = item.Count_timesNonPlanStop; a.Count_scoreDeductFaultIntensity = item.Count_scoreDeductFaultIntensity; a.Count_rateBigUnitFault = item.Count_rateBigUnitFault; a.Count_rateFaultMaintenance = item.Count_rateFaultMaintenance; a.Count_MTBF = item.Count_MTBF; a.Count_rateEquipUse = item.Count_rateEquipUse; a.Count_avgLifeSpanSeal = item.Count_avgLifeSpanSeal; a.Count_avgLifeSpanAxle = item.Count_avgLifeSpanAxle; a.Count_percentEquipAvailability = item.Count_percentEquipAvailability; a.Count_percentPassOnetimeRepair = item.Count_percentPassOnetimeRepair; RecordforA15.Hm.Add(a); } name = RecordforA15.Hm[0].submitUser; UserId = pm.Get_Person(name).Person_Id; pv = pm.Get_PersonModal(UserId); if (pv.Role_Names.Contains("可靠性工程师")) RecordforA15.hm = 1; else RecordforA15.hm = 0; return RecordforA15; }
//时机动处修改 public bool JdcModifyJxItem(A15dot1Tab add) { return(db_Jxpg.JdcModifyJxRecord(add)); }
public bool AddJxItem(A15dot1Tab add) { return(db_Jxpg.AddJxRecord(add)); }