1.部分HTML代码(代码太多所以只写一部分)
<form class="row justify-content-center pl-1" id="VIPform"> <div class="col-6 px-0 my-1"> <span class="col-4" > VIP卡号:</span> <input type="text" name="VIPNumber" class="py-1 pr-2" /> <input type="text" name="VIPID" value="0" style="display:none"/> <div class="btn col-1 layui-icon layui-icon-add-1 p-0 bg-white"></div> </div> <div class="col-6 px-0 my-1"> <span class="col-4">手机:</span> <input type="text" name="Cellphone" class="col-7 p-0 "/> </div> <div class="col-6 px-0 my-1"> <span class="col-4"> VIP姓名:</span> <input type="text" name="VIPName" class="col-6 p-0 "/> </div></form> |
![](https://img-blog.csdnimg.cn/2019062719361341.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU1MjE2OA==,size_16,color_FFFFFF,t_70)
2.视图效果
$("#VIPadd").click(function () { var formDate = $("#VIPform").serializeArray();//serializeArray() 方法通过序列化表单值来创建对象数组(名称和值)。返回 JSON 数据结构数据。此方法返回的是 JSON 对象而非 JSON 字符串 //获取页面中的一些input的vaule值判断是否填写完整 var VIPNumber = $("#VIP input[name=VIPNumber]").val(); var Cellphone = $("#VIP input[name=Cellphone]").val(); var VIPName = $("#VIP input[name=VIPName]").val(); var Birthday = $("#VIP input[name=Birthday]").val(); if (VIPNumber != "" && Cellphone != "" && VIPName != "" && Birthday != "") { //异步请求传递已经序列化的表单数据 $.post("/DailyRoutine/VIPset/VIPform", formDate, function (data) { if (data.State == true) { $("#VIP").modal("hide");//关闭新增VIP模态框 var State = $("#screenProject").val(); var hinge = $("#hinge").val(); table.reload("VIPtabla", { url: "/DailyRoutine/VIPset/VIPinquire", where: { State: 1, hinge: "" } })//刷新VIP表格数据 layer.alert(data.Text, { icon: 1, title: "提示" }) } else { layer.alert(data.Text, { icon: 2, title: "提示" }) } }) } else { layer.alert("请将数据填写完整后提交!", { icon: 5, title: "提示" }) } }) |
3.页面数据和控制器数据对比
页面输入的数据 | 控制器获取的数据 |
4.控制器新增数据
public ActionResult VIPform(B_VIP Bvip, int VIPID) { //实例化实体类 ReturnJson returnJson = new ReturnJson();
//实体类中成员赋值 returnJson.State = false; //查询原有数据中是否有相同数据 var name = Bvip.VIPName; var Cellphone = Bvip.Cellphone; var Name = (from tb in myModel.B_VIP where tb.VIPName == name && tb.Cellphone == Cellphone&&tb.VIPID!= VIPID select tb).Count(); //确定不存在重复数据 if (Name == 0) { myModel.B_VIP.Add(Bvip);//数据库新增语句 myModel.SaveChanges();//数据库确定保存 returnJson.State = true; returnJson.Text = "VIP添加成功"; } } else { //若数据在原有数据中出现就返回状态false和提示内容重复 returnJson.State = false; returnJson.Text = "数据重复"; } //把实例化的变量返回到页面 return Json(returnJson,JsonRequestBehavior.AllowGet); } |