修改

查询数据进行数据回填

//打开修改模态框

1.  
function openUpdate(employeeID) {

            $('UemployeeID
input[type="reset"]').click();//重置表单 

            //数据回填

           
$.post("/Main/SelectEmployeeByID/", {

                employeeID: employeeID

            }, function (data) {

                //给input赋值

               
$("#UemployeeID").val(data.employeeID);

               
$("#UemployeeNum").val(data.employeeNum);

               
$("#UemployeeName").val(data.employeeName);

               
$("#Utelphone").val(data.telphone);

               
$("#Uaddress").val(data.address);

               
$("#UmodalEmployee").modal("show");

            }, "json");

           
$("#UmodalEmployee").modal();//打开模态框

        }

//数据回填查询

2.   public ActionResult
SelectEmployeeByID(int employeeID)

        {

 

            PW_Employee dbEmployee =
(from tbEmployee in myModel.PW_Employee

                                     
where tbEmployee.employeeID == employeeID

                                     
select tbEmployee).Single();

                        return
Json(dbEmployee, JsonRequestBehavior.AllowGet);

        }

修改保存

1.   function savaUpdata() {

            //获取input值

            var employeeNum =
$("#UemployeeNum").val();

            var employeeName =
$("#UemployeeName").val();

            var telphone =
$("#Utelphone").val();

            var address =
$("#Uaddress").val();

            var employeeID =
$("#UemployeeID").val();

            $.post("/Main/UpdataEmployee",

                {

                    employeeID:
employeeID,

                    employeeNum:
employeeNum,

                    employeeName:
employeeName,

                    telphone:
telphone,

                    address:
address,

                }

                , function (msg) {

                    if (msg.State ==
true) {

                       
layer.alert(msg.Text);

                       
$("#UmodalEmployee").modal('hide');

                        tabemployee
= layuiTable.reload('employee');//表格刷新

                    } else {

                       
layer.alert(msg.Text);

                    }

                });

        }

 

//修改

2.   public ActionResult
UpdataEmployee(PW_Employee sysEmployee)

        {

            ReturnJson returnjson =
new ReturnJson();

            returnjson.State =
false;

            if
(!string.IsNullOrEmpty(sysEmployee.employeeName) &&
!string.IsNullOrEmpty(sysEmployee.employeeNum)

                &&
!string.IsNullOrEmpty(sysEmployee.telphone) &&
!string.IsNullOrEmpty(sysEmployee.address))

            {

                var linq = (from
tbEmployee in myModel.PW_Employee

                        where
tbEmployee.employeeID != sysEmployee.employeeID ||

                        
tbEmployee.employeeName==sysEmployee.employeeName.Trim()||

                        
tbEmployee.employeeNum == sysEmployee.employeeNum.Trim()||

                           
tbEmployee.telphone == sysEmployee.telphone.Trim()||

                           
tbEmployee.address == sysEmployee.address.Trim()

                            select
tbEmployee).Count();

                if (linq > 0)

                {

                   
myModel.Entry(sysEmployee).State = EntityState.Modified;

                    if (myModel.SaveChanges()>
0)

                    {

                       
returnjson.State = true;

                       
returnjson.Text = "修改成功";

                    }

                    else

                    {

                       
returnjson.Text = "修改失败";

                    }

                }

                else

                {

                    returnjson.Text = "输入的数据重复";

                }

            }

            else

            {

                returnjson.Text = "数据不完整";  

            }

            return Json(returnjson, JsonRequestBehavior.AllowGet);

        }

ReturnJson封装字段

public class ReturnJson

    {

        /// <summary>

        /// 状态

        /// </summary>

        public bool State { get;
set; }

        /// <summary>

        /// 状态码

        /// </summary>

        public string Code { get;
set; }

        /// <summary>

        /// 文本

        /// </summary>

        public String Text { get;
set; }

        /// <summary>

        /// 附加数据

        /// </summary>

        public object Object { get;
set; }

}

效果