JQuery obtains json data$.getJSON method example code_jquery

Front desk:

Copy code The code is as follows:

 function SelectProject() {
            var a = new Array;
            var r = window.showModalDialog('SelProject.aspx', a, "dialogWidth=1000px; dialogHeight=600px; resizable: yes");
            if (typeof (r) != 'undefined') {
                var arr = r.split(";");
                $("#hidProjectInnerID").val(arr[0]);
                $("#txtProjectNo").val(arr[1]);
                $.getJSON("../Handler/GetProjectInfor.ashx", { key: "PaymentStatement", InnerID: $("#hidProjectInnerID").val() },
                        function (json) {
                            $("#labFinalCustomer").text(json.finalclient);
                            $("#labOrderNo").text(json.orderno);
                            var strDeviceTr = "";
                            $.each(json.workinghours, function (i, item) {
                                strDeviceTr = " " item.description " ";
                                strDeviceTr = "   ";
                                strDeviceTr = " " item.hoursdays "";
                                strDeviceTr = "  0.8";
                                strDeviceTr = " " item.workinghour " ";
                                strDeviceTr = "  0.8";
                                strDeviceTr = " " item.workinghour "";
                                strDeviceTr = "  ";
                                strDeviceTr = "";
                            }; 🎜>

ashx

Copy code

The code is as follows:

 string innerid = CommonClass.Request.GetRequest("InnerID", "");
            string key = CommonClass.Request.GetRequest("key", "");
            string result = "";
            if (key == "StockOutApp" && innerid != "")
            {
                result = StockOutApp(innerid);
                context.Response.Write(result);
            }
            else if (key == "PaymentStatement" && innerid != "")
            {
                result = PaymentStatement(innerid);
                context.Response.Write(result);
            }
#region 结算单信息
        public string PaymentStatement(string _innerid)
        {
            try
            {
                string sql = @"select InnerID,pFinalClient,pOrderNo from se_ProjectMain where InnerID='" _innerid "'";
                DataTable dt = SqlShift.GetDataTable(sql);
                if (!CommonClass.DTRow.CheckDtIsEmpty(dt))
                {
                    StringBuilder json = new StringBuilder();
                     json.Append(""innerid":"" dt.Rows[0]["InnerID"].ToString() """);
                     json.Append(","finalclient":"" dt.Rows[0]["pFinalClient"].ToString() """);
                     json.Append(","orderno":"" dt.Rows[0]["pOrderNo"].ToString() """);
                    json.Append(","workinghours":" GetWorkingHours(_innerid));
                    return "{" json.ToString().Trim(',') "}";
                }
                else
                {
                    return string.Empty;
                }
            }
            catch (Exception ex)
            {
                AppLog.Write("项目获取异常！[异常信息：" ex.Message "]", AppLog.LogMessageType.Info);
                return string.Empty;
            }
        }
        public string GetWorkingHours(string _innerid)
        {
            try
            {
                string sql = @"select InnerID, wDescription,wWorkingHour,wHours_Days from se_ProjectWorkingHour where wProjectID='" _innerid "'";
                DataTable dt = SqlShift.GetDataTable(sql);
                if (!CommonClass.DTRow.CheckDtIsEmpty(dt))
                {
                    StringBuilder json = new StringBuilder();
                    for (int i = 0; i < dt.Rows.Count; i )
                    {
                        json.Append("{");
                        json.Append(""innerid":"" dt.Rows[0]["InnerID"].ToString() """);
                        json.Append(","description":"" dt.Rows[0]["wDescription"].ToString() """);
                        json.Append(","workinghour":"" dt.Rows[0]["wWorkingHour"].ToString() """);
                        json.Append(","hoursdays":"" dt.Rows[0]["wHours_Days"].ToString() """);
                        json.Append("},");
                    }
                    return "[" json.ToString().Trim(',') "]";
                }
                else
                {
                    return string.Empty;
                }
            }
            catch (Exception ex)
            {
                AppLog.Write("项目获取异常！[异常信息：" ex.Message "]", AppLog.LogMessageType.Info);
                return string.Empty;
            }
        }
        #endregion