通过休息POST将参数从jquery传递到asp.net [英] passing parameters from jquery to asp.net thru rest POST
问题描述
大家好我需要一些帮助:(
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
好吧我的问题是
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
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屋!