C# 接口调用并解析json字符串

1.Post方式接收json格式并查找相应带list的数据返回

/// <summary>
        /// 调用Lot卡打印接口 
        /// </summary>
        /// <param name="project"></param>
        /// <returns></returns>
        /// {"PN":"W**CS56DM7-00","cuPNList":[{"cuPN":"900000000047578"},{"cuPN":"900000000047579"},{"cuPN":"900000000047577"},{"cuPN":"9A4000000009443"}]}
        [HttpPost]
        [Route("api/GetLotCardMIMAFInfo")]
        public HttpResponseMessage GetLotCardMIMAFInfo()
        {
            var data = Request.Content.ReadAsStringAsync().Result; 
            var PNlist = "";
            JObject jsonObj = JObject.Parse(data);
            string PNno = jsonObj["PN"].ToString();

            JArray jsonAry = JArray.Parse(jsonObj["cuPNList"].ToString());
            JObject stu1Obj = JObject.Parse(jsonAry[0].ToString());
            string cuPN = stu1Obj["cuPN"].ToString();
            foreach (var ss in jsonAry)  //查找某个字段与值
            {
                PNlist = PNlist + ss["cuPN"].ToString() + ","; // ((JObject)ss)["cuPN"];  // JObject.Parse(jsonAry[0].ToString());
            } 
            JsonData jd = new JsonData(); 
            DataTable dt = checkInplanservice.GettLotCardInfoTable(PNno);
            DataTable dtMAF = checkInplanservice.GettLotCardMAFInfoTable(PNlist);
            //OBJ转化成JSON
            jd.Status = HandleStatus.Success;
            if (dt.Rows.Count == 0)
            {
                jd.Status = HandleStatus.Fail;
                jd.Msg = "无数据";
            }
            else
            {
                jd.Data = new
                {
                    cuLayerType = dt.Rows[0]["LayerLevel"],
                    cuCustomer = dt.Rows[0]["MiCustPn"],
                    cuCustomerName = dt.Rows[0]["MiCustName"],
                    cuQRCustomerPN = "",
                    cuQRCustomerPNVersion = "",
                    cuPNLOrigin = dt.Rows[0]["lvdr"],
                    cuSize = dt.Rows[0]["Value"],
                    cuCurrSize = dt.Rows[0]["MiSetArea"],
                    cuHSFRequirement = dt.Rows[0]["AttrCode"],
                    cuFinalThickness = dt.Rows[0]["cuFinalThickness"],
                    cuPNList = dtMAF 
                };
            }
            string msgAll = JsonConvert.SerializeObject(jd);
            return JsonResult(msgAll); 
        }

        public HttpResponseMessage JsonResult(string msg)
        {
            HttpResponseMessage result = new HttpResponseMessage();
            result.Content = new StringContent(msg,
                Encoding.GetEncoding("UTF-8"), "application/json");
            return result;
        }

        public HttpResponseMessage JsonResult(object obj)
        {
            HttpResponseMessage result = new HttpResponseMessage();
            result.Content = new StringContent(JsonConvert.SerializeObject(obj),
                Encoding.GetEncoding("UTF-8"), "application/json");
            return result;
        }

  2.外部调用接口并更新数据

//      /// <summary>
        ///  更改设备OnHold状态
        /// </summary>
        /// <returns></returns>
        /// {"OS":"create","mcnrs":[{"oano":"abc123","equipid":"A10001"},{"oano":"abc123","equipid":"A10002"}]}
        [HttpPost]
        public ActionResult MEEequipOHStatus()  //HttpResponseMessage
        {
            Logger.Error(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "--" + "update");
            ArrayList mess = new ArrayList();
            BaseManager bm = new BaseManager();
            OperationResult result = new OperationResult();
            try
            {
                var request = System.Web.HttpContext.Current.Request;
                byte[] requestData = new byte[request.InputStream.Length];
                request.InputStream.Read(requestData, 0, (int)request.InputStream.Length); 
                var jsonData = Encoding.UTF8.GetString(requestData);
                JObject jsonObj = JObject.Parse(jsonData);
                string OS = jsonObj["OS"].ToString();
                JArray jsonAry = JArray.Parse(jsonObj["mcnrs"].ToString());
                var msg = "";
                if (OS.ToLower() != "create")
                {
                    foreach (var ss in jsonAry)  //查找某个字段与值
                    {
                        string sql = string.Format(@"update [t_EquipOAOH] set [Stauts] = 'UP',Updatedate='" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where Oano = '" + ss["oano"].ToString() + "'");
                        bm.ExecuteCommand(sql);
                        msg += "EquipOAOH:" + ss["oano"].ToString() + " complete sucess;";
                        Logger.Error(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "--" + "complete:" + msg + "");
                    }
                }
                else
                {
                    foreach (var ss in jsonAry)  //查找某个字段与值
                    {
                        string sql = string.Format(@"insert into t_EquipOAOH ([Oano],[EquipID] ,[Stauts] ) values ( '" + ss["oano"].ToString() + "','" + ss["equipid"].ToString() + "','OH')");
                        bm.ExecuteCommand(sql);
                        msg += "EquipOAOH:" + ss["equipid"].ToString() + " insert sucess;";
                        Logger.Error(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "--" + "Success:" + msg + "");
                    }
                }
                result.Data = msg;
            }
            catch (Exception e)
            {
                result.Errors.Add("Error:" + e.Message);
            }
            return Json(result); 
        }

  

 

posted @ 2022-02-26 11:20  德平Zeng  阅读(753)  评论(0编辑  收藏  举报