PDA

View Full Version : دریافت اطلاعات از وب سرویس؟؟



nimaaamin
چهارشنبه 14 بهمن 1394, 12:12 عصر
سلام دوستان
من از طریق تابع ajax
یک سری اطلاعات از وب سرویس دریافت میکنم :
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "../webservice/Details.asmx/get_raingaugedatainitial",
data: "{}",
dataType: "json",
success: function (Result) {
$("#ContentPlaceHolder1_list_datainitial tr").remove();
$("#ContentPlaceHolder1_list_datainitial").append("<tr>" +
"<th style=width:30px;>#</th>" +
"<th style=width:50px;>date</th>" +
"<th style=width:50px;>time</th>" +
"<th style=width:50px;>Minute Rain</th>" +
"<th style=width:50px;>Total Rain</th>" +
"<th style=width:50px;>RTUBatVolt</th>" +
"<th style=width:50px;>DBStatus</th>" +
"<th style=width:50px;>HUMData</th>" +
"<th style=width:50px;>DS18B20Data</th>" +
"<th style=width:50px;>TempMax</th>" +
"<th style=width:50px;>TempMin</th>" +
"<th style=width:50px;>HumMax</th>" +
"<th style=width:50px;>HumMin</th>" +
"<th style=width:10px;></th>" +
"</tr>");
$.each(Result.d, function (key, value) {
$("#ContentPlaceHolder1_list_datainitial").append
("<tr>" +
"<td style=width:30px; >" + value.row + "</td>" +
"<td style=width:80px;>" + value.raingauge_eventdate + "</td>" +
"<td style=width:80px;>" + value.raingauge_eventtime + "</td>" +
"<td style=width:80px;>" + value.raingauge_minuterain + "</td>" +
"<td style=width:80px;>" + value.raingauge_totalrain + "</td>" +
"<td style=width:80px;>" + value.raingauge_rtubatvolt + "</td>" +
"<td style=width:80px;>" + value.raingauge_boardtemp + "</td>" +
"<td style=width:80px;>" + value.raingauge_dbstatus + "</td>" +
"<td style=width:80px;>" + value.raingauge_humdata + "</td>" +
"<td style=width:80px;>" + value.raingauge_ds18b20data + "</td>" +
"<td style=width:80px;>" + value.raingauge_tempmax + "</td>" +
"<td style=width:80px;>" + value.raingauge_tempmin + "</td>" +
"<td style=width:80px;>" + value.raingauge_hummax + "</td>" +
"<td style=width:80px;>" + value.raingauge_hummin + "</td>" +
"<td style=width:10px;><a href=#>حذف</a></td>" +
"</tr>");
});
$("#ContentPlaceHolder1_list_datainitial").tablePagination({});
},
error: function (Result) {
alert("error");
}
});

public List<raingaugedatainitial> get_raingaugedatainitial()
{
SqlConnection connect = objcon.conect();
List<raingaugedatainitial> raingaugedatainitial_list = new List<raingaugedatainitial>();
DataSet ds;
using (SqlCommand cmd = new SqlCommand("SELECT TOP (200)* FROM tbl_raingauge ORDER BY raingauge_eventdateyear,raingauge_eventdatemounth, raingauge_eventdateday,raingauge_eventdatehour,rai ngauge_eventtimeminute,raingauge_eventtimesecond", connect))
{
connect.Open();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{

ds = new DataSet();
da.Fill(ds);
connect.Close();
}
}
try
{
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
int k = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
raingaugedatainitial_list.Add(new raingaugedatainitial()
{
row=k.ToString(),
raingauge_eventdate = dr["raingauge_eventdate"].ToString(),
raingauge_eventtime = dr["raingauge_eventtime"].ToString(),
raingauge_minuterain = dr["raingauge_minuterain"].ToString(),
raingauge_totalrain = dr["raingauge_totalrain"].ToString(),
raingauge_boardtemp = dr["raingauge_boardtemp"].ToString(),
raingauge_dbstatus = dr["raingauge_dbstatus"].ToString(),
raingauge_ds18b20data = dr["raingauge_ds18b20data"].ToString(),
raingauge_rtubatvolt = dr["raingauge_rtubatvolt"].ToString(),
raingauge_tempmax = dr["raingauge_tempmax"].ToString(),
raingauge_tempmin = dr["raingauge_tempmin"].ToString(),
raingauge_humdata = dr["raingauge_humdata"].ToString(),
raingauge_hummax = dr["raingauge_hummax"].ToString(),
raingauge_hummin = dr["raingauge_hummin"].ToString()
});
k++;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return raingaugedatainitial_list;
}
مشکلی که دارم اینه که وقتی تعداد سطر های این لیست از 200 میگذره تابع ajax دیگه نمیتونه اطلاعات رو توی تیبل نمایش بده!!!!!!!!!!!!!!!!!!!!!!!!!
لطفا راهنمایم کنید

nimaaamin
پنج شنبه 15 بهمن 1394, 07:08 صبح
کسی نیست کمک کنه؟

nimaaamin
شنبه 17 بهمن 1394, 07:04 صبح
لطفا یکی راهنمایم کنه

komeil64
یک شنبه 18 بهمن 1394, 12:04 عصر
شما کلا چند تا رکورد رو برمی گردونید تو سلکتتون؟! 200 تا؟