$(function() {
$("#selectbm").change(function() { //下拉菜单的change事件
var params = '{bm:"' + $(this).val() + '"}'; //此处参数名要注意和后台方法参数名要一致
$.ajax({
type: "POST", //提交方式
url: "wem_default.aspx/user_bind", //提交的页面/方法名
data: params, //参数(如果没有参数:null)
dataType: "text", //类型
contentType: "application/json; charset=utf-8",
beforeSend: function(XMLHttpRequest) {
$('#lblMessage').text("正在响应...");
},
success: function(msg) {
$('#lblMessage').text("");
$("#Username option").each(function() {
$(this).remove(); //移除原有项
});
$("<option value='0'>===请选择===</option>").appendTo("#Username"); //添加一个默认项
$(eval("(" + msg + ")").d).appendTo("#Username"); //将返回来的项添加到下拉菜单中
},
error: function(xhr, msg, e) {
//alert(meg);
}
});
});
});
/// <summary>
/// 绑定用户
/// </summary>
/// <param name="bm"></param>
[System.Web.Services.WebMethod()]
public static string user_bind(string bm)
{
DbOption.DbOption db = new DbOption.DbOption(1);
try
{
StringBuilder strCi = new StringBuilder();
if (bm == "0") //为初始项
{
strCi.Append("<option value=\"");
strCi.Append("请选择");
strCi.Append("\">");
strCi.Append("请选择");
strCi.Append("</option>");
}
else
{
string sql1 = "";
if (bm != "")
sql1 = "select username,notes from st_user where departid = '" + bm + "' order by usernumber";
else
sql1 = "select username,notes from st_user where departid in(select id from xt_department where id ='" + bm + "') order by usernumber";
DataTable dt = db.FillDataTableWithDs(sql1);
foreach (DataRow row in dt.Rows)
{
strCi.Append("<option value=\"");
strCi.Append(row["username"]);
strCi.Append("\">");
strCi.Append(row["notes"]);
strCi.Append("</option>");
}
}
unStr = strCi.ToString();
}
catch (Exception err)
{
//lblMessage.Text = err.Message;
}
return unStr;
}