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));
}
