public static void TestAddModule_sorce() { Entry_score temp=new Entry_score() { entry_id=1, student_id="13111089", score=5 }; Entry_scoreBS.AddEntry_score(temp); }
public static void TestAddAndModify() { Entry_score test = new Entry_score() { entry_id = 1, student_id = "13111089", score = 4 }; //Entry_scoreBS.ModifyEntry_score(test); Console.WriteLine(Entry_scoreBS.AddEntry_score(test)); List<Entry_score> list = Evaluation_entryBS.GetEntry_scoreList(1); foreach (var x in list) { Console.WriteLine(x.student_id); } }
/// <summary> /// 添加项目成绩 /// </summary> /// <param name="model">要添加的项目成绩</param> ///<returns>成功返回true</returns> public static bool AddEntry_score(Entry_score model) { try { using (var db = new SEMSDBContext()) { db.Entry_score.Add(model); /*db.Entry_score.Add(new Entry_score() { entry_id=model.entry_id, score=model.score, student_id=model.student_id });*/ db.SaveChanges(); } return true; } catch (Exception e) { //throw e.InnerException; return false; } }
/// <summary> /// 修改项目成绩 /// </summary> /// <param name="model">修改后的model</param> public static bool ModifyEntry_score(string student_id, int entry_id, Entry_score model) { try { using (var db = new SEMSDBContext()) { var temp = db.Entry_score.Find(student_id, entry_id); temp.score = model.score; db.SaveChanges(); } return true; } catch { return false; } }
/// <summary> /// 从excel批量导入特定项目成绩 /// 说明:必须是“Sheet1”,必须有学号、得分列。 /// </summary> /// <param name="entry_id">项目ID</param> /// <param name="fileName">excel文件的绝对路径</param> /// <returns>有效影添加或修改的记录数,为-1表示操作出错</returns> public static int ImportEntry_score(int entry_id, string fileName) { try { int ret = 0; using (var db = new SEMSDBContext()) { //string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=YES;IMEX=1'Data Source=" + fileName + ";"; //HDR=Yes,代表第一行是标题,不做为数据使用 ,如果用HDR=NO,则表示第一行不是标题,做为数据来使用。系统默认的是YES。IMEX=1,表示只读 string strConn = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info=False;Data Source=" + fileName + "; Extended Properties='Excel 12.0;HDR=Yes;IMEX=1'"; using (OleDbConnection conn = new OleDbConnection(strConn)) { try { conn.Open(); string sql = "select * from [Sheet1$]"; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Entry_score score = new Entry_score() { entry_id = entry_id, score = int.Parse(dr["得分"].ToString()),// Convert.ToInt32(dr["得分"].ToString()), student_id = dr["学号"].ToString() }; if (Entry_scoreBS.AddEntry_score(score)) { ret++; } else if (Entry_scoreBS.ModifyEntry_score(score.student_id, score.entry_id, score)) { ret++; } } } catch (Exception e) { throw e; } finally { conn.Close(); } } } return ret; } catch { return -1; } }