62,041
社区成员
发帖
与我相关
我的任务
分享
function FillSupplier(selectOB)
{
var mid = selectOB.parents("tr").find("input:hidden:first").val();
$.ajax({
url:"../JqueryHandler.ashx",
type:"post",
data:{PAction:"FillSupplier",PMid:mid},
success:function (data) {
var json = eval(data);
selectOB.empty();
for(var ind in json){
selectOB.append($("<option value='" + json[ind].ID + "'>" + json[ind].Names + "</option>"));
selectOB.parent().parent().find(".Sprice").text(selectOB.val().split('-')[1]);
selectOB.parent().parent().find(".MPrice").val(selectOB.val().split('-')[1]);
}
}
});
}
if (context.Request["PAction"].Trim() == "FillSupplier")
{
sql = string.Format("select A.*,B.Names SName"
+ " FROM Sy_MaterielSupplier A,Sy_Supplier B"
+ " WHERE Supplier = B.ID"
+ " AND Materiel = {0}", context.Request["PMid"].Trim());
DataTable dt = DBBase.GetDataTable(sql);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("{");
sb.AppendFormat("\"ID\":\"{0}\",\"Names\":\"{1}\"", dt.Rows[i]["ID"].ToString() + "-" + dt.Rows[i]["Price"].ToString(), dt.Rows[i]["SName"].ToString());
sb.Append("},");
}
context.Response.Write("[" + sb.ToString().TrimEnd(',') + "]");
}
public class Handler : IHttpHandler, IRequiresSessionState
继承IRequiresSessionState接口就可以SESSION了