修改

新增，修改，删除是最基础也是最重要的，接下来我们来看修改，怎么修改，
修改第一步是获取选中值
$("#openUpdate").click(function (CompUserID) {
var checkStatus = layuiTable.checkStatus(‘tabAcademeS’); //获取选中值
var selectData = checkStatus.data;
if (selectData.length == 0) {
layer.alert(“请选择需要修改的数据”, { icon: 6, offset: ‘150px’, skin: ‘layui-layer-molv’ }
)
}
,然后是数据回填，回填新增时候的数据
$("#CompUserID").val(data.CompUserID);
appendOption(“UProInformaName”,“SeleTPProInformaName?ProInformaID=”+data.ProInformaID);
$("#UProInformaName").val(data.ProInformaID);//下拉框数据回填

接下来是保存，修改后的数据
//获取页面数据
var HeNetComUserNum = $("#formopenUpdate [name=‘HeNetComUserNum’]").val();
//数据完整性验证
if (ProInformaID > 0 && TermNum != “” && HeNetComUserName != “”) {
//打开加载层
var load = layer.load();
//提交表单
$("#formopenUpdate").ajaxSubmit(function (returnJson) {
//关闭加载层layer.close(load);
if (returnJson.State) {
layer.msg(returnJson.Text, { icon: 1, title: “提示” });
//关闭模态框
$("#modalInsertopenUpdate").modal(“hide”);
//刷新表格
tabAcademe.reload();} else {
layer.alert(returnJson.Text, { icon: 0, title: “提示” });}
});
}else {
layer.alert(“请填写完整数据信息！”, { icon: 0, title: “提示” });
}}
//控制器上
public ActionResult Sacct(CompUser compUser)
{ReturnJson returnJson = new ReturnJson();
try{
//判断信息是否与数据库已有数据重复
int countComUser = (from tbComUser in myModel.CompUser
where tbComUser.CompUserID != compUser.CompUserID&&
(tbComUser.HeNetComUserNum == compUser.HeNetComUserNum ||tbComUser.HeNetComUserName == compUser.HeNetComUserName)select tbComUser).Count();
然后是提取需要修改的信息，
CompUser dbComUser = (from tbComUser in myModel.CompUserwhere tbComUser.CompUserID == compUser.CompUserID select tbComUser).Single();
需要修改的字段要与数据库的一致，否则修改不了
dbComUser.HeNetComUserName = compUser.HeNetComUserName;//他网竞争用户名称
dbComUser.HeNetComUserNum = compUser.HeNetComUserNum;//他网竞争用户名称
if (myModel.SaveChanges() > 0)
{returnJson.State = true;
returnJson.Text = “修改成功”;}
else{returnJson.State = false;
returnJson.Text = “保存失败”;}}
大于0就显示修改成功
如果数据库已经有该用户修改后信息了，他就不能保存修改的信息
else{
returnJson.State = false;
returnJson.Text = “数据库已存在该用户信息，不需要重复录入！”;}}