public static void Seed(StuDBContext context)
{
var d1 = new DepartMent()
{
Name = "电子信息工程学院",
SortCode = "001",
Description = "第一大学院"
};
var d2 = new DepartMent()
{
Name = "机电工程学院",
SortCode = "002",
Description = "第二大学院"
};
var d3 = new DepartMent()
{
Name = "汽车工程学院",
SortCode = "003",
Description = "第三大学院"
};
var d4 = new DepartMent()
{
Name = "财经与物流学院",
SortCode = "004",
Description = "第四大学院"
};
context.DepartMents.Add(d1);
context.DepartMents.Add(d2);
context.DepartMents.Add(d3);
context.DepartMents.Add(d4);
context.SaveChanges();
}
public static void Seed(StuDBContext context)
{
for (var i = 0; i < 1000; i++)
{
var fname = "";
var lname = "";
var d1 = context.DepartMent.SingleOrDefault(x => x.Name == "电子信息工程学院");
var fullname = StudentSeed._GetRandomChineFullName(ref fname, ref lname);
Random sj = new Random();
var rnd = sj.Next(0, 1);
var s1 = new Student()
{
StudentNo = "DZXX" + i.ToString("0000"),
FirstName = fname,
LastName = lname,
FullName = fullname,
BirhDay = DateTime.Now,
Address = "社弯路28号",
Sex = rnd == 1? true : false,
phone = "188**********"
};
context.Studetnt.Add(s1);
Thread.Sleep(1);
context.SaveChanges();
_GarbageClear();
}
}
public static void Seed(StuDBContext context)
{
Random random = new Random();
string name = "赵钱孙李周吴郑王冯陈褚卫蒋沈韩杨朱秦尤许何吕施张孔曹严华金魏陶姜戚谢邹喻柏水窦章云苏潘葛奚范彭郎鲁韦昌马苗凤花方俞任袁柳酆鲍史唐费廉岑薛雷贺倪汤滕殷罗毕郝邬安常乐于时傅皮卞齐康伍余元卜顾孟平黄和穆萧尹姚邵湛汪祁毛禹狄米贝明臧计伏成戴谈宋茅庞熊纪舒屈项祝董梁杜阮蓝闵席季麻强贾路娄危江童颜郭梅盛林刁钟徐邱骆高夏蔡田樊胡凌霍虞万支柯昝管卢莫经房裘缪干解应宗丁宣贲邓郁单杭洪包诸左石崔吉钮龚程嵇邢滑裴陆荣翁荀羊於惠甄麴家封芮羿储靳汲邴糜松井段富巫乌焦巴弓牧隗山谷车侯宓蓬全郗班仰秋仲伊宫宁仇栾暴甘钭厉戎祖武符刘景詹束龙叶幸司韶郜黎蓟薄印宿白怀蒲邰从鄂索咸籍赖卓蔺屠蒙池乔阴郁胥能苍双闻莘党翟谭贡劳逄姬申扶堵冉宰郦雍舄璩桑桂濮牛寿通边扈燕冀郏浦尚农温别庄晏柴瞿阎充慕连茹习宦艾鱼容向古易慎戈廖庾终暨居衡步都耿满弘匡国文寇广禄阙东殴殳沃利蔚越夔隆师巩厍聂晁勾敖融冷訾辛阚那简饶空曾毋沙乜养鞠须丰巢关蒯相查後荆红游竺权逯盖益桓公万俟司马上官欧阳夏侯诸葛闻人东方赫连皇甫尉迟公羊澹台公冶宗政濮阳淳于单于太叔申屠公孙仲孙轩辕令狐钟离宇文长孙慕容鲜于闾丘司徒司空亓官司寇仉督子车颛孙端木巫马公西漆雕乐正壤驷公良拓跋夹谷宰父谷梁晋楚闫法汝鄢涂钦段干百里东郭南门呼延归海羊舌微生岳帅缑亢况后有琴梁丘左丘东门西门商牟佘佴伯赏南宫墨哈谯笪年爱阳佟第五言福";
string str = "苍苍白露为霜所谓伊人在水一方溯洄从之道阻且长溯游从之宛在水中央萋萋白露未晞所谓伊人在水之湄溯洄从之道阻且跻溯游从之宛在水中坻采采白露未已所谓伊人在水之涘溯洄从之道阻且右溯游从之宛在水中沚若";
int studentcode = 2017031000;
string ph = "133";
for (int i = 0; i < 1000; i++)
{
studentcode++;
int xin = 0, ming = 0, ming1 = 0, de = 0;
xin = random.Next(0, name.Length);
ming = random.Next(0, str.Length);
ming1 = random.Next(0, str.Length);
de = random.Next(1, 4);
var d = new Student()
{
//随机姓名
Name = name.Substring(xin, 1) + str.Substring(ming, 1) + str.Substring(ming1, 1),
StudentCode = studentcode.ToString(),
Sex = (i % 2 == 0) ? true : false,
Birthday = DateTime.Now,
//随机号码
Phone = ph + de.ToString() + (de / 2).ToString() + de.ToString() + ((i < 100)?"0" + i.ToString():i.ToString()) + de.ToString(),
Address = "社湾路28号",
//随机学院
DepartMent = context.DepartMents.SingleOrDefault(x => x.SortCode == "00" + de.ToString())
};
context.Students.Add(d);
}
context.SaveChanges();
_GarbageClear();
}
protected void Page_Load(object sender, EventArgs e)
{
//IsPostBack判断页面是加载还是回发，如果不是回发才进行数据初始化
if (!IsPostBack)
{
//读出选择的部门id
using (var context = new StuDBContext())
{
var depts = context.Departments.ToList();
DropDownList1.DataSource = depts;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
//选取若干个字段显示
var list = context.Students
.Select(n => new
{
StuNo = n.StudentCode,
Name = n.Name,
Department = n.Department,
Sex = n.Sex ? "男" : "女",
Address = n.Address,
Telphone = n.Phone
}).Take(20).OrderBy(x => x.Department).ThenByDescending(x => x.StuNo);
//取前20条记录，先按学院排序，在按学号倒序排序
GridView1.DataSource = list;
GridView1.DataBind();
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
//读出选择的部门id
var id = Guid.Parse(DropDownList1.SelectedValue);
//读出选择的部门id
using (var context = new StuDBContext())
{
var list = context.Students.Where(n => n.Department.ID == id)
.Select(n => new
{
StuNo = n.StudentCode,
Name = n.Name,
Department = n.Department,
Sex = n.Sex ? "男" : "女",
Address = n.Address,
Telphone = n.Phone
})
//选取若干个字段显示
.Take(20).OrderBy(x => x.StuNo);
//取前20条记录，先按学院排序，在按学号倒序排序
GridView1.DataSource = list;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var category = new StuDBContext().Students.First();
Session["A"] = category;
Response.Redirect("~/B.aspx");
}
private void _getDate()
{
//显示数据
using (var context = new StuDBContext())
{
var studentList = context.Students.Select(x => new{ Sex = x.Sex?"男":"女", ID = x.ID, Name = x.Name, Phone = x.Phone, StudentCode = x.StudentCode, x.DepartMent }).OrderBy(x => x.StudentCode).ToList();
GridView1.DataSource = studentList;
GridView1.DataBind();
}
}
public static void _GarbageClear()
{
var dbcontext = new StuDBContext();
var students = dbcontext.Students.DistinctBy(x => x.Name).ToList();
//删除重名
foreach (var stu in students)
{
dbcontext.Students.Where(x => x.Name == stu.Name && x.ID != stu.ID).Delete();
}
}
//删除时发生
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
using (var context = new StuDBContext())
{
var stu = context.Students.Find(id);
context.Students.Remove(stu);
context.SaveChanges();
}
_getDate();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
var id = Guid.Parse(Request.QueryString["id"].ToString());
var student = new StuDBContext().Students.Find(id);
StuID.Text = student.StudentCode.ToString();
StuName.Text = student.Name;
Stuphone.Text = student.Phone;
}
else
{
Response.Redirect("~/Productlist.aspx");
}
}
//保存修改
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
using (var context = new StuDBContext())
{
var stu = context.Students.Find(id);
var name = e.NewValues["Name"].ToString();
var studentcode = e.NewValues["StudentCode"].ToString();
var sex = true;
if (e.NewValues["sex"].ToString().Trim() != "男")
{
sex = false;
}
stu.Name = name;
stu.StudentCode = studentcode;
stu.Sex = sex;
context.SaveChanges();
}
GridView1.EditIndex = -1;
_getDate();
}
public static void Seed(StuDBContext context)
{
#region 电子信息学生
var d1 = context.DepartMents.SingleOrDefault(x => x.Name == "电子信息工程学院");
for (var i = 0; i < 400; i++)
{
var fname = "";
var lname = "";
var fullname = _GetRandomChineseFullName(ref fname, ref lname);
var student = new Student()
{
StudentNo = "DZXX" + i.ToString("0000"),
FirstName = fname,
LastName = lname,
FullName = fullname,
BirthDay = DateTime.Now,
Address = "社湾路28号",
Department = d1,
Phone = "188********"
};
context.Students.Add(student);
Thread.Sleep(1);
}
#endregion
#region 机电学生
var d2 = context.DepartMents.SingleOrDefault(x => x.Name == "机电工程学院");
for (var i = 0; i < 300; i++)
{
var fname = "";
var lname = "";
var fullname = _GetRandomChineseFullName(ref fname, ref lname);
var student = new Student()
{
StudentNo = "JDGC" + i.ToString("0000"),
FirstName = fname,
LastName = lname,
FullName = fullname,
BirthDay = DateTime.Now,
Address = "社湾路28号",
Department = d2,
Phone = "188********"
};
context.Students.Add(student);
Thread.Sleep(1);
}
#endregion
#region 汽车学生
var d3 = context.DepartMents.SingleOrDefault(x => x.Name == "汽车工程学院");
for (var i = 0; i < 250; i++)
{
var fname = "";
var lname = "";
var fullname = _GetRandomChineseFullName(ref fname, ref lname);
var student = new Student()
{
StudentNo = "QCGC" + i.ToString("0000"),
FirstName = fname,
LastName = lname,
FullName = fullname,
BirthDay = DateTime.Now,
Address = "社湾路28号",
Department = d3,
Phone = "188********"
};
context.Students.Add(student);
Thread.Sleep(1);
}
#endregion
#region 贸易与旅游学生
var d4 = context.DepartMents.SingleOrDefault(x => x.Name == "贸易与旅游学院");
for (var i = 0; i < 200; i++)
{
var fname = "";
var lname = "";
var fullname = _GetRandomChineseFullName(ref fname, ref lname);
var student = new Student()
{
StudentNo = "MYLY" + i.ToString("0000"),
FirstName = fname,
LastName = lname,
FullName = fullname,
BirthDay = DateTime.Now,
Address = "社湾路28号",
Department = d4,
Phone = "188********"
};
context.Students.Add(student);
Thread.Sleep(1);
}
#endregion
#region 机电学生
var d5 = context.DepartMents.SingleOrDefault(x => x.Name == "财经与物流学院");
for (var i = 0; i < 150; i++)
{
var fname = "";
var lname = "";
var fullname = _GetRandomChineseFullName(ref fname, ref lname);
var student = new Student()
{
StudentNo = "CJWL" + i.ToString("0000"),
FirstName = fname,
LastName = lname,
FullName = fullname,
BirthDay = DateTime.Now,
Address = "社湾路28号",
Department = d5,
Phone = "188********"
};
context.Students.Add(student);
Thread.Sleep(1);
}
#endregion
context.SaveChanges();
//_GarbageClear();
}
static void Main(string[] args)
{
using (var context = new StuDBContext())
Console.WriteLine("ef初始化");
}
