单表的数据新增
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
开发工具与关键技术：Adobe Dreamweaver JavaScript
作者：周乐献
撰写时间：2020年8月8日
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<script>
原有的学院信息
$(function () {
- 点击新增学院按钮,弹出新增模态框
- 在模态框中输入框内填入想新增的数据
- 填写完毕后点击确认按钮,把填写的数据通过Post提交到控制器
//打开新增模态框
function openInsertFaculty() {
condition = true;
$("#Increased").modal('show');
$("#formIncreased input[type='reset']").click();
};
//确认新增
function saveFacultyInfor() {
var facultyName = $("#facultyName").val();
var facultySite = $("#facultySite").val();
var facultyCode = $("#facultyCode").val();
if (facultyCode == "" || !code.test(facultyCode)) {
layer.alert("学院编号由两位数字组成");
return false;
}
if (facultyName == "" || facultyName == null || facultyName == undefined) {
layer.alert("学院名称不能为空");
return false;
}
if (facultySite == "" || facultySite == null || facultySite == undefined) {
layer.alert("学院地址不能为空");
return false;
}
var layerIndex = layer.load();
$.post("@Url.Content("~/college/IncreasedFaculty")",
{
facultyName: facultyName,
facultySite: facultySite,
facultyCode: facultyCode,
},
function (msg) {
layer.close(layerIndex);
layer.alert(msg.Text);
if (msg.State) {
$("#Increased").modal('hide');
TableFaculty.reload({
page: {
curr:1,
}
})
}
})
};
});
</script>
通过控制器把从页面传递过来的数据新增到数据库,
在控制器中查询学院表,然后返回查询到的数据到页面
public ActionResult IncreasedFaculty(S_Academy dbAcademy)
{
ReturnJson msg = new ReturnJson();
try
{
if (!string.IsNullOrEmpty(dbAcademy.facultyName))
{
if (!string.IsNullOrEmpty(dbAcademy.facultySite))
{
if (!string.IsNullOrEmpty(dbAcademy.facultyCode) || Regex.IsMatch(dbAcademy.facultyCode,"^[0-9]{2}$"))
{
int facultyCodeCount = (from tbAcademy in myModel.S_Academy
where tbAcademy.facultyCode == dbAcademy.facultyCode ||tbAcademy.facultyName == dbAcademy.facultyName
select tbAcademy).Count();
if (facultyCodeCount == 0)
{
myModel.S_Academy.Add(dbAcademy);
if (myModel.SaveChanges()>0)
{
msg.State = true;
msg.Text = "新增成功";
}
else
{
msg.Text = "新增失败";
}
}
else
{
msg.Text = "该学院名称或者学院编号已经存在,不能添加";
}
}
else
{
msg.Text = "学院编号由两位数字组成";
}
}
else
{
msg.Text = "学院地址不能为空";
}
}
else
{
msg.Text = "学院名称不能为空";
}
}
catch (Exception e)
{
Console.WriteLine(e);
msg.Text = "数据异常";
}
return Json(msg, JsonRequestBehavior.AllowGet);
}
新增后的页面数据