new public static MyCourses Courses(int MID, int CID) { var m = new MyCourses(); try { SqlParameter[] param = { new SqlParameter("@MID",MID), new SqlParameter("@CID",CID) }; var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_MyCourses", param); if (dr.Read()) { m.CID = CID; m.MID = MID; m.Name = Convert.ToString(dr["Name"]); m.Year = Convert.ToInt32(dr["Year"]); if (DBNull.Value != dr["Minutes"]) m.Minutes = Convert.ToInt32(dr["Minutes"]); if (DBNull.Value != dr["Second"]) m.Second = Convert.ToDecimal(dr["Second"]); m.Validate = Convert.ToInt32(dr["Validate"]); m.Length = Convert.ToDecimal(dr["Length"]); } dr.Close(); } catch (Exception ex) { log.Fatal("{0},{1}", ex.Message, ex.StackTrace); } return m; }
new public static List<MyCourses> MyCourses(int MID, int Year, int Type) { var l = new List<MyCourses>(); try { SqlParameter[] param = { new SqlParameter("@MID",MID), new SqlParameter("@Year",Year), new SqlParameter("@Type",Type) }; var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_MyCoursesList", param); while (dr.Read()) { var m = new MyCourses(); m.CID = Convert.ToInt32(dr["CID"]); m.Name = Convert.ToString(dr["Name"]); m.Second = Convert.ToInt32(dr["Second"]); m.Minutes = Convert.ToInt32(dr["Minutes"]); m.Status = Convert.ToInt32(dr["Status"]); if (DBNull.Value != dr["Cate"]) m.Cate = Convert.ToInt32(dr["Cate"]); if (DBNull.Value != dr["Sort"]) m.Sort = Convert.ToInt32(dr["Sort"]); if (DBNull.Value != dr["Teacher"]) m.Teacher = Convert.ToString(dr["Teacher"]); if (DBNull.Value != dr["Length"]) m.Length = Convert.ToDecimal(dr["Length"]); if (DBNull.Value != dr["Memo"]) m.Memo = Convert.ToString(dr["Memo"]); if (DBNull.Value != dr["Tag"]) m.Tag = Convert.ToString(dr["Tag"]); l.Add(m); } dr.Close(); } catch (Exception ex) { log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return l; }
public ActionResult Certificatev2(int id) { decimal Total_length = 0; var report = DAL.Get.Report(Client.MID, id); var cert = DAL.Get.Certificate(Client.MID); var CLData = DAL.Get.MyCourses(Client.MID, id, Client.Type); var certConfig = DAL.Get.CertConfig(id); if (cert.ID == 0) { DAL.Update.Certificate(Client.MID); cert = DAL.Get.Certificate(Client.MID); } if (report.Status != 1) { GoMessage("您尚未获得合格证书,请继续学习。"); } //已学 var MyCourses_1 = CLData.FindAll(n => n.Status == 1); var ShowList = new List<MyCourses>(); for (int i = 0; i < MyCourses_1.Count; i++) { Total_length = Total_length + MyCourses_1[i].Length; if (i < 13) { ShowList.Add(MyCourses_1[i]); } } if (MyCourses_1.Count > 14) { var m = new MyCourses(); m.Name = "……"; ShowList.Add(m); } ViewData["MyCourses_1"] = ShowList; ViewData["report"] = report; ViewData["cert"] = cert; ViewData["certConfig"] = certConfig; ViewData["PID"] = id; ViewData["Total_length"] = Total_length; return View(); }