回车键数据回填事件

回车键数据回填事件

---

开发工具与关键技术：Visual Studio + MVC + SQL Server + .Net
作者：琉敏
撰写时间：2019年1月31日

---

1、今天跟大家讲一个简单的回车键按下数据回填事件（见图1）。

图1
2、代码实现回车键按下数据回填事件：
（1）控制器代码：

public ActionResult SelectSEE(string aa)//住院号回填事件
{
     var list = (from tbsur in myModels.SYS_SurgeryPlan
                 where tbsur.BeHospitalizedHowl == aa
                 select new
                 {
                     tbsur.SurgeryPlanID,
                 }).Single();
     int SurgeryPlanID = list.SurgeryPlanID;
     var listPateint = (from tbPateint in myModels.PW_Patient//病人表
                        join tbsurgeryplan in myModels.SYS_SurgeryPlan on tbPateint.SurgeryPlanID equals tbsurgeryplan.SurgeryPlanID//手术安排表
                        join tbIll in myModels.SYS_IllnessDistrict on tbPateint.IllnessDistrictID equals tbIll.IllnessDistrictID//病区表
                        join tbill in myModels.SYS_Expenses on tbsurgeryplan.ExpensesID equals tbill.ExpensesID//费别表
                        join tbSu in myModels.SYS_SurgeryPlanRegister on tbsurgeryplan.SurgeryPlanID equals tbSu.SurgeryPlanID//手术安排登记安排
                        where tbsurgeryplan.SurgeryPlanID == SurgeryPlanID //根据住院号所在的那张表的ID查询
                        select new
                        {
                            tbsurgeryplan.BeHospitalizedHowl,
                            tbPateint.PatientName,
                            tbIll.IllnessDistrictMC,
                            tbPateint.PatientSex,
                            tbPateint.PateintAge,
                            tbsurgeryplan.BedCall,
                            tbsurgeryplan.SurgeryName,
                            tbill.Expenses,
                            tbSu.ShuQianDiagnose,
                            tbsurgeryplan.DoctorName
                        }).ToList();
     return Json(listPateint, JsonRequestBehavior.AllowGet);
 }

（2）页面代码：

 //住院号回填事件
 function u() {
     var aa = $("#zhuyuanhao").val();
     //alert(aa);
     $.post("/Surgerywork/SurgeryPlanRegister/SelectSEE", { aa: aa }, function (data) {//{ aa: aa }  键值对
         $("#xingming").val(data[0].PatientName);
         $("#bingqu").val(data[0].IllnessDistrictMC);
         $("#xingbie").val(data[0].PatientSex);
         $("#nianling").val(data[0].PateintAge);
         $("#shoushu").val(data[0].SurgeryName);
         $("#chuanghao").val(data[0].BedCall);
         $("#feibie").val(data[0].Expenses);
         $("#zhenduan").val(data[0].ShuQianDiagnose);
         $("#zhudao").val(data[0].DoctorName);
     });
 }
 //回车键
 function onreturn() {
     if (window.event.keyCode == 13) {
         u();
     }
 }