private void btnSave_Click(object sender, EventArgs e)
{
using (var db = new XLYJEntities())
{
if (txtCode.Tag != null)
{
int id = int.Parse(txtCode.Tag.ToString());
var stu = db.X_Student.FirstOrDefault(p => p.ID == id);
SetStuInfoEntity(stu);
stu.ModifyPerson = "admin";
stu.ModifyTime = DateTime.Now;
db.SaveChanges();
}
else
{
X_Student stu = new X_Student();
SetStuInfoEntity(stu);
stu.CreatePerson = "admin";
stu.CreateTime = DateTime.Now;
db.X_Student.Add(stu);
db.SaveChanges();
}
this.DialogResult = DialogResult.Yes;
}
}
private void FrmSingleStuInfo_Load(object sender, EventArgs e)
{
if (null != _StuInfo)
{
GetStuInfoEntity(_StuInfo);
}
else
{
using (var db = new XLYJEntities())
{
var stuid = db.X_Student.Count() > 0 ? db.X_Student.Max(p => p.ID) : 0;
if (0 != stuid)
{
var stu = db.X_Student.FirstOrDefault(p => p.ID == stuid);
string code = stu.Code;
int num = int.Parse(code.Substring(3, 3));
num += 1;
string cnum = num > 99 ? num.ToString() : num > 9 ? "0" + num.ToString() : "00" + num.ToString();
txtCode.Text = "XY_" + cnum;
}
else
{
txtCode.Text = "XY_001";
}
}
}
}
public void BindStuInfoes()
{
using (var dataContext = new XLYJEntities())
{
List <X_Student> dataSource = dataContext.X_Student.ToList <X_Student>();
this.gridControl.DataSource = dataSource;
}
}
private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView.RowCount > 0)
{
DialogResult dialogResult = XtraMessageBox.Show("确定删除吗？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
int _id = ((X_Student)this.gridView.GetRow(this.gridView.FocusedRowHandle)).ID;
using (var dataContext = new XLYJEntities())
{
X_Student stu = dataContext.X_Student.SingleOrDefault((X_Student p) => p.ID == _id);
if (null != stu)
{
dataContext.X_Student.Remove(stu);
}
dataContext.SaveChanges();
this.BindStuInfoes();
}
}
}
}
