如何从Jqgrid检查到另一个视图并在TextBoxes中显示时获取整行数据

问题描述

Hii to all,
   I Have a requirement that i need to retrive  one r more table's data from DataBase (SQLServer)& display in a Jqgrid.Up to here i have done using Linq Joins&EntityFramework,and one more requirement where i strucked is,here in Jqgrid i have made Multiselect to True,after displaying the table data in Jqgrid the respective checked row's data i need to get in another view say Editable view where i need to dispaly this row data in Textboxes in Editable mode,here user will update the records present in Textboxes and when he press Updata button,the records should be updated to DataBase& also we need to redirect to previous View(after clicking update button in Editable View)
 i.e Jqgrid view & display the modified records in Jqgrid.
Here is my Jqgrid View code  say "GetTablesData":-
@model MVCLINQJoins.Models.TableData
<link href="@Url.Content("~/Content/themes/base/ui.jqgrid.css")" rel="stylesheet" type="text/css" />
<script src="@Url.Content("~/JS/jquery-1.7.2.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/JS/jquery.jqGrid.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/JS/grid.locale-en.js")" type="text/javascript"></script>
@{
    ViewBag.Title = "GetTablesData";
}
<h2>
    GetTablesData</h2>
<script type="text/javascript">
    var mdata = []
</script>
@foreach (var item in Model.getEmployeeDetails)
{
    <script type="text/javascript">
        row = { EmployeeID: '@item.EmployeeId', EmpName: '@item.EmpName', Designation: '@item.Designation', Salary: '@item.Salary', MobileNo: '@item.MobileNo', Email: '@item.Email' };
        mdata.push(row);
    </script>
}
<table id="emp-data-grid">
</table>
<script type="text/javascript">
    $("#emp-data-grid").jqGrid({
        datatype: "local",
        data: mdata,
        colNames: ["EmployeeID", "EmpName", "Designation", "Salary", "MobileNo", "Email"],
        colModel: [
                { name: "EmployeeID", index: "EmployeeID", editable: true, edittype: "checkbox", editoptions: { value: "Yes:No"} },
                { name: "EmpName", index: "EmpName" },
                { name: "Designation", index: "Designation" },
                { name: "Salary", index: "Salary", sorttype: "int" },
                { name: "MobileNo", index: "MobileNo", sorttype: "int" },
                { name: "Email", index: "Email" }
            ],
        shrinkToFit: true,
        multiselect:true,
        caption: "Employee List"

    });


</script>
    @Html.ActionLink("EDIT", "Edit")
when he click on above Edit link,i need to get the respective rows data to Edit View.
Here is My Controller Code:-
public ActionResult GetTablesData()
        {
            TableData model = new TableData();
            model.getEmployeeDetails = new List<Employee>();
            GetDataFromDB(model);
            return View(model);
        }

        private static void GetDataFromDB(TableData model)
        {
            using (personalEntities2 db = new personalEntities2())
            {
                var emply = (from empd in db.empdetails
                             join empp in db.emppersonals on empd.empid equals empp.empid
                             orderby empd.empid
                             select new
                             {
                                 empd.empid,
                                 empd.ename,
                                 empd.designation,
                                 empd.salary,
                                 empd.deptno,
                                 empp.mobileno,
                                 empp.email
                             });
                foreach (var item in emply)
                {
                    Employee ed = new Employee();
                    ed.EmployeeId = item.empid;
                    ed.EmpName = item.ename;
                    ed.Designation = item.designation;
                    ed.Salary = item.salary;
                    ed.DeptNo = item.deptno;
                    ed.MobileNo = item.mobileno;
                    ed.Email = item.email;
                    model.getEmployeeDetails.Add(ed);
                }

            }
        }
        public ActionResult Edit(Employee model,int id)
        {

          return View(model);
        }
Please guide me how to achieve my requirement along with Controller code.Thanks in advance

Thanks
Ramu

推荐答案

这篇关于如何从Jqgrid检查到另一个视图并在TextBoxes中显示时获取整行数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！