一.首先我们要写个form表单如下所示:
<formid="formTitleInfors"method="post"role="form"action="/DoctorManage/Dorctor/SelctElder"style="background:#e3efff;
padding-top:8px;">
<div
class="form-row">里面放有input标签</div>
<div
class="form-row">里面放有input标签</div>
<div
class="form-row">里面放有input标签</div>
</form>
然而我们要根据双击入住号达到回填form表单里的其他input标签内容,js代码如下:根据这个入住号的ID写一个双击方法获取页面输入的入住号再写个if判断进行执行,再用post请求去控制器写查询方法并传参去控制器最后进行整张form表单回填。
<label class="col-sm-1
col-form-label text-right">入住号:</label>
<input id="ChekinNumber" name="ChekinNumber" class="
form-control-sm col-sm-1">
$(function () {
//form表单回填
$("#ChekinNumber").dblclick(function
() {
var chekinNumber =
$("#ChekinNumber").val();
if (chekinNumber
!="") {
$.post("SelctElder", { chekinNumber: chekinNumber }, function
(stuData) {
console.log(stuData);//输出
loadDatatoForm("formTitleInfors",
stuData);
$("#ElderName").val(stuData.ElderName);
});
}
});
});
根据chekinNumber来回填表单,查询所有和这个入住号相关人的信息:
public ActionResult SelctElder(string
chekinNumber)
{
ElderVo listElderMasage = (from
tbElder in myModels.B_Elder
join tbInsurancetypeName in
myModels.B_Insurancetype on tbElder.InsurancetypeID equals
tbInsurancetypeName.InsurancetypeID
join tbNurRank
in myModels.B_NurseRank on tbElder.NurseRankID equals tbNurRank.NurseRankID
join
tbRoomDetail in myModels.B_RoomDetail on tbElder.ElderID equals
tbRoomDetail.ElderID
join
tbChekinMode in myModels.B_CheckinMode on tbElder.CheckinModeID equals
tbChekinMode.CheckinModeID
join
tbAgreement in myModels.B_Agreement on tbElder.ElderID equals
tbAgreement.ElderID
join tbChekin in myModels.B_Checkin
on tbElder.ElderID equals tbChekin.ElderID
where
tbChekin.ChekinNumber== chekinNumber
select new
ElderVo
{
ElderID=tbElder.ElderID,
ElderAge
=tbElder.ElderAge,
ElderName=tbElder.ElderName,
ElderSex=tbElder.ElderSex,
ElderNum=tbElder.ElderNum,
NurseRankName=tbNurRank.NurseRankName,
AgreementStarttime=tbAgreement.AgreementStarttime,
AgreementEndtime=tbAgreement.AgreementEndtime
InsurancetypeName=tbInsurancetypeName.InsurancetypeName,
CheckinMode=tbChekinMode.CheckinMode,
RoomDetail=tbRoomDetail.RoomDetail,
ChekinNumber=tbChekin.ChekinNumber,
}).Single();
return
Json(listElderMasage,JsonRequestBehavior.AllowGet);
}