public JsonResult GetData() { string myurl = url + "api/v1/configuration/andon/work_order_alert_detail"; var machineList = CommonHelper <work_order_alertDto> .Get(myurl, HttpContext); var purl = url + "api/v1/configuration/public/tag_extra"; var tag_info_extraList = CommonHelper <tag_info_extra> .Get(purl, HttpContext); List <object> list = new List <object>(); foreach (var obj in machineList) { tag_info_extra tag_info = new tag_info_extra(); if (obj.alert_type == 0) { tag_info = tag_info_extraList .Where(x => x.target_type == 2 && x.target_id == obj.virtual_line_id && x.tag_type_sub_id == 19) .FirstOrDefault(); } else if (obj.alert_type == 1) { tag_info = tag_info_extraList .Where(x => x.target_type == 2 && x.target_id == obj.virtual_line_id && x.tag_type_sub_id == 20) .FirstOrDefault(); } else if (obj.alert_type == 2) { tag_info = tag_info_extraList .Where(x => x.target_type == 2 && x.target_id == obj.virtual_line_id && x.tag_type_sub_id == 21) .FirstOrDefault(); } else if (obj.alert_type == 3) { tag_info = tag_info_extraList .Where(x => x.target_type == 2 && x.target_id == obj.virtual_line_id && x.tag_type_sub_id == 22) .FirstOrDefault(); } object ob = new { obj.id, obj.virtual_line_id, obj.alert_type, obj.minimum, obj.maximum, obj.notice_group_id, obj.notice_type, obj.enable, obj.virtual_line.name_cn, nname = obj.notice_group.name_cn, tag_info?.name, tag_info?.description, extraid = tag_info?.id, tag_info?.tag_type_sub_id }; list.Add(ob); } return(Json(list)); }
//Tag点修改/新增 public IActionResult UpdateTagInfo(tag_info_extra tag_Info) { tag_Info.tag_type_sub_id = 13; tag_Info.target_type = 0; string tagInfoUrl = url + "api/v1/configuration/public/tag_extra"; int id = tag_Info.id; //新增 if (id == 0) { //string tagInfoPostData = "{{" + // "\"id\":{0}," + // "\"description\":\"{1}\"," + // "\"tag_type_sub_id\":{2}," + // "\"target_id\":{3}," + // "\"name\":\"{4}\"," + // "\"target_type\":{5}," + // "}}"; //tagInfoPostData = string.Format(tagInfoPostData, id, tag_Info.description, tag_Info.tag_type_sub_id, tag_Info.target_id, tag_Info.name, 0); var tagInfoPostData = JsonConvert.SerializeObject(tag_Info); string tagInfoPostResult = PostUrl(tagInfoUrl, tagInfoPostData); JObject joMachinePost = (JObject)JsonConvert.DeserializeObject(tagInfoPostResult); if (Convert.ToInt32(joMachinePost["code"]) == 200) { return(Json("Success")); } else { return(Json("Fail")); } } else {//修改 //string tagInfoPutData = "{{" + // "\"id\":{0}," + // "\"description\":\"{1}\"," + // "\"tag_type_sub_id\":{2}," + // "\"target_id\":{3}," + // "\"name\":\"{4}\"," + // "\"target_type\":{5}," + // "}}"; //tagInfoPutData = string.Format(tagInfoPutData, id, tag_Info.description, tag_Info.tag_type_sub_id, tag_Info.target_id, tag_Info.name, 0); var tagInfoPutData = JsonConvert.SerializeObject(tag_Info); //string tagInfoPostResult = PostUrl(tagInfoUrl, tagInfoPostData); string tagInfoPutResult = PutUrl(tagInfoUrl, tagInfoPutData); JObject joMachinePut = (JObject)JsonConvert.DeserializeObject(tagInfoPutResult); if (Convert.ToInt32(joMachinePut["code"]) == 200) { return(Json("Success")); } else { return(Json("Fail")); } } }
//Tag点修改/新增 public IActionResult UpdateTagInfo(tag_info_extra tag_Info) { if (tag_Info.utilization_rate_types == 0) { tag_Info.tag_type_sub_id = 19; } else if (tag_Info.utilization_rate_types == 1) { tag_Info.tag_type_sub_id = 20; } else if (tag_Info.utilization_rate_types == 2) { tag_Info.tag_type_sub_id = 21; } else if (tag_Info.utilization_rate_types == 3) { tag_Info.tag_type_sub_id = 22; } tag_Info.target_type = 2; string tagInfoUrl = url + "api/v1/configuration/public/tag_extra"; int id = tag_Info.id; //新增 if (id == 0) { var tagInfoPostData = JsonConvert.SerializeObject(tag_Info); string tagInfoPostResult = PostUrl(tagInfoUrl, tagInfoPostData); JObject joMachinePost = (JObject)JsonConvert.DeserializeObject(tagInfoPostResult); if (Convert.ToInt32(joMachinePost["code"]) == 200) { return(Json("Success")); } else { return(Json("Fail")); } } else {//修改 var tagInfoPostData = JsonConvert.SerializeObject(tag_Info); string tagInfoPutResult = PutUrl(tagInfoUrl, tagInfoPostData); JObject joMachinePut = (JObject)JsonConvert.DeserializeObject(tagInfoPutResult); if (Convert.ToInt32(joMachinePut["code"]) == 200) { return(Json("Success")); } else { return(Json("Fail")); } } }
public JsonResult GetData() { string geturl = url + "api/v1/configuration/andon/capacity_alert_detail"; var machineList = CommonHelper <capacity_alertDto> .Get(geturl, HttpContext); var purl = url + "api/v1/configuration/public/tag_extra"; var tag_info_extraList = CommonHelper <tag_info_extra> .Get(purl, HttpContext); //var nurl = url + "api/v1/configuration/public/area_node"; //var nresult = GetUrl(nurl); //JObject njo = (JObject)JsonConvert.DeserializeObject(nresult); //var nodeList = njo["data"].ToObject<IList<Model.area_node>>(); //var datAreaNode = (from p in nodeList // orderby p.id // select new { p.id, p.name_cn, p.name_en, p.name_tw, p.description,p.upper_id ,p.area_layer_id }).ToList(); //var dat = // from p in // machineList // join // y in tag_info_extraList.Where(n => n.tag_type_sub_id == 23 && n.target_type == 1) // on p.capacity equals y.target_id///????有问题的 // into g // from o in g.DefaultIfEmpty() // select new // { // p.id, // p.date, // p.capacity, // p.notice_group_id, // p.notice_type, // p.enable, // nname = p.notice_group.name_cn, // o?.name,//o!=null?o.name:null // o?.description, // extraid = o?.id // }; List <object> list = new List <object>(); tag_info_extra o = new tag_info_extra(); o = tag_info_extraList .Where(x => x.target_type == 1 && x.target_id == 0 && x.tag_type_sub_id == 23) .FirstOrDefault(); foreach (var p in machineList) { object ob = new { p.id, p.date, p.capacity, p.notice_group_id, p.notice_type, p.enable, nname = p.notice_group.name_cn, o?.name,//o!=null?o.name:null o?.description, extraid = o?.id }; list.Add(ob); } return(Json(list)); }