JQuery 获取json数据$.getJSON方法
2013-03-25 16:48:59 来源:WEB开发网核心提示:前台:function SelectProject() { var a = new Array; var r = window.showModalDialog('SelProject.aspx', a, "dialogWidth=1000px; di
前台:
function SelectProject() {
var a = new Array;
var r = window.showModalDialog('SelProject.aspx', a, "dialogWidth=1000px; dialogHeight=600px; resizable: yes");
if (typeof (r) != 'undefined') {
var arr = r.split(";");
$("#hidProjectInnerID").val(arr[0]);
$("#txtProjectNo").val(arr[1]);
$.getJSON("../Handler/GetProjectInfor.ashx", { key: "PaymentStatement", InnerID: $("#hidProjectInnerID").val() },
function (json) {
$("#labFinalCustomer").text(json.finalclient);
$("#labOrderNo").text(json.orderno);
var strDeviceTr = "";
$.each(json.workinghours, function (i, item) {
strDeviceTr += "<tr><td><lable name=\"infor\"> " + item.description + "</lable> </td>";
strDeviceTr += "<td> </td>";
strDeviceTr += " <td><lable name=\"infor\"> " + item.hoursdays + "</lable></td>";
strDeviceTr += "<td> 0.8</td>";
strDeviceTr += "<td><lable name=\"infor\"> " + item.workinghour + " </lable></td>";
strDeviceTr += "<td> 0.8</td>";
strDeviceTr += "<td><lable name=\"infor\"> " + item.workinghour + "</lable></td>";
strDeviceTr += "<td> </td>";
strDeviceTr += "</tr>";
});
$("#infor").append(strDeviceTr);
});
}
}
ashx
string innerid = CommonClass.Request.GetRequest<string>("InnerID", "");
string key = CommonClass.Request.GetRequest<string>("key", "");
string result = "";
if (key == "StockOutApp" && innerid != "")
{
result = StockOutApp(innerid);
context.Response.Write(result);
}
else if (key == "PaymentStatement" && innerid != "")
{
result = PaymentStatement(innerid);
context.Response.Write(result);
}
#region 结算单信息
public string PaymentStatement(string _innerid)
{
try
{
string sql = @"select InnerID,pFinalClient,pOrderNo from se_ProjectMain where InnerID='" + _innerid + "'";
DataTable dt = SqlShift.GetDataTable(sql);
if (!CommonClass.DTRow.CheckDtIsEmpty(dt))
{
StringBuilder json = new StringBuilder();
json.Append("\"innerid\":\""+dt.Rows[0]["InnerID"].ToString()+"\"");
json.Append(",\"finalclient\":\"" + dt.Rows[0]["pFinalClient"].ToString() + "\"");
json.Append(",\"orderno\":\"" + dt.Rows[0]["pOrderNo"].ToString() + "\"");
json.Append(",\"workinghours\":" + GetWorkingHours(_innerid));
return "{" + json.ToString().Trim(',') + "}";
}
else
{
return string.Empty;
}
}
catch (Exception ex)
{
AppLog.Write("项目获取异常![异常信息:" + ex.Message + "]", AppLog.LogMessageType.Info);
return string.Empty;
}
}
public string GetWorkingHours(string _innerid)
{
try
{
string sql = @"select InnerID, wDescription,wWorkingHour,wHours_Days from se_ProjectWorkingHour where wProjectID='" + _innerid + "'";
DataTable dt = SqlShift.GetDataTable(sql);
if (!CommonClass.DTRow.CheckDtIsEmpty(dt))
{
StringBuilder json = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
json.Append("{");
json.Append("\"innerid\":\"" + dt.Rows[0]["InnerID"].ToString() + "\"");
json.Append(",\"description\":\"" + dt.Rows[0]["wDescription"].ToString() + "\"");
json.Append(",\"workinghour\":\"" + dt.Rows[0]["wWorkingHour"].ToString() + "\"");
json.Append(",\"hoursdays\":\"" + dt.Rows[0]["wHours_Days"].ToString() + "\"");
json.Append("},");
}
return "[" + json.ToString().Trim(',') + "]";
}
else
{
return string.Empty;
}
}
catch (Exception ex)
{
AppLog.Write("项目获取异常![异常信息:" + ex.Message + "]", AppLog.LogMessageType.Info);
return string.Empty;
}
}
#endregion
- ››jquery .ajax方法 异步表单,接收服务器返回的数据...
- ››jquery 添加\删除 cookie
- ››jquery 正则表达式判断是否为正确邮箱格式
- ››jQuery EasyUI 数字框(NumberBox)用法
- ››JQuery中对option的添加、删除、取值
- ››JQuery实现下拉,单选,复选三大控件方法,
- ››jquery实现判断输入文字个数的代码
- ››获取Android手机型号,系统版本,App版本号等信息
- ››获取Windows xp系统高权限无需注销用户
- ››jQuery bxCarousel实现图片滚动切换效果
- ››jQuery弹性滑动导航菜单
- ››jquery实现全选反选功能
更多精彩
赞助商链接
