如何在mvc 4中的chekboxlist中显示表数据? [英] how to show table data in chekboxlist in mvc 4?
问题描述
这是我的控制器:
使用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屋!