//切换到编辑
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
_getData();
//查询出所有的分类
var context1 = new DataContext.StuDBContext();
//查询出Students数据
var department = context1.DepartMents.ToList();
//查询出Gridview中分类列编辑状态模板中下拉菜单
DropDownList ddl = (DropDownList)GridView1.Rows[e.NewEditIndex].FindControl("DdlDepartment") as DropDownList;
//下拉数据绑定
ddl.DataSource = department;
ddl.DataTextField = "Name";
ddl.DataValueField = "ID";
ddl.DataBind();
//选项绑定
var id = (Guid)GridView1.DataKeys[e.NewEditIndex].Value;
//查询出当前记录 的商品记录，获取他的分类
var departMents = context1.Students.Find(id);
if (departMents.Department != null)
{
ddl.SelectedValue = departMents.Department.ID.ToString();
}
}
public static void Seed(StuDBContext context)
{
var d1 = new Department()
{
Name = "电子信息工程学院",
Dscn = "222",
SortCode = "1"
};
var d2 = new Department()
{
Name = "机电工程学院",
Dscn = "202",
SortCode = "2"
};
var d3 = new Department()
{
Name = "汽车工程学院",
Dscn = "250",
SortCode = "3"
};
var d4 = new Department()
{
Name = "财经与物流学院",
Dscn = "600",
SortCode = "4"
};
context.Departments.Add(d1);
context.Departments.Add(d2);
context.Departments.Add(d3);
context.Departments.Add(d4);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var context = new DataContext.StuDBContext())
{
var depts = new DataContext.StuDBContext().DepartMents.ToList();
//数据绑定到下拉控件
DropDownList1.DataSource = depts;
//显示的数据名
DropDownList1.DataTextField = "Name";
//显示的数据ID
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
var list = context.Students.Select(n => new
{
StudentNo = n.StudentNo,
FullName = n.FullName,
Department = n.Department.Name,
Sex = n.Sex ? "男" : "女",
Address = n.Address,
Telphone = n.Phone
})
.Take(20).OrderBy(x => x.Department).ThenByDescending(x => x.StudentNo).ToList();
GridView1.DataSource = list;
GridView1.DataBind();
}
}
}
//保存修改
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//查询出该记录的主键
var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
using (var context = new DataContext.StuDBContext())
{
var s = context.Students.Find(id);
//读出Gridview中用户编辑的字段，给每个允许修改的实体属性赋值
//获取用户编辑的这一行
var row = GridView1.Rows[e.RowIndex];
var sn = (row.Cells[0].Controls[0] as TextBox).Text.Trim();
var name = (row.Cells[1].Controls[0] as TextBox).Text.Trim();
var add = (row.Cells[2].Controls[0] as TextBox).Text.Trim();
var Departmentid = Guid.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DdlDepartment")).SelectedValue);
s.Department = context.DepartMents.Find(Departmentid);
s.StudentNo = sn;
s.FullName = name;
s.Address = add;
context.SaveChanges();
}
GridView1.EditIndex = -1;
_getData();
}
public static void Seed(StuDBContext context)
{
List <string> Xing = new List <string>()
{
"赵", "钱", "孙", "李", "周", "吴", "郑 ", "王 ", "冯", "陈", "褚", "卫", "蒋", "沈", "韩", "杨", "朱", "秦", "尤", "许",
"何", "吕", "施", "张", "孔", "曹", "严", "华", "金",
};
string _Ming = "刚伟勇毅俊峰强军平保东文辉力明永健世广志义兴良海山仁波宁贵福生龙元全国胜学祥才发武新利清飞彬富顺信子杰涛昌成康星光天达安岩中茂进林有坚和彪博诚先敬震振壮会思群豪心邦承乐绍功松善厚庆磊民友裕河哲江超浩亮政谦亨奇固之轮翰朗伯宏言若鸣朋斌梁栋维启克伦翔旭鹏泽晨辰士以建家致树炎德行时泰盛雄琛钧冠策腾楠榕风航弘";
char[] Ming = _Ming.ToCharArray();
Random X = new Random();
Random M = new Random();
for (var i = 0; i < 1000; i++)
{
string sotrcode = M.Next(1, 4).ToString();
var d1 = new Student()
{
Name = Xing[X.Next(Xing.Count - 1)] + Ming[M.Next(Ming.Length - 1)] + Ming[M.Next(Ming.Length - 1)],
Address = "柳北",
Sex = false,
Birthday = DateTime.Parse("2000-01-06"),
Phone = "151" + X.Next(7000000).ToString(),
Department = context.Departments.SingleOrDefault(x => x.SortCode == sotrcode),
StudentCode = "20170" + X.Next(9) + X.Next(9) + X.Next(9) + X.Next(9),
};
context.Students.Add(d1);
Thread.Sleep(1);
}
}
//切换到编辑
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
_getData();
//查询出所有的分类
var context = new DataContext.StuDBContext();
var departments = context.Departments.ToList();
//查询出gridview中分类列编辑状态模板中下拉菜单
var list = (DropDownList)GridView1.Rows[e.NewEditIndex].FindControl("editdepartment");
//下拉数据绑定
list.DataSource = departments;
list.DataTextField = "Name";
list.DataValueField = "ID";
list.DataBind();
//选项绑定
var ID = (Guid)GridView1.DataKeys[e.NewEditIndex].Value;
//查询出当前记录商品记录，获取它的分类
var DTdata = context.Students.Find(ID);
if (DTdata.ID != null)
{
list.SelectedValue = DTdata.Department.ID.ToString();
}
}
//保存修改
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
using (var context = new DataContext.StuDBContext())
{
//查询出要修改这条记录
var p = context.Students.Find(id);
//读出gridview中用户编辑的字段，给每个允许修改的实体属性赋值
//获取用户编辑的这一行
var row = GridView1.Rows[e.RowIndex];
var sn = (row.Cells[0].Controls[0] as TextBox).Text.Trim();
var name = (row.Cells[1].Controls[0] as TextBox).Text.Trim();
var phone = (row.Cells[2].Controls[0] as TextBox).Text.Trim();
var department = Guid.Parse(((DropDownList)row.FindControl("editdepartment")).SelectedValue);
p.StudentCode = sn;
p.Name = name;
p.Phone = phone;
p.Department = context.Departments.Find(department);
context.SaveChanges();
}
GridView1.EditIndex = -1;
_getData();
}
private void _getData()
{
using (var context = new DataContext.StuDBContext())
{
//查询出Students数据
var students = context.Students.OrderBy(x => x.StudentNo).ToList();
GridView1.DataSource = students;
GridView1.DataBind();
}
}
private void _getData()
{
using (var context = new DataContext.StuDBContext())
{
var list = context.Students.OrderBy(x => x.StudentCode).ToList();
GridView1.DataSource = list;
GridView1.DataBind();
}
}
//删除
private void NewMethod(GridViewDeleteEventArgs e)
{
var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
using (var context = new DataContext.StuDBContext())
{
var delstu = context.Students.Find(id);
context.Students.Remove(delstu);
context.SaveChanges();
}
}
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 DataContext.StuDBContext())
{
//删除这条记录
var delstudent = context.Students.Find(id);
context.Students.Remove(delstudent);
context.SaveChanges();
}
_getData();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
var id = Guid.Parse(DropDownList1.SelectedValue);
// 按部门查询id
using (var context = new DataContext.StuDBContext())
{
var list = context.Students.Where(n => n.Department.ID == id)
.Select(n => new
{
StudentNo = n.StudentNo,
FullName = n.FullName,
Department = n.Department.Name,
Sex = n.Sex ? "男" : "女",
Address = n.Address,
Telphone = n.Phone
}).OrderBy(x => x.StudentNo).ToList();
GridView1.DataSource = list;
GridView1.DataBind();
}
}
