如何从Jqgrid检查到另一个视图并在TextBoxes中显示时获取整行数据 [英] How to get Entire Row data when checked from Jqgrid to another view &display in 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

推荐答案

（＃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：指定，索引：指定}，
{名称：薪水，索引：薪水，sorttype：int}，
{名称：MobileNo，索引：MobileNo ，sorttype：int}，
{name：Email，index：Email}
]，
shrinkToFit：true，
multiselect：true，
标题：员工名单

}）;


< / script >
@ Html.ActionLink（编辑，编辑）
当他点击上面的编辑链接时，我需要获取相应的行数据到编辑视图。
这是我的控制器代码： -
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 =（来自db.empdetails中的empd
在empd.empid上的db.emppersonals中加入empp等于empp.empid
orderby empd.empid
选择新
{
empd.empid，
empd.ename，
empd.designation，
empd.salary，
empd.deptno，
empp.mobileno，
empp。电子邮件
}）;
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 ）;
}
请指导我如何实现我的要求以及控制器代码。提前谢谢

谢谢
Ramu

("#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中显示时获取整行数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！