// @see search "EF模型增删改查"
private void button_delete_Click(object sender, EventArgs e)
{
//lqRecCustTransDataContext
sail_heEntities db = new sail_heEntities();
ustudent delete = new ustudent();
delete.sid = int.Parse(studentS[listBox_main.SelectedIndex].getStuId());
db.Entry(delete).State = System.Data.Entity.EntityState.Deleted;
studentS.RemoveAt(listBox_main.SelectedIndex);
Clear();
studentS.ForEach(ele => WriteLine(ele.tabString()));
db.SaveChanges();
/*
* var q = (from c in db.ustudent
* where c.sid == tb_UserInf.CreateUser && c.AutoId == iAid
* select c).First();
* db.ustudent.DeleteOnSubmit(q);
* db.ustudent.delete
*
* var q2 = db.ustudent.First(c => c.AutoId == iAid && c.CreateUser == tb_UserInf.CreateUser);
* db.ustudent.DeleteOnSubmit(q2);
*
* @see https://docs.microsoft.com/zh-cn/dotnet/framework/data/adonet/sql/linq/how-to-delete-rows-from-the-database
* // Query the database for the rows to be deleted.
* var deleteOrderDetails =
* from details in db.ustudent
* where details.sid == 11000
* select details;
*
* foreach (var detail in deleteOrderDetails)
* {
* db.ustudent.DeleteOnSubmit(detail);
* }
*
* try
* {
* db.SubmitChanges();
* }
* catch (Exception e)
* {
* Console.WriteLine(e);
* // Provide for exceptions.
* }*/
}
public StringMapInt calcAllClass(out intMapString gidMapGname)
{
StringMapInt result = new StringMapInt();
intMapString gidMapGnameBuffer = new intMapString();
using (var context = new sail_heEntities())
{
var ugradeList = context.ugrade.ToList();
ugradeList.ForEach(ele => {
string gname = ele.gname;
gidMapGnameBuffer.Add(ele.gid, ele.gname);
result.Add(gname, ele.gid);
});
}
gidMapGname = gidMapGnameBuffer;
return(result);
}
void saveAll(List <StudentInfo> studentS)
{
studentS.ForEach(ele => {
if (ele.getStuId() == null)
{
using (var context = new sail_heEntities())
{
ustudent temp = new ustudent();
temp.gid = ele.ClassId.ToString();
//temp.sid = int.Parse(ele.getStuId());
temp.sname = ele.getName().ToString();
temp.sbdate = ele.BirthDay.ToString();
temp.ssexy = (ele.Gender == EnumGender.MALE.ToString() ? "男" : "女");
temp.stele = ele.Phone.ToString();
context.ustudent.Add(temp);
context.SaveChanges();
}
}
else
{
using (var context = new sail_heEntities())
{
int sid = int.Parse(ele.getStuId());
var stuBuffer = context.ustudent.Where(e => e.sid == sid).First();
ustudent temp = stuBuffer;
temp.gid = ele.ClassId.ToString();
temp.sid = int.Parse(ele.getStuId());
temp.sname = ele.getName().ToString();
temp.sbdate = ele.BirthDay.ToString();
temp.ssexy = (ele.Gender == EnumGender.MALE.ToString() ? "男" : "女");
temp.stele = ele.Phone.ToString();
//stuBuffer = temp;
context.SaveChanges();
}
}
});
}
public List <StudentInfo> calcAll(intMapString gidMapGname)
{
List <StudentInfo> studentS = new List <StudentInfo>();
StringMapInt result = new StringMapInt();
using (var context = new sail_heEntities())
{
var resultList = context.ustudent.ToList();
resultList.ForEach(ele => {
StudentInfo temp = new StudentInfo(
ele.sname
, (ele.ssexy) == "男" ? EnumGender.MALE : EnumGender.WOMAN
, DateTime.Parse(ele.sbdate)
, gidMapGname[int.Parse(ele.gid)]
, ele.stele
);
temp.setSduId(ele.sid);
temp.ClassId = int.Parse(ele.gid);
studentS.Add(temp);
});
}
return(studentS);
}
