如何在mvc 4中的chekboxlist中显示表数据? [英] how to show table data in chekboxlist in mvc 4?

查看:68
本文介绍了如何在mvc 4中的chekboxlist中显示表数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

这是我的控制器:



使用System;

使用System.Collections.Generic;

使用System.Data;

使用System.Data.Entity;

使用System.Linq;

使用System.Web;

使用System.Web.Mvc;

使用IBLAZING.Models;



名称空间IBLAZING.Controllers

{

公共类ProjectsController:Controller

{

private IblazingEntities db = new IblazingEntities();



//

//获取:/ Projects /



公共ActionResult索引()

{

// var topics =(来自db.PROJECTS中的p,p.PROJ_ID上的db.PRIOJ_TO_EMPLOYEE中的pt等于pt.PROJ_ID

// join p.EMP_ID = pt.EMP_ID上的db.PRIOJ_TO_EMPLOYEE中的pt

//选择新的

// {

// PROJ_ID = p.PROJ_ID,

// PROJ_TITLE = p.PROJ_TITLE,

// EMP_ID = p.EMP_ID

//})。 ToList();

var projects = db.PROJECTS.Include(p => p.CLIENT)。包括(p => p.EMPLOYEE);

返回View(projects.ToList());

//返回View(topics);

}



//

//获取:/ Projects / Details / 5



public ActionResult Details(int id = 0)

{

PROJECT project = db.PROJECTS.Find(id);

if(project == null)

{

返回HttpNotFound();

}

返回查看(项目);

}



//

// GET:/ Projects /创建



公共ActionResult创建()

{



PROJECT项目= new PROJECT();

List< SelectListItem> names = new List< SelectListItem>();



//ViewBag.EMP_ID = db.EMPLOYEEs.Select(X => new SelectListItem {Text = X.EMP_NAME ,Value = X.EMP_ID.ToString()});





names.Add(new SelectListItem {Text =EMP_NAME, Value =EMP_ID});



project.EmployeeNames = names;



ViewBag.CLIENT_ID =新的SelectList(db.CLIENTs,CLIENT_ID,CLIENT_NAME);



ViewBag.EMP_ID = db.EMPLOYEEs.Select(X => new SelectListItem {Text = X.EMP_NAME,Value = X.EMP_ID.ToString()});



ViewBag.EMP_ID = new SelectList(db.EMPLOYEEs,EMP_ID,EMP_NAME );

ViewBag.TECH_ID = new SelectList(db.TECHNOLOGies,TECH_ID,TECH_NAME);

返回查看(项目);

}



//

// P. OST:/ Projects / Create



[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult Create(PROJECT project) )

{

if(ModelState.IsValid)

{

db.PROJECTS.Add(project);

db.SaveChanges();

返回RedirectToAction(Index);

}



ViewBag.CLIENT_ID = new SelectList(db.CLIENTs,CLIENT_ID,CLIENT_NAME,project.CLIENT_ID);

ViewBag.EMP_ID = new SelectList(db.EMPLOYEEs,EMP_ID ,EMP_NAME,project.EMP_ID);

// ViewBag.TECH_ID =新的SelectList(db.TECHNOLOGies,TECH_ID,TECH_NAME,project.TECH_ID);

返回查看(项目);

}



//

// GET:/ Projects /编辑/ 5



公共ActionResult编辑(int id = 0)

{

PROJECT项目= db.PROJECTS.Find(id);

if(project == null )

{

返回HttpNotFound();

}

ViewBag.CLIENT_ID = new SelectList(db.CLIENTs ,CLIENT_ID,CLIENT_NAME,project.CLIENT_ID);

ViewBag.EMP_ID =新的SelectList(db.EMPLOYEEs,EMP_ID,EMP_NAME,project.EMP_ID);

//ViewBag.TECH_ID = new SelectList(db.TECHNOLOGies,TECH_ID,TECH_NAME,project.TECH_ID);

返回查看(项目);

}



//

// POST:/ Projects / Edit / 5



[HttpPost]

[ValidateAntiForgeryToken]

公共ActionResult编辑(PROJECT项目)

{

if(ModelState.IsValid)

{

db.Entry(project).State = EntityState.Modified;

db.SaveChanges();

返回RedirectToAction(Index);

}

ViewBag.CLIENT_ID = new SelectList(db.CLIENTs,CLIENT_ID,CLIENT_NAME,project.CLIENT_ID);

ViewBag.EMP_ID = new SelectList(db .EMPLOYEEs,EMP_ID,EMP_NAME,project.EMP_ID);

// ViewBag.TECH_ID =新的SelectList(db.TECHNOLOGies,TECH_ID,TECH_NAME,project.TECH_ID);

返回查看(项目);

}



//

/ / GET:/ Projects / Delete / 5



public ActionResult Delete(int id = 0)

{

PROJECT项目= db.PROJECTS.Find(id);

if(project == null)

{

return HttpNotFound();

}

返回Vi ew(项目);

}



//

// POST:/ Projects / Delete / 5



[HttpPost,ActionName(删除)]

[ValidateAntiForgeryToken]

public ActionResult DeleteConfirmed(int id)

{

PROJECT项目= db.PROJECTS.Find(id);

db.PROJECTS.Remove(project);

db.SaveChanges();

返回RedirectToAction(Index);

}



protected override void Dispose(bool disposing)

{

db.Dispose();

base.Dispose(disposing); < br $>
}

}

}



型号:

this is my controller:

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using IBLAZING.Models;

namespace IBLAZING.Controllers
{
public class ProjectsController : Controller
{
private IblazingEntities db = new IblazingEntities();

//
// GET: /Projects/

public ActionResult Index()
{
//var topics=(from p in db.PROJECTS join pt in db.PRIOJ_TO_EMPLOYEE on p.PROJ_ID equals pt.PROJ_ID
// join pt in db.PRIOJ_TO_EMPLOYEE on p.EMP_ID =pt.EMP_ID
// select new
// {
// PROJ_ID=p.PROJ_ID ,
// PROJ_TITLE =p.PROJ_TITLE ,
// EMP_ID =p.EMP_ID
// }).ToList();
var projects = db.PROJECTS.Include(p => p.CLIENT).Include(p => p.EMPLOYEE);
return View(projects.ToList());
//return View (topics);
}

//
// GET: /Projects/Details/5

public ActionResult Details(int id = 0)
{
PROJECT project = db.PROJECTS.Find(id);
if (project == null)
{
return HttpNotFound();
}
return View(project);
}

//
// GET: /Projects/Create

public ActionResult Create()
{

PROJECT project = new PROJECT();
List<SelectListItem> names = new List<SelectListItem>();

//ViewBag.EMP_ID = db.EMPLOYEEs.Select(X => new SelectListItem { Text = X.EMP_NAME, Value = X.EMP_ID.ToString() });


names.Add(new SelectListItem{ Text = "EMP_NAME", Value = "EMP_ID" });

project.EmployeeNames = names;

ViewBag.CLIENT_ID = new SelectList(db.CLIENTs, "CLIENT_ID", "CLIENT_NAME");

ViewBag.EMP_ID = db.EMPLOYEEs.Select(X => new SelectListItem { Text = X.EMP_NAME, Value = X.EMP_ID.ToString() });

ViewBag.EMP_ID = new SelectList(db.EMPLOYEEs, "EMP_ID", "EMP_NAME");
ViewBag.TECH_ID = new SelectList(db.TECHNOLOGies, "TECH_ID", "TECH_NAME");
return View(project);
}

//
// POST: /Projects/Create

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Create(PROJECT project)
{
if (ModelState.IsValid)
{
db.PROJECTS.Add(project);
db.SaveChanges();
return RedirectToAction("Index");
}

ViewBag.CLIENT_ID = new SelectList(db.CLIENTs, "CLIENT_ID", "CLIENT_NAME", project.CLIENT_ID);
ViewBag.EMP_ID = new SelectList(db.EMPLOYEEs, "EMP_ID", "EMP_NAME", project.EMP_ID);
// ViewBag.TECH_ID = new SelectList(db.TECHNOLOGies, "TECH_ID", "TECH_NAME", project.TECH_ID);
return View(project);
}

//
// GET: /Projects/Edit/5

public ActionResult Edit(int id = 0)
{
PROJECT project = db.PROJECTS.Find(id);
if (project == null)
{
return HttpNotFound();
}
ViewBag.CLIENT_ID = new SelectList(db.CLIENTs, "CLIENT_ID", "CLIENT_NAME", project.CLIENT_ID);
ViewBag.EMP_ID = new SelectList(db.EMPLOYEEs, "EMP_ID", "EMP_NAME", project.EMP_ID);
//ViewBag.TECH_ID = new SelectList(db.TECHNOLOGies, "TECH_ID", "TECH_NAME", project.TECH_ID);
return View(project);
}

//
// POST: /Projects/Edit/5

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Edit(PROJECT project)
{
if (ModelState.IsValid)
{
db.Entry(project).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.CLIENT_ID = new SelectList(db.CLIENTs, "CLIENT_ID", "CLIENT_NAME", project.CLIENT_ID);
ViewBag.EMP_ID = new SelectList(db.EMPLOYEEs, "EMP_ID", "EMP_NAME", project.EMP_ID);
// ViewBag.TECH_ID = new SelectList(db.TECHNOLOGies, "TECH_ID", "TECH_NAME", project.TECH_ID);
return View(project);
}

//
// GET: /Projects/Delete/5

public ActionResult Delete(int id = 0)
{
PROJECT project = db.PROJECTS.Find(id);
if (project == null)
{
return HttpNotFound();
}
return View(project);
}

//
// POST: /Projects/Delete/5

[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(int id)
{
PROJECT project = db.PROJECTS.Find(id);
db.PROJECTS.Remove(project);
db.SaveChanges();
return RedirectToAction("Index");
}

protected override void Dispose(bool disposing)
{
db.Dispose();
base.Dispose(disposing);
}
}
}

model:

//------------------------------------------------------------------------------
// <auto-generated>
//    This code was generated from a template.
//
//    Manual changes to this file may cause unexpected behavior in your application.
//    Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace IBLAZING.Models
{
    using System;
    using System.Collections.Generic;
    using System.Web.Mvc;

    public partial class PROJECT
    {

        public IList<SelectListItem> EmployeeNames { get; set; }


        public PROJECT()
        {
            this.PRIOJ_TO_EMPLOYEE = new HashSet<PRIOJ_TO_EMPLOYEE>();
            this.PROJ_DOC = new HashSet<PROJ_DOC>();
            this.PROJ_TO_TECH = new HashSet<PROJ_TO_TECH>();
            this.PROJECT_DISCUSSION = new HashSet<PROJECT_DISCUSSION>();
        }

        public int PROJ_ID { get; set; }
        public string PROJ_TITLE { get; set; }
        public int CLIENT_ID { get; set; }
        public string PROJ_DETAIL { get; set; }
        public int EMP_ID { get; set; }
        public System.DateTime AWARD_TIME { get; set; }
        public System.DateTime START_TIME { get; set; }
        public decimal COST { get; set; }

        public virtual CLIENT CLIENT { get; set; }
        public virtual EMPLOYEE EMPLOYEE { get; set; }
        public virtual ICollection<PRIOJ_TO_EMPLOYEE> PRIOJ_TO_EMPLOYEE { get; set; }
        public virtual ICollection<PROJ_DOC> PROJ_DOC { get; set; }
        public virtual ICollection<PROJ_TO_TECH> PROJ_TO_TECH { get; set; }
        public virtual ICollection<PROJECT_DISCUSSION> PROJECT_DISCUSSION { get; set; }
    }
}







查看:

@model IBLAZING.Models.PROJECT



@ {

ViewBag.Title =创建;

}



创建







@using(Html.BeginForm()){

@ Html.AntiForgeryToken()

@ Html.ValidationSummary(true)




view:
@model IBLAZING.Models.PROJECT

@{
ViewBag.Title = "Create";
}

Create




@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)








PROJECT

< link href =〜/ Content / layout.css =stylesheet/>



@ *


PROJECT
<link href="~/Content/layout.css" rel="stylesheet" />

@*


@ Html.LabelFor(model => model.PROJ_ID)


@Html.LabelFor(model => model.PROJ_ID)






@ Html.EditorFor(model => model.PROJ_ID)

@ Html.ValidationMessageFor(model => model.PROJ_ID)


@Html.EditorFor(model => model.PROJ_ID)
@Html.ValidationMessageFor(model => model.PROJ_ID)

* @



*@



@ Html.LabelFor(model => model.PROJ_TITLE)


@Html.LabelFor(model => model.PROJ_TITLE)






@ Html.EditorFor(model => ; model.PROJ_TITLE)

@ Html.ValidationMessageFor(model => model.PROJ_TITLE)


@Html.EditorFor(model => model.PROJ_TITLE)
@Html.ValidationMessageFor(model => model.PROJ_TITLE)






@ *


@*



@ Html.LabelFor(model => model.TECH_ID,技术)


@Html.LabelFor(model => model.TECH_ID, "TECHNOLOGY")






@ Html.DropDownList(TECH_ID, ---选择技术名称---)

@ Html.ValidationMessageFor(model => model.TECH_ID)


@Html.DropDownList("TECH_ID", "--- Select Technology-Name---")
@Html.ValidationMessageFor(model => model.TECH_ID)

* @

*@









@ Html.LabelFor(model => model.CLIENT_ID,CLIENT)


@Html.LabelFor(model => model.CLIENT_ID, "CLIENT")






@ Html.DropDownList(CLIE NT_ID,---请选择客户名称---)

@ Html.ValidationMessageFor(model => model.CLIENT_ID)


@Html.DropDownList("CLIENT_ID", "---Please Select Client-Name---" )
@Html.ValidationMessageFor(model => model.CLIENT_ID)












@ Html.LabelFor(model => model.PROJ_DETAIL)


@Html.LabelFor(model => model.PROJ_DETAIL)






@ Html.EditorFor(model => model.PROJ_DETAIL)

@ Html.ValidationMessageFor(model => ; model.PROJ_DETAIL)


@Html.EditorFor(model => model.PROJ_DETAIL)
@Html.ValidationMessageFor(model => model.PROJ_DETAIL)









@ Html.LabelFor(model => model.EMP_ID,EMPLOYEE)




@Html.LabelFor(model => model.EMP_ID, "EMPLOYEE")








< script src =〜/ Scripts / jquery-1.7.1。 min.js>< / script>







< script>



$(凭证).ready(功能(){











$('。chkclass')。click(function(){







var getchkid = $(this).attr('id');



var isChecked = $('#'+ getchkid).is(':checked');







if($('#'+ getchkid).is(':checked')== true){



$('#td '+ $(this).val())。css(color,white);



$('#td'+ $(this) .val())。css(background-color,blue);



}



else {



$('#td'+ $(this).val())。css(color,black);



$('#td'+ $(this).val())。css(background-color,white);



}



});







});







< / script>



<script src="~/Scripts/jquery-1.7.1.min.js"></script>



<script>

$(document).ready(function () {





$('.chkclass').click(function () {



var getchkid = $(this).attr('id');

var isChecked = $('#' + getchkid).is(':checked');



if ($('#' + getchkid).is(':checked') == true) {

$('#td' + $(this).val()).css("color", "white");

$('#td' + $(this).val()).css("background-color", "blue");

}

else {

$('#td' + $(this).val()).css("color", "black");

$('#td' + $(this).val()).css("background-color", "white");

}

});



});



</script>




@foreach (@ Model.EmployeeNames中的var名称)



{



var checkBoxId =chk+名称.Value;



var tdId =td+ names.Text;







< input type =checkboxid =@ checkBoxIdclass =chkclassvalue =@ names.Value/>



@ names.Text













}





@foreach (var names in @Model.EmployeeNames)

{

var checkBoxId = "chk" + names.Value;

var tdId = "td" + names.Text;



<input type="checkbox" id="@checkBoxId" class="chkclass" value="@names.Value" />

@names.Text






}



@H tml.DropDownListFor(m => m.EMPLOYEE,(IEnumerable< SelectListItem>)ViewBag.EMP_ID,

- 请选择 - )



@ * @ Html.CheckBox(EMP_ID)* @







@ Html.DropDownList(EMP_ID ,---选择员工姓名---)



@ Html.ValidationMessageFor(model => model.EMP_ID)


@Html.DropDownListFor(m => m.EMPLOYEE,(IEnumerable<SelectListItem>)ViewBag.EMP_ID,
"--Please select--")

@* @Html.CheckBox("EMP_ID")*@



@Html.DropDownList("EMP_ID","--- Select Employee-Name---")

@Html.ValidationMessageFor(model => model.EMP_ID)















@ Html.LabelFor(model => model.AWARD_TIME)


@Html.LabelFor(model => model.AWARD_TIME)






@ Html.EditorFor(model => model.AWARD_TIME)

@ Html.ValidationMessageFor(model => model。 AWARD_TIME)


@Html.EditorFor(model => model.AWARD_TIME)
@Html.ValidationMessageFor(model => model.AWARD_TIME)









@ Html.LabelFor(model => model.START_TIME)


@Html.LabelFor(model => model.START_TIME)






@ Html.EditorFor(model => ; model.START_TIME)

@ Html.ValidationMessageFor(model => model.START_TIME)


@Html.EditorFor(model => model.START_TIME)
@Html.ValidationMessageFor(model => model.START_TIME)









@ Html.LabelFor(model => model.COST)


@Html.LabelFor(model => model.COST)






@ Html.EditorFor(model => model.COST)

@ Html.ValidationMessageFor(model => model.COST)


@Html.EditorFor(model => model.COST)
@Html.ValidationMessageFor(model => model.COST)






< input type =submitvalue =创建/>


<input type="submit" value="Create" />






}




}



@ Html.ActionLink(返回列表,索引)


@Html.ActionLink("Back to List", "Index")





@section脚本{

@ Scripts.Render(〜/ bundles / jqueryval)

}



@section Scripts {
@Scripts.Render("~/bundles/jqueryval")
}

推荐答案

(文件).ready(function(){










(document).ready(function () {






('。chkclass')。click(function(){







var getchkid =
('.chkclass').click(function () {



var getchkid =


(this).attr(' id');



var isChecked =
(this).attr('id');

var isChecked =


这篇关于如何在mvc 4中的chekboxlist中显示表数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆