效果:
一、SQL数据库表结构
tinyint 范围:0 到 255
int 范围:-2,147,483,648 到 2,147,483,647
bit 范围:0 到 1(0表示False 1表示True)
money 范围:小数4位(存储-922337203685477.5808~922337203685477.5807的货币值)
datetime 时间
varchar 可变长度 如:varchar(60) 那表示可以存60个数字,英文
或 可以存30个中文
二、创建实体数据模型
三、增,删,改,查,列表
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication4.Controllers
{
/// <summary>
/// 数据传输对象(Dto)
/// </summary>
public class UserDto
{
public int Id { get; set; }
public string UserName { get; set; }
public bool? Sex { get; set; }//?表示数据库中这个字段可以为空
public int? WorkYear { get; set; }
public DateTime? WorkTime { get; set; }
public decimal? Salary { get; set; }
public string Texts { get; set; }
}
public class HomeController : Controller
{
public ActionResult Index()
{
//添加
//UserDto item = new UserDto();
//item.UserName = "姓名";
item.Sex = true;
//item.WorkYear = 5;
//item.WorkTime = DateTime.Now;
//item.Salary = 7500;
//AddUser(item);
//获得一条记录
//return View(Fetch(2));
//修改
//UserDto item = new UserDto();
//item.Id = 2;
//item.UserName = "姓名2";
//item.Sex = true;
//item.WorkYear = 5;
//item.WorkTime = DateTime.Now;
//item.Salary = 7500;
//item.Texts = "备注";
//Update(item);
//删除
//Delete(2);
//列表
return View(FetchList());
}
[HttpPost]//获得多选框的值
public ActionResult Index(FormCollection fc)
{
//获得隐藏域Id的值,并将string数组转换成int数组,获得 2,3
int[] ArrId = Array.ConvertAll<string, int>(fc["item.Id"].Split(','), delegate(string s) { return int.Parse(s); });
//获得多选框的值:只选择了3,提交,获得 "false","3","false"
string[] ArrSex = fc["item.Sex"].Split(',');
bool[] MyArr = new bool[ArrId.Length];
for (int i = 0; i < ArrId.Length; i++)
{
MyArr[i] = ArrSex.Contains<string>(ArrId[i].ToString());//如果多选框包含隐藏域的值,则返回True
} int count = ArrId.Length;
using (var ctx = new csEntities())
{
int j = 0;
for (int i = 0; i < count; i+