在for循环中执行AJAX，防止异步执行失效或卡死

最新推荐文章于 2024-12-25 17:29:37 发布

原创最新推荐文章于 2024-12-25 17:29:37 发布 · 1.4k 阅读

CC 4.0 BY-SA版权

 function Submit() {
        var qidArr = qids.split(',');
        //循环写入数据库
        for (var i = 0; i < qidArr.length; i++) {
            var QID = qidArr[i];
            var Question = $("#labQuestion_" + QID).html();
            var OID = $("input[name='question_" + QID + "']:checked").attr("id");
            var Letters = $("input[name='question_" + QID + "']:checked").val();
            var Options = $("#labOption_" + OID).html();
            RunAjax(QID, Question, OID, Letters, Options);
            if (i == (qidArr.length - 1)) {
                alert("问卷提交成功!谢谢您的参与!");
                window.location.reload();
            }
        }
    }
    function RunAjax(QID, Question, OID, Letters, Options) {
        $.ajax({
            url: "index.aspx/AddSelections",
            type: "POST",
            contentType: "application/json; charset=utf-8",
            async: false,//设置成同步
            dataType: "json",
            data: JSON.stringify({
                QID: QID,
                Question: Question,
                OID: OID,
                Letters: Letters,
                Options: Options
            }),
            success: function (data) {
                //var str = data.d;
            }
        });
    }

    [WebMethod]
    public static void AddSelections(string QID, string Question, string OID, string Letters, string Options)
    {
        //Thread.Sleep(1000);
        try
        {
            string sql = @"INSERT INTO [t_Selections]([GUID],[QID],[Question],[OID],[Letters],[Options],[CreateDate]) VALUES (";
            sql += "'" + guid + "',";
            sql += "'" + QID + "',";
            sql += "'" + Question + "',";
            sql += "'" + OID + "',";
            sql += "'" + Letters + "',";
            sql += "'" + Options + "',";
            sql += "'" + DateTime.Now + "'";
            sql += ");";
            int i = TempRecordDB.ExecuteNonQuery(sql);
        }
        catch { }    
    }

关键是：async: false,//设置成同步