public JsonResult ReturnJson()
{
string sql = "select AccountNumber,Name from [dbo].[SysUser]";
DAL.SqlHelper sqlHelper = new DAL.SqlHelper();
DataTable dataTable = sqlHelper.SqlConnectionInformation(sql);
var list = (
from d in dataTable.AsEnumerable()
where d.Field <string>("Name") == "许嵩"
select new User
{
Number = d.Field <string>("AccountNumber"),
Name = d.Field <string>("Name")
}
).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
