//功能:根据查询信息查询设备 //参数:设备工艺编号,设备位置,设备专业分类 //返回:数据拼接string public string Query_Equip(string equip_gycode, int equiparchi_id, string equip_specialty)//string json1)//,) { List <object> r = new List <object>(); List <Equip_Info> e = new List <Equip_Info>(); if (equip_gycode != "" || equiparchi_id != 0 || equip_specialty != "") { EquipManagment EM = new EquipManagment(); e = EM.getAllEquips_byinfo(equip_gycode, equiparchi_id, equip_specialty); for (var i = 0; i < e.Count; i++) { //数据库中可能为空这些数据做些处理在赋值给o string ecode; string manuf; if (e[i].Equip_Code == null) { ecode = "无"; } else { ecode = e[i].Equip_Code; } if (e[i].Equip_Manufacturer == null) { manuf = "无"; } else { manuf = e[i].Equip_Manufacturer; } //返回前台显示的数据 object o = new { index = i + 1, equip_gycode = e[i].Equip_GyCode.ToString(), equip_code = ecode, equip_specialty = e[i].Equip_Specialty.ToString(), equip_phaseB = e[i].Equip_PhaseB.ToString(), equip_manufacturer = manuf }; r.Add(o); } } string str = JsonConvert.SerializeObject(r); return("{" + "\"data\": " + str + "}"); }