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,//设置成同步