通过休息POST将参数从jquery传递到asp.net [英] passing parameters from jquery to asp.net thru rest POST

查看:74
本文介绍了通过休息POST将参数从jquery传递到asp.net的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好我需要一些帮助:(



i有这个拖放数据列表和两个文本框。

首先我会填写在两个文本框中,然后将一个项目拖到我的

Hello guys i need some help here :(

i have this drag and drop datalist and two textbox.
first i will fill in the two textbox, then drag a item into my

中,当我点击一个按钮时,它应该能够通过jquery.ajax调用我的休息服务。将数据发布到我的数据库中。

好吧我的问题是

1.当我放弃时,我可以传递多个值吗?(例如,当我丢弃时,我应该能够检索项目的ID,名称和类别)



2.我不确定我的webInvoke POST是否正常工作,当我测试它时,它表示该方法无效/未找到端点。但是我可以通过我的wcf测试人员创建/发布。



请帮助我,非常感谢!!



我的jquery



$(#Button1)。click(function(){

var data1 = new Array( );



});



$ .ajax({

类型:'POST',

url:'http:// localhost:1990 / Service1.svc / InsertPlan?PlanDate = {0 }& Category = {0}& FoodName = {0}& TCalories = {0}& FoodFk = {0}& EmailFK = {0}',

contentType:application / JSON; charset = utf-8,

数据:'{food:['+'calories:['+'name:['+

data.join()+ ']]]}',

dataType:'json',

成功:功能(结果){alert(results.d);},

错误:function(){alert('error');}

});

});



$(div .block)。each(function(){

this.addEventListener('dragstart',OnDragStart,false);

} ); $



$(div .drop)。each(function(){

this.addEventListener('dragenter',OnDragEnter) ,false);

this.addEventListener('dragleave',OnDragLeave,false);

this.addEventListener('dragover',OnDragOver,false);

this.addEventListener('drop ',OnDrop,false);

this.addEventListener('dragend',OnDragEnd,false);

});



});



// on drop

, when i click a button, it should be able to call my rest service via jquery.ajax. to post the data into my database.
okay my question is
1.how can i pass in multiple value when i dropped? (eg. when i dropped, i should be able to retrieve the id , name and category of the item)

2. i'm not sure if my webInvoke POST is working, cos when i test it out, it states that the method is not working / endpoint not found. However i am able to create/post through my wcf test cient.

Pls help me up, Thanks alot!!

my jquery

$("#Button1").click(function () {
var data1 = new Array();

});

$.ajax({
type: 'POST',
url: 'http://localhost:1990/Service1.svc/InsertPlan?PlanDate={0}&Category={0}&FoodName={0}&TCalories={0}&FoodFk={0}&EmailFK={0}',
contentType: "application/json; charset=utf-8",
data: '{ food:[' + 'calories:[' + 'name:[' +
data.join() + ']]]}',
dataType: 'json',
success: function (results) { alert(results.d); },
error: function () { alert('error'); }
});
});

$("div .block").each(function () {
this.addEventListener('dragstart', OnDragStart, false);
});

$("div .drop").each(function () {
this.addEventListener('dragenter', OnDragEnter, false);
this.addEventListener('dragleave', OnDragLeave, false);
this.addEventListener('dragover', OnDragOver, false);
this.addEventListener('drop', OnDrop, false);
this.addEventListener('dragend', OnDragEnd, false);
});

});

//on drop
function OnDrop(e) {
           if (e.preventDefault) {
               e.preventDefault();
           }
           srcElement.style.opacity = '1';
           $(this).removeClass('highlight');
           var count = $(this).find("div[data-food-name='" + e.dataTransfer.getData('text/html') + "']").length;

           $(this).append("<div class='selectedfood' data-food-name='" + e.dataTransfer.getData('text/html') + "'>" + e.dataTransfer.getData('text/html') + "</div>");
           alert(data)
       }

       function OnDragEnd(e) {
           $("div .drop").removeClass('highlight');
           this.style.opacity = '1';
       }









my service.svc



public bool InsertPlan(string Date,string Category,string food,string calories,string foodfk,string email)

{



string connstring = ConfigurationManager.ConnectionStrings [DBConnectionString]。ToString();



string queryStr =INSERT INTO [计划](PlanDate,Category,FoodName,TCalories,FoodFk,EmailFK)

+值(@日期,@ cat,@ food,@ cal,@ foodfk,@ email);



SqlConnection conn = new SqlConnection(connstring);

SqlCommand cmd = new SqlCommand(queryStr,conn);



cmd.Parameters.AddWithValue(@ date,Date);

cmd.Parameters.AddWithValue(@ cat,Category);

cmd.Parameters.AddWithValue(@ food,食物);

cmd.Parame ters.AddWithValue(@ cal,卡路里);

cmd.Parameters.AddWithValue(@ foodfk,foodfk);

cmd.Parameters.AddWithValue(@电子邮件,电子邮件);

conn.Open();

int result = cmd.ExecuteNonQuery();

if(result> 0){



返回true;





}

else {



}



返回false;

}



//我的iservice .cs





my service.svc

public bool InsertPlan(string Date, string Category, string food, string calories, string foodfk , string email)
{

string connstring = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();

string queryStr = "INSERT INTO [Plans] (PlanDate, Category, FoodName,TCalories, FoodFk, EmailFK)"
+ "values (@date, @cat, @food, @cal , @foodfk, @email)";

SqlConnection conn = new SqlConnection(connstring);
SqlCommand cmd = new SqlCommand(queryStr, conn);

cmd.Parameters.AddWithValue("@date", Date);
cmd.Parameters.AddWithValue("@cat", Category);
cmd.Parameters.AddWithValue("@food", food);
cmd.Parameters.AddWithValue("@cal", calories);
cmd.Parameters.AddWithValue("@foodfk", foodfk);
cmd.Parameters.AddWithValue("@email", email);
conn.Open();
int result = cmd.ExecuteNonQuery();
if (result > 0){

return true;


}
else{

}

return false;
}

//my iservice.cs








[WebInvoke(Method="POST",
       RequestFormat = WebMessageFormat.Json,
       ResponseFormat = WebMessageFormat.Json,
       UriTemplate = "InsertPlan?PlanDate={Date}&Category={Category}&FoodName={food}&TCalories={calories}&FoodFk={foodfk}&EmailFK={email}")]

推荐答案

(#Button1)。click(function(){

var data1 = new Array();



});


("#Button1").click(function () {
var data1 = new Array();

});


.ajax({

类型:'POST',

url:'http:// localhost:1990 / Service1.svc / InsertPlan?PlanDate = {0}& Category = {0}& FoodName = {0}& TCalories = {0}& FoodFk = {0}& EmailFK = {0}',

contentType:application / json; charset = utf-8,

数据:'{food:['+'calories:['+'name:['+

data.join()+ ']]]}',

dataType:'json',

成功:功能(结果){alert(results.d);},

错误:function(){alert('error');}

});

});


.ajax({
type: 'POST',
url: 'http://localhost:1990/Service1.svc/InsertPlan?PlanDate={0}&Category={0}&FoodName={0}&TCalories={0}&FoodFk={0}&EmailFK={0}',
contentType: "application/json; charset=utf-8",
data: '{ food:[' + 'calories:[' + 'name:[' +
data.join() + ']]]}',
dataType: 'json',
success: function (results) { alert(results.d); },
error: function () { alert('error'); }
});
});


(div .block)。each(function(){

this.addEventListener('dragstart',OnDragStart,false);

});


("div .block").each(function () {
this.addEventListener('dragstart', OnDragStart, false);
});


这篇关于通过休息POST将参数从jquery传递到asp.net的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆